I_CnsldtnUnitByTimeVersion

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_CnsldtnUnitByTimeVersion.
-- 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_CnsldtnUnitByTimeVersion AS
SELECT
  bunit AS ConsolidationUnit,
  cuavs AS CnsldtnUnitAttributeVersion,
  cast (fromyearper as fincs_fsi_fiscalyearper_from preserving type) AS FromFiscalYearPeriod,
  cast (toyearper as fincs_fsi_fiscalyearper_to preserving type) AS ToFiscalYearPeriod,
  dimen AS ConsolidationDimension,
  local_curr_source AS CnsldtnUnitLocalCrcySource,
  group_curr_source AS CnsldtnUnitGroupCrcySource,
  cast ( periv as fincs_bunit_periv preserving type ) AS FiscalYearVariant,
  trans AS CnsldtnDataTransferMethod,
  cast ( upmeth as fincs_upload_method preserving type ) AS CnsldtnUploadMethod,
  cast ( ctrgr as fincs_crcy_trnsltn_method preserving type ) AS CnsldtnCrcyTranslationMethod,
  taxrt AS TaxRate,
  cast ( gcind as fincs_gcind preserving type ) AS DocumentEntryIsInGroupCurrency,
  is_partner_only AS ConsolidationUnitIsPartnerOnly,
  sa_data_collection AS CnsldtnUnitDataCollection,
  sa_partner AS ConsolidationUnitPartner,
  sa_posting_rule AS ConsolidationUnitPostingRule,
  sa_validation AS ConsolidationUnitValidation
FROM fincs_bunit_atvd
LEFT OUTER JOIN I_CnsldtnUnitCurrencySource AS _LocalCurrencySource ON CnsldtnUnitLocalCrcySource = _LocalCurrencySource.CnsldtnUnitCurrencySource  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnUnitCurrencySource AS _GroupCurrencySource ON CnsldtnUnitGroupCrcySource = _GroupCurrencySource.CnsldtnUnitCurrencySource  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnDimension AS _CnsldtnDimension ON ConsolidationDimension = _CnsldtnDimension.ConsolidationDimension  -- association [1..1]
LEFT OUTER JOIN I_CnsldtnUnit_3 AS _CnsldtnUnit ON ConsolidationUnit = _CnsldtnUnit.ConsolidationUnit  -- association [1..1]
LEFT OUTER JOIN I_CnsldtnUnitIntegration AS _DataTransferMethod ON CnsldtnDataTransferMethod = _DataTransferMethod.CnsldtnDataTransferMethod  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearVariant AS _FiscalYearVariant ON FiscalYearVariant = _FiscalYearVariant.FiscalYearVariant  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnCrcyTrnsltnMethod AS _CnsldtnCrcyTrnsltnMethod ON CnsldtnCrcyTranslationMethod = _CnsldtnCrcyTrnsltnMethod.CnsldtnCrcyTranslationMethod  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnRptdFinDataUpldMeth AS _CnsldtnRptdFinDataUpldMeth ON CnsldtnUploadMethod = _CnsldtnRptdFinDataUpldMeth.CnsldtnRptdFinDataUploadMethod  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnUnitDataColl AS _CnsldtnUnitDataColl ON CnsldtnUnitDataCollection = _CnsldtnUnitDataColl.CnsldtnUnitDataCollection  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnUnitPartner AS _CnsldtnUnitPartner ON ConsolidationUnitPartner = _CnsldtnUnitPartner.ConsolidationUnitPartner  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnUnitPostingRule AS _CnsldtnUnitPostingRule ON ConsolidationUnitPostingRule = _CnsldtnUnitPostingRule.ConsolidationUnitPostingRule  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnUnitValidation AS _CnsldtnUnitValidation ON ConsolidationUnitValidation = _CnsldtnUnitValidation.ConsolidationUnitValidation  -- association [0..1]
;