C_WasteStreamPointOfGnrtnVH

DDL: C_WASTESTREAMPOINTOFGNRTNVH Type: view CONSUMPTION
32 Fields 1 Associations 2 OData Services 1 Fiori Apps

Waste Stream Pt Of Generation

C_WasteStreamPointOfGnrtnVH is a Consumption CDS View that provides data about "Waste Stream Pt Of Generation" in SAP S/4HANA. It has 1 association to related views. It is exposed through 2 OData services (UI_WASTETRANSFERREQUEST, UI_WASTETRANSFERREQUESTMANAGE). It is used in 1 Fiori application: My Waste Transfer Requests.

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_Country _Country $projection.country = _Country.Country

Annotations (14)

NameValueLevelField
EndUserText.label Waste Stream Pt Of Generation view
AbapCatalog.sqlViewName CWSTSTPTGENVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey 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
ObjectModel.updateEnabled true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Search.searchable true view

OData Services (2)

ServiceBindingVersionContractRelease
UI_WASTETRANSFERREQUEST UI_WASTETRANSFERREQUEST V2 C1 NOT_RELEASED
UI_WASTETRANSFERREQUESTMANAGE UI_WASTETRANSFERREQUESTMNG V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F6083 My Waste Transfer Requests Transactional The app will allow the production operator to create Internal Waste Transfer Requests when the waste container is full. A notification will be sent to the Environment Manager to process the request, which will be done in the “Manage Waste Transfer Request” app.

My Waste Transfer Requests

Business Role: Production Operator - EHS Info

With this app, an Environmental Manager can manage and create waste transfer requests. Waste transfer requests are the starting point for disposal processing. In the waste transfer request, you document the point of generation of the waste product, the related waste stream and disposal channel, the date of the transfer request, and the quantity of waste that was produced and the unit of measure. The waste transfer request also contains the data required for disposal processing. Waste transfer requests serve as a notification that waste can be moved from the point of generation. If a storage location has been specified, the waste product will be moved from the point of generation to a central collection point or to a local collection point. It will later be moved from the collection point to a disposal facility by the transporter. If no storage location has been specified, the waste product will be moved directly from the point of generation to the disposal facility by the transporter. Only a user with the role Environmental Manager (SAP_BR_EHS_ENV_MGMT) associated to a location, classified as waste generator, can manage waste transfer requests using this app. The location is called "waste generator" in the waste management context.

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY WasteStreamPtOfGnrtnUUID WasteStreamPtOfGnrtnUUID Pnt of Gnrtn UUID
WasteStreamPtOfGnrtnLocUUID WasteStreamPtOfGnrtnLocUUID Pnt of Gnrtn UUID
WasteStreamUUID WasteStreamUUID Waste Stream UUID
EnvrmtWasteGnrtrUUID EnvrmtWasteGnrtrUUID Waste Generator UUID
ChmlCmplncMatlAssgmtUUID ChmlCmplncMatlAssgmtUUID Product Assignment
ChmlCmplncInfoUUID ChmlCmplncInfoUUID Chemical Compliance Information PP
WasteStreamStorageLocID
WasteStreamStorageLocIsRqd
EnvrmtWasteGnrtrName _EnvrmtWasteGnrtrText EnvrmtWasteGnrtrName Location
EHSLocationName _WastePtOfGnrtn EHSLocationName Point of Generation
WasteStreamPtOfGnrtnLocID _WastePtOfGnrtn EHSLocationID
Material Material Product
ProductDescription
WasteStreamName _WasteStream WasteStreamName Waste Stream
_WastePtOfGnrtn _WastePtOfGnrtn
_MaterialGenerator _MaterialGenerator
WasteTransfReqDate Date
EnvrmtWasteOutgoingQuantity Quantity
WasteStorageUnitOfMeasure WasteStorageUnitOfMeasure Unit of Measure
WasteDisposalChannelUUID _DisposalChannelDefault WasteDisposalChannelUUID UUID
WasteDisposalChannelStatusName Disposal Channel Status
WasteDsplChnlWstStmStsTxt Waste Stream Status
WasteDisposalChannelName Disposal Channel
UnitOfMeasureName Unit of Measure
StorageLocationName Waste Storage Location
Country
Region
_Region
_WasteGeneratorByMgrRole _WasteGeneratorByMgrRole
_WasteGeneratorByOptRole _WasteGeneratorByOptRole
_WasteGenerator _WasteGenerator
_Country _Country

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_WasteStreamPointOfGnrtnVH.
-- 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_WasteStreamPointOfGnrtnVH AS
SELECT
  WasteStreamPtOfGnrtnUUID,
  WasteStreamPtOfGnrtnLocUUID,
  WasteStreamUUID,
  EnvrmtWasteGnrtrUUID,
  ChmlCmplncMatlAssgmtUUID,
  ChmlCmplncInfoUUID,
  _WasteStream._WasteGenerator.EHSLocationID AS WasteStreamStorageLocID,
  _WasteStream._HandlingType.WasteStreamStorageLocIsRqd AS WasteStreamStorageLocIsRqd,
  _EnvrmtWasteGnrtrText.EnvrmtWasteGnrtrName AS EnvrmtWasteGnrtrName,
  _WastePtOfGnrtn.EHSLocationName AS EHSLocationName,
  _WastePtOfGnrtn.EHSLocationID AS WasteStreamPtOfGnrtnLocID,
  Material,
  _WasteStream._ProductText[1: Language = $session.system_language].ProductDescription AS ProductDescription,
  _WasteStream.WasteStreamName AS WasteStreamName,
  cast( '00000000' as ehewa_wst_trf_req_date ) AS WasteTransfReqDate,
  cast( 0 as abap.quan( 13, 3 ) ) AS EnvrmtWasteOutgoingQuantity,
  WasteStorageUnitOfMeasure,
  _DisposalChannelDefault.WasteDisposalChannelUUID AS WasteDisposalChannelUUID,
  _DisposalChannelDefault._WasteDisposalChannel._DisposalChannelStatus.WasteDisposalChannelStatusName AS WasteDisposalChannelStatusName,
  _DisposalChnlWasteStream._WasteStreamStatus.WasteDisposalChannelStatusName AS WasteDsplChnlWstStmStsTxt,
  _DisposalChannelDefault._WasteDisposalChannel.WasteDisposalChannelName AS WasteDisposalChannelName,
  cast( '' as msehl ) AS UnitOfMeasureName,
  _WasteStream._WasteStorage.EHSLocationName AS StorageLocationName,
  _WasteStream._WasteGenerator.Country AS Country,
  _WasteStream._WasteGenerator.Region AS Region,
  _WasteStream._WasteGenerator._Region AS _Region
LEFT OUTER JOIN I_Country AS _Country ON country = _Country.Country  -- association [1..1]
;

Learn More