What is C_PrepaymentAgrmtCollateralTP in SAP S/4HANA?

C_PrepaymentAgrmtCollateralTP is a consumption CDS view in SAP S/4HANA. Prepayment Aggrement Collateral C View It contains 74 fields.

Which tables does C_PrepaymentAgrmtCollateralTP read from?

C_PrepaymentAgrmtCollateralTP reads data from: I_PrepaymentAgrmtCollateralTP.

What VDM layer is C_PrepaymentAgrmtCollateralTP?

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

C_PrepaymentAgrmtCollateralTP

DDL: C_PREPAYMENTAGRMTCOLLATERALTP SQL: CPPMGCOLLTRLTP Type: view CONSUMPTION

74 Fields 1 Data Sources 9 Associations

Prepayment Aggrement Collateral C View

C_PrepaymentAgrmtCollateralTP is a Consumption CDS View that provides data about "Prepayment Aggrement Collateral C View" in SAP S/4HANA. It reads from 1 data source (I_PrepaymentAgrmtCollateralTP) and exposes 74 fields. It has 9 associations to related views.

Data Sources (1)

Source	Alias	Join Type
I_PrepaymentAgrmtCollateralTP	Collateral	from

Associations (9)

Cardinality	Target	Alias	Condition
[1..1]	C_PrepaymentAgreementTP	_PrepaymentAgreement	`$projection.PrepaymentAgreementUUID = _PrepaymentAgreement.PrepaymentAgreementUUID --`
[0..*]	C_PrepaymentAgrmtPartnersTP	_CollateralPartners	`$projection.PrepaymentAgrmtColltrlUUID = _CollateralPartners.PrepaymentAgrmtColltrlUUID --`
[0..*]	C_PrepaymentAgrmtColExt1TP	_CollateralExtension1	`$projection.PrepaymentAgrmtColltrlUUID = _CollateralExtension1.PrepaymentAgrmtColltrlUUID --`
[0..1]	I_PrepaymentColltrlTypeVH	_CollateralType	`$projection.PrepaymentColltrlType = _CollateralType.PrepaymentAgrmtColltrlTypeCode and _CollateralType.Language = $session.system_language -- Country text`
[0..1]	I_CountryText	_CountryText	`$projection.CountryCode = _CountryText.Country and _CountryText.Language = $session.system_language -- Region text`
[0..1]	I_RegionText	_RegionText	`$projection.CompanyRegion = _RegionText.Region and _RegionText.Language = $session.system_language and $projection.CountryCode = _RegionText.Country -- City text`
[0..1]	I_CityCodeText	_CityCodeText	`$projection.PrepaymentColltrlCityCode = _CityCodeText.CityCode and $projection.CountryCode = _CityCodeText.Country and $projection.CompanyRegion = _CityCodeText.Region and _CityCodeText.Language = $session.system_language -- Tax Jurisidiction`
[0..*]	I_TaxJurisdictionText	_TaxJurisdictionText	`$projection.PrepaymentColltrlTxCodeJx = _TaxJurisdictionText.TaxJurisdiction and _TaxJurisdictionText.Language = $session.system_language -- Extension View for Collateral in Prepayment`
[0..1]	E_PrepaymentAgrmtCollateral	_Extension	`$projection.PrepaymentAgrmtColltrlUUID = _Extension.PrepaymentAgrmtColltrlUUID`

Annotations (18)

Name	Value	Level
AbapCatalog.sqlViewName	CPPMGCOLLTRLTP	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
ClientHandling.type	#CLIENT_DEPENDENT	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
AccessControl.authorizationCheck	#CHECK	view
AccessControl.personalData.blocking	#REQUIRED	view
EndUserText.label	Prepayment Aggrement Collateral C View	view
VDM.viewType	#CONSUMPTION	view
Search.searchable	true	view
Metadata.allowExtensions	true	view
ObjectModel.transactionalProcessingDelegated	true	view
ObjectModel.createEnabled	EXTERNAL_CALCULATION	view
ObjectModel.updateEnabled	EXTERNAL_CALCULATION	view
ObjectModel.deleteEnabled	EXTERNAL_CALCULATION	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.dataClass	#MIXED	view

Fields (74)

