Table/Structure Field list used by SAP ABAP View /SRMERP/VD_SC (Database View on Shopping Cart Header and Item)
SAP ABAP View
/SRMERP/VD_SC (Database View on Shopping Cart Header and Item) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
| 1 | /SRMERP/D_SC - /SRMERP/E_SCROOT | Dummy function in length 1 | ||
| 2 | /SRMERP/D_SC - /SRMERP/E_SCROOT | Dummy function in length 1 | ||
| 3 | /SRMERP/D_SC - APPROVAL_STATUS | Approval Status | ||
| 4 | /SRMERP/D_SC - APPROVAL_STATUS | Approval Status | ||
| 5 | /SRMERP/D_SC - CANCELATN_STATUS | Cancelation Status | ||
| 6 | /SRMERP/D_SC - CANCELATN_STATUS | Cancelation Status | ||
| 7 | /SRMERP/D_SC - CONSIST_STATUS | Consistency Status | ||
| 8 | /SRMERP/D_SC - CONSIST_STATUS | Consistency Status | ||
| 9 | /SRMERP/D_SC - CREA_DATE_TIME | UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) | ||
| 10 | /SRMERP/D_SC - CREA_DATE_TIME | UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) | ||
| 11 | /SRMERP/D_SC - CREA_UNAME | User Name | ||
| 12 | /SRMERP/D_SC - CREA_UNAME | User Name | ||
| 13 | /SRMERP/D_SC - CURR_MAX_ITM_NO | Maximum Current Internal Item Number for SC Item | ||
| 14 | /SRMERP/D_SC - CURR_MAX_ITM_NO | Maximum Current Internal Item Number for SC Item | ||
| 15 | /SRMERP/D_SC - DB_KEY | NodeID | ||
| 16 | /SRMERP/D_SC - DB_KEY | NodeID | ||
| 17 | /SRMERP/D_SC - DELIVERY_STATUS | Delivery Status | ||
| 18 | /SRMERP/D_SC - DELIVERY_STATUS | Delivery Status | ||
| 19 | /SRMERP/D_SC - DOCUMENT_TYPE | Purchasing Document Type | ||
| 20 | /SRMERP/D_SC - DOCUMENT_TYPE | Purchasing Document Type | ||
| 21 | /SRMERP/D_SC - FOLLOW_ON_STATUS | Follow-On Status | ||
| 22 | /SRMERP/D_SC - FOLLOW_ON_STATUS | Follow-On Status | ||
| 23 | /SRMERP/D_SC - ITM_COUNT | Number of Items in a Shopping Cart | ||
| 24 | /SRMERP/D_SC - ITM_COUNT | Number of Items in a Shopping Cart | ||
| 25 | /SRMERP/D_SC - LCHG_DATE_TIME | UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) | ||
| 26 | /SRMERP/D_SC - LCHG_DATE_TIME | UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) | ||
| 27 | /SRMERP/D_SC - LCHG_UNAME | User Name | ||
| 28 | /SRMERP/D_SC - LCHG_UNAME | User Name | ||
| 29 | /SRMERP/D_SC - LIFECYCLE_STATUS | Shopping Cart Life Cycle | ||
| 30 | /SRMERP/D_SC - LIFECYCLE_STATUS | Shopping Cart Life Cycle | ||
| 31 | /SRMERP/D_SC - MANDT | Client | ||
| 32 | /SRMERP/D_SC - MANDT | Client | ||
| 33 | /SRMERP/D_SC - OBJECT_ID | Object ID - Document Number | ||
| 34 | /SRMERP/D_SC - OBJECT_ID | Object ID - Document Number | ||
| 35 | /SRMERP/D_SC - TOTAL_VAL_NET | Total Net Value of Shopping Cart | ||
| 36 | /SRMERP/D_SC - TOTAL_VAL_NET | Total Net Value of Shopping Cart | ||
| 37 | /SRMERP/D_SC - WAERS | Document currency | ||
| 38 | /SRMERP/D_SC - WAERS | Document currency | ||
| 39 | /SRMERP/D_SC_ITM - /SRMERP/E_SC_ITM | Dummy function in length 1 | ||
| 40 | /SRMERP/D_SC_ITM - /SRMERP/E_SC_ITM | Dummy function in length 1 | ||
| 41 | /SRMERP/D_SC_ITM - ADDRESS_KEY | NodeID | ||
| 42 | /SRMERP/D_SC_ITM - ADDRESS_KEY | NodeID | ||
| 43 | /SRMERP/D_SC_ITM - ADRNR | Address number | ||
| 44 | /SRMERP/D_SC_ITM - ADRNR | Address number | ||
| 45 | /SRMERP/D_SC_ITM - APPROVAL_STATUS | Approval Status | ||
| 46 | /SRMERP/D_SC_ITM - APPROVAL_STATUS | Approval Status | ||
| 47 | /SRMERP/D_SC_ITM - AUTHOR_KEY | Author | ||
| 48 | /SRMERP/D_SC_ITM - AUTHOR_KEY | Author | ||
| 49 | /SRMERP/D_SC_ITM - BEDNR | Requirement Tracking Number | ||
| 50 | /SRMERP/D_SC_ITM - BEDNR | Requirement Tracking Number | ||
| 51 | /SRMERP/D_SC_ITM - BMEIN | Order unit | ||
| 52 | /SRMERP/D_SC_ITM - BMEIN | Order unit | ||
| 53 | /SRMERP/D_SC_ITM - BWTAR | Valuation type | ||
| 54 | /SRMERP/D_SC_ITM - BWTAR | Valuation type | ||
| 55 | /SRMERP/D_SC_ITM - CANCELATN_STATUS | Cancelation Status | ||
| 56 | /SRMERP/D_SC_ITM - CANCELATN_STATUS | Cancelation Status | ||
| 57 | /SRMERP/D_SC_ITM - CATALOG_ID | Technical Key of a Web Service (for Example - a Catalog) | ||
| 58 | /SRMERP/D_SC_ITM - CATALOG_ID | Technical Key of a Web Service (for Example - a Catalog) | ||
| 59 | /SRMERP/D_SC_ITM - CONSIST_STATUS | Consistency Status | ||
| 60 | /SRMERP/D_SC_ITM - CONSIST_STATUS | Consistency Status | ||
| 61 | /SRMERP/D_SC_ITM - CREA_DATE_TIME | UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) | ||
| 62 | /SRMERP/D_SC_ITM - CREA_DATE_TIME | UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) | ||
| 63 | /SRMERP/D_SC_ITM - CREA_UNAME | User Name | ||
| 64 | /SRMERP/D_SC_ITM - CREA_UNAME | User Name | ||
| 65 | /SRMERP/D_SC_ITM - DB_KEY | NodeID | ||
| 66 | /SRMERP/D_SC_ITM - DB_KEY | NodeID | ||
| 67 | /SRMERP/D_SC_ITM - DELIVERY_STATUS | Delivery Status | ||
| 68 | /SRMERP/D_SC_ITM - DELIVERY_STATUS | Delivery Status | ||
| 69 | /SRMERP/D_SC_ITM - EKGRP | Purchasing group | ||
| 70 | /SRMERP/D_SC_ITM - EKGRP | Purchasing group | ||
| 71 | /SRMERP/D_SC_ITM - EKORG | Purchasing organization | ||
| 72 | /SRMERP/D_SC_ITM - EKORG | Purchasing organization | ||
| 73 | /SRMERP/D_SC_ITM - EMATN | Material number corresponding to manufacturer part number | ||
| 74 | /SRMERP/D_SC_ITM - EMATN | Material number corresponding to manufacturer part number | ||
| 75 | /SRMERP/D_SC_ITM - EMNFR | External manufacturer code name or number | ||
| 76 | /SRMERP/D_SC_ITM - EMNFR | External manufacturer code name or number | ||
| 77 | /SRMERP/D_SC_ITM - FLIEF | Fixed vendor | ||
| 78 | /SRMERP/D_SC_ITM - FLIEF | Fixed vendor | ||
| 79 | /SRMERP/D_SC_ITM - FOLLOW_ON_STATUS | Follow-On Status | ||
| 80 | /SRMERP/D_SC_ITM - FOLLOW_ON_STATUS | Follow-On Status | ||
| 81 | /SRMERP/D_SC_ITM - IDNLF | Material Number Used by Vendor | ||
| 82 | /SRMERP/D_SC_ITM - IDNLF | Material Number Used by Vendor | ||
| 83 | /SRMERP/D_SC_ITM - INFNR | Number of purchasing info record | ||
| 84 | /SRMERP/D_SC_ITM - INFNR | Number of purchasing info record | ||
| 85 | /SRMERP/D_SC_ITM - ITM_LIFEC_STATUS | Life Cycle of Shopping Cart Item | ||
| 86 | /SRMERP/D_SC_ITM - ITM_LIFEC_STATUS | Life Cycle of Shopping Cart Item | ||
| 87 | /SRMERP/D_SC_ITM - ITM_NO | Internal Shopping Cart Item Number | ||
| 88 | /SRMERP/D_SC_ITM - ITM_NO | Internal Shopping Cart Item Number | ||
| 89 | /SRMERP/D_SC_ITM - ITM_TYPE | Item Type | ||
| 90 | /SRMERP/D_SC_ITM - ITM_TYPE | Item Type | ||
| 91 | /SRMERP/D_SC_ITM - KNTTP | Account assignment category | ||
| 92 | /SRMERP/D_SC_ITM - KNTTP | Account assignment category | ||
| 93 | /SRMERP/D_SC_ITM - KONNR | Number of principal purchase agreement | ||
| 94 | /SRMERP/D_SC_ITM - KONNR | Number of principal purchase agreement | ||
| 95 | /SRMERP/D_SC_ITM - KTPNR | Item number of principal purchase agreement | ||
| 96 | /SRMERP/D_SC_ITM - KTPNR | Item number of principal purchase agreement | ||
| 97 | /SRMERP/D_SC_ITM - KZBWS | Valuation of Special Stock | ||
| 98 | /SRMERP/D_SC_ITM - KZBWS | Valuation of Special Stock | ||
| 99 | /SRMERP/D_SC_ITM - KZVBR | Consumption posting | ||
| 100 | /SRMERP/D_SC_ITM - KZVBR | Consumption posting | ||
| 101 | /SRMERP/D_SC_ITM - LCHG_DATE_TIME | UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) | ||
| 102 | /SRMERP/D_SC_ITM - LCHG_DATE_TIME | UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) | ||
| 103 | /SRMERP/D_SC_ITM - LCHG_UNAME | User Name | ||
| 104 | /SRMERP/D_SC_ITM - LCHG_UNAME | User Name | ||
| 105 | /SRMERP/D_SC_ITM - LFDAT | Delivery date | ||
| 106 | /SRMERP/D_SC_ITM - LFDAT | Delivery date | ||
| 107 | /SRMERP/D_SC_ITM - LGORT | Storage location | ||
| 108 | /SRMERP/D_SC_ITM - LGORT | Storage location | ||
| 109 | /SRMERP/D_SC_ITM - LIFNR | Desired vendor | ||
| 110 | /SRMERP/D_SC_ITM - LIFNR | Desired vendor | ||
| 111 | /SRMERP/D_SC_ITM - LPEIN | Category of delivery date | ||
| 112 | /SRMERP/D_SC_ITM - LPEIN | Category of delivery date | ||
| 113 | /SRMERP/D_SC_ITM - MATKL | Material Group | ||
| 114 | /SRMERP/D_SC_ITM - MATKL | Material Group | ||
| 115 | /SRMERP/D_SC_ITM - MATNR | Material Number | ||
| 116 | /SRMERP/D_SC_ITM - MATNR | Material Number | ||
| 117 | /SRMERP/D_SC_ITM - MEINS | Order Unit of Measure | ||
| 118 | /SRMERP/D_SC_ITM - MEINS | Order Unit of Measure | ||
| 119 | /SRMERP/D_SC_ITM - MENGE | Order Quantity | ||
| 120 | /SRMERP/D_SC_ITM - MENGE | Order Quantity | ||
| 121 | /SRMERP/D_SC_ITM - MFRNR | Manufacturer number | ||
| 122 | /SRMERP/D_SC_ITM - MFRNR | Manufacturer number | ||
| 123 | /SRMERP/D_SC_ITM - MFRPN | Manufacturer Part Number | ||
| 124 | /SRMERP/D_SC_ITM - MFRPN | Manufacturer Part Number | ||
| 125 | /SRMERP/D_SC_ITM - MPROF | Mfr part profile | ||
| 126 | /SRMERP/D_SC_ITM - MPROF | Mfr part profile | ||
| 127 | /SRMERP/D_SC_ITM - NETFW | Net Amount in Foreign Currency | ||
| 128 | /SRMERP/D_SC_ITM - NETFW | Net Amount in Foreign Currency | ||
| 129 | /SRMERP/D_SC_ITM - NETPR | Net Price in Purchasing Document (in Document Currency) | ||
| 130 | /SRMERP/D_SC_ITM - NETPR | Net Price in Purchasing Document (in Document Currency) | ||
| 131 | /SRMERP/D_SC_ITM - NETWR | Net Value in Document Currency | ||
| 132 | /SRMERP/D_SC_ITM - NETWR | Net Value in Document Currency | ||
| 133 | /SRMERP/D_SC_ITM - PACKNO | Package number | ||
| 134 | /SRMERP/D_SC_ITM - PACKNO | Package number | ||
| 135 | /SRMERP/D_SC_ITM - PARENT_KEY | NodeID | ||
| 136 | /SRMERP/D_SC_ITM - PARENT_KEY | NodeID | ||
| 137 | /SRMERP/D_SC_ITM - PEINH | Price unit | ||
| 138 | /SRMERP/D_SC_ITM - PEINH | Price unit | ||
| 139 | /SRMERP/D_SC_ITM - PLIFZ | Planned delivery time in days | ||
| 140 | /SRMERP/D_SC_ITM - PLIFZ | Planned delivery time in days | ||
| 141 | /SRMERP/D_SC_ITM - REPOS | Invoice receipt indicator | ||
| 142 | /SRMERP/D_SC_ITM - REPOS | Invoice receipt indicator | ||
| 143 | /SRMERP/D_SC_ITM - REQUESTER_KEY | Requester | ||
| 144 | /SRMERP/D_SC_ITM - REQUESTER_KEY | Requester | ||
| 145 | /SRMERP/D_SC_ITM - RESLO | Issuing Storage Location for Stock Transport Order | ||
| 146 | /SRMERP/D_SC_ITM - RESLO | Issuing Storage Location for Stock Transport Order | ||
| 147 | /SRMERP/D_SC_ITM - RESWK | Supplying (issuing) plant in case of stock transport order | ||
| 148 | /SRMERP/D_SC_ITM - RESWK | Supplying (issuing) plant in case of stock transport order | ||
| 149 | /SRMERP/D_SC_ITM - SOBKZ | Special Stock Indicator | ||
| 150 | /SRMERP/D_SC_ITM - SOBKZ | Special Stock Indicator | ||
| 151 | /SRMERP/D_SC_ITM - SRM_CONTRACT_ID | Central Contract | ||
| 152 | /SRMERP/D_SC_ITM - SRM_CONTRACT_ID | Central Contract | ||
| 153 | /SRMERP/D_SC_ITM - SRM_CONTRACT_ITM | Central Contract Item Number | ||
| 154 | /SRMERP/D_SC_ITM - SRM_CONTRACT_ITM | Central Contract Item Number | ||
| 155 | /SRMERP/D_SC_ITM - TWRKZ | Partial invoice indicator | ||
| 156 | /SRMERP/D_SC_ITM - TWRKZ | Partial invoice indicator | ||
| 157 | /SRMERP/D_SC_ITM - TXZ01 | Short Text | ||
| 158 | /SRMERP/D_SC_ITM - TXZ01 | Short Text | ||
| 159 | /SRMERP/D_SC_ITM - VRTKZ | Distribution indicator for multiple account assignment | ||
| 160 | /SRMERP/D_SC_ITM - VRTKZ | Distribution indicator for multiple account assignment | ||
| 161 | /SRMERP/D_SC_ITM - VRTYP | Purchasing document category | ||
| 162 | /SRMERP/D_SC_ITM - VRTYP | Purchasing document category | ||
| 163 | /SRMERP/D_SC_ITM - WAERS | Currency Key | ||
| 164 | /SRMERP/D_SC_ITM - WAERS | Currency Key | ||
| 165 | /SRMERP/D_SC_ITM - WEPOS | Goods Receipt Indicator | ||
| 166 | /SRMERP/D_SC_ITM - WEPOS | Goods Receipt Indicator | ||
| 167 | /SRMERP/D_SC_ITM - WERKS | Plant | ||
| 168 | /SRMERP/D_SC_ITM - WERKS | Plant | ||
| 169 | /SRMERP/D_SC_ITM - WEUNB | Goods Receipt, Non-Valuated | ||
| 170 | /SRMERP/D_SC_ITM - WEUNB | Goods Receipt, Non-Valuated | ||
| 171 | /SRMERP/D_SC_ITM - WKURS | Exchange Rate | ||
| 172 | /SRMERP/D_SC_ITM - WKURS | Exchange Rate | ||
| 173 | /SRMERP/D_SC_ITM - XOBLR | Item affects commitments | ||
| 174 | /SRMERP/D_SC_ITM - XOBLR | Item affects commitments |