I_CollectionsResubmission

DDL: I_COLLECTIONSRESUBMISSION Type: view BASIC

Resubmissions in Collections Management

I_CollectionsResubmission (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Resubmission in Collections Management · Accounting and Financial Close

I_CollectionsResubmission is a Basic CDS View that provides data about "Resubmissions in Collections Management" in SAP S/4HANA. It reads from 1 data source (udm_rsm_attr) and exposes 22 fields with key field ResubmissionUUID. It has 8 associations to related views.

SAP Help Documentation

CategoryCDS Views for Collections Management
Purpose
This CDS view provides information about resubmissions within the collections management process in SAP Collections Management . It aggregates and exposes key data related to resubmissions, including business partner information, collection segments, reasons and statuses for resubmissions, and metadata about the creation and modification of resubmission records. The view facilitates data extraction and supports transactional operations, making it suitable for integration into business processes and analytics. This CDS view provides the data to answer the following business questions: Which resubmissions are currently active in the collections management process? What are the due dates and timestamps for resubmissions? Which business partners are associated with specific resubmissions? What are the reasons and statuses for each resubmission? Who created or last changed a particular resubmission record, and when did these actions occur? What is the collection segment associated with each resubmission? Are there any restrictions on contacting the business partner until the resubmission date is reached? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations Users who want to use this CDS view must have a role with the following restriction types set to read access: RLTYP ( BP Role ) UDM_SGMNT ( Collection Segment ) B_BUP_DCPD ( Business Partner Processing ) BEGRU_BUPA_GRP ( Authorization Group for Business Partners ) You can use the Display Restriction Types app to find out in which business catalogs these restriction types are included.

Structure
Important Fields Important fields in this view include the following: Field Name Description ResubmissionUUID Resubmission Key BusinessPartner Business Partner Number CollectionSegment Collection Segment ResubmissionDueDate Resubmission Date CollResubmissionDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss)

Data Extraction
Data Extraction Type This CDS view is enabled for data extraction in full mode as well as in delta mode. Deltas are determined automatically by change data capture.

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessAccounting and Financial Close
Application ComponentFIN-FIO-CCD-COL
CapabilitiesData Source for Data Extraction, Data Source in SQL Select
PackageAccounting and Financial Close for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
udm_rsm_attr udm_rsm_attr from

Associations (8)

CardinalityTargetAliasCondition
[0..1] I_BusinessPartner _BusinessPartner $projection.BusinessPartner = _BusinessPartner.BusinessPartner
[0..1] I_CollectionSegment _CollectionSegment $projection.CollectionSegment = _CollectionSegment.CollectionSegment
[0..1] I_ResubmissionReason _ResubmissionReason $projection.ResubmissionReason = _ResubmissionReason.ResubmissionReason
[0..1] I_ResubmissionStatus _ResubmissionStatus $projection.ResubmissionStatus = _ResubmissionStatus.ResubmissionStatus
[0..1] I_User _CreatedBy $projection.CreatedByUser = _CreatedBy.UserID
[0..1] I_UserContactCard _CreatedByContactCard $projection.CreatedByUser = _CreatedByContactCard.ContactCardID
[0..1] I_User _ChangedBy $projection.ChangedBy = _ChangedBy.UserID
[0..1] I_UserContactCard _ChangedByContactCard $projection.ChangedBy = _ChangedByContactCard.ContactCardID

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName ICOLLSRSM view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Resubmissions in Collections Management view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.representativeKey ResubmissionUUID view
ObjectModel.sapObjectNodeType.name CollectionsResubmission view
Metadata.ignorePropagatedAnnotations true view
Analytics.dataExtraction.enabled true view
Analytics.dataExtraction.delta.changeDataCapture.automatic true view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY ResubmissionUUID rsm_guid Resubmission Key
BusinessPartner customer Business Partner Number
CollectionSegment Collection Segment
ResubmissionDueDate rsm_date Resubmission Date
CollResubmissionDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
NoCntctUntilResubmsnDateIsReq No Customer Contact until Resubmission Date
ResubmissionReason rsm_reason Reason for Resubmission
ResubmissionStatus rsm_status Status of Resubmission
CreatedByUser created_by Version Created By
CreationDateTime Uploaded On
ChangedBy changed_by Last Changed By
ChangedOnDateTime Last Changed At
ObjectType objtype Translation OType
ObjectKey objkey Push Object Key
_BusinessPartner _BusinessPartner
_CollectionSegment _CollectionSegment
_ResubmissionReason _ResubmissionReason
_ResubmissionStatus _ResubmissionStatus
_CreatedBy _CreatedBy
_ChangedBy _ChangedBy
_CreatedByContactCard _CreatedByContactCard
_ChangedByContactCard _ChangedByContactCard

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 I_CollectionsResubmission.
-- 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 I_CollectionsResubmission AS
SELECT
  rsm_guid AS ResubmissionUUID,
  customer AS BusinessPartner,
  cast ( coll_segment as farp_collection_segment preserving type ) AS CollectionSegment,
  rsm_date AS ResubmissionDueDate,
  cast ( rsm_time as timestamp preserving type ) AS CollResubmissionDateTime,
  cast ( rsm_xbypass as coll_rsm_dont_contact preserving type ) AS NoCntctUntilResubmsnDateIsReq,
  rsm_reason AS ResubmissionReason,
  rsm_status AS ResubmissionStatus,
  created_by AS CreatedByUser,
  cast( created_at as coll_pr_creation_date_time preserving type ) AS CreationDateTime,
  changed_by AS ChangedBy,
  cast ( changed_at as coll_pr_changed_at preserving type ) AS ChangedOnDateTime,
  objtype AS ObjectType,
  objkey AS ObjectKey
FROM udm_rsm_attr
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_CollectionSegment AS _CollectionSegment ON CollectionSegment = _CollectionSegment.CollectionSegment  -- association [0..1]
LEFT OUTER JOIN I_ResubmissionReason AS _ResubmissionReason ON ResubmissionReason = _ResubmissionReason.ResubmissionReason  -- association [0..1]
LEFT OUTER JOIN I_ResubmissionStatus AS _ResubmissionStatus ON ResubmissionStatus = _ResubmissionStatus.ResubmissionStatus  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedBy ON CreatedByUser = _CreatedBy.UserID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _CreatedByContactCard ON CreatedByUser = _CreatedByContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_User AS _ChangedBy ON ChangedBy = _ChangedBy.UserID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _ChangedByContactCard ON ChangedBy = _ChangedByContactCard.ContactCardID  -- association [0..1]
;