SAP ABAP Table MCRBITM (Item Data)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ MRM (Package) Appl.development R/3 decentralized invoice verification
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ MRM (Package) Appl.development R/3 decentralized invoice verification
Basic Data
Table Category | INTTAB | Structure |
Structure | MCRBITM | Table Relationship Diagram |
Short Description | Item Data |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | .INCLUDE | 0 | 0 | Document Item: Incoming Invoice | |||||
2 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
3 | BELNR | BELNR_D | BELNR | CHAR | 10 | 0 | Accounting Document Number | ||
4 | GJAHR | GJAHR | GJAHR | NUMC | 4 | 0 | Fiscal Year | ||
5 | BUZEI | RBLGP | NUMC6 | NUMC | 6 | 0 | Document Item in Invoice Document | ||
6 | EBELN | EBELN | EBELN | CHAR | 10 | 0 | Purchasing Document Number | EKKO | |
7 | EBELP | EBELP | EBELP | NUMC | 5 | 0 | Item Number of Purchasing Document | EKPO | |
8 | ZEKKN | DZEKKN | NUM02 | NUMC | 2 | 0 | Sequential Number of Account Assignment | ||
9 | MATNR | MATNR | MATNR | CHAR | 18 | 0 | Material Number | MARA | |
10 | BWKEY | BWKEY | BWKEY | CHAR | 4 | 0 | Valuation area | T001K | |
11 | BWTAR | BWTAR_D | BWTAR | CHAR | 10 | 0 | Valuation type | T149D | |
12 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | T001 | |
13 | WERKS | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | T001W | |
14 | WRBTR | WRBTR | WERT7 | CURR | 13 | 2 | Amount in document currency | ||
15 | SHKZG | SHKZG | SHKZG | CHAR | 1 | 0 | Debit/Credit Indicator | ||
16 | MWSKZ | MWSKZ | MWSKZ | CHAR | 2 | 0 | Tax on sales/purchases code | T007A | |
17 | TXJCD | TXJCD | TXJCD | CHAR | 15 | 0 | Tax Jurisdiction | TTXJ | |
18 | MENGE | MENGE_D | MENG13 | QUAN | 13 | 3 | Quantity | ||
19 | BSTME | BSTME | MEINS | UNIT | 3 | 0 | Order unit | T006 | |
20 | BPMNG | BPMNG | MENG13 | QUAN | 13 | 3 | Quantity in order price quantity unit | ||
21 | BPRME | BPRME | MEINS | UNIT | 3 | 0 | Order Price Unit (purchasing) | T006 | |
22 | LBKUM | LBKUM | MENG13V | QUAN | 13 | 3 | Total Valuated Stock | ||
23 | VRKUM | VRKUM | MENG13V | QUAN | 13 | 3 | Total valuated stock in the previous posting period | ||
24 | MEINS | MEINS | MEINS | UNIT | 3 | 0 | Base Unit of Measure | T006 | |
25 | PSTYP | PSTYP | PSTYP | CHAR | 1 | 0 | Item category in purchasing document | T163 | |
26 | KNTTP | KNTTP | KNTTP | CHAR | 1 | 0 | Account assignment category | T163K | |
27 | BKLAS | BKLAS | BKLAS | CHAR | 4 | 0 | Valuation Class | T025 | |
28 | EREKZ | EREKZ | XFELD | CHAR | 1 | 0 | Final Invoice Indicator | ||
29 | EXKBE | XEKBE | XFELD | CHAR | 1 | 0 | Indicator: update purchase order history | ||
30 | XEKBZ | XEKBZ | XFELD | CHAR | 1 | 0 | Indicator: Update Purchase Order Delivery Costs | ||
31 | TBTKZ | TBTKZ | TBTKZ | CHAR | 1 | 0 | Indicator: Subsequent Debit/Credit | ||
32 | SPGRP | SPGRP | XFELD | CHAR | 1 | 0 | Blocking Reason: Price | ||
33 | SPGRM | SPGRM | XFELD | CHAR | 1 | 0 | Blocking Reason: Quantity | ||
34 | SPGRT | SPGRT | XFELD | CHAR | 1 | 0 | Blocking Reason: Date | ||
35 | SPGRG | SPGRG | XFELD | CHAR | 1 | 0 | Blocking Reason: Order Price Quantity | ||
36 | SPGRV | SPGRV | XFELD | CHAR | 1 | 0 | Blocking Reason: Project Budget | ||
37 | SPGRQ | SPGRQ | XFELD | CHAR | 1 | 0 | Manual Blocking Reason | ||
38 | SPGRS | SPGRS | XFELD | CHAR | 1 | 0 | Blocking Reason: Item Amount | ||
39 | SPGRC | SPGRC | XFELD | CHAR | 1 | 0 | Blocking Reason: Quality | ||
40 | SPGREXT | SPGREXT | XFELD | CHAR | 1 | 0 | Blocking Reason Enhancement Fields | ||
41 | BUSTW | BUSTW | BUSTW | CHAR | 4 | 0 | Posting string for values | ||
42 | XBLNR | XBLNR1 | XBLNR1 | CHAR | 16 | 0 | Reference Document Number | ||
43 | XRUEB | XRUEB | XFELD | CHAR | 1 | 0 | Indicator: Document is posted to a previous period | ||
44 | BNKAN | BNK_ANTEIL | WERT7 | CURR | 13 | 2 | Delivery costs' share of item value | ||
45 | KSCHL | KSCHL | KSCHL | CHAR | 4 | 0 | Condition Type | * | |
46 | SALK3 | SALK3 | WERT13N | CURR | 13 | 2 | Value of Total Valuated Stock | ||
47 | VMSAL | VMSAL | WERT13N | CURR | 13 | 2 | Value of total valuated stock in previous period | ||
48 | XLIFO | XLIFO | LIFO_FIFO | CHAR | 1 | 0 | LIFO/FIFO-relevant | ||
49 | LFBNR | LFBNR | BELNR | CHAR | 10 | 0 | Document number of a reference document | ||
50 | LFGJA | LFGJA | GJAHR | NUMC | 4 | 0 | Fiscal Year of Current Period | ||
51 | LFPOS | LFPOS | MBLPO | NUMC | 4 | 0 | Item of a reference document | ||
52 | MATBF | MATBF | MATNR | CHAR | 18 | 0 | Material in Respect of Which Stock is Managed | * | |
53 | RBMNG | RBMNG | MENG13V | QUAN | 13 | 3 | Qty invoiced in vendor invoice in PO order units | ||
54 | BPRBM | BPRBM | MENG13V | QUAN | 13 | 3 | Qty invoiced in vendor invoice in PO price units | ||
55 | RBWWR | RBWWR | WERT7 | CURR | 13 | 2 | Invoice amount in document currency of vendor invoice | ||
56 | LFEHL | LFEHL | LFEHL | CHAR | 1 | 0 | Type of vendor error | ||
57 | GRICD | J_1AGICD_D | J_1AGICD2 | CHAR | 2 | 0 | Activity Code for Gross Income Tax | J_1AGICD | |
58 | GRIRG | REGIO | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | T005S | |
59 | GITYP | J_1ADTYP_D | J_1ADTYP | CHAR | 2 | 0 | Distribution Type for Employment Tax | J_1ADTYP | |
60 | PACKNO | PACKNO_EKBE | PACKNO | NUMC | 10 | 0 | Package Number of Service | * | |
61 | INTROW | INTROW_EKBE | INTROW | NUMC | 10 | 0 | Line Number of Service | ||
62 | SGTXT | SGTXT | TEXT50 | CHAR | 50 | 0 | Item Text | ||
63 | XSKRL | XSKRL | XFELD | CHAR | 1 | 0 | Indicator: Line item not liable to cash discount? | ||
64 | KZMEK | KZMEKORR | KZMEKORR | CHAR | 1 | 0 | Correction indicator | ||
65 | MRMOK | MRMOK | XFELD | CHAR | 1 | 0 | Indicator: invoice item processed | ||
66 | STUNR | STUNR | STUNR | NUMC | 3 | 0 | Level Number | * | |
67 | ZAEHK | DZAEHK | ZAEHK | NUMC | 2 | 0 | Condition counter | ||
68 | STOCK_POSTING | STOCK_POSTING | WRTV7 | CURR | 13 | 2 | Stock Posting of Line from an Incoming Invoice | ||
69 | STOCK_POSTING_PP | STOCK_POSTING_PP | WRTV7 | CURR | 13 | 2 | Stock Posting of Line from an Incoming Invoice, Prev. Period | ||
70 | STOCK_POSTING_PY | STOCK_POSTING_PY | WRTV7 | CURR | 13 | 2 | Stock Posting of Line from an Incoming Invoice, Prev. Year | ||
71 | WEREC | MMWEREC | XFELD | CHAR | 1 | 0 | Clearing Indicator for GR/IR Posting for External Services | ||
72 | LIFNR | LIFNR | LIFNR | CHAR | 10 | 0 | Account Number of Vendor or Creditor | * | |
73 | FRBNR | FRBNR1 | XBLNR1 | CHAR | 16 | 0 | Number of Bill of Lading at Time of Goods Receipt | ||
74 | XHISTMA | XHISTMA | CHAR1 | CHAR | 1 | 0 | Update Multiple Account Assignment EKBE_MA, EKBZ_MA | ||
75 | COMPLAINT_REASON | COMPLAINT_REASON | COMPLAINT_REASON | CHAR | 2 | 0 | Complaints Reason in an Invoice | * | |
76 | RETAMT_FC | RET_AMT_FC | WERT7 | CURR | 13 | 2 | Retention Amount in Document Currency | ||
77 | RETPC | RETPZ | PRZ32 | DEC | 5 | 2 | Retention in Percent | ||
78 | RETDUEDT | RET_DUE_DATE | DATUM | DATS | 8 | 0 | Due Date for Retention | ||
79 | XRETTAXNET | RET_TAXNET | XFELD | CHAR | 1 | 0 | Tax Reduction for Retention | ||
80 | RE_ACCOUNT | FAGL_RE_ACCOUNT | SAKNR | CHAR | 10 | 0 | Cash Ledger: Expense or Revenue Account | * | |
81 | ERP_CONTRACT_ID | KONNR | EBELN | CHAR | 10 | 0 | Number of principal purchase agreement | * | |
82 | ERP_CONTRACT_ITM | KTPNR | EBELP | NUMC | 5 | 0 | Item number of principal purchase agreement | * | |
83 | SRM_CONTRACT_ID | SRM_CONTRACT_ID | BBP_BAPI_EBELN | CHAR | 10 | 0 | Central Contract | ||
84 | SRM_CONTRACT_ITM | SRM_CONTRACT_ITEM | BBP_ITEMNO | NUMC | 10 | 0 | Central Contract Item Number | ||
85 | CONT_PSTYP | PSTYP | PSTYP | CHAR | 1 | 0 | Item category in purchasing document | * | |
86 | SRVMAPKEY | SRVMAPKEY | NUMC | 10 | 0 | Item Key for eSOA Messages | |||
87 | CHARG | CHARG_D | CHARG | CHAR | 10 | 0 | Batch Number | * | |
88 | INV_ITM_ORIGIN | INV_ITM_ORIGIN | INV_ITM_ORIGIN | CHAR | 1 | 0 | Origin of an Invoice Item | ||
89 | INVREL | INVREL | NUMC6 | NUMC | 6 | 0 | Grouping Characteristic for Invoice Verification | ||
90 | XDINV | XDINV | CHAR1 | CHAR | 1 | 0 | Indicator for Differential Invoicing | ||
91 | DIFF_AMOUNT | DIFFERENCE_AMOUNT | ANLKWERT | CURR | 13 | 2 | Difference Amount (in Document Currency) | ||
92 | XCPRF | XCPRF | CHAR1 | CHAR | 1 | 0 | Checkbox for Commodity Repricing in Invoice Verification | ||
93 | .INCLU--AP | 0 | 0 | License details to Invoice | |||||
94 | LICNO | J_1ILICNO | J_1ILICNO | NUMC | 10 | 0 | Internal License Number | ||
95 | ZEILE | J_1IZEILE | J_1IZEILE | NUMC | 4 | 0 | Item Number | ||
96 | .INCLUDE | 0 | 0 | New Persistent Key Figures | |||||
97 | BPUMZ | BPUMZ | UMBSZ | DEC | 5 | 0 | Numerator for Conversion of Order Price Unit into Order Unit | ||
98 | BPUMN | BPUMN | UMBSN | DEC | 5 | 0 | Denominator for Conv. of Order Price Unit into Order Unit | ||
99 | NETWR | NETWR | WERTV8 | CURR | 15 | 2 | Net Value in Document Currency | ||
100 | BSMNG | BSMNG | MENG13 | QUAN | 13 | 3 | Quantity ordered against this purchase requisition | ||
101 | WEMNG | WEMNG | MENG13 | QUAN | 13 | 3 | Quantity of goods received | ||
102 | REMNG | REMNG | MENG13 | QUAN | 13 | 3 | Quantity invoiced | ||
103 | BPREM | BPREM | MENG13 | QUAN | 13 | 3 | Invoice receipt quantity in order price unit | ||
104 | BPWEM | BPWEM | MENG13 | QUAN | 13 | 3 | Goods receipt quantity in order unit | ||
105 | REEWR | REEWR | WRTV7 | CURR | 13 | 2 | Invoice Value Entered (in Local Currency) | ||
106 | REFWR | REFWR | WRTV7 | CURR | 13 | 2 | Invoice Value in Foreign Currency | ||
107 | REWRT | REWRT | WRTV7 | CURR | 13 | 2 | Invoice value in local currency | ||
108 | REWWR | REWWR | WERT7 | CURR | 13 | 2 | Invoice Amount in Foreign Currency | ||
109 | WENWR | WENWR | WERT7 | CURR | 13 | 2 | Accepted net value of service in foreign currency | ||
110 | WEWRT | WEWRT | WERT7 | CURR | 13 | 2 | Value of goods received in local currency | ||
111 | WEWWR | WEWWR | WERT7 | CURR | 13 | 2 | Value of goods received in foreign currency | ||
112 | NOQUANTITY | NOQUANTITY | XFELD | CHAR | 1 | 0 | No quantity logic (document item without quantity) | ||
113 | PRDIFF | PRDIFF | WERTV7 | CURR | 13 | 2 | Price Difference in Local Currency | ||
114 | .INCLUDE | 0 | 0 | Key Figures At Item Level Only | |||||
115 | AFNAM | AFNAM | AFNAM | CHAR | 12 | 0 | Name of requisitioner/requester | ||
116 | EKGRP | EKGRP | EKGRP | CHAR | 3 | 0 | Purchasing group | * | |
117 | FKNUM | FKNUM | FKNUM | CHAR | 10 | 0 | Shipment cost number | * | |
118 | FKPOS | FKPOS | FKPOS | NUMC | 6 | 0 | Shipment costs item | * | |
119 | FPLNR | IPLNR | CHAR10 | CHAR | 10 | 0 | Invoicing plan number | ||
120 | HWAER | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
121 | LEBRE | LEBRE | XFELD | CHAR | 1 | 0 | Indicator for Service-Based Invoice Verification | ||
122 | MATKL | MATKL | MATKL | CHAR | 9 | 0 | Material Group | * | |
123 | NETPR | BPREI | WERT11 | CURR | 11 | 2 | Net Price in Purchasing Document (in Document Currency) | ||
124 | PEINH | PEINH | PACK3 | DEC | 5 | 0 | Price unit | ||
125 | REPOS | REPOS | XFELD | CHAR | 1 | 0 | Invoice receipt indicator | ||
126 | RETPO | RETPO | XFELD | CHAR | 1 | 0 | Returns Item | ||
127 | TXZ01 | TXZ01 | TEXT40 | CHAR | 40 | 0 | Short Text | ||
128 | WEBRE | WEBRE | XFELD | CHAR | 1 | 0 | Indicator: GR-Based Invoice Verification | ||
129 | ERNAM | ERNAM | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
130 | EKORG | EKORG | EKORG | CHAR | 4 | 0 | Purchasing organization | * | |
131 | LIFNR2 | ELIFN | LIFNR | CHAR | 10 | 0 | Vendor's account number | * | |
132 | KZBWS | KZBWS | KZBWS | CHAR | 1 | 0 | Valuation of Special Stock | ||
133 | KTPNR | KTPNR | EBELP | NUMC | 5 | 0 | Item number of principal purchase agreement | * | |
134 | KONNR | KONNR | EBELN | CHAR | 10 | 0 | Number of principal purchase agreement | * | |
135 | WEUNB | WEUNB | XFELD | CHAR | 1 | 0 | Goods Receipt, Non-Valuated | ||
136 | WEPOS | WEPOS | XFELD | CHAR | 1 | 0 | Goods Receipt Indicator | ||
137 | KTOPL | KTOPL | KTOPL | CHAR | 4 | 0 | Chart of Accounts | * | |
138 | BEWAE | BSTWA | WAERS | CUKY | 5 | 0 | Purchase order currency | * | |
139 | UMREZ | UMREZ | UMBSZ | DEC | 5 | 0 | Numerator for Conversion to Base Units of Measure | ||
140 | UMREN | UMREN | UMBSN | DEC | 5 | 0 | Denominator for conversion to base units of measure | ||
141 | BASME | BASME | MEINS | UNIT | 3 | 0 | Base Unit of Measure for BOM | * | |
142 | .INCLUDE | 0 | 0 | Jointly Used Key Figures (ITM and CO) | |||||
143 | AREWR | AREWR | WERT7 | CURR | 13 | 2 | GR/IR account clearing value in local currency | ||
144 | AREWW | AREWW | WERT7 | CURR | 13 | 2 | Clearing value on GR/IR clearing account (transac. currency) | ||
145 | .INCLUDE | 0 | 0 | Technical Fields for Extraction | |||||
146 | SUPKZ | SUPKZD | SUPKZD | CHAR | 1 | 0 | Update Indicator: BW Extraction | ||
147 | LAUFNAME | MCLAUFNAME | CHAR10 | CHAR | 10 | 0 | Name of run | ||
148 | VRTKZ | VRTKZ | VRTKZ | CHAR | 1 | 0 | Distribution indicator for multiple account assignment |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | MCRBITM | BKLAS | T025 | BKLAS | |||
2 | MCRBITM | BPRME | T006 | MSEHI | |||
3 | MCRBITM | BSTME | T006 | MSEHI | |||
4 | MCRBITM | BUKRS | T001 | BUKRS | |||
5 | MCRBITM | BWKEY | T001K | BWKEY | |||
6 | MCRBITM | BWTAR | T149D | BWTAR | |||
7 | MCRBITM | EBELN | EKKO | EBELN | |||
8 | MCRBITM | EBELP | EKPO | EBELP | |||
9 | MCRBITM | GITYP | J_1ADTYP | J_1ADTYP | KEY | 1 | CN |
10 | MCRBITM | GRICD | J_1AGICD | J_1AGICD | KEY | 1 | CN |
11 | MCRBITM | GRIRG | T005S | BLAND | KEY | 1 | CN |
12 | MCRBITM | KNTTP | T163K | KNTTP | |||
13 | MCRBITM | MANDT | T000 | MANDT | |||
14 | MCRBITM | MATNR | MARA | MATNR | |||
15 | MCRBITM | MEINS | T006 | MSEHI | |||
16 | MCRBITM | MWSKZ | T007A | MWSKZ | |||
17 | MCRBITM | PSTYP | T163 | PSTYP | |||
18 | MCRBITM | TXJCD | TTXJ | TXJCD | |||
19 | MCRBITM | WERKS | T001W | WERKS |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 600 |