SAP ABAP Table BBPS_BW_PD_ITEM (Item Structure Procurement Document and Parent Number)

Hierarchy

☛

BBPCRM (Software Component) BBPCRM
⤷

SRM-EBP-REP (Application Component) Reporting
⤷

BBP_BW (Package) BW Extractors and Development for BBP

Basic Data

Table Category	INTTAB	Structure
Structure	BBPS_BW_PD_ITEM	Table Relationship Diagram
Short Description	Item Structure Procurement Document and Parent Number

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components


	Field	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE				0	0	Item Data Procurement Document Interface
2	.INCLUDE				0	0	Business Transaction Item
3	.INCLUDE				0	0	One Order: Key Fields
4	CLIENT	MANDT	MANDT	CLNT	3	0	Client	*
5	GUID	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
6	.INCLUDE				0	0	Item: Structure of System Fields
7	.INCLUDE				0	0	Time and User of Last Transaction Processing
8	CREATED_AT	COMT_CREATED_AT_USR	COM_TSTMP	DEC	15	0	Created At (Output in User Time Zone)
9	CREATED_BY	CRMT_CREATED_BY	UNAME	CHAR	12	0	User that Created the Transaction
10	CHANGED_AT	COMT_CHANGED_AT_USR	COM_TSTMP	DEC	15	0	Changed At (Output in User Time Zone)
11	CHANGED_BY	CRMT_CHANGED_BY	UNAME	CHAR	12	0	Transaction Last Changed By
12	OBJECT_TYPE	CRMT_SWO_OBJTYP_PROCESS_ITM_DB	CRM_OJ_NAME_PROCESS_ITEM	CHAR	10	0	CRM Item Object Type	*
13	DESCRIPTION_UC	CRMT_PRSHTEXTG_DB	CRM_PRSHTEXTG40_DB	CHAR	40	0	Product Short Text in Upper Case for F4 Help
14	.INCLUDE				0	0	Item: Structre of External Fields
15	HEADER	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
16	PARENT	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
17	ALTERNATIVE	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
18	PRODUCT	CRMT_PRODUCT_GUID_DB	SYSUUID	RAW	16	0	Internal Unique ID of Product
19	PRODUCT_SRC_SYS	CRMT_PRODUCT_SRC_SYS	LOGSYS	CHAR	10	0	Logical System from Which Product Originates	*
20	ORDERED_PROD	CRMT_ORDERED_PROD_DB	CRM_ORDERED_PROD	CHAR	54	0	Product Name Entered
21	PARTNER_PROD	CRMT_ITEM_DESCR_PARTNER	PRSHTEXT40	CHAR	40	0	Product Number of Business Partner
22	DESCRIPTION	CRMT_PRSHTEXTX_DB	CRM_PRSHTEXT40_DB	CHAR	40	0	Product Short Text
23	ITM_LANGUAGE	CRMT_ITEM_LANGU	SYLANGU	LANG	1	0	Short Text Language for an Item
24	NUMBER_INT	CRMT_ITEM_NO	CRM_ITEM_NO	NUMC	10	0	Item Number in Document
25	NUMBER_EXT	CRMT_ITEM_NO_EXT		NUMC	10	0	External Item Number
26	ITM_TYPE	CRMT_ITEM_TYPE_DB	CRM_ITEM_TYPE	CHAR	4	0	Item Category	*
27	ORDER_DATE	CRMT_ORDER_DATE	BCOS_TSTMP	DEC	15	0	Posting Date
28	SUBST_REASON	CRMT_ITEM_SUBSTITUTION	CRM_ITEM_SUBSTITUTION	CHAR	4	0	Reason for Product Substitution	*
29	ITM_USAGE	CRMT_ITEM_USAGE	CRM_ITEM_USAGE	CHAR	2	0	Usage of Higher-Level Item
30	ITM_TYPE_USAGE	CRMT_IT_TYPE_USAGE	CRM_IT_TYPE_USAGE	CHAR	4	0	Item Category Usage	*
31	PRODUCT_KIND	CRMT_PRODUCT_KIND	CRM_PRODUCT_KIND	CHAR	1	0	Technnical Type of Product
32	LOG_SYSTEM_EXT	CRMT_LOGSYS	LOGSYS	CHAR	10	0	Logical System	*
33	.INCLUDE				0	0	EEW Extension
34	ORDERADM_I_DUMMY	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
35	.INCLUDE				0	0
36	.INCLU--AP				0	0	Additional Fields in ORDERADM_I_EXT
37	ALTID_TYPE	COMT_ALTID_TYPE	CHAR16	CHAR	16	0	ID Type for Alternative IDs
38	PARENT_IN_COMP_TX	CRMT_COMP_TX_PARENT_GUID	SYSUUID	RAW	16	0	Higher-Level Item Number in Composite Transaction
39	NUMBER_INT_COMP_TX	CRMT_COMP_TX_ITEM_NO	CRM_ITEM_NO	NUMC	10	0	Composite Transaction-Specific Item Number
40	.INCLUDE				0	0	Include Item Data General Purchasing
41	CATEGORY	BBP_CATEGORY_GUID_RAW	SYSUUID	RAW	16	0	Product Category GUID
42	CATEGORY_ID	BBP_CATEGORY_ID	COM_CATEGORY_ID	CHAR	20	0	Product Category ID
43	SCHEMA_TYPE	SCHEMA_TYPE	COM_SCHEMA_TYPE	CHAR	10	0	Standard Schema Type	*
44	CT_CATEGORY_ID	BBP_CT_CATEGORY_ID	CHAR60	CHAR	60	0	Category Name
45	ITM_EX_CT_UN_ID	BBP_ITM_EX_CT_UN_ID	CHAR40	CHAR	40	0	Unique Key in External Category
46	MANU_PROD	BBP_MFRPN	CHAR40	CHAR	40	0	Manufacturer Part Number
47	MFR_NO_EXT	EMNFR	CHAR10	CHAR	10	0	External manufacturer code name or number
48	CATALOGID	BBP_WS_SERVICE_ID	BBP_WS_SERVICE_ID	CHAR	20	0	Technical Key of a Web Service (for Example - a Catalog)	BBP_CAT_ENTITY
49	CATALOGITEM	BBP_CATALOGITEM	CATALOGITEM	CHAR	40	0	Catalog Item (Unique Key)
50	EXT_QUOTE_ID	BBP_EXT_QUOTE_ID		CHAR	35	0	Number of External Bid
51	EXT_QUOTE_ITEM	BBP_EXT_QUOTE_ITEM		NUMC	10	0	Item for an External Bid
52	PRODUCT_TYPE	BBP_PRODUCT_TYPE	COM_PRODUCT_TYPE	CHAR	2	0	Product Type	*
53	DEL_DATCAT	LPEIN_INT	PRGRS	CHAR	1	0	Date type (day, week, month, interval)
54	DELIV_DATE	EINDT	DATUM	DATS	8	0	Item delivery date
55	DELIV_TIME	BBP_DELIV_TIME	TIME	TIMS	6	0	Delivery Time of the Item
56	LEADTIME	BBP_LEADTIME	CHAR5	CHAR	5	0	Delivery Time in Days
57	VPER_START	BBP_VPER_START	DATUM	DATS	8	0	Validity Period From
58	VPER_END	BBP_VPER_END	DATUM	DATS	8	0	Validity period
59	QUANTITY	BBP_MNG	MENG13	QUAN	13	3	Quantity in Order Unit
60	UNIT	BBP_UNIT	MEINS	UNIT	3	0	Purchase Order Unit	*
61	GROSS_PRICE	BBP_GROSS_PRICE	WERT7	CURR	13	2	Gross Price
62	PRICE	BBP_PRICE	WERT7	CURR	13	2	Net Price
63	PRICE_UNIT	EPEIN	DEC5	DEC	5	0	Price unit
64	PRICE_ORIGIN	BBP_PRICE_ORIGIN	BBP_PRICE_ORIGIN	CHAR	1	0	Original Price (Determination/Manual Input)
65	VALUE	BBP_VALUE	WERT8	CURR	15	2	Net Value
66	CURRENCY	WAERS	WAERS	CUKY	5	0	Currency Key	*
67	TAX_CODE	BBP_MWSKZ	BBP_MWSKZ	CHAR	2	0	Tax Code
68	BBP_MOVE_TYPE	BBP_MOVE_TYPE	CHAR4	CHAR	4	0	Movement Code for Enterprise Buyer Professional Edition
69	SRC_OBJECT_TYPE	BBP_SRC_I_OBJ_TYP	OJ_NAME	CHAR	10	0	Object Type of Reference Item	*
70	SRC_ITM_ID	BBP_SRC_ITM_ID	BBP_SRC_ITM_ID	CHAR	20	0	Unique ID of a Template Item
71	SRC_LOG_SYS	BBP_SRC_LOG_SYS	LOGSYS	CHAR	10	0	Logical System of Template Document (Vacant if in Loc. Sys.)	*
72	SRC_GUID	BBP_SRC_I_GUID	SYSUUID	RAW	16	0	Reference Item GUID
73	CTR_LOG_SYS	BBP_CTR_LOG_SYSTEM	LOGSYS	CHAR	10	0	Logical System from Which the Contract Originates	*
74	CTR_GUID	BBP_CTR_I_GUID	SYSUUID	RAW	16	0	Contract Template Item GUID
75	CTR_ITEM_NUMBER	BBP_CTR_ITEM	CRM_ITEM_NO	NUMC	10	0	Number of Contract Item
76	CTR_HDR_NUMBER	BBP_CTR_ID	CRM_OBJECT_ID	CHAR	10	0	Contract Number
77	CTR_HDR_GUID	BBP_CTR_H_GUID	SYSUUID	RAW	16	0	GUID Contract
78	COMM_ID	BBP_COMM_ID	EBELP	NUMC	5	0	Clear Item ID for Commitments Interface	*
79	DEL_IND	BBP_DEL_IND	XFELD	CHAR	1	0	Deletion Indicator EBP Purchasing Document
80	FINAL_INV	EREKZ	XFELD	CHAR	1	0	Final Invoice Indicator
81	FINAL_ENTRY	BBP_FINAL_ENTRY	XFELD	CHAR	1	0	Final Entry Indicator (Goods/Services)
82	DEDUCT_IND	BBP_DEDUCT_IND	XFELD	CHAR	1	0	Discount/Rejection Indicator at Item Level
83	REJECT_WI	SWW_WIID	SWW_WIID	NUMC	12	0	Work item ID	*
84	.INCLUDE				0	0	Actual Values
85	VAL_CF_E	BBP_CF_VALUE_E	WERT8	CURR	15	2	Value of Entered Confirmations
86	VAL_CF	BBP_CF_VALUE	WERT8	CURR	15	2	Value of Confirmations Released
87	VAL_IV_E	BBP_IV_VALUE_E	WERT8	CURR	15	2	Entered Invoice Value
88	VAL_IV	BBP_IV_VALUE	WERT8	CURR	15	2	Released Invoice Value
89	VAL_PO_E	BBP_PO_VALUE_E	WERT8	CURR	15	2	Value of POs/Confirmations/Invoices Created for Contract
90	.INCLUDE				0	0	Actual Quantity
91	QUAN_CF_E	BBP_CF_QUANT_E	MENG15	QUAN	15	3	Quantity of Entered Confirmation
92	QUAN_CF	BBP_CF_QUANT	MENG15	QUAN	15	3	Quantity of Released Confirmations
93	QUAN_IV_E	BBP_IV_QUANT_E	MENG15	QUAN	15	3	Entered Invoiced Quantity
94	QUAN_IV	BBP_IV_QUANT	MENG15	QUAN	15	3	Released Invoiced Quantity
95	QUAN_PO_E	BBP_PO_QUANT_E	MENG15	QUAN	15	3	Quantity of POs/Confirmations/Invoices Created for Contract
96	NUM_CONF	BBP_NUM_CONF	BBP_INT4V	INT4	10	0	Number of Entered Confirmations for a Purchase Order
97	NUM_INV	BBP_NUM_INV	BBP_INT4V	INT4	10	0	Number of Entered Invoices for Purchase Order or Confirmat.
98	DCIND	BBP_DCIND	BBP_DCIND	CHAR	1	0	Debit/credit Indicator
99	SUBTYPE	BBP_I_SUBTYPE	BBP_I_SUBTYPE	CHAR	2	0	Specification Purchase Item (e.g. Direct Material/Hierarch.)
100	SOURCE_REL_IND	BBP_SOURCE_REL_IND	BBP_SOURCE_REL_IND	CHAR	1	0	Indicator - If the Document is Sourcing-Relevant
101	EXT_DEMID	BBP_EXT_DEMID	CHAR32	CHAR	32	0	External Requirement Tracking Number
102	EXT_DEM_POSID	BBP_EXT_DEM_POSID	CHAR32	CHAR	32	0	External Requirement Tracking Number
103	EXT_DEM_LOGSYS	BBP_EXT_DEM_LOGSYS	LOGSYS	CHAR	10	0	Logical System from where an External Requirement Comes	*
104	PCINS	BBPPCINS	BBPPCINS	CHAR	4	0	Procurement card company	*
105	PCNUM	BBPPCNUM	BBPPCNUM	CHAR	25	0	Procurement card number	*
106	PCNAME	BBPPCNAME	CHAR40	CHAR	40	0	Name of procurement cardholder
107	PCDAT_TO	BBPPCDAT_TO	DATUM	DATS	8	0	Procurement Card Validity Date
108	LOGSYS_FI	BBP_LOGSYS_FI	LOGSYS	CHAR	10	0	Logical System of FI System	*
109	ITM_RELEASED	BBP_ITM_RELEASED	XFELD	CHAR	1	0	Indicator - Item is to be Released
110	ACTIVE_ITEM	BBP_GUID	SYSUUID	RAW	16	0	Globally Unique identifier
111	TIME_FROM	BBP_TIME_FROM	TIME	TIMS	6	0	Start Time
112	TIME_TO	BBP_TIME_TO	TIME	TIMS	6	0	Finish Time
113	ORIGIN_ORDER_ID	BBP_ORIGIN_ORDER_ID	CHAR35	CHAR	35	0	Origninal Customer's PO No. for Third Party Transaction
114	ORIGIN_ITEM_ID	BBP_ORIGIN_ORDER_ITEM_ID	NUMC10	NUMC	10	0	Orignl Customer Purchase Order Item No. - Third Party Trans.
115	NUM_SOS	BBP_NUM_SOS	BBP_NUM_SOS	CHAR	1	0	Number of Sources of Supply Found (for Performance)
116	GROUPING_LEVEL	BBP_GROUPING_LEVEL	BBP_GROUPING_LEVEL	CHAR	1	0	Specifies How Hierarchy Positions are to be Managed
117	.INCLUDE				0	0
118	DELIV_DAYS	BBP_DELIV_DAYS	NUMC3	NUMC	3	0	Delivery Time in Days
119	INCOTERM_KEY	BBP_INCOTERM_KEY	BBP_INCOTERM_KEY	CHAR	3	0	Incoterm Key	*
120	INCOTERM_LOC	BBP_INCOTERM_LOCATION	BBP_INCOTERM_LOCATION	CHAR	28	0	Incoterm Location
121	TAX_CODE_ORIGIN	BBP_TAX_CODE_ORIGIN	BBP_TAX_CODE_ORIGIN	CHAR	1	0	Origin Tax Code Indicator (Determination/Manual Entry)
122	MIN_ORDER_VALUE	BBP_VALUE	WERT8	CURR	15	2	Net Value
123	MIN_ORDER_QUAN	BBP_MNG	MENG13	QUAN	13	3	Quantity in Order Unit
124	EXT_DEM_SUBPOSID	BBP_EXT_DEM_SUBPOSID	CHAR32	CHAR	32	0	External Requirement Subitem Number
125	.INCLUDE				0	0	Include Purchasing Set
126	GR_IND	WEPOS	XFELD	CHAR	1	0	Goods Receipt Indicator
127	IR_IND	REPOS	XFELD	CHAR	1	0	Invoice receipt indicator
128	GR_NON_VAL	BBP_WEUNB	XFELD	CHAR	1	0	Goods receipt, non-valuated
129	GR_BASEDIV	WEBRE	XFELD	CHAR	1	0	Indicator: GR-Based Invoice Verification
130	ERS	XERSY	XFELD	CHAR	1	0	Evaluated Receipt Settlement (ERS)
131	OR_IND	BBP_OR_IND	XFELD	CHAR	1	0	PO Confirmation Expected (ORDER_RESP_EXP in vendor master)
132	ASN_IND	BBP_ASN_IND	XFELD	CHAR	1	0	Shipping Notification Exptd (ASN_EXPECTED in Vendor Master)
133	.INCLUDE				0	0	Include Item Data Purchasing Backend-Specific
134	BE_LOG_SYSTEM	BE_LOG_SYSTEM	LOGSYS	CHAR	10	0	Logical System of Logistics Backend	*
135	BE_OBJ_ITEM	BE_OBJ_ITEM	BBP_REF_ITEM	CHAR	10	0	Follow-On Object Item in Backend System
136	BE_OBJECT_TYPE	BE_OBJECT_TYPE	OJ_NAME	CHAR	10	0	Follow-On Document Object Type in Backend System	*
137	BE_OBJECT_ID	BE_OBJECT_ID	BBP_BE_OBJECT_ID	CHAR	20	0	Follow-On Document Object ID in Backend
138	BE_REFOBJ_TYPE	BE_REFOBJ_TYPE	OJ_NAME	CHAR	10	0	Reference Object Type in Backend System	*
139	BE_REFOBJ	BE_REFOBJ	BBP_BE_OBJECT_ID	CHAR	20	0	Reference Object in Backend System
140	BE_REFOBJ_ITEM	BE_REFOBJ_ITEM	BBP_REF_ITEM	CHAR	10	0	Reference Object Item in Backend System
141	BE_REFOBJ_SBITM	BE_REFOBJ_SBITM	CHAR20	CHAR	20	0	Reference Object Sub-Position in Backend System
142	BE_REFOBJ_TYPE2	BE_REFOBJ_TYPE	OJ_NAME	CHAR	10	0	Reference Object Type in Backend System	*
143	BE_REFOBJ2	BE_REFOBJ	BBP_BE_OBJECT_ID	CHAR	20	0	Reference Object in Backend System
144	BE_REFOBJ_ITEM2	BE_REFOBJ_ITEM	BBP_REF_ITEM	CHAR	10	0	Reference Object Item in Backend System
145	BE_REFOBJ_FYEAR2	BE_FI_YEAR	GJAHR	NUMC	4	0	Reference Document Object- Fiscal Year in Backend System
146	BE_STGE_LOC	LGORT_D	LGORT	CHAR	4	0	Storage location
147	BE_PLANT	BE_EWERK	WERKS	CHAR	4	0	Plant	*
148	BE_BATCH	CHARG_D	CHARG	CHAR	10	0	Batch Number
149	BE_VAL_TYPE	BWTAR_D	BWTAR	CHAR	10	0	Valuation type
150	BE_MOVE_REAS	BE_GRBEW	MB_GRBEW	NUMC	4	0	Reason for Movement	*
151	BE_EXPERYDATE	VFDAT	DATUM	DATS	8	0	Shelf Life Expiration or Best-Before Date
152	BE_PUR_GROUP	EKGRP	EKGRP	CHAR	3	0	Purchasing group	*
153	BE_PUR_ORG	EKORG	EKORG	CHAR	4	0	Purchasing organization	*
154	BE_CO_CODE	BUKRS	BUKRS	CHAR	4	0	Company Code	*
155	BE_DOC_TYPE	BBSRT	BSART	CHAR	4	0	Purchase Requisition Document Type	*
156	BE_ACCREQUIRED	BE_ACCREQUIRED	BE_ACCREQUIRED	CHAR	1	0	Account Assignment for Logical Backend Required
157	BE_SP_STK_IND	BBPCIF_CIFSSKEY	BBPCIF_CIFSSKEY	CHAR	16	0	Key for Special Stock Section
158	BE_INFO_REC	INFNR	INFNR	CHAR	10	0	Number of purchasing info record	*
159	BE_MOVE_TYPE	BWART	BWART	CHAR	3	0	Movement type (inventory management)	*
160	BE_PACKNO	PACKNO	PACKNO	NUMC	10	0	Package number	*
161	BE_INTROW	INTROW	NUMC10	NUMC	10	0	Internal line number for limits
162	BE_ITEM_TEXT	BBP_BE_ITEM_TEXT	CHAR40	CHAR	40	0	Short Text of a Service Purchase Order Item
163	BE_PO_PRICE	BBP_BE_PO_PRICE	BPUEB	CHAR	1	0	Price from Backend
164	BE_UNLOAD_PT	BBP_UNLOAD_PT	CHAR25	CHAR	25	0	Unloading Point in Backend
165	BE_DEL_IND	BBP_BE_DEL_IND	XFELD	CHAR	1	0	Deletion Indicator in Backend Documents
166	BE_TRACKING_NO	BEDNR	CHAR10	CHAR	10	0	Requirement Tracking Number
167	.INCLUDE				0	0	Bid Invitation/Bid/Auction-Specific Item Data
168	EXTERNAL_RANK	BBP_EXTERNAL_RANK	INT4	INT4	10	0	Ranking of Bid in External Auction
169	EXTERNAL_SCORE	BBP_EXTERNAL_SCORE	BBP_EXTERNAL_SCORE	DEC	7	2	Valuation of Bid in External Auction
170	START_PRICE	BBP_START_PRICE	WERT7	CURR	13	2	Auction Start Price
171	RESERVED_PRICE	BBP_RESERVE_PRICE	WERT7	CURR	13	2	Reserve Price of an Auction
172	BID_DECR_AMOUNT	BBP_DECREMENT_AMOUNT	WERT7	CURR	13	2	Absolute Bid Decrement
173	BID_DECR_PERCENT	BBP_DECREMENT_PERCENT	BBP_PERCNT	DEC	5	2	Percentage Bid Decrement
174	.INCLUDE				0	0	Data Buffered for UI But not Saved
175	.INCLUDE				0	0	Item Administration Data Buffered But not Saved
176	VERSION_TYPE	BBP_VERSION_TYPE	BBP_VERSION_TYPE	CHAR	1	0	Version Type (Active Document, 'Normal', Work Version)
177	SELECTED	BBP_SELECTED	CHAR1	CHAR	1	0	Indicator: If Item is Selected on UI
178	VPER_TYPE	BBP_VPER_TYPE	CHAR02	CHAR	2	0	Delivery Date Type (From-Date, To-Date, Timeframe ...)
179	PARENT_NUMBER	CRMT_ITEM_NO	CRM_ITEM_NO	NUMC	10	0	Item Number in Document