I_PubSecPeriodicCmtmtAdjTP
Periodic Commitment Adjustments
I_PubSecPeriodicCmtmtAdjTP is a Transactional CDS View that provides data about "Periodic Commitment Adjustments" in SAP S/4HANA. It reads from 2 data sources (I_PubSecPeriodicCmtmtAdj, psm_d_pcmtad_act) and exposes 50 fields with key fields CompanyCode, SourceReferenceDocumentType, SourceReferenceDocument, SourceReferenceDocumentItem, AccountAssignmentNumber. It has 2 associations to related views.
Data Sources (2)
| Source | Alias | Join Type |
|---|---|---|
| I_PubSecPeriodicCmtmtAdj | I_PubSecPeriodicCmtmtAdj | from |
| psm_d_pcmtad_act | JobID | left_outer |
Associations (2)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | I_PubSecRefDocType | _SourceReferenceDocumentType | $projection.SourceReferenceDocumentType = _SourceReferenceDocumentType.ReferenceDocumentType |
| [0..1] | I_PubSecSystMsgType | _MessageType | $projection.SystemMessageType = _MessageType.SystemMessageType |
Annotations (21)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | IPSMS4CPCMTADJTP | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AbapCatalog.preserveKey | true | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| AccessControl.personalData.blocking | #REQUIRED | view | |
| EndUserText.label | Periodic Commitment Adjustments | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| VDM.viewType | #TRANSACTIONAL | view | |
| VDM.lifecycle.contract.type | #SAP_INTERNAL_API | view | |
| ObjectModel.sapObjectNodeType.name | PubSecPeriodicCommitmentAdjmt | view | |
| ObjectModel.modelCategory | #BUSINESS_OBJECT | view | |
| ObjectModel.compositionRoot | true | view | |
| ObjectModel.representativeKey | CompanyCode | view | |
| ObjectModel.writeActivePersistence | PSM_D_PCMTAD_ACT | view | |
| ObjectModel.transactionalProcessingEnabled | true | view | |
| ObjectModel.entityChangeStateId | EXTERNAL_CALCULATION | view | |
| ObjectModel.lifecycle.draft.expiryBehavior | #RELATIVE_TO_PROCESSING_START | view | |
| ObjectModel.lifecycle.draft.expiryInterval | P5D | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.sizeCategory | #L | view |
Fields (50)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | CompanyCode | I_PubSecPeriodicCmtmtAdj | CompanyCode | Receiver Company Code |
| KEY | SourceReferenceDocumentType | I_PubSecPeriodicCmtmtAdj | SourceReferenceDocumentType | Ref. procedure |
| KEY | SourceReferenceDocument | I_PubSecPeriodicCmtmtAdj | SourceReferenceDocument | Reference Doc. |
| KEY | SourceReferenceDocumentItem | I_PubSecPeriodicCmtmtAdj | SourceReferenceDocumentItem | Ref. Doc. Item |
| KEY | AccountAssignmentNumber | I_PubSecPeriodicCmtmtAdj | AccountAssignmentNumber | Account Assgmt No. |
| PubSecBudgetCnsmpnType | I_PubSecPeriodicCmtmtAdj | PubSecBudgetCnsmpnType | Budget Consumption Type | |
| FiscalYear | I_PubSecPeriodicCmtmtAdj | FiscalYear | G/L Fiscal Year | |
| Fund | I_PubSecPeriodicCmtmtAdj | Fund | Sender Fund | |
| BudgetPeriod | I_PubSecPeriodicCmtmtAdj | BudgetPeriod | Budget Period | |
| GrantID | I_PubSecPeriodicCmtmtAdj | GrantID | Sender Grant | |
| FunctionalArea | I_PubSecPeriodicCmtmtAdj | FunctionalArea | Sendr Fctl Area | |
| ChartOfAccounts | I_PubSecPeriodicCmtmtAdj | ChartOfAccounts | Node Class | |
| PubSecBudgetAccount | I_PubSecPeriodicCmtmtAdj | PubSecBudgetAccount | Budget Account | |
| ControllingArea | I_PubSecPeriodicCmtmtAdj | ControllingArea | Controlling Area | |
| FinancialManagementArea | I_PubSecPeriodicCmtmtAdj | FinancialManagementArea | FM Area | |
| CostCenter | I_PubSecPeriodicCmtmtAdj | CostCenter | Cost Center | |
| WBSElementInternalID | I_PubSecPeriodicCmtmtAdj | WBSElementInternalID | WBS Internal ID | |
| WBSElementExternalID | I_PubSecPeriodicCmtmtAdj | WBSElementExternalID | WBS Element External ID | |
| Segment | I_PubSecPeriodicCmtmtAdj | Segment | Segment number | |
| ProfitCenter | I_PubSecPeriodicCmtmtAdj | ProfitCenter | Profit Center | |
| TotalAmountInCoCodeCrcy | I_PubSecPeriodicCmtmtAdj | TotalAmountInCoCodeCrcy | Total Amt In Co Crcy | |
| CompanyCodeCurrency | I_PubSecPeriodicCmtmtAdj | CompanyCodeCurrency | Local Currency | |
| ReferenceApplicationJobName | psm_d_pcmtad_act | job_name | Job No. | |
| ApplicationJob | psm_d_pcmtad_act | job_run_count | Job No. | |
| SystemMessageType | psm_d_pcmtad_act | systemmessagetype | Message type | |
| SystemMessageIdentification | psm_d_pcmtad_act | systemmessageidentification | Message ID | |
| SystemMessageNumber | psm_d_pcmtad_act | systemmessagenumber | Message Number | |
| SystemMessageVariable1 | psm_d_pcmtad_act | systemmessagevariable1 | Variable 1 | |
| SystemMessageVariable2 | psm_d_pcmtad_act | systemmessagevariable2 | Variable 2 | |
| SystemMessageVariable3 | psm_d_pcmtad_act | systemmessagevariable3 | Variable 3 | |
| SystemMessageVariable4 | psm_d_pcmtad_act | systemmessagevariable4 | Variable 4 | |
| _SourceReferenceDocumentType | _SourceReferenceDocumentType | |||
| _CompanyCode | I_PubSecPeriodicCmtmtAdj | _CompanyCode | ||
| _CompanyCodeCurrency | I_PubSecPeriodicCmtmtAdj | _CompanyCodeCurrency | ||
| _FinancialManagementArea | I_PubSecPeriodicCmtmtAdj | _FinancialManagementArea | ||
| _FiscalYear | I_PubSecPeriodicCmtmtAdj | _FiscalYear | ||
| _Fund | I_PubSecPeriodicCmtmtAdj | _Fund | ||
| _PubSecBdgtCnsmpnType | I_PubSecPeriodicCmtmtAdj | _PubSecBdgtCnsmpnType | ||
| _BudgetPeriod | I_PubSecPeriodicCmtmtAdj | _BudgetPeriod | ||
| _FunctionalArea | I_PubSecPeriodicCmtmtAdj | _FunctionalArea | ||
| _ChartOfAccounts | I_PubSecPeriodicCmtmtAdj | _ChartOfAccounts | ||
| _BudgetAccountInChtAccts | I_PubSecPeriodicCmtmtAdj | _BudgetAccountInChtAccts | ||
| _ControllingArea | I_PubSecPeriodicCmtmtAdj | _ControllingArea | ||
| _CurrentCostCenter | I_PubSecPeriodicCmtmtAdj | _CurrentCostCenter | ||
| _WBSElementBasicData | I_PubSecPeriodicCmtmtAdj | _WBSElementBasicData | ||
| _WBSElementExternalID | I_PubSecPeriodicCmtmtAdj | _WBSElementExternalID | ||
| _Segment | I_PubSecPeriodicCmtmtAdj | _Segment | ||
| _CurrentProfitCenter | I_PubSecPeriodicCmtmtAdj | _CurrentProfitCenter | ||
| _MessageType | _MessageType | |||
| _Grant | I_PubSecPeriodicCmtmtAdj | _Grant |
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 I_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: IPSMS4CPCMTADJTP
CREATE VIEW I_PubSecPeriodicCmtmtAdjTP AS
SELECT
I_PubSecPeriodicCmtmtAdj.CompanyCode AS CompanyCode,
I_PubSecPeriodicCmtmtAdj.SourceReferenceDocumentType AS SourceReferenceDocumentType,
I_PubSecPeriodicCmtmtAdj.SourceReferenceDocument AS SourceReferenceDocument,
I_PubSecPeriodicCmtmtAdj.SourceReferenceDocumentItem AS SourceReferenceDocumentItem,
I_PubSecPeriodicCmtmtAdj.AccountAssignmentNumber AS AccountAssignmentNumber,
I_PubSecPeriodicCmtmtAdj.PubSecBudgetCnsmpnType AS PubSecBudgetCnsmpnType,
I_PubSecPeriodicCmtmtAdj.FiscalYear AS FiscalYear,
I_PubSecPeriodicCmtmtAdj.Fund AS Fund,
I_PubSecPeriodicCmtmtAdj.BudgetPeriod AS BudgetPeriod,
I_PubSecPeriodicCmtmtAdj.GrantID AS GrantID,
I_PubSecPeriodicCmtmtAdj.FunctionalArea AS FunctionalArea,
I_PubSecPeriodicCmtmtAdj.ChartOfAccounts AS ChartOfAccounts,
I_PubSecPeriodicCmtmtAdj.PubSecBudgetAccount AS PubSecBudgetAccount,
I_PubSecPeriodicCmtmtAdj.ControllingArea AS ControllingArea,
I_PubSecPeriodicCmtmtAdj.FinancialManagementArea AS FinancialManagementArea,
I_PubSecPeriodicCmtmtAdj.CostCenter AS CostCenter,
I_PubSecPeriodicCmtmtAdj.WBSElementInternalID AS WBSElementInternalID,
I_PubSecPeriodicCmtmtAdj.WBSElementExternalID AS WBSElementExternalID,
I_PubSecPeriodicCmtmtAdj.Segment AS Segment,
I_PubSecPeriodicCmtmtAdj.ProfitCenter AS ProfitCenter,
I_PubSecPeriodicCmtmtAdj.TotalAmountInCoCodeCrcy AS TotalAmountInCoCodeCrcy,
I_PubSecPeriodicCmtmtAdj.CompanyCodeCurrency AS CompanyCodeCurrency,
JobID.job_name AS ReferenceApplicationJobName,
JobID.job_run_count AS ApplicationJob,
JobID.systemmessagetype AS SystemMessageType,
JobID.systemmessageidentification AS SystemMessageIdentification,
JobID.systemmessagenumber AS SystemMessageNumber,
JobID.systemmessagevariable1 AS SystemMessageVariable1,
JobID.systemmessagevariable2 AS SystemMessageVariable2,
JobID.systemmessagevariable3 AS SystemMessageVariable3,
JobID.systemmessagevariable4 AS SystemMessageVariable4,
I_PubSecPeriodicCmtmtAdj._CompanyCode AS _CompanyCode,
I_PubSecPeriodicCmtmtAdj._CompanyCodeCurrency AS _CompanyCodeCurrency,
I_PubSecPeriodicCmtmtAdj._FinancialManagementArea AS _FinancialManagementArea,
I_PubSecPeriodicCmtmtAdj._FiscalYear AS _FiscalYear,
I_PubSecPeriodicCmtmtAdj._Fund AS _Fund,
I_PubSecPeriodicCmtmtAdj._PubSecBdgtCnsmpnType AS _PubSecBdgtCnsmpnType,
I_PubSecPeriodicCmtmtAdj._BudgetPeriod AS _BudgetPeriod,
I_PubSecPeriodicCmtmtAdj._FunctionalArea AS _FunctionalArea,
I_PubSecPeriodicCmtmtAdj._ChartOfAccounts AS _ChartOfAccounts,
I_PubSecPeriodicCmtmtAdj._BudgetAccountInChtAccts AS _BudgetAccountInChtAccts,
I_PubSecPeriodicCmtmtAdj._ControllingArea AS _ControllingArea,
I_PubSecPeriodicCmtmtAdj._CurrentCostCenter AS _CurrentCostCenter,
I_PubSecPeriodicCmtmtAdj._WBSElementBasicData AS _WBSElementBasicData,
I_PubSecPeriodicCmtmtAdj._WBSElementExternalID AS _WBSElementExternalID,
I_PubSecPeriodicCmtmtAdj._Segment AS _Segment,
I_PubSecPeriodicCmtmtAdj._CurrentProfitCenter AS _CurrentProfitCenter,
I_PubSecPeriodicCmtmtAdj._Grant AS _Grant
FROM I_PubSecPeriodicCmtmtAdj
LEFT OUTER JOIN psm_d_pcmtad_act AS JobID ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PubSecRefDocType AS _SourceReferenceDocumentType ON SourceReferenceDocumentType = _SourceReferenceDocumentType.ReferenceDocumentType -- association [0..1]
LEFT OUTER JOIN I_PubSecSystMsgType AS _MessageType ON SystemMessageType = _MessageType.SystemMessageType -- association [0..1]
;Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA