C_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 C_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 C_PPS_PurOrdAcctAssignmentTP AS
SELECT
  PurchaseOrder,
  PurchaseOrderItem,
  AccountAssignmentNumber,
  PurchasingDocument,
  PurchasingDocumentItem,
  AccountAssignmentForEdit,
  CostCenter,
  _PurchaseOrderItem._AccountAssignmentCatText.AcctAssignmentCategoryName : localized AS AcctAssignmentCategoryNamelocalized,
  MasterFixedAsset,
  ProjectNetwork,
  cast(NetworkActivity as pps_e_network_activity preserving type) AS NetworkActivity,
  _PurchaseOrderItem.PurchaseOrderQuantityUnit AS PurchaseOrderQuantityUnit,
  OrderQuantityUnit,
  Quantity,
  DocumentCurrency,
  PurgDocNetAmount,
  PPSMultiAcctAssgmtDistrPct,
  IsDeleted,
  GLAccount,
  BusinessArea,
  SalesOrder,
  SalesOrderItem,
  SalesOrderScheduleLine,
  FixedAsset,
  OrderID,
  UnloadingPointName,
  ControllingArea,
  CostObject,
  ProfitabilitySegment,
  ProfitCenter,
  WBSElementInternalID,
  WBSElementExternalID,
  ProjectNetworkInternalID,
  _PurchaseOrder._CompanyCode.ChartOfAccounts AS ChartOfAccounts,
  FinancialManagementArea,
  cast(FundsCenter as pps_e_funds_center preserving type) AS FundsCenter,
  _FundsCenter._Text[1: Language = $session.system_language].FundsCenterName AS FundsCenterName,
  _FundsCenter[1: FinancialManagementArea = FinancialManagementArea]._Text[1: FinancialManagementArea = FinancialManagementArea and Language = $session.system_language].FundsCenterDescription AS FundsCenterDescription,
  Fund,
  _Fund._Text[1: Language = $session.system_language].FundName AS FundName,
  _Fund[1: FinancialManagementArea = FinancialManagementArea]._Text[1: Language = $session.system_language].FundDescription AS FundDescription,
  FunctionalArea,
  GoodsRecipientName,
  IsFinallyInvoiced,
  NetworkActivityInternalID,
  PartnerAccountNumber,
  JointVentureRecoveryCode,
  SettlementReferenceDate,
  OrderInternalID,
  OrderIntBillOfOperationsItem,
  TaxCode,
  TaxJurisdiction,
  CostCtrActivityType,
  BusinessProcess,
  GrantID,
  BudgetPeriod,
  USFedGovernmentUUID,
  EarmarkedFundsDocument,
  EarmarkedFundsDocumentItem,
  ValidityDate,
  ServiceDocumentType,
  ServiceDocument,
  ServiceDocumentItem,
  CreationDate,
  IsAcctLineFinal,
  AcctLineFinalReason,
  _PurchaseOrderItem.CompanyCode AS CompanyCode,
  PPSAccountAssignmentIsUnfunded,
  _WBSElement.WBSDescription AS WBSDescription,
  _CostCenterText[1: Language = $session.system_language].CostCenterDescription AS CostCenterDescription,
  _CostCenterActivityTypeText[1: Language = $session.system_language].CostCtrActivityTypeDesc AS CostCtrActivityTypeDesc,
  virtual LeadingObjectDescription : abap.char(60) AS char60,
  _PurchaseOrderItem.AccountAssignmentCategory AS AccountAssignmentCategory,
  CommitmentItem,
  _PurchaseOrderItem.PurchaseContractItem AS PurchaseContractItem,
  _PurchaseOrderItem.MultipleAcctAssgmtDistribution AS MultipleAcctAssgmtDistribution,
  virtual UICT_CostCenter : boolean AS virtualUICT_CostCenterboolean,
  virtual UICT_OrderID : boolean AS virtualUICT_OrderIDboolean,
  virtual UICT_NetworkActivity : boolean AS virtualUICT_NetworkActivityboolean,
  virtual UICT_WBSElementInternalID : boolean AS virtualUICT_WBSElementInternalIDboolean,
  virtual UICT_ProjectNetwork : boolean AS virtualUICT_ProjectNetworkboolean,
  virtual UICT_MasterFixedAsset : boolean AS virtualUICT_MasterFixedAssetboolean,
  virtual UICT_FixedAsset : boolean AS virtualUICT_FixedAssetboolean,
  virtual UICT_BusinessArea : boolean AS virtualUICT_BusinessAreaboolean,
  virtual UICT_GLAccount : boolean AS virtualUICT_GLAccountboolean,
  virtual UICT_ControllingArea : boolean AS virtualUICT_ControllingAreaboolean,
  virtual UICT_Fund : boolean AS virtualUICT_Fundboolean,
  virtual UICT_FundsCenter : boolean AS virtualUICT_FundsCenterboolean,
  virtual UICT_CommitmentItem : boolean AS virtualUICT_CommitmentItemboolean,
  virtual UICT_EarmarkedFundsItem : boolean AS virtualUICT_EarmarkedFundsItemboolean,
  virtual UICT_FunctionalArea : boolean AS virtualUICT_FunctionalAreaboolean,
  virtual UICT_GrantID : boolean AS virtualUICT_GrantIDboolean,
  virtual UICT_BudgetPeriod : boolean AS virtualUICT_BudgetPeriodboolean,
  virtual UICT_Quantity : boolean AS virtualUICT_Quantityboolean,
  virtual UICT_PurgDocNetAmount : boolean AS virtualUICT_PurgDocNetAmountboolean,
  virtual PPSPurgDocNetAmount : bwert AS virtualPPSPurgDocNetAmountbwert,
  virtual PPSDspMultiAccAssDistrPct : abap.dec(4,1) AS dec41,
  virtual UICT_SalesOrder : boolean AS virtualUICT_SalesOrderboolean,
  _PurchaseOrderItem.NetAmount AS NetAmount,
  PPSAcctAsgtRefNmbr,
  PPSAcctAsgtSublineItmNmbr,
  cast(_PurchaseOrderItem._CompanyCode.FinancialManagementArea as fikrs preserving type) AS FundsCenterFinMgmtArea,
  _PurchaseOrderItem.PurchaseContract AS PurchaseContract
FROM R_PPS_PurOrdAcctAssignmentTP
LEFT OUTER JOIN I_MM_SalesOrderItemVH AS _SalesOrderItemValueHelp ON SalesOrderItem = _SalesOrderItemValueHelp.SalesOrderItem AND SalesOrder = _SalesOrderItemValueHelp.SalesOrder  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
;