SAP ABAP Table BBPS_CON_IL_ITEM (Item)

Hierarchy

☛

BBPCRM (Software Component) BBPCRM
⤷

SRM-EBP-CON (Application Component) Purchase Contract
⤷

BBP_CON (Package) Purchase Contracts

Basic Data

Table Category	INTTAB	Structure
Structure	BBPS_CON_IL_ITEM	Table Relationship Diagram
Short Description	Item

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