/SRMERP/VD_SC SAP (Generated Table for View) Table View details

Dictionary Type: Table View
Description: Generated Table for View




ABAP Code to SELECT data from /SRMERP/VD_SC
Related tables to /SRMERP/VD_SC
Access table /SRMERP/VD_SC




Table View field list including key, data, relationships and ABAP select examples

/SRMERP/VD_SC is a standard SAP Table View which is used to store Generated Table for View data and is available within R/3 SAP systems depending on the version and release level.

The /SRMERP/VD_SC table consists of various fields, each holding specific information or linking keys about Generated Table for View data available in SAP. These include DB_KEY_H (NodeID), OBJECT_ID (Object ID - Document Number), DOCUMENT_TYPE (Purchasing Document Type), CURR_MAX_ITM_NO (Maximum Current Internal Item Number for SC Item).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP /SRMERP/VD_SC table view fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3MANDT
DB_KEY_HNodeID /BOBF/CONF_KEYRAW16/BOBF/CONF_KEY
OBJECT_IDObject ID - Document Number /SRMERP/OBJECT_IDCHAR10/SRMERP/OBJECT_ID
DOCUMENT_TYPEPurchasing Document Type /SRMERP/DOCUMENT_TYPECHAR4/SRMERP/DOCUMENT_TYPE
CURR_MAX_ITM_NOMaximum Current Internal Item Number for SC Item /SRMERP/SC_CURR_MAX_ITM_NOINT410INT4
ITM_COUNTNumber of Items in a Shopping Cart /SRMERP/SC_ITM_COUNTINT410INT4
CREA_DATE_TIME_HUTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TIMESTAMPLDEC21(7) TZNTSTMPL
CREA_UNAME_HUser Name UNAMECHAR12UNAME
LCHG_DATE_TIME_HUTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TIMESTAMPLDEC21(7) TZNTSTMPL
LCHG_UNAME_HUser Name UNAMECHAR12UNAME
TOTAL_VAL_NETTotal Net Value of Shopping Cart /SRMERP/SC_TOTAL_VAL_NETCURR15(2) /SRMERP/AMOUNT
WAERS_HDocument currency WAERFCUKY5WAERSFWS
APPROVAL_STAT_HApproval Status /SRMERP/STAT_APPROVAL_W_PARTLYCHAR2/SRMERP/STAT_APPROVAL_W_PARTLY
DELIVERY_STAT_HDelivery Status /SRMERP/STAT_DELIVERY_W_PARTLYCHAR2/SRMERP/STAT_DELIVERY_W_PARTLY
CONSIST_STAT_HConsistency Status /SRMERP/STATUS_CONSISTENCYCHAR2/SRMERP/STATUS_CONSISTENCY
FOLLOW_ON_STAT_HFollow-On Status /SRMERP/STAT_FOLLOW_ON_W_PRTLYCHAR2/SRMERP/STAT_FOLLOW_ON_W_PRTLY
CANCELATN_STAT_HCancelation Status /SRMERP/STATUS_CANCELATIONCHAR2/SRMERP/STATUS_CANCELATION
LIFECYCLE_STAT_HShopping Cart Life Cycle /SRMERP/SC_STATUS_RT_LIFE_CYCLCHAR2/SRMERP/SC_STATUS_RT_LIFE_CYCL
/SRMERP/E_SCROOTDummy function in length 1 DUMMYCHAR1DUMMY
DB_KEY_INodeID /BOBF/CONF_KEYRAW16/BOBF/CONF_KEY
PARENT_KEY_INodeID /BOBF/CONF_KEYRAW16/BOBF/CONF_KEY
ITM_NOInternal Shopping Cart Item Number /SRMERP/SC_ITM_NOINT410INT4
ITM_TYPEItem Type /SRMERP/SC_ITEM_TYPECHAR4/SRMERP/SC_ITEM_TYPE
TXZ01Short Text TXZ01CHAR40TEXT40
MATNRMaterial Number MATNRCHAR18MATN1MATNRMATS_MAT1
MENGEOrder Quantity /SRMERP/ORDER_QTYQUAN13(3) MENG13
MEINSOrder Unit of Measure /SRMERP/ORDER_UOMUNIT3CUNITMEINS
NETPRNet Price in Purchasing Document (in Document Currency) BPREICURR11(2) WERT11
PEINHPrice Unit EPEINDEC5DEC5
EKORGPurchasing Organization EKORGCHAR4EKORGEKO
EKGRPPurchasing Group EKGRPCHAR3EKGRPEKG
LGORTStorage Location LGORT_DCHAR4LGORTLAG
BEDNRRequirement Tracking Number BEDNRCHAR10CHAR10
WAERS_ICurrency Key WAERSCUKY5WAERSFWS
MATKLMaterial Group MATKLCHAR9MATKLMKLS_WBWG
WERKSPlant EWERKCHAR4WERKSWRK
CATALOG_IDTechnical Key of a Web Service (for Example - a Catalog) WSI_SERVICE_IDCHAR20BBP_WS_SERVICE_ID
PLIFZPlanned Delivery Time in Days PLIFZDEC3DEC3
EMATNMaterial Number Corresponding to Manufacturer Part Number EMATNCHAR18MATN1MATNRHTN
IDNLFMaterial Number Used by Vendor IDNLFCHAR35IDNEX
MPROFManufacturer Part Profile MPROFCHAR4MPROF
MFRPNManufacturer Part Number MFRPNCHAR40CHAR40
MFRNRNumber of a Manufacturer MFRNRCHAR10ALPHALIFNR
EMNFRExternal manufacturer code name or number EMNFRCHAR10CHAR10
BMEINPurchase Order Unit of Measure BSTMEUNIT3CUNITMEINS
NETWRNet Value in Document Currency NETWRCURR15(2) WERTV8
NETFWNet Amount in Foreign Currency NETFWCURR13(2) WERT7
WKURSExchange Rate WKURSDEC9(5) EXCRTKURSP
LPEINCategory of Delivery Date LPEINCHAR1PRGBZ
LFDATDelivery date LFDATDATS8DATUM
KNTTPAccount Assignment Category KNTTPCHAR1KNTTPKNT
KZVBRConsumption Posting KZVBRCHAR1KZVBR
VRTKZDistribution indicator for multiple account assignment VRTKZCHAR1VRTKZ
TWRKZPartial Invoice Indicator TWRKZCHAR1TWRKZ
WEPOSGoods Receipt Indicator WEPOSCHAR1XFELD
WEUNBGoods Receipt, Non-Valuated WEUNBCHAR1XFELD
REPOSInvoice Receipt Indicator REPOSCHAR1XFELD
SOBKZSpecial Stock Indicator SOBKZCHAR1SOBKZ
KZBWSValuation of Special Stock KZBWSCHAR1KZBWS
BWTARValuation Type BWTAR_DCHAR10BWTARBWT
XOBLRItem affects commitments XOBLRCHAR1XFELD
PACKNOPackage number PACKNONUMC10PACKNO
ADRNRAddress number AD_ADDRNUMCHAR10ALPHAAD_ADDRNUMADR
ADDRESS_KEYNodeID /BOBF/CONF_KEYRAW16/BOBF/CONF_KEY
AUTHOR_KEYAuthor /SRMERP/AUTHOR_KEYRAW16/BOBF/CONF_KEY
REQUESTER_KEYRequester /SRMERP/REQUESTER_KEYRAW16/BOBF/CONF_KEY
FLIEFFixed Vendor FLIEFCHAR10LFA1ALPHALIFNR
SRM_CONTRACT_IDCentral Contract SRM_CONTRACT_IDCHAR10ALPHABBP_BAPI_EBELNMMBSI_MEKK_CC
SRM_CONTRACT_ITMCentral Contract Item Number SRM_CONTRACT_ITEMNUMC10BBP_ITEMNO
LIFNRDesired Vendor WLIEFCHAR10LFA1ALPHALIFNR
INFNRNumber of Purchasing Info Record INFNRCHAR10EINAALPHAINFNRINFMEIN_C
VRTYPPurchasing Document Category BSTYPCHAR1BSTYP
KONNRNumber of Principal Purchase Agreement KONNRCHAR10EKKOALPHAEBELNKTR
KTPNRItem Number of Principal Purchase Agreement KTPNRNUMC5EKPOEBELP
RESWKSupplying (Issuing) Plant in Stock Transport Order RESWKCHAR4WERKS
RESLOIssuing Storage Location for Stock Transport Order RESLOCHAR4LGORT
ITM_LIFEC_STATUSLife Cycle of Shopping Cart Item /SRMERP/SC_STATUS_ITM_LIFE_CYCCHAR2/SRMERP/SC_STATUS_ITM_LIFE_CYC
APPROVAL_STAT_IApproval Status /SRMERP/STATUS_APPROVALCHAR2/SRMERP/STATUS_APPROVAL
DELIVERY_STAT_IDelivery Status /SRMERP/STATUS_DELIVERYCHAR2/SRMERP/STATUS_DELIVERY
CONSIST_STAT_IConsistency Status /SRMERP/STATUS_CONSISTENCYCHAR2/SRMERP/STATUS_CONSISTENCY
FOLLOW_ON_STAT_IFollow-On Status /SRMERP/STATUS_FOLLOW_ONCHAR2/SRMERP/STATUS_FOLLOW_ON
CANCELATN_STAT_ICancelation Status /SRMERP/STATUS_CANCELATIONCHAR2/SRMERP/STATUS_CANCELATION
CREA_DATE_TIME_IUTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TIMESTAMPLDEC21(7) TZNTSTMPL
CREA_UNAME_IUser Name UNAMECHAR12UNAME
LCHG_DATE_TIME_IUTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TIMESTAMPLDEC21(7) TZNTSTMPL
LCHG_UNAME_IUser Name UNAMECHAR12UNAME
/SRMERP/E_SC_ITMDummy function in length 1 DUMMYCHAR1DUMMY

Key field Non-key field



How do I retrieve data from SAP table /SRMERP/VD_SC using ABAP code

The following ABAP code Example will allow you to do a basic selection on /SRMERP/VD_SC to SELECT all data from the table
DATA: WA_/SRMERP/VD_SC TYPE /SRMERP/VD_SC.

SELECT SINGLE *
FROM /SRMERP/VD_SC
INTO CORRESPONDING FIELDS OF WA_/SRMERP/VD_SC
WHERE...

How to access SAP table /SRMERP/VD_SC

Within an ECC or HANA version of SAP you can also view further information about /SRMERP/VD_SC and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!