I_CollectionGroup

DDL: I_COLLECTIONGROUP SQL: ICOLLGRP Type: view BASIC
4 Fields 1 Data Sources 2 Associations

Collection Group

I_CollectionGroup (Basic)

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

CollectionsGroup · Financial Operations

I_CollectionGroup is a Basic CDS View (Dimension) that provides data about "Collection Group" in SAP S/4HANA. It reads from 1 data source (udm_coll_grp) and exposes 4 fields with key field CollectionGroup. It has 2 associations to related views.

SAP Help Documentation

CategoryCDS Views for Collection Management
Data CategoryDimension
Purpose
This CDS view is designed to provide a structured representation of collection groups within a system, including their associated strategies and textual descriptions. It serves as a dimension in analytical scenarios, enabling data extraction and analysis related to collection groups. This CDS view provides the data to answer the following business questions: What are the different collection groups defined in the system? What strategies are associated with each collection group? How can the textual descriptions of collection groups be accessed for reporting or analytical purposes? How do collection groups relate to other entities within the collections management framework? 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 don't need any special authorization.

Structure
Further Important Fields Important fields in this view include the following: Field Name Description CollectionGroup Collection Group CollectionStrategy Collection Strategy

Data Extraction
Data Extraction Type This CDS view is enabled for data extraction in full mode.

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessFinancial Operations
Application ComponentFIN-FSCM-COL
CapabilitiesData Source in SQL Select, Data Source for Defining CDS Entities, Association Target for Defining CDS Entities, Analytical Dimension, Data Source for Data Extraction
PackageFinancial Operations for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view is designed to provide a structured representation of collection groups within a system, including their associated strategies and textual descriptions. It serves as a dimension in analytical scenarios, enabling data extraction and analysis related to collection groups. </p> <p>This CDS view provides the data to answer the following business questions:</p> <ul> <li><p>What are the different collection groups defined in the system?</p></li> <li><p>What strategies are associated with each collection group?</p></li> <li><p>How can the textual descriptions of collection groups be accessed for reporting or analytical purposes?</p></li> <li><p>How do collection groups relate to other entities within the collections management framework?</p></li> </ul> <p>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.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
udm_coll_grp udm_coll_grp from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_CollectionGroupText _Text $projection.CollectionGroup = _Text.CollectionGroup
[0..1] I_CollectionsStrategy _CollectionsStrategy $projection.CollectionStrategy = _CollectionsStrategy.CollectionStrategy

Annotations (13)

NameValueLevelField
EndUserText.label Collection Group view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
VDM.viewType #BASIC view
AbapCatalog.sqlViewName ICOLLGRP view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.representativeKey CollectionGroup view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.sapObjectNodeType.name CollectionsGroup view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY CollectionGroup Collection Group
CollectionStrategy coll_strategy Collection Strategy
_Text _Text
_CollectionsStrategy _CollectionsStrategy

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_CollectionGroup.
-- 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.
-- SQL view name: ICOLLGRP

CREATE VIEW I_CollectionGroup AS
SELECT
  cast(coll_group as udm_coll_group preserving type) AS CollectionGroup,
  coll_strategy AS CollectionStrategy
FROM udm_coll_grp
LEFT OUTER JOIN I_CollectionGroupText AS _Text ON CollectionGroup = _Text.CollectionGroup  -- association [0..*]
LEFT OUTER JOIN I_CollectionsStrategy AS _CollectionsStrategy ON CollectionStrategy = _CollectionsStrategy.CollectionStrategy  -- association [0..1]
;

Learn More