I_ProfitabilityAnalysisDoc

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_ProfitabilityAnalysisDoc.
-- 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_ProfitabilityAnalysisDoc AS
SELECT
  kokrs AS ControllingArea,
  BELNR AS ControllingDocument,
  BUZEI AS ControllingDocumentItem,
  PERIO AS FiscalPeriod,
  objnr AS ControllingObject,
  WRTTP AS ControllingValueType,
  KSTAR AS CostElement,
  vrgng AS ControllingBusTransacType,
  PAROB1 AS PartnerControllingObject,
  uspob AS OriginSenderObject,
  VBUND AS PartnerCompany,
  PARGB AS PartnerBusinessArea,
  BEKNZ AS ControllingDebitCreditCode,
  TWAER AS TransactionCurrency,
  WTGBTR AS AmountInTransactionCurrency,
  OWAER AS ControllingObjectCurrency,
  WOGBTR AS AmountInObjectCurrency,
  KWAER AS ControllingAreaCurrency,
  WKGBTR AS ActualAmtInCtrlgAreaCrcy,
  WKFBTR AS FixedAmountInCtrlgAreaCrcy,
  PAGBTR AS TotalPriceVarcInCtrlgAreaCrcy,
  PAFBTR AS FixedPriceVarcInCtrlgAreaCrcy,
  MEINH AS CostSourceUnit,
  MEGBTR AS TotalQuantity,
  MEFBTR AS FixedQuantity,
  MEINB AS EntryUnit,
  MBGBTR AS TotalQuantityInEntryUnit,
  MBFBTR AS EnteredFixedQuantity,
  qunit1 AS AdditionalQuantity1Unit,
  quant1 AS AdditionalQuantity1,
  qunit2 AS AdditionalQuantity2Unit,
  quant2 AS AdditionalQuantity2,
  qunit3 AS AdditionalQuantity3Unit,
  quant3 AS AdditionalQuantity3,
  MVFLG AS QuantityCompletion,
  sgtxt AS DocumentItemText,
  refbz AS ReferenceDocumentItem,
  BW_REFBZ AS OperativeVersionLineItem,
  gkont AS OffsettingAccount,
  gkoar AS FinancialAccountType,
  werks AS Plant,
  matnr AS Material,
  rbest AS ReferencePurchaseOrderCategory,
  ebeln AS PurchasingDocument,
  ebelp AS PurchasingDocumentItem,
  zekkn AS AccountAssignmentNumber,
  erlkz AS LineItemIsCompleted,
  pernr AS Personnel,
  BTRKL AS CtrlgAreaCurrencyAmountClass,
  cast( case when paobjnr > '9999999999' then '9999999999' else lpad( paobjnr, 10, '0' ) end as rkeobjnr_numc ) AS ProfitabilitySegment,
  cast( paobjnr as rkeobjnr_char ) AS ProfitabilitySegment_2,
  beltp AS ControllingObjectDebitType,
  GSBER AS BusinessArea,
  FKBER AS FunctionalArea,
  scope AS ControllingObjectClass,
  logsyso AS LogicalSystem,
  PKSTAR AS PartnerCostElement,
  pbukrs AS PartnerCompanyCode,
  PFKBER AS PartnerFunctionalArea,
  pscope AS PartnerControllingObjectClass,
  logsysp AS PartnerLogicalSystem,
  DABRZ AS SettlementReferenceDate,
  bwstrat AS AllocPriceDetnStrategy,
  objnr_hk AS OriginObject,
  rsrce AS CostAnalysisResource,
  qmnum AS CustomerServiceNotification,
  GEBER AS Fund,
  PGEBER AS PartnerFund,
  GRANT_NBR AS GrantID,
  PGRANT_NBR AS PartnerGrant,
  REFBZ_FI AS RefAccountingDocumentItem,
  Segment,
  psegment AS PartnerSegment,
  POSNR AS AccountingDocumentItemRef,
  prctr AS ProfitCenter,
  PPRCT AS PartnerProfitCenter,
  BUDGET_PD AS BudgetPeriod,
  PBUDGET_PD AS PartnerBudgetPeriod,
  awtyp AS ReferenceDocumentType,
  AWKEY AS OriginalReferenceDocument,
  AWSYS AS ReferenceDocumentLogicalSystem,
  accas AS AccountAssignment,
  accasty AS AccountAssignmentType,
  KOSTL AS CostCenter,
  LSTAR AS CostCtrActivityType,
  AUFNR AS OrderID,
  AUTYP AS OrderCategory,
  PS_PSP_PNR AS WBSElementInternalID,
  PSPNR AS WBSElement,
  PSPID AS Project,
  VBELN AS SDDocument,
  VBPOSNR AS SalesDocumentItem,
  work_item_id AS WorkItem,
  erkrs AS OperatingConcern,
  PKOSTL AS PartnerCostCenter,
  plstar AS PartnerCostCtrActivityType,
  paufnr AS PartnerOrder,
  pautyp AS PartnerOrderCategory,
  PPSPNR AS PartnerWBSElement,
  PPSPID AS PartnerProject,
  PVBELN AS PartnerSalesDocument,
  PVBPOSNR AS PartnerSalesDocumentItem,
  gjahr AS FiscalYear,
  bldat AS DocumentDate,
  budat AS PostingDate,
  usnam AS CreatedByUser,
  LEDNR AS BudgetPlanningLedger,
  BUKRS AS CompanyCode,
  cpudt AS CreationDate,
  cputm AS CreationTime,
  KNDNR AS Customer,
  ARTNR AS Product,
  fkart AS BillingDocumentType,
  kdauf AS SalesOrder,
  kdpos AS SalesOrderItem,
  vkorg AS SalesOrganization,
  vtweg AS DistributionChannel,
  spart AS Division,
  kstrg AS CostObject,
  BRSCH AS Industry,
  BZIRK AS SalesDistrict,
  kdgrp AS CustomerGroup,
  KMVKBU AS SalesOffice,
  KMVTNR AS SalesEmployee,
  matkl AS MaterialGroup,
  VKGRP AS SalesGroup,
  bttype AS BusinessTransactionType
