/SRMERP/D_SC_ITM - Shopping Cart Item

Shopping Cart Item information is stored in SAP table /SRMERP/D_SC_ITM.
It is part of development package /SRMERP/OL_BO_SC in software component MM-PUR-SSP. This development package consists of objects that can be grouped under "BPO Shopping Cart".

Fields for table /SRMERP/D_SC_ITM

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
MANDTClientXMANDTCLNT6
DB_KEYNodeIDX/BOBF/CONF_KEYRAW16
PARENT_KEYNodeID/BOBF/CONF_KEYRAW16
NODE_CAT_KEYNodeID/BOBF/CONF_KEYRAW16
.INCLUDE/SRMERP/S_SC_ITM_D0
.INCLUDEITM_BASE/SRMERP/S_SC_ITM_BASE0
OBJECT_IDObject ID - Document Number/SRMERP/OBJECT_IDCHAR20
ITM_NOInternal Shopping Cart Item Number/SRMERP/SC_ITM_NOINT44
ITM_TYPEItem Type/SRMERP/SC_ITEM_TYPECHAR8
.INCLUDE/SRMERP/S_PROD_ITM_COMMON0
TXZ01Short TextTXZ01CHAR80
MATNRMaterial NumberMATNRCHAR80
MENGEOrder Quantity/SRMERP/ORDER_QTYQUAN7
MEINSOrder Unit of Measure/SRMERP/ORDER_UOMUNIT6*
NETPRNet Price in Purchasing Document (in Document Currency)BPREICURR6
PEINHPrice unitEPEINDEC3
EKORGPurchasing organizationEKORGCHAR8*
EKGRPPurchasing GroupEKGRPCHAR6*
LGORTStorage locationLGORT_DCHAR8*
BEDNRRequirement Tracking NumberBEDNRCHAR20
WAERSCurrency KeyWAERSCUKY10*
MATKLMaterial GroupMATKLCHAR18
WERKSPlantEWERKCHAR8*
CATALOG_IDTechnical Key of a Web Service (for Example - a Catalog)WSI_SERVICE_IDCHAR40
PLIFZPlanned Delivery Time in DaysPLIFZDEC2
EMATNMaterial number corresponding to manufacturer part numberEMATNCHAR80*
IDNLFMaterial Number Used by SupplierIDNLFCHAR70
MPROFMfr part profileMPROFCHAR8*
MFRPNManufacturer Part NumberMFRPNCHAR80
MFRNRManufacturer numberMFRNRCHAR20*
EMNFRExternal manufacturer code name or numberEMNFRCHAR20
BMEINPurchase Order Unit of MeasureBSTMEUNIT6*
NETWRNet Value in Document CurrencyNETWRCURR8
NETFWNet Amount in Foreign CurrencyNETFW_CSCURR7
WKURSExchange RateWKURSDEC5
LPEINCategory of delivery dateLPEINCHAR2*
LFDATDelivery dateLFDATDATS16
KNTTPAccount Assignment CategoryKNTTPCHAR2*
KZVBRConsumption postingKZVBRCHAR2
VRTKZDistribution Indicator for Multiple Account AssignmentVRTKZCHAR2
TWRKZPartial invoice indicatorTWRKZCHAR2
WEPOSGoods Receipt IndicatorWEPOSCHAR2
WEUNBGoods Receipt, Non-ValuatedWEUNBCHAR2
REPOSInvoice receipt indicatorREPOSCHAR2
SOBKZSpecial Stock IndicatorSOBKZCHAR2*
KZBWSValuation of Special StockKZBWSCHAR2
BWTARValuation TypeBWTAR_DCHAR20*
XOBLRItem affects commitmentsXOBLRCHAR2
PACKNOPackage numberPACKNONUMC20*
AUTHOR_KEYAuthor/SRMERP/AUTHOR_KEYRAW16
REQUESTER_KEYRequester/SRMERP/REQUESTER_KEYRAW16
FOOBJ_TYPEFollow-On Object Type/SRMERP/FOLLOW_ON_OBJ_TYPECHAR8
BSARTPurchasing Document TypeESARTCHAR8*
.INCLUDEADDRESS_DATA/SRMERP/S_ADDRESS_COMMON0
ADRNRAddress NumberAD_ADDRNUMCHAR20*
ADDRESS_KEYNodeID/BOBF/CONF_KEYRAW16
TXT_EXISTSText Exists/SRMERP/TXT_EXISTS_INDCHAR2
DOC_EXISTSDocument Exists/SRMERP/DOC_EXISTS_INDCHAR2
.INCLUDESOS_DATA/SRMERP/S_SC_SOURCE_OF_SUPPLY0
.INCLUDE/SRMERP/S_SOS_COMMON0
FLIEFFixed VendorFLIEFCHAR20LFA1
SRM_CONTRACT_IDCentral ContractSRM_CONTRACT_IDCHAR20
SRM_CONTRACT_ITMCentral Contract Item NumberSRM_CONTRACT_ITEMNUMC20
LIFNRDesired VendorWLIEFCHAR20LFA1
INFNRNumber of purchasing info recordINFNRCHAR20EINA
VRTYPPurchasing Document CategoryBSTYPCHAR2
KONNRNumber of principal purchase agreementKONNRCHAR20EKKO
KTPNRItem number of principal purchase agreementKTPNRNUMC10EKPO
RESWKSupplying (issuing) plant in case of stock transport orderRESWKCHAR8*
RESLOIssuing Storage Location for Stock Transport OrderRESLOCHAR8*
.INCLUDEFOD/SRMERP/S_SC_ITM_FOD0
BANFNPurchase Requisition NumberBANFNCHAR20
BNFPOItem number of purchase requisitionBNFPONUMC10*
RSNUMNumber of reservation/dependent requirementsRSNUMNUMC20*
RSPOSItem Number of Reservation / Dependent RequirementsRSPOSNUMC8
.INCLUDESTATUS/SRMERP/S_SC_ITM_STATUS0
APPROVAL_STATUSApproval Status/SRMERP/STATUS_APPROVALCHAR4
DELIVERY_STATUSDelivery Status/SRMERP/STATUS_DELIVERYCHAR4
CONSIST_STATUSConsistency Status/SRMERP/STATUS_CONSISTENCYCHAR4
FOLLOW_ON_STATUSFollow-On Status/SRMERP/STATUS_FOLLOW_ONCHAR4
CANCELATN_STATUSCancelation Status/SRMERP/STATUS_CANCELATIONCHAR4
ITM_LIFEC_STATUSLife Cycle of Shopping Cart Item/SRMERP/SC_STATUS_ITM_LIFE_CYCCHAR4
.INCLUDEADMIN_DATA/BOBF/S_LIB_ADMIN_DATA0
CREA_DATE_TIMEUTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)TIMESTAMPLDEC11
CREA_UNAMEUser NameUNAMECHAR24
LCHG_DATE_TIMEUTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)TIMESTAMPLDEC11
LCHG_UNAMEUser NameUNAMECHAR24
.INCLUDEINCL_EEW/SRMERP/INCL_EEW_SC_ITM0
/SRMERP/E_SC_ITMDummy function in length 1DUMMYCHAR2
Privacy Policy