What is C_PrepaymentAgrmtDistrTP in SAP S/4HANA?

C_PrepaymentAgrmtDistrTP is a consumption CDS view in SAP S/4HANA. Prepayment Agreement Distribution It contains 33 fields.

Which tables does C_PrepaymentAgrmtDistrTP read from?

C_PrepaymentAgrmtDistrTP reads data from: I_PrepaymentAgrmtDistrTP.

What VDM layer is C_PrepaymentAgrmtDistrTP?

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

C_PrepaymentAgrmtDistrTP

DDL: C_PREPAYMENTAGRMTDISTRTP SQL: CPPAGRDISTRTP Type: view CONSUMPTION

33 Fields 1 Data Sources 7 Associations

Prepayment Agreement Distribution

C_PrepaymentAgrmtDistrTP is a Consumption CDS View that provides data about "Prepayment Agreement Distribution" in SAP S/4HANA. It reads from 1 data source (I_PrepaymentAgrmtDistrTP) and exposes 33 fields with key field PrepaymentAgrmtDistrUUID. It has 7 associations to related views.

Data Sources (1)

Source	Alias	Join Type
I_PrepaymentAgrmtDistrTP	PrepaymentAgmntDistr	from

Associations (7)

Cardinality	Target	Alias	Condition
[1..1]	C_PrepaymentAgreementTP	_PrepaymentAgreement	`$projection.PrepaymentAgreementUUID = _PrepaymentAgreement.PrepaymentAgreementUUID --Distribution Type Text`
[0..1]	I_PrepaymentAgrmtDistrTypeVH	_DistrType	`$projection.PrepaymentDistrType = _DistrType.PrepaymentAgrmtDomainCode and _DistrType.PrepaymentAgrmtDomainLangCode = $session.system_language --Commodity Type`
[0..1]	I_ProductDescription	_ProductDescription	`$projection.PrepaymentAgreementProduct = _ProductDescription.Product and _ProductDescription.Language = $session.system_language --Business partner`
[0..1]	I_BusinessPartner	_BPText	`$projection.PrepaymentDistrBeneficiaryName = _BPText.BusinessPartner --Prepayment system status`
[0..1]	I_SystemStatusText	_PostingStatusText	`$projection.PrepaymentAgrmtDistrPostingSts = _PostingStatusText.SystemStatus and _PostingStatusText.Language = $session.system_language --`
[0..1]	I_PrepaymentAgrmtLinkStsText	_LinkStatusText	`$projection.PrepaymentAgrmtDistrLinkSts = _LinkStatusText.PrepaymentAgrmtDomainCode and _LinkStatusText.Language = $session.system_language -- Extension View for Distribution in Prepayment`
[0..1]	E_PrepaymentAgrmtDistribution	_Extension	`$projection.PrepaymentAgrmtDistrUUID = _Extension.PrepaymentAgrmtDistrUUID`

Annotations (19)

Name	Value	Level
AbapCatalog.sqlViewName	CPPAGRDISTRTP	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#MANDATORY	view
AccessControl.personalData.blocking	#REQUIRED	view
EndUserText.label	Prepayment Agreement Distribution	view
VDM.viewType	#CONSUMPTION	view
Search.searchable	true	view
Metadata.allowExtensions	true	view
ClientHandling.type	#CLIENT_DEPENDENT	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.createEnabled	EXTERNAL_CALCULATION	view
ObjectModel.updateEnabled	EXTERNAL_CALCULATION	view
ObjectModel.deleteEnabled	EXTERNAL_CALCULATION	view
ObjectModel.draftEnabled	true	view
ObjectModel.transactionalProcessingDelegated	true	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#M	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view

Fields (33)

