SAP ABAP Table EKREP (Purchasing Data for Reporting)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ SRM-EBP (Application Component) Enterprise Buyer
     ⤷ BBP_APPLICATION (Package) Structure Package EBP
       ⤷ ME (Package) Application development R/3 Purchasing

Basic Data

Table Category	INTTAB	Structure
Structure	EKREP	Table Relationship Diagram
Short Description	Purchasing Data for Reporting

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	EBELN	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	EKKO
2	EBELP	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	EKPO
3	LPEIN	☐	LPEIN	PRGBZ	CHAR	1	0	Category of delivery date	TPRG
4	EINDT	☐	EEIND	CHAR10	CHAR	10	0	Delivery Date
5	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
6	BSTYP	☐	BSTYP	BSTYP	CHAR	1	0	Purchasing document category
7	BSART	☐	ESART	BSART	CHAR	4	0	Purchasing Document Type	T161
8	EKGRP	☐	EKGRP	EKGRP	CHAR	3	0	Purchasing group	T024
9	LIFNR	☐	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	LFA1
10	NAME1	☐	NAME1	TEXT30	CHAR	30	0	Name
11	BEDAT	☐	EBDAT	DATUM	DATS	8	0	Purchasing Document Date
12	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
13	TXZ01	☐	TXZ01	TEXT40	CHAR	40	0	Short Text
14	WERKS	☐	EWERK	WERKS	CHAR	4	0	Plant	T001W
15	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
16	PSTYP	☐	PSTYP	PSTYP	CHAR	1	0	Item category in purchasing document	T163
17	KNTTP	☐	KNTTP	KNTTP	CHAR	1	0	Account assignment category	T163K
18	MEINS	☐	BSTME	MEINS	UNIT	3	0	Order unit	T006
19	LMEIN	☐	LAGME	MEINS	UNIT	3	0	Base Unit of Measure	T006
20	KTMNG	☐	KTMNG	MENGE	QUAN	13	3	Target Quantity
21	KTLMG	☐	KTLMG	MENG13	QUAN	13	3	Target quantity in stockkeeping unit
22	MENGE	☐	BSTMG	MENG13	QUAN	13	3	Purchase Order Quantity
23	BELMG	☐	BELMG	MENG13	QUAN	13	3	Purchase Order Quantity in Stockkeeping Unit
24	ETMEN	☐	ETMEN	MENGE	QUAN	13	3	Scheduled Quantity
25	ETLMG	☐	ETLMG	MENG13	QUAN	13	3	Scheduled quantity in stockkeeping unit
26	WEMNG	☐	WEMNG	MENG13	QUAN	13	3	Quantity of goods received
27	WELMG	☐	WELMG	MENG13	QUAN	13	3	Goods receipt quantity in stockkeeping unit
28	REMNG	☐	REMNG	MENG13	QUAN	13	3	Quantity invoiced
29	RELMG	☐	RELMG	MENG13	QUAN	13	3	Invoice receipt quantity in stockkeeping unit
30	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
31	HWAER	☐	HWAER	WAERS	CUKY	5	0	Local Currency	TCURC
32	NETWR	☐	NETWR	WERTV8	CURR	15	2	Net Value in Document Currency
33	NETHW	☐	NEHWR	WERTV8	CURR	15	2	Net value of purchasing document item in local currency
34	KTWRT	☐	KTWRT	WERT15	CURR	15	2	Target Value for Header Area per Distribution
35	KTHWR	☐	KTHWR	WERTV8	CURR	15	2	Outline Agreement Target Value in Local Currency
36	ZWERT	☐	DZWERT	WERT7	CURR	13	2	Target value for outline agreement in document currency
37	ZWHWT	☐	DZWHWT	WERT7	CURR	13	2	Target Value of Outline Agreement Item in Local Currency
38	REWRT	☐	REWRT	WRTV7	CURR	13	2	Invoice value in local currency
39	WEWRT	☐	WEWRT	WERT7	CURR	13	2	Value of goods received in local currency
40	ACTIV	☐	ACTIV	NUM02	NUMC	2	0	List Level in which the Line Item is Active
41	SELKZ	☐	SELKZ	SELKZ	CHAR	1	0	Selection flag
42	EINTT	☐	EINDT	DATUM	DATS	8	0	Item delivery date

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	EKREP	BSART	T161	BSART
2	EKREP	EBELN	EKKO	EBELN
3	EKREP	EBELP	EKPO	EBELP
4	EKREP	EKGRP	T024	EKGRP
5	EKREP	EKORG	T024E	EKORG
6	EKREP	HWAER	TCURC	WAERS
7	EKREP	KNTTP	T163K	KNTTP
8	EKREP	LIFNR	LFA1	LIFNR
9	EKREP	LMEIN	T006	MSEHI
10	EKREP	LPEIN	TPRG	PRGBZ
11	EKREP	MATKL	T023	MATKL
12	EKREP	MATNR	MARA	MATNR
13	EKREP	MEINS	T006	MSEHI
14	EKREP	PSTYP	T163	PSTYP
15	EKREP	WAERS	TCURC	WAERS
16	EKREP	WERKS	T001W	WERKS

History

Last changed by/on	SAP	20110901
SAP Release Created in