I_CnsldtnMDUpldUnitWrkArea_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 I_CnsldtnMDUpldUnitWrkArea_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: ICSMDBUNITWA2

CREATE VIEW I_CnsldtnMDUpldUnitWrkArea_2 AS
SELECT
  _WorkArea.uuid AS CnsldtnMDUpldRecdUUID,
  _WorkArea.status AS CnsldtnMDUpldRecdStatus,
  _WorkArea.status_detail AS CnsldtnMDUpldRecdStatusDetail,
  _WorkArea.rvers AS ConsolidationVersion,
  cast ( _WorkArea.bunit as fincs_consolidationunit preserving type ) AS ConsolidationUnit,
  cast ( _WorkArea.fiscyearper as fins_fyearperiod ) AS FiscalYearPeriod,
  _WorkArea.cntry AS Country,
  _WorkArea.link AS ConsolidationUnitLink,
  _WorkArea.linklabel AS ConsolidationUnitLinkLabel,
  _WorkArea.langu AS Language,
  _WorkArea.txtsh AS ConsolidationUnitText,
  _WorkArea.txtmi AS ConsolidationUnitMdmText,
  _WorkArea.txtlg AS ConsolidationUnitLongText,
  _WorkArea.curr AS ConsolidationUnitLocalCurrency,
  _WorkArea.rcomp AS Company,
  _WorkArea.local_curr_source AS CnsldtnUnitLocalCrcySource,
  _WorkArea.group_curr_source AS CnsldtnUnitGroupCrcySource,
  _WorkArea.periv AS FiscalYearVariant,
  _WorkArea.gcind AS DocumentEntryIsInGroupCurrency,
  _WorkArea.trans AS CnsldtnDataTransferMethod,
  _WorkArea.upmeth AS CnsldtnUploadMethod,
  _WorkArea.ctrgr AS CnsldtnCrcyTranslationMethod,
  _WorkArea.taxrt AS TaxRate,
  _WorkArea.is_partner_only AS ConsolidationUnitIsPartnerOnly,
  _WorkArea.sa_data_collection AS CnsldtnUnitDataCollection,
  _WorkArea.sa_partner AS ConsolidationUnitPartner,
  _WorkArea.sa_posting_rule AS ConsolidationUnitPostingRule,
  _WorkArea.sa_validation AS ConsolidationUnitValidation,
  cast ('Y1' as fc_dimen ) AS ConsolidationDimension
FROM fincs_bunit_wa_2 AS _WorkArea
LEFT OUTER JOIN I_CnsldtnMDUpldRecdStatus AS _MDUpldRecdStatus ON CnsldtnMDUpldRecdStatus = _MDUpldRecdStatus.CnsldtnMDUpldRecdStatus  -- association [0..1]
;