Key	Field	Source Table	Source Field	Description
KEY	PrepaymentAgrmtDistrUUID	I_PrepaymentAgrmtDistrTP	PrepaymentAgrmtDistrUUID	Key
	PrepaymentAgreementUUID	I_PrepaymentAgrmtDistrTP	PrepaymentAgreementUUID	Key
	PrepaymentDistrTypeasPrepaymentDistrType
	PrepaymentDistrPaymentDate	I_PrepaymentAgrmtDistrTP	PrepaymentDistrPaymentDate	Payment Date
	PrepaymentDistrBeneficiaryName	I_PrepaymentAgrmtDistrTP	PrepaymentDistrBeneficiaryName	Busn. Partner
	PrepaymentDistrAmount	I_PrepaymentAgrmtDistrTP	PrepaymentDistrAmount	Distribution Amount
	PrepaymentDistrCurrency	I_PrepaymentAgrmtDistrTP	PrepaymentDistrCurrency	Currency
	PrepaymentDistrQuantity	I_PrepaymentAgrmtDistrTP	PrepaymentDistrQuantity	Distribution Qnty
	PrepaymentDistrUoM	I_PrepaymentAgrmtDistrTP	PrepaymentDistrUoM	Distri. UoM
	PrepaymentAgreementProduct	I_PrepaymentAgrmtDistrTP	PrepaymentAgreementProduct	Prepayment Product
	PrepaymentAgreementFXDate	I_PrepaymentAgrmtDistrTP	PrepaymentAgreementFXDate	Prepayment ForexDate
	PrepaymentAgreementFXRate	I_PrepaymentAgrmtDistrTP	PrepaymentAgreementFXRate	Prepayment FX Rate
	PrepaymentAgreementExchRate	I_PrepaymentAgrmtDistrTP	PrepaymentAgreementExchRate	Prepayment FX Rate
	PrepaymentDistrCnvrsnFctr	I_PrepaymentAgrmtDistrTP	PrepaymentDistrCnvrsnFctr	Conversion Factor
	PrepaymentDistrUnitValCrcy	I_PrepaymentAgrmtDistrTP	PrepaymentDistrUnitValCrcy	Distri. Unit Curr.
	PrepaymentDistrUnitValUoM	I_PrepaymentAgrmtDistrTP	PrepaymentDistrUnitValUoM	Distri. Value UoM
	BuyerTaxCode	I_PrepaymentAgrmtDistrTP	BuyerTaxCode	Tax Code
	DocumentItemNumber	I_PrepaymentAgrmtDistrTP	DocumentItemNumber	Item
	PrepaymentAgrmtDistrLinkSts	I_PrepaymentAgrmtDistrTP	PrepaymentAgrmtLinkStatus	Link Status
	PrepaymentAgrmtDistrPostingSts	I_PrepaymentAgrmtDistrTP	PrepaymentAgrmtPostingStatus	Pre Posting Status
	CompanyCode	_PrepaymentAgreement	CompanyCode	Receiver Company Code
	Counterparty	_PrepaymentAgreement	Counterparty	Supplier
	SalesOrganization	_PrepaymentAgreement	SalesOrganization	Sales Organization
	DistributionChannel	_PrepaymentAgreement	DistributionChannel	RefDistCh-Cust/Mat.
	PrepaymentAgreementType	_PrepaymentAgreement	PrepaymentAgreementType	Prepay Agreemnt Type
	PrepaymentAgreementCategory	_PrepaymentAgreement	PrepaymentAgreementCategory	Prepayment Category
	PrepaymentAgrmtBPType	_PrepaymentAgreement	PrepaymentAgrmtBPType	Counterparty Type
	Associations_PrepaymentAgreement
	_DistrType		_DistrType
	_BPText		_BPText
	_ProductDescription		_ProductDescription
	_PostingStatusText		_PostingStatusText
	_LinkStatusText		_LinkStatusText

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_PrepaymentAgrmtDistrTP.
-- 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: CPPAGRDISTRTP

