I_WasteMgmtMethCodeDimension

DDL: I_WASTEMGMTMETHCODEDIMENSION SQL: IWANALYTMMCD Type: view COMPOSITE
3 Fields 1 Data Sources 1 Associations

Waste MgmtMethCode Dimension

I_WasteMgmtMethCodeDimension (Composite)

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

Cross Applications

I_WasteMgmtMethCodeDimension is a Composite CDS View (Dimension) that provides data about "Waste MgmtMethCode Dimension" in SAP S/4HANA. It reads from 1 data source (I_EnvrmtWasteMgmtMethCode) and exposes 3 fields with key field EnvrmtWasteMgmtMethCode. It has 1 association to related views.

SAP API Hub

StateC1
Line of BusinessCross Applications
Application ComponentEHS-SUS-WA
CapabilitiesAnalytical Dimension, Association Target for Defining CDS Entities
PackageCross Applications for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
I_EnvrmtWasteMgmtMethCode I_EnvrmtWasteMgmtMethCode from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_EnvrmtWasteMgmtMethCodeText _MgmtMethCodeText $projection.EnvrmtWasteMgmtMethCode = _MgmtMethCodeText.EnvrmtWasteMgmtMethCode and $projection.EnvrmtWasteMgmtMethCodeGrp = _MgmtMethCodeText.EnvrmtWasteMgmtMethCodeGrp and _MgmtMethCodeText.Language = $session.system_language

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName IWANALYTMMCD view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
Analytics.dataCategory #DIMENSION view
Analytics.internalName #LOCAL view
AbapCatalog.preserveKey true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
Metadata.allowExtensions true view
ObjectModel.representativeKey EnvrmtWasteMgmtMethCode view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Waste MgmtMethCode Dimension view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY EnvrmtWasteMgmtMethCode EnvrmtWasteMgmtMethCode Waste Management Method Code
EnvrmtWasteMgmtMethCodeGrp EnvrmtWasteMgmtMethCodeGrp Waste Management Method Group
EnvrmtWasteMgmtMethCodeText _MgmtMethCodeText EnvrmtWasteMgmtMethCodeText Description (Extra Long)

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_WasteMgmtMethCodeDimension.
-- 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: IWANALYTMMCD

CREATE VIEW I_WasteMgmtMethCodeDimension AS
SELECT
  EnvrmtWasteMgmtMethCode,
  EnvrmtWasteMgmtMethCodeGrp,
  _MgmtMethCodeText.EnvrmtWasteMgmtMethCodeText AS EnvrmtWasteMgmtMethCodeText
FROM I_EnvrmtWasteMgmtMethCode
LEFT OUTER JOIN I_EnvrmtWasteMgmtMethCodeText AS _MgmtMethCodeText ON EnvrmtWasteMgmtMethCode = _MgmtMethCodeText.EnvrmtWasteMgmtMethCode AND EnvrmtWasteMgmtMethCodeGrp = _MgmtMethCodeText.EnvrmtWasteMgmtMethCodeGrp AND _MgmtMethCodeText.Language = $session.system_language  -- association [0..1]
;

Learn More