C_PPS_PurchaseReqnAcctAssgmtTP

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_PurchaseReqnAcctAssgmtTP.
-- 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_PurchaseReqnAcctAssgmtTP AS
SELECT
  PurReqnAcctAssgmtNmbr,
  PurchaseRequisition,
  PurchaseRequisitionItem,
  CostCenter,
  _CostCenterText[1: Language = $session.system_language].CostCenterDescription AS CostCenterDescription,
  MasterFixedAsset,
  ProjectNetwork,
  BaseUnit,
  Quantity,
  MultipleAcctAssgmtDistrPercent,
  Plant,
  PurReqnItemCurrency,
  cast (PurReqnNetAmount as pps_e_aa_amount preserving type ) AS PurReqnNetAmount,
  IsDeleted,
  GLAccount,
  _GLAccountText[1:Language = $session.system_language ].GLAccountLongName AS GLAccountLongName,
  BusinessArea,
  SalesOrder,
  SalesOrderItem,
  SalesOrderScheduleLine,
  FixedAsset,
  _FixedAsset.FixedAssetDescription AS FixedAssetDescription,
  OrderID,
  UnloadingPointName,
  ControllingArea,
  CostObject,
  ProfitabilitySegment,
  ProfitCenter,
  WBSElementInternalID,
  WBSElementExternalID,
  WBSElement,
  ProjectNetworkInternalID,
  CommitmentItem,
  FundsCenter,
  _FundsCenterText[1: FinancialManagementArea = FinancialManagementArea and Language = $session.system_language].FundsCenterDescription AS FundsCenterDescription,
  _FundsCenterText[1:Language = $session.system_language].FundsCenterName AS FundsCenterName,
  Fund,
  _FundText[1: Language = $session.system_language].FundDescription AS FundDescription,
  _FundText[1: Language = $session.system_language].FundName AS FundName,
  FunctionalArea,
  CreationDate,
  GoodsRecipientName,
  NetworkActivityInternalID,
  PartnerAccountNumber,
  JointVentureRecoveryCode,
  SettlementReferenceDate,
  EarmarkedFundsDocument,
  EarmarkedFundsDocumentItem,
  CostCtrActivityType,
  GrantID,
  FinancialManagementArea,
  ValidityDate,
  _PurchaseReqnItem.AccountAssignmentCategory AS AccountAssignmentCategory,
  BudgetPeriod,
  NetworkActivity,
  _MasterFixedAsset.MasterFixedAssetDescription AS MasterFixedAssetDescription,
  _ProjectNetwork.ProjectNetworkDescription AS ProjectNetworkDescription,
  _WBSElementBasicData.WBSDescription AS WBSDescription,
  CompanyCode,
  _PurchaseReqnItem._CompanyCode.ChartOfAccounts AS ChartOfAccounts,
  cast(_PurchaseReqnItem._CompanyCode.FinancialManagementArea as fikrs preserving type ) AS FundsCenterFinMgmtArea,
  _PurchaseReqnItem.MultipleAcctAssgmtDistribution AS MultipleAcctAssgmtDistribution,
  _PurchaseReqnItem.RequestedQuantity AS RequestedQuantity,
  _PurchaseReqnItem.ItemNetAmount AS ItemNetAmount,
  PPSAccountAssignmentIsUnfunded,
  PPSAcctAsgtRefNmbr,
  PPSAcctAsgtSublineItmNmbr,
  PPSPurReqnNetAmount,
  virtual LeadingObjectDescription : abap.char( 250 ) AS char250,
  virtual PPSMultiAcctAssgmtDistrPct : abap.dec( 4, 1 ) AS dec41,
  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_FunctionalArea : boolean AS virtualUICT_FunctionalAreaboolean,
  virtual UICT_GrantID : boolean AS virtualUICT_GrantIDboolean,
  virtual UICT_BudgetPeriod : boolean AS virtualUICT_BudgetPeriodboolean,
  virtual UICT_SalesOrder : boolean AS virtualUICT_SalesOrderboolean
FROM R_PPS_PurchaseReqnAcctAssgmtTP
;