R_WasteDisposalChnlWstStmTP

DDL: R_WASTEDISPOSALCHNLWSTSTMTP Type: view_entity TRANSACTIONAL
12 Fields 1 Data Sources 1 Associations

Disposal Channel Waste Stream - TP

R_WasteDisposalChnlWstStmTP is a Transactional CDS View that provides data about "Disposal Channel Waste Stream - TP" in SAP S/4HANA. It reads from 1 data source (I_WasteDisposalChnlWstStm) and exposes 12 fields with key field WasteDsplChnlWasteStreamUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_WasteDisposalChnlWstStm I_WasteDisposalChnlWstStm from

Associations (1)

CardinalityTargetAliasCondition
[0..1] R_WasteStreamTP _WasteStream $projection.WasteStreamUUID = _WasteStream.WasteStreamUUID

Annotations (9)

NameValueLevelField
EndUserText.label Disposal Channel Waste Stream - TP view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.representativeKey WasteDsplChnlWasteStreamUUID view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY WasteDsplChnlWasteStreamUUID WasteDsplChnlWasteStreamUUID Waste Stream UUID
WasteDisposalChannelUUID WasteDisposalChannelUUID UUID
WasteStreamUUID WasteStreamUUID Waste Stream UUID
WasteDsplChnlWasteStreamStatus WasteDsplChnlWasteStreamStatus Status
WasteStreamIsInitial
CreationDateTime CreationDateTime Timestamp
CreatedByUser CreatedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
_DisposalChannel _DisposalChannel
_WasteStream _WasteStream
_WasteStreamStatus _WasteStreamStatus

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 R_WasteDisposalChnlWstStmTP.
-- 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 R_WasteDisposalChnlWstStmTP AS
SELECT
  WasteDsplChnlWasteStreamUUID,
  WasteDisposalChannelUUID,
  WasteStreamUUID,
  WasteDsplChnlWasteStreamStatus,
  cast( 'X' as ehfnd_boolean preserving type ) AS WasteStreamIsInitial,
  CreationDateTime,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser
FROM I_WasteDisposalChnlWstStm
LEFT OUTER JOIN R_WasteStreamTP AS _WasteStream ON WasteStreamUUID = _WasteStream.WasteStreamUUID  -- association [0..1]
;

Learn More