SAP ABAP Table EK08R (Order Item Data for Invoice Verification)

Hierarchy

☛

BBPCRM (Software Component) BBPCRM
⤷

CRM (Application Component) Customer Relationship Management
⤷

CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷

MR (Package) Incoming Invoices

Basic Data

Table Category	INTTAB	Structure
Structure	EK08R	Table Relationship Diagram
Short Description	Order Item Data for Invoice Verification

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	Joint Fields for EK08RN and EK08BN
2	ANLN1	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	*
3	ANLN2	ANLN2	ANLN2	CHAR	4	0	Asset Subnumber	*
4	APLZL	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
5	AREWR	AREWR	WERT7	CURR	13	2	GR/IR account clearing value in local currency
6	AREWW	AREWW	WERT7	CURR	13	2	Clearing value on GR/IR clearing account (transac. currency)
7	AUFNR	AUFNR	AUFNR	CHAR	12	0	Order Number	*
8	AUFPL	CO_AUFPL	AUFPL	NUMC	10	0	Routing number of operations in the order
9	BASME	F_MEINS	MEINS	UNIT	3	0	Base unit of measure	*
10	BEDAT	BEDAT	DATUM	DATS	8	0	Purchase Order Date
11	BEGRU	BEGRU	BEGRU	CHAR	4	0	Authorization Group
12	BEWAE	BSTWA	WAERS	CUKY	5	0	Purchase order currency	*
13	BPMNG	BPMNG	MENG13	QUAN	13	3	Quantity in order price quantity unit
14	BPUMN	BPUMN	UMBSN	DEC	5	0	Denominator for Conv. of Order Price Unit into Order Unit
15	BPUMZ	BPUMZ	UMBSZ	DEC	5	0	Numerator for Conversion of Order Price Unit into Order Unit
16	BPWEM	BPWEM	MENG13	QUAN	13	3	Goods receipt quantity in order unit
17	BPREM	BPREM	MENG13	QUAN	13	3	Invoice receipt quantity in order price unit
18	BSMNG	BSMNG	MENG13	QUAN	13	3	Quantity ordered against this purchase requisition
19	BUDAT	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
20	BUKRS	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
21	BWTAR	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	*
22	BWTTY	BWTTY_D	BWTTY	CHAR	1	0	Valuation Category	*
23	BZDAT	BZDAT	DATUM	DATS	8	0	Asset Value Date
24	EBELN	BSTNR	EBELN	CHAR	10	0	Purchase order number	EKKO
25	EBELP	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	EKPO
26	FIPOS	FIPOS	FIPOS	CHAR	14	0	Commitment Item	*
27	FISTL	FISTL	FISTL	CHAR	16	0	Funds Center	*
28	FKBER	FKBER	FKBER	CHAR	16	0	Functional Area	*
29	GEBER	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	*
30	GSBER	GSBER	GSBER	CHAR	4	0	Business Area	*
31	HWAER	HWAER	WAERS	CUKY	5	0	Local Currency	*
32	IMKEY	IMKEY	IMKEY	CHAR	8	0	Internal Key for Real Estate Object
33	KDAUF	KDAUF	VBELN	CHAR	10	0	Sales Order Number
34	KDPOS	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
35	KNTTP	KNTTP	KNTTP	CHAR	1	0	Account assignment category	*
36	KOSTL	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
37	KO_GSBER	GSBER_GP	GSBER	CHAR	4	0	Business area reported to the partner	*
38	KO_PARGB	PARGB_GP	GSBER	CHAR	4	0	assumed business area of the business partner	*
39	KO_PRCTR	PRCTR	PRCTR	CHAR	10	0	Profit Center
40	KO_PPRCTR	PPRCTR	PRCTR	CHAR	10	0	Partner Profit Center
41	KSTRG	KSTRG	KSTRG	CHAR	12	0	Cost Object	*
42	KUFIX	KUFIX	XFELD	CHAR	1	0	Indicator: Fixing of Exchange Rate
43	KZBAA	KZBAA	XFELD	CHAR	1	0	Indicator: valuation type is set automatically
44	KZBWS	KZBWS	KZBWS	CHAR	1	0	Valuation of Special Stock
45	KZVBF	KZVBF	XFELD	CHAR	1	0	Valuation type "external procurement" mandatory
46	LANDS	LANDS	LAND1	CHAR	3	0	Country from where output is sent (issuing country)	*
47	MATKL	MATKL	MATKL	CHAR	9	0	Material Group	*
48	MATNR	MATNR	MATNR	CHAR	18	0	Material Number	*
49	MEINS	BSTME	MEINS	UNIT	3	0	Order unit	T006
50	MEPRF	MEPRF	MEPRF	CHAR	1	0	Price Determination (Pricing) Date Control
51	MTART	MTART	MTART	CHAR	4	0	Material type	*
52	NETWR	BSTWR	WERT7	CURR	13	2	Net order value in document currency
53	NOQUANTITY	NOQUANTITY	XFELD	CHAR	1	0	No quantity logic (document item without quantity)
54	NPLNR	NPLNR	AUFNR	CHAR	12	0	Network Number for Account Assignment	*
55	PAOBJNR	RKEOBJNR	RKEOBJNR	NUMC	10	0	Profitability Segment Number (CO-PA)
56	PERNR	PERNR_D	PERNR	NUMC	8	0	Personnel Number
57	PRCTR	PRCTR	PRCTR	CHAR	10	0	Profit Center
58	PS_PSP_PNR	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	*
59	PSTYP	PSTYP	PSTYP	CHAR	1	0	Item category in purchasing document	*
60	RECID	JV_RECIND	JV_RECIND	CHAR	2	0	Recovery Indicator	*
61	REEWR	REEWR	WRTV7	CURR	13	2	Invoice Value Entered (in Local Currency)
62	REFWR	REFWR	WRTV7	CURR	13	2	Invoice Value in Foreign Currency
63	REMNG	REMNG	MENG13	QUAN	13	3	Quantity invoiced
64	RETPO	RETPO	XFELD	CHAR	1	0	Returns Item
65	REWRT	REWRT	WRTV7	CURR	13	2	Invoice value in local currency
66	REWWR	REWWR	WERT7	CURR	13	2	Invoice Amount in Foreign Currency
67	SAKNR	SAKNR	SAKNR	CHAR	10	0	G/L Account Number	*
68	SOBKZ	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	*
69	TXJCD	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
70	UMREN	UMREN	UMBSN	DEC	5	0	Denominator for conversion to base units of measure
71	UMREZ	UMREZ	UMBSZ	DEC	5	0	Numerator for Conversion to Base Units of Measure
72	VBWAF	VBWAF	BWTAR	CHAR	10	0	Default: valuation type "external procurement"	*
73	VPTNR	JV_PART	KUNNR	CHAR	10	0	Partner account number	*
74	WAERS	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
75	WEMNG	WEMNG	MENG13	QUAN	13	3	Quantity of goods received
76	WEPOS	WEPOS	XFELD	CHAR	1	0	Goods Receipt Indicator
77	WERKS	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
78	WEUNB	WEUNB	XFELD	CHAR	1	0	Goods Receipt, Non-Valuated
79	WEWRT	WEWRT	WERT7	CURR	13	2	Value of goods received in local currency
80	WEWWR	WEWWR	WERT7	CURR	13	2	Value of goods received in foreign currency
81	XBLNR	LFSNR	XBLNR	CHAR	16	0	Number of external delivery note
82	LSMNG	LSMNG	MENG13	QUAN	13	3	Quantity in Unit of Measure from Delivery Note
83	LSMEH	LSMEH	MEINS	UNIT	3	0	Unit of Measure From Delivery Note	*
84	.INCLUDE				0	0
85	DABRZ	DABRBEZ	DDAT	DATS	8	0	Reference date for settlement
86	EMATN	EMATN	MATNR	CHAR	18	0	Material number corresponding to manufacturer part number
87	KDATB	KDATB	DATUM	DATS	8	0	Start of Validity Period
88	KDATE	KDATE	DATUM	DATS	8	0	End of Validity Period
89	SUMLIMIT	SUMLIMIT	WERT7	CURR	13	2	Overall Limit
90	SUMNOLIM	NOLIMIT	CHAR01	CHAR	1	0	No Limit
91	ACTVALUE	ACTVALUE	WERTV7	CURR	13	2	Total Value of Unplanned Entered Services
92	WEMMG	WEMMG	MENG13V	QUAN	13	3	Non-valuated goods receipt quantity
93	BPWMM	BPWMM	MENG13V	QUAN	13	3	Non-valuated goods receipt quantity in order price unit
94	.INCLUDE				0	0	Additional Data EK08RN
95	ANZAL	ANZAL	WERT7	CURR	13	2	Total Down Payments in Local Currency
96	BPBSM	BPBSM	MENG13	QUAN	13	3	Ordered quantity in order price unit
97	BPRME	BPRME	MEINS	UNIT	3	0	Order Price Unit (purchasing)	T006
98	EINDT	EINDT	DATUM	DATS	8	0	Item delivery date
99	ERNAM	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
100	FPLNR	IPLNR	CHAR10	CHAR	10	0	Invoicing plan number
101	INCO1	INCO1	CRM_INCOTERMS1	CHAR	3	0	Incoterms (part 1)	*
102	INCO2	INCO2	CRM_INCOTERMS2	CHAR	28	0	Incoterms (part 2)
103	LFBNR	LFBNR	BELNR	CHAR	10	0	Document number of a reference document
104	LFGJA	LFGJA	GJAHR	NUMC	4	0	Fiscal Year of Current Period
105	LFPOS	LFPOS	MBLPO	NUMC	4	0	Item of a reference document
106	MWSKZ	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	*
107	NETPR	NETPR	WERTV6	CURR	11	2	Net price
108	PEINH	PEINH	PACK3	DEC	5	0	Price unit
109	SCHPR	SCHPR	XFELD	CHAR	1	0	Indicator: Estimated Price
110	SSQSS	SSQSS	SSQSS	CHAR	8	0	QA Control Key
111	STATU	ASTAT	ASTAT	CHAR	1	0	RFQ status
112	TWRKZ	TWRKZ	TWRKZ	CHAR	1	0	Partial invoice indicator
113	TXZ01	TXZ01	TEXT40	CHAR	40	0	Short Text
114	VETEN	ETENR	ETENR	NUMC	4	0	Schedule line	*
115	VRTKZ	VRTKZ	VRTKZ	CHAR	1	0	Distribution indicator for multiple account assignment
116	WEBRE	WEBRE	XFELD	CHAR	1	0	Indicator: GR-Based Invoice Verification
117	XERSY	XERSY	XFELD	CHAR	1	0	Evaluated Receipt Settlement (ERS)
118	XSKRL	XSKRL	XFELD	CHAR	1	0	Indicator: Line item not liable to cash discount?
119	XUBNKR	XUBNKR	XFELD	CHAR	1	0	Indicates: Not relevant for unplanned delivery costs?
120	ZEKKN	DZEKKN	NUM02	NUMC	2	0	Sequential Number of Account Assignment
121	KORNR	KORNR	KORNR	CHAR	1	0	Correction of miscellaneous provisions
122	EBONF	EBONF	XFELD	CHAR	1	0	Item Not Relevant to Subseq. (Period-End Rebate) Settlement
123	XUNPL	XUNPL	XFELD	CHAR	1	0	Unplanned Account Assignment from Invoice Verification
124	.INCLUDE				0	0	Additional Data: Dialog Invoice Item with PO Ref.
125	ANBWA	ANBWA	BWASL	CHAR	3	0	Asset Transaction Type	*
126	BELNR	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
127	BEWAR	BEWAR	RMVCT	CHAR	3	0	Consolidation Transaction Type	*
128	BPWES	BPWES	MENG13	QUAN	13	3	Quantity in GR blocked stock in order price unit
129	BUZEI	BUZEI	BUZEI	NUMC	3	0	Number of Line Item Within Accounting Document
130	BWKEY	BWKEY	BWKEY	CHAR	4	0	Valuation area	T001K
131	BWMOD	BWMOD	CHAR4	CHAR	4	0	Valuation grouping code
132	EREKZ	EREKZ	XFELD	CHAR	1	0	Final Invoice Indicator
133	FAUS1	FAUS1	FA050	CHAR	50	0	Account/Posting Key Field Selection
134	FAUS2	FAUS1	FA050	CHAR	50	0	Account/Posting Key Field Selection
135	FMORE	FMORE	XFELD	CHAR	1	0	All additional account assignments
136	GJAHR	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
137	KOKRS	KOKRS	CACCD	CHAR	4	0	Controlling Area	*
138	KTOPL	KTOPL	KTOPL	CHAR	4	0	Chart of Accounts	*
139	LNRAN	LNRAN	LNRAN	NUMC	5	0	Sequence Number of Asset Line Items in Fiscal Year	*
140	MENGE	MENGE_D	MENG13	QUAN	13	3	Quantity
141	MLMAA	CK_ML_MAAC	XFELD	CHAR	1	0	Material ledger activated at material level
142	MLAST	CK_ML_ABST	CK_ML_ABST	CHAR	1	0	Material Price Determination: Control
143	MWSKZ_SKB1	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	*
144	POPTS	POPTSATZ	POPTSATZ	DEC	9	6	Real Estate Option Rate
145	REPOS	REPOS	XFELD	CHAR	1	0	Invoice receipt indicator
146	REUPD	REUPD	XFELD	CHAR	1	0	Account assignment can be changed at time of invoice receipt
147	SELKZ	SELKZ_08	XFELD	CHAR	1	0	Selection indicator
148	SGTXT	SGTXT	TEXT50	CHAR	50	0	Item Text
149	SPGRG	SPGRG	XFELD	CHAR	1	0	Blocking Reason: Order Price Quantity
150	SPGRM	SPGRM	XFELD	CHAR	1	0	Blocking Reason: Quantity
151	SPGRP	SPGRP	XFELD	CHAR	1	0	Blocking Reason: Price
152	SPGRQ	SPGRQ	XFELD	CHAR	1	0	Manual Blocking Reason
153	SPGRT	SPGRT	XFELD	CHAR	1	0	Blocking Reason: Date
154	SPGRV	SPGRV	XFELD	CHAR	1	0	Blocking Reason: Project Budget
155	SPGRS	SPGRS	XFELD	CHAR	1	0	Blocking Reason: Item Amount
156	SPGRC	SPGRC	XFELD	CHAR	1	0	Blocking Reason: Quality
157	SUBRC	SUBRC	EK08R_RC	NUMC	2	0	Subroutines for return code
158	TBTKZ	TBTKZ	TBTKZ	CHAR	1	0	Indicator: Subsequent Debit/Credit
159	VTEXT	VTEXT	TEXT20	CHAR	20	0	Description
160	WESBS	WESBS	MENG13	QUAN	13	3	Goods receipt blocked stock in order unit
161	WRBTR	WRBTR	WERT7	CURR	13	2	Amount in document currency
162	WMWST	WMWST	WERT7	CURR	13	2	Tax amount in document currency
163	XDETA	XDETA	XFELD	CHAR	1	0	Indicator: display detail screen
164	XLBPD	XLBPD	XFELD	CHAR	1	0	Price difference posting in GR for subcontract oder
165	XMWST	XMWST	XFELD	CHAR	1	0	Calculate tax automatically
166	XPRUE	XPRUE	XFELD	CHAR	1	0	Indicator: check item
167	ZUONR	DZUONR	ZUONR	CHAR	18	0	Assignment number

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column

1	EK08R	BPRME	T006	MSEHI
2	EK08R	BUKRS	T001	BUKRS
3	EK08R	BWKEY	T001K	BWKEY
4	EK08R	EBELN	EKKO	EBELN
5	EK08R	EBELP	EKPO	EBELP
6	EK08R	MEINS	T006	MSEHI
7	EK08R	WAERS	TCURC	WAERS
8	EK08R	WERKS	T001W	WERKS

History

Last changed by/on	SAP	20130604
SAP Release Created in

Object Hierarchy

Using

Used by

Advertise Links