R_PPS_PurOrdAcctAssignmentTP

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_PurOrdAcctAssignmentTP.
-- 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_PurOrdAcctAssignmentTP AS
SELECT
  PurchaseOrder,
  PurchaseOrderItem,
  AccountAssignmentNumber,
  PurchasingDocument,
  PurchasingDocumentItem,
  AccountAssignmentCategory,
  AccountAssignmentNumber AS AccountAssignmentForEdit,
  CostCenter,
  MasterFixedAsset,
  ProjectNetwork,
  NetworkActivity,
  PPSMultiAcctAssgmtDistrPct,
  OrderQuantityUnit,
  Quantity,
  cast (IsMultipleAccountAssignment as pps_e_multipleaccountassign preserving type ) AS IsMultipleAccountAssignment,
  cast( DocumentCurrency as pps_e_docu_currency preserving type ) AS DocumentCurrency,
  PurgDocNetAmount,
  IsDeleted,
  GLAccount,
  BusinessArea,
  SalesOrder,
  SalesOrderItem,
  SalesOrderScheduleLine,
  FixedAsset,
  OrderID,
  OrderOperation,
  UnloadingPointName,
  ControllingArea,
  CostObject,
  ProfitabilitySegment,
  ProfitCenter,
  WBSElementExternalID,
  ProjectNetworkInternalID,
  CommitmentItemShortID,
  FundsCenter,
  Fund,
  RealEstateObject,
  WBSElementInternalID,
  FunctionalArea,
  GoodsRecipientName,
  IsFinallyInvoiced,
  cast(NetworkActivityInternalID as pps_e_networkactivityid preserving type ) AS NetworkActivityInternalID,
  PartnerAccountNumber,
  JointVentureRecoveryCode,
  SettlementReferenceDate,
  cast(OrderInternalID as pps_e_orderinternalid preserving type ) AS OrderInternalID,
  OrderIntBillOfOperationsItem,
  TaxCode,
  TaxJurisdiction,
  NonDeductibleInputTaxAmount,
  CostCtrActivityType,
  BusinessProcess,
  GrantID,
  CommitmentItem,
  BudgetPeriod,
  USFedGovernmentUUID,
  EarmarkedFundsDocument,
  EarmarkedFundsDocumentItem,
  ValidityDate,
  cast ( hextobin( PPSFieldChangeIndicatorString ) as pps_e_control_flag preserving type ) AS PPSFieldChangeIndicatorBinary,
  ServiceDocumentType,
  ServiceDocument,
  ServiceDocumentItem,
  CreationDate,
  IsAcctLineFinal,
  AcctLineFinalReason,
  CompanyCode,
  FinancialManagementArea,
  R_PPS_PurOrdAccountAssignment._PurchaseOrderItem AS _PurchaseOrderItem_2,
  PPSBdgtPeriodValdtyEndDateCat,
  PPSAccountAssignmentIsUnfunded,
  PPSAcctAsgtRefNmbr,
  PPSAcctAsgtSublineItmNmbr,
  cast(_BudgetPeriodStdVH.ValidityEndDate as pps_e_validity_end_dte preserving type ) AS ValidityEndDate
FROM R_PPS_PurOrdAccountAssignment
LEFT OUTER JOIN R_PPS_PurchaseOrderTP AS _PurchaseOrder ON PurchaseOrder = _PurchaseOrder.PurchaseOrder  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_FixedAsset AS _FixedAsset ON FixedAsset = _FixedAsset.FixedAsset AND MasterFixedAsset = _FixedAsset.MasterFixedAsset AND CompanyCode = _FixedAsset.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_AcctAssignmentCategoryText AS _AccountAssignmentCatText ON AccountAssignmentCategory = _AccountAssignmentCatText.AccountAssignmentCategory AND _AccountAssignmentCatText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CommitmentItemText AS _CommitmentItemText ON CommitmentItem = _CommitmentItemText.CommitmentItem AND FinancialManagementArea = _CommitmentItemText.FinancialManagementArea AND _CommitmentItemText.FinMgmtAreaFiscalYear = '0000' AND _CommitmentItemText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ServiceDocumentTypeText AS _ServiceDocumentTypeText ON ServiceDocumentType = _ServiceDocumentTypeText.ServiceDocumentType  -- association [1..*]
LEFT OUTER JOIN I_PPSBdgtPerdValdtyEndDteCat AS _BdgtPerdValdtyEndDteCat ON PPSBdgtPeriodValdtyEndDateCat = _BdgtPerdValdtyEndDteCat.PPSBdgtPeriodValdtyEndDateCat AND _BdgtPerdValdtyEndDteCat.Language = $session.system_language  -- association [0..1]
;