FKKSK_VATCS_ITM

Transparent Table Application Table
29 Fields 2 CDS Views

CA SK VAT Control Statement Items

FKKSK_VATCS_ITM is an SAP database table in S/4HANA. CA SK VAT Control Statement Items. It contains 29 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_SK_CAStRpCtrlStmntLogItem view_entity from BASIC SK VAT Control Statement Log Item
P_SK_CAStRpCtrlStmntLogItem view_entity from BASIC

Fields (29)

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 cadocumentnumber OPBEL_KK Document Number
KEY cadocumentitem OPUPK_KK Item
KEY billingitem POSNR_VF Item
KEY taxgroup FOT_ATR_TAX_GROUP Tax Group
KEY taxorigin FKKTAX_ORIGIN Tax Origin
KEY caorgdocumentnumber OPBEL_KK Document Number
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.

-- CA SK VAT Control Statement Items
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FKKSK_VATCS_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]
    CADOCUMENTNUMBER,        -- Document Number [OPBEL_KK]
    CADOCUMENTITEM,          -- Item [OPUPK_KK]
    BILLINGITEM,             -- Item [POSNR_VF]
    TAXGROUP,                -- Tax Group [FOT_ATR_TAX_GROUP]
    TAXORIGIN,               -- Tax Origin [FKKTAX_ORIGIN]
    CAORGDOCUMENTNUMBER,     -- Document Number [OPBEL_KK]
    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, CADOCUMENTNUMBER, CADOCUMENTITEM, BILLINGITEM, TAXGROUP, TAXORIGIN, CAORGDOCUMENTNUMBER)
);

Learn More