SAP ABAP Table /SRMERP/S_SC_ITM_D (Shopping Cart Item Data)

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

Foreign Keys

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

History

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