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)
);