queryviz
tables/relationship path
open in builder
TFKB
FKBER → FUNC
AUFK
AUFNR
MDTB
BANFN
EBAN

EBAN

purchase requisition
mm35f · 2k · 2r

fields (35)

fieldtypelengthkeydescription
BANFNchar10pkpurchase requisition number
BNFPOnumc5pkitem number of purchase requisition
AFNAMchar12name of requisitioner/requester
AUFNRchar12order number
BADATdats8requisition date
BSARTchar4document type
EBELNchar10purchasing document number
EBELPnumc5item number of purchasing document
EINDTdats8delivery date
EKGRPchar3purchasing group
EKORGchar4purchasing organization
ERNAMchar12name of person who created the object
ESTKZchar1creation indicator: purchase requisition
FIXKZchar1fixed-date and quantity indicator
FRGKZchar1release indicator: purchasing document
FRGRLchar1release is canceled
FRGZUchar8release state
INFNRchar10number of purchasing info record
KOSTLchar10cost center
LGORTchar4storage location
LIFNRchar10vendor account number
LOEKZchar1deletion indicator
MATKLchar9material group
MATNRchar18material number
MEINSunit3base unit of measure
MENGEquan13quantity
PEINHdec5price unit
PREIScurr11valuation price in purchasing
RESWKchar4issuing plant for intracompany transfer
SAKTOchar10g/l account number
STATUchar1processing status
TXZ01char40short text
WAERScurr5currency key
WEBREchar1indicator: gr-based invoice verification
WERKSchar4plant

relationships (2)

header / item

parent-child document structure

references
EKPO
BANFNBANFN
BNFPOBNFPO
1:N
master lookup

reference to master data

referenced by
MDTB
BANFNBANFN
N:1
queryviz.iobuy me a coffee
s/4 migrationpricingcompareaboutcontactprivacyterms