VBPA

Transparent Table Application Table
29 Fields 25 CDS Views

Sales Document: Partner

VBPA is an SAP database table in S/4HANA. Sales Document: Partner. It contains 29 fields. 25 CDS views read from this table.

CDS Views using this table (25)

ViewTypeJoinVDMDescription
arun_i_so_reqmt view left_outer Sales Order selection in Normal mode
ARUN_I_SO_REQMT_PREV view left_outer Sales Order selection from Preview table
Arun_So_Reqmt view left_outer Sales Order Requirement
E_SDDocumentPartner view from EXTENSION Extension View for VBPA
FISTRPGSTR1ITEM view left_outer
I_RDPSlsDocCompletePartner view from BASIC
I_TripSalesContractVH view left_outer BASIC Value Help for Sales Contract
P_CL_SDM_SD_VBPA_2 view from BASIC
P_CL_SDM_SD_VBPA_3 view from BASIC
P_CL_SDM_SD_VBPA_4 view from BASIC
P_SDDocumentCompletePartners_1 view from BASIC
P_SDDocumentCompletePartners_2 view from BASIC
P_SustSlsDocCompletePartner view_entity from CONSUMPTION
rfm_psst_so_redet view inner PSST - SO redetermination
RFM_SD_ITEM_PARTNER_BASIC view from Item Partner Details for Sales Documents
RFM_SD_ITM_HDR_PATNR_BASIC view left_outer Salesdoc items mapped to HDR Partnr det
v_sd_ci_item_party view left_outer
v_sd_ci_party view from
v_vapma view left_outer
v_vlpma view left_outer
V_WB2_VBRK_VBRP_4 view left_outer Business Volume from Billing Document for Royalties
V_WB2_VBRK_VBRP_5 view left_outer Business Volume from Billing Document for Commission
V_WB2_VBRK_VBRP_7 view left_outer Business Volume from Billing Doc for Commission - Cleared A/R
V_WB2_VBRK_VBRP_8 view_entity left_outer BusVol Bill Docs Personnel Commission
V_WB2_VBRK_VBRP_9 view_entity left_outer BusVol BillDocs Personnel Comm-Cleared

Fields (29)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY vbeln vbeln SD Document
KEY posnr posnr Item
KEY parvw parvw Partner Functn
kunnr kunnr Customer
lifnr lifnr Supplier
pernr pernr_d Personnel No.
parnr parnr Contact Person
adrnr ad_addrnum Address Number
ablad ablad Unloading Point
land1 land1 Country/Reg.
adrda adrda Adress ind.
xcpdk xcpdk One-time acct
hityp hityp_kh Hierarchy type
prfre prfre Price determin.
bokre bokre Rebate
histunr histunr Hierarchy level
knref knref Partner desc.
lzone lzone Transport Zone
hzuor hzuor Hier.assignment
stceg stceg VAT Reg. No.
parvw_ff partner_ff F.partners
adrnp ad_persnum Person Number
kale kale Appointments
_dataaging data_temperature Data Aging
assigned_bp bu_partner Busn. Partner
addr_operation sd_addr_operation Address Detn
addr_type ad_adrtype Address Type
bp_ref_adrnr sdpd_bp_ref_addrnum BP Ref. Address Num.

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Sales Document: Partner
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VBPA (
    MANDT,           -- Client [mandt]
    VBELN,           -- SD Document [vbeln]
    POSNR,           -- Item [posnr]
    PARVW,           -- Partner Functn [parvw]
    KUNNR,           -- Customer [kunnr]
    LIFNR,           -- Supplier [lifnr]
    PERNR,           -- Personnel No. [pernr_d]
    PARNR,           -- Contact Person [parnr]
    ADRNR,           -- Address Number [ad_addrnum]
    ABLAD,           -- Unloading Point [ablad]
    LAND1,           -- Country/Reg. [land1]
    ADRDA,           -- Adress ind. [adrda]
    XCPDK,           -- One-time acct [xcpdk]
    HITYP,           -- Hierarchy type [hityp_kh]
    PRFRE,           -- Price determin. [prfre]
    BOKRE,           -- Rebate [bokre]
    HISTUNR,         -- Hierarchy level [histunr]
    KNREF,           -- Partner desc. [knref]
    LZONE,           -- Transport Zone [lzone]
    HZUOR,           -- Hier.assignment [hzuor]
    STCEG,           -- VAT Reg. No. [stceg]
    PARVW_FF,        -- F.partners [partner_ff]
    ADRNP,           -- Person Number [ad_persnum]
    KALE,            -- Appointments [kale]
    _DATAAGING,      -- Data Aging [data_temperature]
    ASSIGNED_BP,     -- Busn. Partner [bu_partner]
    ADDR_OPERATION,  -- Address Detn [sd_addr_operation]
    ADDR_TYPE,       -- Address Type [ad_adrtype]
    BP_REF_ADRNR,    -- BP Ref. Address Num. [sdpd_bp_ref_addrnum]
    PRIMARY KEY (MANDT, VBELN, POSNR, PARVW)
);

Learn More