/SRMERP/D_SC_ITM SAP table for – Shopping Cart Item

Here we would like to draw your attention to /SRMERP/D_SC_ITM table in SAP. As we know it is being mainly used with the SAP MM-PUR (Purchasing in MM) component which is coming under MM module (Material Management). /SRMERP/D_SC_ITM is a SAP standard transparent table used for storing Shopping Cart Item related data in SAP. It comes under the package /SRMERP/OL_BO_SC.

SAP /SRMERP/D_SC_ITM table

Table /SRMERP/D_SC_ITM technical data

Table/SRMERP/D_SC_ITM
Data storingShopping Cart Item
ModuleMM
ComponentMM-PUR
SAP Package/SRMERP/OL_BO_SC
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP /SRMERP/D_SC_ITM Table Fields

Here is the details of each fields in this table.You can find the discription, data type and assigned lenth of each of the fields in /SRMERP/D_SC_ITM table.

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • TXZ01
    Its data type is C (Character String) with field length 40
  • MATNR : Material Number
    Its data type is C (Character String) with field length 18
  • MENGE : Quantity
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • MEINS : Base Unit of Measure
    Its data type is C (Character String) with field length 3
  • NETPR
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • PEINH : Price unit
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • EKORG : Purchasing organization
    Its data type is C (Character String) with field length 4
  • EKGRP : Purchasing group for external processing
    Its data type is C (Character String) with field length 3
  • LGORT : Storage location
    Its data type is C (Character String) with field length 4
  • DB_KEY
    Its a key field. Its data type is X (Byte string) with field length 16
  • BEDNR : Requirement Tracking Number
    Its data type is C (Character String) with field length 10
  • WAERS : Currency Key
    Its data type is C (Character String) with field length 5
  • MATKL : Material Group
    Its data type is C (Character String) with field length 9
  • WERKS : Plant
    Its data type is C (Character String) with field length 4
  • CATALOG_ID
    Its data type is C (Character String) with field length 20
  • PLIFZ : Planned delivery time in days
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 2
  • EMATN
    Its data type is C (Character String) with field length 18
  • IDNLF
    Its data type is C (Character String) with field length 35
  • MPROF
    Its data type is C (Character String) with field length 4
  • MFRPN : Manufacturer Part Number
    Its data type is C (Character String) with field length 40
  • PARENT_KEY
    Its data type is X (Byte string) with field length 16
  • MFRNR
    Its data type is C (Character String) with field length 10
  • EMNFR : External manufacturer code name or number
    Its data type is C (Character String) with field length 10
  • BMEIN
    Its data type is C (Character String) with field length 3
  • NETWR
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • NETFW
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • WKURS : Exchange Rate
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 5
  • LPEIN
    Its data type is C (Character String) with field length 1
  • LFDAT
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • KNTTP : Account assignment category
    Its data type is C (Character String) with field length 1
  • KZVBR : Consumption posting
    Its data type is C (Character String) with field length 1
  • NODE_CAT_KEY
    Its data type is X (Byte string) with field length 16
  • VRTKZ
    Its data type is C (Character String) with field length 1
  • TWRKZ
    Its data type is C (Character String) with field length 1
  • WEPOS : Goods Receipt Indicator
    Its data type is C (Character String) with field length 1
  • WEUNB : Goods Receipt, Non-Valuated
    Its data type is C (Character String) with field length 1
  • REPOS
    Its data type is C (Character String) with field length 1
  • SOBKZ : Special Stock Indicator
    Its data type is C (Character String) with field length 1
  • KZBWS : Valuation of Special Stock
    Its data type is C (Character String) with field length 1
  • BWTAR : Valuation type
    Its data type is C (Character String) with field length 10
  • XOBLR
    Its data type is C (Character String) with field length 1
  • PACKNO : Package number
    Its data type is N (Character String with Digits Only) with field length 10
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
    Its include structure/component is is /SRMERP/S_SC_ITM_D
  • AUTHOR_KEY
    Its data type is X (Byte string) with field length 16
  • REQUESTER_KEY
    Its data type is X (Byte string) with field length 16
  • FOOBJ_TYPE
    Its data type is C (Character String) with field length 4
  • BSART
    Its data type is C (Character String) with field length 4
  • ADRNR : Addresses: Address Number
    Its data type is C (Character String) with field length 10
  • ADDRESS_KEY
    Its data type is X (Byte string) with field length 16
  • TXT_EXISTS
    Its data type is C (Character String) with field length 1
  • DOC_EXISTS
    Its data type is C (Character String) with field length 1
  • FLIEF
    Its data type is C (Character String) with field length 10
  • SRM_CONTRACT_ID
    Its data type is C (Character String) with field length 10
  • SRM_CONTRACT_ITM
    Its data type is N (Character String with Digits Only) with field length 10
  • LIFNR : Vendor’s account number
    Its data type is C (Character String) with field length 10
  • INFNR : Number of purchasing info record
    Its data type is C (Character String) with field length 10
  • VRTYP
    Its data type is C (Character String) with field length 1
  • KONNR
    Its data type is C (Character String) with field length 10
  • KTPNR
    Its data type is N (Character String with Digits Only) with field length 5
  • RESWK : Supplying (issuing) plant in case of stock transport order
    Its data type is C (Character String) with field length 4
  • OBJECT_ID : Object ID
    Its data type is C (Character String) with field length 10
  • RESLO
    Its data type is C (Character String) with field length 4
  • BANFN : Purchase requisition number
    Its data type is C (Character String) with field length 10
  • BNFPO : Item number of the purchase requisition in the order
    Its data type is N (Character String with Digits Only) with field length 5
  • RSNUM : Number of reservation/dependent requirements
    Its data type is N (Character String with Digits Only) with field length 10
  • RSPOS : Item Number of Reservation / Dependent Requirements
    Its data type is N (Character String with Digits Only) with field length 4
  • APPROVAL_STATUS
    Its data type is C (Character String) with field length 2
  • DELIVERY_STATUS : ACMTST: SalesOrder Ordering Status
    Its data type is C (Character String) with field length 2
  • CONSIST_STATUS
    Its data type is C (Character String) with field length 2
  • ITM_NO
    Its data type is X (Byte string) with field length 4
  • FOLLOW_ON_STATUS
    Its data type is C (Character String) with field length 2
  • CANCELATN_STATUS
    Its data type is C (Character String) with field length 2
  • ITM_LIFEC_STATUS
    Its data type is C (Character String) with field length 2
  • CREA_DATE_TIME
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 11
  • CREA_UNAME
    Its data type is C (Character String) with field length 12
  • LCHG_DATE_TIME
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 11
  • LCHG_UNAME
    Its data type is C (Character String) with field length 12
  • /SRMERP/E_SC_ITM
    Its data type is C (Character String) with field length 1
  • ITM_TYPE
    Its data type is C (Character String) with field length 4