C_WasteStreamRgtyCodeTP

DDL: C_WASTESTREAMRGTYCODETP Type: view_entity CONSUMPTION
13 Fields 1 Data Sources

Waste Stream Regulatory Code

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

Data Sources (1)

SourceAliasJoin Type
R_WasteStreamRgtyCodeTP R_WasteStreamRgtyCodeTP projection

Annotations (8)

NameValueLevelField
EndUserText.label Waste Stream Regulatory Code view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.representativeKey WasteStreamRgtyCodeUUID view
Metadata.allowExtensions true view

Fields (13)

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 Regulatory Code Value
WasteStreamRgtyCodeDesc WasteStreamRgtyCodeDesc Rgty Code Desc.
CountryName _RegCode CountryName Country/Region
WasteStreamRgtyCodeValueText _RegCodeValue WasteStreamRgtyCodeValueText
_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 C_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 C_WasteStreamRgtyCodeTP AS
SELECT
  WasteStreamRgtyCodeUUID,
  WasteStreamUUID,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser,
  WasteStreamRgtyCodeValue,
  WasteStreamRgtyCodeDesc,
  _RegCode.CountryName AS CountryName,
  _RegCodeValue.WasteStreamRgtyCodeValueText AS WasteStreamRgtyCodeValueText
FROM R_WasteStreamRgtyCodeTP
;

Learn More