SAP ABAP Table V_EKKO_EKPO (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_EKKO_EKPO	Table Relationship Diagram
Short Description	Generated Table for View

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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	EBELN	☑	EBELN	EBELN	CHAR	10	0	Purchasing Document Number
3	EBELP	☑	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document
4	BUKRS_K	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
5	BSTYP_K	☐	EBSTYP	EBSTYP	CHAR	1	0	Purchasing Document Category
6	BSART	☐	ESART	BSART	CHAR	4	0	Purchasing Document Type	T161
7	BSAKZ	☐	BSAKZ	BSAKZ	CHAR	1	0	Control indicator for purchasing document type
8	LOEKZ_K	☐	ELOEK	ELOEK	CHAR	1	0	Deletion indicator in purchasing document
9	STATU_K	☐	ESTAK	ESTAK	CHAR	1	0	Status of Purchasing Document
10	AEDAT_K	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
11	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
12	LIFNR	☐	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	LFA1
13	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
14	EKGRP	☐	BKGRP	EKGRP	CHAR	3	0	Purchasing Group	T024
15	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
16	BEDAT	☐	EBDAT	DATUM	DATS	8	0	Purchasing Document Date
17	KDATB	☐	KDATB	DATUM	DATS	8	0	Start of Validity Period
18	KDATE	☐	KDATE	DATUM	DATS	8	0	End of Validity Period
19	ADRNR_K	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number
20	KTWRT	☐	KTWRT	WERT15	CURR	15	2	Target Value for Header Area per Distribution
21	KUFIX	☐	KUFIX	XFELD	CHAR	1	0	Indicator: Fixing of Exchange Rate
22	FRGRL	☐	FRGRL	XFELD	CHAR	1	0	Release Not Yet Completely Effected
23	MEMORY	☐	FRGRL	XFELD	CHAR	1	0	Release Not Yet Completely Effected
24	LOEKZ	☐	ELOEK	ELOEK	CHAR	1	0	Deletion indicator in purchasing document
25	STATU	☐	ASTAT	ASTAT	CHAR	1	0	RFQ status
26	AEDAT	☐	PAEDT	DATUM	DATS	8	0	Purchasing Document Item Change Date
27	TXZ01	☐	TXZ01	TEXT40	CHAR	40	0	Short Text
28	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
29	WERKS	☐	EWERK	WERKS	CHAR	4	0	Plant	T001W
30	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
31	BEDNR	☐	BEDNR	CHAR10	CHAR	10	0	Requirement Tracking Number
32	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
33	MENGE	☐	BSTMG	MENG13	QUAN	13	3	Purchase Order Quantity
34	MEINS	☐	BSTME	MEINS	UNIT	3	0	Order unit	T006
35	BPRME	☐	BBPRM	MEINS	UNIT	3	0	Order Price Unit (purchasing)	T006
36	BPUMZ	☐	BPUMZ	UMBSZ	DEC	5	0	Numerator for Conversion of Order Price Unit into Order Unit
37	BPUMN	☐	BPUMN	UMBSN	DEC	5	0	Denominator for Conv. of Order Price Unit into Order Unit
38	UMREZ	☐	UMBSZ	UMBSZ	DEC	5	0	Numerator for Conversion of Order Unit to Base Unit
39	UMREN	☐	UMBSN	UMBSN	DEC	5	0	Denominator for Conversion of Order Unit to Base Unit
40	NETPR	☐	BPREI	WERT11	CURR	11	2	Net Price in Purchasing Document (in Document Currency)
41	PEINH	☐	EPEIN	DEC5	DEC	5	0	Price unit
42	NETWR	☐	BWERT	WERT7	CURR	13	2	Net Order Value in PO Currency
43	BRTWR	☐	BBWERT	WERT7	CURR	13	2	Gross order value in PO currency
44	EREKZ	☐	EREKZ	XFELD	CHAR	1	0	Final Invoice Indicator
45	PSTYP	☐	PSTYP	PSTYP	CHAR	1	0	Item category in purchasing document	T163
46	KNTTP	☐	KNTTP	KNTTP	CHAR	1	0	Account assignment category	T163K
47	LMEIN	☐	LAGME	MEINS	UNIT	3	0	Base Unit of Measure	T006
48	ZWERT	☐	DZWERT	WERT7	CURR	13	2	Target value for outline agreement in document currency
49	PRDAT	☐	PREDT	DATUM	DATS	8	0	Date of Price Determination
50	BSTYP	☐	BSTYP	BSTYP	CHAR	1	0	Purchasing document category
51	PACKNO	☐	PACKNO	PACKNO	NUMC	10	0	Package number	ESLH
52	ANFNR	☐	ANFNR	EBELN	CHAR	10	0	RFQ Number	EKKO
53	ANFPS	☐	ANFPS	EBELP	NUMC	5	0	Item Number of RFQ	EKPO
54	BANFN	☐	BANFN	BANFN	CHAR	10	0	Purchase requisition number
55	BNFPO	☐	BNFPO	BNFPO	NUMC	5	0	Item number of purchase requisition	EBAN
56	AFNAM	☐	AFNAM	AFNAM	CHAR	12	0	Name of requisitioner/requester
57	LEBRE	☐	LEBRE	XFELD	CHAR	1	0	Indicator for Service-Based Invoice Verification
58	ADRNR	☐	ADRNR_MM	AD_ADDRNUM	CHAR	10	0	Manual address number in purchasing document item	ADRC
59	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
60	KZVBR	☐	KZVBR	KZVBR	CHAR	1	0	Consumption posting
61	WEBRE	☐	KZVBR	KZVBR	CHAR	1	0	Consumption posting
62	ELIKZ	☐	ELIKZ	XFELD	CHAR	1	0	"Delivery Completed" Indicator
63	WEPOS	☐	WEPOS	XFELD	CHAR	1	0	Goods Receipt Indicator

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	V_EKKO_EKPO	ADRNR	ADRC	ADDRNUMBER	KEY	1	CN
2	V_EKKO_EKPO	ANFNR	EKKO	EBELN	REF	1	N
3	V_EKKO_EKPO	ANFPS	EKPO	EBELP	REF	1	N
4	V_EKKO_EKPO	BNFPO	EBAN	BNFPO	REF	1	N
5	V_EKKO_EKPO	BPRME	T006	MSEHI	REF	1	N
6	V_EKKO_EKPO	BSART	T161	BSART	REF	1	N
7	V_EKKO_EKPO	BUKRS	T001	BUKRS	REF	1	N
8	V_EKKO_EKPO	BUKRS_K	T001	BUKRS	REF	1	N
9	V_EKKO_EKPO	EKGRP	T024	EKGRP	REF	1	N
10	V_EKKO_EKPO	EKORG	T024E	EKORG	REF	1	N
11	V_EKKO_EKPO	KNTTP	T163K	KNTTP	REF	1	N
12	V_EKKO_EKPO	LGORT	T001L	LGORT	REF	1	N
13	V_EKKO_EKPO	LIFNR	LFA1	LIFNR	REF	1	N
14	V_EKKO_EKPO	LMEIN	T006	MSEHI	REF	1	N
15	V_EKKO_EKPO	MANDT	T000	MANDT	KEY	1	N
16	V_EKKO_EKPO	MATKL	T023	MATKL	REF	1	N
17	V_EKKO_EKPO	MEINS	T006	MSEHI	REF	1	N
18	V_EKKO_EKPO	PACKNO	ESLH	PACKNO	KEY	1	N
19	V_EKKO_EKPO	PSTYP	T163	PSTYP	REF	1	N
20	V_EKKO_EKPO	SPRAS	T002	SPRAS	REF	1	N
21	V_EKKO_EKPO	WAERS	TCURC	WAERS	REF	1	N
22	V_EKKO_EKPO	WERKS	T001W	WERKS	REF	1	N

History

Last changed by/on	SAP	20140121
SAP Release Created in