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
⤷ 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 | 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 | 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 | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
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 |