VGTBS

Transparent Table Customizing Table
5 Fields 4 CDS Views

Tax Box Structure

VGTBS is an SAP database table in S/4HANA. Tax Box Structure. It contains 5 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_SK_StRpCtrlStmntTaxGroup2 view inner BASIC SK VAT Control Statement Tax Group 2
I_TaxBoxStructure view from BASIC Tax Box Structure definition
P_TaxBoxStructureValidTo1 view from BASIC
P_TaxBoxStructureValidTo1 view left_outer BASIC

Fields (5)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY land1 land1 Country/Reg.
KEY fdate fotfdate From Date
KEY tbstype tbstype Tax Box Str. Type
tsxbstr taxbstr Tax Box Structure

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 Box Structure
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VGTBS (
    MANDT,    -- Client [mandt]
    LAND1,    -- Country/Reg. [land1]
    FDATE,    -- From Date [fotfdate]
    TBSTYPE,  -- Tax Box Str. Type [tbstype]
    TSXBSTR,  -- Tax Box Structure [taxbstr]
    PRIMARY KEY (MANDT, LAND1, FDATE, TBSTYPE)
);

Learn More