I_PPS_PurReqnAcctAssgmt

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_PPS_PurReqnAcctAssgmt.
-- 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_PPS_PurReqnAcctAssgmt AS
SELECT
  PurchaseRequisition,
  PurchaseRequisitionItem,
  PurchaseReqnAcctAssgmtNumber AS PurReqnAcctAssgmtNmbr,
  _PurchaseReqnItemBsc.Plant AS Plant,
  CostCenter,
  MasterFixedAsset,
  ProjectNetwork,
  Quantity,
  _PurchaseReqnItemBsc.BaseUnit AS BaseUnit,
  MultipleAcctAssgmtDistrPercent,
  PurReqnNetAmount,
  _PurchaseReqnItemBsc.PurReqnItemCurrency AS PurReqnItemCurrency,
  IsDeleted,
  GLAccount,
  BusinessArea,
  SalesOrder,
  SalesOrderItem,
  SalesOrderScheduleLine,
  FixedAsset,
  OrderID,
  UnloadingPointName,
  ControllingArea,
  ProfitabilitySegment,
  ProfitCenter,
  cast( WBSElementInternalID_2 as ps_s4_pspnr ) AS WBSElementInternalID,
  WBSElementInternalID_2,
  cast( _WBSElementBasicData.WBSElement as ps_posid_edit ) AS WBSElement,
  cast( _WBSElementBasicData.WBSElement as ps_posid_edit ) AS WBSElementExternalID,
  _WBSElementBasicData.WBSElementExternalID AS WBSElementExternalID_2,
  ProjectNetworkInternalID,
  CommitmentItemShortID,
  FundsCenter,
  Fund,
  FunctionalArea,
  CreationDate,
  GoodsRecipientName,
  REInternalFinNumber,
  NetworkActivityInternalID,
  PartnerAccountNumber,
  JointVentureRecoveryCode,
  SettlementReferenceDate,
  CostObject,
  EarmarkedFundsDocument,
  EarmarkedFundsDocumentItem,
  CostCtrActivityType,
  BusinessProcess,
  GrantID,
  cast(substring( cast(tstmp_current_utctimestamp() as abap.char( 17 ) ), 1, 8 ) as abap.dats ) AS ValidityDate,
  BudgetPeriod,
  PubSecSplitBatchNumberID,
  PubSecSplitAuthznGroup
FROM I_PurReqnAcctAssgmtBasic
LEFT OUTER JOIN I_PurchaseRequisitionItemBasic AS _PurchaseReqnItemBsc ON _PurchaseReqnItemBsc.PurchaseRequisition = PurchaseRequisition AND _PurchaseReqnItemBsc.PurchaseRequisitionItem = PurchaseRequisitionItem  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _Plant ON plant = _Plant.Plant  -- association [1..1]
LEFT OUTER JOIN I_BusinessAreaText AS _BusinessAreaText ON BusinessArea = _BusinessAreaText.BusinessArea  -- association [0..*]
LEFT OUTER JOIN I_SalesOrder AS _SalesOrder ON SalesOrder = _SalesOrder.SalesOrder  -- association [0..1]
LEFT OUTER JOIN I_SalesOrderItem AS _SalesOrderItem ON SalesOrder = _SalesOrderItem.SalesOrder AND SalesOrderItem = _SalesOrderItem.SalesOrderItem  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasicData ON WBSElementInternalID_2 = _WBSElementBasicData.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_Order AS _Order ON OrderID = _Order.OrderID  -- association [0..1]
LEFT OUTER JOIN I_ProjectNetwork AS _ProjectNetwork ON ProjectNetwork = _ProjectNetwork.ProjectNetwork  -- association [0..1]
;