C_PubSecPeriodicCmtmtAdjTP

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_PubSecPeriodicCmtmtAdjTP.
-- 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.
-- SQL view name: CPSMS4CPCMTADJTP

CREATE VIEW C_PubSecPeriodicCmtmtAdjTP AS
SELECT
  CompanyCode,
  SourceReferenceDocumentType,
  SourceReferenceDocument,
  SourceReferenceDocumentItem,
  AccountAssignmentNumber,
  PubSecBudgetCnsmpnType,
  Fund,
  BudgetPeriod,
  FiscalYear,
  FunctionalArea,
  case when _JobStatus.status = 'F' then replace(_JobStatus.status, 'F', 'Finished') when _JobStatus.status = 'R' then replace(_JobStatus.status, 'R', 'In Process') when _JobStatus.status = 'A' then replace(_JobStatus.status, 'A', 'Failed') when _JobStatus.status = 'S' then replace(_JobStatus.status, 'S', 'Released') when _JobStatus.status = 'Y' then replace(_JobStatus.status, 'Y', 'Ready') else _JobStatus.status end as ApplicationJobStatusText AS statusendasApplicationJobStatusText,
  SystemMessageType,
  cast( ' ' as messagetext ) AS SystemMessageLongText,
  _JobText.job_text AS ApplicationJobName,
  TotalAmountInCoCodeCrcy,
  I_PubSecPeriodicCmtmtAdjTP.ReferenceApplicationJobName AS FinClosingRunBatchJobName,
  _JobText.created_at AS CreationDateTime,
  _JobText.created_by AS CreatedByUser,
  CompanyCodeCurrency,
  FinancialManagementArea,
  GrantID,
  ChartOfAccounts,
  PubSecBudgetAccount,
  ControllingArea,
  CostCenter,
  cast('' as fis_cctr_hrynid_50) AS CostCenterHierarchyNode,
  cast('' as fis_cctr_hryid_42) AS CostCenterHierarchy,
  cast('' as fmis_fund_hrynid_50) AS FundHierarchyNode,
  cast('' as fmis_hryid_fund) AS FundHierarchy,
  cast('' as psm_hrynid_budgetaccount) AS BudgetAccountHierarchyNode,
  cast('' as psm_hryid_budgetaccount) AS BudgetAccountHierarchy,
  cast('' as gm_hrynid_grant) AS GrantHierarchyNode,
  cast('' as gm_hryid_grant) AS GrantHierarchy,
  WBSElementExternalID,
  WBSElementInternalID,
  ProfitCenter,
  Segment
FROM I_PubSecPeriodicCmtmtAdjTP
LEFT OUTER JOIN tbtco AS _JobStatus ON I_PubSecPeriodicCmtmtAdjTP.ReferenceApplicationJobName = _JobStatus.jobname AND I_PubSecPeriodicCmtmtAdjTP.ApplicationJob = _JobStatus.jobcount  -- association [0..1]
LEFT OUTER JOIN apj_d_job_exe AS _JobText ON I_PubSecPeriodicCmtmtAdjTP.ReferenceApplicationJobName = _JobText.job_name association[0..*] to C_HierRuntimeRprstnDplLeafNode as _CostCenterHierarchyLeafNode on CostCenter = _CostCenterHierarchyLeafNode.UnivHierarchyBusinessEntity AND ControllingArea = _CostCenterHierarchyLeafNode.HierarchyNodeClass AND _CostCenterHierarchyLeafNode.ValidityStartDate <= $session.system_date AND _CostCenterHierarchyLeafNode.ValidityEndDate >= $session.system_date AND _CostCenterHierarchyLeafNode.HierarchyType = '0101' association[0..*] to C_HierRuntimeRprstnDplLeafNode as _FundHierarchyLeafNode on Fund = _FundHierarchyLeafNode.UnivHierarchyBusinessEntity AND FinancialManagementArea = _FundHierarchyLeafNode.HierarchyNodeClass AND _FundHierarchyLeafNode.ValidityStartDate <= $session.system_date AND _FundHierarchyLeafNode.ValidityEndDate >= $session.system_date AND _FundHierarchyLeafNode.HierarchyType = '0111' association[0..*] to C_HierRuntimeRprstnDplLeafNode as _GrantHierarchyLeafNode on GrantID = _GrantHierarchyLeafNode.UnivHierarchyBusinessEntity AND _GrantHierarchyLeafNode.ValidityStartDate <= $session.system_date AND _GrantHierarchyLeafNode.ValidityEndDate >= $session.system_date AND _GrantHierarchyLeafNode.HierarchyType = '0113' association[0..*] to C_HierRuntimeRprstnDplLeafNode as _BudgetAcctHierarchyLeafNode on PubSecBudgetAccount = _BudgetAcctHierarchyLeafNode.UnivHierarchyBusinessEntity AND _BudgetAcctHierarchyLeafNode.ValidityStartDate <= $session.system_date AND _BudgetAcctHierarchyLeafNode.ValidityEndDate >= $session.system_date AND _BudgetAcctHierarchyLeafNode.HierarchyType = '0115'  -- association [0..1]
;