SAP ABAP Table /SAPSRM/S_CTR_IT_BD (Contract Item Basic Data.)

Hierarchy

☛ SRM_SERVER (Software Component) SRM_SERVER
   ⤷ SRM-EBP (Application Component) Enterprise Buyer
     ⤷ /SAPSRM/MVC_CTR (Package) OBSOLETE !!!!! MVC based UI Contract

Basic Data

Table Category	INTTAB	Structure
Structure	/SAPSRM/S_CTR_IT_BD	Table Relationship Diagram
Short Description	Contract Item Basic Data.

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	.INCLUDE	☐				0	0	Contract Item Basic Data.
2	NUMBER_INT	☐	BBP_ITEM_NO	CRM_ITEM_NO	NUMC	10	0	Item number
3	NUMBER_EXT	☐	BBP_ITEM_NO_EXT		NUMC	10	0	External Item Number
4	DESCRIPTION	☐	BBP_ITEM_DESC	TEXT40	CHAR	40	0	Item Description
5	CATEGORY_ID	☐	COMT_CATEGORY_ID	COM_CATEGORY_ID	CHAR	20	0	Category ID
6	MANU_PROD	☐	MFRPN	CHAR40	CHAR	40	0	Manufacturer Part Number
7	MFR_NO_EXT	☐	EMNFR	CHAR10	CHAR	10	0	External manufacturer code name or number
8	QUANTITY	☐	BBP_ITEM_TARGET_QUANTITY	MENG13	QUAN	13	3	Target Quantity for Contract Item
9	UNIT	☐	BBP_UNIT	MEINS	UNIT	3	0	Purchase Order Unit	*
10	ORDERED_PROD	☐	CRMT_ORDERED_PROD_DB	CRM_ORDERED_PROD	CHAR	54	0	Product Name Entered
11	PRICE	☐	BBP_PRICE	WERT7	CURR	13	2	Net Price
12	PRICE_UNIT	☐	EPEIN	DEC5	DEC	5	0	Price unit
13	PARTNER_PROD	☐	BBP_PARTNER_PROD	PRSHTEXT40	CHAR	40	0	Product Number of Vendor
14	VALUE	☐	BBP_ITEM_TARGET_VALUE	WERT8	CURR	15	2	Target Value
15	DELIV_DAYS	☐	BBP_DELIV_DAYS	NUMC3	NUMC	3	0	Delivery Time in Days
16	INCOTERM_KEY	☐	BBP_INCOTERM_KEY	BBP_INCOTERM_KEY	CHAR	3	0	Incoterm Key	*
17	INCOTERM_LOC	☐	BBP_INCOTERM_LOCATION	BBP_INCOTERM_LOCATION	CHAR	28	0	Incoterm Location
18	MIN_ORDER_VALUE	☐	BBP_MIN_ORDER_VALUE	WERT8	CURR	15	2	Minimum Order Value
19	MIN_ORDER_QUAN	☐	BBP_MIN_ORDER_QUANTITY	MENG13	QUAN	13	3	Minimum Order Quantity
20	UOM_DENOMINATOR	☐	BBP_UOM_DENOMINATOR	INT4	INT4	10	0	Denominator for Conversion to Base Unit of Measure
21	UOM_NUMERATOR	☐	BBP_UOM_NUMERATOR	INT4	INT4	10	0	Counter for Conversion to Base Unit of Measure
22	PS_EXSNR	☐	/SAPPSSRM/_EXSNR	NUMC5	NUMC	5	0	External Sort Number
23	PS_IPT	☐	/SAPPSSRM/_IPT	/SAPPSSRM/_IPT	CHAR	10	0	Public Sector Item Type	*
24	TAR_IVAL	☐	BBP_PER_IVAL	DEC3	DEC	3	0	Relationship of Release Value to Target Value (in Percent)
25	TAR_QTY	☐	BBP_PER_QTY	DEC3	DEC	3	0	Relationship of Release Quantity to Target Quantity (in Per)
26	CATALOG_IND	☐	BBP_CATALOG_IND	XFELD	CHAR	1	0	Document (Contract) Transferred to Catalog
27	PMNTTRMS	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
28	CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
29	EXLIN	☐	/SAPSRM/EXLIN	/SAPSRM/EXLIN	CHAR	40	0	Configurable Line Item Number
30	REV_LEV	☐	CC_REVLV	CC_REVLV	CHAR	2	0	Revision Level
31	PERCENT_LOW	☐	BBP_PERCENT_LOW	BBP_PERCNT_PI	DEC	5	2	Lower limit percentage
32	PERCENT_HIGH	☐	BBP_PERCENT_HIGH	BBP_PERCNT_PI	DEC	5	2	Upper Limit Percentage
33	UNLIMITED	☐	XFELD	XFELD	CHAR	1	0	Checkbox
34	UNIT_DESC	☐	BBP_UNIT_DESC	CHAR40	CHAR	40	0	Description of Unit of Measurement
35	ITEM_TYPE_DESC_TEXT	☐	BBP_TEXT1_052	TEXT50	CHAR	50	0	Own Explanation of Term of Payment
36	PRODUCT_TYPE_DESC	☐	/SAPSRM/S_CLL_PRODUCT_TYPE	/SAPSRM/S_CLL_PRODUCT_TYPE	CHAR	4	0	Product Type
37	DISTRIBUTION_FLAG	☐	XFELD	XFELD	CHAR	1	0	Checkbox
38	ITM_RELEASED	☐	BBP_ITM_RELEASED	BBP_ITM_RELEASED	CHAR	1	0	Indicator - Item is to be Released
39	LOCAL_SOURCING	☐	BBP_LOCAL_SOURCE_IND	XFELD	CHAR	1	0	Block Local Sourcing Indicator
40	SH_CATEGORY_TEXT	☐	COMT_CATEGORY_TEXT	TEXT80	CHAR	80	0	Category Description
41	CATEGORY_TXT	☐	BBP_BW_CATEGORY_TEXT	TEXT80	CHAR	80	0	Category Description
42	PMNTTRMS_TXT	☐	BBP_TEXT1_052	TEXT50	CHAR	50	0	Own Explanation of Term of Payment
43	PRODUCT_TYPE	☐	BBP_PRODUCT_TYPE	COM_PRODUCT_TYPE	CHAR	2	0	Product Type	*
44	.INCLUDE	☐				0	0	Contract Item Basic Technicals
45	GUID	☐	BBP_GUID	SYSUUID	RAW	16	0	Globally Unique identifier
46	PARENT	☐	BBP_PGUID	SYSUUID	RAW	16	0	Parent GUID
47	ITM_TYPE	☐	CRMT_ITEM_TYPE_DB	CRM_ITEM_TYPE	CHAR	4	0	Item Category	*
48	PRODUCT	☐	BBP_PRODUCT	SYSUUID	RAW	16	0	Product GUID
49	CATEGORY	☐	COMT_CATEGORY_GUID	SYSUUID	RAW	16	0	Category GUID
50	SCHEMA_TYPE	☐	SCHEMA_TYPE	COM_SCHEMA_TYPE	CHAR	10	0	Standard Schema Type	*
51	CT_CATEGORY_ID	☐	BBP_CT_CATEGORY_ID	CHAR60	CHAR	60	0	Category Name
52	ITM_EX_CT_UN_ID	☐	BBP_ITM_EX_CT_UN_ID	CHAR40	CHAR	40	0	Unique Key in External Category
53	CATALOGID	☐	CATALOG	BBP_WS_SERVICE_ID	CHAR	20	0	Catalog ID from which the line was selected
54	CATALOGITEM	☐	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	DEL_IND	☐	BBP_DEL_IND	XFELD	CHAR	1	0	Deletion Indicator EBP Purchasing Document
58	PRODUCT_SRC_SYS	☐	BBP_LOGSYS	CHAR10	CHAR	10	0	Business Document Service: ID of Logical System
59	SUBTYPE	☐	BBP_I_SUBTYPE	BBP_I_SUBTYPE	CHAR	2	0	Specification Purchase Item (e.g. Direct Material/Hierarch.)
60	SRC_OBJECT_TYPE	☐	BBP_SRC_I_OBJ_TYP	OJ_NAME	CHAR	10	0	Object Type of Reference Item	*
61	SRC_ITM_ID	☐	BBP_SRC_ITM_ID	BBP_SRC_ITM_ID	CHAR	20	0	Unique ID of a Template Item
62	SRC_LOG_SYS	☐	BBP_SRC_LOG_SYS	LOGSYS	CHAR	10	0	Logical System of Template Document (Vacant if in Loc. Sys.)	*
63	SRC_GUID	☐	BBP_SRC_I_GUID	SYSUUID	RAW	16	0	Reference Item GUID
64	SELECTED_FOR_ACTION	☐	BBP_SELECTED_FOR_ACTION	CHAR1	CHAR	1	0	Indicator: If Item is Selected on UI
65	CO_CODE	☐	BBP_CO_CODE	BUKRS	CHAR	4	0	Company Code in FI System	*
66	LOGSYS_FI	☐	BBP_LOGSYS_FI	LOGSYS	CHAR	10	0	Logical System of FI System	*
67	GUARANTEED_MIN	☐	BBP_GUARANTEED_MIN	WERT8	CURR	15	2	Guaranteed Purchase Value (Public Sector ONLY!!)
68	DUMMY_EEW_PDISS_CTR	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
69	PS_HL_ITEM	☐	/SAPPSSRM/_HL_ITEM	SYSUUID	RAW	16	0	Higher-Level Item GUID
70	PS_HANDLE_ITM	☐	BBP_GUID	SYSUUID	RAW	16	0	Globally Unique identifier
71	PS_CTRL_KEY	☐	/SAPPSSRM/_PS_CTRL_KEY	/SAPPSSRM/_PS_CTRL_KEY	CHAR	4	0	Item Process Type Control Key	*
72	PS_VALUE_RU	☐	BBP_VALUE	WERT8	CURR	15	2	Net Value
73	PS_EXLIN_IND	☐	/SAPPSSRM/_EXLIN_IND	/SAPPSSRM/_EXLIN_IND	CHAR	1	0	EXLIN Indicator
74	DUMMY_EEW_PDISC_CTR	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
75	ITEM_PROCESS_TYP	☐	/SAPSRM/PDO_ITEM_PROCESS_TYPE	/SAPSRM/PDO_ITEM_PROCESS_TYPE	CHAR	10	0	Item Process Type	*
76	VAL_PO_E	☐	BBP_PO_VALUE_E	WERT8	CURR	15	2	Value of POs/Confirmations/Invoices Created for Contract
77	QUAN_PO_E	☐	BBP_PO_QUANT_E	MENG15	QUAN	15	3	Quantity of POs/Confirmations/Invoices Created for Contract
78	HEADER	☐	BBP_GUID	SYSUUID	RAW	16	0	Globally Unique identifier
79	CREATED_BY	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
80	CREATED_AT	☐	CRMT_CREATED_AT	BCOS_TSTMP	DEC	15	0	Transaction was Created at this Time
81	CHANGED_BY	☐	CRMT_CHANGED_AT	BCOS_TSTMP	DEC	15	0	Time of Last Change to the Transaction
82	DUMMY_EEW_PD_IT_SWD_CTR	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
83	ACTIVE_ITEM	☐	BBP_GUID	SYSUUID	RAW	16	0	Globally Unique identifier
84	VERSION_TYPE	☐	BBP_VERSION_TYPE	BBP_VERSION_TYPE	CHAR	1	0	Version Type (Active Document, 'Normal', Work Version)
85	P_GUID	☐	BBP_GUID	SYSUUID	RAW	16	0	Globally Unique identifier
86	PRICE_DESC	☐	BBP_UNIT_DESC	CHAR40	CHAR	40	0	Description of Unit of Measurement
87	PRICE_PER	☐	BBP_UNIT_DESC	CHAR40	CHAR	40	0	Description of Unit of Measurement
88	ALERT_REL_QTY	☐	BBP_ITEM_TARGET_QUANTITY	MENG13	QUAN	13	3	Target Quantity for Contract Item
89	STATUS_DESC	☐	EDI_STADES	EDI_CHAR50	CHAR	50	0	Text for status
90	STATUS_INDCATOR	☐	J_INACT	J_INACT	CHAR	1	0	Indicator: Status Is Inactive
91	ITEM_TYPE_DESC	☐	/SAPSRM/S_CLL_ITEM_TYPE	/SAPSRM/S_CLL_ITEM_TYPE	CHAR	5	0	Item Category
92	TREE_PARENT	☐	BBP_GUID	SYSUUID	RAW	16	0	Globally Unique identifier
93	TREE_ITEM	☐	BBP_GUID	SYSUUID	RAW	16	0	Globally Unique identifier
94	LEAF	☐	/SAPSRM/LEAF	BOOLE	CHAR	1	0	Element Without Subelements
95	EXPANDED	☐	BOOLE_D	BOOLE	CHAR	1	0	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')
96	CHILDREN_LOADED	☐	BOOLE_D	BOOLE	CHAR	1	0	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')
97	CALC_DESCRIPTION	☐	/SAPSRM/CLL_CALC_DESCRIPTION	/SAPSRM/CLL_CALC_DESCRIPTION	STRG	0	0	Calculated description for a hierarchical item
98	NUMBER_ATTACHMENTS	☐	INT4	INT4	INT4	10	0	Natural number
99	NUMBER_NOTES	☐	INT4	INT4	INT4	10	0	Natural number
100	NOT_SELECTABLE	☐	BOOLE_D	BOOLE	CHAR	1	0	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')
101	PRICE_VARIANT	☐	/SAPSRM/S_CLL_PRICE_VAR	/SAPSRM/S_CLL_PRICE_VARIANT	CHAR	1	0	Price Variant Key (Only for Purchase Order)
102	ITEM_GUID	☐	BBP_GUID	SYSUUID	RAW	16	0	Globally Unique identifier
103	ITEM_APPROVAL_STATUS	☐	/SAPSRM/PDO_APPROVALSTATUS	/SAPSRM/PDO_APPROVALSTATUS	CHAR	8	0	Status of Item in Approval Process
104	SH_ORDERED_PROD	☐	CRMT_ORDERED_PROD_DB	CRM_ORDERED_PROD	CHAR	54	0	Product Name Entered
105	SH_CATEGORY_ID	☐	COMT_CATEGORY_ID	COM_CATEGORY_ID	CHAR	20	0	Category ID
106	SH_LOGSYS	☐	COMT_LOGSYS	LOGSYS	CHAR	10	0	Original System	*
107	MODEL	☐	/SAPPSSRM/IF_MODEL		REF	0	0

History

Last changed by/on	SAP	20141013
SAP Release Created in	700