I_OrglChgTransfPostgCube

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_OrglChgTransfPostgCube.
-- 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.
-- Parameters: P_OrganizationalChange : finoc_orgl_change, P_OrglChangeEffectiveDate : finoc_effective_date

CREATE VIEW I_OrglChgTransfPostgCube AS
SELECT
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  LedgerGLLineItem,
  Ledger,
  LedgerFiscalYear,
  _Ledger._Text[1: Language = $session.system_language].LedgerName AS LedgerName,
  cast( _CompanyCode.CompanyCodeName as fis_butxt preserving type ) AS CompanyCodeName,
  ChartOfAccounts,
  ControllingArea,
  cast( _ControllingArea.ControllingAreaName as fis_bezei preserving type ) AS ControllingAreaName,
  PrdcssrJournalEntryCompanyCode,
  PrdcssrJournalEntryFiscalYear,
  PredecessorJournalEntry,
  PredecessorJournalEntryItem,
  BusinessTransactionType,
  OrganizationalChange,
  OrglChangeEffectiveDate,
  GLAccount,
  cast( _GLAccountInChartOfAccounts._Text[1: Language = $session.system_language].GLAccountName as fis_txt20_skat ) AS GLAccountName,
  cast( _GLAccountInChartOfAccounts._Text[1: Language = $session.system_language].GLAccountLongName as fis_txt50_skat ) AS GLAccountLongName,
  CostCenter,
  cast( _CostCenter[1:ValidityStartDate <= $session.system_date and ValidityEndDate >= $session.system_date]._Text[1: Language = $session.system_language].CostCenterName as fis_kostl_name ) AS CostCenterName,
  ProfitCenter,
  _ProfitCenter[1:ValidityStartDate <= $session.system_date and ValidityEndDate >= $session.system_date]._Text[1: Language = $session.system_language].ProfitCenterName AS ProfitCenterName,
  FunctionalArea,
  cast( _FunctionalArea._Text[1: Language = $session.system_language].FunctionalAreaName as fis_funcarea_name ) AS FunctionalAreaName,
  Segment,
  _Segment._Text[1: Language = $session.system_language].SegmentName AS SegmentName,
  PartnerCostCenter,
  PartnerProfitCenter,
  PartnerFunctionalArea,
  PartnerCompany,
  TransactionCurrency,
  AmountInTransactionCurrency,
  CompanyCodeCurrency,
  AmountInCompanyCodeCurrency,
  GlobalCurrency,
  AmountInGlobalCurrency,
  FunctionalCurrency,
  AmountInFunctionalCurrency,
  FiscalPeriod,
  FiscalYearVariant,
  FiscalYearPeriod,
  PostingDate,
  Product,
  Customer,
  _Customer.CustomerName AS CustomerName,
  Supplier,
  _Supplier.SupplierName AS SupplierName,
  MasterFixedAsset,
  FixedAsset,
  PurchasingDocument,
  PurchasingDocumentItem,
  SalesDocument,
  SalesDocumentItem,
  ControllingDebitCreditCode,
  OriginProfitCenter,
  AccountAssignmentType,
  CostCtrActivityType,
  OrderID,
  WBSElementInternalID,
  PartnerWBSElementInternalID,
  cast( _PartnerWBSElementBasicData.WBSElementExternalID as fis_partner_wbsext_no_conv ) AS PartnerWBSElementExternalID,
  cast( _WBSElementBasicData.WBSElementExternalID as fis_wbsext_no_conv ) AS WBSElementExternalID,
  ProjectInternalID,
  PartnerProjectInternalID,
  cast( _ProjectBasicData.ProjectExternalID as fis_projectext_no_conv ) AS ProjectExternalID,
  cast( _PartnerProjectBasicData.ProjectExternalID as fis_part_projectext_no_conv ) AS PartnerProjectExternalID,
  PartnerCostCtrActivityType,
  PartnerOrder,
  PartnerOrder_2,
  SalesOrganization,
  DistributionChannel,
  OrganizationDivision,
  SoldProduct,
  SoldProductGroup,
  CustomerGroup,
  Plant,
  AssetClass,
  ServiceDocumentType,
  FinancialAccountType,
  BusinessArea,
  ValuationArea,
  ServiceDocument,
  AccountingDocumentType,
  _CalendarDate.CalendarYear AS CalendarYear,
  _CalendarDate.CalendarQuarter AS CalendarQuarter,
  _CalendarDate.YearQuarter AS CalendarYearQuarter,
  _CalendarDate.CalendarMonth AS CalendarMonth,
  _CalendarDate.YearMonth AS CalendarYearMonth,
  _CalendarDate.CalendarWeek AS CalendarWeek,
  _CalendarDate.YearWeek AS CalendarYearWeek,
  _OrglChgFiscalCalendarDate.FiscalQuarter AS FiscalQuarter,
  _OrglChgFiscalCalendarDate.FiscalWeek AS FiscalWeek,
  _OrglChgFiscalCalendarDate.FiscalYearQuarter AS FiscalYearQuarter,
  _OrglChgFiscalCalendarDate.FiscalYearWeek AS FiscalYearWeek,
  cast( _JournalEntry.SenderAccountingDocument as fis_belnr_sender ) AS SenderAccountingDocument,
  cast( _JournalEntry.SenderFiscalYear as gjahr_sender ) AS SenderFiscalYear,
  cast( _JournalEntry.SenderLogicalSystem as logsystem_sender ) AS SenderLogicalSystem,
  cast( _CostCtrActivityType[1:ValidityStartDate <= $session.system_date and ValidityEndDate >= $session.system_date]._Text[1: Language = $session.system_language].CostCtrActivityTypeName as fis_lstar_text ) AS CostCtrActivityTypeName,
  cast( _CustomerGroup._Text[1: Language = $session.system_language].CustomerGroupName as fis_customergroup_name ) AS CustomerGroupName,
  cast( _DistributionChannel._Text[1: Language = $session.system_language].DistributionChannelName as fis_distributionchannel_name ) AS DistributionChannelName,
  cast( _Division._Text[1: Language = $session.system_language].DivisionName as fis_division_name ) AS DivisionName,
  _Product._Text[1: Language = $session.system_language].ProductName AS ProductName,
  cast( _PartnerCompany[1: Language = $session.system_language].CompanyName as fis_rcomp_name ) AS PartnerCompanyName,
  cast( _PartnerCostCenter[1:ValidityStartDate <= $session.system_date and ValidityEndDate >= $session.system_date]._Text[1: Language = $session.system_language].CostCenterName as fis_partner_kostl_name) AS PartnerCostCenterName,
  cast( _PartnerCostCtrActivityType[1:ValidityStartDate <= $session.system_date and ValidityEndDate >= $session.system_date]._Text[1: Language = $session.system_language].CostCtrActivityTypeName as fis_partner_activity_type_name ) AS PartnerCostCtrActivityTypeName,
  cast( _PartnerFunctionalArea._Text[1: Language = $session.system_language].FunctionalAreaName as fis_partner_funcarea_name ) AS PartnerFunctionalAreaName,
  cast( _PartnerProfitCenter[1:ValidityStartDate <= $session.system_date and ValidityEndDate >= $session.system_date]._Text[1: Language = $session.system_language].ProfitCenterName as fis_partner_prctr_name ) AS PartnerProfitCenterName,
  cast( _PartnerProjectBasicData.ProjectDescription as fis_partner_project_descript ) AS PartnerProjectDescription,
  cast( _PartnerWBSElementBasicData.WBSDescription as fis_partner_wbs_descript ) AS PartnerWBSElementDescription,
  cast( _ProjectBasicData.ProjectDescription as fis_project_description ) AS ProjectDescription,
  cast( _SalesOrganization._Text[1: Language = $session.system_language].SalesOrganizationName as fis_sales_organization_name ) AS SalesOrganizationName,
  cast( _SoldProduct._Text[1: Language = $session.system_language].ProductName as fis_matnr_copa_name ) AS SoldProductName,
  _WBSElementBasicData.WBSDescription AS WBSElementDescription,
  GLAccountAuthorizationGroup,
  SupplierBasicAuthorizationGrp,
  CustomerBasicAuthorizationGrp,
  AcctgDocTypeAuthorizationGroup,
  OrderType,
  SalesOrderType
