P_WrkflwPOItemClassification

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_WrkflwPOItemClassification.
-- 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.
-- SQL view name: PWRPOICLAS
-- Parameters: P_DisplayCurrency : displaycurrency, P_StartDate : badat, P_EndDate : badat, P_PriceForLowCostItem : mm_a_low_cost_value, P_PriceForMediumCostItem : mm_a_medium_cost_value, P_PriceForHighCostItem : mm_a_high_cost_value

CREATE VIEW P_WrkflwPOItemClassification AS
SELECT
  PurchaseOrder,
  PurchaseOrderItem,
  PurchasingGroup,
  PurchasingOrganization,
  CompanyCode,
  Supplier,
  Plant,
  Material,
  MaterialGroup,
  AccountAssignmentCategory,
  PurchaseOrderDate,
  CreatedByUser,
  DocumentCurrency,
  OrderQuantity,
  NetPriceQuantity,
  PurchaseOrderType,
  WrkflwTskCreationUTCDateTime,
  WrkflwTskCompletionUTCDateTime,
  ApprovalTime,
  TargetApprovalTime,
  PurchaseOrderPrice,
  cast(ApprovalTime as mm_a_approvaldays_lowcostitems) AS ApprovalDaysForLowCostItems,
  cast(0 as mm_a_apprvldays_mediumcostitem ) AS ApprovalDaysForMediumCostItems,
  cast(0 as mm_a_apprvldays_highcostitem ) AS ApprovalDaysForHighCostItems,
  cast(0 as mm_a_apprvldaysforvhcostitem) as ApprvlDaysForVeryHighCostItems AS P_DisplayCurrency,
  P_StartDate : $parameters.P_StartDate AS P_StartDate,
  cast(ApprovalTime as mm_a_apprvldaysforvhcostitem) AS ApprvlDaysForVeryHighCostItems
FROM P_WrkflwPurchaseOrderItem1
-- UNION ALL with additional select branch(es): P_WrkflwPurchaseOrderItem1
;