I_PurReqnAcctAssgmt_Api01

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_PurReqnAcctAssgmt_Api01.
-- 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: IPRACCASGMTAPI01

CREATE VIEW I_PurReqnAcctAssgmt_Api01 AS
SELECT
  I_PurReqnAcctAssgmt.PurchaseRequisition AS PurchaseRequisition,
  I_PurReqnAcctAssgmt.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  I_PurReqnAcctAssgmt.PurchaseReqnAcctAssgmtNumber AS PurchaseReqnAcctAssgmtNumber,
  I_PurReqnAcctAssgmt.CostCenter AS CostCenter,
  I_PurReqnAcctAssgmt.MasterFixedAsset AS MasterFixedAsset,
  I_PurReqnAcctAssgmt.ProjectNetwork AS ProjectNetwork,
  I_PurReqnAcctAssgmt.Quantity AS Quantity,
  _PurchaseRequisition_Api01.BaseUnit AS BaseUnit,
  I_PurReqnAcctAssgmt.MultipleAcctAssgmtDistrPercent AS MultipleAcctAssgmtDistrPercent,
  I_PurReqnAcctAssgmt.PurReqnNetAmount AS PurReqnNetAmount,
  _PurchaseRequisition_Api01.PurReqnItemCurrency AS PurReqnItemCurrency,
  I_PurReqnAcctAssgmt.IsDeleted AS IsDeleted,
  I_PurReqnAcctAssgmt.CostElement AS CostElement,
  I_PurReqnAcctAssgmt.GLAccount AS GLAccount,
  I_PurReqnAcctAssgmt.BusinessArea AS BusinessArea,
  I_PurReqnAcctAssgmt.SDDocument AS SDDocument,
  I_PurReqnAcctAssgmt.SalesOrder AS SalesOrder,
  I_PurReqnAcctAssgmt.SalesDocumentItem AS SalesDocumentItem,
  I_PurReqnAcctAssgmt.SalesOrderItem AS SalesOrderItem,
  I_PurReqnAcctAssgmt.ScheduleLine AS ScheduleLine,
  I_PurReqnAcctAssgmt.SalesOrderScheduleLine AS SalesOrderScheduleLine,
  I_PurReqnAcctAssgmt.FixedAsset AS FixedAsset,
  I_PurReqnAcctAssgmt.ProcessOrder AS ProcessOrder,
  I_PurReqnAcctAssgmt.OrderID AS OrderID,
  I_PurReqnAcctAssgmt.UnloadingPointName AS UnloadingPointName,
  I_PurReqnAcctAssgmt.ControllingArea AS ControllingArea,
  I_PurReqnAcctAssgmt.CostObject AS CostObject,
  cast(I_PurReqnAcctAssgmt.ProfitabilitySegment as rkeobjnr_numc ) AS ProfitabilitySegment,
  cast(I_PurReqnAcctAssgmt.ProfitabilitySegment as rkeobjnr_char ) AS ProfitabilitySegment_2,
  I_PurReqnAcctAssgmt.ProfitCenter AS ProfitCenter,
  I_PurReqnAcctAssgmt.WBSElementInternalID AS WBSElementInternalID,
  I_PurReqnAcctAssgmt.ProjectNetworkInternalID AS ProjectNetworkInternalID,
  I_PurReqnAcctAssgmt.CommitmentItem AS CommitmentItem,
  I_PurReqnAcctAssgmt.FundsCenter AS FundsCenter,
  I_PurReqnAcctAssgmt.Fund AS Fund,
  I_PurReqnAcctAssgmt.FunctionalArea AS FunctionalArea,
  I_PurReqnAcctAssgmt.CreationDate AS CreationDate,
  I_PurReqnAcctAssgmt.GoodsRecipientName AS GoodsRecipientName,
  I_PurReqnAcctAssgmt.RealEstateObject AS RealEstateObject,
  I_PurReqnAcctAssgmt.NetworkActivityInternalID AS NetworkActivityInternalID,
  I_PurReqnAcctAssgmt.PartnerAccountNumber AS PartnerAccountNumber,
  I_PurReqnAcctAssgmt.JointVentureRecoveryCode AS JointVentureRecoveryCode,
  I_PurReqnAcctAssgmt.SettlementReferenceDate AS SettlementReferenceDate,
  I_PurReqnAcctAssgmt.OrderInternalID AS OrderInternalID,
  I_PurReqnAcctAssgmt.OrderIntBillOfOperationsItem AS OrderIntBillOfOperationsItem,
  I_PurReqnAcctAssgmt.EarmarkedFundsDocument AS EarmarkedFundsDocument,
  I_PurReqnAcctAssgmt.CostCtrActivityType AS CostCtrActivityType,
  I_PurReqnAcctAssgmt.BusinessProcess AS BusinessProcess,
  I_PurReqnAcctAssgmt.GrantID AS GrantID,
  I_PurReqnAcctAssgmt.ValidityDate AS ValidityDate,
  I_PurReqnAcctAssgmt.ChartOfAccounts AS ChartOfAccounts,
  I_PurReqnAcctAssgmt.WBSElement AS WBSElement,
  _PurchaseRequisition_Api01.PurchaseRequisitionType AS PurchaseRequisitionType,
  _PurchaseRequisition_Api01.Plant AS Plant,
  _PurchaseRequisition_Api01.PurchasingOrganization AS PurchasingOrganization,
  _PurchaseRequisition_Api01.PurchasingGroup AS PurchasingGroup
FROM I_PurReqnAcctAssgmt
LEFT OUTER JOIN I_PurchaseRequisition_Api01 AS _PurchaseRequisition_Api01 ON PurchaseRequisition = _PurchaseRequisition_Api01.PurchaseRequisition AND PurchaseRequisitionItem = _PurchaseRequisition_Api01.PurchaseRequisitionItem  -- association [0..1]
;