I_PurReqnAccAssignment_WD

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_PurReqnAccAssignment_WD.
-- 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: IPRACCWD

CREATE VIEW I_PurReqnAccAssignment_WD AS
SELECT
  PurReqnAccAssignment.PurchaseRequisition AS PurchaseRequisition,
  PurReqnAccAssignment.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  PurReqnAccAssignment.PurchaseReqnAcctAssgmtNumber AS AccountAssignmentNumber,
  PurReqnAccAssignment.GLAccount AS GLAccount,
  MultipleAcctAssgmtDistrPercent,
  PurReqnAccAssignment.BaseUnit AS BaseUnit,
  PurReqnAccAssignment.PurReqnItemCurrency AS PurReqnItemCurrency,
  PurReqnAccAssignment.Quantity AS Quantity,
  PurReqnAccAssignment.PurReqnNetAmount AS PurReqnNetAmount,
  PurReqnAccAssignment.CostCenter AS CostCenter,
  cast(substring( cast(tstmp_current_utctimestamp() as abap.char( 17 ) ), 1, 8 ) as abap.dats ) AS ValidityEndDate,
  PurReqnAccAssignment.MasterFixedAsset AS MasterFixedAsset,
  PurReqnAccAssignment.FixedAsset AS FixedAsset,
  PurReqnAccAssignment.SDDocument AS SDDocument,
  PurReqnAccAssignment.SalesDocumentItem AS SalesDocumentItem,
  PurReqnAccAssignment.ScheduleLine AS ScheduleLine,
  PurReqnAccAssignment.OrderID AS OrderID,
  PurReqnAccAssignment.ProjectNetwork AS ProjectNetwork,
  PurReqnAccAssignment.ControllingArea AS ControllingArea,
  PurReqnAccAssignment.ProfitCenter AS ProfitCenter,
  PurReqnAccAssignment.Fund AS Fund,
  PurReqnAccAssignment.FundsCenter AS FundsCenter,
  PurReqnAccAssignment.FunctionalArea AS FunctionalArea,
  PurReqnAccAssignment.BusinessArea AS BusinessArea,
  case _Purchaserequisitionitem_Wd.ExtCompanyCodeForPurg when '' then _Purchaserequisitionitem_Wd.CompanyCode when ' ' then _Purchaserequisitionitem_Wd.CompanyCode else _Purchaserequisitionitem_Wd.ExtCompanyCodeForPurg end as CompanyCode AS ExtCompanyCodeForPurgendasCompanyCode,
  PurReqnAccAssignment.UnloadingPointName AS UnloadingPointName,
  PurReqnAccAssignment.ProfitabilitySegment AS ProfitabilitySegment,
  PurReqnAccAssignment.WBSElementInternalID AS WBSElementInternalID,
  cast ( ' ' as ps_posid ) AS WBSElement,
  PurReqnAccAssignment.ProjectNetworkInternalID AS ProjectNetworkInternalID,
  cast (' ' as mmpur_d_extvornr ) AS NetworkActivity,
  cast ( ' ' as vdm_vornr ) AS PurReqnNetworkActivityForDsp,
  cast ('' as abap.char(10) ) AS ProcurementHubSourceSystem,
  PurReqnAccAssignment.CommitmentItem AS CommitmentItem,
  _CommitmentItemShortID.CommitmentItem AS CommitmentItem_2,
  PurReqnAccAssignment.CommitmentItemShortID AS CommitmentItemShortID,
  PurReqnAccAssignment.GoodsRecipientName AS GoodsRecipientName,
  PurReqnAccAssignment.NetworkActivityInternalID AS NetworkActivityInternalID,
  PurReqnAccAssignment.OrderInternalID AS OrderInternalID,
  PurReqnAccAssignment.OrderIntBillOfOperationsItem AS OrderIntBillOfOperationsItem,
  PurReqnAccAssignment.EarmarkedFundsDocument AS EarmarkedFundsDocument,
  PurReqnAccAssignment.EarmarkedFundsDocumentItem AS EarmarkedFundsDocumentItem,
  PurReqnAccAssignment.BudgetPeriod AS BudgetPeriod,
  PurReqnAccAssignment.CostCtrActivityType AS CostCtrActivityType,
  PurReqnAccAssignment.FundedProgram AS FundedProgram,
  PurReqnAccAssignment.BusinessProcess AS BusinessProcess,
  PurReqnAccAssignment.GrantID AS GrantID,
  PurReqnAccAssignment._Employee.UserID AS BusinessUser,
  PurReqnAccAssignment.ServiceDocID AS ServiceDocID,
  PurReqnAccAssignment.ServiceDocItemID AS ServiceDocItemID,
  PurReqnAccAssignment.ServiceDocumentType AS ServiceDocumentType,
  cast ( ExtNetworkActivityForPurg as mmpur_d_extvornr ) AS ExtNetworkActivityForPurg,
  _ControllingArea.ChartOfAccounts AS ChartOfAccounts,
  _Purchaserequisition_Wd.PurReqnSSPAuthor AS PurReqnSSPAuthor,
  _Purchaserequisition_Wd.PurReqnSSPRequestor AS PurReqnSSPRequestor,
  PurReqnAccAssignment.ProcmtHubWBSElementExternalID AS ProcmtHubWBSElementExternalID,
  _WBSElementByInternalKey.WBSElementExternalID AS WBSElementExternalID
