I_REIntegObjectOrderPlanActual

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_REIntegObjectOrderPlanActual.
-- 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.

CREATE VIEW I_REIntegObjectOrderPlanActual AS
SELECT
  _ActualPlanJournalEntryItem.SourceLedger AS SourceLedger,
  _ActualPlanJournalEntryItem.Ledger AS Ledger,
  _ActualPlanJournalEntryItem.CompanyCode AS CompanyCode,
  _ActualPlanJournalEntryItem.FiscalYear AS FiscalYear,
  _ActualPlanJournalEntryItem.AccountingDocument AS AccountingDocument,
  _ActualPlanJournalEntryItem.FinancialPlanningReqTransSqnc AS FinancialPlanningReqTransSqnc,
  _ActualPlanJournalEntryItem.FinancialPlanningDataPacket AS FinancialPlanningDataPacket,
  _ActualPlanJournalEntryItem.ActualPlanJournalEntryItem AS ActualPlanJournalEntryItem,
  cast( '' as reipionr ) AS REOccupancyObjectNumber,
  _REIntegObjectCtrlgObjAssgmt.REIntegrationObjectNumberBldng AS REIntegrationObjectNumberBldng,
  _REIntegObjectCtrlgObjAssgmt.REIntegrationObjectNumberSite AS REIntegrationObjectNumberSite,
  _REIntegObjectCtrlgObjAssgmt.REParentIntegObjectExternalID AS REParentIntegObjectExternalID,
  _ActualPlanJournalEntryItem.AccountingDocumentType AS AccountingDocumentType,
  _ActualPlanJournalEntryItem.FiscalYearPeriod AS FiscalYearPeriod,
  _ActualPlanJournalEntryItem.FiscalYearVariant AS FiscalYearVariant,
  _ActualPlanJournalEntryItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  _ActualPlanJournalEntryItem.ProfitCenter AS ProfitCenter,
  _ActualPlanJournalEntryItem.ControllingArea AS ControllingArea,
  _ActualPlanJournalEntryItem.AccountAssignmentType AS AccountAssignmentType,
  _ActualPlanJournalEntryItem.CostCtrActivityType AS CostCtrActivityType,
  _ActualPlanJournalEntryItem.CostCenter AS CostCenter,
  _ActualPlanJournalEntryItem.CostSourceUnit AS CostSourceUnit,
  _ActualPlanJournalEntryItem.Customer AS Customer,
  _ActualPlanJournalEntryItem.CustomerGroup AS CustomerGroup,
  _ActualPlanJournalEntryItem.ControllingDebitCreditCode AS ControllingDebitCreditCode,
  _ActualPlanJournalEntryItem.FunctionalArea AS FunctionalArea,
  _ActualPlanJournalEntryItem.GlobalCurrency AS GlobalCurrency,
  _ActualPlanJournalEntryItem.LedgerGLLineItem AS LedgerGLLineItem,
  _ActualPlanJournalEntryItem.LedgerFiscalYear AS LedgerFiscalYear,
  _ActualPlanJournalEntryItem.OrderID AS OrderID,
  _ActualPlanJournalEntryItem.PlanningCategory AS PlanningCategory,
  _ActualPlanJournalEntryItem.PostingDate AS PostingDate,
  _ActualPlanJournalEntryItem.ProjectExternalID AS ProjectExternalID,
  _ActualPlanJournalEntryItem.Segment AS Segment,
  _ActualPlanJournalEntryItem.PartnerCompany AS PartnerCompany,
  _ActualPlanJournalEntryItem.TransactionCurrency AS TransactionCurrency,
  _ActualPlanJournalEntryItem.WBSElementExternalID AS WBSElementExternalID,
  _ActualPlanJournalEntryItem.BusinessArea AS BusinessArea,
  _ActualPlanJournalEntryItem.IsStatisticalOrder AS IsStatisticalOrder,
  _ActualPlanJournalEntryItem.IsStatisticalCostCenter AS IsStatisticalCostCenter,
  _ActualPlanJournalEntryItem.WBSIsStatisticalWBSElement AS WBSIsStatisticalWBSElement,
  _ActualPlanJournalEntryItem.ActualAmountInTransactionCrcy AS ActualAmountInTransactionCrcy,
  _ActualPlanJournalEntryItem.ActualAmountInGlobalCurrency AS ActualAmountInGlobalCurrency,
  _ActualPlanJournalEntryItem.PlanAmountInCompanyCodeCrcy AS PlanAmountInCompanyCodeCrcy,
  _ActualPlanJournalEntryItem.PlanAmountInTransactionCrcy AS PlanAmountInTransactionCrcy,
  _ActualPlanJournalEntryItem.PlanAmountInGlobalCurrency AS PlanAmountInGlobalCurrency,
  _ActualPlanJournalEntryItem.ActualValuationQuantity AS ActualValuationQuantity,
  _ActualPlanJournalEntryItem.PlanValuationQuantity AS PlanValuationQuantity,
  _ActualPlanJournalEntryItem._SourceLedger AS _SourceLedger,
  _ActualPlanJournalEntryItem._Ledger AS _Ledger,
  _ActualPlanJournalEntryItem._CompanyCode AS _CompanyCode,
  _ActualPlanJournalEntryItem._FiscalYear AS _FiscalYear,
  _ActualPlanJournalEntryItem._JournalEntry AS _JournalEntry,
  _ActualPlanJournalEntryItem._GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts,
  _ActualPlanJournalEntryItem._GLAccountInCompanyCode AS _GLAccountInCompanyCode,
  _ActualPlanJournalEntryItem._LedgerFiscalYearForVariant AS _LedgerFiscalYearForVariant,
  _ActualPlanJournalEntryItem._FiscalYearPeriod AS _FiscalYearPeriod,
  _ActualPlanJournalEntryItem._FiscalPeriodForVariant AS _FiscalPeriodForVariant,
  _ActualPlanJournalEntryItem._ChartOfAccounts AS _ChartOfAccounts,
  _ActualPlanJournalEntryItem._BusinessTransactionType AS _BusinessTransactionType,
  _ActualPlanJournalEntryItem._CostCtrActivityType AS _CostCtrActivityType,
  _ActualPlanJournalEntryItem._Customer AS _Customer,
  _ActualPlanJournalEntryItem._CustomerGroup AS _CustomerGroup,
  _ActualPlanJournalEntryItem._ControllingDebitCreditCode AS _ControllingDebitCreditCode,
  _ActualPlanJournalEntryItem._FunctionalArea AS _FunctionalArea,
  _ActualPlanJournalEntryItem._PlanningCategory AS _PlanningCategory,
  _ActualPlanJournalEntryItem._ProjectExternalID AS _ProjectExternalID,
  _ActualPlanJournalEntryItem._Segment AS _Segment,
  _ActualPlanJournalEntryItem._PartnerCompany AS _PartnerCompany,
  _ActualPlanJournalEntryItem._FiscalYearVariant AS _FiscalYearVariant,
  _ActualPlanJournalEntryItem._CompanyCodeCurrency AS _CompanyCodeCurrency,
  _ActualPlanJournalEntryItem._ProfitCenter AS _ProfitCenter,
  _ActualPlanJournalEntryItem._ControllingArea AS _ControllingArea,
  _ActualPlanJournalEntryItem._CostCenter AS _CostCenter,
  _ActualPlanJournalEntryItem._WBSElementExternalID AS _WBSElementExternalID,
  _ActualPlanJournalEntryItem._InternalOrder AS _InternalOrder,
  _ActualPlanJournalEntryItem._Order AS _Order,
  _ActualPlanJournalEntryItem._BusinessArea AS _BusinessArea,
  _ActualPlanJournalEntryItem._AccountingDocumentType AS _AccountingDocumentType,
  _REIntegObjectCtrlgObjAssgmt._REParentIntegrationObject AS _REParentIntegrationObject
RIGHT OUTER JOIN I_REIntegObjectCtrlgObjAssgmt AS _REIntegObjectCtrlgObjAssgmt ON /* join condition not captured in parsed metadata */
RIGHT OUTER JOIN I_REOccpcyGrpCtrlgObjAssgmt AS _REOccpcyGrpCtrlgObjAssgmt ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_REIntegObjectBldngLandVH AS _REIntegObjectBldngLandVH ON REIntegrationObjectNumberBldng = _REIntegObjectBldngLandVH.REIntegrationObjectNumberLvl1  -- association [1..1]
LEFT OUTER JOIN I_REIntegObjectSiteVH AS _REIntegObjectSiteVH ON REIntegrationObjectNumberSite = _REIntegObjectSiteVH.REIntegrationObjectNumberLvl0  -- association [1..1]
LEFT OUTER JOIN I_REIntegObjectLevel2VH AS _REOccupancyGroupVH ON REOccupancyObjectNumber = _REOccupancyGroupVH.REIntegrationObjectNumberLvl2  -- association [1..1]
;