C_CollsInvoiceRelatedPrms2P
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)
| Source | Alias | Join Type |
|---|---|---|
| I_CollsInvoiceRelatedPrms2P | I_CollsInvoiceRelatedPrms2P | projection |
Annotations (8)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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":""
}
}*/
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA