R_ACMContrPrePaytReqTP

DDL: R_ACMCONTRPREPAYTREQTP Type: view_entity TRANSACTIONAL
21 Fields 1 Data Sources 1 Associations

Root for Prepayment Request

R_ACMContrPrePaytReqTP is a Transactional CDS View that provides data about "Root for Prepayment Request" in SAP S/4HANA. It reads from 1 data source (I_PrepaymentPaymentTerms) and exposes 21 fields with key fields TradingContractNumber, TradingContractItem, PrepaymentSerialNumber. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_PrepaymentPaymentTerms I_PrepaymentPaymentTerms from

Associations (1)

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

Annotations (7)

NameValueLevelField
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Root for Prepayment Request view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY TradingContractNumber
KEY TradingContractItem PrepaymentRequestDocItem Item
KEY PrepaymentSerialNumber PrepaymentSerialNumber Serial Number of Proposal Descriptions
CustomerPaymentTerms CustomerPaymentTerms Pyt Terms
PrepaymentRequestIsRequested PrepaymentRequestIsRequested Release Settlement
PrepaymentRequestDate PrepaymentRequestDate Prepayment Date
PrepaymentRequestIsReceived PrepaymentRequestIsReceived Prepayment Recieved
PrepaymentRequestIsMade PrepaymentRequestIsMade Prepayment Made
PrepaymentRequestType PrepaymentRequestType Prepay Agreemnt Type
PrepaymentRequestAmount PrepaymentRequestAmount Pre Agrm Amount
PrepaymentRequestCurrency PrepaymentRequestCurrency Transaction Currency
PrepaymentRequest PrepaymentAgreement Renegotiation PPA
PrepaymentRequestIsDeleted PrepaymentRequestIsDeleted Truth Value
PrepaymentReqPostingStatus PrepaymentReqPostingStatus Workflow Status
ConditionApplication ConditionApplication Application
CreatedByUser CreatedByUser User Name
CreationDateTime CreationDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
_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 R_ACMContrPrePaytReqTP.
-- 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.

CREATE VIEW R_ACMContrPrePaytReqTP AS
SELECT
  cast(right(PrepaymentRequestDocNumber, 10) as tkonn) AS TradingContractNumber,
  PrepaymentRequestDocItem AS TradingContractItem,
  PrepaymentSerialNumber,
  CustomerPaymentTerms,
  PrepaymentRequestIsRequested,
  PrepaymentRequestDate,
  PrepaymentRequestIsReceived,
  PrepaymentRequestIsMade,
  PrepaymentRequestType,
  PrepaymentRequestAmount,
  PrepaymentRequestCurrency,
  PrepaymentAgreement AS PrepaymentRequest,
  PrepaymentRequestIsDeleted,
  PrepaymentReqPostingStatus,
  ConditionApplication,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  LastChangeDateTime
FROM I_PrepaymentPaymentTerms
LEFT OUTER JOIN R_ACMTrdgContrHdrDetTP AS _ContractHeader ON TradingContractNumber = _ContractHeader.TradingContractNumber  -- association [1..1]
;

Learn More