SAP ABAP Table CRMS_BW_FM_BPO (Extraction structure for FM Fund Budget Postings BI Content)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BTX-ANA-RFW (Application Component) Reporting Framework
     ⤷ CRM_REPORT (Package) Operative Reporting in CRM

Basic Data

Table Category	INTTAB	Structure
Structure	CRMS_BW_FM_BPO	Table Relationship Diagram
Short Description	Extraction structure for FM Fund Budget Postings 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	BPO_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
2	BPO_ID	☐	CRMT_OBJECT_ID_DB	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
3	BPO_DESCRIPTION	☐	CRMT_PROCESS_DESCRIPTION_UC	CRM_PROCESS_DESCRIPTION_UC	CHAR	40	0	Transaction Description (Upper Case)
4	BPO_DESCR_LANGU	☐	CRMT_PROCESS_DESCRIPTION_LANGU	SPRAS	LANG	1	0	Language Key of Description	*
5	BPO_TYPE	☐	CRMT_PROCESS_TYPE_DB	CRM_PROCESS_TYPE	CHAR	4	0	Business Transaction Type	*
6	CURRENCY	☐	CRMT_CURRENCY	WAERS	CUKY	5	0	Currency	*
7	.INCLUDE	☐				0	0	ORDERADM_H Data for BW DataSources
8	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
9	GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
10	OBJECT_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
11	PROCESS_TYPE	☐	CRMT_PROCESS_TYPE	CRM_PROCESS_TYPE	CHAR	4	0	Business Transaction Type	*
12	POSTING_DATE	☐	CRMT_POSTING_DATE		DATS	8	0	Posting Date for a Business Transaction
13	DESCRIPTION_UC	☐	CRMT_PROCESS_DESCRIPTION_UC	CRM_PROCESS_DESCRIPTION_UC	CHAR	40	0	Transaction Description (Upper Case)
14	DESCR_LANGUAGE	☐	CRMT_PROCESS_DESCRIPTION_LANGU	SPRAS	LANG	1	0	Language Key of Description	*
15	LOGICAL_SYSTEM	☐	CRMT_LOGSYS	LOGSYS	CHAR	10	0	Logical System	*
16	OBJECT_TYPE	☐	CRMT_SUBOBJECT_CATEGORY	CRM_OJ_NAME_PROCESS	CHAR	10	0	Business Transaction Category	CRMC_SUBOB_CAT
17	CREATED_AT	☐	CRMT_OPPT_CREATED_AT	DATUM	DATS	8	0	Transaction Was Created at This Time
18	CREATED_BY	☐	CRMT_CREATED_BY	UNAME	CHAR	12	0	User that Created the Transaction
19	CHANGED_AT	☐	CRMT_OPPT_CHANGED_AT	DATUM	DATS	8	0	Time of Last Change to the Transaction
20	CHANGED_BY	☐	CRMT_CHANGED_BY	UNAME	CHAR	12	0	Transaction Last Changed By
21	RECORDMODE	☐	RODMUPDMOD	RODMUPDMOD	CHAR	1	0	BW Delta Process: Record Mode
22	NUM_OF_HEAD	☐	CRMT_NUMBER_OF_H	INT4	INT4	10	0	Order Header Number
23	OCCURRENCE	☐	CRMT_OCC_AT_LEAST_ONCE	CRM_BOOLEAN	CHAR	1	0	Counter: Document Cat. Appears at Least Once in Document
24	SCENARIO	☐	CRMT_SCENARIO	CRM_SCENARIO	CHAR	10	0	Scenario Identity
25	TEMPLATE_TYPE	☐	CRMT_TEMPLATE_TYPE_DB	CRM_TEMPLATE_TYPE	CHAR	1	0	Template Type of CRM Transaction
26	OCCURR_QUOT	☐	CRMT_QUO_AT_LEAST_ONCE	CRM_BOOLEAN	CHAR	1	0	Counter: Document Cat. Appears at Least Once in Document
27	OCCURR_CONT	☐	CRMT_CON_AT_LEAST_ONCE	CRM_BOOLEAN	CHAR	1	0	Counter: Document Cat. Appears at Least Once in Document
28	REF_UPDATE	☐	CRMT_FLG_REF_UPDATE_BW	XFELD	CHAR	1	0	Flag: Ref. Update (Extract Structure Only Partially Filled)
29	INPUT_CHANNEL	☐	CRMT_INPUT_CHANNEL	CRM_INPUT_CHANNEL	CHAR	3	0	Input channel
30	CREATED_TS	☐	COMT_CREATED_AT_USR	COM_TSTMP	DEC	15	0	Created At (Output in User Time Zone)
31	CHANGED_TS	☐	COMT_CHANGED_AT_USR	COM_TSTMP	DEC	15	0	Changed At (Output in User Time Zone)
32	.INCLUDE	☐				0	0	ORGMAN Data for BW DataSources
33	SALES_ORG_RESP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
34	SALES_ORG	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
35	SALES_OFFICE	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
36	SALES_GROUP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
37	DIS_CHANNEL	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*
38	DIVISION	☐	CRMT_DIVISION	CRM_DIVISION	CHAR	2	0	Division	*
39	SERVICE_ORG_RESP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
40	SERVICE_ORG	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
41	PURCH_ORG_RESP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
42	PURCH_ORG	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
43	PURCH_GROUP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
44	IC_BD_CCODE	☐	CRM_IC_BD_CCODE	BUKRS	CHAR	4	0	Company Code for a Business Transaction	*
45	IC_BD_LOGSYS	☐	CRM_IC_BD_LOGSYS	LOGSYS	CHAR	10	0	Logical System for a Business Transaction	*
46	.INCLUDE	☐				0	0	PARTNER (General) Data for BW DataSoures
47	SALES_EMPLOYEE	☐	CRMT_SALES_EMPLOYEE	BU_PARTNER	CHAR	10	0	Employee	*
48	PERSON_RESP	☐	CRMT_PERSON_RESP	BU_PARTNER	CHAR	10	0	Employee Responsible	*
49	CONTACT_PERSON	☐	CRMT_CONTACT_PERSON	BU_PARTNER	CHAR	10	0	Customer Contact Person	*
50	SALESPARTNER	☐	CRMT_SALESPARTNER	BU_PARTNER	CHAR	10	0	Sales Partners	*
51	RESP_GROUP_RFW	☐	CRMT_RESPONSIBLE_GROUP	BU_PARTNER	CHAR	10	0	Responsible Group	*
52	PLANNING_ACCOUNT	☐	CRMT_PLANNING_ACCOUNT	BU_PARTNER	CHAR	10	0	Planning Account	*
53	.INCLUDE	☐				0	0	ORDERADM_I Data for BW DataSources
54	ITEM_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
55	ITEM_CREATED_AT	☐	CRMT_OPPT_CREATED_AT	DATUM	DATS	8	0	Transaction Was Created at This Time
56	ITEM_CREATED_BY	☐	CRMT_CREATED_BY	UNAME	CHAR	12	0	User that Created the Transaction
57	ITEM_CHANGED_AT	☐	CRMT_OPPT_CHANGED_AT	DATUM	DATS	8	0	Time of Last Change to the Transaction
58	ITEM_CHANGED_BY	☐	CRMT_CHANGED_BY	UNAME	CHAR	12	0	Transaction Last Changed By
59	ORDER_DATE	☐	CRMT_OPPT_ORDER_DATE	DATUM	DATS	8	0	Posting Date
60	NUMBER_INT	☐	CRMT_ITEM_NO	CRM_ITEM_NO	NUMC	10	0	Item Number in Document
61	ITEM_OBJECT_TYPE	☐	CRMT_SWO_OBJTYP_PROCESS_ITEM	CRM_OJ_NAME_PROCESS_ITEM	CHAR	10	0	CRM Item Object Type	*
62	ITM_TYPE	☐	CRMT_ITEM_TYPE	CRM_ITEM_TYPE	CHAR	4	0	Item Category	*
63	NUMBER_OF_I	☐	CRMT_NUMBER_OF_I	INT4	INT4	10	0	Order Item Number
64	BW_ASSIGN	☐	CRMT_BW_ASSIGN	CRMT_BW_ASSIGN	CHAR	1	0	Assign BW and CO
65	ITM_USAGE	☐	CRMT_ITEM_USAGE	CRM_ITEM_USAGE	CHAR	2	0	Usage of Higher-Level Item
66	ITM_TYPE_USAGE	☐	CRMT_IT_TYPE_USAGE	CRM_IT_TYPE_USAGE	CHAR	4	0	Item Category Usage	*
67	ALTERNATIVE	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
68	PARENT	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
69	ITM_BP	☐	CRM_ISU_PARTNER_NO	CRM_ISU_PARTNER_NO	CHAR	10	0	Partner Number
70	ITEM_CREATED_TS	☐	COMT_CREATED_AT_USR	COM_TSTMP	DEC	15	0	Created At (Output in User Time Zone)
71	ITEM_CHANGED_TS	☐	COMT_CHANGED_AT_USR	COM_TSTMP	DEC	15	0	Changed At (Output in User Time Zone)
72	ORDER_DATE_TS	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
73	FND_SRC_ID	☐	FMBPO_FND_SRC_ID	FMBPO_FND_SRC_ID	CHAR	10	0	Fund Source ID
74	FND_SRC_DESCR	☐	CRMT_PRSHTEXTG_DB	CRM_PRSHTEXTG40_DB	CHAR	40	0	Product Short Text in Upper Case for F4 Help
75	FND_SRC_GUID	☐	FMBPO_FND_SRC_GUID	FMBPO_FND_SRC_GUID	CHAR	32	0	Fund Source GUID
76	FND_TGT_ID	☐	FMBPO_FND_TGT_ID	FMBPO_FND_TGT_ID	CHAR	10	0	Fund Target ID
77	FND_TGT_GUID	☐	FMBPO_FND_TGT_GUID	FMBPO_FND_TGT_GUID	CHAR	32	0	Fund Target GUID
78	FNP_SRC_ID	☐	FMBPO_FNP_SRC_ID	FMBPO_FNP_SRC_ID	CHAR	10	0	Fund Plan Source ID
79	FNP_SRC_GUID	☐	FMBPO_FNP_SRC_GUID	FMBPO_FNP_SRC_GUID	CHAR	32	0	Fund Plan Source GUID
80	FNP_TGT_ID	☐	FMBPO_FNP_TGT_ID	FMBPO_FNP_TGT_ID	CHAR	10	0	Fund Plan Target ID
81	FNP_TGT_GUID	☐	FMBPO_FNP_TGT_GUID	FMBPO_FNP_TGT_GUID	CHAR	32	0	Fund Plan Target GUID
82	EXP_DATE	☐	FMBPO_EXP_DATE	FMBPO_EXP_DATE	DATS	8	0	Budget Expiration Date
83	EXP_PERIOD	☐	FMBPO_EXP_PERIOD	FMBPO_EXP_PERIOD	CHAR	10	0	Budget Expiration Period
84	POSTED_AMOUNT	☐	FMBPO_POSTED_AMOUNT	WERTV8	CURR	15	2	Posted Amount
85	BWSTBPOSYS0	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
86	REV_INDICATOR	☐	FMBPO_REV_INDICATOR	FMBPO_REV_INDICATOR	CHAR	1	0	FM Budget Posting Reverse Transfer Indicator
87	POSTING_PERIOD	☐	POPER	POPER	NUMC	3	0	Posting period
88	FISCVAR	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	*
89	BPO_TRAN_TYPE	☐			CHAR	8	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMS_BW_FM_BPO	OBJECT_TYPE	CRMC_SUBOB_CAT	SUBOBJ_CATEGORY

History

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