SAP ABAP Table BBPS_BI_TD_IV (Extraction Structure: Movement Data SAP Supplier Invoice)

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_IV	Table Relationship Diagram
Short Description	Extraction Structure: Movement Data SAP Supplier Invoice

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