SAP ABAP Table EKPOLIGHT (Purchasing Document Item: Data Part)

Hierarchy

☛ ECC-DIMP (Software Component) DIMP
   ⤷ MM-PUR (Application Component) Purchasing
     ⤷ DI_VVA_MEEE (Package) Separation of Purchasing and FI

Basic Data

Table Category	INTTAB	Structure
Structure	EKPOLIGHT	Table Relationship Diagram
Short Description	Purchasing Document Item: Data Part

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	*
2	EBELN	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	*
3	EBELP	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	*
4	LOGSY	☐	LOGSYSTEM	LOGSYS	CHAR	10	0	Logical System	*
5	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
6	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
7	EKGRP	☐	BKGRP	EKGRP	CHAR	3	0	Purchasing Group	*
8	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
9	KUFIX	☐	KUFIX	XFELD	CHAR	1	0	Indicator: Fixing of Exchange Rate
10	BEDAT	☐	EBDAT	DATUM	DATS	8	0	Purchasing Document Date
11	KDATB	☐	KDATB	DATUM	DATS	8	0	Start of Validity Period
12	KDATE	☐	KDATE	DATUM	DATS	8	0	End of Validity Period
13	INCO1	☐	INCO1	INCO1	CHAR	3	0	Incoterms (part 1)	TINC
14	INCO2	☐	INCO2	INCO2	CHAR	28	0	Incoterms (part 2)
15	KNUMV	☐	KNUMV	KNUMV	CHAR	10	0	Number of the document condition
16	LANDS	☐	LAND1_STML	LAND1	CHAR	3	0	Country for Tax Return	*
17	LIFNR	☐	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	*
18	BSART	☐	ESART	BSART	CHAR	4	0	Purchasing Document Type	*
19	LOEKZ	☐	ELOEK	ELOEK	CHAR	1	0	Deletion indicator in purchasing document
20	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
21	ZBD1T	☐	DZBDET	ZBDXT	DEC	3	0	Cash (Prompt Payment) Discount Days
22	ZBD2T	☐	DZBDET	ZBDXT	DEC	3	0	Cash (Prompt Payment) Discount Days
23	ZBD3T	☐	DZBDET	ZBDXT	DEC	3	0	Cash (Prompt Payment) Discount Days
24	ZBD1P	☐	DZBD1P	PRZ23	DEC	5	3	Cash discount percentage 1
25	ZBD2P	☐	DZBD2P	PRZ23	DEC	5	3	Cash Discount Percentage 2
26	WKURS	☐	WKURS	KURSP	DEC	9	5	Exchange Rate
27	FRGRL	☐	FRGRL	XFELD	CHAR	1	0	Release Not Yet Completely Effected
28	TXZ01	☐	TXZ01	TEXT40	CHAR	40	0	Short Text
29	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
30	EMATN	☐	EMATNR	MATNR	CHAR	18	0	Material number	MARA
31	WERKS	☐	EWERK	WERKS	CHAR	4	0	Plant	T001W
32	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
33	MEINS	☐	BSTME	MEINS	UNIT	3	0	Order unit	T006
34	BPRME	☐	BBPRM	MEINS	UNIT	3	0	Order Price Unit (purchasing)	T006
35	BPUMZ	☐	BPUMZ	UMBSZ	DEC	5	0	Numerator for Conversion of Order Price Unit into Order Unit
36	BPUMN	☐	BPUMN	UMBSN	DEC	5	0	Denominator for Conv. of Order Price Unit into Order Unit
37	UMREZ	☐	UMBSZ	UMBSZ	DEC	5	0	Numerator for Conversion of Order Unit to Base Unit
38	UMREN	☐	UMBSN	UMBSN	DEC	5	0	Denominator for Conversion of Order Unit to Base Unit
39	NETPR	☐	BPREI	WERT11	CURR	11	2	Net Price in Purchasing Document (in Document Currency)
40	PEINH	☐	EPEIN	DEC5	DEC	5	0	Price unit
41	NETWR	☐	BWERT	WERT7	CURR	13	2	Net Order Value in PO Currency
42	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	T007A
43	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	T149D
44	BWTTY	☐	BWTTY_D	BWTTY	CHAR	1	0	Valuation Category	T149C
45	EREKZ	☐	EREKZ	XFELD	CHAR	1	0	Final Invoice Indicator
46	PSTYP	☐	PSTYP	PSTYP	CHAR	1	0	Item category in purchasing document	T163
47	KNTTP	☐	KNTTP	KNTTP	CHAR	1	0	Account assignment category	T163K
48	KZVBR	☐	KZVBR	KZVBR	CHAR	1	0	Consumption posting
49	VRTKZ	☐	VRTKZ	VRTKZ	CHAR	1	0	Distribution indicator for multiple account assignment
50	TWRKZ	☐	TWRKZ	TWRKZ	CHAR	1	0	Partial invoice indicator
51	WEPOS	☐	WEPOS	XFELD	CHAR	1	0	Goods Receipt Indicator
52	WEUNB	☐	WEUNB	XFELD	CHAR	1	0	Goods Receipt, Non-Valuated
53	REPOS	☐	REPOS	XFELD	CHAR	1	0	Invoice receipt indicator
54	WEBRE	☐	WEBRE	XFELD	CHAR	1	0	Indicator: GR-Based Invoice Verification
55	BSTYP	☐	BSTYP	BSTYP	CHAR	1	0	Purchasing document category
56	XOBLR	☐	XOBLR	XFELD	CHAR	1	0	Item affects commitments
57	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	TTXJ
58	SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	T148
59	XERSY	☐	XERSY	XFELD	CHAR	1	0	Evaluated Receipt Settlement (ERS)
60	BANFN	☐	BANFN	BANFN	CHAR	10	0	Purchase requisition number
61	BNFPO	☐	BNFPO	BNFPO	NUMC	5	0	Item number of purchase requisition	EBAN
62	MTART	☐	MTART	MTART	CHAR	4	0	Material type	T134
63	RETPO	☐	RETPO	XFELD	CHAR	1	0	Returns Item
64	KZBWS	☐	KZBWS	KZBWS	CHAR	1	0	Valuation of Special Stock
65	LEBRE	☐	LEBRE	XFELD	CHAR	1	0	Indicator for Service-Based Invoice Verification
66	LIFRE	☐	LIFRE	LIFNR	CHAR	10	0	Different Invoicing Party	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	EKPOLIGHT	BNFPO	EBAN	BNFPO	REF	1	N
2	EKPOLIGHT	BPRME	T006	MSEHI	REF	1	N
3	EKPOLIGHT	BUKRS	T001	BUKRS	REF	1	N
4	EKPOLIGHT	BWTAR	T149D	BWTAR	REF	1	N
5	EKPOLIGHT	BWTTY	T149C	BWTTY	REF	1	N
6	EKPOLIGHT	EMATN	MARA	MATNR	REF	1	N
7	EKPOLIGHT	INCO1	TINC	INCO1	REF	1	N
8	EKPOLIGHT	KNTTP	T163K	KNTTP	REF	1	N
9	EKPOLIGHT	MATKL	T023	MATKL	REF	1	N
10	EKPOLIGHT	MATNR	MARA	MATNR	REF	1	N
11	EKPOLIGHT	MEINS	T006	MSEHI	REF	1	N
12	EKPOLIGHT	MTART	T134	MTART
13	EKPOLIGHT	MWSKZ	T007A	MWSKZ	KEY	1	CN
14	EKPOLIGHT	PSTYP	T163	PSTYP	REF	1	N
15	EKPOLIGHT	SOBKZ	T148	SOBKZ	REF	1	N
16	EKPOLIGHT	TXJCD	TTXJ	TXJCD	REF	1	CN
17	EKPOLIGHT	WERKS	T001W	WERKS	REF	1	N

History

Last changed by/on	SAP	20130529
SAP Release Created in