What is C_PrepaymentAgrmtMonitor in SAP S/4HANA?

C_PrepaymentAgrmtMonitor is a consumption CDS view in SAP S/4HANA. Monitor Prepayment Agreement It contains 39 fields.

Which tables does C_PrepaymentAgrmtMonitor read from?

C_PrepaymentAgrmtMonitor reads data from: I_PrepaymentAgreementTP.

What VDM layer is C_PrepaymentAgrmtMonitor?

C_PrepaymentAgrmtMonitor is classified as a Consumption view optimized for specific business scenarios and reporting.

C_PrepaymentAgrmtMonitor

DDL: C_PREPAYMENTAGRMTMONITOR SQL: CPPMGAGRMTMNTR Type: view CONSUMPTION

39 Fields 1 Data Sources 14 Associations 1 Fiori Apps

Monitor Prepayment Agreement

C_PrepaymentAgrmtMonitor is a Consumption CDS View that provides data about "Monitor Prepayment Agreement" in SAP S/4HANA. It reads from 1 data source (I_PrepaymentAgreementTP) and exposes 39 fields with key field PrepaymentAgreementUUID. It has 14 associations to related views. It is used in 1 Fiori application: Monitor Prepayment Agreements.

Data Sources (1)

Source	Alias	Join Type
I_PrepaymentAgreementTP	PrepaymentAgrmntMonitor	from

Associations (14)

Cardinality	Target	Alias	Condition
[0..*]	C_PrepaymentPostingMessages	_Approval	`$projection.PrepaymentAgreement = _Approval.PrepaymentAgreement --Business partner`
[0..1]	I_BusinessPartner	_BPText	`$projection.Counterparty = _BPText.BusinessPartner --Prepayment system status`
[0..1]	I_SystemStatusText	_OrderStatusText	`$projection.PrepaymentAgreementStatus = _OrderStatusText.SystemStatus and _OrderStatusText.Language = $session.system_language --Commodity Type`
[0..*]	I_CmmdtyText	_CmmdtyType	`$projection.PrepaymentAgreementCommodity = _CmmdtyType.Commodity --Company code`
[0..1]	I_CompanyCode	_CoCode	`$projection.CompanyCode = _CoCode.CompanyCode -- Economic Group Text`
[0..1]	I_PrepaymentEconomicGrpTxt	_EconomicGroupText	`$projection.PrepaymentEconomicGroup = _EconomicGroupText.PrepaymentEconomicGroup and $projection.Counterparty = _EconomicGroupText.Counterparty and _EconomicGroupText.Language = $session.system_language --Purchasing organization text`
[0..1]	C_PurchasingOrganizationVHTemp	_PurgOrgTxt	`$projection.PurchasingOrganization = _PurgOrgTxt.PurchasingOrganization --Distribution channel text`
[0..1]	I_DistributionChannelText	_DistrChnlTxt	`$projection.DistributionChannel = _DistrChnlTxt.DistributionChannel and _DistrChnlTxt.Language = $session.system_language --Prepayment agreement category text`
[0..1]	I_PrepaymentAgrmtCategoryText	_PrepaymentAgrmtCatTxt	`$projection.PrepaymentAgreementCategory = _PrepaymentAgrmtCatTxt.PrepaymentAgrmtDomainCode and _PrepaymentAgrmtCatTxt.Language = $session.system_language --Prepatment agreement type text`
[0..*]	I_PrepaymentAgreementTypeVH	_PrepaymentAgrmtTxt	`$projection.PrepaymentAgreementType = _PrepaymentAgrmtTxt.PrepaymentAgreementType --`
[0..1]	I_PrepaymentAgrmtLinkStsText	_LinkStatusText	`$projection.PrepaymentAgrmtLinkStatus = _LinkStatusText.PrepaymentAgrmtDomainCode and _LinkStatusText.Language = $session.system_language --Prepayment system status`
[0..1]	I_SystemStatusText	_PostingStatusText	`$projection.PrepaymentAgrmtPostingStatus = _PostingStatusText.SystemStatus and _PostingStatusText.Language = $session.system_language --`
[0..1]	I_PrepaymentAgrmtLinkStsText	_BarterLinkStatusText	`$projection.PrepaymentBarterLinkStatus = _BarterLinkStatusText.PrepaymentAgrmtDomainCode and _BarterLinkStatusText.Language = $session.system_language --Prepayment user text`
[0..1]	I_PrepaymentAgrmtUserNameText	_UserText	`$projection.CreatedByUser = _UserText.UserName`

Annotations (21)

Name	Value	Level
AbapCatalog.sqlViewName	CPPMGAGRMTMNTR	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#MANDATORY	view
AccessControl.personalData.blocking	#REQUIRED	view
EndUserText.label	Monitor Prepayment Agreement	view
VDM.viewType	#CONSUMPTION	view
Search.searchable	true	view
Metadata.allowExtensions	true	view
OData.publish	true	view
ClientHandling.type	#CLIENT_DEPENDENT	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.compositionRoot	true	view
ObjectModel.transactionalProcessingDelegated	true	view
ObjectModel.draftEnabled	false	view
ObjectModel.createEnabled	false	view
ObjectModel.updateEnabled	false	view
ObjectModel.deleteEnabled	false	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.dataClass	#MASTER	view