Field	Source Table	Source Field	Description
PrepaymentAgrmtColltrlUUID
PrepaymentAgreementUUID
PrepaymentColltrlType
PrepaymentColltrlSubType	I_PrepaymentAgrmtCollateralTP	PrepaymentColltrlSubType	Collateral Sub Types
PrepaymentColltrlCode	I_PrepaymentAgrmtCollateralTP	PrepaymentColltrlCode	Collateral Code
PrepaymentColltrlIsRcvd
PrepaymentColltrlIsSettlmtRqd
PrepaymentColltrlLandAreaQty
PrepaymentColltrlLandAreaUoM	I_PrepaymentAgrmtCollateralTP	PrepaymentColltrlLandAreaUoM	Land Area - Unit of Measure
PrepaymentColltrlTotPrptyQty
PrepaymentColltrlTotPrptyUoM	I_PrepaymentAgrmtCollateralTP	PrepaymentColltrlTotPrptyUoM	Total Property - Unit of Measure
PrepaymentColltrlAreaQty
PrepaymentColltrlAreaUoM	I_PrepaymentAgrmtCollateralTP	PrepaymentColltrlAreaUoM	Collateral Area - Unit of Measure
PrepaymentColltrlProdtvQty
PrepaymentColltrlProdtvAreaUoM	I_PrepaymentAgrmtCollateralTP	PrepaymentColltrlProdtvAreaUoM	Productive Area - Unit of Measure
PrepaymentColltrlPlntAreaQty
PrepaymentColltrlPlntAreaUoM	I_PrepaymentAgrmtCollateralTP	PrepaymentColltrlPlntAreaUoM	Planting Area - Unit of Measure
PrepaymentColltrlPlntAreaAmt	I_PrepaymentAgrmtCollateralTP	PrepaymentColltrlPlntAreaAmt	Plnt Area Amt
PrepaymentColltrlPlntAreaCrcy	I_PrepaymentAgrmtCollateralTP	PrepaymentColltrlPlntAreaCrcy	Land Area - Currency
PrepaymentColltrlCattleAreaQty
PrepaymentColltrlCattleAreaUoM	I_PrepaymentAgrmtCollateralTP	PrepaymentColltrlCattleAreaUoM	Cattle Area - Unit of Measure
PrepaymentColltrlCattleAreaAmt	I_PrepaymentAgrmtCollateralTP	PrepaymentColltrlCattleAreaAmt	Cattle Area Amt
PrepaymentColltrlCattleCrcy	I_PrepaymentAgrmtCollateralTP	PrepaymentColltrlCattleCrcy	Cattle Area Amount - Currency
PrepaymentColltrlClsdAreaQty
PrepaymentColltrlClsdAreaUoM	I_PrepaymentAgrmtCollateralTP	PrepaymentColltrlClsdAreaUoM	Closed Area - Unit of Measure
PrepaymentColltrlClsdAreaAmt	I_PrepaymentAgrmtCollateralTP	PrepaymentColltrlClsdAreaAmt	Clsd Area Amt
PrepaymentColltrlClsdAreaCrcy	I_PrepaymentAgrmtCollateralTP	PrepaymentColltrlClsdAreaCrcy	Closed Area Amount - Currency
PrepaymentColltrlEnvrmtAreaQty
PrepaymentColltrlEnvrmtAreaUoM	I_PrepaymentAgrmtCollateralTP	PrepaymentColltrlEnvrmtAreaUoM	Environmental Reserve Area - UoM
PrepaymentColltrlEnvrmtAreaAmt	I_PrepaymentAgrmtCollateralTP	PrepaymentColltrlEnvrmtAreaAmt	Envrmt Area Amt
PrepaymentColltrlEnvrmtCrcy	I_PrepaymentAgrmtCollateralTP	PrepaymentColltrlEnvrmtCrcy	environmental Reserve Area - Currency
PrepaymentColltrlInvmtText
PrepaymentColltrlInvmtAmt	I_PrepaymentAgrmtCollateralTP	PrepaymentColltrlInvmtAmt	Investment Amount
PrepaymentColltrlInvmtAmtCrcy	I_PrepaymentAgrmtCollateralTP	PrepaymentColltrlInvmtAmtCrcy	Improvements Amount - Currency
PrepaymentColltrlRotateAreaAmt
PrepaymentColltrlRotateAmtCrcy	I_PrepaymentAgrmtCollateralTP	PrepaymentColltrlRotateAmtCrcy	Rotate Area Amount - Currency
PrepaymentColltrlRotateDuDte	I_PrepaymentAgrmtCollateralTP	PrepaymentColltrlRotateDuDte	Rotate Due Date
PrepaymentColltrlTotAmt	I_PrepaymentAgrmtCollateralTP	PrepaymentColltrlTotAmt	Coll Total Amount
PrepaymentColltrlTotAmtCrcy	I_PrepaymentAgrmtCollateralTP	PrepaymentColltrlTotAmtCrcy	Total Amount - Currency
CountryCode	I_PrepaymentAgrmtCollateralTP	CountryCode	Country/Reg.
CountryName	_CountryText	CountryName	Country
CompanyRegion	I_PrepaymentAgrmtCollateralTP	CompanyRegion	Region
PrepaymentColltrlCityCode	I_PrepaymentAgrmtCollateralTP	PrepaymentColltrlCityCode	City Code
PrepaymentColltrlBnfcyName	I_PrepaymentAgrmtCollateralTP	PrepaymentColltrlBnfcyName	Colltrl Beneficiary
PrepaymentColltrlSitn	I_PrepaymentAgrmtCollateralTP	PrepaymentColltrlSitn	Collateral Situation
PrepaymentColltrlDegText	I_PrepaymentAgrmtCollateralTP	PrepaymentColltrlDegText	Collateral Degree
PrepaymentColltrlAvgProdnQty	I_PrepaymentAgrmtCollateralTP	PrepaymentColltrlAvgProdnQty	Avg Prodn Pawned Are
PrepaymentColltrlAvgProdnUoM	I_PrepaymentAgrmtCollateralTP	PrepaymentColltrlAvgProdnUoM	Average Production - Unit of Measure
PrepaymentColltrlProdnWgtUoM	I_PrepaymentAgrmtCollateralTP	PrepaymentColltrlProdnWgtUoM	Average Production Weight - UoM
PrepaymentColltrlCmtdQty	I_PrepaymentAgrmtCollateralTP	PrepaymentColltrlCmtdQty	Committed Quantity
PrepaymentColltrlCmtdQtyUoM	I_PrepaymentAgrmtCollateralTP	PrepaymentColltrlCmtdQtyUoM	Committed Quantity - Unit of Measure
PrepaymentColltrlRegNmbrText	I_PrepaymentAgrmtCollateralTP	PrepaymentColltrlRegNmbrText	Register Number
PrepaymentColltrlTxCodeJx	I_PrepaymentAgrmtCollateralTP	PrepaymentColltrlTxCodeJx	TaxCode Jurisdiction
PrepaymentColltrlRespName	I_PrepaymentAgrmtCollateralTP	PrepaymentColltrlRespName	Appraisal Respnsble
PrepaymentColltrlAppraisalDte	I_PrepaymentAgrmtCollateralTP	PrepaymentColltrlAppraisalDte	Coll. Apprsl Date
PrepaymentColltrlDuDte	I_PrepaymentAgrmtCollateralTP	PrepaymentColltrlDuDte	Collateral Due Date
PrepaymentColltrlVenalValAmt	I_PrepaymentAgrmtCollateralTP	PrepaymentColltrlVenalValAmt	Coll Venal Value
PrepaymentColltrlVenalValCrcy	I_PrepaymentAgrmtCollateralTP	PrepaymentColltrlVenalValCrcy	Venal Value - Currency
PrepaymentColltrlStmntText	I_PrepaymentAgrmtCollateralTP	PrepaymentColltrlStmntText	Coll Trader Statmnt
PrepaymentColltrlDesc	I_PrepaymentAgrmtCollateralTP	PrepaymentColltrlDesc	Collateral Desc.
PrepaymentMortgageCmtdAmt	I_PrepaymentAgrmtCollateralTP	PrepaymentMortgageCmtdAmt	Mortgage Commitd Amt
PrepaymentMortgageCmtdAmtCrcy	I_PrepaymentAgrmtCollateralTP	PrepaymentMortgageCmtdAmtCrcy	Committed Area Amount - Currency
PrepaymentColltrlObsvnText	I_PrepaymentAgrmtCollateralTP	PrepaymentColltrlObsvnText	Colltrl Observations
CompanyCode	_PrepaymentAgreement	CompanyCode	Receiver Company Code
PrepaymentAgreementType	_PrepaymentAgreement	PrepaymentAgreementType	Prepay Agreemnt Type
PrepaymentAgreementCategory	_PrepaymentAgreement	PrepaymentAgreementCategory	Prepayment Category
Associations_PrepaymentAgreement
_CollateralPartners		_CollateralPartners
_CollateralExtension1		_CollateralExtension1
_CollateralType		_CollateralType
_CountryText		_CountryText
_RegionText		_RegionText
_CityCodeText		_CityCodeText
_TaxJurisdictionText		_TaxJurisdictionText

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_PrepaymentAgrmtCollateralTP.
-- 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: CPPMGCOLLTRLTP

