R_WasteStreamRgtyCodeTP

DDL: R_WASTESTREAMRGTYCODETP Type: view_entity TRANSACTIONAL

Waste Stream Regulatory Code

R_WasteStreamRgtyCodeTP is a Transactional CDS View that provides data about "Waste Stream Regulatory Code" in SAP S/4HANA. It reads from 1 data source (I_WasteStreamRgtyCode) and exposes 12 fields with key field WasteStreamRgtyCodeUUID.

Data Sources (1)

SourceAliasJoin Type
I_WasteStreamRgtyCode I_WasteStreamRgtyCode from

Annotations (9)

NameValueLevelField
EndUserText.label Waste Stream Regulatory Code 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 #M view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.representativeKey WasteStreamRgtyCodeUUID view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY WasteStreamRgtyCodeUUID WasteStreamRgtyCodeUUID Regulatory Code UUID
WasteStreamUUID WasteStreamUUID Waste Stream UUID
AdminDataCreationDateTime
CreatedByUser CreatedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
ContentWasteStreamRgtyCode
WasteStreamRgtyCodeValue WasteStreamRgtyCodeValue Rgty Code Value
WasteStreamRgtyCodeDesc WasteStreamRgtyCodeDesc Rgty Code Desc.
Associations_WasteStream
_RegCode _RegCode
_RegCodeValue _RegCodeValue

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_WasteStreamRgtyCodeTP.
-- 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_WasteStreamRgtyCodeTP AS
SELECT
  WasteStreamRgtyCodeUUID,
  WasteStreamUUID,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser,
  WasteStreamRgtyCodeValue,
  WasteStreamRgtyCodeDesc
FROM I_WasteStreamRgtyCode
;