C_CollsInvoiceRelatedPrms2P

DDL: C_COLLSINVOICERELATEDPRMS2P Type: view_entity CONSUMPTION

Promise To Pay Related to Invoice

C_CollsInvoiceRelatedPrms2P is a Consumption CDS View that provides data about "Promise To Pay Related to Invoice" in SAP S/4HANA. It reads from 1 data source (I_CollsInvoiceRelatedPrms2P) and exposes 51 fields with key fields LogicalSystem, ObjectType, ObjectKey, RelationToLinkedObject, CaseUniqueID.

Data Sources (1)

SourceAliasJoin Type
I_CollsInvoiceRelatedPrms2P I_CollsInvoiceRelatedPrms2P projection

Annotations (8)

NameValueLevelField
Metadata.allowExtensions true view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.representativeKey CaseUniqueID view
EndUserText.label Promise To Pay Related to Invoice view

Fields (51)

KeyFieldSource TableSource FieldDescription
KEY LogicalSystem LogicalSystem
KEY ObjectType ObjectType
KEY ObjectKey ObjectKey
KEY RelationToLinkedObject RelationToLinkedObject
KEY CaseUniqueID CaseUniqueID
ObjectClassification ObjectClassification
ObjectIsConfirmed ObjectIsConfirmed
ObjectIsVoided ObjectIsVoided
CompanyCode CompanyCode
AccountingDocument AccountingDocument
FiscalYear FiscalYear
AccountingDocumentItem AccountingDocumentItem
Customer _CollsPromiseToPay Customer
PromisedAmount _CollsPromiseToPay PromisedAmount
PaidAmount _CollsPromiseToPay PaidAmount
PromiseToPayUUID _CollsPromiseToPay PromiseToPayUUID
Currency _CollsPromiseToPay Currency
DueDate _CollsPromiseToPay DueDate
PromiseToPayDate _CollsPromiseToPay PromiseToPayDate
LastPaymentDate _CollsPromiseToPay LastPaymentDate
PromiseToPayStatus _CollsPromiseToPay PromiseToPayStatus
PromiseToPayLevel _CollsPromiseToPay PromiseToPayLevel
PromiseToPayGivenByPersonName _CollsPromiseToPay PromiseToPayGivenByPersonName
ContactPersonEmailAddress _CollsPromiseToPay ContactPersonEmailAddress
ContactPersonPhoneNumber _CollsPromiseToPay ContactPersonPhoneNumber
ContactPersonFaxNumber _CollsPromiseToPay ContactPersonFaxNumber
ContactPersonFaxCountry _CollsPromiseToPay ContactPersonFaxCountry
ContactPerson _CollsPromiseToPay ContactPerson
NumberOfInstallments _CollsPromiseToPay NumberOfInstallments
PaidOnScheduleAmount _CollsPromiseToPay PaidOnScheduleAmount
PaidOffScheduleAmount _CollsPromiseToPay PaidOffScheduleAmount
NextInstallmentDueDate _CollsPromiseToPay NextInstallmentDueDate
NextInstallmentAmount _CollsPromiseToPay NextInstallmentAmount
CaseID _CollsPromiseToPay CaseID
CaseExternalReference _CollsPromiseToPay CaseExternalReference
Prms2PToInvoiceGroupRefUUID _CollsPromiseToPay Prms2PToInvoiceGroupRefUUID
CaseCreatedBy CaseCreatedBy
CaseCreatedOn _CollsPromiseToPay CaseCreatedOn
CaseLastChangedBy CaseLastChangedBy
CaseLastChangedOn _CollsPromiseToPay CaseLastChangedOn
CaseClosedBy CaseClosedBy
CaseClosedTime _CollsPromiseToPay CaseClosedTime
CompanyCodeName
CustomerName
CountryNameasCountryNamelocalized
CurrencyNameasCurrencyNamelocalized
CreatedByUserName
LastChangedByUserName
ClosedByUserFullName
_CaseAttribute _CaseAttribute
_CollsPromiseToPay _CollsPromiseToPay
@Metadata: { allowExtensions: true }
@VDM: { usage: { type:     [ #TRANSACTIONAL_PROCESSING_SERVICE ] },
                 viewType: #CONSUMPTION }
@AccessControl: { authorizationCheck: #CHECK }
@ObjectModel: { usageType: { serviceQuality: #X,
                             sizeCategory:   #L,
                             dataClass:      #TRANSACTIONAL },
                representativeKey: 'CaseUniqueID',
                semanticKey: [ 'CaseUniqueID',
                               'CaseID' ] }
@EndUserText: { label: 'Promise To Pay Related to Invoice' }

define root view entity C_CollsInvoiceRelatedPrms2P
  as projection on I_CollsInvoiceRelatedPrms2P
{
      //I_CollsInvoiceRelatedObject

  key LogicalSystem,
  key ObjectType,
  key ObjectKey,
  key RelationToLinkedObject,
  key CaseUniqueID,
      ObjectClassification,
      ObjectIsConfirmed,
      ObjectIsVoided,

      @ObjectModel: { text: { element: [ 'CompanyCodeName' ] } }
      CompanyCode,

      AccountingDocument,
      FiscalYear,
      AccountingDocumentItem,

      // Promise to Pay data

      @ObjectModel: { text: { element: [ 'CustomerName' ] } }
      _CollsPromiseToPay.Customer,

      _CollsPromiseToPay.PromisedAmount,
      _CollsPromiseToPay.PaidAmount,
      _CollsPromiseToPay.PromiseToPayUUID,

      @ObjectModel: { text: { element: [ 'CurrencyName' ] } }
      _CollsPromiseToPay.Currency,

      _CollsPromiseToPay.DueDate,
      _CollsPromiseToPay.PromiseToPayDate,
      _CollsPromiseToPay.LastPaymentDate,

      @ObjectModel: { text: { element: [ 'PromiseToPayStatusName' ] } }
      _CollsPromiseToPay.PromiseToPayStatus,

      _CollsPromiseToPay.PromiseToPayLevel,
      _CollsPromiseToPay.PromiseToPayGivenByPersonName,
      _CollsPromiseToPay.ContactPersonEmailAddress,
      _CollsPromiseToPay.ContactPersonPhoneNumber,
      _CollsPromiseToPay.ContactPersonFaxNumber,
      _CollsPromiseToPay.ContactPersonFaxCountry,
      _CollsPromiseToPay.ContactPerson,
      _CollsPromiseToPay.NumberOfInstallments,
      _CollsPromiseToPay.PaidOnScheduleAmount,
      _CollsPromiseToPay.PaidOffScheduleAmount,
      _CollsPromiseToPay.NextInstallmentDueDate,
      _CollsPromiseToPay.NextInstallmentAmount,
      _CollsPromiseToPay.CaseID,
      _CollsPromiseToPay.CaseExternalReference,
      _CollsPromiseToPay.Prms2PToInvoiceGroupRefUUID,

      @ObjectModel: { text: { element: [ 'CreatedByUserName' ] } }
      @Consumption: { semanticObject: 'BusinessUser' }
      CaseCreatedBy,

      _CollsPromiseToPay.CaseCreatedOn,

      @ObjectModel: { text: { element: [ 'LastChangedByUserName' ] } }
      @Consumption: { semanticObject: 'BusinessUser' }
      CaseLastChangedBy,

      _CollsPromiseToPay.CaseLastChangedOn,

      @ObjectModel: { text: { element: [ 'ClosedByUserFullName' ] } }
      @Consumption: { semanticObject: 'BusinessUser' }
      CaseClosedBy,

      _CollsPromiseToPay.CaseClosedTime,

      // Text Elements

      _CollsPromiseToPay._CompanyCode.CompanyCodeName                          as CompanyCodeName,
      _CollsPromiseToPay._Customer.CustomerName                                as CustomerName,
      _CollsPromiseToPay._CollsPromiseToPayStatus._Text.PromiseToPayStatusName as PromiseToPayStatusName : localized,
      _CollsPromiseToPay._Country._Text.CountryName                            as CountryName            : localized,
      _CollsPromiseToPay._Currency._Text.CurrencyName                          as CurrencyName           : localized,
      _CollsPromiseToPay._CreatedByContactCard.UserDescription                 as CreatedByUserName,
      _CollsPromiseToPay._ChangedByContactCard.UserDescription                 as LastChangedByUserName,
      _CollsPromiseToPay._ClosedByContactCard.UserDescription                  as ClosedByUserFullName,

      // Exposed Associations

      _CaseAttribute,
      _CollsPromiseToPay,
      _CreatedByContactCard : redirected to C_RblsMgmtUserContactCard,
      _ChangedByContactCard : redirected to C_RblsMgmtUserContactCard,
      _ClosedByContactCard  : redirected to C_RblsMgmtUserContactCard

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_COLLSINVOICERELATEDPRMS2P",
"I_COLLSPROMISETOPAY",
"I_COLLSPROMISETOPAYSTATUS",
"I_COLLSPROMISETOPAYSTATUSTEXT",
"I_COMPANYCODE",
"I_COUNTRY",
"I_COUNTRYTEXT",
"I_CURRENCY",
"I_CURRENCYTEXT",
"I_CUSTOMER",
"I_USERCONTACTCARD"
],
"ASSOCIATED":
[
"C_RBLSMGMTUSERCONTACTCARD",
"I_CASEATTRIBUTE",
"I_COLLSPROMISETOPAY",
"R_RBLSMGMTUSERCONTACTCARD"
],
"BASE":
[
"I_COLLSINVOICERELATEDPRMS2P"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/