SAP ABAP Table BBPS_BI_TD_PO_ACC (Extr.Struc:Transactional Data Purchase Order with Accounting)

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_PO_ACC	Table Relationship Diagram
Short Description	Extr.Struc:Transactional Data Purchase Order with Accounting

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	CO_CODE	☐	BBP_CO_CODE	BUKRS	CHAR	4	0	Company Code in FI System	*
13	BBP_LOG_SYSTEM	☐	BBP_BI_LOG_SYS	LOGSYS	CHAR	10	0	Logical System for SRM	*
14	BE_LOG_SYSTEM	☐	BE_LOG_SYSTEM	LOGSYS	CHAR	10	0	Logical System of Logistics Backend	*
15	LOGSYS_FI	☐	BBP_LOGSYS_FI	LOGSYS	CHAR	10	0	Logical System of FI System	*
16	CURRENCY	☐	BBP_BI_DOC_CURRENCY	WAERS	CUKY	5	0	Currency of Document	*
17	DOC_COUNT	☐	BBP_BI_DOC_COUNT		DEC	5	4	Counter for Number of Documents
18	STAT_PROCESS	☐	BBP_BI_PROC_STAT	J_STATUS	CHAR	5	0	Processing Status
19	ITM_DELIV_DATE	☐	EINDT	DATUM	DATS	8	0	Item delivery date
20	ITM_GUID	☐	BBP_BI_ITEM_GUID	SYSUUID_C	CHAR	32	0	GUID of Item
21	ITM_CREATED_AT	☐	BBP_BI_ITEM_CREAT_DATE		DATS	8	0	Creation Date of Item
22	ITM_CHANGED_AT	☐	BBP_BI_ITEM_CHANG_DATE		DATS	8	0	Change Date of Item
23	ITM_CREATED_BY	☐	BBP_BI_ITEM_CREAT_BY	UNAME	CHAR	12	0	User That Created the Item
24	ITM_CHANGED_BY	☐	BBP_BI_ITEM_CHANG_BY	UNAME	CHAR	12	0	User That Changed the Item
25	ITM_PRODUCT_GUID	☐	BBP_BI_PROD_GUID	SYSUUID_C	CHAR	32	0	Product GUID
26	ITM_PRODUCT_ID	☐	BBP_BI_PROD_ID	CRM_ORDERED_PROD	CHAR	54	0	Product ID
27	ITM_DESCRIPTION	☐	COMT_PRSHTEXTX	PRSHTEXT40	CHAR	40	0	Product Description
28	ITM_NUMBER	☐	BBP_BI_ITEM_NO	CRM_ITEM_NO	NUMC	10	0	Item Number
29	ITM_CAT_GUID	☐	BBP_CATEGORY_GUID_RAW	SYSUUID	RAW	16	0	Product Category GUID
30	ITM_CATEGORY_ID	☐	BBP_CATEGORY_ID	COM_CATEGORY_ID	CHAR	20	0	Product Category ID
31	ITM_SCHEMA_TYPE	☐	SCHEMA_TYPE	COM_SCHEMA_TYPE	CHAR	10	0	Standard Schema Type	*
32	ITM_EXT_CAT_ID	☐	BBP_ITM_EX_CT_UN_ID	CHAR40	CHAR	40	0	Unique Key in External Category
33	ITM_EXT_CAT_NAME	☐	BBP_CT_CATEGORY_ID	CHAR60	CHAR	60	0	Category Name
34	ITM_PRODUCT_TYPE	☐	BBP_PRODUCT_TYPE	COM_PRODUCT_TYPE	CHAR	2	0	Product Type	*
35	ITM_QUANTITY	☐	BBP_MNG	MENG13	QUAN	13	3	Quantity in Order Unit
36	ITM_QUANTITY_BUM	☐	BBP_BI_QUANTITY_BASE_UNIT	MENG13	QUAN	13	3	Quantity in Base Unit of Measurement
37	ITM_UNIT	☐	BBP_UNIT	MEINS	UNIT	3	0	Purchase Order Unit	*
38	ITM_BASE_UNIT	☐	BBP_BI_BASE_UNIT	MEINS	UNIT	3	0	Base Unit	*
39	ITM_PRICE	☐	BBP_PRICE	WERT7	CURR	13	2	Net Price
40	ITM_PRICE_UNIT	☐	EPEIN	DEC5	DEC	5	0	Price unit
41	ITM_VALUE	☐	BBP_VALUE	WERT8	CURR	15	2	Net Value
42	ITM_REQUEST_ID	☐	BBP_BI_REQUESTER_ID	BU_PARTNER	CHAR	10	0	Requester ID	*
43	ITM_RECIPNT_ID	☐	BBP_BI_RECIPIENT_ID	BU_PARTNER	CHAR	10	0	Recipient ID	*
44	ITM_LOC_ID	☐	BBP_BI_LOCATION_ID	BU_PARTNER	CHAR	10	0	Location ID	*
45	ITM_WORKER_ID	☐	BBP_BI_SRV_PROVIDER_ID	BU_PARTNER	CHAR	10	0	Service Provider ID	*
46	ITM_WRKR_SRC_SYS	☐	COMT_PARTNER_SRC_SYS	LOGSYS	CHAR	10	0	Logical System from Which Partner Originates	*
47	ITM_WORKER_NAME	☐	BBP_BI_SRV_PROVIDER_FULLNAME	TEXT80	CHAR	80	0	Service Provider's Full Name
48	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.)
49	ITM_TYPE	☐	BBP_BI_ITEM_TYPE	CRM_ITEM_TYPE	CHAR	4	0	Item Category	*
50	ITM_LIM_OVERALL	☐	BBP_LIMIT	WERT8	CURR	15	2	Overall Limit
51	ITM_UNLIMITED	☐	BBP_UNLIMITED	CHAR01	CHAR	1	0	Undefined Limit
52	ITM_EXP_VALUE	☐	BBP_EXP_VALUE	WERT8	CURR	15	2	Expected value
53	ITM_TAX_CODE	☐	BBP_MWSKZ	BBP_MWSKZ	CHAR	2	0	Tax Code
54	ITM_TAX_AMOUNT	☐	BBP_TAX_AMOUNT	WERT8	CURR	15	2	Tax Amount
55	ITM_PROD_SRC_SYS	☐	BBP_BI_PRODUCT_SRC_SYS	LOGSYS	CHAR	10	0	Original Logical System of Product	*
56	ITM_SUBTYPE	☐	BBP_I_SUBTYPE	BBP_I_SUBTYPE	CHAR	2	0	Specification Purchase Item (e.g. Direct Material/Hierarch.)
57	ITM_COUNT	☐	BBP_BI_ITEM_COUNT		DEC	5	4	Counter for Number of Items
58	ACC_GUID	☐	BBP_BI_ACC_GUID	SYSUUID_C	CHAR	32	0	Accounting GUID
59	ACC_NO	☐	BBP_ACC_NO	BBP_ACCNO	NUMC	4	0	Sequential Account Assignment No. in EBP Purchase Document
60	ACC_CAT	☐	BBP_ACC_CAT	BBP_ACCCAT	CHAR	5	0	Account Assignment Category in Enterprise Buyer
61	ACC_DISTR_PERC	☐	BBP_VPROZ	BBP_VPROZ	DEC	5	2	Distribution Percentage in the Case of Multiple Acct Assgt
62	ACC_G_L_ACCT	☐	SAKNR	SAKNR	CHAR	10	0	G/L Account Number	*
63	ACC_BUS_AREA	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
64	ACC_CO_AREA	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	*
65	ACC_COST_CTR	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
66	ACC_ASSET_NO	☐	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	*
67	ACC_SUB_NUMBER	☐	ANLN2	ANLN2	CHAR	4	0	Asset Subnumber	*
68	ACC_ORDER_NO	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
69	ACC_PROFIT_CTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center
70	ACC_WBS_ELEMENT	☐	WBS_ELEM	PS_POSID	CHAR	24	0	Work breakdown structure element (WBS element)
71	ACC_NETWORK	☐	NPLNR	AUFNR	CHAR	12	0	Network Number for Account Assignment	*
72	ACC_ACTIVITY	☐	VORNR	VORNR	CHAR	4	0	Operation/Activity Number
73	ACC_STR	☐	BBP_ACC_GENERIC	CHAR64	CHAR	64	0	Generic Account Assignment
74	CMMT_ITEM	☐	FIPOS	FIPOS	CHAR	14	0	Commitment Item	*
75	GRANT_NBR	☐	GM_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	Grant
76	FUNDS_CTR	☐	FISTL	FISTL	CHAR	16	0	Funds Center	*
77	FUND	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	*
78	FUNC_AREA	☐	FKBER_SHORT	FKBER_SHORT	CHAR	4	0	Functional Area
79	SD_DOC	☐	BBP_VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number
80	SDOC_ITEM	☐	BBP_POSNR_VA	POSNR	NUMC	6	0	Sales Document Item
81	ORG_RESP_ORG	☐	BBP_PROG_ORG_RESP	HROBJEC_14	CHAR	14	0	Responsible Organizational Unit (purchasing)
82	ORG_PURCH_ORG	☐	BBP_PROC_ORG	HROBJEC_14	CHAR	14	0	Responsible Purchasing Organization
83	ORG_PURCH_GROUP	☐	BBP_PROC_GROUP	HROBJEC_14	CHAR	14	0	Responsible Purchasing Group
84	UPDMOD	☐	RODMUPDMOD	RODMUPDMOD	CHAR	1	0	BW Delta Process: Record Mode
85	.INCLUDE	☐				0	0	FM Fields Earmarked Funds
86	FUNDS_RES	☐	BBP_KBLNR	KBLNR	CHAR	10	0	Document number for earmarked funds	*
87	RES_ITEM	☐	KBLPOS	KBLPOS	NUMC	3	0	Earmarked Funds: Document Item	*
88	ITM_DEL_IND	☐	BBP_DEL_IND	XFELD	CHAR	1	0	Deletion Indicator EBP Purchasing Document
89	ITM_REV_LEV	☐	CC_REVLV	CC_REVLV	CHAR	2	0	Revision Level
90	BUDGET_PERIOD	☐	FM_BUDGET_PERIOD	FM_BUDGET_PERIOD	CHAR	10	0	FM: Budget Period	*
91	.INCLU--AP	☐				0	0	New Field extensions in Thresholds for Accounting
92	PS_ATH_NOT_REL	☐	/SAPPSSRM/_TH_NOT_RELEVANT	XFELD	CHAR	1	0	Threshold not Relevant
93	PS_ATH_TYPE	☐	/SAPPSSRM/_TH_TYPE	/SAPPSSRM/_TH_TYPE	CHAR	10	0	Threshold Type	*
94	PS_ATH_NUMBER	☐	/SAPPSSRM/_TH_NUM	NUMC10	NUMC	10	0	Threshold Number
95	PS_ATH_AVAIL_AMT	☐	/SAPPSSRM/_TH_RM_AMNT	/SAPPSSRM/_TH_RM_AMNT	CURR	20	2	Remaining Threshold Amount
96	PS_ATH_CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*

History

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