R_PPS_PurOrdAccountAssignment

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 R_PPS_PurOrdAccountAssignment.
-- 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 R_PPS_PurOrdAccountAssignment AS
SELECT
  cast (PurchasingDocument as vdm_purchaseorder preserving type) AS PurchaseOrder,
  cast (PurchasingDocumentItem as vdm_purchaseorderitem preserving type) AS PurchaseOrderItem,
  AccountAssignmentNumber,
  PurchasingDocument,
  PurchasingDocumentItem,
  _PurchasingDocumentItem.AccountAssignmentCategory AS AccountAssignmentCategory,
  CostCenter,
  MasterFixedAsset,
  ProjectNetwork,
  OrderQuantityUnit,
  Quantity,
  cast (' ' as ps_s4_vornr) AS NetworkActivity,
  MultipleAcctAssgmtDistrPercent AS PPSMultiAcctAssgmtDistrPct,
  cast (' ' as pps_e_boolean_values ) AS IsMultipleAccountAssignment,
  DocumentCurrency,
  PurgDocNetAmount,
  IsDeleted,
  GLAccount,
  BusinessArea,
  SalesOrder,
  cast(SalesOrderItem as pps_e_salesorderitem preserving type ) AS SalesOrderItem,
  SalesOrderScheduleLine,
  FixedAsset,
  OrderID,
  cast ('' as vdm_vornr ) AS OrderOperation,
  UnloadingPointName,
  ControllingArea,
  CostObject,
  ProfitabilitySegment,
  ProfitCenter,
  cast( WBSElementInternalID as ps_s4_pspnr preserving type ) AS WBSElementInternalID,
  _WBSElement.WBSElementExternalID AS WBSElementExternalID,
  ProjectNetworkInternalID,
  _CommitmentItemShortID.CommitmentItem AS CommitmentItem,
  CommitmentItemShortID,
  FundsCenter,
  Fund,
  FunctionalArea,
  GoodsRecepientName AS GoodsRecipientName,
  IsFinallyInvoiced,
  cast( REInternalFinNumber as recaimkeyfi preserving type ) AS RealEstateObject,
  NetworkActivityInternalID,
  PartnerAccountNumber,
  JointVentureRecoveryCode,
  SettlementReferenceDate,
  OrderInternalID,
  OrderIntBillOfOperationsItem,
  TaxCode,
  TaxJurisdiction,
  NonDeductibleInputTaxAmount,
  CostCtrActivityType,
  BusinessProcess,
  GrantID,
  BudgetPeriod,
  USFedGovernmentUUID,
  EarmarkedFundsDocument,
  EarmarkedFundsDocumentItem,
  cast( '' as abap.char( 510 ) ) AS PPSFieldChangeIndicatorString,
  $session.system_date AS ValidityDate,
  ServiceDocumentType,
  ServiceDocument,
  ServiceDocumentItem,
  CreationDate,
  IsAcctLineFinal,
  AcctLineFinalReason,
  _PurchasingDocumentItem._PurchasingDocument.CompanyCode AS CompanyCode,
  _PurchasingDocumentItem._PurchasingDocument._CompanyCode.FinancialManagementArea AS FinancialManagementArea,
  _AccAssignmentExtension.PPSBdgtPeriodValdtyEndDateCat AS PPSBdgtPeriodValdtyEndDateCat,
  _AccAssignmentExtension.PPSAccountAssignmentIsUnfunded AS PPSAccountAssignmentIsUnfunded,
  _AccAssignmentExtension.PPSAcctAsgtRefNmbr AS PPSAcctAsgtRefNmbr,
  _AccAssignmentExtension.PPSAcctAsgtSublineItmNmbr AS PPSAcctAsgtSublineItmNmbr
