What is R_CollsHeadOfficePromiseToPay in SAP S/4HANA?

R_CollsHeadOfficePromiseToPay is a composite CDS view in SAP S/4HANA. Head Ofice Promise to Pay It contains 52 fields.

Which tables does R_CollsHeadOfficePromiseToPay read from?

R_CollsHeadOfficePromiseToPay reads data from: I_CollsSgmtCompanyCodeAssgmt, P_CollsPromiseToPayDraft.

What VDM layer is R_CollsHeadOfficePromiseToPay?

R_CollsHeadOfficePromiseToPay is classified as a Composite view that combines data from multiple basic views.

R_CollsHeadOfficePromiseToPay

DDL: R_COLLSHEADOFFICEPROMISETOPAY Type: view COMPOSITE

52 Fields 2 Data Sources

Head Ofice Promise to Pay

R_CollsHeadOfficePromiseToPay is a Composite CDS View that provides data about "Head Ofice Promise to Pay" in SAP S/4HANA. It reads from 2 data sources (I_CollsSgmtCompanyCodeAssgmt, P_CollsPromiseToPayDraft) and exposes 52 fields with key fields CollectionSegment, PromiseToPayUUID, Customer.

Data Sources (2)

Source	Alias	Join Type
I_CollsSgmtCompanyCodeAssgmt	I_CollsSgmtCompanyCodeAssgmt	from
P_CollsPromiseToPayDraft	P_CollsPromiseToPayDraft	inner

Annotations (13)

Name	Value	Level
AbapCatalog.sqlViewName	RCLLHOBP2P	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#PRIVILEGED_ONLY	view
AccessControl.personalData.blocking	#BLOCKED_DATA_EXCLUDED	view
EndUserText.label	Head Ofice Promise to Pay	view
VDM.viewType	#COMPOSITE	view
VDM.lifecycle.contract.type	#SAP_INTERNAL_API	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.usageType.serviceQuality	#X	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.representativeKey	PromiseToPayUUID	view

Fields (52)

