T_PurchaseReqnAcctAssgmt

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 T_PurchaseReqnAcctAssgmt.
-- 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: IPURREQNACCTWD

CREATE VIEW T_PurchaseReqnAcctAssgmt AS
SELECT
  Document.PurReqnAcctAssgmtNmbr AS PurReqnAcctAssgmtNmbr,
  Document.PurchaseRequisition AS PurchaseRequisition,
  Document.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  Document.PurReqnAcctAssgmtNmbr AS PurReqnAcctAssgmtNmbrForEdit,
  Document.CostCenter AS CostCenter,
  Document.MasterFixedAsset AS MasterFixedAsset,
  Document.ProjectNetwork AS ProjectNetwork,
  Document.Quantity AS Quantity,
  Document.BaseUnit AS BaseUnit,
  Document.MultipleAcctAssgmtDistrPercent AS MultipleAcctAssgmtDistrPercent,
  Document.PurReqnItemCurrency AS PurReqnItemCurrency,
  Document.PurReqnNetAmount AS PurReqnNetAmount,
  Document.IsDeleted AS IsDeleted,
  Document.CostElement AS CostElement,
  Document.GLAccount AS GLAccount,
  Document.BusinessArea AS BusinessArea,
  Document.SDDocument AS SDDocument,
  Document.SalesOrder AS SalesOrder,
  Document.SalesDocumentItem AS SalesDocumentItem,
  Document.SalesOrderItem AS SalesOrderItem,
  Document.ScheduleLine AS ScheduleLine,
  Document.SalesOrderScheduleLine AS SalesOrderScheduleLine,
  Document.FixedAsset AS FixedAsset,
  Document.ProcessOrder AS ProcessOrder,
  Document.OrderID AS OrderID,
  Document.UnloadingPointName AS UnloadingPointName,
  Document.ControllingArea AS ControllingArea,
  Document.CostObject AS CostObject,
  Document.ProfitabilitySegment AS ProfitabilitySegment,
  Document.ProfitCenter AS ProfitCenter,
  cast( Document.WBSElementInternalID_2 as ps_psp_pnr preserving type ) AS WBSElementInternalID,
  Document.WBSElement AS WBSElement,
  Document.ProjectNetworkInternalID AS ProjectNetworkInternalID,
  Document.CommitmentItem AS CommitmentItem,
  Document.FundsCenter AS FundsCenter,
  Document.Fund AS Fund,
  Document.FunctionalArea AS FunctionalArea,
  Document.CreationDate AS CreationDate,
  Document.GoodsRecipientName AS GoodsRecipientName,
  cast( Document.REInternalFinNumber as imkey preserving type ) AS RealEstateObject,
  Document.NetworkActivityInternalID AS NetworkActivityInternalID,
  Document.PartnerAccountNumber AS PartnerAccountNumber,
  Document.JointVentureRecoveryCode AS JointVentureRecoveryCode,
  Document.SettlementReferenceDate AS SettlementReferenceDate,
  Document.OrderInternalID AS OrderInternalID,
  Document.OrderIntBillOfOperationsItem AS OrderIntBillOfOperationsItem,
  Document.EarmarkedFundsDocument AS EarmarkedFundsDocument,
  Document.EarmarkedFundsDocumentItem AS EarmarkedFundsDocumentItem,
  Document.CostCtrActivityType AS CostCtrActivityType,
  Document.BusinessProcess AS BusinessProcess,
  Document.GrantID AS GrantID,
  Document.ValidityDate AS ValidityDate,
  Document.ChartOfAccounts AS ChartOfAccounts,
  Document.BudgetPeriod AS BudgetPeriod,
  Document.FundedProgram AS FundedProgram,
  cast (' ' as vornr) AS NetworkActivity,
  cast ( '' as vdm_vornr ) AS PurReqnNetworkActivityForDsp,
  Document.CompanyCode AS CompanyCode,
  Document.PubSecSplitBatchNumberID AS PubSecSplitBatchNumberID,
  Document.PubSecSplitAuthznGroup AS PubSecSplitAuthznGroup
FROM I_PurchaseReqnAcctAssgmt AS Document
LEFT OUTER JOIN T_PurchaseReqnItem AS _PurchaseReqnItem ON _PurchaseReqnItem.PurchaseRequisition = PurchaseRequisition AND _PurchaseReqnItem.PurchaseRequisitionItem = PurchaseRequisitionItem  -- association [1..1]
LEFT OUTER JOIN T_PurchaseReqn AS _PurchaseReqn ON _PurchaseReqn.PurchaseRequisition = PurchaseRequisition  -- association [1..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementByInternalKey ON _WBSElementByInternalKey.WBSElementInternalID = WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_CommitmentItem AS _CommitmentItem ON _CommitmentItem.CommitmentItem = CommitmentItem  -- association [0..*]
;