SAP table EXPD_EKPO_EKKODATA (Header data for order item (EKKO for EKPO))

Field Description Data Type Length Decimals Checktable Data Element
LIFNR Account Number of Supplier CHAR 10 0 LFA1 LIFNR
NAME1 Name 1 CHAR 35 0 NAME1_GP
PO_STATU Status of Purchasing Document CHAR 1 0 ESTAK
1 Purchase Order from APO
2 Third-Party Order from CRM
3 Returns Order from Incorrect Delivery
4 Subsequent Stock Transport Order for Additional Item
5 Incorrect Item Returns from Stock Transport Orders
9 Enjoy Purchase Order
A RFQ with Quotation
B Purchase Order from Automatic Conversion of Requisitions
C Purchase Order from Goods Receipt
D Purchase Order from Data Transfer
E Purchase Order from Allocation Table
F Purchase Order from Kanban
G Purchase Order from Store Order
H Purchase Order from DRP
I Purchase Order from BAPI
J Purchase Order from ALE Scenario
K Purchase Order from BBP
L Scheduling Agreement from CRM
M Purchasing Document from E-Sourcing
N Purchase Document from external Network / System
R S4CRM Service Order
S Collective Purchase Order
T Purchase Order from Transportation Management
W Purchase Order Ignored for Collective Delivery Run
X Purchase Order Created via Function Module
PO_AEDAT Date on which the record was created DATS 8 0 ERDAT
BEDAT Purchasing Document Date DATS 8 0 EBDAT
PO_BUKRS Company Code CHAR 4 0 T001 BUKRS
PO_BSTYP Purchasing Document Category CHAR 1 0 EBSTYP
A Request for Quotation
C Central Contract
F Purchase Order
K Contract
L Scheduling Agreement
N Central Request for Quotation
O Quotation
P Central Purchsae Order
R RFQ
T Central Supplier Quotation
BSART Purchasing Document Type CHAR 4 0 T161 ESART
BSAKZ Control indicator for purchasing document type CHAR 1 0 BSAKZ
C Subordinate Document
H Hierarchy
R Purchase requisition for outline agreement
T Transport
PO_LOEKZ Deletion Indicator in Purchasing Document CHAR 1 0 ELOEK
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
PINCR Item Number Interval NUMC 5 0 PINCR
LPONR Last Item Number NUMC 5 0 EKPO LPONR
SPRAS Language Key LANG 1 0 T002 SPRAS
ZTERM Terms of payment key CHAR 4 0 DZTERM
ZBD1T Cash (Prompt Payment) Discount Days DEC 3 0 DZBDET
ZBD2T Cash (Prompt Payment) Discount Days DEC 3 0 DZBDET
ZBD3T Cash (Prompt Payment) Discount Days DEC 3 0 DZBDET
ZBD1P Cash discount percentage 1 DEC 5 3 DZBD1P
ZBD2P Cash Discount Percentage 2 DEC 5 3 DZBD2P
EKORG Purchasing organization CHAR 4 0 T024E EKORG
EKGRP Purchasing Group CHAR 3 0 T024 BKGRP
WAERS Currency Key CUKY 5 0 TCURC WAERS
WKURS Exchange Rate DEC 9 5 WKURS
KUFIX Indicator for Fixed Exchange Rate CHAR 1 0 KUFIX
KDATB Start of Validity Period DATS 8 0 KDATB
KDATE End of Validity Period DATS 8 0 KDATE
BWBDT Closing Date for Applications DATS 8 0 BWBDT
ANGDT Deadline for Submission of Bid/Quotation DATS 8 0 ANGAB
BNDDT Binding Period for Quotation DATS 8 0 EBNDT
GWLDT Warranty Date DATS 8 0 MM_GWLDT
AUSNR Bid invitation number CHAR 10 0 EKKO AUSCH
ANGNR Quotation Number CHAR 10 0 ANGNR
IHRAN Quotation Submission Date DATS 8 0 IHRAN
IHREZ Your Reference CHAR 12 0 IHREZ
VERKF Responsible Salesperson at Supplier's Office CHAR 30 0 EVERK
TELF1 Supplier's Telephone Number CHAR 16 0 TELF0
LLIEF Goods Supplier CHAR 10 0 LFA1 LLIEF
PO_KUNNR Customer Number CHAR 10 0 KNA1 KUNNR
PO_KONNR Number of principal purchase agreement CHAR 10 0 EKKO KONNR
ABGRU Field Not Used CHAR 2 0 ABDUM
AUTLF Complete Delivery Stipulated for Each Purchase Order CHAR 1 0 KMPLF
WEAKT Indicator: Goods Receipt Message CHAR 1 0 WEAKT
RESWK Supplying (issuing) plant in case of stock transport order CHAR 4 0 T001W RESWK
LBLIF Field not used CHAR 10 0 LFA1 LBLIF
PO_INCO1 Incoterms (Part 1) CHAR 3 0 TINC INCO1
PO_INCO2 Incoterms (Part 2) CHAR 28 0 INCO2
KTWRT Target Value for Header Area per Distribution CURR 15 2 KTWRT
SUBMI Collective Number CHAR 10 0 SUBMI
KNUMV Number of the Document Condition CHAR 10 0 KNUMV
KALSM Procedure (Pricing, Output Control, Acct. Det., Costing,...) CHAR 6 0 T683 KALSM_D
PO_STAFO Update Group for statistics update CHAR 6 0 STAFO
LIFRE Different Invoicing Party CHAR 10 0 LFA1 LIFRE
EXNUM Number of foreign trade data in MM and SD documents CHAR 10 0 EXNUM
UNSEZ Our Reference CHAR 12 0 UNSEZ
LOGSY Logical System CHAR 10 0 LOGSYSTEM
UPINC Item Number Interval for Subitems NUMC 5 0 UPINC
STAKO Document with time-dependent conditions CHAR 1 0 STAKO
FRGGR Release group CHAR 2 0 T16FG FRGGR
FRGSX Release Strategy CHAR 2 0 T16FS FRGSX
FRGKE Release Indicator: Purchasing Document CHAR 1 0 T16FB FRGKE
FRGZU Release State CHAR 8 0 FRGZU
FRGRL Release Not Yet Completely Effected CHAR 1 0 FRGRL
LANDS Country/Region for Tax Report CHAR 3 0 T005 LAND1_STML
LPHIS Indicator for scheduling agreement release documentation CHAR 1 0 LPHIS
PO_ADRNR Address Number CHAR 10 0 AD_ADDRNUM
STCEG_L Country/Region of Sales Tax ID Number CHAR 3 0 STCEG_L
STCEG VAT Registration Number CHAR 20 0 STCEG
ABSGR Reason for Cancellation NUMC 2 0 T165R ABSGR
ADDNR Document number for additional CHAR 10 0 ADDI_BELNR
KORNR Correction of miscellaneous provisions CHAR 1 0 KORNR
No corrections of miscellaneous provisions
1 Correction of misc. provisions in invoice verification
MEMORY Purchase order not yet complete CHAR 1 0 MEMER

