I_CnsldtnVersion

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_CnsldtnVersion.
-- 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_CnsldtnVersion AS
SELECT
  cast ( _tf200.rvers as fincs_consolidationversion preserving type ) AS ConsolidationVersion,
  cast ( _tf200.invvs as fincs_investmentversion preserving type ) AS ConsolidationInvestmentVersion,
  cast ( _tf200.strvs as fincs_structureversion preserving type ) AS ConsolidationStructureVersion,
  cast ( _tf200.inpvs as fincs_dataentryversion preserving type ) AS ConsolidationDataEntryVersion,
  cast ( _tf200.ldrvs as fincs_ledgerversion preserving type ) AS ConsolidationLedgerVersion,
  cast ( _tf200.taxvs as fincs_taxrateversion preserving type ) AS ConsolidationTaxRateVersion,
  cast ( _tf200.rrlvs as fincs_reportingruleversion preserving type ) AS ConsolidationReportingRuleVers,
  cast ( _tf200.iatvs as fincs_fsitemattributeversion preserving type ) AS CnsldtnFSItemAttributeVersion,
  cast ( _tf200.cuavs as fincs_cnsldtnunitattributevers preserving type ) AS CnsldtnUnitAttributeVersion,
  cast ( _tf200.impvs as fincs_fsitemmappingversion preserving type ) AS FSItemMappingVersion,
  cast ( _tf200.planvers as fincs_isplanningversion preserving type ) AS CnsldtnIsPlanVersion,
  cast ( _tf200.rldnr_cons as fincs_consolidationledger preserving type ) AS ConsolidationLedger,
  cast ( _tf200.group_curr as fincs_md_groupcurrency preserving type ) AS GroupCurrency,
  cast ( _tf200.rldnr_source as fincs_sourceledger preserving type ) AS CnsldtnSourceLedger,
  cast ( _tf200.ext_version_type as fincs_cnsldtnversiontype preserving type ) AS CnsldtnVersionType,
  cast ( _tf200.ref_version as fincs_cnsldtnreferenceversion preserving type ) AS CnsldtnReferenceVersion,
  cast ( _tf200.rldnr_source_acc_int as fincs_rldnr_source_acc_int preserving type ) AS CnsldtnAccountingSourceLedger,
  cast ( _tf200.source_kf_gc as fincs_group_curr_source preserving type ) AS CnsldtnVersionGroupCrcySource,
  cast ( _tf200.category_src as fincs_category_src preserving type ) AS CnsldtnSourcePlanCategory,
  cast ( _tf200.exec_mode as fincs_versionrunmode preserving type ) AS CnsldtnVersionRunMode,
  cast ( _tf200.ext_vers_all_kf as fincs_versionhasallkeyfigures preserving type ) AS CnsldtnVersionHasAllKeyFigures,
  cast ( _tf200.source_kf_lc as fincs_local_curr_source preserving type ) AS CnsldtnVersionLocalCrcySource,
  cast ( _tf200.source_kf_qty as fincs_quantity_source preserving type ) AS CnsldtnVersionQuantitySource,
  cast ( _tf200.fixvs as fincs_selectedfsitemsversion preserving type ) AS CnsldtnSelectedFSItemsVersion,
  cast ( _tf200.rclvs as fincs_reclassificationversion preserving type ) AS CnsldtnReclassificationVersion
FROM tf200 AS _tf200
LEFT OUTER JOIN I_CnsldtnVersionT AS _Text ON ConsolidationVersion = _Text.ConsolidationVersion  -- association [0..*]
;