R_CollsPrmsToPayCollsSegmentTP

DDL: R_COLLSPRMSTOPAYCOLLSSEGMENTTP Type: view TRANSACTIONAL Package: ODATA_PROMISE_TO_PAY
51 Fields 2 Data Sources 3 Associations

Promise To Pay in Collections Segment

R_CollsPrmsToPayCollsSegmentTP is a Transactional CDS View that provides data about "Promise To Pay in Collections Segment" in SAP S/4HANA. It reads from 2 data sources (I_CollectionsInvoiceMemory, P_CollsPromiseToPayDraft) and exposes 51 fields with key fields CollectionSegment, PromiseToPayUUID, BranchAccount. It has 3 associations to related views. Part of development package ODATA_PROMISE_TO_PAY.

Data Sources (2)

SourceAliasJoin Type
I_CollectionsInvoiceMemory I_CollectionsInvoiceMemory inner
P_CollsPromiseToPayDraft P_CollsPromiseToPayDraft inner

Associations (3)

CardinalityTargetAliasCondition
[0..1] R_RblsMgmtUserContactCard _ChangedByContactCard $projection.CaseLastChangedBy = _ChangedByContactCard.ContactCardID
[0..1] R_RblsMgmtUserContactCard _CreatedByContactCard $projection.CaseCreatedBy = _CreatedByContactCard.ContactCardID
[0..1] R_RblsMgmtUserContactCard _ClosedByContactCard $projection.CaseClosedBy = _ClosedByContactCard.ContactCardID

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName RCOLLSP2PSGMT view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
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 #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (51)

KeyFieldSource TableSource FieldDescription
KEY CollectionSegment Segment
KEY PromiseToPayUUID PromiseToPayUUID Internal Key
KEY BranchAccount I_CollectionsInvoiceMemory BranchAccount Branch Account No.
DraftUUID DraftUUID UUID
CompanyCode I_CollsSgmtCompanyCodeAssgmt CompanyCode Receiver Company Code
Customer I_CollectionsInvoiceMemory Customer Sold-to Party
ObjectType ObjectType Type
LinkedInvoiceKey LinkedInvoiceKey Key
PromisedAmount PromisedAmount Promised Amount
PaidAmount P_CollsPromiseToPayDraft PaidAmount Paid Amount
Currency Currency Valuation Crcy
DueDate P_CollsPromiseToPayDraft 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
_CaseAttribute _CaseAttribute
_ChangedByContactCard _ChangedByContactCard
_ClosedByContactCard _ClosedByContactCard
_CollsPromiseToPayStatus _CollsPromiseToPayStatus
_CompanyCode I_CollsSgmtCompanyCodeAssgmt _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 R_CollsPrmsToPayCollsSegmentTP.
-- 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_CollsPrmsToPayCollsSegmentTP AS
SELECT
  cast( CollectionSegment as farp_collection_segment preserving type ) AS CollectionSegment,
  PromiseToPayUUID,
  I_CollectionsInvoiceMemory.BranchAccount AS BranchAccount,
  DraftUUID,
  I_CollsSgmtCompanyCodeAssgmt.CompanyCode AS CompanyCode,
  I_CollectionsInvoiceMemory.Customer AS Customer,
  ObjectType,
  LinkedInvoiceKey,
  PromisedAmount,
  P_CollsPromiseToPayDraft.PaidAmount AS PaidAmount,
  Currency,
  P_CollsPromiseToPayDraft.DueDate AS 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,
  I_CollsSgmtCompanyCodeAssgmt._CompanyCode AS _CompanyCode
INNER JOIN I_CollectionsInvoiceMemory ON /* join condition not captured in parsed metadata */
INNER JOIN P_CollsPromiseToPayDraft ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN R_RblsMgmtUserContactCard AS _ChangedByContactCard ON CaseLastChangedBy = _ChangedByContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN R_RblsMgmtUserContactCard AS _CreatedByContactCard ON CaseCreatedBy = _CreatedByContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN R_RblsMgmtUserContactCard AS _ClosedByContactCard ON CaseClosedBy = _ClosedByContactCard.ContactCardID  -- association [0..1]
;

Learn More