SAP ABAP Table CRMS_FM_FU_BI_EXTRACTION (Extraction structure for FM Fund Usages BI Content)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-FM-FU (Application Component) Fund Usages
     ⤷ CRM_FM_FU_BI (Package) CRM Funds Management: Fund Usages BI integration

Basic Data

Table Category	INTTAB	Structure
Structure	CRMS_FM_FU_BI_EXTRACTION	Table Relationship Diagram
Short Description	Extraction structure for FM Fund Usages BI Content

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
2	GUID	☐	CRM_FM_FU_HEADER_GUID	SYSUUID	RAW	16	0	Trade Promotion: Fund Usage Header GUID
3	FU_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
4	REF_OBJKEY	☐	SWO_TYPEID	SWO_TYPEID	CHAR	70	0	Object key
5	REF_OBJTYPE	☐	SWO_OBJTYP	OJ_NAME	CHAR	10	0	Object Type	*
6	REF_LOGSYS	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	*
7	EXPENSE_TYPE	☐	CRM_FM_FU_EXPENSE_TYPE	CRM_FM_FU_EXPENSE_TYPE	CHAR	4	0	Expense Type
8	EXTERNAL_ID	☐	CRM_FM_FU_HEADER_ID	CHAR24	CHAR	24	0	Trade Promotion: Fund Usage ID
9	FUND_ATTR_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
10	FUND_PLAN_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
11	FUND_PLAN_ID	☐	CRM_FM_FND_FUNDPLAN_ID	CRM_OBJECT_ID	CHAR	10	0	Funds Plan ID
12	ACCRUAL_PROFILE	☐	CRM_FM_ACL_PROFILE_ID	CRM_FM_ACL_PROFILE_ID	CHAR	8	0	Accrual Profile ID	*
13	TIME_ZONE	☐	TZNZONE	TZNZONE	CHAR	6	0	Time Zone	*
14	DAT_ACL_START	☐	CRM_FM_FU_ACL_START_DATE_BI		DATS	8	0	FM Funds Usage Accrual Start Date (Date Only, No Time)
15	DAT_ACL_END	☐	CRM_FM_FU_ACL_END_DATE_BI		DATS	8	0	FM Funds Usage Accrual End Date (Date Only, No Time)
16	DAT_CREATED_ON	☐	CRM_FM_FU_CREATED_ON_BI		DATS	8	0	FM Funds Usage Created On (Date Only, No Time)
17	DAT_CHANGED_ON	☐	CRM_FM_FU_CHANGED_ON_BI		DATS	8	0	FM Funds Usage Changed On (Date Only, No Time)
18	CREATED_BY	☐	CRM_FM_FU_USER	USNAM	CHAR	12	0	FM Fund Usage: User Name
19	CHANGED_BY	☐	CRM_FM_FU_USER	USNAM	CHAR	12	0	FM Fund Usage: User Name
20	BWSTFUSSYS0	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
21	SALES_ORG	☐	CRMT_SALES_ORG	HROBJEC_14	CHAR	14	0	Sales Organization ID
22	SALES_ORG_8	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
23	DIS_CHANNEL	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*
24	DIVISION	☐	CRMT_DIVISION	CRM_DIVISION	CHAR	2	0	Division	*
25	SERVICES_ORG	☐	CRMT_SERVICE_ORG	HROBJEC_14	CHAR	14	0	Service Organization
26	SERVICE_ORG_8	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
27	.INCLUDE	☐				0	0	INCLUDE structure for FM Fund attributes
28	PROD_CATEG_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
29	PRODUCT_GROUP1	☐	CHAR3	CHAR3	CHAR	3	0	3-Byte field
30	PRODUCT_GROUP2	☐	CHAR3	CHAR3	CHAR	3	0	3-Byte field
31	PRODUCT_GROUP3	☐	CHAR3	CHAR3	CHAR	3	0	3-Byte field
32	PRODUCT_GROUP4	☐	CHAR3	CHAR3	CHAR	3	0	3-Byte field
33	PRODUCT_GROUP5	☐	CHAR3	CHAR3	CHAR	3	0	3-Byte field
34	PRODUCT_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
35	PARTNER_NO	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
36	BP_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
37	BPH_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
38	TERRITORY_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
39	MKT_ORG	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
40	MPL_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
41	MPL_ID	☐	CRM_MKTPL_EXTERNAL_ID	CGPL_EXTID	CHAR	24	0	External Identification
42	CHARGEBACK_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
43	CHARGEBACK_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
44	CLAIM_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
45	CLAIM_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
46	FUND_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
47	FUND_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
48	INITIATIVE_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
49	INITIATIVE_ID	☐	CGPL_EXTID	CGPL_EXTID	CHAR	24	0	Project Planning: External Indentifier of an Element
50	PREPAYMENT_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
51	PREPAYMENT_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
52	TRADE_PROMO_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
53	TRADE_PROMO_ID	☐	CGPL_EXTID	CGPL_EXTID	CHAR	24	0	Project Planning: External Indentifier of an Element
54	CAMPAIGN_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
55	CAMPAIGN_ID	☐	CGPL_EXTID	CGPL_EXTID	CHAR	24	0	Project Planning: External Indentifier of an Element

History

Last changed by/on	SAP	20130604
SAP Release Created in	520