FROM I_PurReqnSSPAcctAssgmt AS PurReqnAccAssignment
LEFT OUTER JOIN I_Purchaserequisition_Wd AS _Purchaserequisition_Wd ON PurchaseRequisition = _Purchaserequisition_Wd.PurchaseRequisition  -- association [1..1]
LEFT OUTER JOIN I_Purchaserequisitionitem_Wd AS _Purchaserequisitionitem_Wd ON PurchaseRequisition = _Purchaserequisitionitem_Wd.PurchaseRequisition AND PurchaseRequisitionItem = _Purchaserequisitionitem_Wd.PurchaseRequisitionItem  -- association [1..1]
LEFT OUTER JOIN I_CostCenter AS _CostCenter ON CostCenter = _CostCenter.CostCenter AND ControllingArea = _CostCenter.ControllingArea AND ValidityEndDate <= _CostCenter.ValidityEndDate  -- association [0..1]
LEFT OUTER JOIN I_CostCenterText AS _CostCenterText ON ControllingArea = _CostCenterText.ControllingArea AND CostCenter = _CostCenterText.CostCenter AND ValidityEndDate <= _CostCenterText.ValidityEndDate  -- association [0..*]
LEFT OUTER JOIN I_FixedAsset AS _FixedAsset ON CompanyCode = _FixedAsset.CompanyCode AND FixedAsset = _FixedAsset.FixedAsset AND MasterFixedAsset = _FixedAsset.MasterFixedAsset  -- association [1]
LEFT OUTER JOIN I_MasterFixedAsset AS _MasterFixedAsset ON CompanyCode = _MasterFixedAsset.CompanyCode  -- association [0..*]
LEFT OUTER JOIN I_Fund AS _Fund ON Fund = _Fund.Fund  -- association [0..*]
LEFT OUTER JOIN I_FundsCenter AS _FundsCenter ON FundsCenter = _FundsCenter.FundsCenter  -- association [0..*]
LEFT OUTER JOIN I_GLAccount AS _GLAccount ON GLAccount = _GLAccount.GLAccount  -- association [0..*]
LEFT OUTER JOIN I_GlAccountTextInCompanycode AS _GlAccountTextInCompanycode ON CompanyCode = _GlAccountTextInCompanycode.CompanyCode AND GLAccount = _GlAccountTextInCompanycode.GLAccount  -- association [0..*]
LEFT OUTER JOIN I_InternalOrder AS _InternalOrder ON OrderID = _InternalOrder.InternalOrder  -- association [0..1]
LEFT OUTER JOIN I_SalesOrder AS _SalesOrder ON SDDocument = _SalesOrder.SalesOrder  -- association [0..1]
LEFT OUTER JOIN I_SalesOrderItem AS _SalesOrderItem ON SDDocument = _SalesOrderItem.SalesOrder AND SalesDocumentItem = _SalesOrderItem.SalesOrderItem  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_BusinessArea AS _BusinessArea ON BusinessArea = _BusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenter AS _ProfitCenter ON ProfitCenter = _ProfitCenter.ProfitCenter AND ControllingArea = _ProfitCenter.ControllingArea AND ValidityEndDate <= _ProfitCenter.ValidityEndDate  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenterText AS _ProfitCenterText ON ControllingArea = _ProfitCenterText.ControllingArea AND ProfitCenter = _ProfitCenterText.ProfitCenter AND ValidityEndDate <= _ProfitCenterText.ValidityEndDate  -- association [0..*]
LEFT OUTER JOIN I_FunctionalArea AS _FunctionalArea ON FunctionalArea = _FunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_BusinessProcess AS _BusinessProcess ON ControllingArea = _BusinessProcess.ControllingArea AND BusinessProcess = _BusinessProcess.BusinessProcess  -- association [0..1]
LEFT OUTER JOIN I_BusinessProcessText AS _BusinessProcessText ON ControllingArea = _BusinessProcessText.ControllingArea AND BusinessProcess = _BusinessProcessText.BusinessProcess AND ValidityEndDate <= _BusinessProcessText.ValidityEndDate  -- association [0..*]
LEFT OUTER JOIN I_BusinessAreaText AS _BusinessAreaText ON BusinessArea = _BusinessAreaText.BusinessArea  -- association [0..*]
LEFT OUTER JOIN I_FunctionalAreaText AS _FunctionalAreaText ON FunctionalArea = _FunctionalAreaText.FunctionalArea  -- association [0..*]
LEFT OUTER JOIN I_FundsCenterText AS _FundsCenterText ON FundsCenter = _FundsCenterText.FundsCenter AND ValidityEndDate = _FundsCenterText.ValidityEndDate  -- association [0..*]
LEFT OUTER JOIN I_FundText AS _FundText ON Fund = _FundText.Fund  -- association [0..*]
LEFT OUTER JOIN I_GLAccountText AS _GLAccountText ON GLAccount = _GLAccountText.GLAccount AND ChartOfAccounts = _GLAccountText.ChartOfAccounts  -- association [0..*]
LEFT OUTER JOIN I_CommitmentItemShortID AS _CommitmentItemShortID ON CommitmentItemShortID = _CommitmentItemShortID.CommitmentItemShortID  -- association [0..1]
LEFT OUTER JOIN I_FundedProgramStdVH AS _FundedProgramStdVH ON _FundedProgramStdVH.FundedProgram = FundedProgram  -- association [0..*]
LEFT OUTER JOIN I_MM_CostCenterValueHelp AS _MM_CostCenterValueHelp ON CostCenter = _MM_CostCenterValueHelp.CostCenter  -- association [0..*]
;