FIILF6111_LOG
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_IL_StRpForm6111Log | view_entity | from | BASIC | IL Statutory Report Form 6111 Log |
Fields (18)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA