SAP Table EK08RB
Purchase Order History for Invoice Verification
EK08RB (Purchase Order History for Invoice Verification) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link EK08RB to other SAP tables.
EK08RB table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
ANLN1
Main Asset Number
|
ANLN1 |
CHAR
|
12 | 0 | ||||||||||||||||
|
ANLN2
Asset Subnumber
|
ANLN2 |
CHAR
|
4 | 0 | ||||||||||||||||
|
APLZL
Internal counter
|
CIM_COUNT |
NUMC
|
8 | 0 | ||||||||||||||||
|
AREWR
GR/IR account clearing value in local currency
|
AREWR |
CURR
|
13 | 2 | ||||||||||||||||
|
AREWW
Clearing value on GR/IR clearing account (transac. currency)
|
AREWW |
CURR
|
13 | 2 | ||||||||||||||||
|
AUFNR
Order Number
|
AUFNR |
CHAR
|
12 | 0 | ||||||||||||||||
|
AUFPL
Routing number of operations in the order
|
CO_AUFPL |
NUMC
|
10 | 0 | ||||||||||||||||
|
BASME
Base unit of measure
|
F_MEINS |
UNIT
|
3 | 0 | ||||||||||||||||
|
BEDAT
Purchase Order Date
|
BEDAT |
DATS
|
8 | 0 | ||||||||||||||||
|
BEGRU
Authorization Group
|
BEGRU |
CHAR
|
4 | 0 | ||||||||||||||||
|
BEWAE
Purchase order currency
|
BSTWA |
CUKY
|
5 | 0 | ||||||||||||||||
|
EKGRP
Purchasing Group
|
BKGRP |
CHAR
|
3 | 0 | ||||||||||||||||
|
BPMNG
Quantity in Purchase Order Price Unit
|
BPMNG |
QUAN
|
13 | 3 | ||||||||||||||||
|
BPRME
Order Price Unit (Purchasing)
|
BPRME |
UNIT
|
3 | 0 | ||||||||||||||||
|
BPUMN
Denominator for Conv. of Order Price Unit into Order Unit
|
BPUMN |
DEC
|
5 | 0 | ||||||||||||||||
|
BPUMZ
Numerator for Conversion of Order Price Unit into Order Unit
|
BPUMZ |
DEC
|
5 | 0 | ||||||||||||||||
|
BPWEM
Goods Receipt Quantity in Purchase Order Price Unit
|
BPWEM |
QUAN
|
13 | 3 | ||||||||||||||||
|
BPREM
Invoice receipt quantity in order price unit
|
BPREM |
QUAN
|
13 | 3 | ||||||||||||||||
|
BSMNG
Quantity Ordered Against this Purchase Requisition
|
BSMNG |
QUAN
|
13 | 3 | ||||||||||||||||
|
BUDAT
Posting Date in the Document
|
BUDAT |
DATS
|
8 | 0 | ||||||||||||||||
|
BUKRS
Company Code
|
BUKRS |
CHAR
|
4 | 0 | ||||||||||||||||
|
BWTAR
Valuation Type
|
BWTAR_D |
CHAR
|
10 | 0 | ||||||||||||||||
|
BWTTY
Valuation Category
|
BWTTY_D |
CHAR
|
1 | 0 | ||||||||||||||||
|
BZDAT
Asset value date
|
BZDAT |
DATS
|
8 | 0 | ||||||||||||||||
|
EBELN
Purchase Order Number
|
BSTNR |
CHAR
|
10 | 0 | ||||||||||||||||
|
EBELP
Item Number of Purchasing Document
|
EBELP |
NUMC
|
5 | 0 | ||||||||||||||||
|
FIPOS
Commitment Item
|
FIPOS |
CHAR
|
14 | 0 | ||||||||||||||||
|
FISTL
Funds Center
|
FISTL |
CHAR
|
16 | 0 | ||||||||||||||||
|
FKBER
Functional Area
|
FKBER |
CHAR
|
16 | 0 | ||||||||||||||||
|
GEBER
Fund
|
FM_FUND |
CHAR
|
10 | 0 | ||||||||||||||||
|
GRANT_NBR
Grant
|
GM_GRANT_NBR |
CHAR
|
20 | 0 | ||||||||||||||||
|
GSBER
Business Area
|
GSBER |
CHAR
|
4 | 0 | ||||||||||||||||
|
KBLNR
Document Number for Earmarked Funds
|
KBLNR_FI |
CHAR
|
10 | 0 | ||||||||||||||||
|
KBLPOS
Earmarked Funds: Document Item
|
KBLPOS |
NUMC
|
3 | 0 | ||||||||||||||||
|
HWAER
Local Currency
|
HWAER |
CUKY
|
5 | 0 | ||||||||||||||||
|
IMKEY
Internal Key for Real Estate Object
|
IMKEY |
CHAR
|
8 | 0 | ||||||||||||||||
|
KDAUF
Sales Order Number
|
KDAUF |
CHAR
|
10 | 0 | ||||||||||||||||
|
KDPOS
Item Number in Sales Order
|
KDPOS |
NUMC
|
6 | 0 | ||||||||||||||||
|
KNTTP
Account Assignment Category
|
KNTTP |
CHAR
|
1 | 0 | ||||||||||||||||
|
KOSTL
Cost Center
|
KOSTL |
CHAR
|
10 | 0 | ||||||||||||||||
|
KO_GSBER
Business area reported to the partner
|
GSBER_GP |
CHAR
|
4 | 0 | ||||||||||||||||
|
KO_PARGB
assumed business area of the business partner
|
PARGB_GP |
CHAR
|
4 | 0 | ||||||||||||||||
|
KO_PRCTR
Profit Center
|
PRCTR |
CHAR
|
10 | 0 | ||||||||||||||||
|
KO_PPRCTR
Partner Profit Center
|
PPRCTR |
CHAR
|
10 | 0 | ||||||||||||||||
|
KSTRG
Cost Object
|
KSTRG |
CHAR
|
12 | 0 | ||||||||||||||||
|
KUFIX
Indicator: Fixing of Exchange Rate
|
KUFIX |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
KZBAA
Indicator: valuation type is set automatically
|
KZBAA |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
KZBWS
Valuation of Special Stock
|
KZBWS |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
KZVBF
Valuation type "external procurement" mandatory
|
KZVBF |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
LANDS
Country from where output is sent (issuing country)
|
LANDS |
CHAR
|
3 | 0 | ||||||||||||||||
|
MATKL
Material Group
|
MATKL |
CHAR
|
9 | 0 | ||||||||||||||||
|
MATNR
Material Number
|
MATNR |
CHAR
|
18 | 0 | ||||||||||||||||
|
MEINS
Purchase Order Unit of Measure
|
BSTME |
UNIT
|
3 | 0 | ||||||||||||||||
|
MEPRF
Price Determination (Pricing) Date Control
|
MEPRF |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
MTART
Material Type
|
MTART |
CHAR
|
4 | 0 | ||||||||||||||||
|
NETWR
Net order value in document currency
|
BSTWR |
CURR
|
13 | 2 | ||||||||||||||||
|
NOQUANTITY
No quantity logic (document item without quantity)
|
NOQUANTITY |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
NPLNR
Network Number for Account Assignment
|
NPLNR |
CHAR
|
12 | 0 | ||||||||||||||||
|
PAOBJNR
Profitability Segment Number (CO-PA)
|
RKEOBJNR |
NUMC
|
10 | 0 | ||||||||||||||||
|
PERNR
Personnel Number
|
PERNR_D |
NUMC
|
8 | 0 | ||||||||||||||||
|
PRCTR
Profit Center
|
PRCTR |
CHAR
|
10 | 0 | ||||||||||||||||
|
PS_PSP_PNR
Work Breakdown Structure Element (WBS Element)
|
PS_PSP_PNR |
NUMC
|
8 | 0 | ||||||||||||||||
|
PSTYP
Item Category in Purchasing Document
|
PSTYP |
CHAR
|
1 | 0 | ||||||||||||||||
|
RECID
Recovery Indicator
|
JV_RECIND |
CHAR
|
2 | 0 | ||||||||||||||||
|
REEWR
Invoice Value Entered (in Local Currency)
|
REEWR |
CURR
|
13 | 2 | ||||||||||||||||
|
REFWR
Invoice value in foreign currency
|
REFWR |
CURR
|
13 | 2 | ||||||||||||||||
|
REMNG
Quantity invoiced
|
REMNG |
QUAN
|
13 | 3 | ||||||||||||||||
|
RETPO
Returns Item
|
RETPO |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
REWRT
Invoice value in local currency
|
REWRT |
CURR
|
13 | 2 | ||||||||||||||||
|
REWWR
Invoice Amount in Foreign Currency
|
REWWR |
CURR
|
13 | 2 | ||||||||||||||||
|
SAKNR
G/L Account Number
|
SAKNR |
CHAR
|
10 | 0 | ||||||||||||||||
|
SOBKZ
Special Stock Indicator
|
SOBKZ |
CHAR
|
1 | 0 | ||||||||||||||||
|
TXJCD
Tax Jurisdiction
|
TXJCD |
CHAR
|
15 | 0 | ||||||||||||||||
|
UMREN
Denominator for conversion to base units of measure
|
UMREN |
DEC
|
5 | 0 | ||||||||||||||||
|
UMREZ
Numerator for Conversion to Base Units of Measure
|
UMREZ |
DEC
|
5 | 0 | ||||||||||||||||
|
VBWAF
Default: valuation type "external procurement"
|
VBWAF |
CHAR
|
10 | 0 | ||||||||||||||||
|
VPTNR
Partner account number
|
JV_PART |
CHAR
|
10 | 0 | ||||||||||||||||
|
WAERS
Currency Key
|
WAERS |
CUKY
|
5 | 0 | ||||||||||||||||
|
WEMNG
Quantity of Goods Received
|
WEMNG |
QUAN
|
13 | 3 | ||||||||||||||||
|
WEPOS
Goods Receipt Indicator
|
WEPOS |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
WERKS
Plant
|
WERKS_D |
CHAR
|
4 | 0 | ||||||||||||||||
|
WEUNB
Goods Receipt, Non-Valuated
|
WEUNB |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
WEWRT
Value of goods received in local currency
|
WEWRT |
CURR
|
13 | 2 | ||||||||||||||||
|
WEWWR
Value of goods received in foreign currency
|
WEWWR |
CURR
|
13 | 2 | ||||||||||||||||
|
WENWR
Accepted net value of service in foreign currency
|
WENWR |
CURR
|
13 | 2 | ||||||||||||||||
|
XBLNR
Number of External Delivery Note
|
LFSNR1 |
CHAR
|
16 | 0 | ||||||||||||||||
|
ZEKKN
Sequential Number of Account Assignment
|
DZEKKN |
NUMC
|
2 | 0 | ||||||||||||||||
|
LSMNG
Quantity from Delivery Note
|
MRM_LSMNG |
QUAN
|
13 | 3 | ||||||||||||||||
|
LSMEH
Unit of Measure From Delivery Note
|
LSMEH |
UNIT
|
3 | 0 | ||||||||||||||||
|
DABRZ
Reference Date for Settlement
|
DABRBEZ |
DATS
|
8 | 0 | ||||||||||||||||
|
EMATN
Material Number Corresponding to Manufacturer Part Number
|
EMATN |
CHAR
|
18 | 0 | ||||||||||||||||
|
KDATB
Start of Validity Period
|
KDATB |
DATS
|
8 | 0 | ||||||||||||||||
|
KDATE
End of Validity Period
|
KDATE |
DATS
|
8 | 0 | ||||||||||||||||
|
SUMLIMIT
Overall Limit
|
SUMLIMIT |
CURR
|
13 | 2 | ||||||||||||||||
|
SUMNOLIM
No Limit
|
NOLIMIT |
CHAR
|
1 | 0 | ||||||||||||||||
|
ACTVALUE
Total Value of Unplanned Entered Services
|
ACTVALUE |
CURR
|
13 | 2 | ||||||||||||||||
|
WEMMG
Non-valuated goods receipt quantity
|
WEMMG |
QUAN
|
13 | 3 | ||||||||||||||||
|
BPWMM
Non-valuated goods receipt quantity in order price unit
|
BPWMM |
QUAN
|
13 | 3 | ||||||||||||||||
|
LSTAR
Activity Type
|
LSTAR |
CHAR
|
6 | 0 | ||||||||||||||||
|
PRZNR
Business Process
|
CO_PRZNR |
CHAR
|
12 | 0 | ||||||||||||||||
|
WENAM
Goods receipt entered by
|
WENAM |
CHAR
|
12 | 0 | ||||||||||||||||
|
AFNAM
Name of Requisitioner/Requester
|
AFNAM |
CHAR
|
12 | 0 | ||||||||||||||||
|
REBEL
Referenced document
|
REBEL |
CHAR
|
10 | 0 | ||||||||||||||||
|
REPOS
Invoice Receipt Indicator
|
REPOS |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
AREWB
Clearing Value on GR/IR Account in PO Currency
|
AREWB |
CURR
|
13 | 2 | ||||||||||||||||
|
TWRKZ
Partial Invoice Indicator
|
TWRKZ |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
REWRB
Invoice Amount in PO Currency
|
REWRB |
CURR
|
13 | 2 | ||||||||||||||||
|
WEWRB
Value of Goods Received in PO Currency
|
WEWRB |
CURR
|
13 | 2 | ||||||||||||||||
|
XBESW
Indicator: Update in PO Currency
|
XBESW |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
WESBB
Valuated Goods Receipt Blocked Stock in Order Unit
|
WESBB |
QUAN
|
13 | 3 | ||||||||||||||||
|
BPWEB
Quantity in Valuated GR Blocked Stock in Order Price Unit
|
BPWEB |
QUAN
|
13 | 3 | ||||||||||||||||
|
KUDIF
Exchange Rate Difference Amount
|
KUDIF |
CURR
|
13 | 2 | ||||||||||||||||
|
BSMNG_F
Quantity Share Account Assignment Line for Item
|
SHARE_F |
FLTP
|
16 | 16 | ||||||||||||||||
|
REMNG_F
Quantity Share Account Assignment Line for Item
|
SHARE_F |
FLTP
|
16 | 16 | ||||||||||||||||
|
WEMNG_F
Quantity Share Account Assignment Line for Item
|
SHARE_F |
FLTP
|
16 | 16 | ||||||||||||||||
|
BPREM_F
Quantity Share Account Assignment Line for Item
|
SHARE_F |
FLTP
|
16 | 16 | ||||||||||||||||
|
BPWEM_F
Quantity Share Account Assignment Line for Item
|
SHARE_F |
FLTP
|
16 | 16 | ||||||||||||||||
|
XHISTMA
Update Multiple Account Assignment EKBE_MA, EKBZ_MA
|
XHISTMA |
CHAR
|
1 | 0 | ||||||||||||||||
|
XUNPL
Unplanned Account Assignment from Invoice Verification
|
XUNPL |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
VRTKZ
Distribution indicator for multiple account assignment
|
VRTKZ |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
WKURS_IR
Exchange Rate
|
WKURS |
DEC
|
9 | 5 | ||||||||||||||||
|
WKURS_GR
Exchange Rate
|
WKURS |
DEC
|
9 | 5 | ||||||||||||||||
|
MEASURE
Funded Program
|
FM_MEASURE |
CHAR
|
24 | 0 | ||||||||||||||||
|
BUDGET_PD
FM: Budget Period
|
FM_BUDGET_PERIOD |
CHAR
|
10 | 0 | ||||||||||||||||
|
LAST_GR_DATE
Last Goods Receipt Date
|
LAST_GR_DATE |
DATS
|
8 | 0 | ||||||||||||||||
|
LAST_DELIV_DATE
Last Allowed Delivery Date
|
LAST_DELIV_DATE |
DATS
|
8 | 0 | ||||||||||||||||
|
AA_FINAL_IND
Final Account Assignment Indicator
|
AA_FINAL_IND |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
AA_FINAL_QTY
Final Account Assignment Quantity
|
AA_FINAL_QTY |
QUAN
|
13 | 3 | ||||||||||||||||
|
AA_FINAL_QTY_F
Final Account Assignment Quantity (Floating Point Number)
|
AA_FINAL_QTY_F |
FLTP
|
16 | 16 | ||||||||||||||||
|
PARKED_QTY
Parked Invoice Quantity
|
PARKED_QTY |
QUAN
|
13 | 3 | ||||||||||||||||
|
PARKED_QTY_F
Parked Invoice Quantity (Floating Point Number)
|
PARKED_QTY_F |
FLTP
|
16 | 16 | ||||||||||||||||
|
CHARG
Batch Number
|
CHARG_D |
CHAR
|
10 | 0 | ||||||||||||||||
|
XDINV
Indicator for Differential Invoicing
|
XDINV |
CHAR
|
1 | 0 | ||||||||||||||||
|
XCPRF
Checkbox for Commodity Repricing in Invoice Verification
|
XCPRF |
CHAR
|
1 | 0 | ||||||||||||||||
|
FINAL_INV_EXIST
Differential Invoicing: Final Invoice Exists
|
FINAL_INV_EXIST |
CHAR
|
1 | 0 | ||||||||||||||||
|
PRICING_QTY_GR
Goods Receipt Quantity in Purchase Order Price Unit
|
BPWEM |
QUAN
|
13 | 3 | ||||||||||||||||
|
KUDIF_GR
Exchange Rate Difference Amount
|
KUDIF |
CURR
|
13 | 2 | ||||||||||||||||
|
KUDIF_IR
Exchange Rate Difference Amount
|
KUDIF |
CURR
|
13 | 2 | ||||||||||||||||
|
VNAME
Joint Venture
|
JV_NAME |
CHAR
|
6 | 0 | ||||||||||||||||
|
EGRUP
Equity group
|
JV_EGROUP |
CHAR
|
3 | 0 | ||||||||||||||||
|
ETYPE
Equity type
|
JV_ETYPE | T8JG |
CHAR
|
3 | 0 | |||||||||||||||
|
NEBTR
Net Payment Amount
|
NEBTR |
CURR
|
13 | 2 | ||||||||||||||||
|
OIEXGNUM
Exchange agreement number
|
OIA_EXGNUM |
CHAR
|
10 | 0 | ||||||||||||||||
|
OIMATPST
Posting rules for material
|
OIA_MATPST |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
OIA_IPMVAT
VAT on internally-posted material
|
OIA_IPMVAT |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
OIVATH
Amount in Local Currency
|
DMBTR |
CURR
|
13 | 2 | ||||||||||||||||
|
OIVATF
Amount in document currency
|
WRBTR |
CURR
|
13 | 2 | ||||||||||||||||
|
OINETTNG
Netting indicator
|
OIA_NETTNG |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
OINETCYC
Netting cycle (FI blocking indicator)
|
OIA_NETCYC |
CHAR
|
1 | 0 | ||||||||||||||||
|
OIEXGTYP
Exchange type
|
OIA_EXGTYP |
CHAR
|
4 | 0 | ||||||||||||||||
|
OIMATCYC
Invoicing cycle for purchase material costs
|
OIA_MATCYC |
NUMC
|
1 | 0 | ||||||||||||||||
|
OITAXGRP
Excise Duty Group
|
OIH_TAXGRP |
CHAR
|
2 | 0 | ||||||||||||||||
|
OIHANTYP
Excise Duty Handling Type
|
OIH_HANTYP |
CHAR
|
2 | 0 | ||||||||||||||||
|
OITAXFROM
Excise duty tax key for 'from' location
|
OIH_TAXFRO |
CHAR
|
2 | 0 | ||||||||||||||||
|
OITAXTO
Excise duty tax key for 'to' location
|
OIH_TAXTO |
CHAR
|
2 | 0 | ||||||||||||||||
|
OIPRICIE
ED pricing: external (indicator)
|
OIH_PRICIE |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
OIFULTAX
Excise duty tax value at the full rate
|
OIH_FULTAX |
CURR
|
13 | 2 | ||||||||||||||||
|
OITXVAL0
Excise duty tax value 0
|
OIH_TXVAL0 |
CURR
|
13 | 2 | ||||||||||||||||
|
OITXVAL1
Excise duty tax value 1
|
OIH_TXVAL1 |
CURR
|
13 | 2 | ||||||||||||||||
|
OITXVAL2
Excise duty tax value 2
|
OIH_TXVAL2 |
CURR
|
13 | 2 | ||||||||||||||||
|
OITXVAL3
Excise duty tax value 3
|
OIH_TXVAL3 |
CURR
|
13 | 2 | ||||||||||||||||
|
OITXVAL4
Excise duty tax value 4
|
OIH_TXVAL4 |
CURR
|
13 | 2 | ||||||||||||||||
|
OITXVAL5
Excise duty tax value 5
|
OIH_TXVAL5 |
CURR
|
13 | 2 | ||||||||||||||||
|
OITXVAL6
Excise duty tax value 6
|
OIH_TXVAL6 |
CURR
|
13 | 2 | ||||||||||||||||
|
OIOILCON
Oil content in a material as a percentage
|
OIH_OILCON |
DEC
|
5 | 2 | ||||||||||||||||
|
||||||||||||||||||||
|
OITAXCON
Excise duty tax from pricing conditions
|
OIH_TAXCON |
CURR
|
13 | 2 | ||||||||||||||||
|
OITAXVAL
Excise duty value in material inventory account
|
OIH_TAXVAL |
CURR
|
13 | 2 | ||||||||||||||||
|
OIOILCON2
Oil content of a material as a percentage (2)
|
OIH_OILCN2 |
DEC
|
5 | 2 | ||||||||||||||||
|
||||||||||||||||||||
|
OIUOMQT
Base quantity for excise duty rate (e.g.per 1 or 100 UoM)
|
OIH_UOMQT |
UNIT
|
3 | 0 | ||||||||||||||||
|
OITAXQT
Excise duty tax quantity in STBME
|
OIH_TAXQT |
QUAN
|
13 | 3 | ||||||||||||||||
|
OIFUTQT
Future tax quantity
|
OIH_FUTQT |
QUAN
|
13 | 3 | ||||||||||||||||
|
OIFUTTX
Future tax value
|
OIH_FUTTX |
CURR
|
13 | 2 | ||||||||||||||||
|
OIFUTDT
Future tax date
|
OIH_FUTDT |
DATS
|
8 | 0 | ||||||||||||||||
|
OIFUTQT2
Future tax quantity 2
|
OIH_FUTQT2 |
QUAN
|
13 | 3 | ||||||||||||||||
|
OIFUTTX2
Future tax value 2
|
OIH_FUTTX2 |
CURR
|
13 | 2 | ||||||||||||||||
|
ROIFUTDT2
Future tax date 2
|
OIH_FUTDT2 |
DATS
|
8 | 0 | ||||||||||||||||
|
OIEDCLT
Excise duty clearing value total
|
OIH_EDCLT |
CURR
|
13 | 2 | ||||||||||||||||
|
OIWEEDWR
Excise duty value - goods receipt
|
OIH_WEEDWR |
CURR
|
13 | 2 | ||||||||||||||||
|
OIREEDWR
Excise duty value - invoice receipt
|
OIH_REEDWR |
CURR
|
13 | 2 | ||||||||||||||||
|
ANZAL
Total Down Payments in Local Currency
|
ANZAL |
CURR
|
13 | 2 | ||||||||||||||||
|
BPBSM
Ordered quantity in order price unit
|
BPBSM |
QUAN
|
13 | 3 | ||||||||||||||||
|
BPWES
Quantity in GR blocked stock in order price unit
|
BPWES |
QUAN
|
13 | 3 | ||||||||||||||||
|
EINDT
Item Delivery Date
|
EINDT |
DATS
|
8 | 0 | ||||||||||||||||
|
ERNAM
Name of Person who Created the Object
|
ERNAM |
CHAR
|
12 | 0 | ||||||||||||||||
|
FPLNR
Invoicing plan number
|
IPLNR |
CHAR
|
10 | 0 | ||||||||||||||||
|
INCO1
Incoterms (Part 1)
|
INCO1 | TINC |
CHAR
|
3 | 0 | |||||||||||||||
|
INCO2
Incoterms (Part 2)
|
INCO2 |
CHAR
|
28 | 0 | ||||||||||||||||
|
LFBNR
Document No. of a Reference Document
|
LFBNR |
CHAR
|
10 | 0 | ||||||||||||||||
|
LFGJA
Fiscal Year of Current Period
|
LFGJA |
NUMC
|
4 | 0 | ||||||||||||||||
|
LFPOS
Item of a Reference Document
|
LFPOS |
NUMC
|
4 | 0 | ||||||||||||||||
|
MWSKZ
Tax on sales/purchases code
|
MWSKZ | T007A |
CHAR
|
2 | 0 | |||||||||||||||
|
NETPR
Net price
|
NETPR |
CURR
|
11 | 2 | ||||||||||||||||
|
PEINH
Price Unit
|
PEINH |
DEC
|
5 | 0 | ||||||||||||||||
|
SCHPR
Indicator: Estimated Price
|
SCHPR |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
SSQSS
QA Control Key
|
SSQSS |
CHAR
|
8 | 0 | ||||||||||||||||
|
STATU
RFQ status
|
ASTAT |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
TXZ01
Short Text
|
TXZ01 |
CHAR
|
40 | 0 | ||||||||||||||||
|
VETEN
Delivery Schedule Line Number
|
ETENR |
NUMC
|
4 | 0 | ||||||||||||||||
|
WEBRE
Indicator: GR-Based Invoice Verification
|
WEBRE |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
WESBS
Goods Receipt Blocked Stock in Order Unit
|
WESBS |
QUAN
|
13 | 3 | ||||||||||||||||
|
XERSY
Evaluated Receipt Settlement (ERS)
|
XERSY |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
XSKRL
Indicator: Line item not liable to cash discount?
|
XSKRL |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
XUBNKR
Indicates: Not relevant for unplanned delivery costs?
|
XUBNKR |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
KORNR
Correction of miscellaneous provisions
|
KORNR |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
EBONF
Item Not Relevant to Subseq. (Period-End Rebate) Settlement
|
EBONF |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
FKNUM
Shipment Cost Number
|
FKNUM |
CHAR
|
10 | 0 | ||||||||||||||||
|
FKPOS
Shipment costs item
|
FKPOS |
NUMC
|
6 | 0 | ||||||||||||||||
|
FKPTY
Item category shipment costs
|
FKPTY |
CHAR
|
4 | 0 | ||||||||||||||||
|
EXTI1
External identification 1
|
EXTI1 |
CHAR
|
20 | 0 | ||||||||||||||||
|
EXLIN
Item Number Length
|
EXLIN |
CHAR
|
40 | 0 | ||||||||||||||||
|
EXSNR
External Sorting
|
EXSNR |
NUMC
|
5 | 0 | ||||||||||||||||
|
EHTYP
External Hierarchy Category
|
EHTYP | TMSRM_EHTYP |
CHAR
|
4 | 0 | |||||||||||||||
|
RETSUM_FC
Total of Retention Amounts in Document Currency
|
RET_SUM_FC |
CURR
|
13 | 2 | ||||||||||||||||
|
RETSUM_LC
Total of Retention Amounts in Company Code Currency
|
RET_SUM_LC |
CURR
|
13 | 2 | ||||||||||||||||
|
RETSUMP_FC
Total Retention Amount Posted To Date in Document Currency
|
RET_SUM_POST_FC |
CURR
|
13 | 2 | ||||||||||||||||
|
RETSUMP_LC
Total Retention Amount Posted in Company Code Currency
|
RET_SUM_POST_LC |
CURR
|
13 | 2 | ||||||||||||||||
|
RETPC
Retention in Percent
|
RETPZ |
DEC
|
5 | 2 | ||||||||||||||||
|
RETTP
Retention Indicator
|
RETTP |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
TRMRISK_RELEVANT
Risk Relevancy in Purchasing
|
PUR_TRM_RISK_RELEVANCY |
CHAR
|
2 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
/BEV1/NEGEN_ITEM
Indicator: Item Is Generated
|
/BEV1/NEGEN_ITEM_FLAG |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
/BEV1/NESTRUCCAT
Structure Category for Material Relationship
|
/BEV1/NESTRUC_CAT |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
MBLNR
Number of Material Document
|
MBLNR |
CHAR
|
10 | 0 | ||||||||||||||||
|
MJAHR
Material Document Year
|
MJAHR |
NUMC
|
4 | 0 | ||||||||||||||||
|
MBLPO
Item in Material Document
|
MBLPO |
NUMC
|
4 | 0 | ||||||||||||||||
|
KNUMVK
Number of the document condition
|
KNUMV |
CHAR
|
10 | 0 | ||||||||||||||||
|
KNUMV
Number of the document condition
|
KNUMV |
CHAR
|
10 | 0 | ||||||||||||||||
|
KNUMVR
Number of the document condition
|
KNUMV |
CHAR
|
10 | 0 | ||||||||||||||||
|
SATNR
Cross-Plant Configurable Material
|
SATNR | MARA |
CHAR
|
18 | 0 | |||||||||||||||
|
EAN11
International Article Number (EAN/UPC)
|
EAN11 |
CHAR
|
18 | 0 | ||||||||||||||||
|
IDNLF
Material Number Used by Vendor
|
IDNLF |
CHAR
|
35 | 0 | ||||||||||||||||
|
AKTNR
Promotion
|
WAKTION | WAKH |
CHAR
|
10 | 0 | |||||||||||||||
|
UPVOR
Subitems Exist
|
UPVOR |
CHAR
|
1 | 0 | ||||||||||||||||
|
UPTYP
Subitem Category, Purchasing Document
|
UPTYP | TMSI1 |
CHAR
|
1 | 0 | |||||||||||||||
|
UEBPO
Higher-Level Item in Purchasing Documents
|
UEBPO | EKPO |
NUMC
|
5 | 0 | |||||||||||||||
|
SRVPOS
Service number
|
SRVPOS |
CHAR
|
18 | 0 | ||||||||||||||||
|
PACKNO
Package Number of Service
|
PACKNO_EKBE |
NUMC
|
10 | 0 | ||||||||||||||||
|
INTROW
Line Number of Service
|
INTROW_EKBE |
NUMC
|
10 | 0 | ||||||||||||||||
|
LEBRE
Indicator for Service-Based Invoice Verification
|
LEBRE |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
BEKKN
Number of PO Account Assignment
|
BEKKN |
NUMC
|
2 | 0 | ||||||||||||||||
|
PLN_PACKNO
Source package number
|
PLN_PACKNO |
NUMC
|
10 | 0 | ||||||||||||||||
|
PLN_INTROW
Entry: Planned package line
|
PLN_INTROW |
NUMC
|
10 | 0 | ||||||||||||||||
EK08RB foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| EK08RB | AKTNR | WAKH | MANDT |
WAKH
Promotion Header Data, IS-R
|
MANDT |
| EK08RB | AKTNR | EK08RB | AKTNR |
WAKH
Promotion Header Data, IS-R
|
AKTNR |
| EK08RB | EHTYP | SYST | MANDT |
TMSRM_EHTYP
SRM Hierarchy Types
|
MANDT |
| EK08RB | EHTYP | EK08RB | EHTYP |
TMSRM_EHTYP
SRM Hierarchy Types
|
EHTYP |
| EK08RB | ETYPE | SYST | MANDT |
T8JG
Valid Investment Group
|
MANDT |
| EK08RB | ETYPE | GJV_OBJDAT | BUKRS |
T8JG
Valid Investment Group
|
BUKRS |
| EK08RB | ETYPE | EK08RB | VNAME |
T8JG
Valid Investment Group
|
VNAME |
| EK08RB | ETYPE | EK08RB | ETYPE |
T8JG
Valid Investment Group
|
ETYPE |
| EK08RB | ETYPE | * |
T8JG
Valid Investment Group
|
FDATE | |
| EK08RB | INCO1 | SY | MANDT |
TINC
Customers: Incoterms
|
MANDT |
| EK08RB | INCO1 | EK08RB | INCO1 |
TINC
Customers: Incoterms
|
INCO1 |
| EK08RB | MWSKZ | T007A | MANDT |
T007A
Tax Keys
|
MANDT |
| EK08RB | MWSKZ | T007A | KALSM |
T007A
Tax Keys
|
KALSM |
| EK08RB | MWSKZ | EK08RB | MWSKZ |
T007A
Tax Keys
|
MWSKZ |
| EK08RB | SATNR | MARA | MANDT |
MARA
General Material Data
|
MANDT |
| EK08RB | SATNR | EK08RB | SATNR |
MARA
General Material Data
|
MATNR |
| EK08RB | UEBPO | EKPO | MANDT |
EKPO
Purchasing Document Item
|
MANDT |
| EK08RB | UEBPO | EKPO | EBELN |
EKPO
Purchasing Document Item
|
EBELN |
| EK08RB | UEBPO | EK08RB | UEBPO |
EKPO
Purchasing Document Item
|
EBELP |
| EK08RB | UPTYP | TMSI1 | MANDT |
TMSI1
Sub-Item Category in Purchasing
|
MANDT |
| EK08RB | UPTYP | EK08RB | UPTYP |
TMSI1
Sub-Item Category in Purchasing
|
UPTYP |
| EK08RB | ZZREGION | EK08RB | ZZREGION |
ZREG
User Defined Regions
|
ZZREGION |
| EK08RB | ZZREGION | SYST | MANDT |
ZREG
User Defined Regions
|
MANDT |
| EK08RB | ZZSPREG | SYST | MANDT |
ZZSPREG
Check table for ZZSPREG = Special Region
|
MANDT |
| EK08RB | ZZSPREG | EK08RB | ZZSPREG |
ZZSPREG
Check table for ZZSPREG = Special Region
|
ZZSPREG |
| EK08RB | ZZSTATE | * |
T005S
Taxes: Region (Province) Key
|
LAND1 | |
| EK08RB | ZZSTATE | EK08RB | ZZSTATE |
T005S
Taxes: Region (Province) Key
|
BLAND |
| EK08RB | ZZSTATE | SYST | MANDT |
T005S
Taxes: Region (Province) Key
|
MANDT |
| EK08RB | ZZUSERFLD1 | SYST | MANDT |
ZFU1
Check Table for User Field 1
|
MANDT |
| EK08RB | ZZUSERFLD1 | EK08RB | ZZUSERFLD1 |
ZFU1
Check Table for User Field 1
|
ZZUSERFLD1 |