FROM P_Copa_Doc
LEFT OUTER JOIN I_FiscalYearForCompanyCode AS _FiscalYear ON FiscalYear = _FiscalYear.FiscalYear AND CompanyCode = _FiscalYear.CompanyCode association[0..1] to I_ControllingArea as _ControllingArea on ControllingArea = _ControllingArea.ControllingArea association[0..1] to I_Currency as _TransactionCurrency on TransactionCurrency = _TransactionCurrency.Currency association[0..1] to I_Currency as _ControllingObjectCurrency on ControllingObjectCurrency = _ControllingObjectCurrency.Currency association[1] to I_Currency as _ControllingAreaCurrency on ControllingAreaCurrency = _ControllingAreaCurrency.Currency association[0..1] to I_UnitOfMeasure as _EntryUnit on EntryUnit = _EntryUnit.UnitOfMeasure association[0..1] to I_UnitOfMeasure as _CostSourceUnit on CostSourceUnit = _CostSourceUnit.UnitOfMeasure association[0..1] to I_UnitOfMeasure as _AdditionalQuantity1Unit on AdditionalQuantity1Unit = _AdditionalQuantity1Unit.UnitOfMeasure association[0..1] to I_UnitOfMeasure as _AdditionalQuantity2Unit on AdditionalQuantity2Unit = _AdditionalQuantity2Unit.UnitOfMeasure association[0..1] to I_UnitOfMeasure as _AdditionalQuantity3Unit on AdditionalQuantity3Unit = _AdditionalQuantity3Unit.UnitOfMeasure association[0..1] to I_Segment as _Segment on Segment = _Segment.Segment association[0..*] to I_ProfitCenter as _ProfitCenter on ControllingArea = _ProfitCenter.ControllingArea AND ProfitCenter = _ProfitCenter.ProfitCenter association[0..*] to I_CostCenter as _CostCenter on ControllingArea = _CostCenter.ControllingArea AND CostCenter = _CostCenter.CostCenter association[0..1] to I_BusinessArea as _BusinessArea on BusinessArea = _BusinessArea.BusinessArea association[0..1] to I_FunctionalArea as _FunctionalArea on FunctionalArea = _FunctionalArea.FunctionalArea association[0..1] to I_WBSElement as _WBSElement on WBSElement = _WBSElement.WBSElement association[0..1] to I_WBSElementByInternalKey as _WBSElementInternalID on WBSElementInternalID = _WBSElementInternalID.WBSElementInternalID association[0..1] to I_Project as _Project on Project = _Project.Project association[0..1] to I_FinancialAccountType as _FinancialAccountType on FinancialAccountType = _FinancialAccountType.FinancialAccountType association[0..1] to I_Material as _Material on Material = _Material.Material association[0..1] to I_Plant as _Plant on Plant = _Plant.Plant association[0..1] to I_WorkItem as _WorkItem on WorkItem = _WorkItem.WorkItem  -- association [0..1]
;