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