CREATE VIEW C_PrepaymentAgrmtDistrTP AS
SELECT
  PrepaymentAgmntDistr.PrepaymentAgrmtDistrUUID AS PrepaymentAgrmtDistrUUID,
  PrepaymentAgmntDistr.PrepaymentAgreementUUID AS PrepaymentAgreementUUID,
  PrepaymentAgmntDistr.PrepaymentDistrPaymentDate AS PrepaymentDistrPaymentDate,
  PrepaymentAgmntDistr.PrepaymentDistrBeneficiaryName AS PrepaymentDistrBeneficiaryName,
  PrepaymentAgmntDistr.PrepaymentDistrAmount AS PrepaymentDistrAmount,
  PrepaymentAgmntDistr.PrepaymentDistrCurrency AS PrepaymentDistrCurrency,
  PrepaymentAgmntDistr.PrepaymentDistrQuantity AS PrepaymentDistrQuantity,
  PrepaymentAgmntDistr.PrepaymentDistrUoM AS PrepaymentDistrUoM,
  PrepaymentAgmntDistr.PrepaymentAgreementProduct AS PrepaymentAgreementProduct,
  PrepaymentAgmntDistr.PrepaymentAgreementFXDate AS PrepaymentAgreementFXDate,
  PrepaymentAgmntDistr.PrepaymentAgreementFXRate AS PrepaymentAgreementFXRate,
  PrepaymentAgmntDistr.PrepaymentAgreementExchRate AS PrepaymentAgreementExchRate,
  PrepaymentAgmntDistr.PrepaymentDistrCnvrsnFctr AS PrepaymentDistrCnvrsnFctr,
  PrepaymentAgmntDistr.PrepaymentDistrUnitValCrcy AS PrepaymentDistrUnitValCrcy,
  PrepaymentAgmntDistr.PrepaymentDistrUnitValUoM AS PrepaymentDistrUnitValUoM,
  PrepaymentAgmntDistr.BuyerTaxCode AS BuyerTaxCode,
  PrepaymentAgmntDistr.DocumentItemNumber AS DocumentItemNumber,
  PrepaymentAgmntDistr.PrepaymentAgrmtLinkStatus AS PrepaymentAgrmtDistrLinkSts,
  PrepaymentAgmntDistr.PrepaymentAgrmtPostingStatus AS PrepaymentAgrmtDistrPostingSts,
  _PrepaymentAgreement.CompanyCode AS CompanyCode,
  _PrepaymentAgreement.Counterparty AS Counterparty,
  _PrepaymentAgreement.SalesOrganization AS SalesOrganization,
  _PrepaymentAgreement.DistributionChannel AS DistributionChannel,
  _PrepaymentAgreement.PrepaymentAgreementType AS PrepaymentAgreementType,
  _PrepaymentAgreement.PrepaymentAgreementCategory AS PrepaymentAgreementCategory,
  _PrepaymentAgreement.PrepaymentAgrmtBPType AS PrepaymentAgrmtBPType
FROM I_PrepaymentAgrmtDistrTP AS PrepaymentAgmntDistr
LEFT OUTER JOIN C_PrepaymentAgreementTP AS _PrepaymentAgreement ON PrepaymentAgreementUUID = _PrepaymentAgreement.PrepaymentAgreementUUID  -- association [1..1]
LEFT OUTER JOIN I_PrepaymentAgrmtDistrTypeVH AS _DistrType ON PrepaymentDistrType = _DistrType.PrepaymentAgrmtDomainCode AND _DistrType.PrepaymentAgrmtDomainLangCode = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ProductDescription AS _ProductDescription ON PrepaymentAgreementProduct = _ProductDescription.Product AND _ProductDescription.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _BPText ON PrepaymentDistrBeneficiaryName = _BPText.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_SystemStatusText AS _PostingStatusText ON PrepaymentAgrmtDistrPostingSts = _PostingStatusText.SystemStatus AND _PostingStatusText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_PrepaymentAgrmtLinkStsText AS _LinkStatusText ON PrepaymentAgrmtDistrLinkSts = _LinkStatusText.PrepaymentAgrmtDomainCode AND _LinkStatusText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN E_PrepaymentAgrmtDistribution AS _Extension ON PrepaymentAgrmtDistrUUID = _Extension.PrepaymentAgrmtDistrUUID  -- association [0..1]
;

Depth:

C_PrepaymentAgrmtDistrTP view

I_PrepaymentAgrmtDistrTP view