VBPA2

Transparent Table Application Table

Sales document: Partner (used several times)

VBPA2 is an SAP database table in S/4HANA. Sales document: Partner (used several times). It contains 18 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_SlsContrAddlCompletePartners view from BASIC SD Document Additional Complete Partners

Fields (18)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY vbeln VBELN SD Document
KEY posnr POSNR Item
KEY parvw PARVW_4 Partner funct.
KEY cntpa CNT_PARVW Counter
partner PARTNER_VB Partners
uepar UEPAR_VB Higher partner
adrnr ADRNR Address
adrnp AD_PERSNUM Person Number
adrda ADRDA Adress ind.
knref KNREF Partner desc.
cntpa_max CNT_PARVW Counter
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 (used several times)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VBPA2 (
    MANDT,           -- Client [MANDT]
    VBELN,           -- SD Document [VBELN]
    POSNR,           -- Item [POSNR]
    PARVW,           -- Partner funct. [PARVW_4]
    CNTPA,           -- Counter [CNT_PARVW]
    PARTNER,         -- Partners [PARTNER_VB]
    UEPAR,           -- Higher partner [UEPAR_VB]
    ADRNR,           -- Address [ADRNR]
    ADRNP,           -- Person Number [AD_PERSNUM]
    ADRDA,           -- Adress ind. [ADRDA]
    KNREF,           -- Partner desc. [KNREF]
    CNTPA_MAX,       -- Counter [CNT_PARVW]
    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, CNTPA)
);