CREATE VIEW C_PrepaymentAgrmtCollateralTP AS
SELECT
  Collateral.PrepaymentColltrlSubType AS PrepaymentColltrlSubType,
  Collateral.PrepaymentColltrlCode AS PrepaymentColltrlCode,
  Collateral.PrepaymentColltrlLandAreaUoM AS PrepaymentColltrlLandAreaUoM,
  Collateral.PrepaymentColltrlTotPrptyUoM AS PrepaymentColltrlTotPrptyUoM,
  Collateral.PrepaymentColltrlAreaUoM AS PrepaymentColltrlAreaUoM,
  Collateral.PrepaymentColltrlProdtvAreaUoM AS PrepaymentColltrlProdtvAreaUoM,
  Collateral.PrepaymentColltrlPlntAreaUoM AS PrepaymentColltrlPlntAreaUoM,
  Collateral.PrepaymentColltrlPlntAreaAmt AS PrepaymentColltrlPlntAreaAmt,
  Collateral.PrepaymentColltrlPlntAreaCrcy AS PrepaymentColltrlPlntAreaCrcy,
  Collateral.PrepaymentColltrlCattleAreaUoM AS PrepaymentColltrlCattleAreaUoM,
  Collateral.PrepaymentColltrlCattleAreaAmt AS PrepaymentColltrlCattleAreaAmt,
  Collateral.PrepaymentColltrlCattleCrcy AS PrepaymentColltrlCattleCrcy,
  Collateral.PrepaymentColltrlClsdAreaUoM AS PrepaymentColltrlClsdAreaUoM,
  Collateral.PrepaymentColltrlClsdAreaAmt AS PrepaymentColltrlClsdAreaAmt,
  Collateral.PrepaymentColltrlClsdAreaCrcy AS PrepaymentColltrlClsdAreaCrcy,
  Collateral.PrepaymentColltrlEnvrmtAreaUoM AS PrepaymentColltrlEnvrmtAreaUoM,
  Collateral.PrepaymentColltrlEnvrmtAreaAmt AS PrepaymentColltrlEnvrmtAreaAmt,
  Collateral.PrepaymentColltrlEnvrmtCrcy AS PrepaymentColltrlEnvrmtCrcy,
  Collateral.PrepaymentColltrlInvmtAmt AS PrepaymentColltrlInvmtAmt,
  Collateral.PrepaymentColltrlInvmtAmtCrcy AS PrepaymentColltrlInvmtAmtCrcy,
  Collateral.PrepaymentColltrlRotateAmtCrcy AS PrepaymentColltrlRotateAmtCrcy,
  Collateral.PrepaymentColltrlRotateDuDte AS PrepaymentColltrlRotateDuDte,
  Collateral.PrepaymentColltrlTotAmt AS PrepaymentColltrlTotAmt,
  Collateral.PrepaymentColltrlTotAmtCrcy AS PrepaymentColltrlTotAmtCrcy,
  Collateral.CountryCode AS CountryCode,
  _CountryText.CountryName AS CountryName,
  Collateral.CompanyRegion AS CompanyRegion,
  Collateral.PrepaymentColltrlCityCode AS PrepaymentColltrlCityCode,
  Collateral.PrepaymentColltrlBnfcyName AS PrepaymentColltrlBnfcyName,
  Collateral.PrepaymentColltrlSitn AS PrepaymentColltrlSitn,
  Collateral.PrepaymentColltrlDegText AS PrepaymentColltrlDegText,
  Collateral.PrepaymentColltrlAvgProdnQty AS PrepaymentColltrlAvgProdnQty,
  Collateral.PrepaymentColltrlAvgProdnUoM AS PrepaymentColltrlAvgProdnUoM,
  Collateral.PrepaymentColltrlProdnWgtUoM AS PrepaymentColltrlProdnWgtUoM,
  Collateral.PrepaymentColltrlCmtdQty AS PrepaymentColltrlCmtdQty,
  Collateral.PrepaymentColltrlCmtdQtyUoM AS PrepaymentColltrlCmtdQtyUoM,
  Collateral.PrepaymentColltrlRegNmbrText AS PrepaymentColltrlRegNmbrText,
  Collateral.PrepaymentColltrlTxCodeJx AS PrepaymentColltrlTxCodeJx,
  Collateral.PrepaymentColltrlRespName AS PrepaymentColltrlRespName,
  Collateral.PrepaymentColltrlAppraisalDte AS PrepaymentColltrlAppraisalDte,
  Collateral.PrepaymentColltrlDuDte AS PrepaymentColltrlDuDte,
  Collateral.PrepaymentColltrlVenalValAmt AS PrepaymentColltrlVenalValAmt,
  Collateral.PrepaymentColltrlVenalValCrcy AS PrepaymentColltrlVenalValCrcy,
  Collateral.PrepaymentColltrlStmntText AS PrepaymentColltrlStmntText,
  Collateral.PrepaymentColltrlDesc AS PrepaymentColltrlDesc,
  Collateral.PrepaymentMortgageCmtdAmt AS PrepaymentMortgageCmtdAmt,
  Collateral.PrepaymentMortgageCmtdAmtCrcy AS PrepaymentMortgageCmtdAmtCrcy,
  Collateral.PrepaymentColltrlObsvnText AS PrepaymentColltrlObsvnText,
  _PrepaymentAgreement.CompanyCode AS CompanyCode,
  _PrepaymentAgreement.PrepaymentAgreementType AS PrepaymentAgreementType,
  _PrepaymentAgreement.PrepaymentAgreementCategory AS PrepaymentAgreementCategory
