queryviz
tables/relationship path
open in builder
TCA01
PLNTY
MAPL
MATNR
MARA
MATNR
VBAP
VBELN → VBELV, POSNR → POSNV
VBFA

VBFA

sales document flow
sd14f · 7k · 3r

fields (14)

fieldtypelengthkeydescription
MANDTclnt3pkclient
POSNNnumc6pksubsequent sales document item number
POSNVnumc6pkpreceding sales document item number
VBELNchar10pksubsequent sales document number (follow-on document)
VBELVchar10pkpreceding sales document number (source document)
VBTYP_Nchar1pksd document category of subsequent document. same domain values as vbtyp_v but represents the follow-on document type. common queries: where vbtyp_n='j' finds all deliveries created from a given order; where vbtyp_n='m' finds all invoices. combining vbtyp_v and vbtyp_n allows you to trace the entire order-to-cash flow.
VBTYP_Vchar1pksd document category of preceding document. key values: a=inquiry, b=quotation, c=sales order, e=scheduling agreement, g=contract, h=returns, j=delivery, k=credit memo, l=debit memo, m=invoice, n=credit memo (accounting), o=debit memo (accounting), p=purchase order (third party). used to filter document flow by source type.
ERDATdats8date record was created (document flow entry creation date)
ERZETtims6created at
MEINSunit3base unit of measure for referenced quantity
PLMINchar1plus/minus flag for quantities (+/-)
RFMNGquan15referenced quantity (quantity copied from preceding document)
RFWRTcurr15referenced value (document currency)
WAERScuky5currency of referenced value

relationships (3)

history

historical/audit records

referenced by
LIKP
VBELVVBELN
1:N
VBAP
VBELVVBELN
POSNVPOSNR
1:N
VBAK
VBELVVBELN
1:N
queryviz.iobuy me a coffee
s/4 migrationpricingcompareaboutcontactprivacyterms