I_IL_StRpForm6111Log

DDL: I_IL_STRPFORM6111LOG Type: view_entity BASIC Package: GLO_FIN_IS_IL_FORM6111
17 Fields 1 Data Sources

IL Statutory Report Form 6111 Log

I_IL_StRpForm6111Log is a Basic CDS View that provides data about "IL Statutory Report Form 6111 Log" in SAP S/4HANA. It reads from 1 data source (fiilf6111_log) and exposes 17 fields with key fields StatryRptgEntity, StatryRptCategory, StatryRptRunID, IL_TaxFileNumber, StatryRptgReportingYear. Part of development package GLO_FIN_IS_IL_FORM6111.

Data Sources (1)

SourceAliasJoin Type
fiilf6111_log fiilf6111_log from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label IL Statutory Report Form 6111 Log view
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY StatryRptgEntity statryrptgentity Reporting Entity
KEY StatryRptCategory statryrptcategory Report ID
KEY StatryRptRunID statryrptrunid Report Run ID
KEY IL_TaxFileNumber file_no File Number
KEY StatryRptgReportingYear reporting_year Year
KEY IL_Form6111Code f6111_code 6111 Code
KEY FinancialStatementHierarchy fin_stmnt_hierarchy Hierarchy ID
KEY CompanyCode comapny_code Company Code
KEY GLAccount glaccount General Ledger
IL_Form6111IsCalculatedCode calculated_code Calculated Code Flag
IL_Form6111EntryIsManual manual_entry Manual Entry Flag
IL_Form6111CodeHasValue code_has_value Code has Value
IL_Form6111Section f6111_section Section
IL_Form6111Subsection f6111_sub_section Subsection
YearlyBalAmtInDspCrcy amount Value Amount
Currency currency Valuation Crcy
IL_Form6111OverAmtInDspCrcy overriden_amount Overridden Amount

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_IL_StRpForm6111Log.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_IL_StRpForm6111Log AS
SELECT
  StatryRptgEntity,
  StatryRptCategory,
  StatryRptRunID,
  file_no AS IL_TaxFileNumber,
  reporting_year AS StatryRptgReportingYear,
  f6111_code AS IL_Form6111Code,
  fin_stmnt_hierarchy AS FinancialStatementHierarchy,
  comapny_code AS CompanyCode,
  GLAccount,
  calculated_code AS IL_Form6111IsCalculatedCode,
  manual_entry AS IL_Form6111EntryIsManual,
  code_has_value AS IL_Form6111CodeHasValue,
  f6111_section AS IL_Form6111Section,
  f6111_sub_section AS IL_Form6111Subsection,
  amount AS YearlyBalAmtInDspCrcy,
  Currency,
  overriden_amount AS IL_Form6111OverAmtInDspCrcy
FROM fiilf6111_log
;

Learn More