FROM I_PurgDocAccountAssignmentBsc
LEFT OUTER JOIN I_PurchaseOrder AS _PurchaseOrder ON PurchaseOrder = _PurchaseOrder.PurchaseOrder  -- association [1..1]
LEFT OUTER JOIN I_PurchaseOrderItem AS _PurchaseOrderItem ON PurchaseOrder = _PurchaseOrderItem.PurchaseOrder AND PurchaseOrderItem = _PurchaseOrderItem.PurchaseOrderItem  -- association [1..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElement ON _WBSElement.WBSElementInternalID = WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN R_PPS_PurgDocAcctAssgmtExtn AS _AccAssignmentExtension ON PurchaseOrder = _AccAssignmentExtension.PurchaseOrder AND PurchaseOrderItem = _AccAssignmentExtension.PurchaseOrderItem AND AccountAssignmentNumber = _AccAssignmentExtension.PPSPurgDocAcctAssgmtNumber  -- association [1..1]
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_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 _BusinessProcessText.ValidityEndDate >= $session.system_date  -- association [0..*]
LEFT OUTER JOIN I_CommitmentItemShortID AS _CommitmentItemShortID ON CommitmentItemShortID = _CommitmentItemShortID.CommitmentItemShortID  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _CostCenter ON CostCenter = _CostCenter.CostCenter AND ControllingArea = _CostCenter.ControllingArea AND _CostCenter.ValidityEndDate >= $session.system_date AND _CostCenter.ValidityStartDate <= $session.system_date  -- association [0..1]
LEFT OUTER JOIN I_CostCenterActivityType AS _CostCenterActivityType ON ControllingArea = _CostCenterActivityType.ControllingArea AND CostCtrActivityType = _CostCenterActivityType.CostCtrActivityType AND _CostCenterActivityType.ValidityEndDate >= $session.system_date AND _CostCenterActivityType.ValidityStartDate <= $session.system_date  -- association [0..1]
LEFT OUTER JOIN I_CostCenterActivityTypeText AS _CostCenterActivityTypeText ON ControllingArea = _CostCenterActivityTypeText.ControllingArea AND CostCtrActivityType = _CostCenterActivityTypeText.CostCtrActivityType AND _CostCenterActivityTypeText.ValidityEndDate >= $session.system_date  -- association [0..*]
LEFT OUTER JOIN I_CostCenterText AS _CostCenterText ON CostCenter = _CostCenterText.CostCenter AND ControllingArea = _CostCenterText.ControllingArea AND _CostCenterText.ValidityEndDate >= $session.system_date AND _CostCenterText.ValidityStartDate <= $session.system_date  -- association [0..*]
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_GLAccount AS _GLAccount ON GLAccount = _GLAccount.GLAccount  -- association [0..*]
LEFT OUTER JOIN I_GlAccountTextInCompanycode AS _GLAccountText ON GLAccount = _GLAccountText.GLAccount AND companycode = _GLAccountText.CompanyCode  -- association [0..*]
LEFT OUTER JOIN I_ProfitCenter AS _ProfitCenter ON ControllingArea = _ProfitCenter.ControllingArea AND ProfitCenter = _ProfitCenter.ProfitCenter AND _ProfitCenter.ValidityEndDate >= $session.system_date AND _ProfitCenter.ValidityStartDate <= $session.system_date  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenterText AS _ProfitCenterText ON ControllingArea = _ProfitCenterText.ControllingArea AND ProfitCenter = _ProfitCenterText.ProfitCenter AND _ProfitCenterText.ValidityEndDate >= $session.system_date  -- association [0..*]
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_SalesOrder AS _SalesOrder ON SalesOrder = _SalesOrder.SalesOrder  -- association [0..1]
LEFT OUTER JOIN I_SalesOrderItem AS _SalesOrderItem ON SalesOrderItem = _SalesOrderItem.SalesOrderItem AND SalesOrder = _SalesOrderItem.SalesOrder  -- association [0..1]
LEFT OUTER JOIN I_TaxCode AS _TaxCode ON TaxCode = _TaxCode.TaxCode  -- association [0..*]
LEFT OUTER JOIN I_TaxCodeText AS _TaxCodeText ON TaxCode = _TaxCodeText.TaxCode  -- association [0..*]
LEFT OUTER JOIN I_TaxJurisdiction AS _TaxJurisdiction ON TaxJurisdiction = _TaxJurisdiction.TaxJurisdiction  -- association [0..*]
LEFT OUTER JOIN I_TaxJurisdictionText AS _TaxJurisdictionText ON TaxJurisdiction = _TaxJurisdictionText.TaxJurisdiction  -- association [0..*]
LEFT OUTER JOIN I_WBSElementByInternalKey AS _WBSElementByInternalKey ON WBSElementInternalID = _WBSElementByInternalKey.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_Fund AS _Fund ON _Fund.Fund = Fund AND _Fund.FinancialManagementArea = FinancialManagementArea AND _Fund.ValidityEndDate > $session.system_date  -- association [0..1]
LEFT OUTER JOIN I_FundsCenter AS _FundsCenter ON _FundsCenter.FundsCenter = FundsCenter AND _FundsCenter.ValidityEndDate > $session.system_date AND _FundsCenter.FinancialManagementArea = FinancialManagementArea  -- association [0..1]
LEFT OUTER JOIN I_BudgetPeriod AS _BudgetPeriodStdVH ON _BudgetPeriodStdVH.BudgetPeriod = BudgetPeriod  -- association [0..1]
LEFT OUTER JOIN I_ProjectNetwork AS _ProjectNetwork ON ProjectNetwork = _ProjectNetwork.ProjectNetwork  -- association [0..1]
LEFT OUTER JOIN I_NetworkActivity AS _NetworkActivity ON NetworkActivity = _NetworkActivity.NetworkActivity  -- association [0..*]
LEFT OUTER JOIN I_Order AS _OrderId ON OrderID = _OrderId.OrderID  -- association [0..1]
LEFT OUTER JOIN I_Grant AS _GrantId ON GrantID = _GrantId.GrantID  -- association [0..1]
LEFT OUTER JOIN I_OrderOperationBasic AS _NetworkActivityDescription ON NetworkActivity = _NetworkActivityDescription.Operation_2 AND _NetworkActivityDescription.Language = $session.system_language  -- association [0..1]
;