SAP Table VBPA stores Sales Document: Partnerdata

  

In this post, I will try and describe everything you need to know about the SAP vbpa table. What it is, including what type of data it stores.

A list of fields which make up the table structure and on an S/4Hana System for VBPA what does this table look like.

And what relationships it has with other SAP tables.

Also see here for example ABAP code to select data from VBPA....Right lets get started!


SAP VBPA dictionary attributes

Object Name: VBPA
Dictionary Type: Transparent table
Description: Sales Document: Partner


VBPA field list

Field Data Element Data Type length (Dec) Check table Description Conversion Routine Domain Name MemoryID AppClass SHLP SHLP Field ConvExit
MANDTMANDTCLNT3(0) T000ClientMANDTTEST
VBELNVBELNCHAR10(0) VBUKSales and Distribution Document NumberVBELNAUNV
POSNRPOSNRNUMC6(0) VBUPItem number of the SD documentPOSNRV
PARVWPARVWCHAR2(0) TPARPartner FunctionPARVWPARVP
KUNNRKUNNRCHAR10(0) KNA1Customer NumbersKUNNRKUNVC_KUNNRKUNNR
LIFNRLIFNRCHAR10(0) LFA1Account Number of Vendor or CreditorLIFNRLIFFBKRED_CLIFNR
PERNRPERNR_DNUMC8(0) Personnel NumberPERNRPERPB
PARNRPARNRNUMC10(0) Number of contact personPARNRVPAVP
ADRNRADRNRCHAR10(0) *AddressADRNRSAP
ABLADABLADCHAR25(0) Unloading PointTEXT25V
LAND1LAND1CHAR3(0) T005Country KeyLAND1LNDFB
ADRDAADRDACHAR1(0) Address indicatorADRDAVS
XCPDKXCPDKCHAR1(0) Indicator: Is the account a one-time account?XFELDFB
HITYPHITYP_KHCHAR1(0) THITCustomer hierarchy typeHITYP
PRFREPRFRECHAR1(0) Relevant for price determination IDXFELD
BOKREBOKRECHAR1(0) Indicator: Customer Is Rebate-RelevantXFELD
HISTUNRHISTUNRNUMC2(0) Level number within hierarchyNUM2
KNREFKNREFCHAR30(0) Customer description of partner (plant, storage location)KNREFKNREFVP
LZONELZONECHAR10(0) *Transportation zone to or from which the goods are deliveredZONEVV
HZUORHZUORNUMC2(0) Assignment to HierarchyHZUOR
STCEGSTCEGCHAR20(0) VAT Registration NumberSTCEGFB
PARVW_FFPARTNER_FFCHAR1(0) Indicator 'further partners in this function' (VBPA2)XFELD
ADRNPAD_PERSNUMCHAR10(0) ADRPPerson numberAD_PERSNUMCDTADDRESSPERSNUMBER
KALEKALECHAR1(0) Maintain appointments in calendarKALE