C_CollsPrmsToPayCollsSegment

DDL: C_COLLSPRMSTOPAYCOLLSSEGMENT Type: view_entity CONSUMPTION Package: ODATA_PROMISE_TO_PAY
59 Fields 1 Data Sources 1 OData Services

Promise To Pay in Collections Segment

C_CollsPrmsToPayCollsSegment is a Consumption CDS View that provides data about "Promise To Pay in Collections Segment" in SAP S/4HANA. It reads from 1 data source (R_CollsPrmsToPayCollsSegmentTP) and exposes 59 fields with key fields CollectionSegment, PromiseToPayUUID, BranchAccount. It is exposed through 1 OData service (UI_PROCESSRECEIVABLES_MANAGE). Part of development package ODATA_PROMISE_TO_PAY.

Data Sources (1)

SourceAliasJoin Type
R_CollsPrmsToPayCollsSegmentTP R_CollsPrmsToPayCollsSegmentTP projection

Annotations (9)

NameValueLevelField
EndUserText.label Promise To Pay in Collections Segment 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

OData Services (1)

ServiceBindingVersionContractRelease
UI_PROCESSRECEIVABLES_MANAGE UI_PROCESSRECEIVABLES_MAN V2 C1 NOT_TO_BE_RELEASED_STABLE

Fields (59)

KeyFieldSource TableSource FieldDescription
KEY CollectionSegment CollectionSegment Segment
KEY PromiseToPayUUID PromiseToPayUUID Internal Key
KEY BranchAccount BranchAccount Branch Account No.
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
IsCleared IsCleared Integer
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
virtualAccountingDocumentbelnr_d
virtualFiscalYeargjahr
virtualAccountingDocumentItembuzei
_CaseAttribute _CaseAttribute
_CollsPromiseToPayStatus _CollsPromiseToPayStatus
_CompanyCode _CompanyCode
_Country _Country
_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_CollsPrmsToPayCollsSegment.
-- 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_CollsPrmsToPayCollsSegment AS
SELECT
  CollectionSegment,
  PromiseToPayUUID,
  BranchAccount,
  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,
  IsCleared,
  _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,
  virtual AccountingDocument : belnr_d AS virtualAccountingDocumentbelnr_d,
  virtual FiscalYear : gjahr AS virtualFiscalYeargjahr,
  virtual AccountingDocumentItem : buzei AS virtualAccountingDocumentItembuzei
FROM R_CollsPrmsToPayCollsSegmentTP
;

Learn More