R_PPS_PurConCmtmtPlnAcctAsgtTP

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_PurConCmtmtPlnAcctAsgtTP.
-- 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_PurConCmtmtPlnAcctAsgtTP AS
SELECT
  PurchaseContract,
  PurchaseContractItem,
  CommitmentPlanItemNumber,
  AccountAssignmentNumber,
  DocumentCurrency,
  PurgDocNetAmount,
  CommitmentItemShortID,
  FundsCenter,
  FunctionalArea,
  GrantID,
  Fund,
  GLAccount,
  EarmarkedFundsDocument,
  EarmarkedFundsDocumentItem,
  NetworkNumberForAcctAssgmt,
  NetworkActivity,
  ProductionOrder,
  CostCenter,
  ControllingArea,
  BusinessArea,
  WBSElementInternalID,
  DeletionIndicator,
  FundedProgram,
  FundsMgmtPeriodOfPerfStartDate,
  FundsMgmtPeriodOfPerfEndDate,
  BudgetPeriod,
  EmrkdFndsAcctAssgmtChangeable,
  MultipleAcctAssgmtDistrPercent,
  CostsDueOnDate,
  CmtmtPlnAccAsgChkIsDeactivated,
  _CommitmentPlan.CompanyCode AS CompanyCode,
  cast(_PurchaseContract._CompanyCode.FinancialManagementArea as fikrs preserving type) AS FinancialManagementArea,
  _PurchaseContract.PPSFiscalYear AS PPSFiscalYear
FROM I_PPS_PurConCmtmtPlnAcctAsgt
LEFT OUTER JOIN R_PPS_PurchaseContractItemTP AS _PurchaseContractItem ON _PurchaseContractItem.PurchaseContract = PurchaseContract AND _PurchaseContractItem.PurchaseContractItem = PurchaseContractItem  -- association [1..1]
LEFT OUTER JOIN R_PPS_PurchaseContractTP AS _PurchaseContract ON _PurchaseContract.PurchaseContract = PurchaseContract  -- association [1..1]
LEFT OUTER JOIN I_Fund AS _Fund ON _Fund.Fund = Fund AND _Fund.FinancialManagementArea = FinancialManagementArea AND _Fund.ValidityEndDate > $session.system_date  -- association [0..1]
LEFT OUTER JOIN I_FundsCenter AS _FundsCenter ON _FundsCenter.FundsCenter = FundsCenter AND _FundsCenter.ValidityEndDate > $session.system_date AND _FundsCenter.FinancialManagementArea = FinancialManagementArea  -- association [0..1]
LEFT OUTER JOIN I_CommitmentItemText AS _CommitmentItemTxt ON _CommitmentItemTxt.Language = $session.system_language AND _CommitmentItemTxt.FinancialManagementArea = FinancialManagementArea AND _CommitmentItemTxt.CommitmentItem = CommitmentItemShortID AND ( _CommitmentItemTxt.FinMgmtAreaFiscalYear = ppsfiscalyear OR _CommitmentItemTxt.FinMgmtAreaFiscalYear = '0000')  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _CostCenter ON _CostCenter.ControllingArea = ControllingArea AND _CostCenter.CostCenter = CostCenter AND _CostCenter.ValidityEndDate > $session.system_date  -- association [0..1]
LEFT OUTER JOIN I_GLAccountInCompanyCode AS _GLAccountInCompanyCode ON _GLAccountInCompanyCode.CompanyCode = FinancialManagementArea AND _GLAccountInCompanyCode.GLAccount = GLAccount  -- association [0..1]
LEFT OUTER JOIN I_BudgetPeriodText AS _BudgetPeriodText ON BudgetPeriod = _BudgetPeriodText.BudgetPeriod  -- association [0..*]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_NetworkActivity AS _NetworkActivity ON NetworkActivity = _NetworkActivity.NetworkActivity  -- association [0..*]
;