I_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_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.
-- SQL view name: IPRACCTASSGMT

CREATE VIEW I_PurReqnAcctAssgmt AS
SELECT
  PurchaseRequisition,
  PurchaseRequisitionItem,
  PurchaseReqnAcctAssgmtNumber,
  CostCenter,
  MasterFixedAsset,
  ProjectNetwork,
  Quantity,
  MultipleAcctAssgmtDistrPercent,
  cast ('' as abap.cuky) AS Currency,
  PurReqnNetAmount,
  IsDeleted,
  CostElement,
  GLAccount,
  BusinessArea,
  SDDocument,
  SalesOrder,
  SalesDocumentItem,
  SalesOrderItem,
  ScheduleLine,
  SalesOrderScheduleLine,
  FixedAsset,
  ProcessOrder,
  OrderID,
  UnloadingPointName,
  ControllingArea,
  CostObject,
  ProfitabilitySegment,
  ProfitCenter,
  cast( WBSElementInternalID_2 as ps_psp_pnr ) AS WBSElementInternalID,
  WBSElementInternalID_2,
  ProjectNetworkInternalID,
  cast(I_PurReqnAcctAssgmtBasic.CommitmentItemShortID as fipos) AS CommitmentItem,
  CommitmentItemShortID,
  FundsCenter,
  Fund,
  FunctionalArea,
  CreationDate,
  GoodsRecipientName,
  cast( I_PurReqnAcctAssgmtBasic.REInternalFinNumber as imkey preserving type ) AS RealEstateObject,
  REInternalFinNumber,
  NetworkActivityInternalID,
  PartnerAccountNumber,
  JointVentureRecoveryCode,
  SettlementReferenceDate,
  OrderInternalID,
  OrderIntBillOfOperationsItem,
  EarmarkedFundsDocument,
  EarmarkedFundsDocumentItem,
  CostCtrActivityType,
  BusinessProcess,
  GrantID,
  cast(substring( cast(tstmp_current_utctimestamp() as abap.char( 17 ) ), 1, 8 ) as abap.dats ) AS ValidityDate,
  BudgetPeriod,
  EarmarkedFundsDocumentItem AS EarmarkedFundsItem,
  ServiceDocID,
  ServiceDocItemID,
  ServiceDocumentType,
  cast (' ' as ps_s4_vornr) AS NetworkActivity,
  ExtNetworkActivityForPurg,
  ProcmtHubWBSElementExternalID,
  PubSecSplitBatchNumberID,
  PubSecSplitAuthznGroup,
  _ControllingArea.ChartOfAccounts AS ChartOfAccounts,
  _WBSElementBasicData.WBSElement AS WBSElementExternalID,
  _WBSElementBasicData.WBSElementExternalID AS WBSElementExternalID_2,
  _WBSElementBasicData.WBSElement AS WBSElement
