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