SAP ABAP Table EK08RB (Purchase Order History for Invoice Verification)

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	EK08RB	Table Relationship Diagram
Short Description	Purchase Order History for Invoice Verification

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	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	EKGRP	☐	BKGRP	EKGRP	CHAR	3	0	Purchasing Group	*
14	BPMNG	☐	BPMNG	MENG13	QUAN	13	3	Quantity in order price quantity unit
15	BPRME	☐	BPRME	MEINS	UNIT	3	0	Order Price Unit (purchasing)	*
16	BPUMN	☐	BPUMN	UMBSN	DEC	5	0	Denominator for Conv. of Order Price Unit into Order Unit
17	BPUMZ	☐	BPUMZ	UMBSZ	DEC	5	0	Numerator for Conversion of Order Price Unit into Order Unit
18	BPWEM	☐	BPWEM	MENG13	QUAN	13	3	Goods receipt quantity in order unit
19	BPREM	☐	BPREM	MENG13	QUAN	13	3	Invoice receipt quantity in order price unit
20	BSMNG	☐	BSMNG	MENG13	QUAN	13	3	Quantity ordered against this purchase requisition
21	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
22	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
23	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	*
24	BWTTY	☐	BWTTY_D	BWTTY	CHAR	1	0	Valuation Category	*
25	BZDAT	☐	BZDAT	DATUM	DATS	8	0	Asset Value Date
26	EBELN	☐	BSTNR	EBELN	CHAR	10	0	Purchase order number	*
27	EBELP	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	*
28	FIPOS	☐	FIPOS	FIPOS	CHAR	14	0	Commitment Item	*
29	FISTL	☐	FISTL	FISTL	CHAR	16	0	Funds Center	*
30	FKBER	☐	FKBER	FKBER	CHAR	16	0	Functional Area	*
31	GEBER	☐	FM_FUND	BP_GEBER	CHAR	10	0	Fund	*
32	GRANT_NBR	☐	GM_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	Grant
33	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
34	KBLNR	☐	KBLNR_FI	KBLNR	CHAR	10	0	Document number for earmarked funds	*
35	KBLPOS	☐	KBLPOS	KBLPOS	NUMC	3	0	Earmarked Funds: Document Item	*
36	HWAER	☐	HWAER	WAERS	CUKY	5	0	Local Currency	*
37	IMKEY	☐	IMKEY	IMKEY	CHAR	8	0	Internal Key for Real Estate Object
38	KDAUF	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	*
39	KDPOS	☐	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
40	KNTTP	☐	KNTTP	KNTTP	CHAR	1	0	Account assignment category	*
41	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
42	KO_GSBER	☐	GSBER_GP	GSBER	CHAR	4	0	Business area reported to the partner	*
43	KO_PARGB	☐	PARGB_GP	GSBER	CHAR	4	0	assumed business area of the business partner	*
44	KO_PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
45	KO_PPRCTR	☐	PPRCTR	PRCTR	CHAR	10	0	Partner Profit Center	*
46	KSTRG	☐	KSTRG	KSTRG	CHAR	12	0	Cost Object	*
47	KUFIX	☐	KUFIX	XFELD	CHAR	1	0	Indicator: Fixing of Exchange Rate
48	KZBAA	☐	KZBAA	XFELD	CHAR	1	0	Indicator: valuation type is set automatically
49	KZBWS	☐	KZBWS	KZBWS	CHAR	1	0	Valuation of Special Stock
50	KZVBF	☐	KZVBF	XFELD	CHAR	1	0	Valuation type "external procurement" mandatory
51	LANDS	☐	LANDS	LAND1	CHAR	3	0	Country from where output is sent (issuing country)	*
52	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	*
53	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
54	MEINS	☐	BSTME	MEINS	UNIT	3	0	Order unit	*
55	MEPRF	☐	MEPRF	MEPRF	CHAR	1	0	Price Determination (Pricing) Date Control
56	MTART	☐	MTART	MTART	CHAR	4	0	Material type	*
57	NETWR	☐	BSTWR	WERT7	CURR	13	2	Net order value in document currency
58	NOQUANTITY	☐	NOQUANTITY	XFELD	CHAR	1	0	No quantity logic (document item without quantity)
59	NPLNR	☐	NPLNR	AUFNR	CHAR	12	0	Network Number for Account Assignment	*
60	PAOBJNR	☐	RKEOBJNR	RKEOBJNR	NUMC	10	0	Profitability Segment Number (CO-PA)
61	PERNR	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
62	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
63	PS_PSP_PNR	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	*
64	PSTYP	☐	PSTYP	PSTYP	CHAR	1	0	Item category in purchasing document	*
65	RECID	☐	JV_RECIND	JV_RECIND	CHAR	2	0	Recovery Indicator	*
66	REEWR	☐	REEWR	WRTV7	CURR	13	2	Invoice Value Entered (in Local Currency)
67	REFWR	☐	REFWR	WRTV7	CURR	13	2	Invoice Value in Foreign Currency
68	REMNG	☐	REMNG	MENG13	QUAN	13	3	Quantity invoiced
69	RETPO	☐	RETPO	XFELD	CHAR	1	0	Returns Item
70	REWRT	☐	REWRT	WRTV7	CURR	13	2	Invoice value in local currency
71	REWWR	☐	REWWR	WERT7	CURR	13	2	Invoice Amount in Foreign Currency
72	SAKNR	☐	SAKNR	SAKNR	CHAR	10	0	G/L Account Number	*
73	SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	*
74	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
75	UMREN	☐	UMREN	UMBSN	DEC	5	0	Denominator for conversion to base units of measure
76	UMREZ	☐	UMREZ	UMBSZ	DEC	5	0	Numerator for Conversion to Base Units of Measure
77	VBWAF	☐	VBWAF	BWTAR	CHAR	10	0	Default: valuation type "external procurement"	*
78	VPTNR	☐	JV_PART	KUNNR	CHAR	10	0	Partner account number	*
79	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
80	WEMNG	☐	WEMNG	MENG13	QUAN	13	3	Quantity of goods received
81	WEPOS	☐	WEPOS	XFELD	CHAR	1	0	Goods Receipt Indicator
82	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
83	WEUNB	☐	WEUNB	XFELD	CHAR	1	0	Goods Receipt, Non-Valuated
84	WEWRT	☐	WEWRT	WERT7	CURR	13	2	Value of goods received in local currency
85	WEWWR	☐	WEWWR	WERT7	CURR	13	2	Value of goods received in foreign currency
86	WENWR	☐	WENWR	WERT7	CURR	13	2	Accepted net value of service in foreign currency
87	XBLNR	☐	LFSNR1	XBLNR1	CHAR	16	0	Number of External Delivery Note
88	ZEKKN	☐	DZEKKN	NUM02	NUMC	2	0	Sequential Number of Account Assignment
89	LSMNG	☐	MRM_LSMNG	MENGV13	QUAN	13	3	Quantity from Delivery Note
90	LSMEH	☐	LSMEH	MEINS	UNIT	3	0	Unit of Measure From Delivery Note	*
91	.INCLUDE	☐				0	0
92	DABRZ	☐	DABRBEZ	DDAT	DATS	8	0	Reference date for settlement
93	EMATN	☐	EMATN	MATNR	CHAR	18	0	Material number corresponding to manufacturer part number	*
94	KDATB	☐	KDATB	DATUM	DATS	8	0	Start of Validity Period
95	KDATE	☐	KDATE	DATUM	DATS	8	0	End of Validity Period
96	SUMLIMIT	☐	SUMLIMIT	WERT7	CURR	13	2	Overall Limit
97	SUMNOLIM	☐	NOLIMIT	CHAR01	CHAR	1	0	No Limit
98	ACTVALUE	☐	ACTVALUE	WERTV7	CURR	13	2	Total Value of Unplanned Entered Services
99	WEMMG	☐	WEMMG	MENG13V	QUAN	13	3	Non-valuated goods receipt quantity
100	BPWMM	☐	BPWMM	MENG13V	QUAN	13	3	Non-valuated goods receipt quantity in order price unit
101	LSTAR	☐	LSTAR	LSTAR	CHAR	6	0	Activity Type	*
102	PRZNR	☐	CO_PRZNR	CO_PRZNR	CHAR	12	0	Business Process	*
103	WENAM	☐	WENAM	UNAME	CHAR	12	0	Goods receipt entered by
104	AFNAM	☐	AFNAM	AFNAM	CHAR	12	0	Name of requisitioner/requester
105	REBEL	☐	REBEL	REBEL	CHAR	10	0	Referenced document
106	REPOS	☐	REPOS	XFELD	CHAR	1	0	Invoice receipt indicator
107	AREWB	☐	AREWB	WERT7	CURR	13	2	Clearing Value on GR/IR Account in PO Currency
108	TWRKZ	☐	TWRKZ	TWRKZ	CHAR	1	0	Partial invoice indicator
109	REWRB	☐	REWRB	WERT7	CURR	13	2	Invoice Amount in PO Currency
110	WEWRB	☐	WEWRB	WERT7	CURR	13	2	Value of Goods Received in PO Currency
111	XBESW	☐	XBESW	XFELD	CHAR	1	0	Indicator: Update in PO Currency
112	WESBB	☐	WESBB	MENG13	QUAN	13	3	Valuated Goods Receipt Blocked Stock in Order Unit
113	BPWEB	☐	BPWEB	MENG13	QUAN	13	3	Quantity in Valuated GR Blocked Stock in Order Price Unit
114	KUDIF	☐	KUDIF	WERT7	CURR	13	2	Exchange Rate Difference Amount
115	BSMNG_F	☐	SHARE_F		FLTP	16	16	Quantity Share Account Assignment Line for Item
116	REMNG_F	☐	SHARE_F		FLTP	16	16	Quantity Share Account Assignment Line for Item
117	WEMNG_F	☐	SHARE_F		FLTP	16	16	Quantity Share Account Assignment Line for Item
118	BPREM_F	☐	SHARE_F		FLTP	16	16	Quantity Share Account Assignment Line for Item
119	BPWEM_F	☐	SHARE_F		FLTP	16	16	Quantity Share Account Assignment Line for Item
120	XHISTMA	☐	XHISTMA	CHAR1	CHAR	1	0	Update Multiple Account Assignment EKBE_MA, EKBZ_MA
121	XUNPL	☐	XUNPL	XFELD	CHAR	1	0	Unplanned Account Assignment from Invoice Verification
122	VRTKZ	☐	VRTKZ	VRTKZ	CHAR	1	0	Distribution indicator for multiple account assignment
123	WKURS_IR	☐	WKURS	KURSP	DEC	9	5	Exchange Rate
124	WKURS_GR	☐	WKURS	KURSP	DEC	9	5	Exchange Rate
125	MEASURE	☐	FM_MEASURE	FM_MEASURE	CHAR	24	0	Funded Program	*
126	BUDGET_PD	☐	FM_BUDGET_PERIOD	FM_BUDGET_PERIOD	CHAR	10	0	FM: Budget Period	*
127	LAST_GR_DATE	☐	LAST_GR_DATE	DATUM	DATS	8	0	Last Goods Receipt Date
128	LAST_DELIV_DATE	☐	LAST_DELIV_DATE	DATUM	DATS	8	0	Last Allowed Delivery Date
129	AA_FINAL_IND	☐	AA_FINAL_IND	XFELD	CHAR	1	0	Final Account Assignment Indicator
130	AA_FINAL_QTY	☐	AA_FINAL_QTY	MENG13	QUAN	13	3	Final Account Assignment Quantity
131	AA_FINAL_QTY_F	☐	AA_FINAL_QTY_F		FLTP	16	16	Final Account Assignment Quantity (Floating Point Number)
132	PARKED_QTY	☐	PARKED_QTY	MENG13	QUAN	13	3	Parked Invoice Quantity
133	PARKED_QTY_F	☐	PARKED_QTY_F		FLTP	16	16	Parked Invoice Quantity (Floating Point Number)
134	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	*
135	XDINV	☐	XDINV	CHAR1	CHAR	1	0	Indicator for Differential Invoicing
136	XCPRF	☐	XCPRF	CHAR1	CHAR	1	0	Checkbox for Commodity Repricing in Invoice Verification
137	FINAL_INV_EXIST	☐	FINAL_INV_EXIST	CHAR1	CHAR	1	0	Differential Invoicing: Final Invoice Exists
138	PRICING_QTY_GR	☐	BPWEM	MENG13	QUAN	13	3	Goods receipt quantity in order unit
139	KUDIF_GR	☐	KUDIF	WERT7	CURR	13	2	Exchange Rate Difference Amount
140	KUDIF_IR	☐	KUDIF	WERT7	CURR	13	2	Exchange Rate Difference Amount
141	.INCLU--AP	☐				0	0	Joint Venture Fields
142	VNAME	☐	JV_NAME	JV_NAME	CHAR	6	0	Joint venture	*
143	EGRUP	☐	JV_EGROUP	JV_EGROUP	CHAR	3	0	Equity group	*
144	ETYPE	☐	JV_ETYPE	JV_ETYPE	CHAR	3	0	Equity type	T8JG
145	.INCLU--AP	☐				0	0	seconnd tax base value for india version
146	NEBTR	☐	NEBTR	WERT7	CURR	13	2	Net Payment Amount
147	.INCLUDE	☐				0	0	Additional Data EK08RN
148	ANZAL	☐	ANZAL	WERT7	CURR	13	2	Total Down Payments in Local Currency
149	BPBSM	☐	BPBSM	MENG13	QUAN	13	3	Ordered quantity in order price unit
150	BPWES	☐	BPWES	MENG13	QUAN	13	3	Quantity in GR blocked stock in order price unit
151	EINDT	☐	EINDT	DATUM	DATS	8	0	Item delivery date
152	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
153	FPLNR	☐	IPLNR	CHAR10	CHAR	10	0	Invoicing plan number
154	INCO1	☐	INCO1	INCO1	CHAR	3	0	Incoterms (part 1)	TINC
155	INCO2	☐	INCO2	INCO2	CHAR	28	0	Incoterms (part 2)
156	LFBNR	☐	LFBNR	BELNR	CHAR	10	0	Document number of a reference document
157	LFGJA	☐	LFGJA	GJAHR	NUMC	4	0	Fiscal Year of Current Period
158	LFPOS	☐	LFPOS	MBLPO	NUMC	4	0	Item of a reference document
159	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	T007A
160	NETPR	☐	NETPR	WERTV6	CURR	11	2	Net price
161	PEINH	☐	PEINH	PACK3	DEC	5	0	Price unit
162	SCHPR	☐	SCHPR	XFELD	CHAR	1	0	Indicator: Estimated Price
163	SSQSS	☐	SSQSS	SSQSS	CHAR	8	0	QA Control Key
164	STATU	☐	ASTAT	ASTAT	CHAR	1	0	RFQ status
165	TXZ01	☐	TXZ01	TEXT40	CHAR	40	0	Short Text
166	VETEN	☐	ETENR	ETENR	NUMC	4	0	Schedule line	*
167	WEBRE	☐	WEBRE	XFELD	CHAR	1	0	Indicator: GR-Based Invoice Verification
168	WESBS	☐	WESBS	MENG13	QUAN	13	3	Goods receipt blocked stock in order unit
169	XERSY	☐	XERSY	XFELD	CHAR	1	0	Evaluated Receipt Settlement (ERS)
170	XSKRL	☐	XSKRL	XFELD	CHAR	1	0	Indicator: Line item not liable to cash discount?
171	XUBNKR	☐	XUBNKR	XFELD	CHAR	1	0	Indicates: Not relevant for unplanned delivery costs?
172	KORNR	☐	KORNR	KORNR	CHAR	1	0	Correction of miscellaneous provisions
173	EBONF	☐	EBONF	XFELD	CHAR	1	0	Item Not Relevant to Subseq. (Period-End Rebate) Settlement
174	FKNUM	☐	FKNUM	FKNUM	CHAR	10	0	Shipment cost number	*
175	FKPOS	☐	FKPOS	FKPOS	NUMC	6	0	Shipment costs item	*
176	FKPTY	☐	FKPTY	FKPTY	CHAR	4	0	Item category shipment costs	*
177	EXTI1	☐	EXTI1	TEXT20	CHAR	20	0	External identification 1
178	.INCLUDE	☐				0	0	SRM Fields in Purchase Order Item
179	EXLIN	☐	EXLIN	EXLIN	CHAR	40	0	Item Number Length
180	EXSNR	☐	EXSNR	EXSNR	NUMC	5	0	External Sorting
181	EHTYP	☐	EHTYP	EHTYP	CHAR	4	0	External Hierarchy Category	TMSRM_EHTYP
182	RETSUM_FC	☐	RET_SUM_FC	WERT7	CURR	13	2	Total of Retention Amounts in Document Currency
183	RETSUM_LC	☐	RET_SUM_LC	WERT7	CURR	13	2	Total of Retention Amounts in Company Code Currency
184	RETSUMP_FC	☐	RET_SUM_POST_FC	WERT7	CURR	13	2	Total Retention Amount Posted To Date in Document Currency
185	RETSUMP_LC	☐	RET_SUM_POST_LC	WERT7	CURR	13	2	Total Retention Amount Posted in Company Code Currency
186	RETPC	☐	RETPZ	PRZ32	DEC	5	2	Retention in Percent
187	RETTP	☐	RETTP	RET_TYPE	CHAR	1	0	Retention Indicator
188	TRMRISK_RELEVANT	☐	PUR_TRM_RISK_RELEVANCY	LOGTRM_RISK_RELEVANCY	CHAR	2	0	Risk Relevancy in Purchasing
189	.INCLU--AP	☐				0	0	Empties Management: DRSEG Enhancement
190	.INCLUDE	☐				0	0	Empties Management: DRSEG Enhancement
191	/BEV1/NEGEN_ITEM	☐	/BEV1/NEGEN_ITEM_FLAG	XFELD	CHAR	1	0	Indicator: Item Is Generated
192	/BEV1/NESTRUCCAT	☐	/BEV1/NESTRUC_CAT	/BEV1/NESTRUC_CAT	CHAR	1	0	Structure Category for Material Relationship
193	.INCLUDE	☐				0	0	Additional Data EK08RB for Batch Invoice Verification
194	MBLNR	☐	MBLNR	BELNR	CHAR	10	0	Number of Material Document
195	MJAHR	☐	MJAHR	GJAHR	NUMC	4	0	Year of material document
196	MBLPO	☐	MBLPO	MBLPO	NUMC	4	0	Item in material document
197	KNUMVK	☐	KNUMV	KNUMV	CHAR	10	0	Number of the document condition
198	KNUMV	☐	KNUMV	KNUMV	CHAR	10	0	Number of the document condition
199	KNUMVR	☐	KNUMV	KNUMV	CHAR	10	0	Number of the document condition
200	SATNR	☐	SATNR	MATNR	CHAR	18	0	Cross-Plant Configurable Material	MARA
201	EAN11	☐	EAN11	EAN11	CHAR	18	0	International Article Number (EAN/UPC)
202	IDNLF	☐	IDNLF	IDNEX	CHAR	35	0	Material Number Used by Vendor
203	AKTNR	☐	WAKTION	WAKTION	CHAR	10	0	Promotion	WAKH
204	UPVOR	☐	UPVOR	CHAR1	CHAR	1	0	Subitems Exist
205	UPTYP	☐	UPTYP	UPTYP	CHAR	1	0	Subitem Category, Purchasing Document	TMSI1
206	UEBPO	☐	UEBPO	EBELP	NUMC	5	0	Higher-Level Item in Purchasing Documents	EKPO
207	SRVPOS	☐	SRVPOS	ASNUM	CHAR	18	0	Service number	*
208	PACKNO	☐	PACKNO_EKBE	PACKNO	NUMC	10	0	Package Number of Service	*
209	INTROW	☐	INTROW_EKBE	INTROW	NUMC	10	0	Line Number of Service
210	LEBRE	☐	LEBRE	XFELD	CHAR	1	0	Indicator for Service-Based Invoice Verification
211	BEKKN	☐	BEKKN	NUM02	NUMC	2	0	Number of PO Account Assignment
212	PLN_PACKNO	☐	PLN_PACKNO	PACKNO	NUMC	10	0	Source package number	*
213	PLN_INTROW	☐	PLN_INTROW	PACKNO	NUMC	10	0	Entry: Planned package line	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	EK08RB	AKTNR	WAKH	AKTNR
2	EK08RB	EHTYP	TMSRM_EHTYP	EHTYP
3	EK08RB	ETYPE	T8JG	ETYPE
4	EK08RB	INCO1	TINC	INCO1
5	EK08RB	MWSKZ	T007A	MWSKZ
6	EK08RB	SATNR	MARA	MATNR
7	EK08RB	UEBPO	EKPO	EBELP
8	EK08RB	UPTYP	TMSI1	UPTYP

History

Last changed by/on	SAP	20131127
SAP Release Created in