I_ACMTrdgContrPrePaytDet

DDL: I_ACMTRDGCONTRPREPAYTDET SQL: IACMCONTRPREPAY Type: view COMPOSITE
26 Fields 1 Data Sources 1 Associations

Trading Contract Item Prepayment Term

I_ACMTrdgContrPrePaytDet is a Composite CDS View that provides data about "Trading Contract Item Prepayment Term" in SAP S/4HANA. It reads from 1 data source (P_PrepaymentAssignedDocument) and exposes 26 fields with key fields DocNumber, DocumentItemNumber, TradingContractNumber, TradingContractItem. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
P_PrepaymentAssignedDocument AssignedDocuments from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_ACMTrdgContrHdr _ContractHeader $projection.TradingContractNumber = _ContractHeader.TradingContractNumber

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IACMCONTRPREPAY view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
EndUserText.label Trading Contract Item Prepayment Term view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY DocNumber
KEY DocumentItemNumber P_PrepaymentAssignedDocument DocumentItemNumber Item
KEY TradingContractNumber P_PrepaymentAssignedDocument PrepaymentAgrmtRefDocument Linking Document No.
KEY TradingContractItem P_PrepaymentAssignedDocument PrepaymentAgrmtRefDocItem Linking Docu No. Itm
PrepaymentAssignedDocumentUUID P_PrepaymentAssignedDocument PrepaymentAssignedDocumentUUID Key
Counterparty PrepaymentAgreement Counterparty Supplier
CompanyCode PrepaymentAgreement CompanyCode Receiver Company Code
PrepaymentAgreementStatus PrepaymentAgreement PrepaymentAgreementStatus Pre Agreement Status
PrepaymentAgrmtLinkStatus PrepaymentAgreement PrepaymentAgrmtLinkStatus Link Status
PrepaymentAgrmtPostingStatus PrepaymentAgreement PrepaymentAgrmtPostingStatus Pre Posting Status
PrepaymentBarterLinkStatus PrepaymentAgreement PrepaymentBarterLinkStatus Prepmt Barter Status
PrepaymentAgreementType PrepaymentAgreement PrepaymentAgreementType Prepay Agreemnt Type
PrepaymentAgreementCategory PrepaymentAgreement PrepaymentAgreementCategory Prepayment Category
PrepaymentPayoutPercent PrepaymentAgreement PrepaymentPayoutPercent Payout Percentage
PrepaymentStopIntrstDateType PrepaymentAgreement PrepaymentStopIntrstDateType Int. Stop Date Type
PrepaymentStartIntrstDateType PrepaymentAgreement PrepaymentStartIntrstDateType Int. Start Date Type
PrepaymentAgreementAmount PrepaymentAgreement PrepaymentAgreementAmount Pre Agrm Amount
PrepaymentAgrmtLinkAmount P_PrepaymentAssignedDocument PrepaymentAgrmtLinkAmount Pre Agrm Amount
PrepaymentAgreementCurrency PrepaymentAgreement PrepaymentAgreementCurrency Currency
PrepaymentAgreementCommodity PrepaymentAgreement PrepaymentAgreementCommodity Commodity
PrepaymentAgrmtIsPosted PrepaymentAgrmtApproval PrepaymentAgrmtIsPosted Pre Agreement Posted
FinalSettlementIndicator PrepaymentAgrmtApproval FinalSettlementIndicator Final Settlement
PrepaymentAgrmtRefDocYear P_PrepaymentAssignedDocument PrepaymentAgrmtRefDocYear Reference Doc Year
PrepaymentAgrmtRefDocumentType P_PrepaymentAssignedDocument PrepaymentAgrmtRefDocumentType Document Type
_ContractItem _ContractItem
_ContractHeader _ContractHeader

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_ACMTrdgContrPrePaytDet.
-- 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: IACMCONTRPREPAY

CREATE VIEW I_ACMTrdgContrPrePaytDet AS
SELECT
  cast(AssignedDocuments.DocNumber as abap.char( 25 )) AS DocNumber,
  AssignedDocuments.DocumentItemNumber AS DocumentItemNumber,
  AssignedDocuments.PrepaymentAgrmtRefDocument AS TradingContractNumber,
  AssignedDocuments.PrepaymentAgrmtRefDocItem AS TradingContractItem,
  AssignedDocuments.PrepaymentAssignedDocumentUUID AS PrepaymentAssignedDocumentUUID,
  PrepaymentAgreement.Counterparty AS Counterparty,
  PrepaymentAgreement.CompanyCode AS CompanyCode,
  PrepaymentAgreement.PrepaymentAgreementStatus AS PrepaymentAgreementStatus,
  PrepaymentAgreement.PrepaymentAgrmtLinkStatus AS PrepaymentAgrmtLinkStatus,
  PrepaymentAgreement.PrepaymentAgrmtPostingStatus AS PrepaymentAgrmtPostingStatus,
  PrepaymentAgreement.PrepaymentBarterLinkStatus AS PrepaymentBarterLinkStatus,
  PrepaymentAgreement.PrepaymentAgreementType AS PrepaymentAgreementType,
  PrepaymentAgreement.PrepaymentAgreementCategory AS PrepaymentAgreementCategory,
  PrepaymentAgreement.PrepaymentPayoutPercent AS PrepaymentPayoutPercent,
  PrepaymentAgreement.PrepaymentStopIntrstDateType AS PrepaymentStopIntrstDateType,
  PrepaymentAgreement.PrepaymentStartIntrstDateType AS PrepaymentStartIntrstDateType,
  PrepaymentAgreement.PrepaymentAgreementAmount AS PrepaymentAgreementAmount,
  AssignedDocuments.PrepaymentAgrmtLinkAmount AS PrepaymentAgrmtLinkAmount,
  PrepaymentAgreement.PrepaymentAgreementCurrency AS PrepaymentAgreementCurrency,
  PrepaymentAgreement.PrepaymentAgreementCommodity AS PrepaymentAgreementCommodity,
  PrepaymentAgrmtApproval.PrepaymentAgrmtIsPosted AS PrepaymentAgrmtIsPosted,
  PrepaymentAgrmtApproval.FinalSettlementIndicator AS FinalSettlementIndicator,
  AssignedDocuments.PrepaymentAgrmtRefDocYear AS PrepaymentAgrmtRefDocYear,
  AssignedDocuments.PrepaymentAgrmtRefDocumentType AS PrepaymentAgrmtRefDocumentType
FROM P_PrepaymentAssignedDocument AS AssignedDocuments
LEFT OUTER JOIN I_ACMTrdgContrHdr AS _ContractHeader ON TradingContractNumber = _ContractHeader.TradingContractNumber  -- association [1..1]
;

Learn More