SAP ABAP Table /SRMERP/S_SC_ITM (Shopping Cart Item)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ MM-PUR-SSP (Application Component) Self-Service Procurement
     ⤷ /SRMERP/OL_BO_SC (Package) BPO Shopping Cart

Basic Data

Table Category	INTTAB	Structure
Structure	/SRMERP/S_SC_ITM	Table Relationship Diagram
Short Description	Shopping Cart Item

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	Include Structure for Key Information
2	KEY	☐	/BOBF/CONF_KEY	/BOBF/CONF_KEY	RAW	16	0	NodeID
3	PARENT_KEY	☐	/BOBF/CONF_KEY	/BOBF/CONF_KEY	RAW	16	0	NodeID
4	ROOT_KEY	☐	/BOBF/CONF_KEY	/BOBF/CONF_KEY	RAW	16	0	NodeID
5	.INCLUDE	☐				0	0	Shopping Cart Item Data
6	.INCLUDE	☐				0	0	SC Item base data
7	OBJECT_ID	☐	/SRMERP/OBJECT_ID	/SRMERP/OBJECT_ID	CHAR	10	0	Object ID - Document Number
8	ITM_NO	☐	/SRMERP/SC_ITM_NO	INT4	INT4	10	0	Internal Shopping Cart Item Number
9	ITM_TYPE	☐	/SRMERP/SC_ITEM_TYPE	/SRMERP/SC_ITEM_TYPE	CHAR	4	0	Item Type
10	.INCLUDE	☐				0	0	Product Item Common Data
11	TXZ01	☐	TXZ01	TEXT40	CHAR	40	0	Short Text
12	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
13	MENGE	☐	/SRMERP/ORDER_QTY	MENG13	QUAN	13	3	Order Quantity
14	MEINS	☐	/SRMERP/ORDER_UOM	MEINS	UNIT	3	0	Order Unit of Measure	*
15	NETPR	☐	BPREI	WERT11	CURR	11	2	Net Price in Purchasing Document (in Document Currency)
16	PEINH	☐	EPEIN	DEC5	DEC	5	0	Price unit
17	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	*
18	EKGRP	☐	EKGRP	EKGRP	CHAR	3	0	Purchasing group	*
19	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	*
20	BEDNR	☐	BEDNR	CHAR10	CHAR	10	0	Requirement Tracking Number
21	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
22	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	*
23	WERKS	☐	EWERK	WERKS	CHAR	4	0	Plant	*
24	CATALOG_ID	☐	WSI_SERVICE_ID	BBP_WS_SERVICE_ID	CHAR	20	0	Technical Key of a Web Service (for Example - a Catalog)
25	PLIFZ	☐	PLIFZ	DEC3	DEC	3	0	Planned delivery time in days
26	EMATN	☐	EMATN	MATNR	CHAR	18	0	Material number corresponding to manufacturer part number	*
27	IDNLF	☐	IDNLF	IDNEX	CHAR	35	0	Material Number Used by Vendor
28	MPROF	☐	MPROF	MPROF	CHAR	4	0	Mfr part profile	*
29	MFRPN	☐	MFRPN	CHAR40	CHAR	40	0	Manufacturer Part Number
30	MFRNR	☐	MFRNR	LIFNR	CHAR	10	0	Manufacturer number	*
31	EMNFR	☐	EMNFR	CHAR10	CHAR	10	0	External manufacturer code name or number
32	BMEIN	☐	BSTME	MEINS	UNIT	3	0	Order unit	*
33	NETWR	☐	NETWR	WERTV8	CURR	15	2	Net Value in Document Currency
34	NETFW	☐	NETFW	WERT7	CURR	13	2	Net Amount in Foreign Currency
35	WKURS	☐	WKURS	KURSP	DEC	9	5	Exchange Rate
36	LPEIN	☐	LPEIN	PRGBZ	CHAR	1	0	Category of delivery date	*
37	LFDAT	☐	LFDAT	DATUM	DATS	8	0	Delivery date
38	KNTTP	☐	KNTTP	KNTTP	CHAR	1	0	Account assignment category	*
39	KZVBR	☐	KZVBR	KZVBR	CHAR	1	0	Consumption posting
40	VRTKZ	☐	VRTKZ	VRTKZ	CHAR	1	0	Distribution indicator for multiple account assignment
41	TWRKZ	☐	TWRKZ	TWRKZ	CHAR	1	0	Partial invoice indicator
42	WEPOS	☐	WEPOS	XFELD	CHAR	1	0	Goods Receipt Indicator
43	WEUNB	☐	WEUNB	XFELD	CHAR	1	0	Goods Receipt, Non-Valuated
44	REPOS	☐	REPOS	XFELD	CHAR	1	0	Invoice receipt indicator
45	SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	*
46	KZBWS	☐	KZBWS	KZBWS	CHAR	1	0	Valuation of Special Stock
47	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	*
48	XOBLR	☐	XOBLR	XFELD	CHAR	1	0	Item affects commitments
49	PACKNO	☐	PACKNO	PACKNO	NUMC	10	0	Package number	*
50	AUTHOR_KEY	☐	/SRMERP/AUTHOR_KEY	/BOBF/CONF_KEY	RAW	16	0	Author
51	REQUESTER_KEY	☐	/SRMERP/REQUESTER_KEY	/BOBF/CONF_KEY	RAW	16	0	Requester
52	FOOBJ_TYPE	☐	/SRMERP/FOLLOW_ON_OBJ_TYPE	/SRMERP/FOLLOW_ON_OBJ_TYPE	CHAR	4	0	Follow-On Object Type
53	BSART	☐	ESART	BSART	CHAR	4	0	Purchasing Document Type	*
54	.INCLUDE	☐				0	0	Address Data
55	ADRNR	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
56	ADDRESS_KEY	☐	/BOBF/CONF_KEY	/BOBF/CONF_KEY	RAW	16	0	NodeID
57	TXT_EXISTS	☐	/SRMERP/TXT_EXISTS_IND	BOOLE	CHAR	1	0	Text Exists
58	DOC_EXISTS	☐	/SRMERP/DOC_EXISTS_IND	BOOLE	CHAR	1	0	Document Exists
59	.INCLUDE	☐				0	0	Source of supply variables of the shopping cart item
60	.INCLUDE	☐				0	0	Common source of supply data
61	FLIEF	☐	FLIEF	LIFNR	CHAR	10	0	Fixed vendor	LFA1
62	SRM_CONTRACT_ID	☐	SRM_CONTRACT_ID	BBP_BAPI_EBELN	CHAR	10	0	Central Contract
63	SRM_CONTRACT_ITM	☐	SRM_CONTRACT_ITEM	BBP_ITEMNO	NUMC	10	0	Central Contract Item Number
64	LIFNR	☐	WLIEF	LIFNR	CHAR	10	0	Desired vendor	LFA1
65	INFNR	☐	INFNR	INFNR	CHAR	10	0	Number of purchasing info record	EINA
66	VRTYP	☐	BSTYP	BSTYP	CHAR	1	0	Purchasing document category
67	KONNR	☐	KONNR	EBELN	CHAR	10	0	Number of principal purchase agreement	EKKO
68	KTPNR	☐	KTPNR	EBELP	NUMC	5	0	Item number of principal purchase agreement	EKPO
69	RESWK	☐	RESWK	WERKS	CHAR	4	0	Supplying (issuing) plant in case of stock transport order	*
70	RESLO	☐	RESLO	LGORT	CHAR	4	0	Issuing Storage Location for Stock Transport Order	*
71	.INCLUDE	☐				0	0	Follow on document numbers of the shopping cart item
72	BANFN	☐	BANFN	BANFN	CHAR	10	0	Purchase requisition number
73	BNFPO	☐	BNFPO	BNFPO	NUMC	5	0	Item number of purchase requisition	*
74	RSNUM	☐	RSNUM	RSNUM	NUMC	10	0	Number of reservation/dependent requirements	*
75	RSPOS	☐	RSPOS	RSPOS	NUMC	4	0	Item Number of Reservation / Dependent Requirements
76	.INCLUDE	☐				0	0	Status variables of the Shopping Cart Item
77	APPROVAL_STATUS	☐	/SRMERP/STATUS_APPROVAL	/SRMERP/STATUS_APPROVAL	CHAR	2	0	Approval Status
78	DELIVERY_STATUS	☐	/SRMERP/STATUS_DELIVERY	/SRMERP/STATUS_DELIVERY	CHAR	2	0	Delivery Status
79	CONSIST_STATUS	☐	/SRMERP/STATUS_CONSISTENCY	/SRMERP/STATUS_CONSISTENCY	CHAR	2	0	Consistency Status
80	FOLLOW_ON_STATUS	☐	/SRMERP/STATUS_FOLLOW_ON	/SRMERP/STATUS_FOLLOW_ON	CHAR	2	0	Follow-On Status
81	CANCELATN_STATUS	☐	/SRMERP/STATUS_CANCELATION	/SRMERP/STATUS_CANCELATION	CHAR	2	0	Cancelation Status
82	ITM_LIFEC_STATUS	☐	/SRMERP/SC_STATUS_ITM_LIFE_CYC	/SRMERP/SC_STATUS_ITM_LIFE_CYC	CHAR	2	0	Life Cycle of Shopping Cart Item
83	.INCLUDE	☐				0	0	Admin Data to be included (/BOBF/CL_LIB_ADMIN_DATA_TSM)
84	CREA_DATE_TIME	☐	TIMESTAMPL	TZNTSTMPL	DEC	21	7	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)
85	CREA_UNAME	☐	UNAME	UNAME	CHAR	12	0	User Name
86	LCHG_DATE_TIME	☐	TIMESTAMPL	TZNTSTMPL	DEC	21	7	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)
87	LCHG_UNAME	☐	UNAME	UNAME	CHAR	12	0	User Name
88	.INCLUDE	☐				0	0	Extension Include for SC ITM
89	/SRMERP/E_SC_ITM	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
90	.INCLUDE	☐				0	0	transient data SC item
91	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
92	PSTYP	☐	PSTYP	PSTYP	CHAR	1	0	Item category in purchasing document	*
93	FABKL	☐	FABKL	WFCID	CHAR	2	0	Factory calendar key	*
94	MRPPP	☐	MRPPP	MRPPP	CHAR	3	0	PPC planning calendar	*
95	PRREG	☐	PRREG	PRREG	CHAR	2	0	Checking rule for the availability check	*
96	MNG02	☐	MNG06	MENGV13	QUAN	13	3	Committed quantity
97	DATA_ORIGIN_MATNR	☐	/SRMERP/SC_ORIGIN	/SRMERP/ORIGIN	NUMC	2	0	SC Origin
98	DATA_ORIGIN_MENGE	☐	/SRMERP/SC_ORIGIN	/SRMERP/ORIGIN	NUMC	2	0	SC Origin
99	DATA_ORIGIN_MEINS	☐	/SRMERP/SC_ORIGIN	/SRMERP/ORIGIN	NUMC	2	0	SC Origin
100	DATA_ORIGIN_MAKTX	☐	/SRMERP/SC_ORIGIN	/SRMERP/ORIGIN	NUMC	2	0	SC Origin
101	DATA_ORIGIN_EKORG	☐	/SRMERP/SC_ORIGIN	/SRMERP/ORIGIN	NUMC	2	0	SC Origin
102	DATA_ORIGIN_WAERS	☐	/SRMERP/SC_ORIGIN	/SRMERP/ORIGIN	NUMC	2	0	SC Origin
103	DATA_ORIGIN_WERKS	☐	/SRMERP/SC_ORIGIN	/SRMERP/ORIGIN	NUMC	2	0	SC Origin
104	DATA_ORIGIN_LPEIN	☐	/SRMERP/SC_ORIGIN	/SRMERP/ORIGIN	NUMC	2	0	SC Origin
105	DATA_ORIGIN_LFDAT	☐	/SRMERP/SC_ORIGIN	/SRMERP/ORIGIN	NUMC	2	0	SC Origin
106	DATA_ORIGIN_BUKRS	☐	/SRMERP/SC_ORIGIN	/SRMERP/ORIGIN	NUMC	2	0	SC Origin
107	DATA_ORIGIN_FABKL	☐	/SRMERP/SC_ORIGIN	/SRMERP/ORIGIN	NUMC	2	0	SC Origin
108	DATA_ORIGIN_KNTTP	☐	/SRMERP/SC_ORIGIN	/SRMERP/ORIGIN	NUMC	2	0	SC Origin
109	DATA_ORIGIN_KOSTL	☐	/SRMERP/SC_ORIGIN	/SRMERP/ORIGIN	NUMC	2	0	SC Origin
110	DATA_ORIGIN_KOKRS	☐	/SRMERP/SC_ORIGIN	/SRMERP/ORIGIN	NUMC	2	0	SC Origin

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	/SRMERP/S_SC_ITM	FLIEF	LFA1	LIFNR
2	/SRMERP/S_SC_ITM	INFNR	EINA	INFNR
3	/SRMERP/S_SC_ITM	KONNR	EKKO	EBELN
4	/SRMERP/S_SC_ITM	KTPNR	EKPO	EBELP
5	/SRMERP/S_SC_ITM	LIFNR	LFA1	LIFNR

History

Last changed by/on	SAP	20130529
SAP Release Created in	606