C_CollsPromiseToPayDraft

DDL: C_COLLSPROMISETOPAYDRAFT Type: view_entity CONSUMPTION Package: ODATA_PROMISE_TO_PAY
56 Fields 1 Data Sources

Promise To Pay Draft

C_CollsPromiseToPayDraft is a Consumption CDS View that provides data about "Promise To Pay Draft" in SAP S/4HANA. It reads from 1 data source (R_CollsPromiseToPayDraftTP) and exposes 56 fields with key field PromiseToPayUUID. Part of development package ODATA_PROMISE_TO_PAY.

Data Sources (1)

SourceAliasJoin Type
R_CollsPromiseToPayDraftTP R_CollsPromiseToPayDraftTP projection

Annotations (9)

NameValueLevelField
EndUserText.label Promise To Pay 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 #CONSUMPTION view
Metadata.allowExtensions true view

Fields (56)

KeyFieldSource TableSource FieldDescription
KEY PromiseToPayUUID PromiseToPayUUID Internal Key
DraftUUID DraftUUID UUID
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
IsActiveEntity IsActiveEntity Is active
HasActiveEntity HasActiveEntity TRUE
DraftCreationDateTime DraftCreationDateTime Time Stamp
DraftLastChangedDateTime DraftLastChangedDateTime Time Stamp
CaseType CaseType Upper/Lowercase
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
virtualPromiseToPayDateCriticalitychar1
_CaseAttribute _CaseAttribute
_ChangedByContactCard _ChangedByContactCard
_ClosedByContactCard _ClosedByContactCard
_CollsPromiseToPayStatus _CollsPromiseToPayStatus
_CompanyCode _CompanyCode
_Country _Country
_CreatedByContactCard _CreatedByContactCard
_Currency _Currency
_Customer _Customer

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_CollsPromiseToPayDraft.
-- 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_CollsPromiseToPayDraft AS
SELECT
  PromiseToPayUUID,
  DraftUUID,
  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,
  IsActiveEntity,
  HasActiveEntity,
  DraftCreationDateTime,
  DraftLastChangedDateTime,
  CaseType,
  _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 PromiseToPayDateCriticality : char1 AS virtualPromiseToPayDateCriticalitychar1
FROM R_CollsPromiseToPayDraftTP
;

Learn More