SAP MCRBITM Table in S/4 HANA - Item Data
MCRBITM is a standard SAP Table which is used to store Item Data data and is available within SAP S/4 HANA systems and previous ECC R/3 systems. Below is the technical details and the field list relevant for an SAP S/4 HANA system, see here for details and fields available within the SAP R/3 version of the MCRBITM table(ECC)
Delivery Class:
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Can Be Enhanced (Deep)
Dictionary Type: Structure
Database Table: MCRBITM
MCRBITM table structure field list
Below is the full MCRBITM field list that makes up the SAP database table structure, including key fields, description, data type and other technical details of each field
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP | SHLP Field |
MANDT | Client | MANDT | CLNT | 3(0) | T000 | MANDT | ||||
BELNR | Accounting Document Number | BELNR_D | CHAR | 10(0) | ALPHA | BELNR | BLN | |||
GJAHR | Fiscal Year | GJAHR | NUMC | 4(0) | GJAHR | GJAHR | GJR | |||
BUZEI | Document Item in Invoice Document | RBLGP | NUMC | 6(0) | NUMC6 | |||||
EBELN | Purchasing Document Number | EBELN | CHAR | 10(0) | EKKO | ALPHA | EBELN | BES | MEKK_C | EBELN |
EBELP | Item Number of Purchasing Document | EBELP | NUMC | 5(0) | EKPO | EBELP | BSP | |||
ZEKKN | Sequential Number of Account Assignment | DZEKKN | NUMC | 2(0) | NUM02 | |||||
MATNR | Material Number | MATNR | CHAR | 40(0) | MARA | MATN1 | MATNR | MAT | S_MAT1 | MATNR |
BWKEY | Valuation area | BWKEY | CHAR | 4(0) | T001K | BWKEY | BWK | |||
BWTAR | Valuation Type | BWTAR_D | CHAR | 10(0) | T149D | BWTAR | BWT | |||
BUKRS | Company Code | BUKRS | CHAR | 4(0) | T001 | BUKRS | BUK | C_T001 | BUKRS | |
WERKS | Plant | WERKS_D | CHAR | 4(0) | T001W | WERKS | WRK | H_T001W_C | WERKS | |
WRBTR | Amount in Document Currency | WRBTR_CS | CURR | 13(2) | WERT7 | |||||
SHKZG | Debit/Credit Indicator | SHKZG | CHAR | 1(0) | SHKZG | |||||
MWSKZ | Tax on sales/purchases code | MWSKZ | CHAR | 2(0) | T007A | MWSKZ | ||||
TXJCD | Tax Jurisdiction | TXJCD | CHAR | 15(0) | TTXJ | TXJCD | TXJ | |||
MENGE | Quantity | MENGE_D | QUAN | 13(3) | MENG13 | |||||
BSTME | Purchase Order Unit of Measure | BSTME | UNIT | 3(0) | T006 | CUNIT | MEINS | |||
BPMNG | Quantity in Purchase Order Price Unit | BPMNG | QUAN | 13(3) | MENG13 | |||||
BPRME | Order Price Unit (Purchasing) | BPRME | UNIT | 3(0) | T006 | CUNIT | MEINS | |||
LBKUM | Total Valuated Stock | LBKUM | QUAN | 13(3) | MENG13V | |||||
VRKUM | Total valuated stock in the previous posting period | VRKUM | QUAN | 13(3) | MENG13V | |||||
MEINS | Base Unit of Measure | MEINS | UNIT | 3(0) | T006 | CUNIT | MEINS | |||
PSTYP | Item category in purchasing document | PSTYP | CHAR | 1(0) | T163 | PSTYP | ||||
KNTTP | Account Assignment Category | KNTTP | CHAR | 1(0) | T163K | KNTTP | KNT | |||
BKLAS | Valuation Class | BKLAS | CHAR | 4(0) | T025 | BKLAS | ||||
EREKZ | Final Invoice Indicator | EREKZ | CHAR | 1(0) | XFELD | |||||
EXKBE | Indicator: update purchase order history | XEKBE | CHAR | 1(0) | XFELD | |||||
XEKBZ | Indicator: Update Purchase Order Delivery Costs | XEKBZ | CHAR | 1(0) | XFELD | |||||
TBTKZ | Indicator: Subsequent Debit/Credit | TBTKZ | CHAR | 1(0) | TBTKZ | |||||
SPGRP | Blocking Reason: Price | SPGRP | CHAR | 1(0) | XFELD | |||||
SPGRM | Blocking Reason: Quantity | SPGRM | CHAR | 1(0) | XFELD | |||||
SPGRT | Blocking Reason: Date | SPGRT | CHAR | 1(0) | XFELD | |||||
SPGRG | Blocking Reason: Order Price Quantity | SPGRG | CHAR | 1(0) | XFELD | |||||
SPGRV | Blocking Reason: Project Budget | SPGRV | CHAR | 1(0) | XFELD | |||||
SPGRQ | Manual Blocking Reason | SPGRQ | CHAR | 1(0) | XFELD | |||||
SPGRS | Blocking Reason: Item Amount | SPGRS | CHAR | 1(0) | XFELD | |||||
SPGRC | Blocking Reason: Quality | SPGRC | CHAR | 1(0) | XFELD | |||||
SPGREXT | Blocking Reason Enhancement Fields | SPGREXT | CHAR | 1(0) | XFELD | |||||
BUSTW | Posting String for Values | BUSTW | CHAR | 4(0) | BUSTW | |||||
XBLNR | Reference Document Number | XBLNR1 | CHAR | 16(0) | XBLNR1 | |||||
XRUEB | Indicator: Document Is Posted to a Previous Period | XRUEB | CHAR | 1(0) | XFELD | |||||
BNKAN | Delivery costs' share of item value | BNK_ANTEIL | CURR | 13(2) | WERT7 | |||||
KSCHL | Condition type | KSCHL | CHAR | 4(0) | Assigned to domain | KSCHL | VKS | |||
SALK3 | Value of Total Valuated Stock | SALK3 | CURR | 13(2) | WERT13N | |||||
VMSAL | Value of total valuated stock in previous period | VMSAL | CURR | 13(2) | WERT13N | |||||
XLIFO | LIFO/FIFO-Relevant | XLIFO | CHAR | 1(0) | LIFO_FIFO | |||||
LFBNR | Document No. of a Reference Document | LFBNR | CHAR | 10(0) | ALPHA | BELNR | ||||
LFGJA | Fiscal Year of Current Period | LFGJA | NUMC | 4(0) | GJAHR | GJAHR | ||||
LFPOS | Item of a Reference Document | LFPOS | NUMC | 4(0) | MBLPO | |||||
MATBF | Material in Respect of Which Stock is Managed | MATBF | CHAR | 40(0) | Assigned to domain | MATN1 | MATNR | |||
RBMNG | Quantity Invoiced in Supplier Invoice in PO Order Units | RBMNG | QUAN | 13(3) | MENG13V | |||||
BPRBM | Quantity Invoiced in Supplier Invoice in PO Price Units | BPRBM | QUAN | 13(3) | MENG13V | |||||
RBWWR | Invoice Amount in Document Currency of Supplier Invoice | RBWWR | CURR | 13(2) | WERT7 | |||||
LFEHL | Type of Supplier Error | LFEHL | CHAR | 1(0) | LFEHL | |||||
GRICD | Activity Code for Gross Income Tax | J_1AGICD_D | CHAR | 2(0) | J_1AGICD | J_1AGICD2 | ||||
GRIRG | Region (State, Province, County) | REGIO | CHAR | 3(0) | T005S | REGIO | ||||
GITYP | Distribution Type for Employment Tax | J_1ADTYP_D | CHAR | 2(0) | J_1ADTYP | J_1ADTYP | ||||
PACKNO | Package Number of Service | PACKNO_EKBE | NUMC | 10(0) | Assigned to domain | PACKNO | ||||
INTROW | Line Number of Service | INTROW_EKBE | NUMC | 10(0) | INTROW | |||||
SGTXT | Item Text | SGTXT | CHAR | 50(0) | TEXT50 | |||||
XSKRL | Indicator: Line Item Not Liable to Cash Discount? | XSKRL | CHAR | 1(0) | XFELD | |||||
KZMEK | Correction indicator | KZMEKORR | CHAR | 1(0) | KZMEKORR | |||||
MRMOK | Indicator: Invoice Item Processed | MRMOK | CHAR | 1(0) | XFELD | |||||
STUNR | Step Number | STUNR | NUMC | 3(0) | Assigned to domain | STUNR | ||||
ZAEHK | Condition Counter | DZAEHK | NUMC | 3(0) | ZAEHK | |||||
STOCK_POSTING | Stock Posting of Line from an Incoming Invoice | STOCK_POSTING | CURR | 13(2) | WRTV7 | |||||
STOCK_POSTING_PP | Stock Posting of Line from an Incoming Invoice, Prev. Period | STOCK_POSTING_PP | CURR | 13(2) | WRTV7 | |||||
STOCK_POSTING_PY | Stock Posting of Line from an Incoming Invoice, Prev. Year | STOCK_POSTING_PY | CURR | 13(2) | WRTV7 | |||||
WEREC | Clearing Indicator for GR/IR Posting for External Services | MMWEREC | CHAR | 1(0) | XFELD | |||||
LIFNR | Account Number of Vendor or Creditor | LIFNR | CHAR | 10(0) | ALPHA | LIFNR | LIF | KRED_C | LIFNR | |
FRBNR | Number of Bill of Lading at Time of Goods Receipt | FRBNR1 | CHAR | 16(0) | XBLNR1 | |||||
XHISTMA | Update Multiple Account Assignment EKBE_MA, EKBZ_MA | XHISTMA | CHAR | 1(0) | CHAR1 | |||||
COMPLAINT_REASON | Complaints Reason in an Invoice | COMPLAINT_REASON | CHAR | 2(0) | Assigned to domain | COMPLAINT_REASON | ||||
RETAMT_FC | Retention Amount in Document Currency | RET_AMT_FC | CURR | 13(2) | WERT7 | |||||
RETPC | Retention in Percent | RETPZ | DEC | 5(2) | PRZ32 | |||||
RETDUEDT | Due Date for Retention | RET_DUE_DATE | DATS | 8(0) | DATUM | |||||
XRETTAXNET | Tax Reduction for Retention | RET_TAXNET | CHAR | 1(0) | XFELD | |||||
RE_ACCOUNT | Cash Ledger: Expense or Revenue Account | FAGL_RE_ACCOUNT | CHAR | 10(0) | Assigned to domain | ALPHA | SAKNR | |||
ERP_CONTRACT_ID | Number of principal purchase agreement | KONNR | CHAR | 10(0) | Assigned to domain | ALPHA | EBELN | KTR | ||
ERP_CONTRACT_ITM | Item number of principal purchase agreement | KTPNR | NUMC | 5(0) | Assigned to domain | EBELP | ||||
SRM_CONTRACT_ID | Central Contract | SRM_CONTRACT_ID | CHAR | 10(0) | ALPHA | BBP_BAPI_EBELN | MMBSI_MEKK_CC | SRM_CONTRACT_ID | ||
SRM_CONTRACT_ITM | Central Contract Item Number | SRM_CONTRACT_ITEM | NUMC | 10(0) | BBP_ITEMNO | |||||
CONT_PSTYP | Item category in purchasing document | PSTYP | CHAR | 1(0) | Assigned to domain | PSTYP | ||||
SRVMAPKEY | Item Key for eSOA Messages | SRVMAPKEY | NUMC | 10(0) | ||||||
CHARG | Batch Number | CHARG_D | CHAR | 10(0) | Assigned to domain | CHARG | CHA | |||
INV_ITM_ORIGIN | Origin of an Invoice Item | INV_ITM_ORIGIN | CHAR | 1(0) | INV_ITM_ORIGIN | |||||
INVREL | Grouping Characteristic for Invoice Verification | INVREL | NUMC | 6(0) | NUMC6 | |||||
XDINV | Indicator for Differential Invoicing | XDINV | CHAR | 1(0) | CHAR1 | |||||
DIFF_AMOUNT | Difference Amount (in Document Currency) | DIFFERENCE_AMOUNT | CURR | 13(2) | ANLKWERT | |||||
XCPRF | Checkbox for Commodity Repricing in Invoice Verification | XCPRF | CHAR | 1(0) | CHAR1 | |||||
PRODUCTTYPE | Product Type Group | PRODUCT_TYPE | CHAR | 2(0) | CHAR2 | |||||
NODE_KEY | GUID: MM Supplier Invoice in S-Innovations | MRM_SI_GUID | RAW | 16(0) | MRM_SI_GUID | |||||
PARENT_KEY | GUID: MM Supplier Invoice in S-Innovations | MRM_SI_GUID | RAW | 16(0) | MRM_SI_GUID | |||||
ROOT_KEY | GUID: MM Supplier Invoice in S-Innovations | MRM_SI_GUID | RAW | 16(0) | MRM_SI_GUID | |||||
DUMMY_MMIV_SI_S_ITEM_EEW_PS | MMIV_SI_S_ITEM_INCL_EEW | MMIV_SI_S_ITEM_INCL_EEW | CHAR | 1(0) | MMIV_SI_S_ITEM_INCL_EEW | |||||
ENH_DATE1 | Start date of WKA working period | WKA_DATE1 | DATS | 8(0) | DATUM | |||||
ENH_DATE2 | End date of WKA working period | WKA_DATE2 | DATS | 8(0) | DATUM | |||||
ENH_CHAR1 | Chain Liability work description | WKA_DESCR | CHAR | 20(0) | CHAR20 | |||||
ENH_CHAR2 | Chain Liability description of construction site | WKA_DESPL | CHAR | 20(0) | CHAR20 | |||||
ENH_PERCENT | WKA: Percentage of wages | WKA_PERCENT | DEC | 5(2) | PRZ32 | |||||
ENH_NUMC1 | Working time in hours | WKA_HOURS | NUMC | 10(0) | NUM10 | |||||
/CWM/MENGE | Quantity in Parallel Unit of Measure | /CWM/MENGE | QUAN | 13(3) | MENG13 | |||||
/CWM/WEMNG | Goods Receipt Quantity in Base or Parallel Unit of Measure | /CWM/WEMNG | QUAN | 13(3) | MENG13 | |||||
/CWM/REMNG | Invoice Receipt Quantity in Base or Parallel UoM | /CWM/REMNG | QUAN | 13(3) | MENG13 | |||||
/CWM/BAMNG | Quantity in Parallel Unit of Measure | /CWM/BAMNG | QUAN | 13(3) | MENG13 | |||||
/CWM/VALUM | Valuation Unit of Measure | /CWM/VALUM | UNIT | 3(0) | Assigned to domain | CUNIT | MEINS | |||
TXDAT | Date for defining tax rates | TXDAT | DATS | 8(0) | DATUM | |||||
TXDAT_FROM | Valid-From Date of the Tax Rate | FOT_TXDAT_FROM | DATS | 8(0) | ||||||
.INCLU--AP | 0(0) | |||||||||
/NFM/SPGRK | NF Processing, Rate Blocking Reason | /NFM/SPGRK | CHAR | 1(0) | CHAR01 | |||||
EFKOR | Type of correction to own error | EFKOR | CHAR | 1(0) | EFKOR | |||||
.INCLU--AP | 0(0) | |||||||||
FSH_SEASON_YEAR | Season Year | FSH_SAISJ | CHAR | 4(0) | FSH_CJAHR | WMSAISJ | ||||
FSH_SEASON | Season | FSH_SAISO | CHAR | 10(0) | RFM_SAISO | SAISO | ||||
FSH_COLLECTION | Fashion Collection | FSH_COLLECTION | CHAR | 10(0) | Assigned to domain | FSH_COLLECTION | ||||
FSH_THEME | Fashion Theme | FSH_THEME | CHAR | 10(0) | FSH_THEME | |||||
.INCLU--AP | 0(0) | |||||||||
HSN_SAC | HSN or SAC Code | J_1IG_HSN_SAC | CHAR | 16(0) | J_1IG_HSN_SAC | |||||
CUSTOMS_VAL | Assessable Value | J_1IG_VALASS | CURR | 13(2) | WERT7 | |||||
.INCLU--AP | 0(0) | |||||||||
LICNO | Internal License Number | J_1ILICNO | NUMC | 10(0) | J_1ILICNO | |||||
ZEILE | Item Number | J_1IZEILE | NUMC | 4(0) | J_1IZEILE | |||||
.INCLU--AP | 0(0) | |||||||||
SGT_SCAT | Stock Segment | SGT_SCAT | CHAR | 40(0) | SGT_SRCA | SGT_S | SGT_CAT_FIELD_POPUP | VALUE | ||
.INCLU--AP | 0(0) | |||||||||
WRF_CHARSTC1 | Characteristic Value 1 | WRF_CHARSTC1 | CHAR | 18(0) | WRF_CHARSTC | WRF_MATNR_CHAR1 | COLOR | |||
WRF_CHARSTC2 | Characteristic Value 2 | WRF_CHARSTC2 | CHAR | 18(0) | WRF_CHARSTC | WRF_MATNR_CHAR2 | SIZE1 | |||
WRF_CHARSTC3 | Characteristic Value 3 | WRF_CHARSTC3 | CHAR | 18(0) | WRF_CHARSTC | WRF_MATNR_CHAR3 | SIZE2 | |||
BPUMZ | Numerator for Conversion of Order Price Unit into Order Unit | BPUMZ | DEC | 5(0) | UMBSZ | |||||
BPUMN | Denominator for Conv. of Order Price Unit into Order Unit | BPUMN | DEC | 5(0) | UMBSN | |||||
NETWR | Net Value in Document Currency | NETWR | CURR | 15(2) | WERTV8 | |||||
BSMNG | Quantity ordered against this purchase requisition | BSMNG | QUAN | 13(3) | MENG13 | |||||
WEMNG | Quantity of Goods Received | WEMNG | QUAN | 13(3) | MENG13 | |||||
REMNG | Quantity invoiced | REMNG | QUAN | 13(3) | MENG13 | |||||
BPREM | Invoice receipt quantity in order price unit | BPREM | QUAN | 13(3) | MENG13 | |||||
BPWEM | Goods Receipt Quantity in Purchase Order Price Unit | BPWEM | QUAN | 13(3) | MENG13 | |||||
REEWR | Invoice Value Entered (in Local Currency) | REEWR | CURR | 13(2) | WRTV7 | |||||
REFWR | Invoice Value in Foreign Currency | REFWR | CURR | 13(2) | WRTV7 | |||||
REWRT | Invoice value in local currency | REWRT | CURR | 13(2) | WRTV7 | |||||
REWWR | Invoice Amount in Foreign Currency | REWWR_CS | CURR | 13(2) | WERT7 | |||||
WENWR | Accepted net value of service in foreign currency | WENWR | CURR | 13(2) | WERT7 | |||||
WEWRT | Value of goods received in local currency | WEWRT | CURR | 13(2) | WERT7 | |||||
WEWWR | Value of goods received in foreign currency | WEWWR | CURR | 13(2) | WERT7 | |||||
NOQUANTITY | No quantity logic (document item without quantity) | NOQUANTITY | CHAR | 1(0) | XFELD | |||||
PRDIFF | Price Difference in Local Currency | PRDIFF | CURR | 13(2) | WERTV7 | |||||
AFNAM | Name of requisitioner/requester | AFNAM | CHAR | 12(0) | AFNAM | |||||
EKGRP | Purchasing Group | EKGRP | CHAR | 3(0) | Assigned to domain | EKGRP | EKG | |||
FKNUM | Shipment Cost Number | FKNUM | CHAR | 10(0) | ALPHA | FKNUM | FKK | SD_F4_SCD_ID | FKNUM | |
FKPOS | Shipment costs item | FKPOS | NUMC | 6(0) | Assigned to domain | FKPOS | ||||
FPLNR | Invoicing plan number | IPLNR | CHAR | 10(0) | CHAR10 | |||||
HWAER | Currency Key | WAERS | CUKY | 5(0) | Assigned to domain | WAERS | FWS | |||
LEBRE | Indicator for Service-Based Invoice Verification | LEBRE | CHAR | 1(0) | XFELD | |||||
MATKL | Material Group | MATKL | CHAR | 9(0) | MATKL | MKL | S_WBWG | MATKL | ||
NETPR | Net Price in Purchasing Document (in Document Currency) | BPREI | CURR | 11(2) | WERT11 | |||||
PEINH | Price unit | PEINH | DEC | 5(0) | PACK3 | |||||
REPOS | Invoice receipt indicator | REPOS | CHAR | 1(0) | XFELD | |||||
RETPO | Returns Item | RETPO | CHAR | 1(0) | XFELD | |||||
TXZ01 | Short Text | TXZ01 | CHAR | 40(0) | TEXT40 | |||||
WEBRE | Indicator: GR-Based Invoice Verification | WEBRE | CHAR | 1(0) | XFELD | |||||
ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12(0) | USNAM | |||||
EKORG | Purchasing organization | EKORG | CHAR | 4(0) | Assigned to domain | EKORG | EKO | |||
LIFNR2 | Vendor's account number | ELIFN | CHAR | 10(0) | ALPHA | LIFNR | LIF | KRED_C | LIFNR | |
KZBWS | Valuation of Special Stock | KZBWS | CHAR | 1(0) | KZBWS | |||||
KTPNR | Item number of principal purchase agreement | KTPNR | NUMC | 5(0) | Assigned to domain | EBELP | ||||
KONNR | Number of principal purchase agreement | KONNR | CHAR | 10(0) | Assigned to domain | ALPHA | EBELN | KTR | ||
WEUNB | Goods Receipt, Non-Valuated | WEUNB | CHAR | 1(0) | XFELD | |||||
WEPOS | Goods Receipt Indicator | WEPOS | CHAR | 1(0) | XFELD | |||||
KTOPL | Chart of Accounts | KTOPL | CHAR | 4(0) | KTOPL | KPL | C_KTOPL | KTOPL | ||
BEWAE | Purchase order currency | BSTWA | CUKY | 5(0) | Assigned to domain | WAERS | ||||
UMREZ | Numerator for Conversion to Base Units of Measure | UMREZ | DEC | 5(0) | UMBSZ | |||||
UMREN | Denominator for conversion to base units of measure | UMREN | DEC | 5(0) | UMBSN | |||||
BASME | Base Unit of Measure for BOM | BASME | UNIT | 3(0) | Assigned to domain | CUNIT | MEINS | |||
AREWR | GR/IR account clearing value in local currency | AREWR | CURR | 13(2) | WERT7 | |||||
AREWW | Clearing value on GR/IR clearing account (transac. currency) | AREWW | CURR | 13(2) | WERT7 | |||||
SUPKZ | Update Indicator: BW Extraction | SUPKZD | CHAR | 1(0) | SUPKZD | |||||
LAUFNAME | Name of run | MCLAUFNAME | CHAR | 10(0) | CHAR10 | |||||
VRTKZ | Distribution Indicator for Multiple Account Assignment | VRTKZ | CHAR | 1(0) | VRTKZ |
Search for further information about these or an SAP related objects