FROM I_PurReqnAcctAssgmtBasic
LEFT OUTER JOIN I_CostCenter AS _CostCenter ON CostCenter = _CostCenter.CostCenter AND ControllingArea = _CostCenter.ControllingArea AND ValidityDate <= _CostCenter.ValidityEndDate  -- association [0..1]
LEFT OUTER JOIN I_CostCenterText AS _CostCenterText ON CostCenter = _CostCenterText.CostCenter AND ControllingArea = _CostCenterText.ControllingArea AND ValidityDate <= _CostCenterText.ValidityEndDate  -- association [0..*]
LEFT OUTER JOIN I_GLAccount AS _GLAccount ON GLAccount = _GLAccount.GLAccount  -- association [0..*]
LEFT OUTER JOIN I_GLAccountText AS _GLAccountText ON GLAccount = _GLAccountText.GLAccount AND ChartOfAccounts = _GLAccountText.ChartOfAccounts  -- association [0..*]
LEFT OUTER JOIN I_BusinessArea AS _BusinessArea ON BusinessArea = _BusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_BusinessAreaText AS _BusinessAreaText ON BusinessArea = _BusinessAreaText.BusinessArea  -- association [0..*]
LEFT OUTER JOIN I_ProfitCenter AS _ProfitCenter ON ControllingArea = _ProfitCenter.ControllingArea AND ProfitCenter = _ProfitCenter.ProfitCenter AND ValidityDate <= _ProfitCenter.ValidityEndDate  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenterText AS _ProfitCenterText ON ControllingArea = _ProfitCenterText.ControllingArea AND ProfitCenter = _ProfitCenterText.ProfitCenter AND ValidityDate <= _ProfitCenterText.ValidityEndDate  -- 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_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_SalesDocumentScheduleLine AS _SalesDocumentScheduleLine ON SalesOrder = _SalesDocumentScheduleLine.SalesDocument AND SalesOrderItem = _SalesDocumentScheduleLine.SalesDocumentItem AND SalesOrderScheduleLine = _SalesDocumentScheduleLine.ScheduleLine  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementByInternalKey ON WBSElementInternalID = _WBSElementByInternalKey.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasicData ON WBSElementInternalID_2 = _WBSElementBasicData.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_FunctionalArea AS _FunctionalArea ON FunctionalArea = _FunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_FunctionalAreaText AS _FunctionalAreaText ON FunctionalArea = _FunctionalAreaText.FunctionalArea  -- association [0..*]
LEFT OUTER JOIN I_CostCenterActivityType AS _CostCenterActivityType ON ControllingArea = _CostCenterActivityType.ControllingArea AND CostCtrActivityType = _CostCenterActivityType.CostCtrActivityType AND ValidityDate <= _CostCenterActivityType.ValidityEndDate  -- association [0..1]
LEFT OUTER JOIN I_CostCenterActivityTypeText AS _CostCenterActivityTypeText ON ControllingArea = _CostCenterActivityTypeText.ControllingArea AND CostCtrActivityType = _CostCenterActivityTypeText.CostCtrActivityType AND ValidityDate <= _CostCenterActivityTypeText.ValidityEndDate  -- association [0..*]
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 ValidityDate <= _BusinessProcessText.ValidityEndDate  -- association [0..*]
LEFT OUTER JOIN I_FixedAsset AS _FixedAssetWorklist ON MasterFixedAsset = _FixedAssetWorklist.MasterFixedAsset AND FixedAsset = _FixedAssetWorklist.FixedAsset  -- association [0..*]
LEFT OUTER JOIN I_FixedAsset AS _FixedAsset ON MasterFixedAsset = _FixedAsset.MasterFixedAsset AND FixedAsset = _FixedAsset.FixedAsset  -- association [0..*]
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]
LEFT OUTER JOIN I_BudgetPeriod AS _BudgetPeriod ON BudgetPeriod = _BudgetPeriod.BudgetPeriod  -- association [1..1]
LEFT OUTER JOIN I_BudgetPeriodText AS _BudgetPeriodText ON BudgetPeriod = _BudgetPeriodText.BudgetPeriod  -- association [0..*]
LEFT OUTER JOIN I_FundStdVH AS _FundStdVH ON _FundStdVH.Fund = Fund  -- association [0..*]
LEFT OUTER JOIN I_BudgetPeriodStdVH AS _BudgetPeriodStdVH ON _BudgetPeriodStdVH.BudgetPeriod = BudgetPeriod  -- association [0..1]
LEFT OUTER JOIN I_FundsCenterStdVH AS _FundsCenterStdVH ON _FundsCenterStdVH.FundsCenter = FundsCenter  -- association [0..*]
LEFT OUTER JOIN I_CommitmentItemStdVH AS _CommitmentItemStdVH ON _CommitmentItemStdVH.CommitmentItem = CommitmentItem  -- association [0..*]
LEFT OUTER JOIN I_EarmarkedFundsStdVH AS _EarmarkedFundsStdVH ON _EarmarkedFundsStdVH.EarmarkedFunds = EarmarkedFundsDocument AND _EarmarkedFundsStdVH.EarmarkedFundsItem = EarmarkedFundsDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_FndsMgmtFuncnlAreaStdVH AS _FndsMgmtFuncnlAreaStdVH ON _FndsMgmtFuncnlAreaStdVH.FunctionalArea = FunctionalArea  -- association [0..1]
;