Fiori Apps (1)

App ID	App Name	Type	Description
F5051	Monitor Prepayment Agreements	Transactional

Monitor Prepayment Agreements

Business Role: Credit Controller - Prepayments

This feature enables you to search and reprocess the prepayment agreements which have failed during the prepayment financial posting process using Monitor Prepayment Agreements app.

Fields (39)

Key	Field	Source Table	Source Field	Description
KEY	PrepaymentAgreementUUID	I_PrepaymentAgreementTP	PrepaymentAgreementUUID	Key
	PrepaymentAgreement	I_PrepaymentAgreementTP	PrepaymentAgreement	Renegotiation PPA
	PrepaymentAgreementCategory	I_PrepaymentAgreementTP	PrepaymentAgreementCategory	Prepayment Category
	PrepaymentAgreementDescription	I_PrepaymentAgreementTP	PrepaymentAgreementDescription	Pre Agreement Desc.
	PrepaymentAgreementAmount	I_PrepaymentAgreementTP	PrepaymentAgreementAmount	Pre Agrm Amount
	PrepaymentAgreementCurrency	I_PrepaymentAgreementTP	PrepaymentAgreementCurrency	Currency
	PrepaymentAgreementStatus	I_PrepaymentAgreementTP	PrepaymentAgreementStatus	Pre Agreement Status
	PrepaymentAgreementCommodity	I_PrepaymentAgreementTP	PrepaymentAgreementCommodity	Commodity
	CompanyCode	I_PrepaymentAgreementTP	CompanyCode	Receiver Company Code
	PrepaymentEconomicGroup	I_PrepaymentAgreementTP	PrepaymentEconomicGroup	Economic Group
	PrepaymentEconomicGroupFilter	I_PrepaymentAgreementTP	PrepaymentEconomicGroup	Economic Group
	PurchasingGroup	I_PrepaymentAgreementTP	PurchasingGroup	Purchasing Group
	PurchasingOrganization	I_PrepaymentAgreementTP	PurchasingOrganization	Purchasing Organization
	SalesOrganization	I_PrepaymentAgreementTP	SalesOrganization	Sales Organization
	DistributionChannel	I_PrepaymentAgreementTP	DistributionChannel	RefDistCh-Cust/Mat.
	Division	I_PrepaymentAgreementTP	Division	Internal Division ID
	PrepaymentAgrmtCropSeason	I_PrepaymentAgreementTP	PrepaymentAgrmtCropSeason	Crop Season
	Counterparty	I_PrepaymentAgreementTP	Counterparty	Supplier
	PrepaymentAgrmtBPType	I_PrepaymentAgreementTP	PrepaymentAgrmtBPType	Counterparty Type
	PrepaymentAgrmtPostingStatus	I_PrepaymentAgreementTP	PrepaymentAgrmtPostingStatus	Pre Posting Status
	PrepaymentAgrmtLinkStatus	I_PrepaymentAgreementTP	PrepaymentAgrmtLinkStatus	Link Status
	PrepaymentBarterLinkStatus	I_PrepaymentAgreementTP	PrepaymentBarterLinkStatus	Prepmt Barter Status
	CreatedByUserasCreatedByUser
	CreationDate	I_PrepaymentAgreementTP	CreationDate	Time Stamp
	CreationDateTime	I_PrepaymentAgreementTP	CreationDateTime	Timestamp
	LastChangeDateTime	I_PrepaymentAgreementTP	LastChangeDateTime	Timestamp
	_Approval		_Approval
	_BPText		_BPText
	_OrderStatusText		_OrderStatusText
	_CmmdtyType		_CmmdtyType
	_PurgOrgTxt		_PurgOrgTxt
	_DistrChnlTxt		_DistrChnlTxt
	_PrepaymentAgrmtCatTxt		_PrepaymentAgrmtCatTxt
	_PrepaymentAgrmtTxt		_PrepaymentAgrmtTxt
	_LinkStatusText		_LinkStatusText
	_PostingStatusText		_PostingStatusText
	_UserText		_UserText
	CompanyCodeText_CoCode
	EconomicGroupText_EconomicGroupText

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_PrepaymentAgrmtMonitor.
-- 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: CPPMGAGRMTMNTR

