/SRMERP/D_SC_ITM

Shopping Cart Item | #transactional | Component: Self-Service Procurement
Column Name Description
MANDT Client
DB_KEY NodeID
Column Name Description
💲 Currency Key (WAERS):
NETPR Net Price in Purchasing Document (in Document Currency)
NETFW Net Amount in Foreign Currency
NETWR Net Value in Document Currency
Column Name Description
📏 Order Unit of Measure (MEINS):
MENGE Order Quantity
Column Name Description
LFDAT Delivery date
Column Name Description
ITM_TYPE Item Type Show values
KZVBR Consumption posting Show values
VRTKZ Distribution Indicator for Multiple Account Assignment Show values
TWRKZ Partial invoice indicator Show values
WEPOS Goods Receipt Indicator Show values
WEUNB Goods Receipt, Non-Valuated Show values
REPOS Invoice receipt indicator Show values
KZBWS Valuation of Special Stock Show values
XOBLR Item affects commitments Show values
FOOBJ_TYPE Follow-On Object Type Show values
TXT_EXISTS Text Exists Show values
DOC_EXISTS Document Exists Show values
VRTYP Purchasing Document Category Show values
APPROVAL_STATUS Approval Status Show values
DELIVERY_STATUS Delivery Status Show values
CONSIST_STATUS Consistency Status Show values
FOLLOW_ON_STATUS Follow-On Status Show values
CANCELATN_STATUS Cancelation Status Show values
ITM_LIFEC_STATUS Life Cycle of Shopping Cart Item Show values
Column Name Description Domain name
PARENT_KEY NodeID /BOBF/CONF_KEY
NODE_CAT_KEY NodeID /BOBF/CONF_KEY
OBJECT_ID Object ID - Document Number /SRMERP/OBJECT_ID
ITM_NO Internal Shopping Cart Item Number INT4
TXZ01 Short Text TEXT40
MATNR Material Number MATNR
PEINH Price unit DEC5
EKGRP Purchasing Group EKGRP
BEDNR Requirement Tracking Number CHAR10
MATKL Material Group MATKL
CATALOG_ID Technical Key of a Web Service (for Example - a Catalog) BBP_WS_SERVICE_ID
PLIFZ Planned Delivery Time in Days DEC3
EMATN Material number corresponding to manufacturer part number MATNR
IDNLF Material Number Used by Supplier IDNEX
MPROF Mfr part profile MPROF
MFRPN Manufacturer Part Number CHAR40
MFRNR Manufacturer number LIFNR
EMNFR External manufacturer code name or number CHAR10
WKURS Exchange Rate KURSP
LPEIN Category of delivery date PRGBZ
KNTTP Account Assignment Category KNTTP
SOBKZ Special Stock Indicator SOBKZ
BWTAR Valuation Type BWTAR
PACKNO Package number PACKNO
AUTHOR_KEY Author /BOBF/CONF_KEY
REQUESTER_KEY Requester /BOBF/CONF_KEY
BSART Purchasing Document Type BSART
ADRNR Address Number AD_ADDRNUM
ADDRESS_KEY NodeID /BOBF/CONF_KEY
SRM_CONTRACT_ID Central Contract BBP_BAPI_EBELN
SRM_CONTRACT_ITM Central Contract Item Number BBP_ITEMNO
RESWK Supplying (issuing) plant in case of stock transport order WERKS
RESLO Issuing Storage Location for Stock Transport Order LGORT
BANFN Purchase Requisition Number BANFN
BNFPO Item number of purchase requisition BNFPO
RSNUM Number of reservation/dependent requirements RSNUM
RSPOS Item Number of Reservation / Dependent Requirements RSPOS
CREA_DATE_TIME UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TZNTSTMPL
CREA_UNAME User Name UNAME
LCHG_DATE_TIME UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TZNTSTMPL
LCHG_UNAME User Name UNAME
/SRMERP/E_SC_ITM Dummy function in length 1 DUMMY
Master Data Relations Join Conditions
Fixed Vendor
  • /SRMERP/D_SC_ITM.MANDT == LFA1.MANDT
  • /SRMERP/D_SC_ITM.FLIEF == LFA1.LIFNR
Number of purchasing info record
  • Number of purchasing info record
  • Client
  • /SRMERP/D_SC_ITM.INFNR == EINA.INFNR
  • /SRMERP/D_SC_ITM.MANDT == EINA.MANDT
Desired Vendor
  • /SRMERP/D_SC_ITM.MANDT == LFA1.MANDT
  • /SRMERP/D_SC_ITM.LIFNR == LFA1.LIFNR