FROM I_PrepaymentAgrmtCollateralTP AS Collateral
LEFT OUTER JOIN C_PrepaymentAgreementTP AS _PrepaymentAgreement ON PrepaymentAgreementUUID = _PrepaymentAgreement.PrepaymentAgreementUUID  -- association [1..1]
LEFT OUTER JOIN C_PrepaymentAgrmtPartnersTP AS _CollateralPartners ON PrepaymentAgrmtColltrlUUID = _CollateralPartners.PrepaymentAgrmtColltrlUUID  -- association [0..*]
LEFT OUTER JOIN C_PrepaymentAgrmtColExt1TP AS _CollateralExtension1 ON PrepaymentAgrmtColltrlUUID = _CollateralExtension1.PrepaymentAgrmtColltrlUUID  -- association [0..*]
LEFT OUTER JOIN I_PrepaymentColltrlTypeVH AS _CollateralType ON PrepaymentColltrlType = _CollateralType.PrepaymentAgrmtColltrlTypeCode AND _CollateralType.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CountryText AS _CountryText ON CountryCode = _CountryText.Country AND _CountryText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_RegionText AS _RegionText ON CompanyRegion = _RegionText.Region AND _RegionText.Language = $session.system_language AND CountryCode = _RegionText.Country  -- association [0..1]
LEFT OUTER JOIN I_CityCodeText AS _CityCodeText ON PrepaymentColltrlCityCode = _CityCodeText.CityCode AND CountryCode = _CityCodeText.Country AND CompanyRegion = _CityCodeText.Region AND _CityCodeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_TaxJurisdictionText AS _TaxJurisdictionText ON PrepaymentColltrlTxCodeJx = _TaxJurisdictionText.TaxJurisdiction AND _TaxJurisdictionText.Language = $session.system_language  -- association [0..*]
LEFT OUTER JOIN E_PrepaymentAgrmtCollateral AS _Extension ON PrepaymentAgrmtColltrlUUID = _Extension.PrepaymentAgrmtColltrlUUID  -- association [0..1]
;

Depth:

C_PrepaymentAgrmtCollateralTP view

I_PrepaymentAgrmtCollateralTP view