VGTAXGR

Transparent Table Customizing Table
13 Fields 2 CDS Views

Tax Groups Definition

VGTAXGR is an SAP database table in S/4HANA. Tax Groups Definition. It contains 13 fields. 2 CDS views read from this table.

CDS Views using this table (2)

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

Fields (13)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY land1 land1 Country/Reg.
KEY fdate fotfdate From Date
KEY tbstyp tbstype Tax Box Str. Type
KEY acr_tg taxgrp Tax Group
KEY mwskz mwskz Tax Code
KEY ktosl ktosl Transaction
KEY shkzg_umsv shkzg_umsv Tot./Deb./Cred.
KEY blart blart Document Type
KEY umskz umskz Special G/L Ind
KEY ktokk ktokk Account group
kbetr vgkbetr Percentage
opera oper_type Arithmet. Oper.

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 Groups Definition
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VGTAXGR (
    MANDT,       -- Client [mandt]
    LAND1,       -- Country/Reg. [land1]
    FDATE,       -- From Date [fotfdate]
    TBSTYP,      -- Tax Box Str. Type [tbstype]
    ACR_TG,      -- Tax Group [taxgrp]
    MWSKZ,       -- Tax Code [mwskz]
    KTOSL,       -- Transaction [ktosl]
    SHKZG_UMSV,  -- Tot./Deb./Cred. [shkzg_umsv]
    BLART,       -- Document Type [blart]
    UMSKZ,       -- Special G/L Ind [umskz]
    KTOKK,       -- Account group [ktokk]
    KBETR,       -- Percentage [vgkbetr]
    OPERA,       -- Arithmet. Oper. [oper_type]
    PRIMARY KEY (MANDT, LAND1, FDATE, TBSTYP, ACR_TG, MWSKZ, KTOSL, SHKZG_UMSV, BLART, UMSKZ, KTOKK)
);

Learn More