I_ActualPlanServiceCube

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_ActualPlanServiceCube.
-- 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_ActualPlanServiceCube AS
SELECT
  Ledger,
  SourceLedger,
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  FinancialPlanningReqTransSqnc,
  FinancialPlanningDataPacket,
  ActualPlanJournalEntryItem,
  LedgerGLLineItem,
  FinancialPlanningEntryItem,
  ActualPlanCode,
  FiscalYearVariant,
  FiscalPeriod,
  FiscalYearPeriod,
  _SourceServiceDocument.ControllingObject AS ControllingObject,
  _SourceServiceDocument.SrvcContrItmControllingObject AS SrvcContrItmControllingObject,
  cast ( case _SourceServiceDocument.SrvcContrItmControllingObject when '' then substring( _SourceServiceDocument.ControllingObject,13,6) else substring( _SourceServiceDocument.SrvcContrItmControllingObject,13,6) end as abap.numc( 6 ) ) as ServiceContractItem AS numc6asServiceContractItem,
  AccountAssignmentType,
  ControllingArea,
  ProfitCenter,
  ServiceDocumentType,
  ServiceDocument,
  ServiceDocumentItem,
  BillToParty,
  BusinessTransactionType,
  Customer,
  CustomerGroup,
  GLAccount,
  CustomerSupplierIndustry,
  SoldProductGroup,
  SoldProduct,
  SalesOrder,
  SalesOrderItem,
  SalesDocument,
  SalesDocumentItem,
  SalesOrganization,
  ShipToParty,
  ChartOfAccounts,
  CostSourceUnit,
  ValuationQuantity,
  BaseUnit,
  Quantity,
  DistributionChannel,
  OrganizationDivision,
  FunctionalArea,
  PartnerCostCtrActivityType,
  BillableControl,
  Plant,
  Material,
  Product,
  FunctionalLocation,
  Equipment,
  AccountAssignmentNumber,
  OrderCategory,
  TimeSheetOvertimeCategory,
  PersonnelNumber,
  _ServiceDocument.ServiceOrganization AS ServiceOrganization,
  _MaintenanceOrder.SerialNumber AS SerialNumber,
  OrderID,
  PostingDate,
  PartnerCostCenter,
  PartnerProfitCenter,
  _CalendarDate.CalendarMonth AS CalendarMonth,
  _CalendarDate.CalendarQuarter AS CalendarQuarter,
  _CalendarDate.CalendarWeek AS CalendarWeek,
  _CalendarDate.CalendarYear AS CalendarYear,
  _CalendarDate.YearMonth AS CalendarYearMonth,
  _CalendarDate.YearQuarter AS CalendarYearQuarter,
  _CalendarDate.YearWeek AS CalendarYearWeek,
  _FiscalCalendarDate.FiscalQuarter AS FiscalQuarter,
  _FiscalCalendarDate.FiscalWeek AS FiscalWeek,
  _FiscalCalendarDate.FiscalYearQuarter AS FiscalYearQuarter,
  _FiscalCalendarDate.FiscalYearWeek AS FiscalYearWeek,
  CustomerSupplierCountry,
  cast( WBSElement as fis_wbs_no_conv preserving type ) AS WBSElement,
  WBSElementExternalID,
  SalesDistrict,
  Segment,
  PlanningCategory,
  ControllingObjectClass,
  GlobalCurrency,
  AmountInGlobalCurrency,
  CompanyCodeCurrency,
  AmountInCompanyCodeCurrency,
  TransactionCurrency,
  AmountInTransactionCurrency
FROM I_ActualPlanJournalEntryItem
LEFT OUTER JOIN I_AcctgServiceDocumentType AS _ServiceDocumentTypeNew ON ServiceDocumentType = _ServiceDocumentTypeNew.ServiceDocumentType  -- association [0..1]
LEFT OUTER JOIN I_AccountingServiceDocument AS _ServiceDocumentNew ON ServiceDocumentType = _ServiceDocumentNew.ServiceDocumentType AND ServiceDocument = _ServiceDocumentNew.ServiceDocument  -- association [0..1]
LEFT OUTER JOIN I_AcctgSrvcDocumentItemBasic AS _ServiceDocumentItemNew ON ServiceDocumentType = _ServiceDocumentItemNew.ServiceDocumentType AND ServiceDocument = _ServiceDocumentItemNew.ServiceDocument AND ServiceDocumentItem = _ServiceDocumentItemNew.ServiceDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_AcctgServiceDocumentType AS _ServiceContractTypeNew ON ServiceContractType = _ServiceContractTypeNew.ServiceDocumentType  -- association [0..1]
LEFT OUTER JOIN I_AccountingServiceDocument AS _ServiceContractNew ON ServiceContractType = _ServiceContractNew.ServiceDocumentType AND ServiceContract = _ServiceContractNew.ServiceDocument  -- association [0..1]
LEFT OUTER JOIN I_AcctgSrvcDocumentItemBasic AS _ServiceContractItemNew ON ServiceContractType = _ServiceContractItemNew.ServiceDocumentType AND ServiceContract = _ServiceContractItemNew.ServiceDocument AND ServiceContractItem = _ServiceContractItemNew.ServiceDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_AcctgServiceDocumentItem AS _SourceServiceDocument ON ServiceDocumentType = _SourceServiceDocument.ServiceDocumentType AND ServiceDocument = _SourceServiceDocument.ServiceDocument AND ServiceDocumentItem = _SourceServiceDocument.ServiceDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_CalendarDate AS _CalendarDate ON PostingDate = _CalendarDate.CalendarDate  -- 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_MaintenanceOrder AS _MaintenanceOrder ON OrderID = _MaintenanceOrder.MaintenanceOrder  -- association [0..1]
LEFT OUTER JOIN I_FiscalCalendarDate AS _FiscalCalendarDate ON PostingDate = _FiscalCalendarDate.CalendarDate AND FiscalYearVariant = _FiscalCalendarDate.FiscalYearVariant  -- association [0..1]
LEFT OUTER JOIN E_JournalEntryItem AS _Extension_acdoca ON SourceLedger = _Extension_acdoca.SourceLedger AND CompanyCode = _Extension_acdoca.CompanyCode AND FiscalYear = _Extension_acdoca.FiscalYear AND AccountingDocument = _Extension_acdoca.AccountingDocument AND LedgerGLLineItem = _Extension_acdoca.LedgerGLLineItem  -- association [1..1]
LEFT OUTER JOIN E_FinancialPlanningEntryItem AS _Extension_acdocp ON FinancialPlanningReqTransSqnc = _Extension_acdocp.FinancialPlanningReqTransSqnc AND FinancialPlanningDataPacket = _Extension_acdocp.FinancialPlanningDataPacket AND FinancialPlanningEntryItem = _Extension_acdocp.FinancialPlanningEntryItem  -- association [1..1]
;