C_WasteStreamDsplChnlTP

DDL: C_WASTESTREAMDSPLCHNLTP Type: view_entity CONSUMPTION
26 Fields 1 Data Sources 1 OData Services 1 Fiori Apps

Waste Stream Disposal Channel

C_WasteStreamDsplChnlTP is a Consumption CDS View that provides data about "Waste Stream Disposal Channel" in SAP S/4HANA. It reads from 1 data source (R_WasteStreamDsplChnlTP) and exposes 26 fields with key field WasteStreamDsplChnlUUID. It is exposed through 1 OData service (UI_WASTESTREAM_MANAGE). It is used in 1 Fiori application: My Waste Streams.

Data Sources (1)

SourceAliasJoin Type
R_WasteStreamDsplChnlTP R_WasteStreamDsplChnlTP projection

Annotations (8)

NameValueLevelField
EndUserText.label Waste Stream Disposal Channel view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.representativeKey WasteStreamDsplChnlUUID view
Metadata.allowExtensions true view

OData Services (1)

ServiceBindingVersionContractRelease
UI_WASTESTREAM_MANAGE UI_WASTESTREAM_MANAGE V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F5410 My Waste Streams Transactional An application to create waste streams and disposal channels for Waste Management

My Waste Streams

Business Role: Environmental Manager

With this feature, a user with the role of Environmental Manager can create waste streams, including waste disposal channels. Waste streams define the relationship between a waste product, a waste generator, a storage location, and the point(s) of waste generation. In addition, disposal channels can be created within a waste stream. Disposal channels define how a waste product can be disposed of. Disposal channels define the relationship between a waste stream and transporters and disposers. Transporters and disposers are previously entered as waste partners and then assigned to a waste material using the My Transporters and Disposers - Waste Management app.

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY WasteStreamDsplChnlUUID WasteStreamDsplChnlUUID Dispsl Channel UUI
WasteStreamUUID WasteStreamUUID Waste Stream UUID
WasteDisposalChannelUUID WasteDisposalChannelUUID UUID
AdminDataCreationDateTime
CreatedByUser CreatedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
ContentWasteStreamDsplChnlIsDflt
WasteDisposalChannelNumber _WasteDisposalChannel WasteDisposalChannelNumber Number
WasteDisposalChannelName _WasteDisposalChannel WasteDisposalChannelName Dispsl Channel Name
WasteDsplChnlDisposerUUID _WasteDisposalChannel WasteDsplChnlDisposerUUID Waste Partner UUID
EnvrmtWastePartnerNmbr
EnvrmtWastePartnerName
WasteDsplChnlFacilityUUID _WasteDisposalChannel WasteDsplChnlFacilityUUID Waste Facility UUID
EnvrmtWastePartFcltyName
WasteDisposalChannelStatus _WasteDisposalChannel WasteDisposalChannelStatus Status
WasteDisposalChannelStatusName
Country _WasteDisposalChannel Country Venue: Ctry/Reg
Region
EnvrmtWasteGnrtrUUID _WasteStream EnvrmtWasteGnrtrUUID Waste Generator UUID
EnvrmtWasteGnrtrID
EnvrmtWasteGnrtrName
Material _WasteStream Material Vehicle Model
EnvrmtWasteTranspDocType _WasteDisposalChannel EnvrmtWasteTranspDocType Trans Doc Ty ID
EnvWstTranspDocTypeDesc
_WasteDisposalChannel _WasteDisposalChannel

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_WasteStreamDsplChnlTP.
-- 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 C_WasteStreamDsplChnlTP AS
SELECT
  WasteStreamDsplChnlUUID,
  WasteStreamUUID,
  WasteDisposalChannelUUID,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser,
  _WasteDisposalChannel.WasteDisposalChannelNumber AS WasteDisposalChannelNumber,
  _WasteDisposalChannel.WasteDisposalChannelName AS WasteDisposalChannelName,
  _WasteDisposalChannel.WasteDsplChnlDisposerUUID AS WasteDsplChnlDisposerUUID,
  _WasteDisposalChannel._Disposer.EnvrmtWastePartnerNmbr AS EnvrmtWastePartnerNmbr,
  _WasteDisposalChannel._Disposer._BusinessPartner.EnvrmtWastePartnerName AS EnvrmtWastePartnerName,
  _WasteDisposalChannel.WasteDsplChnlFacilityUUID AS WasteDsplChnlFacilityUUID,
  _WasteDisposalChannel._DisposalFacility.EnvrmtWastePartFcltyName AS EnvrmtWastePartFcltyName,
  _WasteDisposalChannel.WasteDisposalChannelStatus AS WasteDisposalChannelStatus,
  _WasteDisposalChannel._DisposalChannelStatus.WasteDisposalChannelStatusName AS WasteDisposalChannelStatusName,
  _WasteDisposalChannel.Country AS Country,
  _WasteDisposalChannel._WasteLocation.Region AS Region,
  _WasteStream.EnvrmtWasteGnrtrUUID AS EnvrmtWasteGnrtrUUID,
  _WasteStream._WasteGenerator.EHSLocationID AS EnvrmtWasteGnrtrID,
  _WasteStream._WasteGenerator.EHSLocationName AS EnvrmtWasteGnrtrName,
  _WasteStream.Material AS Material,
  _WasteDisposalChannel.EnvrmtWasteTranspDocType AS EnvrmtWasteTranspDocType,
  _WasteDisposalChannel._TransportDocType.EnvWstTranspDocTypeDesc AS EnvWstTranspDocTypeDesc
FROM R_WasteStreamDsplChnlTP
;

Learn More