FOT_RECON

Transparent Table Application Table
29 Fields 2 CDS Views

Account Tax Reconciliation

FOT_RECON is an SAP database table in S/4HANA. Account Tax Reconciliation. It contains 29 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_TaxReconciliation view_entity from BASIC Tax Reconciliation
P_Fot_Declar view_entity from BASIC Basic View of Table FOT_DECLAR

Fields (29)

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 mwskz mwskz Tax Code
KEY tax_country fot_tax_country Tax Ctry/Reg.
KEY txdat_from fot_txdat_from Tax Rate Valid-From
KEY buzei buzei Item
KEY ktosl ktosl Transaction
dmbtr dmbtr Amount in LC
txbhw txbhw Original Tax Base Amount
hwbas hwbas LC Base
calculated abap.curr
subtotal abap.curr
posted abap.dec
hwste hwste LC Tax
kbetr kbetr_tax Percent
hkont hkont G/L Acct
lokkt altkt_skb1 Altern. Account
altkt bilkt_ska1 Group Account Number
prctr prctr Profit Center
bupla bupla Business place
h_monat monat Period
h_blart blart Document Type
h_budat budat Posting Date
h_bldat bldat Document Date
h_hwaer hwaer Local Currency
zbd1p dzbd1p CD Percentage 1

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 Reconciliation
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FOT_RECON (
    MANDT,        -- Client [mandt]
    UUID,         -- UUID [sysuuid_c36]
    BUKRS,        -- Company Code [bukrs]
    BELNR,        -- Document Number [belnr_d]
    GJAHR,        -- Fiscal Year [gjahr]
    MWSKZ,        -- Tax Code [mwskz]
    TAX_COUNTRY,  -- Tax Ctry/Reg. [fot_tax_country]
    TXDAT_FROM,   -- Tax Rate Valid-From [fot_txdat_from]
    BUZEI,        -- Item [buzei]
    KTOSL,        -- Transaction [ktosl]
    DMBTR,        -- Amount in LC [dmbtr]
    TXBHW,        -- Original Tax Base Amount [txbhw]
    HWBAS,        -- LC Base [hwbas]
    CALCULATED,   -- abap.curr
    SUBTOTAL,     -- abap.curr
    POSTED,       -- abap.dec
    HWSTE,        -- LC Tax [hwste]
    KBETR,        -- Percent [kbetr_tax]
    HKONT,        -- G/L Acct [hkont]
    LOKKT,        -- Altern. Account [altkt_skb1]
    ALTKT,        -- Group Account Number [bilkt_ska1]
    PRCTR,        -- Profit Center [prctr]
    BUPLA,        -- Business place [bupla]
    H_MONAT,      -- Period [monat]
    H_BLART,      -- Document Type [blart]
    H_BUDAT,      -- Posting Date [budat]
    H_BLDAT,      -- Document Date [bldat]
    H_HWAER,      -- Local Currency [hwaer]
    ZBD1P,        -- CD Percentage 1 [dzbd1p]
    PRIMARY KEY (MANDT, UUID, BUKRS, BELNR, GJAHR, MWSKZ, TAX_COUNTRY, TXDAT_FROM, BUZEI, KTOSL)
);

Learn More