EKPO SAP table for – Purchasing Document Item

Here we would like to draw your attention to EKPO table in SAP. As we know it is being mainly used with the SAP MM-PUR (Purchasing in MM) component which is coming under MM module (Material Management). EKPO is a SAP standard transparent table used for storing Purchasing Document Item related data in SAP. It comes under the package ME.

SAP EKPO table

Table EKPO technical data

TableEKPO
Data storingPurchasing Document Item
ModuleMM
ComponentMM-PUR
SAP PackageME
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP EKPO Table Fields

Here is the details of each fields in this table.You can find the discription, data type and assigned lenth of each of the fields in EKPO table.

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • KO_GSBER
    Its data type is C (Character String) with field length 4
  • KO_PRCTR
    Its data type is C (Character String) with field length 10
  • MEPRF
    Its data type is C (Character String) with field length 1
  • VOLUM : Volume
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • INCO1 : Incoterms (part 1)
    Its data type is C (Character String) with field length 3
  • BUKRS : Company Code
    Its data type is C (Character String) with field length 4
  • VORAB
    Its data type is C (Character String) with field length 1
  • LTSNR : Vendor Subrange
    Its data type is C (Character String) with field length 6
  • FPLNR : Billing plan number / invoicing plan number
    Its data type is C (Character String) with field length 10
  • STAPO
    Its data type is C (Character String) with field length 1
  • LEWED
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • LBLKZ
    Its data type is C (Character String) with field length 1
  • ATTYP
    Its data type is C (Character String) with field length 2
  • ADRN2
    Its data type is C (Character String) with field length 10
  • XERSY
    Its data type is C (Character String) with field length 1
  • DRDAT
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • LGORT : Storage location
    Its data type is C (Character String) with field length 4
  • DRUNR
    Its data type is N (Character String with Digits Only) with field length 4
  • ABELN
    Its data type is C (Character String) with field length 10
  • ANZPU
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • SAISO
    Its data type is C (Character String) with field length 4
  • EBON2
    Its data type is C (Character String) with field length 2
  • EBONF
    Its data type is C (Character String) with field length 1
  • MHDRZ
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • ANFPS
    Its data type is N (Character String with Digits Only) with field length 5
  • USEQU
    Its data type is C (Character String) with field length 1
  • BANFN : Purchase requisition number
    Its data type is C (Character String) with field length 10
  • MATKL : Material Group
    Its data type is C (Character String) with field length 9
  • MTART : Material type
    Its data type is C (Character String) with field length 4
  • UPVOR
    Its data type is C (Character String) with field length 1
  • KZWI2
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • KZWI4
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • KZWI6
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • MFZHI
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • RETPO : Returns Item
    Its data type is C (Character String) with field length 1
  • BSGRU
    Its data type is C (Character String) with field length 3
  • NRFHG
    Its data type is C (Character String) with field length 1
  • IDNLF
    Its data type is C (Character String) with field length 35
  • J_1BMATUSE
    Its data type is C (Character String) with field length 1
  • J_1BOWNPRO
    Its data type is C (Character String) with field length 1
  • ABUEB
    Its data type is C (Character String) with field length 4
  • NFABD
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • BONBA
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • J_1AINDXP
    Its data type is C (Character String) with field length 5
  • MPROF
    Its data type is C (Character String) with field length 4
  • EGLKZ
    Its data type is C (Character String) with field length 1
  • KZFME
    Its data type is C (Character String) with field length 1
  • TECHS : Parameter Variant/Standard Variant
    Its data type is C (Character String) with field length 12
  • CHG_FPLNR
    Its data type is C (Character String) with field length 1
  • MENGE : Quantity
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • MFRNR
    Its data type is C (Character String) with field length 10
  • NOVET
    Its data type is C (Character String) with field length 1
  • TZONRC
    Its data type is C (Character String) with field length 6
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
    Its include structure/component is is CI_EKPODB
  • BPRME : Order Price Unit (purchasing)
    Its data type is C (Character String) with field length 3
  • BPUMN
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • UMREN : Denominator for conversion to base units of measure
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • PEINH : Price unit
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • BRTWR
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • EBELP : Item Number of Purchasing Document
    Its a key field. Its data type is N (Character String with Digits Only) with field length 5
  • WEBAZ : Goods receipt processing time in days
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 2
  • INSMK : Stock Type
    Its data type is C (Character String) with field length 1
  • PRSDR
    Its data type is C (Character String) with field length 1
  • MAHNZ
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 2
  • MAHN2
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 2
  • UEBTO : Overdelivery Tolerance Limit
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 2
  • UNTTO : Underdelivery Tolerance Limit
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 2
  • BWTTY : Valuation Category
    Its data type is C (Character String) with field length 1
  • ABSKZ
    Its data type is C (Character String) with field length 1
  • ELIKZ : “Delivery Completed” Indicator
    Its data type is C (Character String) with field length 1
  • LOEKZ : CHAR01 data element for SYST
    Its data type is C (Character String) with field length 1
  • PSTYP : Item category in purchasing document
    Its data type is C (Character String) with field length 1
  • KZVBR : Consumption posting
    Its data type is C (Character String) with field length 1
  • TWRKZ
    Its data type is C (Character String) with field length 1
  • WEUNB : Goods Receipt, Non-Valuated
    Its data type is C (Character String) with field length 1
  • KZABS
    Its data type is C (Character String) with field length 1
  • KTPNR
    Its data type is N (Character String with Digits Only) with field length 5
  • ABFTZ
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • ETFZ2
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 2
  • KZSTU
    Its data type is C (Character String) with field length 1
  • NOTKZ
    Its data type is C (Character String) with field length 1
  • AEDAT : (8-character) Date for SYST
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • EVERS
    Its data type is C (Character String) with field length 2
  • NAVNW
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • PRDAT
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • EFFWR
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • KUNNR : Customer number
    Its data type is C (Character String) with field length 10
  • EKKOL : Condition Group with Vendor
    Its data type is C (Character String) with field length 4
  • STAFO
    Its data type is C (Character String) with field length 6
  • NTGEW : Net Weight
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • TXJCD : Tax Jurisdiction
    Its data type is C (Character String) with field length 15
  • SOBKZ : Special Stock Indicator
    Its data type is C (Character String) with field length 1
  • MATNR : Material Number
    Its data type is C (Character String) with field length 18
  • ARSPS : Order item number
    Its data type is N (Character String with Digits Only) with field length 4
  • SSQSS
    Its data type is C (Character String) with field length 8
  • EAN11 : International Article Number (EAN/UPC)
    Its data type is C (Character String) with field length 18
  • REVLV : Revision Level
    Its data type is C (Character String) with field length 2
  • FISTL : Funds Center
    Its data type is C (Character String) with field length 16