P_CnsldtnUnitOverview

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 P_CnsldtnUnitOverview.
-- 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.
-- SQL view name: PCSCUOVERVIEW

CREATE VIEW P_CnsldtnUnitOverview AS
SELECT
  _CnsldtnUnit.ConsolidationDimension AS ConsolidationDimension,
  _CnsldtnUnit.ConsolidationUnit AS ConsolidationUnit,
  _ConsolidationVersion.ConsolidationVersion AS ConsolidationVersion,
  _ConsolidationVersion.CnsldtnUnitAttributeVersion AS CnsldtnUnitAttributeVersion,
  _CnsldtnUnit.Country AS Country,
  _CnsldtnUnit.ConsolidationUnitLink AS ConsolidationUnitLink,
  _CnsldtnUnit.ConsolidationUnitLinkLabel AS ConsolidationUnitLinkLabel,
  _CnsldtnUnitByTime.Company AS Company,
  _CnsldtnUnitByTime.ConsolidationUnitLocalCurrency AS ConsolidationUnitLocalCurrency,
  cast ( coalesce( _CnsldtnUnitByTimeVersion.DocumentEntryIsInGroupCurrency, '' ) as fincs_gcind preserving type ) AS DocumentEntryIsInGroupCurrency,
  cast ( coalesce( _CnsldtnUnitByTimeVersion.CnsldtnUnitLocalCrcySource, '' ) as fincs_local_curr_source preserving type ) AS CnsldtnUnitLocalCrcySource,
  cast ( coalesce( _CnsldtnUnitByTimeVersion.CnsldtnUnitGroupCrcySource, '' ) as fincs_group_curr_source preserving type ) AS CnsldtnUnitGroupCrcySource,
  cast ( coalesce( _CnsldtnUnitByTimeVersion.FiscalYearVariant, '' ) as fincs_bunit_periv preserving type ) AS FiscalYearVariant,
  cast ( coalesce( _CnsldtnUnitByTimeVersion.CnsldtnDataTransferMethod, '' ) as fincs_datatransfermethod preserving type ) AS CnsldtnDataTransferMethod,
  cast ( coalesce( _CnsldtnUnitByTimeVersion.CnsldtnUploadMethod, '' ) as fincs_upload_method preserving type ) AS CnsldtnUploadMethod,
  cast ( coalesce( _CnsldtnUnitByTimeVersion.CnsldtnCrcyTranslationMethod, '' ) as fincs_crcy_trnsltn_method preserving type ) AS CnsldtnCrcyTranslationMethod,
  cast ( coalesce( _CnsldtnUnitByTimeVersion.TaxRate, 0 ) as fc_taxrt preserving type ) AS TaxRate,
  cast ( coalesce( _CnsldtnUnitByTimeVersion.ConsolidationUnitIsPartnerOnly, '' ) as fincs_bunit_partner_only preserving type ) AS ConsolidationUnitIsPartnerOnly,
  cast ( coalesce( _CnsldtnUnitByTimeVersion.CnsldtnUnitDataCollection, '' ) as fincs_unitdatacollection preserving type ) AS CnsldtnUnitDataCollection,
  cast ( coalesce( _CnsldtnUnitByTimeVersion.ConsolidationUnitPartner, '' ) as fincs_unitpartner preserving type ) AS ConsolidationUnitPartner,
  cast ( coalesce( _CnsldtnUnitByTimeVersion.ConsolidationUnitPostingRule, '' ) as fincs_unitpostingrule preserving type ) AS ConsolidationUnitPostingRule,
  cast ( coalesce( _CnsldtnUnitByTimeVersion.ConsolidationUnitValidation, '' ) as fincs_unitvalidation preserving type ) AS ConsolidationUnitValidation,
  _CnsldtnAcctgIntegSetting.CnsldtnFrmYrForAcctgInteg AS CnsldtnFrmYrForAcctgInteg,
  cast( _CnsldtnUnitByTimeVersion.FromFiscalYearPeriod as fins_fyearperiod) AS FiscalYearPeriod
FROM I_CnsldtnUnit_3 AS _CnsldtnUnit
CROSS JOIN I_CnsldtnVersion AS _ConsolidationVersion
;