SAP ABAP Table MC45W_0ITM (Agency business extraction: Item data)

Hierarchy

☛

SAP_APPL (Software Component) Logistics and Accounting
⤷

LO-LIS (Application Component) Logistics Information System (LIS)
⤷

MCEX (Package) Extraction Interface LIS-BW

Basic Data

Table Category	INTTAB	Structure
Structure	MC45W_0ITM	Table Relationship Diagram
Short Description	Agency business extraction: Item data

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	ROCANCEL	ROCANCEL	BOOLE	CHAR	1	0	Indicator: Cancel Data Record
2	.INCLUDE				0	0	Agency business extraction: Item data
3	ABART	NAFKT	NAFKT	CHAR	1	0	Settlement Type
4	BLDAT	BLDAT	DATUM	DATS	8	0	Document Date in Document
5	BUKRS	BUKRS	BUKRS	CHAR	4	0	Company Code	*
6	CPDK_ADDR	WLF_CPDK_ADDR	AD_ADDRNUM	CHAR	10	0	Agency Business: Address of One-Time Customer	*
7	EKGRP	EKGRP	EKGRP	CHAR	3	0	Purchasing group	*
8	EKORG	EKORG	EKORG	CHAR	4	0	Purchasing organization	*
9	FKSTO	FKSTO	XFELD	CHAR	1	0	Billing document is cancelled
10	FKSTO_PART	WLF_FKSTO_PART	XFELD	CHAR	1	0	Partial Reversal
11	FKSTO_PARTY	WLF_FKSTO_PARTY	WLF_FKSTO_PARTY	CHAR	1	0	Cancelled Partner
12	GSKTO	SKFBP	WERTV7	CURR	13	2	Amount eligible for cash discount in document currency
13	GSKTOD	SKFBP	WERTV7	CURR	13	2	Amount eligible for cash discount in document currency
14	HWAER	HWAER	WAERS	CUKY	5	0	Local Currency	*
15	KKBER	KKBER	KKBER	CHAR	4	0	Credit control area	*
16	KUNRE	KUNRE	KUNNR	CHAR	10	0	Bill-to party	*
17	KUNRG	KUNRG	KUNNR	CHAR	10	0	Payer	*
18	KURST	KURST	KURST	CHAR	4	0	Exchange Rate Type	*
19	LANDL	LANDL	LAND1	CHAR	3	0	Supplying Country	*
20	LFART	WFART	WFART	CHAR	4	0	Agency business: Billing document type	*
21	LFTYP	WFTYP	WFTYP	CHAR	2	0	Agency business: Billing category
22	LIFRE	LIFRE	LIFNR	CHAR	10	0	Different Invoicing Party	*
23	LNRZB	W_LIFZE	LIFNR	CHAR	10	0	Agency business: Payee	*
24	LOGSYS	LOGSYS	LOGSYS	CHAR	10	0	Logical system	*
25	MWSBK	MWSBP	WERTV7	CURR	13	2	Tax amount in document currency
26	MWSBKD	MWSBPD	WERTV7	CURR	13	2	Tax amount in document currency (customer-side)
27	NARVF	NARVF	XFELD	CHAR	1	0	Vendor billing document is relevant for subseq. settlement
28	NAVNK	NAVNW	WERT7	CURR	13	2	Non-deductible input tax
29	POST_PARTY	WLF_POST_PARTY	WLF_POST_PARTY	CHAR	1	0	Posting Partner
30	SETTLE_CATEGORY	WSETTLE_CATEGORY	WSETTLE_CATEGORY	CHAR	1	0	Settlement Attributes
31	SETTLE_DOC	WLF_EXP_SETTLE_DOC	WBELN	CHAR	10	0	Global Trade Expenses: Settlement Document	*
32	SPART	SPART	SPART	CHAR	2	0	Division	*
33	VKBUR	VKBUR	VKBUR	CHAR	4	0	Sales office	*
34	VKGRP	VKGRP	VKGRP	CHAR	3	0	Sales group	*
35	VKORG	VKORG	VKORG	CHAR	4	0	Sales Organization	*
36	VTWEG	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
37	WAERL	WAERL	WAERS	CUKY	5	0	Currency of Agency Document	*
38	WBTYP	WBTYP	WBTYP	CHAR	1	0	Settlement request: Payment type
39	WDTYP	DOCTYPE	DOCTYPE	CHAR	1	0	Agency Business: Document Category
40	WFDAT	WFDAT	DATUM	DATS	8	0	Agency business: Posting date
41	WFDAT_RL	WFDAT_RL	DATUM	DATS	8	0	Agency Business: Posting Date for the Remuneration List
42	WKURS	WKURS	KURSP	DEC	9	5	Exchange Rate
43	WKURS_DAT	WWERT_D	DATUM	DATS	8	0	Translation date
44	WRART	WRART	WRART	CHAR	4	0	Agency business: Payment type	*
45	WRTYP	WRTYP	WRTYP	CHAR	1	0	Entry category: payment
46	WSTWAE	WSTWAE	WAERS	CUKY	5	0	Agency Business: Statistics Currency	*
47	ZEITP	DZEITP	ZEITP	CHAR	2	0	Event for which updating should take place	*
48	.INCLUDE				0	0	BW agency extraction: Document item MCWBRP
49	AKTNR	WAKTION	WAKTION	CHAR	10	0	Promotion	*
50	BONBA	BONBA	WERTV7	CURR	13	2	Rebate basis 1
51	BONBAD	BONBA	WERTV7	CURR	13	2	Rebate basis 1
52	BRGEW	BRGEW_15	MENG15	QUAN	15	3	Gross weight
53	BRTWR	BRTWR_LFP	WERTV8	CURR	15	2	Gross value of the item in document currency
54	BRTWRD	BRTWRD_LFP	WERTV8	CURR	15	2	Gross value of item in document currency (customer-side)
55	CHARG	CHARG_D	CHARG	CHAR	10	0	Batch Number	*
56	CONTRACT	WCONTRACT	WCONTRACT	CHAR	10	0	Referencing Contract Number
57	CONTRACT_TYPE	WCONTRACT_TYPE	WCONTRACT_TYPE	CHAR	1	0	Contract Type for Contract Number
58	EFFWR	EFFWR	WERT7	CURR	13	2	Effective value of item
59	EFFWRD	EFFWRD	WERTV7	CURR	13	2	Effective value of the item (customer-side)
60	EKKOL	EKKOG	CHAR4	CHAR	4	0	Condition Group with Vendor
61	ERDAT	ERDAT	DATUM	DATS	8	0	Date on which the record was created
62	FPRME	WFPRME	MEINS	UNIT	3	0	Billing price unit	*
63	FPUMN	WPUMN	UMBSZ	DEC	5	0	Vendor billing doc.: denominator for converting BPUn to PBUn
64	FPUMZ	WPUMZ	UMBSZ	DEC	5	0	Vendor billing doc.: numerator for converting BPUn to PBUn
65	GEWEI	GEWEI	MEINS	UNIT	3	0	Weight Unit	*
66	GSBER	GSBER	GSBER	CHAR	4	0	Business Area	*
67	ITEMCAT	WSHKZG	WSHKZG	CHAR	1	0	Agency Business: Item Category
68	KOKRS	KOKRS	CACCD	CHAR	4	0	Controlling Area	*
69	KOLIF	KOLIF	LIFNR	CHAR	10	0	Prior Vendor	*
70	KOSTL	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
71	KZWI1	KZWI1	WERTV7	CURR	13	2	Subtotal 1 from pricing procedure for condition
72	KZWI1D	KZWI1	WERTV7	CURR	13	2	Subtotal 1 from pricing procedure for condition
73	KZWI2	KZWI2	WERTV7	CURR	13	2	Subtotal 2 from pricing procedure for condition
74	KZWI2D	KZWI2	WERTV7	CURR	13	2	Subtotal 2 from pricing procedure for condition
75	KZWI3	KZWI3	WERTV7	CURR	13	2	Subtotal 3 from pricing procedure for condition
76	KZWI3D	KZWI3	WERTV7	CURR	13	2	Subtotal 3 from pricing procedure for condition
77	KZWI4	KZWI4	WERTV7	CURR	13	2	Subtotal 4 from pricing procedure for condition
78	KZWI4D	KZWI4	WERTV7	CURR	13	2	Subtotal 4 from pricing procedure for condition
79	KZWI5	KZWI5	WERTV7	CURR	13	2	Subtotal 5 from pricing procedure for condition
80	KZWI5D	KZWI5	WERTV7	CURR	13	2	Subtotal 5 from pricing procedure for condition
81	KZWI6	KZWI6	WERTV7	CURR	13	2	Subtotal 6 from pricing procedure for condition
82	KZWI6D	KZWI6	WERTV7	CURR	13	2	Subtotal 6 from pricing procedure for condition
83	LFGRU	WFGRU	WFGRU	CHAR	3	0	Agency business: Reason for activity	*
84	LTSNR	LTSNR	LTSNR	CHAR	6	0	Vendor Subrange	*
85	MATBF	MATBF	MATNR	CHAR	18	0	Material in Respect of Which Stock is Managed	*
86	MATKL	MATKL	MATKL	CHAR	9	0	Material Group	*
87	MATNR	MATNR	MATNR	CHAR	18	0	Material Number	*
88	MEINS	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
89	MENGE	WFIMG	MENGE13	QUAN	13	3	Vendor billing document: actual quantity billed
90	MTART	MTART	MTART	CHAR	4	0	Material type	*
91	MWERT_IM	NETWR	WERTV8	CURR	15	2	Net Value in Document Currency
92	MWERT_PR	NETWR	WERTV8	CURR	15	2	Net Value in Document Currency
93	MWERT_UM	NETWR	WERTV8	CURR	15	2	Net Value in Document Currency
94	MWSBP	MWSBP	WERTV7	CURR	13	2	Tax amount in document currency
95	MWSBPD	MWSBPD	WERTV7	CURR	13	2	Tax amount in document currency (customer-side)
96	MWSK2	MWSKZ_RB	MWSKZ	CHAR	2	0	Agency business: Tax code (output tax)	*
97	MWSKZ	MWSKZ_LF	MWSKZ	CHAR	2	0	Agency business: Tax code (input tax)	*
98	NAVNW	NAVNW	WERT7	CURR	13	2	Non-deductible input tax
99	NETWR	NETWR_LFP	WERTV8	CURR	15	2	Net value of the item in document currency
100	NETWRD	NETWRD_LFP	WERTV8	CURR	15	2	Net value of the item in document currency (customer-side)
101	NTGEW	NTGEW_15	MENG15	QUAN	15	3	Net weight
102	PEINH	WEINH	DEC5	DEC	5	0	Price Unit of Vendor Billing Document Item
103	POSNR	WPOSNR_LF	WPOSNR	NUMC	6	0	Agency business: Document item	*
104	PRCTR	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
105	PRSDT	PRSDT	DATUM	DATS	8	0	Date for pricing and exchange rate
106	SKFBP	SKFBP	WERTV7	CURR	13	2	Amount eligible for cash discount in document currency
107	SKFBPD	SKFBPD	WERTV7	CURR	13	2	Amount qualifying for cash discount in doc. currency (cust.)
108	STAFO	STAFO	STAFO	CHAR	6	0	Update group for statistics update	*
109	TXJCD	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
110	UMREN	UMWFN	UMBSN	DEC	5	0	Factor for converting qty in vendor bill. doc. to base unit
111	UMREZ	UMWFZ	UMBSZ	DEC	5	0	Numerator converting qty in vendor bill.doc. to base unit
112	VOLEH	VOLEH	MEINS	UNIT	3	0	Volume unit	*
113	VOLUM	VOLUM_15	MENG15	QUAN	15	3	Volume
114	WBELN	WBELN_AG	WBELN	CHAR	10	0	Agency Business: Document Number	*
115	WBELN_V	WBELN_V	CHAR10	CHAR	10	0	Triggering document of the agency document
116	WERKS	WERKS_D	WERKS	CHAR	4	0	Plant	*
117	WFKME	WFKME	MEINS	UNIT	3	0	Vendor billing document: unit of measure	*
118	PERIV	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	*
119	ANZRG	MC_AWBRKRG	MCZAEHLER	DEC	9	0	Key figure: Number of payment requests
120	ANZLF	MC_AWBRKRL	MCZAEHLER	DEC	9	0	Key figure: Number of vendor billing documents
121	ANZCS	MC_AWBRKCS	MCZAEHLER	DEC	9	0	Key Figure: Number of Customer Settlements
122	ANZPOSRL	MC_ARLRPRGRLAL	MCZAEHLER	DEC	9	0	Key figure: Number of documents in request lists (payment)
123	ANZPOSLF	MC_AWBRPRL	MCZAEHLER	DEC	9	0	Key figure: No. of vendor billing document items
124	ANZPOSRG	MC_AWBRPRG	MCZAEHLER	DEC	9	0	Key figure: Number of payment request items
125	ANZPOSCS	MC_AWBRPCS	MCZAEHLER	DEC	9	0	Key Figure: Number of Line Items in Customer Settlement
126	.INCLU--AP				0	0	Append Structure WBRK GTM
127	DUMMY	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
128	.INCLU--AP				0	0	Add-On Data for Remuneration List Enhancement
129	RRLCG	RRLCG	RRLCG	CHAR	4	0	AB-RRLE: Condition Type Group	*
130	RRLPA	RRLPA	RRLPA	CHAR	1	0	AB-RRLE: Remuneration List Partner
131	REFSITE	REFSITE	WERKS	CHAR	4	0	Reference Plant	*
132	.INCLU--AP				0	0	Add-On Append Structure For WBRK Global Trade
133	DOC_SETTLED	WB2_EXP_DOCUMENT_SETTLED	WB2_EXP_DOCUMENT_SETTLED	CHAR	1	0	GT Expenses: Document Settled
134	EXP_CALC_TYPE	WB2_EXPENSE_CALC_TYPE	WB2_EXPENSE_CALC_TYPE	CHAR	1	0	GT Expenses: Calculation Type
135	EXP_CLASS	WB2_EXPENSE_CLASS	WB2_EXPENSE_CLASS	CHAR	3	0	GT Expenses: Expense Class	*
136	PARTNER_EXP	PRQ_PARNO	PRQ_PARNO	CHAR	10	0	Business Partner
137	POST_TYPE	WB2_EXPENSE_POSTING_TYPE	WB2_EXPENSE_POSTING_TYPE	CHAR	1	0	GT Expenses: Posting Type of Expenses	*
138	REF_VALUE	WB2_EXPENSE_REFERENCE_VALUE	WERTV6	CURR	11	2	Global Trade Reference Value for Expenses
139	REF_VALUE_REF	WB2_EXPENSE_REF_VALUE_REF	WAERS	CUKY	5	0	Ref. Field for GT Expenses Ref. Value (Currency, %, Unit)	*
140	STEP	WB2_STEP	WB2_STEP	CHAR	4	0	Business Process Step
141	STEP_FROM	WB2_STEP	WB2_STEP	CHAR	4	0	Business Process Step
142	STEP_TEW	WB2_STEP	WB2_STEP	CHAR	4	0	Business Process Step