What is I_WasteTransfReqDimension in SAP S/4HANA?

I_WasteTransfReqDimension is a composite CDS view in SAP S/4HANA. Waste Transfer Request Dimension It contains 15 fields.

Which tables does I_WasteTransfReqDimension read from?

I_WasteTransfReqDimension reads data from: I_WasteTransferRequest.

What VDM layer is I_WasteTransfReqDimension?

I_WasteTransfReqDimension is classified as a Composite view that combines data from multiple basic views.

I_WasteTransfReqDimension

DDL: I_WASTETRANSFREQDIMENSION SQL: IWANALYTWTRD Type: view COMPOSITE

15 Fields 1 Data Sources 2 Associations

Waste Transfer Request Dimension

I_WasteTransfReqDimension (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_WasteTransfReqDimension is a Composite CDS View (Dimension) that provides data about "Waste Transfer Request Dimension" in SAP S/4HANA. It reads from 1 data source (I_WasteTransferRequest) and exposes 15 fields with key field WasteTransferRequestNumber. It has 2 associations to related views.

SAP API Hub

State	C1
Line of Business	Cross Applications
Application Component	EHS-SUS-WA
Capabilities	Analytical Dimension, Association Target for Defining CDS Entities
Package	Cross Applications for SAP S/4HANA Cloud Private Edition

Documentation

Analytics with CDS Views — Build Analytics for S/4HANA Cloud Private Edition ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Private Edition CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Private Edition and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP Extensibility Explorer for SAP S/4HANA Cloud Private Edition — Explore SAP S/4HANA Cloud Private Edition Extensibility options by leveraging the sample scenarios from SAP
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Private Edition
View Browser — Search, browse and tag CDS Views

Data Sources (1)

Source	Alias	Join Type
I_WasteTransferRequest	I_WasteTransferRequest	from

Associations (2)

Cardinality	Target	Alias	Condition
[0..1]	I_Country	_Country	`$projection.Country = _Country.Country`
[0..1]	I_WastePtOfGnrtnDimension	_WastePtOfGnrtn	`$projection.ehslocationid = _WastePtOfGnrtn.EHSLocationID`

Annotations (14)

Name	Value	Level
AbapCatalog.sqlViewName	IWANALYTWTRD	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#MANDATORY	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	#L	view
Metadata.allowExtensions	true	view
ObjectModel.representativeKey	WasteTransferRequestNumber	view
VDM.viewType	#COMPOSITE	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
EndUserText.label	Waste Transfer Request Dimension	view

Fields (15)

Key	Field	Source Table	Source Field	Description
KEY	WasteTransferRequestNumber		WasteTransferRequestNumber	Number of Waste Transfer Request
	WasteStreamPtOfGnrtnLocUUID		WasteStreamPtOfGnrtnLocUUID	Waste Stream - Point of Generation UUID
	EHSLocationID	_WasteStorage	EHSLocationID	Location ID
	WasteStreamPtOfGnrtnLocName	_WasteStorage	EHSLocationName	Location
	WasteTransfReqStatus		WasteTransfReqStatus	Status of Waste Transfer Request
	WasteTransfReqStatusName	_WasteStatus	WasteTransfReqStatusName	Short Text for Fixed Values
	Country		Country	Venue: Ctry/Reg
	CostCenter	_WasteStorage	CostCenter	Cost Center
	WasteStreamUUID		WasteStreamUUID	Waste Stream UUID
	_Country		_Country
	_WasteStatus		_WasteStatus
	_WastePtOfGnrtn		_WastePtOfGnrtn
	_WasteStream		_WasteStream
	_WasteGeneratorManagerByRole		_WasteGeneratorManagerByRole
	_WasteGeneratorOperatorByRole		_WasteGeneratorOperatorByRole

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_WasteTransfReqDimension.
-- 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: IWANALYTWTRD

CREATE VIEW I_WasteTransfReqDimension AS
SELECT
  WasteTransferRequestNumber,
  WasteStreamPtOfGnrtnLocUUID,
  _WasteStorage.EHSLocationID AS EHSLocationID,
  _WasteStorage.EHSLocationName AS WasteStreamPtOfGnrtnLocName,
  WasteTransfReqStatus,
  _WasteStatus.WasteTransfReqStatusName AS WasteTransfReqStatusName,
  Country,
  _WasteStorage.CostCenter AS CostCenter,
  WasteStreamUUID
FROM I_WasteTransferRequest
LEFT OUTER JOIN I_Country AS _Country ON Country = _Country.Country  -- association [0..1]
LEFT OUTER JOIN I_WastePtOfGnrtnDimension AS _WastePtOfGnrtn ON ehslocationid = _WastePtOfGnrtn.EHSLocationID  -- association [0..1]
;

Depth:

I_WasteTransfReqDimension view

I_WasteTransferRequest view