SAP ABAP View /SRMERP/VD_SC (Database View on Shopping Cart Header and 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

View Type	D	Database View
Database View	/SRMERP/VD_SC
Short Description	Database View on Shopping Cart Header and Item
Root table	/SRMERP/D_SC	Shopping Cart Header

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	/SRMERP/D_SC	/SRMERP/D_SC
2	/SRMERP/D_SC_ITM

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	/SRMERP/D_SC	MANDT	JL	EQ				0	0
2	/SRMERP/D_SC_ITM	MANDT	JR	EQ			AND	0	0
3	/SRMERP/D_SC	DB_KEY	JL	EQ				0	0
4	/SRMERP/D_SC_ITM	PARENT_KEY	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	/SRMERP/D_SC	MANDT		☐	MANDT	☐	Client
2	DB_KEY_H	/SRMERP/D_SC	DB_KEY		☐	/BOBF/CONF_KEY	☐	NodeID
3	OBJECT_ID	/SRMERP/D_SC	OBJECT_ID		☐	/SRMERP/OBJECT_ID	☐	Object ID - Document Number
4	DOCUMENT_TYPE	/SRMERP/D_SC	DOCUMENT_TYPE		☐	/SRMERP/DOCUMENT_TYPE	☐	Purchasing Document Type
5	CURR_MAX_ITM_NO	/SRMERP/D_SC	CURR_MAX_ITM_NO		☐	/SRMERP/SC_CURR_MAX_ITM_NO	☐	Maximum Current Internal Item Number for SC Item
6	ITM_COUNT	/SRMERP/D_SC	ITM_COUNT		☐	/SRMERP/SC_ITM_COUNT	☐	Number of Items in a Shopping Cart
7	CREA_DATE_TIME_H	/SRMERP/D_SC	CREA_DATE_TIME		☐	TIMESTAMPL	☐	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)
8	CREA_UNAME_H	/SRMERP/D_SC	CREA_UNAME		☐	UNAME	☐	User Name
9	LCHG_DATE_TIME_H	/SRMERP/D_SC	LCHG_DATE_TIME		☐	TIMESTAMPL	☐	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)
10	LCHG_UNAME_H	/SRMERP/D_SC	LCHG_UNAME		☐	UNAME	☐	User Name
11	TOTAL_VAL_NET	/SRMERP/D_SC	TOTAL_VAL_NET		☐	/SRMERP/SC_TOTAL_VAL_NET	☐	Total Net Value of Shopping Cart
12	WAERS_H	/SRMERP/D_SC	WAERS		☐	WAERF	☐	Document currency
13	APPROVAL_STAT_H	/SRMERP/D_SC	APPROVAL_STATUS		☐	/SRMERP/STAT_APPROVAL_W_PARTLY	☐	Approval Status
14	DELIVERY_STAT_H	/SRMERP/D_SC	DELIVERY_STATUS		☐	/SRMERP/STAT_DELIVERY_W_PARTLY	☐	Delivery Status
15	CONSIST_STAT_H	/SRMERP/D_SC	CONSIST_STATUS		☐	/SRMERP/STATUS_CONSISTENCY	☐	Consistency Status
16	FOLLOW_ON_STAT_H	/SRMERP/D_SC	FOLLOW_ON_STATUS		☐	/SRMERP/STAT_FOLLOW_ON_W_PRTLY	☐	Follow-On Status
17	CANCELATN_STAT_H	/SRMERP/D_SC	CANCELATN_STATUS		☐	/SRMERP/STATUS_CANCELATION	☐	Cancelation Status
18	LIFECYCLE_STAT_H	/SRMERP/D_SC	LIFECYCLE_STATUS		☐	/SRMERP/SC_STATUS_RT_LIFE_CYCL	☐	Shopping Cart Life Cycle
19	/SRMERP/E_SCROOT	/SRMERP/D_SC	/SRMERP/E_SCROOT		☐	DUMMY	☐	Dummy function in length 1
20	DB_KEY_I	/SRMERP/D_SC_ITM	DB_KEY		☐	/BOBF/CONF_KEY	☐	NodeID
21	PARENT_KEY_I	/SRMERP/D_SC_ITM	PARENT_KEY		☐	/BOBF/CONF_KEY	☐	NodeID
22	ITM_NO	/SRMERP/D_SC_ITM	ITM_NO		☐	/SRMERP/SC_ITM_NO	☐	Internal Shopping Cart Item Number
23	ITM_TYPE	/SRMERP/D_SC_ITM	ITM_TYPE		☐	/SRMERP/SC_ITEM_TYPE	☐	Item Type
24	TXZ01	/SRMERP/D_SC_ITM	TXZ01		☐	TXZ01	☐	Short Text
25	MATNR	/SRMERP/D_SC_ITM	MATNR		☐	MATNR	☐	Material Number
26	MENGE	/SRMERP/D_SC_ITM	MENGE		☐	/SRMERP/ORDER_QTY	☐	Order Quantity
27	MEINS	/SRMERP/D_SC_ITM	MEINS		☐	/SRMERP/ORDER_UOM	☐	Order Unit of Measure
28	NETPR	/SRMERP/D_SC_ITM	NETPR		☐	BPREI	☐	Net Price in Purchasing Document (in Document Currency)
29	PEINH	/SRMERP/D_SC_ITM	PEINH		☐	EPEIN	☐	Price unit
30	EKORG	/SRMERP/D_SC_ITM	EKORG		☐	EKORG	☐	Purchasing organization
31	EKGRP	/SRMERP/D_SC_ITM	EKGRP		☐	EKGRP	☐	Purchasing group
32	LGORT	/SRMERP/D_SC_ITM	LGORT		☐	LGORT_D	☐	Storage location
33	BEDNR	/SRMERP/D_SC_ITM	BEDNR		☐	BEDNR	☐	Requirement Tracking Number
34	WAERS_I	/SRMERP/D_SC_ITM	WAERS		☐	WAERS	☐	Currency Key
35	MATKL	/SRMERP/D_SC_ITM	MATKL		☐	MATKL	☐	Material Group
36	WERKS	/SRMERP/D_SC_ITM	WERKS		☐	EWERK	☐	Plant
37	CATALOG_ID	/SRMERP/D_SC_ITM	CATALOG_ID		☐	WSI_SERVICE_ID	☐	Technical Key of a Web Service (for Example - a Catalog)
38	PLIFZ	/SRMERP/D_SC_ITM	PLIFZ		☐	PLIFZ	☐	Planned delivery time in days
39	EMATN	/SRMERP/D_SC_ITM	EMATN		☐	EMATN	☐	Material number corresponding to manufacturer part number
40	IDNLF	/SRMERP/D_SC_ITM	IDNLF		☐	IDNLF	☐	Material Number Used by Vendor
41	MPROF	/SRMERP/D_SC_ITM	MPROF		☐	MPROF	☐	Mfr part profile
42	MFRPN	/SRMERP/D_SC_ITM	MFRPN		☐	MFRPN	☐	Manufacturer Part Number
43	MFRNR	/SRMERP/D_SC_ITM	MFRNR		☐	MFRNR	☐	Manufacturer number
44	EMNFR	/SRMERP/D_SC_ITM	EMNFR		☐	EMNFR	☐	External manufacturer code name or number
45	BMEIN	/SRMERP/D_SC_ITM	BMEIN		☐	BSTME	☐	Order unit
46	NETWR	/SRMERP/D_SC_ITM	NETWR		☐	NETWR	☐	Net Value in Document Currency
47	NETFW	/SRMERP/D_SC_ITM	NETFW		☐	NETFW	☐	Net Amount in Foreign Currency
48	WKURS	/SRMERP/D_SC_ITM	WKURS		☐	WKURS	☐	Exchange Rate
49	LPEIN	/SRMERP/D_SC_ITM	LPEIN		☐	LPEIN	☐	Category of delivery date
50	LFDAT	/SRMERP/D_SC_ITM	LFDAT		☐	LFDAT	☐	Delivery date
51	KNTTP	/SRMERP/D_SC_ITM	KNTTP		☐	KNTTP	☐	Account assignment category
52	KZVBR	/SRMERP/D_SC_ITM	KZVBR		☐	KZVBR	☐	Consumption posting
53	VRTKZ	/SRMERP/D_SC_ITM	VRTKZ		☐	VRTKZ	☐	Distribution indicator for multiple account assignment
54	TWRKZ	/SRMERP/D_SC_ITM	TWRKZ		☐	TWRKZ	☐	Partial invoice indicator
55	WEPOS	/SRMERP/D_SC_ITM	WEPOS		☐	WEPOS	☐	Goods Receipt Indicator
56	WEUNB	/SRMERP/D_SC_ITM	WEUNB		☐	WEUNB	☐	Goods Receipt, Non-Valuated
57	REPOS	/SRMERP/D_SC_ITM	REPOS		☐	REPOS	☐	Invoice receipt indicator
58	SOBKZ	/SRMERP/D_SC_ITM	SOBKZ		☐	SOBKZ	☐	Special Stock Indicator
59	KZBWS	/SRMERP/D_SC_ITM	KZBWS		☐	KZBWS	☐	Valuation of Special Stock
60	BWTAR	/SRMERP/D_SC_ITM	BWTAR		☐	BWTAR_D	☐	Valuation type
61	XOBLR	/SRMERP/D_SC_ITM	XOBLR		☐	XOBLR	☐	Item affects commitments
62	PACKNO	/SRMERP/D_SC_ITM	PACKNO		☐	PACKNO	☐	Package number
63	ADRNR	/SRMERP/D_SC_ITM	ADRNR		☐	AD_ADDRNUM	☐	Address number
64	ADDRESS_KEY	/SRMERP/D_SC_ITM	ADDRESS_KEY		☐	/BOBF/CONF_KEY	☐	NodeID
65	AUTHOR_KEY	/SRMERP/D_SC_ITM	AUTHOR_KEY		☐	/SRMERP/AUTHOR_KEY	☐	Author
66	REQUESTER_KEY	/SRMERP/D_SC_ITM	REQUESTER_KEY		☐	/SRMERP/REQUESTER_KEY	☐	Requester
67	FLIEF	/SRMERP/D_SC_ITM	FLIEF		☐	FLIEF	☐	Fixed vendor
68	SRM_CONTRACT_ID	/SRMERP/D_SC_ITM	SRM_CONTRACT_ID		☐	SRM_CONTRACT_ID	☐	Central Contract
69	SRM_CONTRACT_ITM	/SRMERP/D_SC_ITM	SRM_CONTRACT_ITM		☐	SRM_CONTRACT_ITEM	☐	Central Contract Item Number
70	LIFNR	/SRMERP/D_SC_ITM	LIFNR		☐	WLIEF	☐	Desired vendor
71	INFNR	/SRMERP/D_SC_ITM	INFNR		☐	INFNR	☐	Number of purchasing info record
72	VRTYP	/SRMERP/D_SC_ITM	VRTYP		☐	BSTYP	☐	Purchasing document category
73	KONNR	/SRMERP/D_SC_ITM	KONNR		☐	KONNR	☐	Number of principal purchase agreement
74	KTPNR	/SRMERP/D_SC_ITM	KTPNR		☐	KTPNR	☐	Item number of principal purchase agreement
75	RESWK	/SRMERP/D_SC_ITM	RESWK		☐	RESWK	☐	Supplying (issuing) plant in case of stock transport order
76	RESLO	/SRMERP/D_SC_ITM	RESLO		☐	RESLO	☐	Issuing Storage Location for Stock Transport Order
77	ITM_LIFEC_STATUS	/SRMERP/D_SC_ITM	ITM_LIFEC_STATUS		☐	/SRMERP/SC_STATUS_ITM_LIFE_CYC	☐	Life Cycle of Shopping Cart Item
78	APPROVAL_STAT_I	/SRMERP/D_SC_ITM	APPROVAL_STATUS		☐	/SRMERP/STATUS_APPROVAL	☐	Approval Status
79	DELIVERY_STAT_I	/SRMERP/D_SC_ITM	DELIVERY_STATUS		☐	/SRMERP/STATUS_DELIVERY	☐	Delivery Status
80	CONSIST_STAT_I	/SRMERP/D_SC_ITM	CONSIST_STATUS		☐	/SRMERP/STATUS_CONSISTENCY	☐	Consistency Status
81	FOLLOW_ON_STAT_I	/SRMERP/D_SC_ITM	FOLLOW_ON_STATUS		☐	/SRMERP/STATUS_FOLLOW_ON	☐	Follow-On Status
82	CANCELATN_STAT_I	/SRMERP/D_SC_ITM	CANCELATN_STATUS		☐	/SRMERP/STATUS_CANCELATION	☐	Cancelation Status
83	CREA_DATE_TIME_I	/SRMERP/D_SC_ITM	CREA_DATE_TIME		☐	TIMESTAMPL	☐	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)
84	CREA_UNAME_I	/SRMERP/D_SC_ITM	CREA_UNAME		☐	UNAME	☐	User Name
85	LCHG_DATE_TIME_I	/SRMERP/D_SC_ITM	LCHG_DATE_TIME		☐	TIMESTAMPL	☐	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)
86	LCHG_UNAME_I	/SRMERP/D_SC_ITM	LCHG_UNAME		☐	UNAME	☐	User Name
87	/SRMERP/E_SC_ITM	/SRMERP/D_SC_ITM	/SRMERP/E_SC_ITM		☐	DUMMY	☐	Dummy function in length 1

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

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

History

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