SAP ABAP Table EKPODATA (Purchasing Document Item: Data Part)
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 EKPODATA   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 LOEKZ ELOEK ELOEK CHAR 1   0   Deletion indicator in purchasing document  
2 STATU ASTAT ASTAT CHAR 1   0   RFQ status  
3 AEDAT PAEDT DATUM DATS 8   0   Purchasing Document Item Change Date  
4 TXZ01 TXZ01 TEXT40 CHAR 40   0   Short Text  
5 MATNR MATNR MATNR CHAR 18   0   Material Number  
6 EMATN EMATNR MATNR CHAR 18   0   Material number  
7 BUKRS BUKRS BUKRS CHAR 4   0   Company Code T001
8 WERKS EWERK WERKS CHAR 4   0   Plant T001W
9 LGORT LGORT_D LGORT CHAR 4   0   Storage location  
10 BEDNR BEDNR CHAR10 CHAR 10   0   Requirement Tracking Number  
11 MATKL MATKL MATKL CHAR 9   0   Material Group T023
12 INFNR INFNR INFNR CHAR 10   0   Number of purchasing info record *
13 IDNLF IDNLF IDNEX CHAR 35   0   Material Number Used by Vendor  
14 KTMNG KTMNG MENGE QUAN 13   3   Target Quantity  
15 MENGE BSTMG MENG13 QUAN 13   3   Purchase Order Quantity  
16 MEINS BSTME MEINS UNIT 3   0   Order unit T006
17 BPRME BBPRM MEINS UNIT 3   0   Order Price Unit (purchasing) T006
18 BPUMZ BPUMZ UMBSZ DEC 5   0   Numerator for Conversion of Order Price Unit into Order Unit  
19 BPUMN BPUMN UMBSN DEC 5   0   Denominator for Conv. of Order Price Unit into Order Unit  
20 UMREZ UMBSZ UMBSZ DEC 5   0   Numerator for Conversion of Order Unit to Base Unit  
21 UMREN UMBSN UMBSN DEC 5   0   Denominator for Conversion of Order Unit to Base Unit  
22 NETPR BPREI WERT11 CURR 11   2   Net Price in Purchasing Document (in Document Currency)  
23 PEINH EPEIN DEC5 DEC 5   0   Price unit  
24 NETWR BWERT WERT7 CURR 13   2   Net Order Value in PO Currency  
25 BRTWR BBWERT WERT7 CURR 13   2   Gross order value in PO currency  
26 AGDAT ANGAB DATUM DATS 8   0   Deadline for Submission of Bid/Quotation  
27 WEBAZ WEBAZ DEC3 DEC 3   0   Goods receipt processing time in days  
28 MWSKZ MWSKZ MWSKZ CHAR 2   0   Tax on sales/purchases code *
29 BONUS EBONU EBONU CHAR 2   0   Settlement Group 1 (Purchasing)  
30 INSMK INSMK INSMK CHAR 1   0   Stock Type  
31 SPINF SPINF SPINF CHAR 1   0   Indicator: Update Info Record  
32 PRSDR PRSDR XFELD CHAR 1   0   Price Printout  
33 SCHPR SCHPR XFELD CHAR 1   0   Indicator: Estimated Price  
34 MAHNZ MAHNZ PACK2 DEC 3   0   Number of Reminders/Expediters  
35 MAHN1 MAHN1 MAHNT DEC 3   0   Number of Days for First Reminder/Expediter  
36 MAHN2 MAHN2 MAHNT DEC 3   0   Number of Days for Second Reminder/Expediter  
37 MAHN3 MAHN3 MAHNT DEC 3   0   Number of Days for Third Reminder/Expediter  
38 UEBTO UEBTO PRZ21 DEC 3   1   Overdelivery Tolerance Limit  
39 UEBTK UEBTK XFELD CHAR 1   0   Indicator: Unlimited Overdelivery Allowed  
40 UNTTO UNTTO PRZ21 DEC 3   1   Underdelivery Tolerance Limit  
41 BWTAR BWTAR_D BWTAR CHAR 10   0   Valuation type  
42 BWTTY BWTTY_D BWTTY CHAR 1   0   Valuation Category *
43 ABSKZ ABSKZ XFELD CHAR 1   0   Rejection Indicator  
44 AGMEM AGMEM AGMEM CHAR 3   0   Internal Comment on Quotation *
45 ELIKZ ELIKZ XFELD CHAR 1   0   "Delivery Completed" Indicator  
46 EREKZ EREKZ XFELD CHAR 1   0   Final Invoice Indicator  
47 PSTYP PSTYP PSTYP CHAR 1   0   Item category in purchasing document *
48 KNTTP KNTTP KNTTP CHAR 1   0   Account assignment category *
49 KZVBR KZVBR KZVBR CHAR 1   0   Consumption posting  
50 VRTKZ VRTKZ VRTKZ CHAR 1   0   Distribution indicator for multiple account assignment  
51 TWRKZ TWRKZ TWRKZ CHAR 1   0   Partial invoice indicator  
52 WEPOS WEPOS XFELD CHAR 1   0   Goods Receipt Indicator  
53 WEUNB WEUNB XFELD CHAR 1   0   Goods Receipt, Non-Valuated  
54 REPOS REPOS XFELD CHAR 1   0   Invoice receipt indicator  
55 WEBRE WEBRE XFELD CHAR 1   0   Indicator: GR-Based Invoice Verification  
56 KZABS KZABS XFELD CHAR 1   0   Order Acknowledgment Requirement  
57 LABNR LABNR TEXT20 CHAR 20   0   Order Acknowledgment Number  
58 KONNR KONNR EBELN CHAR 10   0   Number of principal purchase agreement EKKO
59 KTPNR KTPNR EBELP NUMC 5   0   Item number of principal purchase agreement EKPO
60 ABDAT ABDAT DATUM DATS 8   0   Reconciliation date for agreed cumulative quantity  
61 ABFTZ ABFTZ MENG13 QUAN 13   3   Agreed Cumulative Quantity  
62 ETFZ1 ETFZ1 PACK2 DEC 3   0   Firm Zone (Go-Ahead for Production)  
63 ETFZ2 ETFZ2 PACK2 DEC 3   0   Trade-Off Zone (Go-Ahead for Materials Procurement)  
64 KZSTU MRPRE KZFIX CHAR 1   0   Firm/Trade-Off Zones Binding with Regard to Mat. Planning  
65 NOTKZ NOTKZ XFELD CHAR 1   0   Exclusion in Outline Agreement Item with Material Class  
66 LMEIN LAGME MEINS UNIT 3   0   Base Unit of Measure T006
67 EVERS EVERS EVERS CHAR 2   0   Shipping Instructions *
68 ZWERT DZWERT WERT7 CURR 13   2   Target value for outline agreement in document currency  
69 NAVNW NAVNW WERT7 CURR 13   2   Non-deductible input tax  
70 ABMNG NORAM MENG13 QUAN 13   3   Standard release order quantity  
71 PRDAT PREDT DATUM DATS 8   0   Date of Price Determination  
72 BSTYP BSTYP BSTYP CHAR 1   0   Purchasing document category  
73 EFFWR EFFWR WERT7 CURR 13   2   Effective value of item  
74 XOBLR XOBLR XFELD CHAR 1   0   Item affects commitments  
75 KUNNR EKUNNR KUNNR CHAR 10   0   Customer *
76 ADRNR ADRNR_MM AD_ADDRNUM CHAR 10   0   Manual address number in purchasing document item ADRC
77 EKKOL EKKOG CHAR4 CHAR 4   0   Condition Group with Vendor  
78 SKTOF ESKTOF XFELD CHAR 1   0   Item Does Not Qualify for Cash Discount  
79 STAFO STAFO STAFO CHAR 6   0   Update group for statistics update *
80 PLIFZ EPLIF DEC3 DEC 3   0   Planned Delivery Time in Days  
81 NTGEW ENTGE MENG13 QUAN 13   3   Net Weight  
82 GEWEI EGEWE MEINS UNIT 3   0   Unit of Weight T006
83 TXJCD TXJCD TXJCD CHAR 15   0   Tax Jurisdiction *
84 ETDRK ETDRK ETDRK CHAR 1   0   Indicator: Print-relevant schedule lines exist  
85 SOBKZ SOBKZ SOBKZ CHAR 1   0   Special Stock Indicator *
86 ARSNR ARSNR MDNUM NUMC 10   0   Settlement reservation number  
87 ARSPS ARSPS RSPOS NUMC 4   0   Item number of the settlement reservation  
88 INSNC INSNC XFELD CHAR 1   0   Quality inspection indicator cannot be changed  
89 SSQSS QSSPUR QSSPUR CHAR 8   0   Control Key for Quality Management in Procurement *
90 ZGTYP QZGTYP QZGTYP CHAR 4   0   Certificate Type *
91 EAN11 EAN11 EAN11 CHAR 18   0   International Article Number (EAN/UPC)  
92 BSTAE BSTAE BSTAE CHAR 4   0   Confirmation Control Key *
93 REVLV REVLV REVLV CHAR 2   0   Revision level  
94 GEBER BP_GEBER BP_GEBER CHAR 10   0   Fund *
95 FISTL FISTL FISTL CHAR 16   0   Funds Center *
96 FIPOS FIPOS FIPOS CHAR 14   0   Commitment Item FMFPO
97 KO_GSBER GSBER_GP GSBER CHAR 4   0   Business area reported to the partner *
98 KO_PARGB PARGB_GP GSBER CHAR 4   0   assumed business area of the business partner *
99 KO_PRCTR PRCTR PRCTR CHAR 10   0   Profit Center  
100 KO_PPRCTR PPRCTR PRCTR CHAR 10   0   Partner Profit Center  
101 MEPRF MEPRF MEPRF CHAR 1   0   Price Determination (Pricing) Date Control  
102 BRGEW BRGEW MENG13 QUAN 13   3   Gross weight  
103 VOLUM VOLUM MENG13 QUAN 13   3   Volume  
104 VOLEH VOLEH MEINS UNIT 3   0   Volume unit T006
105 INCO1 INCO1 CRM_INCOTERMS1 CHAR 3   0   Incoterms (part 1) *
106 INCO2 INCO2 CRM_INCOTERMS2 CHAR 28   0   Incoterms (part 2)  
107 VORAB VORAB XFELD CHAR 1   0   Advance procurement: project stock  
108 KOLIF KOLIF LIFNR CHAR 10   0   Prior Vendor LFA1
109 LTSNR LTSNR LTSNR CHAR 6   0   Vendor Subrange *
110 PACKNO PACKNO PACKNO NUMC 10   0   Package number *
111 FPLNR IPLNR CHAR10 CHAR 10   0   Invoicing plan number  
112 GNETWR BWERT WERT7 CURR 13   2   Net Order Value in PO Currency  
113 STAPO STAPO XFELD CHAR 1   0   Item is statistical  
114 UEBPO UEBPO EBELP NUMC 5   0   Higher-Level Item in Purchasing Documents EKPO
115 LEWED LEWED DATUM DATS 8   0   Latest Possible Goods Receipt  
116 EMLIF EMLIF LIFNR CHAR 10   0   Vendor to be supplied/who is to receive delivery LFA1
117 LBLKZ LBLKZ XFELD CHAR 1   0   Subcontracting vendor  
118 SATNR SATNR MATNR CHAR 18   0   Cross-Plant Configurable Material  
119 ATTYP ATTYP ATTYP CHAR 2   0   Material Category  
120 KANBA KBNKZ KBNKZ CHAR 1   0   Kanban Indicator  
121 ADRN2 ADRN2 AD_ADDRNUM CHAR 10   0   Number of delivery address ADRC
122 CUOBJ CUOBJ CUOBJ NUMC 18   0   Configuration (internal object number)  
123 XERSY XERSY XFELD CHAR 1   0   Evaluated Receipt Settlement (ERS)  
124 EILDT EILDT DATUM DATS 8   0   Start Date for GR-Based Settlement  
125 DRDAT DRDAT DATUM DATS 8   0   Last Transmission  
126 DRUHR DRUHR UZEIT TIMS 6   0   Time  
127 DRUNR DRUNR NUMC4 NUMC 4   0   Sequential Number  
128 AKTNR WAKTION WAKTION CHAR 10   0   Promotion  
129 ABELN ABELN ABELN CHAR 10   0   Allocation Table Number *
130 ABELP ABELP ABELP NUMC 5   0   Item number of allocation table *
131 ANZPU ANZPU MENG13 QUAN 13   3   Number of Points  
132 PUNEI PUNEI MEINS UNIT 3   0   Points unit T006
133 SAISO SAISO SAISO CHAR 4   0   Season Category *
134 SAISJ SAISJ CJAHR CHAR 4   0   Season Year  
135 EBON2 EBON2 EBONU CHAR 2   0   Settlement Group 2 (Rebate Settlement, Purchasing)  
136 EBON3 EBON3 EBONU CHAR 2   0   Settlement Group 3 (Rebate Settlement, Purchasing)  
137 EBONF EBONY XFELD CHAR 1   0   Item Relevant to Subsequent (Period-End Rebate) Settlement  
138 MLMAA CK_ML_MAAC XFELD CHAR 1   0   Material ledger activated at material level  
139 MHDRZ MHDRZ DEC4 DEC 4   0   Minimum Remaining Shelf Life  
140 ANFNR ANFNR EBELN CHAR 10   0   RFQ Number EKKO
141 ANFPS ANFPS EBELP NUMC 5   0   Item Number of RFQ EKPO
142 KZKFG KZCUH KZCUH CHAR 1   0   Origin of Configuration  
143 USEQU USEQU USEQU CHAR 1   0   Quota arrangement usage *
144 UMSOK UMSOK SOBKZ CHAR 1   0   Special stock indicator for physical stock transfer *
145 BANFN BANFN BANFN CHAR 10   0   Purchase requisition number  
146 BNFPO BNFPO BNFPO NUMC 5   0   Item number of purchase requisition EBAN
147 MTART MTART MTART CHAR 4   0   Material type *
148 UPTYP UPTYP UPTYP CHAR 1   0   Subitem Category, Purchasing Document *
149 UPVOR UPVOR CHAR1 CHAR 1   0   Subitems Exist  
150 KZWI1 KZWI1 WERTV7 CURR 13   2   Subtotal 1 from pricing procedure for condition  
151 KZWI2 KZWI2 WERTV7 CURR 13   2   Subtotal 2 from pricing procedure for condition  
152 KZWI3 KZWI3 WERTV7 CURR 13   2   Subtotal 3 from pricing procedure for condition  
153 KZWI4 KZWI4 WERTV7 CURR 13   2   Subtotal 4 from pricing procedure for condition  
154 KZWI5 KZWI5 WERTV7 CURR 13   2   Subtotal 5 from pricing procedure for condition  
155 KZWI6 KZWI6 WERTV7 CURR 13   2   Subtotal 6 from pricing procedure for condition  
156 SIKGR SIKGR SIKGR CHAR 3   0   Processing key for sub-items *
157 MFZHI MFZHI MENG15 QUAN 15   3   Maximum Cumulative Material Go-Ahead Quantity  
158 FFZHI FFZHI MENG15 QUAN 15   3   Maximum Cumulative Production Go-Ahead Quantity  
159 RETPO RETPO XFELD CHAR 1   0   Returns Item  
160 AUREL AUREL AUREL CHAR 1   0   Relevant to Allocation Table  
161 BSGRU BSGRU BSGRU CHAR 3   0   Reason for Ordering  
162 LFRET LFRET LFART CHAR 4   0   Delivery Type for Returns to Vendors *
163 MFRGR MFRGR MFRGR CHAR 8   0   Material freight group  
164 NRFHG NRFHG NRFHG CHAR 1   0   Material qualifies for discount in kind  
165 J_1BNBM J_1BNBMCO1 STEUC CHAR 16   0   Brazilian NCM Code *
166 J_1BMATUSE J_1BMATUSE J_1BMATUSE CHAR 1   0   Usage of the material  
167 J_1BMATORG J_1BMATORG J_1BMATORG CHAR 1   0   Origin of the material  
168 J_1BOWNPRO J_1BOWNPRO XFELD CHAR 1   0   Produced in-house  
169 J_1BINDUST J_1BINDUS3 J_1BINDUS3 CHAR 2   0   Material CFOP category  
170 ABUEB ABUEB ABUEB CHAR 4   0   Release Creation Profile *
171 NLABD NLABD DATUM DATS 8   0   Next Forecast Delivery Schedule Transmission  
172 NFABD NFABD DATUM DATS 8   0   Next JIT Delivery Schedule Transmission  
173 KZBWS KZBWS KZBWS CHAR 1   0   Valuation of Special Stock  
174 BONBA BONBA WERTV7 CURR 13   2   Rebate basis 1  
175 FABKZ FABKZ FABKZ CHAR 1   0   Indicator: Item Relevant to JIT Delivery Schedules  
176 J_1AINDXP J_1AINDXP J_1AINDXP CHAR 5   0   Inflation Index *
177 J_1AIDATEP J_1AIDATEP J_1AUDATEP DATS 8   0   Last day of the time period where the index value is valid  
178 MPROF MPROF MPROF CHAR 4   0   Mfr part profile *
179 EGLKZ EGLKZ XFELD CHAR 1   0   "Outward Delivery Completed" Indicator  
180 KZTLF KZTUL KZTUL CHAR 1   0   Partial Delivery at Item Level (Stock Transfer)  
181 KZFME KZWSO KZWSO CHAR 1   0   Units of measure usage  
182 RDPRF RDPRF RDPRF CHAR 4   0   Rounding Profile *
183 TECHS TECHS TECHS CHAR 12   0   Parameter Variant/Standard Variant  
184 CHG_SRV CHG_SRV XFELD CHAR 1   0   Configuration changed  
185 CHG_FPLNR CHG_FPLNR XFELD CHAR 1   0   No invoice for this item although not free of charge  
186 MFRPN MFRPN CHAR40 CHAR 40   0   Manufacturer Part Number  
187 MFRNR MFRNR LIFNR CHAR 10   0   Manufacturer number LFA1
188 EMNFR EMNFR CHAR10 CHAR 10   0   External manufacturer code name or number  
189 NOVET NOVET XFELD CHAR 1   0   Item blocked for SD delivery  
190 AFNAM AFNAM AFNAM CHAR 12   0   Name of requisitioner/requester  
191 TZONRC TSEGZONREC TZNZONE CHAR 6   0   Time zone of recipient location *
192 IPRKZ DATTP DATTP CHAR 1   0   Period Indicator for Shelf Life Expiration Date  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 EKPODATA ADRN2 ADRC ADDRNUMBER    
2 EKPODATA ADRNR ADRC ADDRNUMBER KEY 1 CN
3 EKPODATA ANFNR EKKO EBELN REF 1 N
4 EKPODATA ANFPS EKPO EBELP REF 1 N
5 EKPODATA BNFPO EBAN BNFPO REF 1 N
6 EKPODATA BPRME T006 MSEHI REF 1 N
7 EKPODATA BUKRS T001 BUKRS REF 1 N
8 EKPODATA EMLIF LFA1 LIFNR KEY 1 N
9 EKPODATA FIPOS FMFPO FIPOS REF C CN
10 EKPODATA GEWEI T006 MSEHI REF 1 N
11 EKPODATA KOLIF LFA1 LIFNR REF 1 CN
12 EKPODATA KONNR EKKO EBELN REF 1 N
13 EKPODATA KTPNR EKPO EBELP REF 1 N
14 EKPODATA LMEIN T006 MSEHI REF 1 N
15 EKPODATA MATKL T023 MATKL REF 1 N
16 EKPODATA MEINS T006 MSEHI REF 1 N
17 EKPODATA MFRNR LFA1 LIFNR REF 1 N
18 EKPODATA PUNEI T006 MSEHI KEY 1 N
19 EKPODATA UEBPO EKPO EBELP    
20 EKPODATA VOLEH T006 MSEHI REF 1 N
21 EKPODATA WERKS T001W WERKS REF 1 N
History
Last changed by/on SAP  20130604 
SAP Release Created in