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