I_PrepaymentAgrmtContracts

DDL: I_PREPAYMENTAGRMTCONTRACTS SQL: IPPMTCON Type: view BASIC
33 Fields 1 Data Sources 4 Associations

Prepayment Agreement Contracts

I_PrepaymentAgrmtContracts is a Basic CDS View that provides data about "Prepayment Agreement Contracts" in SAP S/4HANA. It reads from 1 data source (I_PrepaymentAssignedDocument) and exposes 33 fields with key fields PrepaymentAssignedDocumentUUID, PrepaymentAgreementUUID, PrepaymentAgreement. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_PrepaymentAssignedDocument AssignedDocuments from

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_PrepaymentApproval _PrepaymentAgrmtApproval _PrepaymentAgrmtApproval.PrepaymentAgreement = AssignedDocuments.PrepaymentAgreement --Prepayment Agreement Status
[0..1] I_SystemStatusText _PrepaymentStatusText _PrepaymentStatusText.SystemStatus = AssignedDocuments.PrepaymentAgreementStatus and _PrepaymentStatusText.Language = $session.system_language --Prepayment Posting Status
[0..1] I_SystemStatusText _PostingStatusText _PostingStatusText.SystemStatus = AssignedDocuments.PrepaymentAgrmtPostingStatus and _PostingStatusText.Language = $session.system_language --Prepayment Barter Link Status
[0..1] P_PpaytAgrmtBarterLnkStsTxt _BarterLinkStatusText _BarterLinkStatusText.PrepaymentAgrmtDomainCode = AssignedDocuments.PrepaymentBarterLinkStatus and _BarterLinkStatusText.Language = $session.system_language

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IPPMTCON view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #BASIC view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Prepayment Agreement Contracts view

Fields (33)

KeyFieldSource TableSource FieldDescription
KEY PrepaymentAssignedDocumentUUID I_PrepaymentAssignedDocument PrepaymentAssignedDocumentUUID Key
KEY PrepaymentAgreementUUID I_PrepaymentAssignedDocument PrepaymentAgreementUUID Key
KEY PrepaymentAgreement I_PrepaymentAssignedDocument PrepaymentAgreement Renegotiation PPA
Counterparty
CompanyCode
PrepaymentAgreementStatus
PrepaymentAgrmtLinkStatus
PrepaymentAgrmtPostingStatus
PrepaymentBarterLinkStatus I_PrepaymentAssignedDocument PrepaymentBarterLinkStatus Prepmt Barter Status
PrepaymentAgreementType
ProcessingStatusDesc _PrepaymentStatusText SystemStatusName
LoanPaymentStatusText _PostingStatusText SystemStatusName
AssignmentStatusText _BarterLinkStatusText PrepaymentAgrmtDomainText
PrepaymentAgreementCategory
PrepaymentPayoutPercent
PrepaymentStopIntrstDateType
PrepaymentStartIntrstDateType
PrepaymentRenegttnStopDate
PrepaymentSuspendIntrstFromDte
PrepaymentSuspendIntrstToDte
PrepaymentPostingProfile
PrepaymentAgreementAmount
PrepaymentAgrmtLinkAmount I_PrepaymentAssignedDocument PrepaymentAgrmtLinkAmount Pre Agrm Amount
PrepaymentAgreementCurrency
PrepaymentAgreementCommodity
PrepaymentAgrmtIsPosted _PrepaymentAgrmtApproval PrepaymentAgrmtIsPosted Pre Agreement Posted
FinalSettlementIndicator _PrepaymentAgrmtApproval FinalSettlementIndicator Final Settlement
PrepaymentAgrmtRefDocument I_PrepaymentAssignedDocument PrepaymentAgrmtRefDocument Linking Document No.
PrepaymentAgrmtRefDocItem I_PrepaymentAssignedDocument PrepaymentAgrmtRefDocItem Linking Docu No. Itm
PrepaymentAgrmtRefDocYear I_PrepaymentAssignedDocument PrepaymentAgrmtRefDocYear Reference Doc Year
PrepaymentIsAssignedViaEconGrp I_PrepaymentAssignedDocument PrepaymentIsAssignedViaEconGrp
PrepaymentEconomicGroup I_PrepaymentAssignedDocument PrepaymentEconomicGroup Economic Group
PrepaymentAgrmtRefDocumentType I_PrepaymentAssignedDocument PrepaymentAgrmtRefDocumentType Document Type

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_PrepaymentAgrmtContracts.
-- 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: IPPMTCON

