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