VGTAXGR

Transparent Table Customizing Table
14 Fields 2 CDS Views

Tax Groups Definition

VGTAXGR is an SAP database table in S/4HANA. Tax Groups Definition. It contains 14 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 (14)

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.
fc_code ID_FC_CODE FC Code

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]
    FC_CODE,     -- FC Code [ID_FC_CODE]
    PRIMARY KEY (MANDT, LAND1, FDATE, TBSTYP, ACR_TG, MWSKZ, KTOSL, SHKZG_UMSV, BLART, UMSKZ, KTOKK)
);

Learn More