VBPA

Sales Document: Partner | #transactional | Component: Basic Functions
Column Name Description
MANDT FK Client
VBELN Sales and Distribution Document Number
POSNR Item number of the SD document
PARVW FK Partner Function
Column Name Description
Column Name Description
Column Name Description
_DATAAGING Data Filter Value for Data Aging
Column Name Description
ADRDA Address indicator Show values
XCPDK Indicator: Is the account a one-time account? Show values
PRFRE Relevant for price determination ID Show values
BOKRE Indicator: Customer Is Rebate-Relevant Show values
PARVW_FF Indicator 'further partners in this function' (VBPA2) Show values
KALE Maintain appointments in calendar Show values
ADDR_TYPE Address type (1=Organization, 2=Person, 3=Contact person) Show values
SDM_VERSION SDM: Version field for VBPA Show values
Column Name Description Domain name
PERNR Personnel Number PERNR
PARNR Number of Contact Person PARNR
ADRNR Address ADRNR
ABLAD Unloading Point TEXT25
HISTUNR Level number within hierarchy NUM2
KNREF Customer description of partner (plant, storage location) KNREF
LZONE Transportation zone to or from which the goods are delivered ZONE
HZUOR Assignment to Hierarchy HZUOR
STCEG VAT Registration Number STCEG
BP_REF_ADRNR BP Reference Address Number AD_ADDRNUM
DUMMY_SDDOCPARTNER_INCL_EEW_PS Dummy function in length 1 DUMMY
Master Data Relations Join Conditions
Address Determination in Document
  • VBPA.MANDT == TB008S.CLIENT
  • VBPA.ADDR_OPERATION == TB008S.OPERATION
Person Number
  • ?
  • ?
  • Client
  • Person Number
  • VBPA.[column in domain "AD_DATE_FR"] == ADRP.DATE_FROM
  • VBPA.[column in domain "AD_NATION"] == ADRP.NATION
  • VBPA.MANDT == ADRP.CLIENT
  • VBPA.ADRNP == ADRP.PERSNUMBER
Business Partner Number
  • Business Partner Number
  • Client
  • VBPA.ASSIGNED_BP == BUT000.PARTNER
  • VBPA.MANDT == BUT000.CLIENT
Customer hierarchy type
  • VBPA.MANDT == THIT.MANDT
  • VBPA.HITYP == THIT.HITYP
Customer - Document Customer
  • VBPA.MANDT == KNA1.MANDT
  • VBPA.KUNNR == KNA1.KUNNR
Country/Region Key
  • Country/Region Key
  • Client
  • VBPA.LAND1 == T005.LAND1
  • VBPA.MANDT == T005.MANDT
Vendor - Document Vendor
  • VBPA.MANDT == LFA1.MANDT
  • VBPA.LIFNR == LFA1.LIFNR
Client VBPA.MANDT == T000.MANDT
Partner function - Document partner
  • Partner Function
  • Client
  • VBPA.PARVW == TPAR.PARVW
  • VBPA.MANDT == TPAR.MANDT