EXPD_EKPO_EKKODATA foreign key relationships

Table Field Check Table Check Field
0 EXPD_EKPO_EKKODATA AUSNR EKKO Purchasing Document Header MANDT
0 EXPD_EKPO_EKKODATA AUSNR EKKO Purchasing Document Header EBELN
1 EXPD_EKPO_EKKODATA BSART T161 Purchasing Document Types MANDT
0 EXPD_EKPO_EKKODATA EKGRP T024 Purchasing Groups EKGRP
1 EXPD_EKPO_EKKODATA EKORG T024E Purchasing Organizations EKORG
0 EXPD_EKPO_EKKODATA FRGGR T16FG Release Groups FRGGR
1 EXPD_EKPO_EKKODATA KALSM T683 Pricing procedures KAPPL
1 EXPD_EKPO_EKKODATA KALSM T683 Pricing procedures KALSM
0 EXPD_EKPO_EKKODATA LANDS T005 Countries MANDT
0 EXPD_EKPO_EKKODATA LANDS T005 Countries LAND1
1 EXPD_EKPO_EKKODATA LBLIF LFA1 Supplier Master (General Section) MANDT
1 EXPD_EKPO_EKKODATA LBLIF LFA1 Supplier Master (General Section) LIFNR
0 EXPD_EKPO_EKKODATA LIFNR LFA1 Supplier Master (General Section) MANDT
0 EXPD_EKPO_EKKODATA LIFNR LFA1 Supplier Master (General Section) LIFNR
1 EXPD_EKPO_EKKODATA LIFRE LFA1 Supplier Master (General Section) MANDT
1 EXPD_EKPO_EKKODATA LIFRE LFA1 Supplier Master (General Section) LIFNR
0 EXPD_EKPO_EKKODATA LLIEF LFA1 Supplier Master (General Section) MANDT
0 EXPD_EKPO_EKKODATA LLIEF LFA1 Supplier Master (General Section) LIFNR
1 EXPD_EKPO_EKKODATA LPONR EKPO Purchasing Document Item MANDT
1 EXPD_EKPO_EKKODATA LPONR EKPO Purchasing Document Item EBELN
0 EXPD_EKPO_EKKODATA PO_BUKRS T001 Company Codes BUKRS
1 EXPD_EKPO_EKKODATA PO_INCO1 TINC Customers: Incoterms INCO1
0 EXPD_EKPO_EKKODATA PO_KONNR EKKO Purchasing Document Header MANDT
0 EXPD_EKPO_EKKODATA PO_KONNR EKKO Purchasing Document Header EBELN
1 EXPD_EKPO_EKKODATA PO_KUNNR KNA1 General Data in Customer Master MANDT
1 EXPD_EKPO_EKKODATA PO_KUNNR KNA1 General Data in Customer Master KUNNR
0 EXPD_EKPO_EKKODATA RESWK T001W Plants/Branches MANDT
0 EXPD_EKPO_EKKODATA RESWK T001W Plants/Branches WERKS
1 EXPD_EKPO_EKKODATA SPRAS T002 Language Keys (Component BC-I18) SPRAS
0 EXPD_EKPO_EKKODATA WAERS TCURC Currency Codes WAERS