R_PurOrdAccountAssignmentTP

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_PurOrdAccountAssignmentTP.
-- 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_PurOrdAccountAssignmentTP AS
SELECT
  PurchaseOrder,
  PurchaseOrderItem,
  AccountAssignmentNumber,
  PurchasingDocument,
  PurchasingDocumentItem,
  CostCenter,
  MasterFixedAsset,
  ProjectNetwork,
  cast( NetworkActivity as ps_s4_vornr preserving type ) AS NetworkActivity,
  OrderQuantityUnit,
  Quantity,
  MultipleAcctAssgmtDistrPercent,
  DocumentCurrency,
  PurgDocNetAmount,
  IsDeleted,
  GLAccount,
  BusinessArea,
  SalesOrder,
  SalesOrderItem,
  SalesOrderScheduleLine,
  FixedAsset,
  OrderID,
  UnloadingPointName,
  ControllingArea,
  CostObject,
  ProfitabilitySegment_2 AS ProfitabilitySegment,
  ProfitCenter,
  cast( WBSElementInternalID as ps_s4_pspnr preserving type ) AS WBSElementInternalID,
  WBSElementExternalID,
  ProjectNetworkInternalID,
  CommitmentItemShortID,
  FundsCenter,
  Fund,
  FunctionalArea,
  LastChangedDate,
  GoodsRecipientName,
  IsFinallyInvoiced,
  NetworkActivityInternalID,
  PartnerAccountNumber,
  JointVentureRecoveryCode,
  SettlementReferenceDate,
  OrderInternalID,
  OrderIntBillOfOperationsItem,
  TaxCode,
  TaxJurisdiction,
  NonDeductibleInputTaxAmount,
  CostCtrActivityType,
  BusinessProcess,
  GrantID,
  BudgetPeriod,
  EarmarkedFundsDocument,
  EarmarkedFundsDocumentItem,
  ValidityDate,
  ChartOfAccounts,
  ServiceDocumentType,
  ServiceDocument,
  ServiceDocumentItem,
  CreationDate,
  IsAcctLineFinal,
  AcctLineFinalReason,
  CompanyCode
FROM I_PurOrdAccountAssignment AS _PurOrdAccountAssignmentTP
LEFT OUTER JOIN R_PurchaseOrderTP AS _PurchaseOrder ON PurchaseOrder = _PurchaseOrder.PurchaseOrder  -- association [1..1]
LEFT OUTER JOIN E_PurgDocAccountAssignment AS _PurOrdAcctAssgmtExtension ON PurchaseOrder = _PurOrdAcctAssgmtExtension.PurchasingDocument AND PurchaseOrderItem = _PurOrdAcctAssgmtExtension.PurchasingDocumentItem AND AccountAssignmentNumber = _PurOrdAcctAssgmtExtension.AccountAssignmentNumber  -- association [0..1]
;