CREATE VIEW I_PrepaymentAgrmtContracts AS
SELECT
  AssignedDocuments.PrepaymentAssignedDocumentUUID AS PrepaymentAssignedDocumentUUID,
  AssignedDocuments.PrepaymentAgreementUUID AS PrepaymentAgreementUUID,
  AssignedDocuments.PrepaymentAgreement AS PrepaymentAgreement,
  AssignedDocuments._PrepaymentAgreement.Counterparty AS Counterparty,
  AssignedDocuments._PrepaymentAgreement.CompanyCode AS CompanyCode,
  AssignedDocuments._PrepaymentAgreement.PrepaymentAgreementStatus AS PrepaymentAgreementStatus,
  AssignedDocuments._PrepaymentAgreement.PrepaymentAgrmtLinkStatus AS PrepaymentAgrmtLinkStatus,
  AssignedDocuments._PrepaymentAgreement.PrepaymentAgrmtPostingStatus AS PrepaymentAgrmtPostingStatus,
  AssignedDocuments.PrepaymentBarterLinkStatus AS PrepaymentBarterLinkStatus,
  AssignedDocuments._PrepaymentAgreement.PrepaymentAgreementType AS PrepaymentAgreementType,
  _PrepaymentStatusText.SystemStatusName AS ProcessingStatusDesc,
  _PostingStatusText.SystemStatusName AS LoanPaymentStatusText,
  _BarterLinkStatusText.PrepaymentAgrmtDomainText AS AssignmentStatusText,
  AssignedDocuments._PrepaymentAgreement.PrepaymentAgreementCategory AS PrepaymentAgreementCategory,
  AssignedDocuments._PrepaymentAgreement.PrepaymentPayoutPercent AS PrepaymentPayoutPercent,
  AssignedDocuments._PrepaymentAgreement.PrepaymentStopIntrstDateType AS PrepaymentStopIntrstDateType,
  AssignedDocuments._PrepaymentAgreement.PrepaymentStartIntrstDateType AS PrepaymentStartIntrstDateType,
  AssignedDocuments._PrepaymentAgreement.PrepaymentRenegttnStopDate AS PrepaymentRenegttnStopDate,
  AssignedDocuments._PrepaymentAgreement.PrepaymentSuspendIntrstFromDte AS PrepaymentSuspendIntrstFromDte,
  AssignedDocuments._PrepaymentAgreement.PrepaymentSuspendIntrstToDte AS PrepaymentSuspendIntrstToDte,
  AssignedDocuments._PrepaymentAgreement.PrepaymentPostingProfile AS PrepaymentPostingProfile,
  AssignedDocuments._PrepaymentAgreement.PrepaymentAgreementAmount AS PrepaymentAgreementAmount,
  AssignedDocuments.PrepaymentAgrmtLinkAmount AS PrepaymentAgrmtLinkAmount,
  AssignedDocuments._PrepaymentAgreement.PrepaymentAgreementCurrency AS PrepaymentAgreementCurrency,
  AssignedDocuments._PrepaymentAgreement.PrepaymentAgreementCommodity AS PrepaymentAgreementCommodity,
  _PrepaymentAgrmtApproval.PrepaymentAgrmtIsPosted AS PrepaymentAgrmtIsPosted,
  _PrepaymentAgrmtApproval.FinalSettlementIndicator AS FinalSettlementIndicator,
  AssignedDocuments.PrepaymentAgrmtRefDocument AS PrepaymentAgrmtRefDocument,
  AssignedDocuments.PrepaymentAgrmtRefDocItem AS PrepaymentAgrmtRefDocItem,
  AssignedDocuments.PrepaymentAgrmtRefDocYear AS PrepaymentAgrmtRefDocYear,
  AssignedDocuments.PrepaymentIsAssignedViaEconGrp AS PrepaymentIsAssignedViaEconGrp,
  AssignedDocuments.PrepaymentEconomicGroup AS PrepaymentEconomicGroup,
  AssignedDocuments.PrepaymentAgrmtRefDocumentType AS PrepaymentAgrmtRefDocumentType
FROM I_PrepaymentAssignedDocument AS AssignedDocuments
LEFT OUTER JOIN I_PrepaymentApproval AS _PrepaymentAgrmtApproval ON _PrepaymentAgrmtApproval.PrepaymentAgreement = AssignedDocuments.PrepaymentAgreement  -- association [0..1]
LEFT OUTER JOIN I_SystemStatusText AS _PrepaymentStatusText ON _PrepaymentStatusText.SystemStatus = AssignedDocuments.PrepaymentAgreementStatus AND _PrepaymentStatusText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SystemStatusText AS _PostingStatusText ON _PostingStatusText.SystemStatus = AssignedDocuments.PrepaymentAgrmtPostingStatus AND _PostingStatusText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN P_PpaytAgrmtBarterLnkStsTxt AS _BarterLinkStatusText ON _BarterLinkStatusText.PrepaymentAgrmtDomainCode = AssignedDocuments.PrepaymentBarterLinkStatus AND _BarterLinkStatusText.Language = $session.system_language  -- association [0..1]
;

Learn More