back to all posts

tables

Change Request Tables

Published in crm, tables by max.favilli on 20/01/2015 11:56:41

In case you need to find the tables storing the Change Request (store of data handled in SE10/SE03/STMS) check tables: E070 and E071

read more

How to link two different object (e.g. CRM TRANSACTIONS in document flow)

Published in crm, tables by max.favilli on 25/10/2006 17:49:00

include CRM_BIN_RELATION_CON. data: it_item_links TYPE crmt_brelvonai_tab. DATA:ls_new_binrel TYPE gbinrel,ls_obj_predecessor TYPE borident,ls_obj_successor TYPE borident,lt_links TYPE STANDARD TABLE OF relgraphlk WITH HEADER LINE. * fill role A (BUS2000116)ls_obj_predecessor-objkey = ‘453C94F14F0800A902000000A0DC2704’.ls_obj_predecessor-objtype = ‘BUS2000116’.ls_obj_predecessor-logsys = ”. * fill role B (BUS2000126)ls_obj_successor-objkey = ‘453C961B4F0800A902000000A0DC2704’.ls_obj_successor-objtype = ‘BUS2000126’.ls_obj_successor-logsys = ”. * Read header-relationsCALL FUNCTION ‘SREL_GET_NEXT_RELATIONS’ EXPORTING  object = ls_obj_predecessor  relationtype = gc_bin_rel_type-predecessor_successor TABLES  links = lt_links EXCEPTIONS  OTHERS = … Continue reading How to link two different object (e.g. CRM TRANSACTIONS in document flow)

read more about this

Where the hell activity reason is stored?

Published in crm, tables by max.favilli on 09/10/2006 09:58:00

Of course you have the guid of the activity (crmd_activity_h) right?Great, now through CRMD_LINK and CRMD_SRV_OSSET reach table CRMD_SRV_SUBJECT, yes here it is.And if you want to read the text, just read table QPCT too.

read more about this

Bupa vs Username fight!

Published in crm, tables by max.favilli on 25/08/2006 10:01:00

Want to retrieve the businesspartner related to an username? Just jump to transaction se37 and use this nice function module: CRM_CMG_GET_USER_FOR_BUPA Want to do it viceversa? No problem: BUP_PARTNER_TO_USER_CONVERT Have fun!

read more about this