What is C_CollsPromiseToPayTP in SAP S/4HANA?

C_CollsPromiseToPayTP is a consumption CDS view in SAP S/4HANA. Promise To Pay It contains 65 fields.

Which tables does C_CollsPromiseToPayTP read from?

C_CollsPromiseToPayTP reads data from: R_CollsPromiseToPayTP.

What VDM layer is C_CollsPromiseToPayTP?

C_CollsPromiseToPayTP is classified as a Consumption view optimized for specific business scenarios and reporting.

C_CollsPromiseToPayTP

DDL: C_COLLSPROMISETOPAYTP Type: view_entity CONSUMPTION

65 Fields 1 Data Sources

Promise To Pay

C_CollsPromiseToPayTP is a Consumption CDS View that provides data about "Promise To Pay" in SAP S/4HANA. It reads from 1 data source (R_CollsPromiseToPayTP) and exposes 65 fields with key field PromiseToPayUUID.

Data Sources (1)

Source	Alias	Join Type
R_CollsPromiseToPayTP	R_CollsPromiseToPayTP	projection

Annotations (9)

Name	Value	Level
EndUserText.label	Promise To Pay	view
ObjectModel.representativeKey	PromiseToPayUUID	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.serviceQuality	#X	view
AccessControl.authorizationCheck	#CHECK	view
AccessControl.personalData.blocking	#BLOCKED_DATA_EXCLUDED	view
VDM.viewType	#CONSUMPTION	view
Metadata.allowExtensions	true	view

Fields (65)