FROM I_OrglChangeTransfPostg
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElement ON WBSElementInternalID = _WBSElement.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementText ON WBSElementInternalID = _WBSElementText.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementByExternalID AS _WBSElementExternalID ON WBSElementExternalID = _WBSElementExternalID.WBSElementExternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementByExternalID AS _WBSElementExternalIDText ON WBSElementExternalID = _WBSElementExternalIDText.WBSElementExternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementByExternalID AS _PartnerWBSElementExternalID ON PartnerWBSElementExternalID = _PartnerWBSElementExternalID.WBSElementExternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementByExternalID AS _PartWBSElementExternalIDText ON PartnerWBSElementExternalID = _PartWBSElementExternalIDText.WBSElementExternalID  -- association [0..1]
LEFT OUTER JOIN I_ProjectBasicData AS _PartnerProject ON PartnerProjectInternalID = _PartnerProject.ProjectInternalID  -- association [0..1]
LEFT OUTER JOIN I_ProjectBasicData AS _PartnerProjectText ON PartnerProjectInternalID = _PartnerProjectText.ProjectInternalID  -- association [0..1]
LEFT OUTER JOIN I_ProjectByExternalID AS _ProjectExternalID ON ProjectExternalID = _ProjectExternalID.ProjectExternalID  -- association [0..1]
LEFT OUTER JOIN I_ProjectByExternalID AS _ProjectExternalIDText ON ProjectExternalID = _ProjectExternalIDText.ProjectExternalID  -- association [0..1]
LEFT OUTER JOIN I_ProjectByExternalID AS _PartnerProjectExternalID ON PartnerProjectExternalID = _PartnerProjectExternalID.ProjectExternalID  -- association [0..1]
LEFT OUTER JOIN I_ProjectByExternalID AS _PartnerProjectExternalIDText ON PartnerProjectExternalID = _PartnerProjectExternalIDText.ProjectExternalID  -- association [0..1]
LEFT OUTER JOIN I_CalendarMonth AS _CalendarMonth ON CalendarMonth = _CalendarMonth.CalendarMonth  -- association [1..1]
LEFT OUTER JOIN I_CalendarQuarter AS _CalendarQuarter ON CalendarQuarter = _CalendarQuarter.CalendarQuarter  -- association [1..1]
LEFT OUTER JOIN I_YearMonth AS _CalendarYearMonth ON CalendarYearMonth = _CalendarYearMonth.YearMonth  -- association [1..1]
LEFT OUTER JOIN I_MasterFixedAsset AS _MasterFixedAsset ON CompanyCode = _MasterFixedAsset.CompanyCode AND MasterFixedAsset = _MasterFixedAsset.MasterFixedAsset  -- association [0..1]
LEFT OUTER JOIN I_FixedAsset AS _FixedAsset ON CompanyCode = _FixedAsset.CompanyCode AND MasterFixedAsset = _FixedAsset.MasterFixedAsset AND FixedAsset = _FixedAsset.FixedAsset  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_PurchasingDocument AS _PurchasingDocument ON PurchasingDocument = _PurchasingDocument.PurchasingDocument  -- association [0..1]
LEFT OUTER JOIN I_PurchasingDocumentItem AS _PurchasingDocumentItem ON PurchasingDocument = _PurchasingDocumentItem.PurchasingDocument AND PurchasingDocumentItem = _PurchasingDocumentItem.PurchasingDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_SalesDocument AS _SalesDocument ON SalesDocument = _SalesDocument.SalesDocument  -- association [0..1]
LEFT OUTER JOIN I_SalesDocumentItem AS _SalesDocumentItem ON SalesDocument = _SalesDocumentItem.SalesDocument AND SalesDocumentItem = _SalesDocumentItem.SalesDocumentItem  -- association [0..1]
;