CREATE VIEW C_PrepaymentAgrmtMonitor AS
SELECT
  PrepaymentAgrmntMonitor.PrepaymentAgreementUUID AS PrepaymentAgreementUUID,
  PrepaymentAgrmntMonitor.PrepaymentAgreement AS PrepaymentAgreement,
  PrepaymentAgrmntMonitor.PrepaymentAgreementCategory AS PrepaymentAgreementCategory,
  PrepaymentAgrmntMonitor.PrepaymentAgreementDescription AS PrepaymentAgreementDescription,
  PrepaymentAgrmntMonitor.PrepaymentAgreementAmount AS PrepaymentAgreementAmount,
  PrepaymentAgrmntMonitor.PrepaymentAgreementCurrency AS PrepaymentAgreementCurrency,
  PrepaymentAgrmntMonitor.PrepaymentAgreementStatus AS PrepaymentAgreementStatus,
  PrepaymentAgrmntMonitor.PrepaymentAgreementCommodity AS PrepaymentAgreementCommodity,
  PrepaymentAgrmntMonitor.CompanyCode AS CompanyCode,
  PrepaymentAgrmntMonitor.PrepaymentEconomicGroup AS PrepaymentEconomicGroup,
  PrepaymentAgrmntMonitor.PrepaymentEconomicGroup AS PrepaymentEconomicGroupFilter,
  PrepaymentAgrmntMonitor.PurchasingGroup AS PurchasingGroup,
  PrepaymentAgrmntMonitor.PurchasingOrganization AS PurchasingOrganization,
  PrepaymentAgrmntMonitor.SalesOrganization AS SalesOrganization,
  PrepaymentAgrmntMonitor.DistributionChannel AS DistributionChannel,
  PrepaymentAgrmntMonitor.Division AS Division,
  PrepaymentAgrmntMonitor.PrepaymentAgrmtCropSeason AS PrepaymentAgrmtCropSeason,
  PrepaymentAgrmntMonitor.Counterparty AS Counterparty,
  PrepaymentAgrmntMonitor.PrepaymentAgrmtBPType AS PrepaymentAgrmtBPType,
  PrepaymentAgrmntMonitor.PrepaymentAgrmtPostingStatus AS PrepaymentAgrmtPostingStatus,
  PrepaymentAgrmntMonitor.PrepaymentAgrmtLinkStatus AS PrepaymentAgrmtLinkStatus,
  PrepaymentAgrmntMonitor.PrepaymentBarterLinkStatus AS PrepaymentBarterLinkStatus,
  PrepaymentAgrmntMonitor.CreationDate AS CreationDate,
  PrepaymentAgrmntMonitor.CreationDateTime AS CreationDateTime,
  PrepaymentAgrmntMonitor.LastChangeDateTime AS LastChangeDateTime
FROM I_PrepaymentAgreementTP AS PrepaymentAgrmntMonitor
LEFT OUTER JOIN C_PrepaymentPostingMessages AS _Approval ON PrepaymentAgreement = _Approval.PrepaymentAgreement  -- association [0..*]
LEFT OUTER JOIN I_BusinessPartner AS _BPText ON Counterparty = _BPText.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_SystemStatusText AS _OrderStatusText ON PrepaymentAgreementStatus = _OrderStatusText.SystemStatus AND _OrderStatusText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CmmdtyText AS _CmmdtyType ON PrepaymentAgreementCommodity = _CmmdtyType.Commodity  -- association [0..*]
LEFT OUTER JOIN I_CompanyCode AS _CoCode ON CompanyCode = _CoCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_PrepaymentEconomicGrpTxt AS _EconomicGroupText ON PrepaymentEconomicGroup = _EconomicGroupText.PrepaymentEconomicGroup AND Counterparty = _EconomicGroupText.Counterparty AND _EconomicGroupText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN C_PurchasingOrganizationVHTemp AS _PurgOrgTxt ON PurchasingOrganization = _PurgOrgTxt.PurchasingOrganization  -- association [0..1]
LEFT OUTER JOIN I_DistributionChannelText AS _DistrChnlTxt ON DistributionChannel = _DistrChnlTxt.DistributionChannel AND _DistrChnlTxt.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_PrepaymentAgrmtCategoryText AS _PrepaymentAgrmtCatTxt ON PrepaymentAgreementCategory = _PrepaymentAgrmtCatTxt.PrepaymentAgrmtDomainCode AND _PrepaymentAgrmtCatTxt.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_PrepaymentAgreementTypeVH AS _PrepaymentAgrmtTxt ON PrepaymentAgreementType = _PrepaymentAgrmtTxt.PrepaymentAgreementType  -- association [0..*]
LEFT OUTER JOIN I_PrepaymentAgrmtLinkStsText AS _LinkStatusText ON PrepaymentAgrmtLinkStatus = _LinkStatusText.PrepaymentAgrmtDomainCode AND _LinkStatusText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SystemStatusText AS _PostingStatusText ON PrepaymentAgrmtPostingStatus = _PostingStatusText.SystemStatus AND _PostingStatusText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_PrepaymentAgrmtLinkStsText AS _BarterLinkStatusText ON PrepaymentBarterLinkStatus = _BarterLinkStatusText.PrepaymentAgrmtDomainCode AND _BarterLinkStatusText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_PrepaymentAgrmtUserNameText AS _UserText ON CreatedByUser = _UserText.UserName  -- association [0..1]
;

Depth:

C_PrepaymentAgrmtMonitor view

I_PrepaymentAgreementTP view