FIILF6111_LOG

Transparent Table Application Table

Form 6111 - Log table for DRC runs

FIILF6111_LOG is an SAP database table in S/4HANA. Form 6111 - Log table for DRC runs. It contains 18 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_IL_StRpForm6111Log view_entity from BASIC IL Statutory Report Form 6111 Log

Fields (18)

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 file_no /atl/file_no File Number
KEY reporting_year fiilf6111_reporting_year Reporting Year
KEY f6111_code /atl/code_6111 6111 Code
KEY fin_stmnt_hierarchy hryid Hierarchy ID
KEY comapny_code bukrs Company Code
KEY glaccount racct Account Number
calculated_code fiilf6111_calc_code_flag Calculated Code Flag
manual_entry fiilf6111_manual_entry_flag Manual Entry Flag
code_has_value fiilf6111_code_has_value Code has Value
f6111_section fiilf6111_section Section
f6111_sub_section fiilf6111_subsection Subsection
amount fiilf6111_amount Amount
currency fiilf6111_currency Currency
overriden_amount fiilf6111_overridden_amount Overridden Amount

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.

-- Form 6111 - Log table for DRC runs
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FIILF6111_LOG (
    MANDT,                -- Client [mandt]
    STATRYRPTGENTITY,     -- Reporting Entity [srf_reporting_entity]
    STATRYRPTCATEGORY,    -- Report ID [srf_rep_cat_id]
    STATRYRPTRUNID,       -- Report Run ID [srf_report_run_id]
    FILE_NO,              -- File Number [/atl/file_no]
    REPORTING_YEAR,       -- Reporting Year [fiilf6111_reporting_year]
    F6111_CODE,           -- 6111 Code [/atl/code_6111]
    FIN_STMNT_HIERARCHY,  -- Hierarchy ID [hryid]
    COMAPNY_CODE,         -- Company Code [bukrs]
    GLACCOUNT,            -- Account Number [racct]
    CALCULATED_CODE,      -- Calculated Code Flag [fiilf6111_calc_code_flag]
    MANUAL_ENTRY,         -- Manual Entry Flag [fiilf6111_manual_entry_flag]
    CODE_HAS_VALUE,       -- Code has Value [fiilf6111_code_has_value]
    F6111_SECTION,        -- Section [fiilf6111_section]
    F6111_SUB_SECTION,    -- Subsection [fiilf6111_subsection]
    AMOUNT,               -- Amount [fiilf6111_amount]
    CURRENCY,             -- Currency [fiilf6111_currency]
    OVERRIDEN_AMOUNT,     -- Overridden Amount [fiilf6111_overridden_amount]
    PRIMARY KEY (MANDT, STATRYRPTGENTITY, STATRYRPTCATEGORY, STATRYRPTRUNID, FILE_NO, REPORTING_YEAR, F6111_CODE, FIN_STMNT_HIERARCHY, COMAPNY_CODE, GLACCOUNT)
);