SAP ABAP Table CRMS_FM_FPO_BI_EXTRACTION (CRM-FM FPO BI Extractor - Extraction Structure)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-FM-FPO (Application Component) Fund Posting
     ⤷ CRM_FM_FPO_BI (Package) CRM Funds Management: Funds Posting BI integration

Basic Data

Table Category	INTTAB	Structure
Structure	CRMS_FM_FPO_BI_EXTRACTION	Table Relationship Diagram
Short Description	CRM-FM FPO 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	GUID	☐	CRM_FM_FPO_GUID	SYSUUID	RAW	16	0	Fund Posting Key
3	DOCUMENT_NUMBER	☐	CRM_FM_FPO_ID	CRM_OBJECT_ID	CHAR	10	0	Fund Posting Identifier
4	POSTING_TRANS	☐	CRM_FM_FPO_POSTING_TYPE	CRM_FM_FPO_POSTING_TYPE	CHAR	5	0	Fund Posting - Posting Type
5	DT_POSTING_DATE	☐	CRM_FM_FPO_POSTING_DATE_BI		DATS	8	0	FM Funds Post Posting Date (Date Only, No Time)
6	POSTING_PERIOD	☐	POPER	POPER	NUMC	3	0	Posting period
7	LOCAL_TIMEZONE	☐	CRM_FM_FPO_TIMEZONE	TZNZONE	CHAR	6	0	Fund Posting - Time Zone	*
8	DT_CREATED_ON	☐	CRM_FM_FPO_CREATED_ON_BI		DATS	8	0	FM Funds Posting Created On (Date Only, No Time)
9	CREATED_BY	☐	CRM_FM_FPO_CREATED_BY	UNAME	CHAR	12	0	Fund Posting - User Creator
10	REF_OBJKEY	☐	SWO_TYPEID	SWO_TYPEID	CHAR	70	0	Object key
11	REF_OBJTYPE	☐	SWO_OBJTYP	OJ_NAME	CHAR	10	0	Object Type	*
12	REF_LOGSYS	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	*
13	ITEM_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
14	ITEM_NUMBER	☐	CRM_FM_FPO_ITEM_ID	CRM_OBJECT_ID	CHAR	10	0	Fund Posting Item Identifier
15	HEADER_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
16	FUND_PLAN_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
17	FUND_PLAN_ID	☐	CRM_FM_FND_FUNDPLAN_ID	CRM_OBJECT_ID	CHAR	10	0	Funds Plan ID
18	FUND_ID	☐	CRM_FM_FND_FUND_ID	CRM_OBJECT_ID	CHAR	10	0	Fund ID
19	FUND_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
20	FUND_EXP_DATE	☐	CRM_FM_FPO_EXPIRATION_DATE	DATS	DATS	8	0	Fund Expiration Date
21	FU_ID	☐	CRM_FM_FU_HEADER_ID	CHAR24	CHAR	24	0	Trade Promotion: Fund Usage ID
22	FU_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
23	FU_ITEM_ID	☐	CRM_FM_FU_ITEM_ID		NUMC	4	0	TFM Fund Usage: ITEM External ID
24	FU_ITEM_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
25	VALUE_CATEGORY	☐	CRM_FM_FPO_VALUE_CAT	CRM_FM_FPO_VALUE_CAT	CHAR	5	0	Value Category
26	TRANS_AMOUNT	☐	CRM_FM_FPO_VALUE	WERTV8	CURR	15	2	Fund Posting Amount
27	TRANS_CURRENCY	☐	CRM_FM_FPO_CURRENCY	WAERS	CUKY	5	0	Currency Key	*
28	FM_AMOUNT	☐	CRM_FM_FPO_VALUE	WERTV8	CURR	15	2	Fund Posting Amount
29	FM_CURRENCY	☐	CRM_FM_FPO_CURRENCY	WAERS	CUKY	5	0	Currency Key	*
30	PROD_CATEG_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
31	PROD_GROUP_ID	☐	CRMT_PRC_GROUP1	CRM_PRC_GROUP1	CHAR	3	0	Product Group 1	*
32	PRODUCT_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
33	BP_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
34	BPH_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
35	TERRITORY_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
36	BP_ID	☐	CRM_FM_FPO_BP_ID	BU_PARTNER	CHAR	10	0	CRM FM Funds Management - Business Partner ID	*
37	BPH_ID	☐	CRM_FM_FPO_BPHN_ID		CHAR	20	0	CRM FM Funds Management - BPHN ID
38	MKT_ORG	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
39	MPL_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
40	MPL_ID	☐	CRM_FM_FPO_MPL_ID	CGPL_EXTID	CHAR	24	0	CRM FM: Fund Posting Marketing Plan ID
41	FISCAL_YEAR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
42	SERVICES_ORG	☐	CRMT_SERVICE_ORG	HROBJEC_14	CHAR	14	0	Service Organization
43	SERVICE_ORG_8	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
44	SALES_ORG	☐	CRMT_SALES_ORG	HROBJEC_14	CHAR	14	0	Sales Organization ID
45	SALES_ORG_8	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
46	DIS_CHANNEL	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*
47	DIVISION	☐	CRMT_DIVISION	CRM_DIVISION	CHAR	2	0	Division	*
48	CHARGEBACK_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
49	CHARGEBACK_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
50	CLAIM_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
51	CLAIM_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
52	PREPAYMENT_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
53	PREPAYMENT_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
54	RESERVATION_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
55	RESERVATION_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
56	SETTLEMENT_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
57	SETTLEMENT_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
58	TRADE_PROMO_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
59	TRADE_PROMO_ID	☐	CGPL_EXTID	CGPL_EXTID	CHAR	24	0	Project Planning: External Indentifier of an Element
60	REF_FUND_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
61	REF_FUND_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
62	BPOSTING_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
63	BPOSTING_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
64	COUNTER	☐			NUMC	1	0
65	FISCVAR	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	*
66	POSTING_PERIOD_7	☐	CRM_FM_FPO_POSTING_PERIOD_YR	CRM_FM_FISCPER	NUMC	7	0	Posting Period with Fiscal Year

History

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