P_PurOrdItmAcctAssgmt

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_PurOrdItmAcctAssgmt.
-- 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: PMMPOIACCASGMT
-- Parameters: P_DisplayCurrency : displaycurrency, P_StartDate : bedat, P_EndDate : bedat

CREATE VIEW P_PurOrdItmAcctAssgmt AS
SELECT
  PurchaseOrder,
  cast( PurchaseOrderItem.PurchaseOrderItem as vdm_purchaseorderitem ) AS PurchaseOrderItem,
  AccountAssignment.AccountAssignmentNumber AS AccountAssignmentNumber,
  PurgDocMigrtnIsCmpltdForAnlyts,
  PurchaseOrderItem.PurchaseRequisition AS PurchaseRequisition,
  PurchaseOrderItem.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  PurchaseOrderItem.Supplier AS Supplier,
  PurchaseOrderItem.PurchasingOrganization AS PurchasingOrganization,
  PurchaseOrderItem.PurchasingGroup AS PurchasingGroup,
  PurchaseOrderItem.CompanyCode AS CompanyCode,
  PurchaseOrderItem.PurgDocHdrCompanyCode AS PurgDocHdrCompanyCode,
  PurchaseOrderItem.PurchaseOrderType AS PurchaseOrderType,
  PurchaseOrderItem.IsCompletelyDelivered AS IsCompletelyDelivered,
  PurchaseOrderItem.PurchaseOrderDate AS PurchaseOrderDate,
  PurchaseOrderItem.CreatedByUser AS CreatedByUser,
  Currency,
  PurchaseOrderItem.MaterialGroup AS MaterialGroup,
  PurchaseOrderItem.Material AS Material,
  PurchaseOrderItem.Plant AS Plant,
  PurchaseOrderItem.PurchaseOrderItemCategory AS PurchaseOrderItemCategory,
  PurchaseOrderItem.PurchaseOrderCategory AS PurchaseOrderCategory,
  PurchaseOrderItem.PurchaseContract AS PurchaseContract,
  PurchaseOrderItem.PurchaseContractItem AS PurchaseContractItem,
  PurchaseOrderItem.ProductType AS ProductType,
  PurchaseOrderItem.ServicePerformer AS ServicePerformer,
  PurchaseOrderItem.MultipleAcctAssgmtDistribution AS MultipleAcctAssgmtDistribution,
  PurchaseOrderItem.AccountAssignmentCategory AS AccountAssignmentCategory,
  AccountAssignment.MultipleAcctAssgmtDistrPercent AS MultipleAcctAssgmtDistrPercent,
  AccountAssignment.CostCenter AS CostCenter,
  AccountAssignment.WBSElementInternalID AS WBSElementInternalID,
  AccountAssignment.ControllingArea AS ControllingArea,
  AccountAssignment.GLAccount AS GLAccount,
  AccountAssignment.ProfitCenter AS ProfitCenter,
  cast( :P_DisplayCurrency as displaycurrency ) AS DisplayCurrency,
  PurchaseOrderItem.PurchaseOrderQuantityUnit AS PurchaseOrderQuantityUnit,
  cast ( AccountAssignment.Quantity as bstmg ) AS PurchaseOrderQty,
  cast ( cast( currency_conversion( amount => AccountAssignment.PurgDocNetAmount, source_currency => DocumentCurrency, target_currency => :P_DisplayCurrency, exchange_rate_date => PurchaseOrderDate, exchange_rate_type => 'M', error_handling => 'FAIL_ON_ERROR' ) as purchase_order_net_amount ) * cast( IsReturnsItem as int2 ) as purchase_order_net_amount ) as PurOrdNetAmountInDisplayCrcy AS P_DisplayCurrency,
  P_StartDate : $parameters.P_StartDate AS P_StartDate
FROM P_PURORDITMACCTASSGMT2
INNER JOIN I_PurgDocAccountAssignment AS AccountAssignment ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): P_PDOCITEMWITHOUTACCTASSGMT
;