SAP ABAP Table CRMS_FM_ACL_ASA_BI_EXTR_DB (Direct extraction from the ASA database)

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_ASA_BI_EXTR_DB	Table Relationship Diagram
Short Description	Direct extraction from the ASA database

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	ACR_PERIOD	☐	RSFISCPER	RSFISCPER	NUMC	7	0	Fiscal year / period
3	PERIOD_VARIANT	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	*
4	CURRENCY	☐	CRM_FM_FPO_CURRENCY	WAERS	CUKY	5	0	Currency Key	*
5	ACCRUED_AMOUNT	☐	CRM_FM_ACL_ACR_AMOUNT	WERTV8	CURR	15	2	Amount to be accrued
6	FU_ITEM_GUID	☐	CRM_FM_FU_ITEM_GUID	SYSUUID	RAW	16	0	TFM Fund Usage: Fund Usage Item Guid
7	CREATED_ON	☐	CRM_FM_ACL_DATE	BCOS_TSTMP	DEC	15	0	Funds Management Accruals Timestamp
8	CREATED_BY	☐	XUBNAME	XUBNAME	CHAR	12	0	User Name in User Master Record	*
9	CHANGED_ON	☐	CRM_FM_ACL_DATE	BCOS_TSTMP	DEC	15	0	Funds Management Accruals Timestamp
10	CHANGED_BY	☐	XUBNAME	XUBNAME	CHAR	12	0	User Name in User Master Record	*
11	FU_HEADER_GUID	☐	CRM_FM_FU_HEADER_GUID	SYSUUID	RAW	16	0	Trade Promotion: Fund Usage Header GUID
12	FUND_GUID	☐	CRM_FM_FND_FUND_GUID	SYSUUID	RAW	16	0	GUID of Fund Business Object
13	ACCOUNT_GUID	☐	CRM_FM_FND_FUND_ATTR_GUID	SYSUUID	RAW	16	0	Fund Attributes GUID
14	EXTERNAL_ID	☐	CRM_FM_FU_ITEM_ID		NUMC	4	0	TFM Fund Usage: ITEM External ID
15	SALES_ORG	☐	CRMT_SALES_ORG	HROBJEC_14	CHAR	14	0	Sales Organization ID
16	DIVISION	☐	CRMT_DIVISION	CRM_DIVISION	CHAR	2	0	Division	*
17	DIS_CHANNEL	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*
18	SERVICES_ORG	☐	CRMT_SERVICE_ORG	HROBJEC_14	CHAR	14	0	Service Organization

History

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