queryviz
tables/relationship path
open in builder
TSPA
SPART
MARA
MATNR
EINA
INFNR
EKPO

EKPO

purchasing document item
mm37f · 2k · 13r
Unchanged in S/4
No structural change in S/4HANA. EKPO remains the purchasing document item table.
key differences:
  • •Table structure unchanged in S/4HANA
  • •Some fields deprecated but table remains primary purchasing item

fields (37)

fieldtypelengthkeydescription
EBELNchar10pkpurchasing document number
EBELPnumc5pkitem number of purchasing document
AUFNRchar12order number
BANFNchar10purchase requisition number
BNFPOnumc5item number of purchase requisition
BRTWRcurr13gross order value in po currency
BSARTchar4purchasing document type
EINDTdats8item delivery date
ELIKZchar1delivery completed indicator
INFNRchar10number of purchasing info record
KNTTPchar1account assignment category
KONNRchar10contract number
KOSTLchar10cost center
KTPNRnumc5contract item
LEWEDdats8latest possible goods receipt date
LGORTchar4storage location
LOEKZchar1deletion indicator in purchasing document
MATKLchar9material group
MATNRchar18material number
MEINSunit3purchase order unit of measure
MENGEquan13purchase order quantity
NETPRcurr11net price in purchasing document
NETWRcurr13net order value in po currency
PEINHdec5price unit
PRCTRchar10profit center
PRDATdats8price date
PSTYPchar1item category in purchasing document
REPOSchar1invoice receipt indicator
SAKTOchar10g/l account number
TXZ01char40short text
UEBTOdec3overdelivery tolerance
UNTTOdec3underdelivery tolerance
VBELNchar10sales and distribution document number
VBELPnumc6sales document item
WEBREchar1indicator: gr-based invoice verification
WEPOSchar1goods receipt indicator
WERKSchar4plant

relationships (13)

master lookup

reference to master data

references
MARA
MATNRMATNR
N:1
RSEG
EBELNEBELN
EBELPEBELP
1:N
referenced by
MSEG
EBELNEBELN
EBELPEBELP
N:1
RSEG
EBELNEBELN
EBELPEBELP
N:1
EINA
INFNRINFNR
1:N
EKPA
EBELPEBELP
N:1
header / item

parent-child document structure

references
EKET
EBELNEBELN
EBELPEBELP
1:N
EKKO
EBELNEBELN
N:1
referenced by
EBAN
BANFNBANFN
BNFPOBNFPO
1:N
ESKN
EBELNEBELN
EBELPEBELP
1:N
EKKO
EBELNEBELN
1:N
history

historical/audit records

references
EKBE
EBELNEBELN
EBELPEBELP
1:N
referenced by
EKBE
EBELNEBELN
EBELPEBELP
N:1
queryviz.io
s/4 migrationpricingcompareaboutcontactprivacyterms