R_CollsPromiseToPayDraftTP

DDL: R_COLLSPROMISETOPAYDRAFTTP Type: view TRANSACTIONAL

Promise to Pay with Draft

R_CollsPromiseToPayDraftTP is a Transactional CDS View that provides data about "Promise to Pay with Draft" in SAP S/4HANA. It reads from 1 data source (P_CollsPromiseToPayDraft) and exposes 48 fields with key field PromiseToPayUUID.

1 data source(s) 48 fields

Data Sources (1)

SourceAliasJoin Type
P_CollsPromiseToPayDraft P_CollsPromiseToPayDraft from

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName RCOLLSP2PDRTP view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Promise to Pay with Draft view
ObjectModel.representativeKey PromiseToPayUUID view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.allowExtensions true view

Fields (48)

KeyFieldSource TableSource FieldDescription
KEY PromiseToPayUUID PromiseToPayUUID
DraftUUID DraftUUID
CompanyCode CompanyCode
Customer Customer
ObjectType ObjectType
LinkedInvoiceKey LinkedInvoiceKey
PromisedAmount PromisedAmount
PaidAmount PaidAmount
Currency Currency
DueDate DueDate
PromiseToPayDate PromiseToPayDate
LastPaymentDate LastPaymentDate
PromiseToPayStatus PromiseToPayStatus
PromiseToPayLevel PromiseToPayLevel
PromiseToPayGivenByPersonName PromiseToPayGivenByPersonName
ContactPersonEmailAddress ContactPersonEmailAddress
ContactPersonPhoneNumber ContactPersonPhoneNumber
ContactPersonFaxNumber ContactPersonFaxNumber
ContactPersonFaxCountry ContactPersonFaxCountry
ContactPerson ContactPerson
NumberOfInstallments NumberOfInstallments
PaidOnScheduleAmount PaidOnScheduleAmount
PaidOffScheduleAmount PaidOffScheduleAmount
NextInstallmentDueDate NextInstallmentDueDate
NextInstallmentAmount NextInstallmentAmount
CaseID CaseID
CaseExternalReference CaseExternalReference
Prms2PToInvoiceGroupRefUUID Prms2PToInvoiceGroupRefUUID
CaseCreatedBy CaseCreatedBy
CaseCreatedOn CaseCreatedOn
CaseLastChangedBy CaseLastChangedBy
CaseLastChangedOn CaseLastChangedOn
CaseClosedBy CaseClosedBy
CaseClosedTime CaseClosedTime
IsActiveEntity IsActiveEntity
HasActiveEntity HasActiveEntity
DraftCreationDateTime DraftCreationDateTime
DraftLastChangedDateTime DraftLastChangedDateTime
CaseType CaseType
_CaseAttribute _CaseAttribute
_ChangedByContactCard _ChangedByContactCard
_ClosedByContactCard _ClosedByContactCard
_CollsPromiseToPayStatus _CollsPromiseToPayStatus
_CompanyCode _CompanyCode
_Country _Country
_CreatedByContactCard _CreatedByContactCard
_Currency _Currency
_Customer _Customer 
@AbapCatalog: { sqlViewName: 'RCOLLSP2PDRTP',
                preserveKey: true,
                compiler: { compareFilter: true } }
@EndUserText: { label: 'Promise to Pay with Draft' }
@ObjectModel: { representativeKey: 'PromiseToPayUUID',
                semanticKey:       [ 'CaseID' ],
                usageType:         { dataClass:      #TRANSACTIONAL,
                                     sizeCategory:   #L,
                                     serviceQuality: #C } }
@AccessControl: { authorizationCheck: #CHECK,
                  privilegedAssociations: ['_CreatedByContactCard',
                                           '_ChangedByContactCard',
                                           '_ClosedByContactCard' ],
                  personalData: { blocking: #BLOCKED_DATA_EXCLUDED } }
@VDM: { viewType:  #TRANSACTIONAL,
        lifecycle: { contract: { type: #SAP_INTERNAL_API } } }
@ClientHandling: { algorithm: #SESSION_VARIABLE }
@Metadata: { allowExtensions: true }

define root view R_CollsPromiseToPayDraftTP
  as select from P_CollsPromiseToPayDraft
{

      // VDM Fields

  key PromiseToPayUUID,
      DraftUUID,
      CompanyCode,
      Customer,
      ObjectType,
      LinkedInvoiceKey,

      @Semantics: { amount: { currencyCode: 'Currency' } }
      PromisedAmount,

      @Semantics: { amount: { currencyCode: 'Currency' } }
      PaidAmount,

      @Semantics: { currencyCode: true }
      Currency,

      DueDate,
      PromiseToPayDate,
      LastPaymentDate,
      PromiseToPayStatus,
      PromiseToPayLevel,
      PromiseToPayGivenByPersonName,

      @Semantics: { eMail: { address: true } }
      ContactPersonEmailAddress,

      @Semantics: { telephone: { type: [ #PREF ] } }
      ContactPersonPhoneNumber,

      @Semantics: { telephone: { type: [ #FAX ] } }
      ContactPersonFaxNumber,

      ContactPersonFaxCountry,
      ContactPerson,
      NumberOfInstallments,

      @Semantics: { amount: { currencyCode: 'Currency' } }
      PaidOnScheduleAmount,

      @Semantics: { amount: { currencyCode: 'Currency' } }
      PaidOffScheduleAmount,

      NextInstallmentDueDate,

      @Semantics: { amount: { currencyCode: 'Currency' } }
      NextInstallmentAmount,

      CaseID,
      CaseExternalReference,
      Prms2PToInvoiceGroupRefUUID,
      CaseCreatedBy,
      CaseCreatedOn,
      CaseLastChangedBy,
      CaseLastChangedOn,
      CaseClosedBy,
      CaseClosedTime,
      IsActiveEntity,
      HasActiveEntity,
      DraftCreationDateTime,
      DraftLastChangedDateTime,
      CaseType,

      // Exposed Associations

      _CaseAttribute,
      _ChangedByContactCard,
      _ClosedByContactCard,
      _CollsPromiseToPayStatus,
      _CompanyCode,
      _Country,
      _CreatedByContactCard,
      _Currency,
      _Customer

}

Learn More