SAP ABAP Table CRMS_FM_ACL_EFSA_BI_EXTR (CRM-FM : ACL-EFSA BI Extractor - Extraction Structure)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-FM-ACL (Application Component) Accruals
     ⤷ CRM_FM_ACL_BI (Package) CRM Funds Management Accruals: BI integration

Basic Data

Table Category	INTTAB	Structure
Structure	CRMS_FM_ACL_EFSA_BI_EXTR	Table Relationship Diagram
Short Description	CRM-FM : ACL-EFSA BI Extractor - Extraction Structure

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	ACCRUED_AMOUNT	☐	CRM_FM_ACL_ACR_AMOUNT	WERTV8	CURR	15	2	Amount to be accrued
3	CURRENCY	☐	CRM_FM_FPO_CURRENCY	WAERS	CUKY	5	0	Currency Key	*
4	CHANGED_BY	☐	XUBNAME	XUBNAME	CHAR	12	0	User Name in User Master Record	*
5	CREATED_BY	☐	XUBNAME	XUBNAME	CHAR	12	0	User Name in User Master Record	*
6	DT_CHANGED_ON	☐	CRM_FM_ACL_CHANGED_ON_BI		DATS	8	0	FM Accrual Staging Area: Changed On (Date)
7	DT_CREATED_ON	☐	CRM_FM_ACL_CREATED_ON_BI		DATS	8	0	FM Accrual Staging Area : Created On (Date)
8	FORECAST_PERIOD	☐	RSFISCPER	RSFISCPER	NUMC	7	0	Fiscal year / period
9	ACCRUAL_PERIOD	☐	RSFISCPER	RSFISCPER	NUMC	7	0	Fiscal year / period
10	FISCAL_YEAR_VAR	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	*
11	FU_HEADER_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
12	FUND_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
13	EXTERNAL_ID	☐	CRM_FM_FU_ITEM_ID		NUMC	4	0	TFM Fund Usage: ITEM External ID
14	ACCOUNT_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
15	SERVICES_ORG	☐	CRMT_SERVICE_ORG	HROBJEC_14	CHAR	14	0	Service Organization
16	SERVICE_ORG_8	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
17	SALES_ORG	☐	CRMT_SALES_ORG	HROBJEC_14	CHAR	14	0	Sales Organization ID
18	SALES_ORG_8	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
19	DIS_CHANNEL	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*
20	DIVISION	☐	CRMT_DIVISION	CRM_DIVISION	CHAR	2	0	Division	*
21	.INCLUDE	☐				0	0	INCLUDE structure for FM Fund attributes
22	PROD_CATEG_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
23	PRODUCT_GROUP1	☐	CHAR3	CHAR3	CHAR	3	0	3-Byte field
24	PRODUCT_GROUP2	☐	CHAR3	CHAR3	CHAR	3	0	3-Byte field
25	PRODUCT_GROUP3	☐	CHAR3	CHAR3	CHAR	3	0	3-Byte field
26	PRODUCT_GROUP4	☐	CHAR3	CHAR3	CHAR	3	0	3-Byte field
27	PRODUCT_GROUP5	☐	CHAR3	CHAR3	CHAR	3	0	3-Byte field
28	PRODUCT_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
29	PARTNER_NO	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
30	BP_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
31	BPH_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
32	TERRITORY_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
33	MKT_ORG	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
34	MPL_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
35	MPL_ID	☐	CRM_MKTPL_EXTERNAL_ID	CGPL_EXTID	CHAR	24	0	External Identification

History

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