Key	Field	Source Table	Source Field	Description
KEY	PromiseToPayUUID		PromiseToPayUUID	Internal Key
	CompanyCode		CompanyCode	Receiver Company Code
	Customer		Customer	Sold-to Party
	ObjectType		ObjectType	Type
	LinkedInvoiceKey		LinkedInvoiceKey	Key
	PromisedAmount		PromisedAmount	Promised Amount
	PaidAmount		PaidAmount	Paid Amount
	Currency		Currency	Valuation Crcy
	DueDate		DueDate	Promised For
	PromiseToPayDate		PromiseToPayDate	Promised On
	LastPaymentDate		LastPaymentDate	Last Payment
	PromiseToPayStatus		PromiseToPayStatus	State
	PromiseToPayLevel		PromiseToPayLevel	Level
	PromiseToPayGivenByPersonName		PromiseToPayGivenByPersonName	Promised By
	ContactPersonEmailAddress		ContactPersonEmailAddress	Email
	ContactPersonPhoneNumber		ContactPersonPhoneNumber	Telephone No.
	ContactPersonFaxNumber		ContactPersonFaxNumber	Fax Number
	ContactPersonFaxCountry		ContactPersonFaxCountry	C/R of Fax No.
	ContactPerson		ContactPerson	Contact Person Key
	NumberOfInstallments		NumberOfInstallments	Installments
	PaidOnScheduleAmount		PaidOnScheduleAmount	Installment Amounts Paid on Schedule
	PaidOffScheduleAmount		PaidOffScheduleAmount	Not on Schedule
	NextInstallmentDueDate		NextInstallmentDueDate	Due Date of Next Open Installment
	NextInstallmentAmount		NextInstallmentAmount	Open Amount
	CaseID		CaseID	Case ID
	CaseExternalReference		CaseExternalReference	External Reference
	Prms2PToInvoiceGroupRefUUID		Prms2PToInvoiceGroupRefUUID	UUID
	CaseCreatedBy		CaseCreatedBy	Created By
	CaseCreatedOn		CaseCreatedOn	Created At
	CaseLastChangedBy		CaseLastChangedBy	Changed By
	CaseLastChangedOn		CaseLastChangedOn	Last Changed At
	CaseClosedBy		CaseClosedBy	Closed By
	CaseClosedTime		CaseClosedTime	Closed At
	PromisedAmountForEdit		PromisedAmountForEdit	Promised Amount
	IsCleared		IsCleared	Integer
	CaseSystemStatus	_CaseAttribute	CaseSystemStatus	System Status
	OrganizationBPName1	_Customer	OrganizationBPName1	Name 1
	OrganizationBPName2	_Customer	OrganizationBPName2	Name 2
	UICT_CreatedByFirstName	_CreatedByContactCard	FirstName	First Name
	UICT_CreatedByLastName	_CreatedByContactCard	LastName	Last Name
	UICT_ChangedByFirstName	_ChangedByContactCard	FirstName	First Name
	UICT_ChangedByLastName	_ChangedByContactCard	LastName	Last Name
	UICT_ClosedByFirstName	_ClosedByContactCard	FirstName	First Name
	UICT_ClosedByLastName	_ClosedByContactCard	LastName	Last Name
	CompanyCodeName	_CompanyCode	CompanyCodeName	Company Name
	CustomerName	_Customer	CustomerName	Name of Customer
	CountryNameasCountryNamelocalized
	CurrencyNameasCurrencyNamelocalized
	CreatedByUserName	_CreatedByContactCard	UserDescription	Full Name
	LastChangedByUserName	_ChangedByContactCard	UserDescription	Full Name
	ClosedByUserFullName	_ClosedByContactCard	UserDescription	Full Name
	virtualBusinessPartnerbu_partner
	virtualPromiseToPayDateIsExceededboolean
	virtualPromiseToPayDateCriticalitychar1
	virtualUICT_LastPaymentboolean
	virtualAccountingDocumentfarp_belnr_d
	virtualFiscalYearfis_gjahr
	virtualAccountingDocumentItemfis_buzei
	virtualUICT_PromiseToPayLevelboolean
	_CaseAttribute		_CaseAttribute
	_CollsPromiseToPayStatus		_CollsPromiseToPayStatus
	_CompanyCode		_CompanyCode
	_Country		_Country
	_Customer		_Customer
	_CustomerContact		_CustomerContact

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 C_CollsPromiseToPayTP.
-- 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 C_CollsPromiseToPayTP AS
SELECT
  PromiseToPayUUID,
  CompanyCode,
  Customer,
  ObjectType,
  LinkedInvoiceKey,
  PromisedAmount,
  PaidAmount,
  Currency,
  DueDate,
  PromiseToPayDate,
  LastPaymentDate,
  PromiseToPayStatus,
  PromiseToPayLevel,
  PromiseToPayGivenByPersonName,
  ContactPersonEmailAddress,
  ContactPersonPhoneNumber,
  ContactPersonFaxNumber,
  ContactPersonFaxCountry,
  ContactPerson,
  NumberOfInstallments,
  PaidOnScheduleAmount,
  PaidOffScheduleAmount,
  NextInstallmentDueDate,
  NextInstallmentAmount,
  CaseID,
  CaseExternalReference,
  Prms2PToInvoiceGroupRefUUID,
  CaseCreatedBy,
  CaseCreatedOn,
  CaseLastChangedBy,
  CaseLastChangedOn,
  CaseClosedBy,
  CaseClosedTime,
  PromisedAmountForEdit,
  IsCleared,
  _CaseAttribute.CaseSystemStatus AS CaseSystemStatus,
  _Customer.OrganizationBPName1 AS OrganizationBPName1,
  _Customer.OrganizationBPName2 AS OrganizationBPName2,
  _CreatedByContactCard.FirstName AS UICT_CreatedByFirstName,
  _CreatedByContactCard.LastName AS UICT_CreatedByLastName,
  _ChangedByContactCard.FirstName AS UICT_ChangedByFirstName,
  _ChangedByContactCard.LastName AS UICT_ChangedByLastName,
  _ClosedByContactCard.FirstName AS UICT_ClosedByFirstName,
  _ClosedByContactCard.LastName AS UICT_ClosedByLastName,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  _Customer.CustomerName AS CustomerName,
  _Country._Text.CountryName as CountryName : localized AS CountryNameasCountryNamelocalized,
  _Currency._Text.CurrencyName as CurrencyName : localized AS CurrencyNameasCurrencyNamelocalized,
  _CreatedByContactCard.UserDescription AS CreatedByUserName,
  _ChangedByContactCard.UserDescription AS LastChangedByUserName,
  _ClosedByContactCard.UserDescription AS ClosedByUserFullName,
  virtual BusinessPartner : bu_partner AS virtualBusinessPartnerbu_partner,
  virtual PromiseToPayDateIsExceeded : boolean AS virtualPromiseToPayDateIsExceededboolean,
  virtual PromiseToPayDateCriticality : char1 AS virtualPromiseToPayDateCriticalitychar1,
  virtual UICT_LastPayment : boolean AS virtualUICT_LastPaymentboolean,
  virtual AccountingDocument : farp_belnr_d AS virtualAccountingDocumentfarp_belnr_d,
  virtual FiscalYear : fis_gjahr AS virtualFiscalYearfis_gjahr,
  virtual AccountingDocumentItem : fis_buzei AS virtualAccountingDocumentItemfis_buzei,
  virtual UICT_PromiseToPayLevel : boolean AS virtualUICT_PromiseToPayLevelboolean
FROM R_CollsPromiseToPayTP
;

Depth:

C_CollsPromiseToPayTP view_entity

R_CollsPromiseToPayTP view_entity