C_CnsldtnMDUpldUnitWrkArea

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 C_CnsldtnMDUpldUnitWrkArea.
-- 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: CCSMDBUNITWA

CREATE VIEW C_CnsldtnMDUpldUnitWrkArea AS
SELECT
  _WorkArea.CnsldtnMDUpldRecdUUID AS CnsldtnMDUpldRecdUUID,
  _WorkArea.CnsldtnMDUpldRecdStatus AS CnsldtnMDUpldRecdStatus,
  _MDUpldRecdStatus._Text[1: Language=$session.system_language].CnsldtnMDUpldRecdStatusText AS CnsldtnMDUpldRecdStatusText,
  _WorkArea.ConsolidationUnit AS ConsolidationUnit,
  _WorkArea.Language AS Language,
  _WorkArea.ConsolidationUnitText AS ConsolidationUnitText,
  _WorkArea.ConsolidationUnitMdmText AS ConsolidationUnitMdmText,
  _WorkArea.Country AS Country,
  _Country.Description AS CountryName,
  _WorkArea.ConsolidationVersion AS ConsolidationVersion,
  _WorkArea.CnsldtnDataTransferMethod AS CnsldtnDataTransferMethod,
  _DataTransferMethods.CnsldtnDataTransferMethodText AS CnsldtnDataTransferMethodText,
  _Companies.Company AS Company,
  _Company.CompanyName AS CompanyName,
  _WorkArea.CnsldtnReadFrmUnivJrnlEffctvYr AS CnsldtnReadFrmUnivJrnlEffctvYr,
  _WorkArea.CnsldtnUploadMethod AS CnsldtnUploadMethod,
  _CnsldtnRptdFinDataUpldMeth.CnsldtnRptdFinDataUpldMethText AS CnsldtnUploadMethodText,
  _WorkArea.FiscalYearPeriod AS FiscalYearPeriod,
  _WorkArea.ConsolidationUnitLocalCurrency AS ConsolidationUnitLocalCurrency,
  _Currency.CurrencyName AS CurrencyName,
  _WorkArea.CnsldtnCrcyTranslationMethod AS CnsldtnCrcyTranslationMethod,
  cast( _CnsldtnCrcyTrnsltnMethod.CnsldtnCrcyTrnsltnMethodText as fincs_crcy_trnsltn_method_text preserving type ) AS CnsldtnCrcyTrnsltnMethodText,
  _WorkArea.TaxRate AS TaxRate,
  _WorkArea.DocumentEntryIsInGroupCurrency AS DocumentEntryIsInGroupCurrency,
  _WorkArea.CnsldtnUnitSndrCrcyForLoclCrcy AS CnsldtnUnitSndrCrcyForLoclCrcy,
  _SndrCrcyForLocCrcies.CnsldtnSenderCurrencyText AS CnsldtnUnitSndrCrcyLoclCrcyTxt,
  _WorkArea.ConsolidationLedger AS ConsolidationLedger,
  _WorkArea.CnsldtnUnitSndrCrcyForGrpCrcy AS CnsldtnUnitSndrCrcyForGrpCrcy,
  _SndrCrcyForGrpCrcies.CnsldtnSenderCurrencyText AS CnsldtnUnitSndrCrcyGrpCrcyTxt,
  _WorkArea.FiscalYearVariant AS FiscalYearVariant,
  _FiscalYearVariant.FiscalYearVariantDescription AS FiscalYearVariantDescription,
  _WorkArea.CnsldtnMDUpldRecdStatusDetail AS CnsldtnMDUpldRecdStatusDetail,
  _WorkArea.ConsolidationDimension AS ConsolidationDimension
FROM I_CnsldtnMDUpldUnitWrkArea AS _WorkArea
LEFT OUTER JOIN I_Globalcompany AS _Companies ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN C_CnsldtnDataTransferMethodVH AS _DataTransferMethods ON CnsldtnDataTransferMethod = _DataTransferMethods.CnsldtnDataTransferMethod  -- association [0..1]
LEFT OUTER JOIN C_CnsldtnSenderCurrencyVH AS _SndrCrcyForGrpCrcies ON CnsldtnUnitSndrCrcyForGrpCrcy = _SndrCrcyForGrpCrcies.CnsldtnSenderCurrency  -- association [0..1]
LEFT OUTER JOIN C_CnsldtnSenderCurrencyVH AS _SndrCrcyForLocCrcies ON CnsldtnUnitSndrCrcyForLoclCrcy = _SndrCrcyForLocCrcies.CnsldtnSenderCurrency  -- association [0..1]
LEFT OUTER JOIN C_CnsldtnCrcyTrnsltnMethodVH AS _CnsldtnCrcyTrnsltnMethod ON CnsldtnCrcyTranslationMethod = _CnsldtnCrcyTrnsltnMethod.CnsldtnCrcyTranslationMethod  -- association [0..1]
LEFT OUTER JOIN C_CnsldtnRptdFinDataUpldMethVH AS _CnsldtnRptdFinDataUpldMeth ON CnsldtnUploadMethod = _CnsldtnRptdFinDataUpldMeth.CnsldtnRptdFinDataUploadMethod  -- association [0..1]
LEFT OUTER JOIN C_CnsldtnCurrencyVH AS _Currency ON ConsolidationUnitLocalCurrency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN C_CnsldtnCompanyVH AS _Company ON Company = _Company.Company  -- association [0..1]
LEFT OUTER JOIN C_CnsldtnFiscalYearVariantVH AS _FiscalYearVariant ON FiscalYearVariant = _FiscalYearVariant.FiscalYearVariant  -- association [0..1]
LEFT OUTER JOIN I_CountryVH AS _Country ON Country = _Country.Country  -- association [0..1]
;