EKREP SAP (Purchasing Data for Reporting) Structure details
Description: Purchasing Data for Reporting
Structure field list including key, data, relationships and ABAP select examples
EKREP is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Purchasing Data for Reporting" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_EKREP TYPE EKREP.
The EKREP table consists of various fields, each holding specific information or linking keys about Purchasing Data for Reporting data available in SAP. These include EBELP (Item Number of Purchasing Document), LPEIN (Category of Delivery Date), EINDT (Delivery Date), EKORG (Purchasing Organization).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP EKREP structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
EBELN | Purchasing Document Number | EBELN | CHAR | 10 | EKKO | ALPHA | EBELN | BES | MEKK_C |
EBELP | Item Number of Purchasing Document | EBELP | NUMC | 5 | EKPO | EBELP | BSP | ||
LPEIN | Category of Delivery Date | LPEIN | CHAR | 1 | TPRG | PRGBZ | |||
EINDT | Delivery Date | EEIND | CHAR | 10 | CHAR10 | ||||
EKORG | Purchasing Organization | EKORG | CHAR | 4 | T024E | EKORG | EKO | ||
BSTYP | Purchasing Document Category | BSTYP | CHAR | 1 | BSTYP | ||||
BSART | Purchasing Document Type | ESART | CHAR | 4 | T161 | BSART | BSA | ||
EKGRP | Purchasing Group | EKGRP | CHAR | 3 | T024 | EKGRP | EKG | ||
LIFNR | Vendor Account Number | ELIFN | CHAR | 10 | LFA1 | ALPHA | LIFNR | LIF | KRED_C |
NAME1 | Name | NAME1 | CHAR | 30 | TEXT30 | ||||
BEDAT | Purchasing Document Date | EBDAT | DATS | 8 | DATUM | ||||
MATNR | Material Number | MATNR | CHAR | 18 | MARA | MATN1 | MATNR | MAT | S_MAT1 |
TXZ01 | Short Text | TXZ01 | CHAR | 40 | TEXT40 | ||||
WERKS | Plant | EWERK | CHAR | 4 | T001W | WERKS | WRK | ||
MATKL | Material Group | MATKL | CHAR | 9 | T023 | MATKL | MKL | S_WBWG | |
PSTYP | Item Category in Purchasing Document | PSTYP | CHAR | 1 | T163 | PSTYP | |||
KNTTP | Account Assignment Category | KNTTP | CHAR | 1 | T163K | KNTTP | KNT | ||
MEINS | Purchase Order Unit of Measure | BSTME | UNIT | 3 | T006 | CUNIT | MEINS | ||
LMEIN | Base Unit of Measure | LAGME | UNIT | 3 | T006 | CUNIT | MEINS | ||
KTMNG | Target Quantity | KTMNG | QUAN | 13(3) | MENGE | ||||
KTLMG | Target quantity in stockkeeping unit | KTLMG | QUAN | 13(3) | MENG13 | ||||
MENGE | Purchase Order Quantity | BSTMG | QUAN | 13(3) | MENG13 | ||||
BELMG | Purchase Order Quantity in Stockkeeping Unit | BELMG | QUAN | 13(3) | MENG13 | ||||
ETMEN | Scheduled Quantity | ETMEN | QUAN | 13(3) | MENGE | ||||
ETLMG | Scheduled quantity in stockkeeping unit | ETLMG | QUAN | 13(3) | MENG13 | ||||
WEMNG | Quantity of Goods Received | WEMNG | QUAN | 13(3) | MENG13 | ||||
WELMG | Goods receipt quantity in stockkeeping unit | WELMG | QUAN | 13(3) | MENG13 | ||||
REMNG | Quantity invoiced | REMNG | QUAN | 13(3) | MENG13 | ||||
RELMG | Invoice receipt quantity in stockkeeping unit | RELMG | QUAN | 13(3) | MENG13 | ||||
WAERS | Currency Key | WAERS | CUKY | 5 | TCURC | WAERS | FWS | ||
HWAER | Local Currency | HWAER | CUKY | 5 | TCURC | WAERS | |||
NETWR | Net Value in Document Currency | NETWR | CURR | 15(2) | WERTV8 | ||||
NETHW | Net value of purchasing document item in local currency | NEHWR | CURR | 15(2) | WERTV8 | ||||
KTWRT | Target Value for Header Area per Distribution | KTWRT | CURR | 15(2) | WERT15 | ||||
KTHWR | Outline Agreement Target Value in Local Currency | KTHWR | CURR | 15(2) | WERTV8 | ||||
ZWERT | Target Value for Outline Agreement in Document Currency | DZWERT | CURR | 13(2) | WERT7 | ||||
ZWHWT | Target Value of Outline Agreement Item in Local Currency | DZWHWT | CURR | 13(2) | WERT7 | ||||
REWRT | Invoice value in local currency | REWRT | CURR | 13(2) | WRTV7 | ||||
WEWRT | Value of goods received in local currency | WEWRT | CURR | 13(2) | WERT7 | ||||
ACTIV | List Level in which the Line Item is Active | ACTIV | NUMC | 2 | NUM02 | ||||
SELKZ | Selection flag | SELKZ | CHAR | 1 | SELKZ | ||||
EINTT | Item Delivery Date | EINDT | DATS | 8 | DATUM |
Key field | Non-key field |
How do I retrieve data from SAP structure EKREP using ABAP code?
As EKREP is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on EKREP as there is no data to select.How to access SAP table EKREP
Within an ECC or HANA version of SAP you can also view further information about EKREP and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects