VBPA3

Transparent Table Application Table

Tax Numbers for One-Time Customers

VBPA3 is an SAP database table in S/4HANA. Tax Numbers for One-Time Customers. It contains 15 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_OneTimeCustomerTaxNumber view from BASIC Tax Number for One Time Customer

Fields (15)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY vbeln vbeln SD Document
KEY posnr posnr Item
KEY parvw parvw Partner Functn
stcd1 stcd1 Tax Number 1
stcd2 stcd2 Tax Number 2
stcd3 stcd3 Tax Number 3
stcd4 stcd4 Tax Number 4
stcd5 stcd5 Tax Number 5
stkzn stkzn Natural person
stcdt j_1atoid Tax number type
j_1kfrepre repres Rep's Name
j_1kftbus gestyp Type of Business
j_1kftind indtyp Type of Industry
_dataaging data_temperature Data Aging

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.

-- Tax Numbers for One-Time Customers
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VBPA3 (
    MANDT,       -- Client [mandt]
    VBELN,       -- SD Document [vbeln]
    POSNR,       -- Item [posnr]
    PARVW,       -- Partner Functn [parvw]
    STCD1,       -- Tax Number 1 [stcd1]
    STCD2,       -- Tax Number 2 [stcd2]
    STCD3,       -- Tax Number 3 [stcd3]
    STCD4,       -- Tax Number 4 [stcd4]
    STCD5,       -- Tax Number 5 [stcd5]
    STKZN,       -- Natural person [stkzn]
    STCDT,       -- Tax number type [j_1atoid]
    J_1KFREPRE,  -- Rep's Name [repres]
    J_1KFTBUS,   -- Type of Business [gestyp]
    J_1KFTIND,   -- Type of Industry [indtyp]
    _DATAAGING,  -- Data Aging [data_temperature]
    PRIMARY KEY (MANDT, VBELN, POSNR, PARVW)
);