VBPA is a standard Basic Functions Transparent Table in SAP SD application, which stores Sales Document: Partner data. Below you can view the Table Structure, columns(fields), SAP Wiki pages, discussion threads, related TCodes, FMs, ABAP Reports, BW Datasources, and Authorization Objects for VBPA. You can use the transaction code SE16 to view the data in this table, and SE11 TCode for the table structure and definition.

VBPA — Meta Data

Description: Sales Document: Partner
Main Category: SD
Sub Category: Basic Functions
Table type: Transparent Table (TRANSP)

VBPA — Table Structure, Fields(Columns) and Definitions

    Position Column Name Description Primary Key Data Type Length Check Table
    1 MANDT Client X CLNT 3 T000
    2 VBELN Sales Document X CHAR 10
    3 POSNR Item X NUMC 6
    4 PARVW Partner function X CHAR 2 TPAR
    5 KUNNR Customer CHAR 10 KNA1
    6 LIFNR Vendor CHAR 10 LFA1
    7 PERNR Personnel No. NUMC 8
    8 PARNR Number of contact person NUMC 10
    9 ADRNR Address CHAR 10
    10 ABLAD Unloading Point CHAR 25
    11 LAND1 Country CHAR 3 T005
    12 ADRDA Address indicator CHAR 1
    13 XCPDK Indicator: Is the account a one-time account? CHAR 1
    14 HITYP Customer hierarchy type CHAR 1 THIT
    15 PRFRE Relevant for price determination ID CHAR 1
    16 BOKRE ID: Customer is to receive rebates CHAR 1
    17 HISTUNR Level number within hierarchy NUMC 2
    18 KNREF Customer description of partner (plant CHAR 30
    19 LZONE Transportation zone to or from which the goods are delivered CHAR 10
    20 HZUOR Assignment to Hierarchy NUMC 2
    21 STCEG VAT registration number CHAR 20
    22 PARVW_FF Indicator 'further partners in this function' (VBPA2) CHAR 1
    23 ADRNP Person number CHAR 10 ADRP
    24 KALE Maintain appointments in calendar CHAR 1
    25 _DATAAGING Data Filter Value for Data Aging DATS 8
    26 .INCLUDE 0
    27 DUMMY_SDDOCPARTNER_INCL_EEW_PS Dummy function in length 1 CHAR 1
    28 .INCLU--AP 0
    29 OIPBL Updated information in related user data field CHAR 10 OIFSPBL

SAP Help, Wiki Resources, and Forum Discussions on VBPA

Click the above link for the full list of resources and help pages, only the first few are posted below

  • Retrieve partner for each item in VBPA | SCN

    I explain : for each different partner (at item level), they only store one item in VBPA. It compress the data like they say in OSS note 380507.

    http://scn.sap.com/thread/659675

  • Enhance 2LIS_11_VAITM from VBPA possible? | SCN

    I need to Enhance this Std extractor 2LIS_11_VAITM from the table VBPA with the fileds KUNNR PERNR !

    http://scn.sap.com/thread/973386

  • LIS User Exit MCS10001 and VBPA table (Roberto N. read me!)

    How do you tackle the problem of adding custom fields to SD extractions when the fields do not have a before/after image?

    http://scn.sap.com/message/1666256

  • How to avoid XVBPA line item values while creating sales order

    I am creating Sales order using function module IDOC_INPUT_ORDERS, for that I am passing partner details through segment E1EDKA1.If I pass the same partner details(Partner number, name1,name4,city,postel code) which is same like customer master,

    http://scn.sap.com/message/10686616

  • VBPA | SCN

    Then it is maintained at header level.

    just check it. How many entries r u getting for particluar sales order.

    wat is the difference.

    Regards

    azad.

    http://scn.sap.com/message/3830975

  • How to add Z fields from VBPA in datasource 2LIS_11_VAITM in delta mode

    I'm looking for a method to add Z fields from VBPA (ie order reponsible , account manager , ..) in the datasource 2LIS_11_VAITM

    http://scn.sap.com/message/7872478

  • Delta for VBPA extractor | SCN

    I have a requirement to create an extractor for VBPA table and make it delta enabled. As there is no date field I tried the below three options which did not work.

    http://scn.sap.com/message/13826387

  • New ADRNR record in VBPA | SCN

    Can anyone tell me any BAPI if i want to create a new ADRNR in VBPA for a given VBELN,PARVW and KUNNR.(And simaltaneously a new record in ADRC should also be created.)

    http://scn.sap.com/message/683540

  • Relation Btw VBRK and VBPA and KNVH | SCN

    Select parameter fields are HKUNNER(KNVH), VBELN(VBRK) and WERKS(VBRP),KUNAG(VBRK)

    http://scn.sap.com/message/7161736

  • VBPA table not getting modified | SCN

    Dear Experts,

    I want to update table VBPA for sold to party and shift to party.

    I wrote the code as follows,

    SELECT SINGLE vbeln kunnr FROM vbak INTO wa_vbak

    WHERE vbeln EQ s_vbeln.

    IF sy-subrc NE 0.

    MESSAGE 'Sales Order Does Not Exists' TYPE 'E'.

    ELSE.

    SELECT SINGLE * FROM kna1 INTO WA_KNA1

    WHERE kunnr EQ p_kunnr...

    http://scn.sap.com/message/10540380

  • VBELN in VBPA in Sales Order Creation | SCN

    I have to change the Sales Order Customer Group Values with the Ship-To-Party Customer Group Values.

    http://scn.sap.com/message/3841634


Related Tables

TABLE Description Functional Area
VBAK Sales Document: Header Data SD - Sales
VBRK Billing Document: Header Data SD - Billing
VBRP Billing Document: Item Data SD - Billing
LIKP SD Document: Delivery Header Data Logistics Execution - Shipping
VBFA Sales Document Flow SD - Basic Functions
LIPS SD document: Delivery: Item data Logistics Execution - Shipping
VBKD Sales Document: Business Data SD - Sales

Transaction Codes for SAP Table VBPA

TCODE Description Functional Area
VBKD Bonus Buy: Condition Types SD - Free Goods
SPRO Customizing - Edit Project Basis - Customizing Project Management (IMG)
VA01 Create Sales Order SD - Sales
VA02 Change Sales Order SD - Sales
SE11 ABAP Dictionary Maintenance Basis - Dictionary Maintenance
SLIS FI-SL Spec.Purpose Ledg. Info.System FI - Information System
SE16 Data Browser Basis - Workbench Utilities
SE38 ABAP Editor Basis - ABAP Editor

FMs for SAP Table VBPA

FM Description Functional Area
REUSE_ALV_GRID_DISPLAY Output of a simple list (single-line) Basis - SAP List Viewer
REUSE_ALV_COMMENTARY_WRITE List body comment block output BC - SAP List Viewer
REUSE_ALV_EVENTS_GET Returns table of possible events for a list type BC - SAP List Viewer
REUSE_ALV_VARIANT_F4 Display variant selection dialog box BC - SAP List Viewer
REUSE_ALV_FIELDCATALOG_MERGE Create field catalog from dictionary structure or internal table BC - SAP List Viewer
REUSE_ALV_LIST_DISPLAY Output a simple list (single line or several lines) BC - SAP List Viewer
F4_FILENAME F4 for filename / Filemanager support to locate file in a directory PM - Plant Maintenance
READ_TEXT SAPscript: Read text BC - SAPscript

ABAP Reports for SAP Table VBPA

ABAP REPORT Description Functional Area
SAPMV45A Sales Order Processing SD - Sales
MV45AFZB User Exits SD - Material Maintenance
RVADTABL INCLUDE for General Table Descriptions for Print Programs SD - Output Determination
RVADOR01 Print Program for Sales Documents SD - Basic Functions
RSAP0001 Program for object type SAP0001 : BapiService Basis - BW Service API
SAPLV05I Updating Sales and Distribution Indices
RSCONN01 SAPconnect: Start Send Process Basis - Communication Services: Mail, Fax, SMS, Telephony
RVADOPFO INCLUDE for OPEN_FORM for SD Print Programs SD - Word Processing

BW Datasources for SAP Table VBPA

BW DATASOURCE Description Functional Area
2LIS_11_VAITM Sales Document Item Data SD - Sales and Distribution
2LIS_11_VAHDR Sales Document Header Data SD - Sales and Distribution
2LIS_13_VDITM Billing Document Item Data SD - Sales and Distribution
2LIS_13_VDKON Billing Document Condition SD - Sales and Distribution
2LIS_11_VASCL Sales Document Schedule Line SD - Sales and Distribution
2LIS_12_VCITM Delivery Item Data SD - Sales and Distribution
2LIS_03_BF Goods Movements From Inventory Management MM - Materials Management
2LIS_11_VAKON Sales Document Condition SD - Sales and Distribution

Authorization Objects for SAP Table VBPA

AUTHORIZATION OBJECT Description Functional Area
P_PERNR HR: Master Data - Personnel Number Check
V_VBAK_VKO Sales Document: Authorization for Sales Areas
S_TCODE Transaction Code Check at Transaction Start
M_MATE_WRK Material Master: Plants
S_CARRID Authorization Object for Airlines
I_FCODE WCM: Function Codes (e.g. Operational Cycle)
E_GRID Authorization Object for Grid

Most searched SAP Sales and Distribution Tables