P_EBASO_OrderCost2

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 P_EBASO_OrderCost2.
-- 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_FromFiscalYearPeriod : fis_jahrper, P_ToFiscalYearPeriod : fis_jahrper, P_Ledger : fins_ledger

CREATE VIEW P_EBASO_OrderCost2 AS
SELECT
  Costs.Ledger AS Ledger,
  Costs.CompanyCode AS CompanyCode,
  Costs.FiscalYear AS FiscalYear,
  Costs.AccountingDocument AS AccountingDocument,
  Costs.LedgerGLLineItem AS LedgerGLLineItem,
  Costs.FinancialPlanningReqTransSqnc AS FinancialPlanningReqTransSqnc,
  Costs.FinancialPlanningDataPacket AS FinancialPlanningDataPacket,
  Costs.FinancialPlanningEntryItem AS FinancialPlanningEntryItem,
  Costs.ControllingValueType AS ControllingValueType,
  Costs.SelectedCurrencyBranch AS SelectedCurrencyBranch,
  Costs.PlantForFilter AS PlantForFilter,
  Costs.OrderDescription AS OrderDescription,
  Costs.OrderType AS OrderType,
  Costs.Product AS Product,
  Costs.OrderID AS OrderID,
  Costs.OrderCategory AS OrderCategory,
  Costs.ProfitCenter AS ProfitCenter,
  Costs.MRPPlant AS MRPPlant,
  Costs.StorageLocation AS StorageLocation,
  Costs.ProductionVersion AS ProductionVersion,
  Costs.SalesOrder AS SalesOrder,
  Costs.SalesOrderItem AS SalesOrderItem,
  Costs.WBSElementInternalID AS WBSElementInternalID,
  Costs.MfgOrderHasMultipleItems AS MfgOrderHasMultipleItems,
  Costs.ControllingArea AS ControllingArea,
  Costs.ReferenceOrder AS ReferenceOrder,
  Costs.ResponsibleCostCenter AS ResponsibleCostCenter,
  Costs.CostElement AS CostElement,
  Costs.BusinessTransactionCategory AS BusinessTransactionCategory,
  Costs.ControllingDebitCreditCode AS ControllingDebitCreditCode,
  Costs.CtrlgOriginClassification AS CtrlgOrignClassificationFoFltr,
  Costs.OrderItem AS OrderItem,
  Costs.AccountAssignmentType AS AccountAssignmentType,
  Costs.PartnerAccountAssignment AS PartnerAccountAssignment,
  Costs.PartnerObjectType AS PartnerObjectType,
  Costs.PartnerCostCenter AS PartnerCostCenter,
  Costs.PartnerCostCtrActivityType AS PartnerCostCtrActivityType,
  cast(Costs.PartnerOrder as fis_par_aufnr) AS PartnerOrder,
  Costs.UnitOfMeasure AS UnitOfMeasure,
  Costs.Material AS MaterialForFilter,
  Costs.CostOriginGroup AS CostOriginGroupForFilter,
  Costs.SubLedgerAcctLineItemType AS SubLedgerAcctLineItemType,
  Costs.IsLotSizeIndependent AS IsLotSizeIndependent,
  Costs.OriginCostCenter AS OriginCostCenter,
  Costs.OriginCostCtrActivityType AS OriginCostCtrActivityType,
  substring(Costs.BusinessTransactionCategory, 1, 3) AS BusinessTransactionCatPrefix,
  CostElement.CostElementCategory AS CostElementCategory,
  CostElement.ChartOfAccounts AS ChartOfAccounts,
  Costs.Plant AS Plant,
  Costs.Material AS Material,
  Costs.CostOriginGroup AS CostOriginGroup,
  case when Costs.Material <> '' then concat(concat(Costs.Plant, '/'), Costs.Material) when Costs.CostOriginGroup <> '' then Costs.CostOriginGroup when Costs.OriginCostCenter <> '' and Costs.OriginCostCtrActivityType <> '' then concat(concat(Costs.OriginCostCenter, '/'), Costs.OriginCostCtrActivityType) when Costs.OriginCostCenter <> '' and (Costs.OriginCostCtrActivityType = '' or Costs.OriginCostCtrActivityType is null) then Costs.OriginCostCenter else '' end as OriginObject AS OriginCostCenterelseendasOriginObject,
  Costs.DisplayCurrency AS DisplayCurrency,
  Costs.AmountInDisplayCurrency AS AmountInDisplayCurrency,
  Costs.TotalQuantity AS TotalQuantity
FROM P_EBASO_OrderCost1
;