FOT_DECLAR

Transparent Table Application Table
25 Fields 1 CDS Views

Account Tax Declaration

FOT_DECLAR is an SAP database table in S/4HANA. Account Tax Declaration. It contains 25 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_TaxDeclaration view_entity from BASIC Tax Declaration

Fields (25)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY uuid SYSUUID_C36 UUID
KEY bukrs BUKRS Company Code
KEY belnr BELNR_D Document Number
KEY gjahr GJAHR Fiscal Year
KEY tax_country FOT_TAX_COUNTRY Tax Ctry/Reg.
KEY mwskz MWSKZ Tax Code
KEY txdat_from FOT_TXDAT_FROM Tax Rate Valid-From
KEY ktosl KTOSL Transaction
KEY h_monat FOT_TAX_RECON_POSTING_PERIOD Period
dmbtr DMBTR Amount in LC
txbhw TXBHW Original Tax Base Amount
hwste HWSTE LC Tax
calculated abap.curr
subtotal abap.curr
h_hwaer HWAER Local Currency
kbetr KBETR_TAX Percent
h_blart BLART Document Type
h_bldat BLDAT Document Date
h_budat BUDAT Posting Date
zbd1p abap.dec
xmwsn XMWSN Net Tax Base
xskfn XSKFN Net Discount Base
land1 LAND Country/Region
kbetr_calc abap.dec

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.

-- Account Tax Declaration
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FOT_DECLAR (
    MANDT,        -- Client [MANDT]
    UUID,         -- UUID [SYSUUID_C36]
    BUKRS,        -- Company Code [BUKRS]
    BELNR,        -- Document Number [BELNR_D]
    GJAHR,        -- Fiscal Year [GJAHR]
    TAX_COUNTRY,  -- Tax Ctry/Reg. [FOT_TAX_COUNTRY]
    MWSKZ,        -- Tax Code [MWSKZ]
    TXDAT_FROM,   -- Tax Rate Valid-From [FOT_TXDAT_FROM]
    KTOSL,        -- Transaction [KTOSL]
    H_MONAT,      -- Period [FOT_TAX_RECON_POSTING_PERIOD]
    DMBTR,        -- Amount in LC [DMBTR]
    TXBHW,        -- Original Tax Base Amount [TXBHW]
    HWSTE,        -- LC Tax [HWSTE]
    CALCULATED,   -- abap.curr
    SUBTOTAL,     -- abap.curr
    H_HWAER,      -- Local Currency [HWAER]
    KBETR,        -- Percent [KBETR_TAX]
    H_BLART,      -- Document Type [BLART]
    H_BLDAT,      -- Document Date [BLDAT]
    H_BUDAT,      -- Posting Date [BUDAT]
    ZBD1P,        -- abap.dec
    XMWSN,        -- Net Tax Base [XMWSN]
    XSKFN,        -- Net Discount Base [XSKFN]
    LAND1,        -- Country/Region [LAND]
    KBETR_CALC,   -- abap.dec
    PRIMARY KEY (MANDT, UUID, BUKRS, BELNR, GJAHR, TAX_COUNTRY, MWSKZ, TXDAT_FROM, KTOSL, H_MONAT)
);

Learn More