C_WasteStreamMatlVH

DDL: C_WASTESTREAMMATLVH Type: view CONSUMPTION Package: EHEWA_CNS_WASTESTREAM
7 Fields 5 OData Services 1 Fiori Apps

Waste Stream Material VH

C_WasteStreamMatlVH is a Consumption CDS View that provides data about "Waste Stream Material VH" in SAP S/4HANA. It is exposed through 5 OData services (ASQL_F5410, ASQL_F6083, ASQL_F6084, ...). It is used in 1 Fiori application: My Waste Streams. Part of development package EHEWA_CNS_WASTESTREAM.

Annotations (11)

NameValueLevelField
EndUserText.label Waste Stream Material VH view
AbapCatalog.sqlViewName CWSTSTRMMATLVH view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.dataCategory #VALUE_HELP view
AccessControl.authorizationCheck #MANDATORY view
ClientHandling.algorithm #SESSION_VARIABLE view
Search.searchable true view

OData Services (5)

ServiceBindingVersionContractRelease
ASQL_F5410 ASQL_F5410 C2 NOT_RELEASED
ASQL_F6083 ASQL_F6083 C2 NOT_RELEASED
ASQL_F6084 ASQL_F6084 C2 NOT_RELEASED
ASQL_F6543 ASQL_F6543 C2 NOT_RELEASED
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 (7)

KeyFieldSource TableSource FieldDescription
KEY ChmlCmplncInfoUUID ChmlCmplncInfoUUID Chemical Compliance Information PP
KEY ChmlCmplncMatlAssgmtUUID ChmlCmplncMatlAssgmtUUID Product Assignment
KEY Material Material Product
ProductDescription _MaterialText ProductDescription Product Description
ProductIsPackaged ProductIsPackaged Packaged Material
ProductExternalID _Product ProductExternalID Material
Associations_ChmlCmplncInfo

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_WasteStreamMatlVH.
-- 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_WasteStreamMatlVH AS
SELECT
  ChmlCmplncInfoUUID,
  ChmlCmplncMatlAssgmtUUID,
  Material,
  _MaterialText.ProductDescription AS ProductDescription,
  ProductIsPackaged,
  _Product.ProductExternalID AS ProductExternalID
;

Learn More