FISKVATC_ITM

Transparent Table Application Table
28 Fields 1 CDS Views

VAT Control Statement Items

FISKVATC_ITM is an SAP database table in S/4HANA. VAT Control Statement Items. It contains 28 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_SK_StRpCtrlStmntTaxItem view from BASIC SK VAT Control Statement Tax Item

Fields (28)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY statryrptgentity srf_reporting_entity Reporting Entity
KEY statryrptcategory srf_rep_cat_id Report ID
KEY statryrptrunid srf_report_run_id Report Run ID
KEY companycode bukrs Company Code
KEY accountingdocument belnr_d Document Number
KEY fiscalyear gjahr Fiscal Year
KEY taxitem buzei Item
KEY billingdocumentitem fins_cfin_av_billing_doc_item Central Finance Billing Document Item
taxgroup fot_atr_tax_group Tax Group
vatregistration stceg VAT Reg. No.
invoicenumber fisk_doc_num Invoice Number
referenceinvoicenumber fisk_ref_doc_num Original Invoice
taxreportingdate vatdate Tax Reporting Date
taxfulfillmentdate fot_fulfilldate Tax Fulfill. Date
taxrate figen_tax_rate Tax Rate
taxbaseamount glo_taxbase_amount_rptg_crcy TaxBaseAmtInRptgCrcy
taxamount glo_tax_amount_rptg_crcy Tax Amt in Rptg Crcy
deducttaxamount figen_ded_inptx_amt Deductible Input Tax In Rptg Crcy
currency waers Currency
controlcode steuc Control Code
billingquantity fklmg Bill.Qty in SKU
baseunit meins Base Unit
baddebtrelief fisk_acr_bad_debt_relief Bad Debt Relief
downpaymentstatus fisk_dp_status DP Status
xreversing fins_xreversing Is Reversing
xreversed fins_xreversed Is Reversed
_dataaging data_temperature Data Aging

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.

-- VAT Control Statement Items
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FISKVATC_ITM (
    MANDT,                   -- Client [mandt]
    STATRYRPTGENTITY,        -- Reporting Entity [srf_reporting_entity]
    STATRYRPTCATEGORY,       -- Report ID [srf_rep_cat_id]
    STATRYRPTRUNID,          -- Report Run ID [srf_report_run_id]
    COMPANYCODE,             -- Company Code [bukrs]
    ACCOUNTINGDOCUMENT,      -- Document Number [belnr_d]
    FISCALYEAR,              -- Fiscal Year [gjahr]
    TAXITEM,                 -- Item [buzei]
    BILLINGDOCUMENTITEM,     -- Central Finance Billing Document Item [fins_cfin_av_billing_doc_item]
    TAXGROUP,                -- Tax Group [fot_atr_tax_group]
    VATREGISTRATION,         -- VAT Reg. No. [stceg]
    INVOICENUMBER,           -- Invoice Number [fisk_doc_num]
    REFERENCEINVOICENUMBER,  -- Original Invoice [fisk_ref_doc_num]
    TAXREPORTINGDATE,        -- Tax Reporting Date [vatdate]
    TAXFULFILLMENTDATE,      -- Tax Fulfill. Date [fot_fulfilldate]
    TAXRATE,                 -- Tax Rate [figen_tax_rate]
    TAXBASEAMOUNT,           -- TaxBaseAmtInRptgCrcy [glo_taxbase_amount_rptg_crcy]
    TAXAMOUNT,               -- Tax Amt in Rptg Crcy [glo_tax_amount_rptg_crcy]
    DEDUCTTAXAMOUNT,         -- Deductible Input Tax In Rptg Crcy [figen_ded_inptx_amt]
    CURRENCY,                -- Currency [waers]
    CONTROLCODE,             -- Control Code [steuc]
    BILLINGQUANTITY,         -- Bill.Qty in SKU [fklmg]
    BASEUNIT,                -- Base Unit [meins]
    BADDEBTRELIEF,           -- Bad Debt Relief [fisk_acr_bad_debt_relief]
    DOWNPAYMENTSTATUS,       -- DP Status [fisk_dp_status]
    XREVERSING,              -- Is Reversing [fins_xreversing]
    XREVERSED,               -- Is Reversed [fins_xreversed]
    _DATAAGING,              -- Data Aging [data_temperature]
    PRIMARY KEY (MANDT, STATRYRPTGENTITY, STATRYRPTCATEGORY, STATRYRPTRUNID, COMPANYCODE, ACCOUNTINGDOCUMENT, FISCALYEAR, TAXITEM, BILLINGDOCUMENTITEM)
);

Learn More