queryviz
tables/relationship path
open in builder
T002
SPRAS
T005T
LAND1
T005
LAND1
LFA1
LIFNR
VBPA

VBPA

sales document: partner
sd12f · 3k · 8r

fields (12)

fieldtypelengthkeydescription
PARVWchar2pkpartner function code (ag=sold-to, we=ship-to, re=bill-to, rg=payer, sp=sales employee, ve=carrier)
POSNRnumc6pkitem number (000000 = header partner)
VBELNchar10pksales document number
ABLADchar25unloading point
ADRDAdats8validity date for address
ADRNRchar10address number from central address management (adrc)
KUNNRchar10customer number for this partner
LAND1char3country key
LIFNRchar10vendor number for this partner (if partner is a vendor)
MANDTclnt3client
PARNRchar10partner number (for partners not customers/vendors)
PERNRnumc8personnel number (if partner is an employee)

relationships (8)

master lookup

reference to master data

references
VBUP
POSNRPOSNR
N:1
VBUK
VBELNVBELN
N:1
LFA1
LIFNRLIFNR
N:1
KNA1
KUNNRKUNNR
N:1
configuration

reference to config tables

references
T005
LAND1LAND1
N:1
TPAR
PARVWPARVW
N:1
header / item

parent-child document structure

references
VBAK
VBELNVBELN
N:1
referenced by
VBAK
VBELNVBELN
1:N
queryviz.iobuy me a coffee
s/4 migrationpricingcompareaboutcontactprivacyterms