/SRMERP/D_SC_ITM SAP (Shopping Cart Item) Table details

Dictionary Type: Table
Description: Shopping Cart Item




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




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

/SRMERP/D_SC_ITM is a standard SAP Table which is used to store Shopping Cart Item data and is available within R/3 SAP systems depending on the version and release level.

The /SRMERP/D_SC_ITM table consists of various fields, each holding specific information or linking keys about Shopping Cart Item data available in SAP. These include DB_KEY (NodeID), PARENT_KEY (NodeID), NODE_CAT_KEY (NodeID), OBJECT_ID (Object ID - Document Number).. 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: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP /SRMERP/D_SC_ITM table 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 MANDTCLNT3Assigned to domainMANDT
DB_KEYNodeID /BOBF/CONF_KEYRAW16/BOBF/CONF_KEY
PARENT_KEYNodeID /BOBF/CONF_KEYRAW16/BOBF/CONF_KEY
NODE_CAT_KEYNodeID /BOBF/CONF_KEYRAW16/BOBF/CONF_KEY
OBJECT_IDObject ID - Document Number /SRMERP/OBJECT_IDCHAR10/SRMERP/OBJECT_ID
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 MATNRCHAR18Assigned to domainMATN1MATNRMATS_MAT1
MENGEOrder Quantity /SRMERP/ORDER_QTYQUAN13(3) MENG13
MEINSOrder Unit of Measure /SRMERP/ORDER_UOMUNIT3Assigned to domainCUNITMEINS
NETPRNet Price in Purchasing Document (in Document Currency) BPREICURR11(2) WERT11
PEINHPrice Unit EPEINDEC5DEC5
EKORGPurchasing Organization EKORGCHAR4Assigned to domainEKORGEKO
EKGRPPurchasing Group EKGRPCHAR3Assigned to domainEKGRPEKG
LGORTStorage Location LGORT_DCHAR4Assigned to domainLGORTLAG
BEDNRRequirement Tracking Number BEDNRCHAR10CHAR10
WAERSCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
MATKLMaterial Group MATKLCHAR9Assigned to domainMATKLMKLS_WBWG
WERKSPlant EWERKCHAR4Assigned to domainWERKSWRK
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 EMATNCHAR18Assigned to domainMATN1MATNRHTN
IDNLFMaterial Number Used by Vendor IDNLFCHAR35IDNEX
MPROFManufacturer Part Profile MPROFCHAR4Assigned to domainMPROF
MFRPNManufacturer Part Number MFRPNCHAR40CHAR40
MFRNRNumber of a Manufacturer MFRNRCHAR10Assigned to domainALPHALIFNR
EMNFRExternal manufacturer code name or number EMNFRCHAR10CHAR10
BMEINPurchase Order Unit of Measure BSTMEUNIT3Assigned to domainCUNITMEINS
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 LPEINCHAR1Assigned to domainPRGBZ
LFDATDelivery date LFDATDATS8DATUM
KNTTPAccount Assignment Category KNTTPCHAR1Assigned to domainKNTTPKNT
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 SOBKZCHAR1Assigned to domainSOBKZ
KZBWSValuation of Special Stock KZBWSCHAR1KZBWS
BWTARValuation Type BWTAR_DCHAR10Assigned to domainBWTARBWT
XOBLRItem affects commitments XOBLRCHAR1XFELD
PACKNOPackage number PACKNONUMC10Assigned to domainPACKNO
AUTHOR_KEYAuthor /SRMERP/AUTHOR_KEYRAW16/BOBF/CONF_KEY
REQUESTER_KEYRequester /SRMERP/REQUESTER_KEYRAW16/BOBF/CONF_KEY
FOOBJ_TYPEFollow-On Object Type /SRMERP/FOLLOW_ON_OBJ_TYPECHAR4/SRMERP/FOLLOW_ON_OBJ_TYPE
BSARTPurchasing Document Type ESARTCHAR4Assigned to domainBSARTBSA
ADRNRAddress number AD_ADDRNUMCHAR10Assigned to domainALPHAAD_ADDRNUMADR
ADDRESS_KEYNodeID /BOBF/CONF_KEYRAW16/BOBF/CONF_KEY
TXT_EXISTSText Exists /SRMERP/TXT_EXISTS_INDCHAR1BOOLE
DOC_EXISTSDocument Exists /SRMERP/DOC_EXISTS_INDCHAR1BOOLE
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 RESWKCHAR4Assigned to domainWERKS
RESLOIssuing Storage Location for Stock Transport Order RESLOCHAR4Assigned to domainLGORT
BANFNPurchase Requisition Number BANFNCHAR10ALPHABANFNBANMBAN_C
BNFPOItem Number of Purchase Requisition BNFPONUMC5Assigned to domainBNFPOBAP
RSNUMNumber of Reservation/Dependent Requirement RSNUMNUMC10Assigned to domainRSNUMRES
RSPOSItem Number of Reservation/Dependent Requirement RSPOSNUMC4RSPOSRPO
APPROVAL_STATUSApproval Status /SRMERP/STATUS_APPROVALCHAR2/SRMERP/STATUS_APPROVAL
DELIVERY_STATUSDelivery Status /SRMERP/STATUS_DELIVERYCHAR2/SRMERP/STATUS_DELIVERY
CONSIST_STATUSConsistency Status /SRMERP/STATUS_CONSISTENCYCHAR2/SRMERP/STATUS_CONSISTENCY
FOLLOW_ON_STATUSFollow-On Status /SRMERP/STATUS_FOLLOW_ONCHAR2/SRMERP/STATUS_FOLLOW_ON
CANCELATN_STATUSCancelation Status /SRMERP/STATUS_CANCELATIONCHAR2/SRMERP/STATUS_CANCELATION
ITM_LIFEC_STATUSLife Cycle of Shopping Cart Item /SRMERP/SC_STATUS_ITM_LIFE_CYCCHAR2/SRMERP/SC_STATUS_ITM_LIFE_CYC
CREA_DATE_TIMEUTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TIMESTAMPLDEC21(7) TZNTSTMPL
CREA_UNAMEUser Name UNAMECHAR12UNAME
LCHG_DATE_TIMEUTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TIMESTAMPLDEC21(7) TZNTSTMPL
LCHG_UNAMEUser 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/D_SC_ITM using ABAP code

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

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

How to access SAP table /SRMERP/D_SC_ITM

Within an ECC or HANA version of SAP you can also view further information about /SRMERP/D_SC_ITM 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!