C_PPS_DrctPurOrdAcctAssgmtTP_2

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_DrctPurOrdAcctAssgmtTP_2.
-- 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_DrctPurOrdAcctAssgmtTP_2 AS
SELECT
  PurchaseOrder,
  PurchaseOrderItem,
  AccountAssignmentNumber,
  PurchasingDocument,
  PurchasingDocumentItem,
  AccountAssignmentForEdit,
  CostCenter,
  _AccountAssignmentCatText.AcctAssignmentCategoryName AS AcctAssignmentCategoryName,
  MasterFixedAsset,
  ProjectNetwork,
  _ProjectNetwork[1:ProjectNetwork = ProjectNetwork].ProjectNetworkDescription AS ProjectNetworkDescription,
  cast ( NetworkActivity as pps_e_network_activity preserving type ) AS NetworkActivity,
  _NetworkActivityDescription.OperationText AS NetworkActivityDescription,
  _PurchaseOrderItem.PurchaseOrderQuantityUnit AS PurchaseOrderQuantityUnit,
  OrderQuantityUnit,
  Quantity,
  DocumentCurrency,
  PurgDocNetAmount,
  PPSMultiAcctAssgmtDistrPct,
  IsDeleted,
  _GLAccountText[1: Language = $session.system_language].GLAccountName AS GLAccountName,
  GLAccount,
  _BusinessAreaText[1: Language = $session.system_language].BusinessAreaName AS BusinessAreaName,
  BusinessArea,
  SalesOrder,
  SalesOrderItem,
  SalesOrderScheduleLine,
  _FixedAsset.FixedAssetDescription AS FixedAssetDescription,
  FixedAsset,
  OrderID,
  _OrderId[1:OrderID = OrderID].OrderDescription AS OrderDescription,
  UnloadingPointName,
  _ControllingArea.ControllingAreaName AS ControllingAreaName,
  ControllingArea,
  CostObject,
  ProfitabilitySegment,
  ProfitCenter,
  _ProfitCenterText[1: Language = $session.system_language ].ProfitCenterName AS ProfitCenterName,
  WBSElementInternalID,
  WBSElementExternalID,
  ProjectNetworkInternalID,
  FinancialManagementArea,
  cast ( FundsCenter as pps_e_funds_center preserving type ) AS FundsCenter,
  _FundsCenter[1:FinancialManagementArea = FinancialManagementArea]._Text[1: FinancialManagementArea = FinancialManagementArea and 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[1:FinancialManagementArea = FinancialManagementArea]._Text[1: Language = $session.system_language].FundName AS FundName,
  _Fund[1:FinancialManagementArea = FinancialManagementArea]._Text[1: Language = $session.system_language].FundDescription AS FundDescription,
  FunctionalArea,
  _FunctionalAreaText.FunctionalAreaName : localized AS FunctionalAreaNamelocalized,
  GoodsRecipientName,
  IsFinallyInvoiced,
  NetworkActivityInternalID,
  PartnerAccountNumber,
  JointVentureRecoveryCode,
  SettlementReferenceDate,
  OrderInternalID,
  OrderIntBillOfOperationsItem,
  TaxCode,
  TaxJurisdiction,
  CostCtrActivityType,
  _BusinessProcessText[1: Language = $session.system_language ].BusinessProcessName AS BusinessProcessName,
  BusinessProcess,
  GrantID,
  _GrantId._Text[1:Language = $session.system_language].GrantName AS GrantName,
  BudgetPeriod,
  _BudgetPeriodStdVH._Text.BudgetPeriodName : localized AS BudgetPeriodNamelocalized,
  USFedGovernmentUUID,
  EarmarkedFundsDocument,
  EarmarkedFundsDocumentItem,
  ValidityDate,
  cast( ServiceDocumentType as pps_e_service_doc_type preserving type ) AS ServiceDocumentType,
  ServiceDocument,
  cast( ServiceDocumentItem as pps_e_service_document_item preserving type ) AS ServiceDocumentItem,
  CreationDate,
  IsAcctLineFinal,
  AcctLineFinalReason,
  CompanyCode,
  _PurchaseOrderItem._CompanyCode.CompanyCodeName AS CompanyCodeName,
  PPSAccountAssignmentIsUnfunded,
  _WBSElement.WBSDescription AS WBSDescription,
  PPSBdgtPeriodValdtyEndDateCat,
  _BdgtPerdValdtyEndDteCat.PPSBdgtPerdValdtyEndDteCatName AS PPSBdgtPerdValdtyEndDteCatName,
  _BudgetPeriodStdVH.ValidityEndDate AS ValidityEndDate,
  virtual ValidityEndDateIsHdn : boolean AS virtualValidityEndDateIsHdnboolean,
  cast( _CostCenterText[1: Language = $session.system_language ].CostCenterDescription as pps_e_cost_center_desc preserving type ) AS CostCenterDescription,
  _CostCenterActivityTypeText[1: Language = $session.system_language].CostCtrActivityTypeDesc AS CostCtrActivityTypeDesc,
  virtual LeadingObjectDescription : abap.char( 60 ) AS char60,
  cast( AccountAssignmentCategory as pps_e_accnt_assignment_cat preserving type ) AS AccountAssignmentCategory,
  CommitmentItem,
  _CommitmentItemText.CommitmentItemDescription AS CommitmentItemDescription,
  _PurchaseOrderItem.PurchaseContractItem AS PurchaseContractItem,
  cast( _PurchaseOrderItem.MultipleAcctAssgmtDistribution as pps_e_multi_account_assignment preserving type ) AS MultipleAcctAssgmtDistribution,
  _PurchaseOrderItem.PartialInvoiceDistribution AS PartialInvoiceDistribution,
  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
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]
;