MCRBITM SAP (Item Data) Structure details
Description: Item Data
Structure field list including key, data, relationships and ABAP select examples
MCRBITM is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Item Data" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_MCRBITM TYPE MCRBITM.
The MCRBITM table consists of various fields, each holding specific information or linking keys about Item Data data available in SAP. These include MANDT (Client), BELNR (Accounting Document Number), GJAHR (Fiscal Year), BUZEI (Document Item in Invoice Document).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)
SAP MCRBITM structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
BELNR | Accounting Document Number | BELNR_D | CHAR | 10 | ALPHA | BELNR | BLN | ||
GJAHR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
BUZEI | Document Item in Invoice Document | RBLGP | NUMC | 6 | NUMC6 | ||||
EBELN | Purchasing Document Number | EBELN | CHAR | 10 | EKKO | ALPHA | EBELN | BES | MEKK_C |
EBELP | Item Number of Purchasing Document | EBELP | NUMC | 5 | EKPO | EBELP | BSP | ||
ZEKKN | Sequential Number of Account Assignment | DZEKKN | NUMC | 2 | NUM02 | ||||
MATNR | Material Number | MATNR | CHAR | 18 | MARA | MATN1 | MATNR | MAT | S_MAT1 |
BWKEY | Valuation Area | BWKEY | CHAR | 4 | T001K | BWKEY | BWK | ||
BWTAR | Valuation Type | BWTAR_D | CHAR | 10 | T149D | BWTAR | BWT | ||
BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
WERKS | Plant | WERKS_D | CHAR | 4 | T001W | WERKS | WRK | H_T001W_C | |
WRBTR | Amount in document currency | WRBTR | CURR | 13(2) | WERT7 | ||||
SHKZG | Debit/Credit Indicator | SHKZG | CHAR | 1 | SHKZG | ||||
MWSKZ | Tax on sales/purchases code | MWSKZ | CHAR | 2 | T007A | MWSKZ | |||
TXJCD | Tax Jurisdiction | TXJCD | CHAR | 15 | TTXJ | TXJCD | TXJ | ||
MENGE | Quantity | MENGE_D | QUAN | 13(3) | MENG13 | ||||
BSTME | Purchase Order Unit of Measure | BSTME | UNIT | 3 | T006 | CUNIT | MEINS | ||
BPMNG | Quantity in Purchase Order Price Unit | BPMNG | QUAN | 13(3) | MENG13 | ||||
BPRME | Order Price Unit (Purchasing) | BPRME | UNIT | 3 | 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 | T006 | CUNIT | MEINS | ||
PSTYP | Item Category in Purchasing Document | PSTYP | CHAR | 1 | T163 | PSTYP | |||
KNTTP | Account Assignment Category | KNTTP | CHAR | 1 | T163K | KNTTP | KNT | ||
BKLAS | Valuation Class | BKLAS | CHAR | 4 | T025 | BKLAS | |||
EREKZ | Final Invoice Indicator | EREKZ | CHAR | 1 | XFELD | ||||
EXKBE | Indicator: update purchase order history | XEKBE | CHAR | 1 | XFELD | ||||
XEKBZ | Indicator: Update Purchase Order Delivery Costs | XEKBZ | CHAR | 1 | XFELD | ||||
TBTKZ | Indicator: subsequent debit/credit | TBTKZ | CHAR | 1 | TBTKZ | ||||
SPGRP | Blocking reason: price | SPGRP | CHAR | 1 | XFELD | ||||
SPGRM | Blocking reason: quantity | SPGRM | CHAR | 1 | XFELD | ||||
SPGRT | Blocking Reason: Date | SPGRT | CHAR | 1 | XFELD | ||||
SPGRG | Blocking reason: order price quantity | SPGRG | CHAR | 1 | XFELD | ||||
SPGRV | Blocking reason: project budget | SPGRV | CHAR | 1 | XFELD | ||||
SPGRQ | Manual Blocking Reason | SPGRQ | CHAR | 1 | XFELD | ||||
SPGRS | Blocking Reason: Item Amount | SPGRS | CHAR | 1 | XFELD | ||||
SPGRC | Block.reason: quality | SPGRC | CHAR | 1 | XFELD | ||||
SPGREXT | Blocking Reason Enhancement Fields | SPGREXT | CHAR | 1 | XFELD | ||||
BUSTW | Posting string for values | BUSTW | CHAR | 4 | BUSTW | ||||
XBLNR | Reference Document Number | XBLNR1 | CHAR | 16 | XBLNR1 | ||||
XRUEB | Indicator: Document is posted to a previous period | XRUEB | CHAR | 1 | XFELD | ||||
BNKAN | Delivery costs' share of item value | BNK_ANTEIL | CURR | 13(2) | WERT7 | ||||
KSCHL | Condition Type | KSCHL | CHAR | 4 | 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 | LIFO_FIFO | ||||
LFBNR | Document No. of a Reference Document | LFBNR | CHAR | 10 | ALPHA | BELNR | |||
LFGJA | Fiscal Year of Current Period | LFGJA | NUMC | 4 | GJAHR | GJAHR | |||
LFPOS | Item of a Reference Document | LFPOS | NUMC | 4 | MBLPO | ||||
MATBF | Material in Respect of Which Stock is Managed | MATBF | CHAR | 18 | Assigned to domain | MATN1 | MATNR | ||
RBMNG | Qty invoiced in vendor invoice in PO order units | RBMNG | QUAN | 13(3) | MENG13V | ||||
BPRBM | Qty invoiced in vendor invoice in PO price units | BPRBM | QUAN | 13(3) | MENG13V | ||||
RBWWR | Invoice amount in document currency of vendor invoice | RBWWR | CURR | 13(2) | WERT7 | ||||
LFEHL | Type of vendor error | LFEHL | CHAR | 1 | LFEHL | ||||
GRICD | Activity Code for Gross Income Tax | J_1AGICD_D | CHAR | 2 | J_1AGICD | J_1AGICD2 | |||
GRIRG | STATE (State, Province, County) | REGIO | CHAR | 3 | T005S | REGIO | |||
GITYP | Distribution Type for Employment Tax | J_1ADTYP_D | CHAR | 2 | J_1ADTYP | J_1ADTYP | |||
PACKNO | Package Number of Service | PACKNO_EKBE | NUMC | 10 | Assigned to domain | PACKNO | |||
INTROW | Line Number of Service | INTROW_EKBE | NUMC | 10 | INTROW | ||||
SGTXT | Item Text | SGTXT | CHAR | 50 | TEXT50 | ||||
XSKRL | Indicator: Line item not liable to cash discount? | XSKRL | CHAR | 1 | XFELD | ||||
KZMEK | Correction indicator | KZMEKORR | CHAR | 1 | KZMEKORR | ||||
MRMOK | Indicator: invoice item processed | MRMOK | CHAR | 1 | XFELD | ||||
STUNR | Step number | STUNR | NUMC | 3 | Assigned to domain | STUNR | |||
ZAEHK | Condition counter | DZAEHK | NUMC | 2 | 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 | XFELD | ||||
LIFNR | Account Number of Vendor or Creditor | LIFNR | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | LIF | KRED_C |
FRBNR | Number of Bill of Lading at Time of Goods Receipt | FRBNR1 | CHAR | 16 | XBLNR1 | ||||
XHISTMA | Update Multiple Account Assignment EKBE_MA, EKBZ_MA | XHISTMA | CHAR | 1 | CHAR1 | ||||
COMPLAINT_REASON | Complaints Reason in an Invoice | COMPLAINT_REASON | CHAR | 2 | 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 | DATUM | ||||
XRETTAXNET | Tax Reduction for Retention | RET_TAXNET | CHAR | 1 | XFELD | ||||
RE_ACCOUNT | Cash Ledger: Expense or Revenue Account | FAGL_RE_ACCOUNT | CHAR | 10 | Assigned to domain | ALPHA | SAKNR | ||
ERP_CONTRACT_ID | Number of Principal Purchase Agreement | KONNR | CHAR | 10 | Assigned to domain | ALPHA | EBELN | KTR | |
ERP_CONTRACT_ITM | Item Number of Principal Purchase Agreement | KTPNR | NUMC | 5 | Assigned to domain | EBELP | |||
SRM_CONTRACT_ID | Central Contract | SRM_CONTRACT_ID | CHAR | 10 | ALPHA | BBP_BAPI_EBELN | MMBSI_MEKK_CC | ||
SRM_CONTRACT_ITM | Central Contract Item Number | SRM_CONTRACT_ITEM | NUMC | 10 | BBP_ITEMNO | ||||
CONT_PSTYP | Item Category in Purchasing Document | PSTYP | CHAR | 1 | Assigned to domain | PSTYP | |||
SRVMAPKEY | Item Key for eSOA Messages | SRVMAPKEY | NUMC | 10 | |||||
CHARG | Batch Number | CHARG_D | CHAR | 10 | Assigned to domain | CHARG | CHA | ||
INV_ITM_ORIGIN | Origin of an Invoice Item | INV_ITM_ORIGIN | CHAR | 1 | INV_ITM_ORIGIN | ||||
INVREL | Grouping Characteristic for Invoice Verification | INVREL | NUMC | 6 | NUMC6 | ||||
XDINV | Indicator for Differential Invoicing | XDINV | CHAR | 1 | 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 | CHAR1 | ||||
.INCLU--AP | 0 | ||||||||
/NFM/SPGRK | NF Processing, Rate Blocking Reason | /NFM/SPGRK | CHAR | 1 | CHAR01 | ||||
EFKOR | Type of correction to own error | EFKOR | CHAR | 1 | EFKOR | ||||
.INCLU--AP | 0 | ||||||||
LICNO | Internal License Number | J_1ILICNO | NUMC | 10 | J_1ILICNO | ||||
ZEILE | Item Number | J_1IZEILE | NUMC | 4 | J_1IZEILE | ||||
BPUMZ | Numerator for Conversion of Order Price Unit into Order Unit | BPUMZ | DEC | 5 | UMBSZ | ||||
BPUMN | Denominator for Conv. of Order Price Unit into Order Unit | BPUMN | DEC | 5 | 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 | 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 | XFELD | ||||
PRDIFF | Price Difference in Local Currency | PRDIFF | CURR | 13(2) | WERTV7 | ||||
AFNAM | Name of Requisitioner/Requester | AFNAM | CHAR | 12 | AFNAM | ||||
EKGRP | Purchasing Group | EKGRP | CHAR | 3 | Assigned to domain | EKGRP | EKG | ||
FKNUM | Shipment Cost Number | FKNUM | CHAR | 10 | Assigned to domain | ALPHA | FKNUM | FKK | SD_F4_SCD_ID |
FKPOS | Shipment costs item | FKPOS | NUMC | 6 | Assigned to domain | FKPOS | |||
FPLNR | Invoicing plan number | IPLNR | CHAR | 10 | CHAR10 | ||||
HWAER | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
LEBRE | Indicator for Service-Based Invoice Verification | LEBRE | CHAR | 1 | XFELD | ||||
MATKL | Material Group | MATKL | CHAR | 9 | Assigned to domain | MATKL | MKL | S_WBWG | |
NETPR | Net Price in Purchasing Document (in Document Currency) | BPREI | CURR | 11(2) | WERT11 | ||||
PEINH | Price Unit | PEINH | DEC | 5 | PACK3 | ||||
REPOS | Invoice Receipt Indicator | REPOS | CHAR | 1 | XFELD | ||||
RETPO | Returns Item | RETPO | CHAR | 1 | XFELD | ||||
TXZ01 | Short Text | TXZ01 | CHAR | 40 | TEXT40 | ||||
WEBRE | Indicator: GR-Based Invoice Verification | WEBRE | CHAR | 1 | XFELD | ||||
ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
EKORG | Purchasing Organization | EKORG | CHAR | 4 | Assigned to domain | EKORG | EKO | ||
LIFNR2 | Vendor Account Number | ELIFN | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | LIF | KRED_C |
KZBWS | Valuation of Special Stock | KZBWS | CHAR | 1 | KZBWS | ||||
KTPNR | Item Number of Principal Purchase Agreement | KTPNR | NUMC | 5 | Assigned to domain | EBELP | |||
KONNR | Number of Principal Purchase Agreement | KONNR | CHAR | 10 | Assigned to domain | ALPHA | EBELN | KTR | |
WEUNB | Goods Receipt, Non-Valuated | WEUNB | CHAR | 1 | XFELD | ||||
WEPOS | Goods Receipt Indicator | WEPOS | CHAR | 1 | XFELD | ||||
KTOPL | Chart of Accounts | KTOPL | CHAR | 4 | Assigned to domain | KTOPL | KPL | C_KTOPL | |
BEWAE | Purchase order currency | BSTWA | CUKY | 5 | Assigned to domain | WAERS | |||
UMREZ | Numerator for Conversion to Base Units of Measure | UMREZ | DEC | 5 | UMBSZ | ||||
UMREN | Denominator for conversion to base units of measure | UMREN | DEC | 5 | UMBSN | ||||
BASME | Base unit of measure for BOM | BASME | UNIT | 3 | 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 | SUPKZD | ||||
LAUFNAME | Name of run | MCLAUFNAME | CHAR | 10 | CHAR10 | ||||
VRTKZ | Distribution indicator for multiple account assignment | VRTKZ | CHAR | 1 | VRTKZ |
Key field | Non-key field |
How do I retrieve data from SAP structure MCRBITM using ABAP code?
As MCRBITM is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on MCRBITM as there is no data to select.How to access SAP table MCRBITM
Within an ECC or HANA version of SAP you can also view further information about MCRBITM and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects