I_ActlPlnSrvcMargItemCube

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_ActlPlnSrvcMargItemCube.
-- 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_ActlPlnSrvcMargItemCube AS
SELECT
  Ledger,
  SourceLedger,
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  FinancialPlanningReqTransSqnc,
  FinancialPlanningDataPacket,
  ActualPlanJournalEntryItem,
  cast(PostingDate as budat preserving type ) AS PostingDate,
  _FiscalCalendarDate.FiscalYearQuarter AS FiscalYearQuarter,
  LedgerGLLineItem,
  FinancialPlanningEntryItem,
  BusinessSolutionOrder,
  BusinessSolutionOrderItem,
  ProviderContract,
  ProviderContractItem,
  ActualPlanCode,
  FiscalYearVariant,
  FiscalPeriod,
  FiscalYearPeriod,
  ServiceContract,
  ServiceContractItem,
  ServiceContractType,
  AccountAssignmentType,
  cast( ProjectExternalID as ps_pspid_edit preserving type ) AS ProjectExternalID,
  ProfitCenter,
  ServiceDocumentType,
  ServiceDocument,
  ServiceDocumentItem,
  BillToParty,
  BusinessTransactionType,
  Customer,
  CustomerGroup,
  GLAccount,
  cast( GLAccount as fis_racct preserving type ) AS OldGLAccount,
  CustomerSupplierIndustry,
  SoldProductGroup,
  SoldProduct,
  SalesOrder,
  SalesOrderItem,
  SalesDocument,
  SalesDocumentItem,
  SalesOrganization,
  ShipToParty,
  ChartOfAccounts,
  ControllingArea,
  cast( CostSourceUnit as rvunit preserving type ) AS CostSourceUnit,
  ValuationQuantity,
  BaseUnit,
  Quantity,
  BillableControl,
  DistributionChannel,
  OrganizationDivision,
  FunctionalArea,
  PartnerCostCtrActivityType,
  PersonnelNumber,
  Plant,
  CustomerSupplierCountry,
  cast( WBSElement as fis_wbs_no_conv preserving type ) AS WBSElement,
  WBSElementExternalID,
  cast( _AcctgServiceDocumentItem.ResultAnalysisInternalID as fins_ma_rev_rec_key preserving type ) AS ResultAnalysisInternalID,
  Product,
  Equipment,
  ServicesRenderedDate,
  TimeSheetOvertimeCategory,
  SalesDistrict,
  Segment,
  PlanningCategory,
  ControllingObjectClass,
  GlobalCurrency,
  AmountInGlobalCurrency,
  CompanyCodeCurrency,
  AmountInCompanyCodeCurrency,
  LedgerFiscalYear,
  Supplier,
  CostCenter,
  FinancialAccountType,
  OrderID,
  AccountingDocumentType,
  ValuationArea,
  AssetClass
FROM I_ActualPlanJournalEntryItem
LEFT OUTER JOIN I_MargAnlysProdAndSrvcObjType AS _ObjectType ON AccountAssignmentType = _ObjectType.MarginAnalysisObjectType  -- association [0..1]
LEFT OUTER JOIN I_ServiceDocument AS _SolutionOrder ON BusinessSolutionOrder = _SolutionOrder.ServiceDocument AND _SolutionOrder.ServiceObjectType = 'BUS2000172'  -- association [0..1]
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] to I_GLAccountInChartOfAccounts as _OldGLAccountInChartOfAccounts on ChartOfAccounts = _OldGLAccountInChartOfAccounts.ChartOfAccounts AND OldGLAccount = _OldGLAccountInChartOfAccounts.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_AcctgServiceDocumentItem AS _AcctgServiceDocumentItem ON ServiceDocumentType = _AcctgServiceDocumentItem.ServiceDocumentType AND ServiceDocument = _AcctgServiceDocumentItem.ServiceDocument AND ServiceDocumentItem = _AcctgServiceDocumentItem.ServiceDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_CustomerSupplierIndustry AS _CustomerSupplierIndustry ON CustomerSupplierIndustry = _CustomerSupplierIndustry.Industry  -- 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]
LEFT OUTER JOIN I_FiscalYearForLedger AS _LedgerFiscalYearForLedger ON LedgerFiscalYear = _LedgerFiscalYearForLedger.FiscalYear AND CompanyCode = _LedgerFiscalYearForLedger.CompanyCode AND Ledger = _LedgerFiscalYearForLedger.Ledger  -- association [0..1]
;