I_CmplncOblgnAssignmentCube

DDL: I_CMPLNCOBLGNASSIGNMENTCUBE Type: view_entity COMPOSITE Package: EHFND_RAP_CMPLNC_OBLGN_ASSGMT

Compliance Obligations Assignment - Cube

I_CmplncOblgnAssignmentCube (Composite)

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

Cross Applications

I_CmplncOblgnAssignmentCube is a Composite CDS View (Cube) that provides data about "Compliance Obligations Assignment - Cube" in SAP S/4HANA. It reads from 1 data source (I_CmplncObligationAssignment) and exposes 13 fields with key field CmplncObligationAssignmentUUID. It has 1 association to related views. Part of development package EHFND_RAP_CMPLNC_OBLGN_ASSGMT.

SAP Help Documentation

CategoryObligation Assignment Compliance - Query
Data CategoryCube
StatusStatus
Purpose
This CDS view helps to retrieve the compliance obligation assignment. This CDS view provides the data to answer the following business questions: How many compliance obligation assignments are in the system? 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: Authorization Object ID Authorization Object Text EHFND_COM Compliance Obligation Management 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 Measure or Attribute CmplncObligationAssignmentUUID Compliance Obligation Assignment Attribute EHSLocationUUID Location Attribute EHSLocationName Text Attribute ComplianceObligationUUID Compliance Obligation Attribute CmplncOblgnAssgmtAppltyStatus Applicability Attribute CmplncOblgnAssgmtCmplncStatus Status Attribute CmplncOblgnAssgmtAppltyStsText Short Description Attribute CmplncOblgnAssgmtCmplncStsText Short Description Attribute ComplianceObligationTypeCode Type Attribute CmplncOblgnTypeDescription Type Attribute NumberOfRecords Number of Obligations Measure NumberOfFulfilledObligations Number of Fulfilled Obligations Measure CmplOblAsgtFulfilledUUID Compliance Obligation Assignment Attribute ComplianceObligationDomainCode Domain Attribute

View on SAP Help Portal →

SAP API Hub

CategoryComposite
StateC1
Line of BusinessCross Applications
Application ComponentEHS-SUS-FND-EHS
CapabilitiesData Provider for Analytical Queries
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Not Released
PackageCross Applications for SAP S/4HANA Cloud Public Edition
Description <p>This CDS view helps to retrieve the compliance obligation assignment.</p> <p>This CDS view provides the data to answer the following business questions:</p> <ul> <li><p>How many compliance obligation assignments are in the system?</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
I_CmplncObligationAssignment CmplncObligation from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_ComplianceObligationDomain _ObligationDomain $projection.ComplianceObligationUUID = _ObligationDomain.ComplianceObligationUUID

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Compliance Obligations Assignment - Cube view
Analytics.dataCategory #CUBE view
Analytics.internalName #LOCAL view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.modelingPattern #ANALYTICAL_CUBE view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY CmplncObligationAssignmentUUID CmplncObligationAssignmentUUID Compliance Obligation Assignment UUID
EHSLocationUUID EHSLocationUUID Location
EHSLocationName _EHSLocNameFallbackLanguage EHSLocationName Location Revision Text
ComplianceObligationUUID ComplianceObligationUUID Compliance Obligation
CmplncOblgnAssgmtAppltyStatus CmplncOblgnAssgmtAppltyStatus Applicability
CmplncOblgnAssgmtCmplncStatus CmplncOblgnAssgmtCmplncStatus Status
CmplncOblgnAssgmtAppltyStsText Short Text for Fixed Values
CmplncOblgnAssgmtCmplncStsText Short Text for Fixed Values
ComplianceObligationTypeCode _ComplianceObligation ComplianceObligationTypeCode Compliance Obligation Type
CmplncOblgnTypeDescription Compliance Obligation Type Description
NumberOfRecords Number of Obligations
NumberOfFulfilledObligations Number of Fulfilled Obligations
ComplianceObligationDomainCode _ObligationDomain ComplianceObligationDomainCode Compliance Obligation Domain

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_CmplncOblgnAssignmentCube.
-- 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_CmplncOblgnAssignmentCube AS
SELECT
  CmplncObligationAssignmentUUID,
  EHSLocationUUID,
  _EHSLocNameFallbackLanguage.EHSLocationName AS EHSLocationName,
  ComplianceObligationUUID,
  CmplncOblgnAssgmtAppltyStatus,
  CmplncOblgnAssgmtCmplncStatus,
  _CmplOblAsgtAppltyStatus._Text[1: Language = $session.system_language].CmplncOblgnAssgmtAppltyStsText AS CmplncOblgnAssgmtAppltyStsText,
  _CmplOblAsgtCmplncStatus._Text[1: Language = $session.system_language].CmplncOblgnAssgmtCmplncStsText AS CmplncOblgnAssgmtCmplncStsText,
  _ComplianceObligation.ComplianceObligationTypeCode AS ComplianceObligationTypeCode,
  _ComplianceObligation._ComplianceObligationTypeText[1: Language = $session.system_language].CmplncOblgnTypeDescription AS CmplncOblgnTypeDescription,
  cast( 0 as ehfnd_number_of_obligations ) AS NumberOfRecords,
  cast( 0 as ehfnd_number_fulfilled_obl ) AS NumberOfFulfilledObligations,
  _ObligationDomain.ComplianceObligationDomainCode AS ComplianceObligationDomainCode
FROM I_CmplncObligationAssignment AS CmplncObligation
LEFT OUTER JOIN I_ComplianceObligationDomain AS _ObligationDomain ON ComplianceObligationUUID = _ObligationDomain.ComplianceObligationUUID  -- association [0..*]
;