/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".
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 |
---|---|---|---|---|---|---|
MANDT | Client | X | MANDT | CLNT | 6 | |
DB_KEY | NodeID | X | /BOBF/CONF_KEY | RAW | 16 | |
PARENT_KEY | NodeID | /BOBF/CONF_KEY | RAW | 16 | ||
NODE_CAT_KEY | NodeID | /BOBF/CONF_KEY | RAW | 16 | ||
.INCLUDE | /SRMERP/S_SC_ITM_D | 0 | ||||
.INCLUDE | ITM_BASE | /SRMERP/S_SC_ITM_BASE | 0 | |||
OBJECT_ID | Object ID - Document Number | /SRMERP/OBJECT_ID | CHAR | 20 | ||
ITM_NO | Internal Shopping Cart Item Number | /SRMERP/SC_ITM_NO | INT4 | 4 | ||
ITM_TYPE | Item Type | /SRMERP/SC_ITEM_TYPE | CHAR | 8 | ||
.INCLUDE | /SRMERP/S_PROD_ITM_COMMON | 0 | ||||
TXZ01 | Short Text | TXZ01 | CHAR | 80 | ||
MATNR | Material Number | MATNR | CHAR | 80 | ||
MENGE | Order Quantity | /SRMERP/ORDER_QTY | QUAN | 7 | ||
MEINS | Order Unit of Measure | /SRMERP/ORDER_UOM | UNIT | 6 | * | |
NETPR | Net Price in Purchasing Document (in Document Currency) | BPREI | CURR | 6 | ||
PEINH | Price unit | EPEIN | DEC | 3 | ||
EKORG | Purchasing organization | EKORG | CHAR | 8 | * | |
EKGRP | Purchasing Group | EKGRP | CHAR | 6 | * | |
LGORT | Storage location | LGORT_D | CHAR | 8 | * | |
BEDNR | Requirement Tracking Number | BEDNR | CHAR | 20 | ||
WAERS | Currency Key | WAERS | CUKY | 10 | * | |
MATKL | Material Group | MATKL | CHAR | 18 | ||
WERKS | Plant | EWERK | CHAR | 8 | * | |
CATALOG_ID | Technical Key of a Web Service (for Example - a Catalog) | WSI_SERVICE_ID | CHAR | 40 | ||
PLIFZ | Planned Delivery Time in Days | PLIFZ | DEC | 2 | ||
EMATN | Material number corresponding to manufacturer part number | EMATN | CHAR | 80 | * | |
IDNLF | Material Number Used by Supplier | IDNLF | CHAR | 70 | ||
MPROF | Mfr part profile | MPROF | CHAR | 8 | * | |
MFRPN | Manufacturer Part Number | MFRPN | CHAR | 80 | ||
MFRNR | Manufacturer number | MFRNR | CHAR | 20 | * | |
EMNFR | External manufacturer code name or number | EMNFR | CHAR | 20 | ||
BMEIN | Purchase Order Unit of Measure | BSTME | UNIT | 6 | * | |
NETWR | Net Value in Document Currency | NETWR | CURR | 8 | ||
NETFW | Net Amount in Foreign Currency | NETFW_CS | CURR | 7 | ||
WKURS | Exchange Rate | WKURS | DEC | 5 | ||
LPEIN | Category of delivery date | LPEIN | CHAR | 2 | * | |
LFDAT | Delivery date | LFDAT | DATS | 16 | ||
KNTTP | Account Assignment Category | KNTTP | CHAR | 2 | * | |
KZVBR | Consumption posting | KZVBR | CHAR | 2 | ||
VRTKZ | Distribution Indicator for Multiple Account Assignment | VRTKZ | CHAR | 2 | ||
TWRKZ | Partial invoice indicator | TWRKZ | CHAR | 2 | ||
WEPOS | Goods Receipt Indicator | WEPOS | CHAR | 2 | ||
WEUNB | Goods Receipt, Non-Valuated | WEUNB | CHAR | 2 | ||
REPOS | Invoice receipt indicator | REPOS | CHAR | 2 | ||
SOBKZ | Special Stock Indicator | SOBKZ | CHAR | 2 | * | |
KZBWS | Valuation of Special Stock | KZBWS | CHAR | 2 | ||
BWTAR | Valuation Type | BWTAR_D | CHAR | 20 | * | |
XOBLR | Item affects commitments | XOBLR | CHAR | 2 | ||
PACKNO | Package number | PACKNO | NUMC | 20 | * | |
AUTHOR_KEY | Author | /SRMERP/AUTHOR_KEY | RAW | 16 | ||
REQUESTER_KEY | Requester | /SRMERP/REQUESTER_KEY | RAW | 16 | ||
FOOBJ_TYPE | Follow-On Object Type | /SRMERP/FOLLOW_ON_OBJ_TYPE | CHAR | 8 | ||
BSART | Purchasing Document Type | ESART | CHAR | 8 | * | |
.INCLUDE | ADDRESS_DATA | /SRMERP/S_ADDRESS_COMMON | 0 | |||
ADRNR | Address Number | AD_ADDRNUM | CHAR | 20 | * | |
ADDRESS_KEY | NodeID | /BOBF/CONF_KEY | RAW | 16 | ||
TXT_EXISTS | Text Exists | /SRMERP/TXT_EXISTS_IND | CHAR | 2 | ||
DOC_EXISTS | Document Exists | /SRMERP/DOC_EXISTS_IND | CHAR | 2 | ||
.INCLUDE | SOS_DATA | /SRMERP/S_SC_SOURCE_OF_SUPPLY | 0 | |||
.INCLUDE | /SRMERP/S_SOS_COMMON | 0 | ||||
FLIEF | Fixed Vendor | FLIEF | CHAR | 20 | LFA1 | |
SRM_CONTRACT_ID | Central Contract | SRM_CONTRACT_ID | CHAR | 20 | ||
SRM_CONTRACT_ITM | Central Contract Item Number | SRM_CONTRACT_ITEM | NUMC | 20 | ||
LIFNR | Desired Vendor | WLIEF | CHAR | 20 | LFA1 | |
INFNR | Number of purchasing info record | INFNR | CHAR | 20 | EINA | |
VRTYP | Purchasing Document Category | BSTYP | CHAR | 2 | ||
KONNR | Number of principal purchase agreement | KONNR | CHAR | 20 | EKKO | |
KTPNR | Item number of principal purchase agreement | KTPNR | NUMC | 10 | EKPO | |
RESWK | Supplying (issuing) plant in case of stock transport order | RESWK | CHAR | 8 | * | |
RESLO | Issuing Storage Location for Stock Transport Order | RESLO | CHAR | 8 | * | |
.INCLUDE | FOD | /SRMERP/S_SC_ITM_FOD | 0 | |||
BANFN | Purchase Requisition Number | BANFN | CHAR | 20 | ||
BNFPO | Item number of purchase requisition | BNFPO | NUMC | 10 | * | |
RSNUM | Number of reservation/dependent requirements | RSNUM | NUMC | 20 | * | |
RSPOS | Item Number of Reservation / Dependent Requirements | RSPOS | NUMC | 8 | ||
.INCLUDE | STATUS | /SRMERP/S_SC_ITM_STATUS | 0 | |||
APPROVAL_STATUS | Approval Status | /SRMERP/STATUS_APPROVAL | CHAR | 4 | ||
DELIVERY_STATUS | Delivery Status | /SRMERP/STATUS_DELIVERY | CHAR | 4 | ||
CONSIST_STATUS | Consistency Status | /SRMERP/STATUS_CONSISTENCY | CHAR | 4 | ||
FOLLOW_ON_STATUS | Follow-On Status | /SRMERP/STATUS_FOLLOW_ON | CHAR | 4 | ||
CANCELATN_STATUS | Cancelation Status | /SRMERP/STATUS_CANCELATION | CHAR | 4 | ||
ITM_LIFEC_STATUS | Life Cycle of Shopping Cart Item | /SRMERP/SC_STATUS_ITM_LIFE_CYC | CHAR | 4 | ||
.INCLUDE | ADMIN_DATA | /BOBF/S_LIB_ADMIN_DATA | 0 | |||
CREA_DATE_TIME | UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) | TIMESTAMPL | DEC | 11 | ||
CREA_UNAME | User Name | UNAME | CHAR | 24 | ||
LCHG_DATE_TIME | UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) | TIMESTAMPL | DEC | 11 | ||
LCHG_UNAME | User Name | UNAME | CHAR | 24 | ||
.INCLUDE | INCL_EEW | /SRMERP/INCL_EEW_SC_ITM | 0 | |||
/SRMERP/E_SC_ITM | Dummy function in length 1 | DUMMY | CHAR | 2 |