P_EBASO_OrderPlanCost1

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_OrderPlanCost1.
-- 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_OrderPlanCost1 AS
SELECT
  FinancialPlanningReqTransSqnc,
  FinancialPlanningDataPacket,
  FinancialPlanningEntryItem,
  '01' AS ControllingValueType,
  CompanyCode,
  Plant,
  ControllingArea,
  PlanningCategory,
  cast(GLAccount as fis_saknr) AS CostElement,
  BusinessTransactionCategory,
  ControllingDebitCreditCode,
  OrderID,
  AccountAssignmentType,
  PartnerAccountAssignmentType,
  PartnerCostCenter,
  PartnerCostCtrActivityType,
  PartnerOrder_2 AS PartnerOrder,
  CostSourceUnit AS UnitOfMeasure,
  Material,
  IsLotSizeIndependent,
  CostOriginGroup,
  OriginCostCenter,
  OriginCostCtrActivityType,
  CompanyCodeCurrency,
  GlobalCurrency,
  FreeDefinedCurrency1,
  FreeDefinedCurrency2,
  FreeDefinedCurrency3,
  FreeDefinedCurrency4,
  FreeDefinedCurrency5,
  FreeDefinedCurrency6,
  FreeDefinedCurrency7,
  FreeDefinedCurrency8,
  cast(AmountInCompanyCodeCurrency as abap.dec(23, 2)) AS AmountInCompanyCodeCurrency,
  cast(AmountInGlobalCurrency as abap.dec(23, 2)) AS AmountInGlobalCurrency,
  cast(AmountInFreeDefinedCurrency1 as abap.dec(23, 2)) AS AmountInFreeDefinedCurrency1,
  cast(AmountInFreeDefinedCurrency2 as abap.dec(23, 2)) AS AmountInFreeDefinedCurrency2,
  cast(AmountInFreeDefinedCurrency3 as abap.dec(23, 2)) AS AmountInFreeDefinedCurrency3,
  cast(AmountInFreeDefinedCurrency4 as abap.dec(23, 2)) AS AmountInFreeDefinedCurrency4,
  cast(AmountInFreeDefinedCurrency5 as abap.dec(23, 2)) AS AmountInFreeDefinedCurrency5,
  cast(AmountInFreeDefinedCurrency6 as abap.dec(23, 2)) AS AmountInFreeDefinedCurrency6,
  cast(AmountInFreeDefinedCurrency7 as abap.dec(23, 2)) AS AmountInFreeDefinedCurrency7,
  cast(AmountInFreeDefinedCurrency8 as abap.dec(23, 2)) AS AmountInFreeDefinedCurrency8,
  cast(FixedAmountInGlobalCrcy as abap.dec(23, 2)) AS FixedAmountInGlobalCrcy,
  ValuationQuantity AS Quantity
FROM I_FinancialPlanningEntryItem
;