SAP ABAP Table BBPS_BI_TD_CF (Extraction Structure: Movement Data SAP SRM Confirmation)

Hierarchy

☛ SRM_SERVER (Software Component) SRM_SERVER
   ⤷ SRM-BW (Application Component) SRM Analytics
     ⤷ BBP_BI (Package) Business Intelligence

Basic Data

Table Category	INTTAB	Structure
Structure	BBPS_BI_TD_CF	Table Relationship Diagram
Short Description	Extraction Structure: Movement Data SAP SRM Confirmation

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	GUID	☐	BBP_BI_DOC_GUID	SYSUUID_C	CHAR	32	0	GUID of Document
2	OBJECT_ID	☐	BBP_BI_DOC_NUMBER	CRM_OBJECT_ID	CHAR	10	0	Document Number
3	PROCESS_TYPE	☐	BBP_BI_PROCESS_TYPE	CRM_PROCESS_TYPE	CHAR	4	0	Business Transaction Type	*
4	POSTING_DATE	☐	BBP_BI_POST_DATE	DATE	DATS	8	0	Posting Date
5	DESCRIPTION	☐	BBP_BI_DOC_DESCR	CRM_PROCESS_DESCRIPTION	CHAR	40	0	Description of Document
6	CREATED_AT	☐	BBP_BI_CREAT_DATE		DATS	8	0	Creation Date of Document
7	CHANGED_AT	☐	BBP_BI_CHANG_DATE		DATS	8	0	Change Date of Document
8	CREATED_BY	☐	BBP_BI_CREAT_BY	UNAME	CHAR	12	0	User That Created the Document
9	CHANGED_BY	☐	BBP_BI_CHANG_BY	UNAME	CHAR	12	0	User That Changed the Document
10	ORDERER_ID	☐	BBP_BI_ORDERER_ID	BU_PARTNER	CHAR	10	0	Orderer ID	*
11	VENDOR_ID	☐	BBP_BI_VENDOR_ID	BU_PARTNER	CHAR	10	0	Supplier ID	*
12	VEN_DOC_NO	☐	BBP_BI_VENDOR_DOC	XBLNR	CHAR	16	0	Supplier Document Number
13	CO_CODE	☐	BBP_CO_CODE	BUKRS	CHAR	4	0	Company Code in FI System	*
14	BBP_LOG_SYSTEM	☐	BBP_BI_LOG_SYS	LOGSYS	CHAR	10	0	Logical System for SRM	*
15	BE_LOG_SYSTEM	☐	BE_LOG_SYSTEM	LOGSYS	CHAR	10	0	Logical System of Logistics Backend	*
16	LOGSYS_FI	☐	BBP_LOGSYS_FI	LOGSYS	CHAR	10	0	Logical System of FI System	*
17	CURRENCY	☐	BBP_BI_DOC_CURRENCY	WAERS	CUKY	5	0	Currency of Document	*
18	REASON_CODE	☐	BBP_PD_REASON	CHAR4	CHAR	4	0	Reason for Rejection
19	INP_TYPE	☐	BBP_INP_TYPE	BBP_INP_TYPE	CHAR	1	0	Creation Indictaor (Dialog, XML and so on)
20	SUBTYPE	☐	BBP_H_SUBTYPE	BBP_H_SUBTYPE	CHAR	2	0	Specification of a Purchasing Doc.(e.g. Credit Memo/Invoice)
21	IS_BBP	☐	BBP_BI_IS_BBP		CHAR	1	0	Document Originates in SAP SRM System
22	DOC_COUNT	☐	BBP_BI_DOC_COUNT		DEC	5	4	Counter for Number of Documents
23	STAT_PROCESS	☐	BBP_BI_PROC_STAT	J_STATUS	CHAR	5	0	Processing Status
24	STAT_RELEASE	☐	BBP_BI_REL_STAT	J_STATUS	CHAR	5	0	Release Status
25	STAT_TRANSFER	☐	BBP_BI_TRAN_STAT	J_STATUS	CHAR	5	0	Transfer Status
26	ITM_GUID	☐	BBP_BI_ITEM_GUID	SYSUUID_C	CHAR	32	0	GUID of Item
27	ITM_CREATED_AT	☐	BBP_BI_ITEM_CREAT_DATE		DATS	8	0	Creation Date of Item
28	ITM_CHANGED_AT	☐	BBP_BI_ITEM_CHANG_DATE		DATS	8	0	Change Date of Item
29	ITM_CREATED_BY	☐	BBP_BI_ITEM_CREAT_BY	UNAME	CHAR	12	0	User That Created the Item
30	ITM_CHANGED_BY	☐	BBP_BI_ITEM_CHANG_BY	UNAME	CHAR	12	0	User That Changed the Item
31	ITM_PRODUCT_GUID	☐	BBP_BI_PROD_GUID	SYSUUID_C	CHAR	32	0	Product GUID
32	ITM_PRODUCT_ID	☐	BBP_BI_PROD_ID	CRM_ORDERED_PROD	CHAR	54	0	Product ID
33	ITM_DESCRIPTION	☐	COMT_PRSHTEXTX	PRSHTEXT40	CHAR	40	0	Product Description
34	ITM_NUMBER	☐	BBP_BI_ITEM_NO	CRM_ITEM_NO	NUMC	10	0	Item Number
35	ITM_TYPE	☐	BBP_BI_ITEM_TYPE	CRM_ITEM_TYPE	CHAR	4	0	Item Category	*
36	ITM_CAT_GUID	☐	BBP_CATEGORY_GUID_RAW	SYSUUID	RAW	16	0	Product Category GUID
37	ITM_CATEGORY_ID	☐	BBP_CATEGORY_ID	COM_CATEGORY_ID	CHAR	20	0	Product Category ID
38	ITM_SCHEMA_TYPE	☐	SCHEMA_TYPE	COM_SCHEMA_TYPE	CHAR	10	0	Standard Schema Type	*
39	ITM_EXT_CAT_ID	☐	BBP_ITM_EX_CT_UN_ID	CHAR40	CHAR	40	0	Unique Key in External Category
40	ITM_EXT_CAT_NAME	☐	BBP_CT_CATEGORY_ID	CHAR60	CHAR	60	0	Category Name
41	ITM_MANU_PROD_EX	☐	EMNFR	CHAR10	CHAR	10	0	External manufacturer code name or number
42	ITM_MANU_PROD_IN	☐	BBP_MFRPN	CHAR40	CHAR	40	0	Manufacturer Part Number
43	ITM_CATALOGID	☐	CATALOG	BBP_WS_SERVICE_ID	CHAR	20	0	Catalog ID from which the line was selected
44	ITM_PRODUCT_TYPE	☐	BBP_PRODUCT_TYPE	COM_PRODUCT_TYPE	CHAR	2	0	Product Type	*
45	ITM_PROD_SRC_SYS	☐	BBP_BI_PRODUCT_SRC_SYS	LOGSYS	CHAR	10	0	Original Logical System of Product	*
46	ITM_SYS_TYPE	☐	BBP_SYSTEM_TYPE	BBP_SYSTEM_TYPE	CHAR	10	0	System type
47	ITM_SLD_SYS_NAME	☐	BBP_SLD_SYS_NAME	TEXT60	CHAR	60	0	Name of a System im System Landscape Directory (SLD)
48	ITM_DELIV_DATE	☐	EINDT	DATUM	DATS	8	0	Item delivery date
49	ITM_QUANTITY	☐	BBP_MNG	MENG13	QUAN	13	3	Quantity in Order Unit
50	ITM_QUANTITY_BUM	☐	BBP_BI_QUANTITY_BASE_UNIT	MENG13	QUAN	13	3	Quantity in Base Unit of Measurement
51	ITM_UNIT	☐	BBP_UNIT	MEINS	UNIT	3	0	Purchase Order Unit	*
52	ITM_BASE_UNIT	☐	BBP_BI_BASE_UNIT	MEINS	UNIT	3	0	Base Unit	*
53	ITM_PRICE	☐	BBP_PRICE	WERT7	CURR	13	2	Net Price
54	ITM_PRICE_UNIT	☐	EPEIN	DEC5	DEC	5	0	Price unit
55	ITM_VALUE	☐	BBP_VALUE	WERT8	CURR	15	2	Net Value
56	ITM_REQUEST_ID	☐	BBP_BI_REQUESTER_ID	BU_PARTNER	CHAR	10	0	Requester ID	*
57	ITM_RECIPNT_ID	☐	BBP_BI_RECIPIENT_ID	BU_PARTNER	CHAR	10	0	Recipient ID	*
58	ITM_LOC_ID	☐	BBP_BI_LOCATION_ID	BU_PARTNER	CHAR	10	0	Location ID	*
59	ITM_WORKER_ID	☐	BBP_BI_SRV_PROVIDER_ID	BU_PARTNER	CHAR	10	0	Service Provider ID	*
60	ITM_WRKR_SRC_SYS	☐	COMT_PARTNER_SRC_SYS	LOGSYS	CHAR	10	0	Logical System from Which Partner Originates	*
61	ITM_WORKER_NAME	☐	BBP_BI_SRV_PROVIDER_FULLNAME	TEXT80	CHAR	80	0	Service Provider's Full Name
62	ITM_WRK_NO_TYPE	☐	BBP_BI_SRV_PROVIDER_NO_TYPE	COMT_PARTNER_NO_TYPE	CHAR	2	0	Internal Service Provider Type (for example, GUID, pers.no.)
63	ITM_CUSTOMER_ID	☐	BBP_BI_CUSTOMER_ID	BU_PARTNER	CHAR	10	0	Customer ID	*
64	ITM_CUST_SRC_SYS	☐	COMT_PARTNER_SRC_SYS	LOGSYS	CHAR	10	0	Logical System from Which Partner Originates	*
65	ITM_CUST_NAME	☐	BBP_BI_CUSTOMER_FULLNAME	CHAR35	CHAR	35	0	Customer's Full Name
66	ITM_CUST_NO_TYPE	☐	BBP_BI_CUSTOMER_NO_TYPE	COMT_PARTNER_NO_TYPE	CHAR	2	0	Internal Customer No.Type (for example, GUID, pers. no.)
67	ITM_TAX_CODE	☐	BBP_MWSKZ	BBP_MWSKZ	CHAR	2	0	Tax Code
68	ITM_TAX_AMOUNT	☐	BBP_TAX_AMOUNT	WERT8	CURR	15	2	Tax Amount
69	ITM_PO_NUMBER	☐	BBP_BI_REF_PO_NO	CRM_OBJECT_ID	CHAR	10	0	Referenced Purchase Order Number
70	ITM_PO_ITEM_NO	☐	BBP_BI_REF_PO_ITEM_NO	CRM_ITEM_NO	NUMC	10	0	Referenced Item Number of Purchase Order
71	ITM_CTR_NUMBER	☐	BBP_BI_REF_CTR_NO	CRM_OBJECT_ID	CHAR	10	0	Referenced Contract Number
72	ITM_CTR_ITM_NO	☐	BBP_BI_REF_CTR_ITEM_NO	CRM_ITEM_NO	NUMC	10	0	Referenced Item Number of Contract
73	ITM_DEL_IND	☐	BBP_DEL_IND	XFELD	CHAR	1	0	Deletion Indicator EBP Purchasing Document
74	ITM_FIN_ENTRY_CF	☐	BBP_BI_FINAL_ENTRY_CF	XFELD	CHAR	1	0	Final Entry Indicator (Goods/Services) in CF
75	ITM_COUNT	☐	BBP_BI_ITEM_COUNT		DEC	5	4	Counter for Number of Items
76	ACC_NO	☐	BBP_ACC_NO	BBP_ACCNO	NUMC	4	0	Sequential Account Assignment No. in EBP Purchase Document
77	ACC_CAT	☐	BBP_ACC_CAT	BBP_ACCCAT	CHAR	5	0	Account Assignment Category in Enterprise Buyer
78	ACC_DISTR_PERC	☐	BBP_VPROZ	BBP_VPROZ	DEC	5	2	Distribution Percentage in the Case of Multiple Acct Assgt
79	ACC_G_L_ACCT	☐	SAKNR	SAKNR	CHAR	10	0	G/L Account Number	*
80	ACC_BUS_AREA	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
81	ACC_CO_AREA	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	*
82	ACC_COST_CTR	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
83	ACC_ASSET_NO	☐	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	*
84	ACC_SUB_NUMBER	☐	ANLN2	ANLN2	CHAR	4	0	Asset Subnumber	*
85	ACC_ORDER_NO	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
86	ACC_PROFIT_CTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center
87	ACC_WBS_ELEMENT	☐	WBS_ELEM	PS_POSID	CHAR	24	0	Work breakdown structure element (WBS element)
88	ACC_NETWORK	☐	NPLNR	AUFNR	CHAR	12	0	Network Number for Account Assignment	*
89	ACC_ACTIVITY	☐	VORNR	VORNR	CHAR	4	0	Operation/Activity Number
90	ACC_STR	☐	BBP_ACC_GENERIC	CHAR64	CHAR	64	0	Generic Account Assignment
91	CMMT_ITEM	☐	FIPOS	FIPOS	CHAR	14	0	Commitment Item	*
92	GRANT_NBR	☐	GM_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	Grant
93	FUNDS_CTR	☐	FISTL	FISTL	CHAR	16	0	Funds Center	*
94	FUND	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	*
95	FUNC_AREA	☐	FKBER_SHORT	FKBER_SHORT	CHAR	4	0	Functional Area
96	SD_DOC	☐	BBP_VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number
97	SDOC_ITEM	☐	BBP_POSNR_VA	POSNR	NUMC	6	0	Sales Document Item
98	SCL_NO	☐	BBP_ETENR	ETENR	NUMC	4	0	Schedule Line Number	*
99	ORG_RESP_ORG	☐	BBP_PROG_ORG_RESP	HROBJEC_14	CHAR	14	0	Responsible Organizational Unit (purchasing)
100	ORG_PURCH_ORG	☐	BBP_PROC_ORG	HROBJEC_14	CHAR	14	0	Responsible Purchasing Organization
101	ORG_PURCH_GROUP	☐	BBP_PROC_GROUP	HROBJEC_14	CHAR	14	0	Responsible Purchasing Group
102	UPDMOD	☐	RODMUPDMOD	RODMUPDMOD	CHAR	1	0	BW Delta Process: Record Mode
103	.INCLUDE	☐				0	0	FM Fields Earmarked Funds
104	FUNDS_RES	☐	BBP_KBLNR	KBLNR	CHAR	10	0	Document number for earmarked funds	*
105	RES_ITEM	☐	KBLPOS	KBLPOS	NUMC	3	0	Earmarked Funds: Document Item	*
106	ITM_REV_LEV	☐	CC_REVLV	CC_REVLV	CHAR	2	0	Revision Level
107	BUDGET_PERIOD	☐	FM_BUDGET_PERIOD	FM_BUDGET_PERIOD	CHAR	10	0	FM: Budget Period	*

History

Last changed by/on	SAP	20130528
SAP Release Created in	500