I_CollectionGroupText

DDL: I_COLLECTIONGROUPTEXT SQL: ICOLLGRPT Type: view BASIC
4 Fields 1 Data Sources 1 Associations

Collection Group - Text

I_CollectionGroupText (Basic)

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

Financial Operations

I_CollectionGroupText is a Basic CDS View that provides data about "Collection Group - Text" in SAP S/4HANA. It reads from 1 data source (udm_coll_grpt) and exposes 4 fields with key fields CollectionGroup, Language. It has 1 association to related views.

SAP API Hub

StateC1
Line of BusinessFinancial Operations
Application ComponentFIN-FSCM-COL
CapabilitiesLanguage-Dependent Text, Data Source in SQL Select, Data Source for Defining CDS Entities, Association Target for Defining CDS Entities
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_grpt udm_coll_grpt from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_Language _Language $projection.Language = _Language.Language

Annotations (12)

NameValueLevelField
EndUserText.label Collection Group - Text view
Analytics.dataExtraction.enabled true view
VDM.viewType #BASIC view
AbapCatalog.sqlViewName ICOLLGRPT view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey CollectionGroup view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #CUSTOMIZING view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY CollectionGroup Collection Group
KEY Language lang Language Key
CollectionGroupName coll_group_text Name of Collection Group
_Language _Language

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_CollectionGroupText.
-- 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: ICOLLGRPT

CREATE VIEW I_CollectionGroupText AS
SELECT
  cast(coll_group as udm_coll_group preserving type) AS CollectionGroup,
  lang AS Language,
  coll_group_text AS CollectionGroupName
FROM udm_coll_grpt
LEFT OUTER JOIN I_Language AS _Language ON Language = _Language.Language  -- association [0..1]
;

Learn More