C_WasteStreamStorageLocVH

DDL: C_WASTESTREAMSTORAGELOCVH Type: view CONSUMPTION Package: EHEWA_CNS_WASTESTREAM
4 Fields 1 Associations 3 OData Services 1 Fiori Apps

Waste Stream Storage Location VH

C_WasteStreamStorageLocVH is a Consumption CDS View that provides data about "Waste Stream Storage Location VH" in SAP S/4HANA. It has 1 association to related views. It is exposed through 3 OData services (ASQL_F5410, ASQL_F6084, UI_WASTESTREAM_MANAGE). It is used in 1 Fiori application: My Waste Streams. Part of development package EHEWA_CNS_WASTESTREAM.

Associations (1)

CardinalityTargetAliasCondition
[1..*] I_EHSLocRespManagerCombined _EHSLocResponsibleManager $projection.WasteStreamStorageLocUUID = _EHSLocResponsibleManager.EHSLocationUUID

Annotations (11)

NameValueLevelField
EndUserText.label Waste Stream Storage Location VH view
AbapCatalog.sqlViewName CWSTSTRSTRGLOCVH 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 (3)

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

KeyFieldSource TableSource FieldDescription
KEY WasteStreamStorageLocUUID WasteStreamStorageLocUUID Storage Loctn UUID
WasteStreamStorageLocID WasteStreamStorageLocID Waste Storage Location
WasteStreamStorageLocName _LocText EHSLocationName Waste Storage Location Name
_EHSLocResponsibleManager _EHSLocResponsibleManager

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_WasteStreamStorageLocVH.
-- 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_WasteStreamStorageLocVH AS
SELECT
  WasteStreamStorageLocUUID,
  WasteStreamStorageLocID,
  _LocText.EHSLocationName AS WasteStreamStorageLocName
LEFT OUTER JOIN I_EHSLocRespManagerCombined AS _EHSLocResponsibleManager ON WasteStreamStorageLocUUID = _EHSLocResponsibleManager.EHSLocationUUID  -- association [1..*]
;

Learn More