C_WasteStreamDsplChnlVH

DDL: C_WASTESTREAMDSPLCHNLVH SQL: CWSDCVH Type: view CONSUMPTION Package: EHEWA_CNS_WASTESTREAM
17 Fields 1 Data Sources 1 OData Services

Disposal Channels

C_WasteStreamDsplChnlVH is a Consumption CDS View that provides data about "Disposal Channels" in SAP S/4HANA. It reads from 1 data source (I_WasteDisposalChannel) and exposes 17 fields with key fields WasteDisposalChannelUUID, Material. It is exposed through 1 OData service (ASQL_F5410). Part of development package EHEWA_CNS_WASTESTREAM.

Data Sources (1)

SourceAliasJoin Type
I_WasteDisposalChannel DisposalChannel from

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CWSDCVH view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Disposal Channels view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey WasteDisposalChannelUUID view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ClientHandling.algorithm #SESSION_VARIABLE view
Search.searchable true view

OData Services (1)

ServiceBindingVersionContractRelease
ASQL_F5410 ASQL_F5410 C2 NOT_RELEASED

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY WasteDisposalChannelUUID I_WasteDisposalChannel WasteDisposalChannelUUID UUID
KEY Material _Generator Material Vehicle Model
WasteDisposalChannelNumber I_WasteDisposalChannel WasteDisposalChannelNumber Number
WasteDisposalChannelName I_WasteDisposalChannel WasteDisposalChannelName Name
WasteDisposalChannelStatus I_WasteDisposalChannel WasteDisposalChannelStatus Status
WasteDisposalChannelStatusName
WasteDsplChnlDisposerUUID I_WasteDisposalChannel WasteDsplChnlDisposerUUID Waste Partner UUID
EnvrmtWastePartnerName Disposer
WasteDsplChnlFacilityUUID I_WasteDisposalChannel WasteDsplChnlFacilityUUID Waste Facility UUID
EnvrmtWastePartFcltyName Facility
EnvrmtWasteGnrtrID Waste Generator
EnvrmtWasteGnrtrName Waste Generator Name
ProductDescription
EnvrmtWasteTranspDocType I_WasteDisposalChannel EnvrmtWasteTranspDocType Trans Doc Ty ID
EnvrmtWasteGnrtrUUID I_WasteDisposalChannel EnvrmtWasteGnrtrUUID Waste Generator UUID
_WasteLocation I_WasteDisposalChannel _WasteLocation
_Disposer I_WasteDisposalChannel _Disposer

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 C_WasteStreamDsplChnlVH.
-- 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: CWSDCVH

CREATE VIEW C_WasteStreamDsplChnlVH AS
SELECT
  DisposalChannel.WasteDisposalChannelUUID AS WasteDisposalChannelUUID,
  _Generator.Material AS Material,
  DisposalChannel.WasteDisposalChannelNumber AS WasteDisposalChannelNumber,
  DisposalChannel.WasteDisposalChannelName AS WasteDisposalChannelName,
  DisposalChannel.WasteDisposalChannelStatus AS WasteDisposalChannelStatus,
  DisposalChannel._DisposalChannelStatus.WasteDisposalChannelStatusName AS WasteDisposalChannelStatusName,
  DisposalChannel.WasteDsplChnlDisposerUUID AS WasteDsplChnlDisposerUUID,
  DisposalChannel._Disposer._BusinessPartner.EnvrmtWastePartnerName AS EnvrmtWastePartnerName,
  DisposalChannel.WasteDsplChnlFacilityUUID AS WasteDsplChnlFacilityUUID,
  DisposalChannel._DisposalFacility.EnvrmtWastePartFcltyName AS EnvrmtWastePartFcltyName,
  DisposalChannel._WasteLocation.EHSLocationID AS EnvrmtWasteGnrtrID,
  DisposalChannel._WasteLocation._EnvrmtWasteGnrtrText.EnvrmtWasteGnrtrName AS EnvrmtWasteGnrtrName,
  _Generator._MaterialText.ProductDescription AS ProductDescription,
  DisposalChannel.EnvrmtWasteTranspDocType AS EnvrmtWasteTranspDocType,
  DisposalChannel.EnvrmtWasteGnrtrUUID AS EnvrmtWasteGnrtrUUID,
  DisposalChannel._WasteLocation AS _WasteLocation,
  DisposalChannel._Disposer AS _Disposer
FROM I_WasteDisposalChannel AS DisposalChannel
;

Learn More