SAP ABAP Table MC06M_0ITM (Extraction Structure BW)

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

Basic Data

Table Category	INTTAB	Structure
Structure	MC06M_0ITM	Table Relationship Diagram
Short Description	Extraction Structure BW

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components


	Field	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE				0	0	Extraction Structure BW: Key Fields
2	BELNR	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
3	BUZEI	RBLGP	NUMC6	NUMC	6	0	Document Item in Invoice Document
4	GJAHR	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
5	COBL_NR	COBL_NR	COBL_NR	NUMC	4	0	Four Character Sequential Number for Coding Block
6	.INCLUDE				0	0	Extraction Structure BW: Header Data
7	ARKUEMW	ARKUEMW	WERTV7	CURR	13	2	Sales Tax Portion of Automatic Invoice Reduction Amount
8	ARKUEN	ARKUEN	WERTV7	CURR	13	2	Automatic Invoice Reduction Amount (Net)
9	BEZNK	BEZNK	ANLKWERT	CURR	13	2	Unplanned delivery costs
10	BKTXT	BKTXT	TEXT25	CHAR	25	0	Document Header Text
11	BLDAT	BLDAT	DATUM	DATS	8	0	Document Date in Document
12	BUDAT	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
13	BUKRS	BUKRS	BUKRS	CHAR	4	0	Company Code	*
14	DIFFMW	DIFFMW	WERTV7	CURR	13	2	Sales Tax Portion of the Invoice Verification Difference
15	DIFFN	RPDIFN	WERTV7	CURR	13	2	Document Balance
16	IVTYP	IVTYP	IVTYP	CHAR	1	0	Origin of a Logistics Invoice Verification Document
17	LIEFFMW	LIEFFMW	WERTV7	CURR	13	2	Tax in vendor error
18	LIEFFN	LIEFFN	WERTV7	CURR	13	2	Vendor error (exclusive of tax)
19	LIFNR	LIFRE	LIFNR	CHAR	10	0	Different Invoicing Party	*
20	LOGSYS	LOGSYS	LOGSYS	CHAR	10	0	Logical system	*
21	MAKZMW	MAKZMW	WERTV7	CURR	13	2	Tax Amount Accepted Manually
22	MAKZN	MAKZN	WERTV7	CURR	13	2	Manually accepted net difference amount
23	MRM_ZLSPR	MRM_ZLSPR	MRM_ZLSPR	CHAR	1	0	Logistics payment block
24	MWSKZ_BNK	MWSKZ_MRM	MWSKZ	CHAR	2	0	Tax Code	*
25	RBSTAT	RBSTAT	RBSTAT	CHAR	1	0	Invoice document status
26	RMWWR	RMWWR	WERT7	CURR	13	2	Gross invoice amount in document currency
27	STBLG	RE_STBLG	BELNR	CHAR	10	0	Reversal document number
28	STJAH	RE_STJAH	GJAHR	NUMC	4	0	Fiscal year of reversal document
29	WAERS	WAERS	WAERS	CUKY	5	0	Currency Key	*
30	WMWST1	FWSTEV	WERTV7	CURR	13	2	Tax Amount in Document Currency with +/- Sign
31	XBLNR	XBLNR1	XBLNR1	CHAR	16	0	Reference Document Number
32	XRECH	XRECH	XRADI	CHAR	1	0	Indicator: post invoice
33	ZLSPR	DZLSPR	ZAHLS	CHAR	1	0	Payment Block Key	*
34	.INCLUDE				0	0	Extraction Structure BW: PO Reference Items
35	AFNAM	AFNAM	AFNAM	CHAR	12	0	Name of requisitioner/requester
36	AREWR	AREWR	WERT7	CURR	13	2	GR/IR account clearing value in local currency
37	BASME	BASME	MEINS	UNIT	3	0	Base Unit of Measure for BOM	*
38	BEWAE	BSTWA	WAERS	CUKY	5	0	Purchase order currency	*
39	BPMNG	BPMNG	MENG13	QUAN	13	3	Quantity in order price quantity unit
40	BPRBM	BPRBM	MENG13V	QUAN	13	3	Qty invoiced in vendor invoice in PO price units
41	BPREM	BPREM	MENG13	QUAN	13	3	Invoice receipt quantity in order price unit
42	BPRME	BPRME	MEINS	UNIT	3	0	Order Price Unit (purchasing)	*
43	BPUMN	BPUMN	UMBSN	DEC	5	0	Denominator for Conv. of Order Price Unit into Order Unit
44	BPUMZ	BPUMZ	UMBSZ	DEC	5	0	Numerator for Conversion of Order Price Unit into Order Unit
45	BPWEM	BPWEM	MENG13	QUAN	13	3	Goods receipt quantity in order unit
46	BSMNG	BSMNG	MENG13	QUAN	13	3	Quantity ordered against this purchase requisition
47	BSTME	BSTME	MEINS	UNIT	3	0	Order unit	*
48	EBELN	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	*
49	EBELP	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	*
50	EKGRP	EKGRP	EKGRP	CHAR	3	0	Purchasing group	*
51	EKORG	EKORG	EKORG	CHAR	4	0	Purchasing organization	*
52	EREKZ	EREKZ	XFELD	CHAR	1	0	Final Invoice Indicator
53	HWAER	WAERS	WAERS	CUKY	5	0	Currency Key	*
54	KNTTP	KNTTP	KNTTP	CHAR	1	0	Account assignment category	*
55	KONNR	KONNR	EBELN	CHAR	10	0	Number of principal purchase agreement	*
56	KTPNR	KTPNR	EBELP	NUMC	5	0	Item number of principal purchase agreement	*
57	LFBNR	LFBNR	BELNR	CHAR	10	0	Document number of a reference document
58	LFGJA	LFGJA	GJAHR	NUMC	4	0	Fiscal Year of Current Period
59	LFPOS	LFPOS	MBLPO	NUMC	4	0	Item of a reference document
60	LIFNR2	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	*
61	MATKL	MATKL	MATKL	CHAR	9	0	Material Group	*
62	MATNR	MATNR	MATNR	CHAR	18	0	Material Number	*
63	MEINS	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
64	MENGE	MENGE_D	MENG13	QUAN	13	3	Quantity
65	NETPR	BPREI	WERT11	CURR	11	2	Net Price in Purchasing Document (in Document Currency)
66	NETWR	NETWR	WERTV8	CURR	15	2	Net Value in Document Currency
67	NOQUANTITY	NOQUANTITY	XFELD	CHAR	1	0	No quantity logic (document item without quantity)
68	PEINH	PEINH	PACK3	DEC	5	0	Price unit
69	PSTYP	PSTYP	PSTYP	CHAR	1	0	Item category in purchasing document	*
70	RBMNG	RBMNG	MENG13V	QUAN	13	3	Qty invoiced in vendor invoice in PO order units
71	RBWWR	RBWWR	WERT7	CURR	13	2	Invoice amount in document currency of vendor invoice
72	REFWR	REFWR	WRTV7	CURR	13	2	Invoice Value in Foreign Currency
73	REMNG	REMNG	MENG13	QUAN	13	3	Quantity invoiced
74	RETPO	RETPO	XFELD	CHAR	1	0	Returns Item
75	REWWR	REWWR	WERT7	CURR	13	2	Invoice Amount in Foreign Currency
76	SHKZG	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
77	SPGRC	SPGRC	XFELD	CHAR	1	0	Blocking Reason: Quality
78	SPGRG	SPGRG	XFELD	CHAR	1	0	Blocking Reason: Order Price Quantity
79	SPGRM	SPGRM	XFELD	CHAR	1	0	Blocking Reason: Quantity
80	SPGRP	SPGRP	XFELD	CHAR	1	0	Blocking Reason: Price
81	SPGRQ	SPGRQ	XFELD	CHAR	1	0	Manual Blocking Reason
82	SPGRS	SPGRS	XFELD	CHAR	1	0	Blocking Reason: Item Amount
83	SPGRT	SPGRT	XFELD	CHAR	1	0	Blocking Reason: Date
84	SPGRV	SPGRV	XFELD	CHAR	1	0	Blocking Reason: Project Budget
85	TBTKZ	TBTKZ	TBTKZ	CHAR	1	0	Indicator: Subsequent Debit/Credit
86	TXZ01	TXZ01	TEXT40	CHAR	40	0	Short Text
87	UMREN	UMREN	UMBSN	DEC	5	0	Denominator for conversion to base units of measure
88	UMREZ	UMREZ	UMBSZ	DEC	5	0	Numerator for Conversion to Base Units of Measure
89	WEMNG	WEMNG	MENG13	QUAN	13	3	Quantity of goods received
90	WENWR	WENWR	WERT7	CURR	13	2	Accepted net value of service in foreign currency
91	WEPOS	WEPOS	XFELD	CHAR	1	0	Goods Receipt Indicator
92	WERKS	WERKS_D	WERKS	CHAR	4	0	Plant	*
93	WEUNB	WEUNB	XFELD	CHAR	1	0	Goods Receipt, Non-Valuated
94	WEWWR	WEWWR	WERT7	CURR	13	2	Value of goods received in foreign currency
95	WRBTR	WRBTR	WERT7	CURR	13	2	Amount in document currency
96	.INCLUDE				0	0	Extraction Structure BW: CO Data
97	ANLN1	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	*
98	ANLN2	ANLN2	ANLN2	CHAR	4	0	Asset Subnumber	*
99	AREWW	AREWW	WERT7	CURR	13	2	Clearing value on GR/IR clearing account (transac. currency)
100	AUFNR	AUFNR	AUFNR	CHAR	12	0	Order Number	*
101	BPMNG_F	BPMNG_F		FLTP	16	16	Quantity in PO Price Unit (as Floating Point No. - Int. Fld)
102	FIKRS	FIKRS	FIKRS	CHAR	4	0	Financial Management Area	*
103	FIPOS	FIPOS	FIPOS	CHAR	14	0	Commitment Item	*
104	FISTL	FISTL	FISTL	CHAR	16	0	Funds Center	*
105	FKBER	FKBER	FKBER	CHAR	16	0	Functional Area	*
106	GEBER	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	*
107	GSBER	GSBER	GSBER	CHAR	4	0	Business Area	*
108	KOART	KOART	KOART	CHAR	1	0	Account type
109	KOKRS	KOKRS	CACCD	CHAR	4	0	Controlling Area	*
110	KOSTL	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
111	KTOPL	KTOPL	KTOPL	CHAR	4	0	Chart of Accounts	*
112	LSTAR	LSTAR	LSTAR	CHAR	6	0	Activity Type	*
113	NPLNR	NPLNR	AUFNR	CHAR	12	0	Network Number for Account Assignment	*
114	PAOBJNR	RKEOBJNR	RKEOBJNR	NUMC	10	0	Profitability Segment Number (CO-PA)
115	PRCTR	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
116	PS_PSP_PNR	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	*
117	SAKNR	SAKNR	SAKNR	CHAR	10	0	G/L Account Number	*
118	VORNR	VORNR	VORNR	CHAR	4	0	Operation/Activity Number
119	BUDGET_PD	FM_BUDGET_PERIOD	FM_BUDGET_PERIOD	CHAR	10	0	FM: Budget Period	*
120	ROCANCEL	IV_EXTRACT_RECTYPE	IV_EXTRACT_RECTYPE	CHAR	1	0	Record Type in Extraction of Invoice Verification Data