Key	Field	Source Table	Source Field	Description
KEY	CollectionSegment	I_CollsSgmtCompanyCodeAssgmt	CollectionSegment	Segment
KEY	PromiseToPayUUID	P_CollsPromiseToPayDraft	PromiseToPayUUID	Internal Key
KEY	Customer	P_CollsPromiseToPayDraft	Customer	Sold-to Party
	DraftUUID	P_CollsPromiseToPayDraft	DraftUUID	UUID
	CompanyCode	P_CollsPromiseToPayDraft	CompanyCode	Receiver Company Code
	ObjectType	P_CollsPromiseToPayDraft	ObjectType	Type
	LinkedInvoiceKey	P_CollsPromiseToPayDraft	LinkedInvoiceKey	Key
	PromisedAmount	P_CollsPromiseToPayDraft	PromisedAmount	Promised Amount
	PaidAmount	P_CollsPromiseToPayDraft	PaidAmount	Paid Amount
	Currency	P_CollsPromiseToPayDraft	Currency	Valuation Crcy
	DueDate	P_CollsPromiseToPayDraft	DueDate	Promised For
	PromiseToPayDate	P_CollsPromiseToPayDraft	PromiseToPayDate	Promised On
	LastPaymentDate	P_CollsPromiseToPayDraft	LastPaymentDate	Last Payment
	PromiseToPayStatus	P_CollsPromiseToPayDraft	PromiseToPayStatus	State
	PromiseToPayLevel	P_CollsPromiseToPayDraft	PromiseToPayLevel	Level
	PromiseToPayGivenByPersonName	P_CollsPromiseToPayDraft	PromiseToPayGivenByPersonName	Promised By
	ContactPersonEmailAddress	P_CollsPromiseToPayDraft	ContactPersonEmailAddress	Email
	ContactPersonPhoneNumber	P_CollsPromiseToPayDraft	ContactPersonPhoneNumber	Telephone No.
	ContactPersonFaxNumber	P_CollsPromiseToPayDraft	ContactPersonFaxNumber	Fax Number
	ContactPersonFaxCountry	P_CollsPromiseToPayDraft	ContactPersonFaxCountry	C/R of Fax No.
	ContactPerson
	NumberOfInstallments	P_CollsPromiseToPayDraft	NumberOfInstallments	Installments
	PaidOnScheduleAmount	P_CollsPromiseToPayDraft	PaidOnScheduleAmount	Installment Amounts Paid on Schedule
	PaidOffScheduleAmount	P_CollsPromiseToPayDraft	PaidOffScheduleAmount	Not on Schedule
	NextInstallmentDueDate	P_CollsPromiseToPayDraft	NextInstallmentDueDate	Due Date of Next Open Installment
	NextInstallmentAmount	P_CollsPromiseToPayDraft	NextInstallmentAmount	Open Amount
	Prms2PToInvoiceGroupRefUUID	P_CollsPromiseToPayDraft	Prms2PToInvoiceGroupRefUUID	UUID
	CaseID	P_CollsPromiseToPayDraft	CaseID	Case ID
	CaseExternalReference	P_CollsPromiseToPayDraft	CaseExternalReference	External Reference
	CaseCreatedBy	P_CollsPromiseToPayDraft	CaseCreatedBy	Created By
	CaseCreatedOn	P_CollsPromiseToPayDraft	CaseCreatedOn	Created At
	CaseLastChangedBy	P_CollsPromiseToPayDraft	CaseLastChangedBy	Changed By
	CaseLastChangedOn	P_CollsPromiseToPayDraft	CaseLastChangedOn	Last Changed At
	CaseClosedBy	P_CollsPromiseToPayDraft	CaseClosedBy	Closed By
	CaseClosedTime	P_CollsPromiseToPayDraft	CaseClosedTime	Closed At
	IsActiveEntity	P_CollsPromiseToPayDraft	IsActiveEntity	Is active
	HasActiveEntity	P_CollsPromiseToPayDraft	HasActiveEntity	TRUE
	DraftCreationDateTime	P_CollsPromiseToPayDraft	DraftCreationDateTime	Time Stamp
	DraftLastChangedDateTime	P_CollsPromiseToPayDraft	DraftLastChangedDateTime	Time Stamp
	DraftAdministrativeDataUUID	P_CollsPromiseToPayDraft	DraftAdministrativeDataUUID	UUID
	CaseType	P_CollsPromiseToPayDraft	CaseType	Upper/Lowercase
	_CollectionSegment	I_CollsSgmtCompanyCodeAssgmt	_CollectionSegment
	_CaseAttribute	P_CollsPromiseToPayDraft	_CaseAttribute
	_ChangedByContactCard	P_CollsPromiseToPayDraft	_ChangedByContactCard
	_ClosedByContactCard	P_CollsPromiseToPayDraft	_ClosedByContactCard
	_CollsPromiseToPayStatus	P_CollsPromiseToPayDraft	_CollsPromiseToPayStatus
	_CompanyCode	P_CollsPromiseToPayDraft	_CompanyCode
	_Country	P_CollsPromiseToPayDraft	_Country
	_CreatedByContactCard	P_CollsPromiseToPayDraft	_CreatedByContactCard
	_Currency	P_CollsPromiseToPayDraft	_Currency
	_Customer	P_CollsPromiseToPayDraft	_Customer
	_DraftAdministrativeData	P_CollsPromiseToPayDraft	_DraftAdministrativeData

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_CollsHeadOfficePromiseToPay.
-- 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_CollsHeadOfficePromiseToPay AS
SELECT
  I_CollsSgmtCompanyCodeAssgmt.CollectionSegment AS CollectionSegment,
  P_CollsPromiseToPayDraft.PromiseToPayUUID AS PromiseToPayUUID,
  P_CollsPromiseToPayDraft.Customer AS Customer,
  P_CollsPromiseToPayDraft.DraftUUID AS DraftUUID,
  P_CollsPromiseToPayDraft.CompanyCode AS CompanyCode,
  P_CollsPromiseToPayDraft.ObjectType AS ObjectType,
  P_CollsPromiseToPayDraft.LinkedInvoiceKey AS LinkedInvoiceKey,
  P_CollsPromiseToPayDraft.PromisedAmount AS PromisedAmount,
  P_CollsPromiseToPayDraft.PaidAmount AS PaidAmount,
  P_CollsPromiseToPayDraft.Currency AS Currency,
  P_CollsPromiseToPayDraft.DueDate AS DueDate,
  P_CollsPromiseToPayDraft.PromiseToPayDate AS PromiseToPayDate,
  P_CollsPromiseToPayDraft.LastPaymentDate AS LastPaymentDate,
  P_CollsPromiseToPayDraft.PromiseToPayStatus AS PromiseToPayStatus,
  P_CollsPromiseToPayDraft.PromiseToPayLevel AS PromiseToPayLevel,
  P_CollsPromiseToPayDraft.PromiseToPayGivenByPersonName AS PromiseToPayGivenByPersonName,
  P_CollsPromiseToPayDraft.ContactPersonEmailAddress AS ContactPersonEmailAddress,
  P_CollsPromiseToPayDraft.ContactPersonPhoneNumber AS ContactPersonPhoneNumber,
  P_CollsPromiseToPayDraft.ContactPersonFaxNumber AS ContactPersonFaxNumber,
  P_CollsPromiseToPayDraft.ContactPersonFaxCountry AS ContactPersonFaxCountry,
  cast( P_CollsPromiseToPayDraft.ContactPerson as parnr ) AS ContactPerson,
  P_CollsPromiseToPayDraft.NumberOfInstallments AS NumberOfInstallments,
  P_CollsPromiseToPayDraft.PaidOnScheduleAmount AS PaidOnScheduleAmount,
  P_CollsPromiseToPayDraft.PaidOffScheduleAmount AS PaidOffScheduleAmount,
  P_CollsPromiseToPayDraft.NextInstallmentDueDate AS NextInstallmentDueDate,
  P_CollsPromiseToPayDraft.NextInstallmentAmount AS NextInstallmentAmount,
  P_CollsPromiseToPayDraft.Prms2PToInvoiceGroupRefUUID AS Prms2PToInvoiceGroupRefUUID,
  P_CollsPromiseToPayDraft.CaseID AS CaseID,
  P_CollsPromiseToPayDraft.CaseExternalReference AS CaseExternalReference,
  P_CollsPromiseToPayDraft.CaseCreatedBy AS CaseCreatedBy,
  P_CollsPromiseToPayDraft.CaseCreatedOn AS CaseCreatedOn,
  P_CollsPromiseToPayDraft.CaseLastChangedBy AS CaseLastChangedBy,
  P_CollsPromiseToPayDraft.CaseLastChangedOn AS CaseLastChangedOn,
  P_CollsPromiseToPayDraft.CaseClosedBy AS CaseClosedBy,
  P_CollsPromiseToPayDraft.CaseClosedTime AS CaseClosedTime,
  P_CollsPromiseToPayDraft.IsActiveEntity AS IsActiveEntity,
  P_CollsPromiseToPayDraft.HasActiveEntity AS HasActiveEntity,
  P_CollsPromiseToPayDraft.DraftCreationDateTime AS DraftCreationDateTime,
  P_CollsPromiseToPayDraft.DraftLastChangedDateTime AS DraftLastChangedDateTime,
  P_CollsPromiseToPayDraft.DraftAdministrativeDataUUID AS DraftAdministrativeDataUUID,
  P_CollsPromiseToPayDraft.CaseType AS CaseType,
  I_CollsSgmtCompanyCodeAssgmt._CollectionSegment AS _CollectionSegment,
  P_CollsPromiseToPayDraft._CaseAttribute AS _CaseAttribute,
  P_CollsPromiseToPayDraft._ChangedByContactCard AS _ChangedByContactCard,
  P_CollsPromiseToPayDraft._ClosedByContactCard AS _ClosedByContactCard,
  P_CollsPromiseToPayDraft._CollsPromiseToPayStatus AS _CollsPromiseToPayStatus,
  P_CollsPromiseToPayDraft._CompanyCode AS _CompanyCode,
  P_CollsPromiseToPayDraft._Country AS _Country,
  P_CollsPromiseToPayDraft._CreatedByContactCard AS _CreatedByContactCard,
  P_CollsPromiseToPayDraft._Currency AS _Currency,
  P_CollsPromiseToPayDraft._Customer AS _Customer,
  P_CollsPromiseToPayDraft._DraftAdministrativeData AS _DraftAdministrativeData
FROM I_CollsSgmtCompanyCodeAssgmt
INNER JOIN P_CollsPromiseToPayDraft ON /* join condition not captured in parsed metadata */
;

Depth:

R_CollsHeadOfficePromiseToPay view

I_CollsSgmtCompanyCodeAssgmt view
P_CollsPromiseToPayDraft view

C_CollsHeadOfficePromiseToPay view_entity