FINCS_MD_CONSUNIT_2

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 FINCS_MD_CONSUNIT_2.
-- 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: FINCSMDCONSUNIT2
-- Parameters: P_Language : spras

CREATE VIEW FINCS_MD_CONSUNIT_2 AS
SELECT
  ConsolidationDimension,
  ConsolidationUnit,
  ConsolidationVersion,
  cast( FromFiscalYearPeriod as jahrper ) AS FromFiscalYearPeriod,
  cast( ToFiscalYearPeriod as jahrper ) AS ToFiscalYearPeriod,
  $parameters.P_Language AS Language,
  _CnsldtnUnitText[1: Language=$parameters.P_Language].ConsolidationUnitText AS ConsolidationUnitText,
  _CnsldtnUnitText[1: Language=$parameters.P_Language].ConsolidationUnitMdmText AS ConsolidationUnitMdmText,
  _CnsldtnUnitText[1: Language=$parameters.P_Language].ConsolidationUnitLongText AS ConsolidationUnitLongText,
  Country,
  ConsolidationUnitLink,
  ConsolidationUnitLinkLabel,
  Company,
  ConsolidationUnitLocalCurrency,
  ConsolidationUnitIsPartnerOnly,
  CnsldtnUnitLocalCrcySource,
  CnsldtnUnitGroupCrcySource,
  FiscalYearVariant,
  CnsldtnDataTransferMethod,
  CnsldtnUploadMethod,
  CnsldtnCrcyTranslationMethod,
  TaxRate,
  DocumentEntryIsInGroupCurrency
FROM I_CnsldtnUnitOverview
LEFT OUTER JOIN C_CnsldtnUnitText AS _CnsldtnUnitText ON ConsolidationDimension = _CnsldtnUnitText.ConsolidationDimension AND ConsolidationUnit = _CnsldtnUnitText.ConsolidationUnit  -- association [0..*]
;