I_EHSEnvRptPRTRSubstWaste

DDL: I_EHSENVRPTPRTRSUBSTWASTE Type: view_entity COMPOSITE Package: EHENV_BO_ENV_REPORT
33 Fields 4 Data Sources 2 Associations

PRTR waste sensitive data

I_EHSEnvRptPRTRSubstWaste is a Composite CDS View that provides data about "PRTR waste sensitive data" in SAP S/4HANA. It reads from 4 data sources (I_ChmlCmplncWasteData, I_EHSAmount, I_EnvrmtWasteTranspDoc, I_EnvrmtWasteTranspDocMatl) and exposes 33 fields with key fields EnvrmtWasteTranspDocUUID, EnvWstTranspDocMatlAssgdUUID. It has 2 associations to related views. Part of development package EHENV_BO_ENV_REPORT.

Data Sources (4)

SourceAliasJoin Type
I_ChmlCmplncWasteData ChmlCmplncWasteData inner
I_EHSAmount EHSAmount inner
I_EnvrmtWasteTranspDoc EnvrmtWasteTranspDoc from
I_EnvrmtWasteTranspDocMatl EnvrmtWasteTranspDocMatl inner

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_EHSLocation _EHSLocation _EHSLocation.EHSLocationUUID = $projection.EHSLocationUUID and _EHSLocation.RevisionStartDate <= $session.system_date and _EHSLocation.RevisionEndDate > $session.system_date
[0..1] I_EnvrmtWasteTranspDocPart _Disposer _Disposer.EnvrmtWasteTranspDocUUID = $projection.EnvrmtWasteTranspDocUUID and _Disposer.EnvrmtWastePartnerType = '02'

Annotations (8)

NameValueLevelField
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
EndUserText.label PRTR waste sensitive data view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (33)

KeyFieldSource TableSource FieldDescription
KEY EnvrmtWasteTranspDocUUID I_EnvrmtWasteTranspDoc EnvrmtWasteTranspDocUUID WTR UUID
KEY EnvWstTranspDocMatlAssgdUUID I_EnvrmtWasteTranspDocMatl EnvWstTranspDocMatlAssgdUUID Matl Assigd UUID
EnvrmtWastePartnerName
EnvrmtWastePartDsplFcltyUUID
EnvrmtWastePartFcltyName
CountryThreeDigitISOCode
BusinessPartnerCountry
CountryendasCountry
BusinessPartnerCityName
CityNameendasCityName
BusinessPartnerStreetName
StreetNameendasStreetName
BusinessPartnerHouseNumber
HouseNumberendasHouseNumber
BusinessPartnerPostalCode
PostalCodeendasPostalCode
EnvrmtWasteHazardCharcID I_ChmlCmplncWasteData EnvrmtWasteHazardCharcID Waste Type ID
EnvWstTranspDocTakeAcceptDate _Disposer EnvWstTranspDocTakeAcceptDate Take/Accept Date
WasteStreamDsplChnlUUID I_EnvrmtWasteTranspDoc WasteStreamDsplChnlUUID Dispsl Channel UUI
EHSLocationUUID I_EnvrmtWasteTranspDoc EnvrmtWasteGnrtrUUID Waste Generator UUID
Material I_EnvrmtWasteTranspDocMatl Material Vehicle Model
WasteIsTransportedAbroad I_EnvrmtWasteTranspDoc WasteIsTransportedAbroad
EHSWasteProductIsRecyclable I_EnvrmtWasteTranspDocMatl EHSWasteProductIsRecyclable
EHSAmountUUID I_EHSAmount EHSAmountUUID NodeID
EHSAmountValue I_EHSAmount EHSAmountValue Value
UnitOfMeasure I_EHSAmount UnitOfMeasure Unit Protected Qty
WasteTranspDocID I_EnvrmtWasteTranspDoc WasteTranspDocID Trans Doc ID
EHSLocationID _EHSLocation EHSLocationID
EnvrmtWasteTranspDocStatus I_EnvrmtWasteTranspDoc EnvrmtWasteTranspDocStatus Trans Doc Status
EnvrmtWasteTranspDocType I_EnvrmtWasteTranspDoc EnvrmtWasteTranspDocType Trans Doc Ty ID
_Disposer _Disposer
_EHSLocation _EHSLocation
_Location I_EnvrmtWasteTranspDoc _Location

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 I_EHSEnvRptPRTRSubstWaste.
-- 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 I_EHSEnvRptPRTRSubstWaste AS
SELECT
  EnvrmtWasteTranspDoc.EnvrmtWasteTranspDocUUID AS EnvrmtWasteTranspDocUUID,
  EnvrmtWasteTranspDocMatl.EnvWstTranspDocMatlAssgdUUID AS EnvWstTranspDocMatlAssgdUUID,
  _Disposer._WastePartner._BusinessPartner.EnvrmtWastePartnerName AS EnvrmtWastePartnerName,
  _Disposer._DisposalFacility.EnvrmtWastePartDsplFcltyUUID AS EnvrmtWastePartDsplFcltyUUID,
  _Disposer._DisposalFacility.EnvrmtWastePartFcltyName AS EnvrmtWastePartFcltyName,
  _Disposer._WastePartner._BusinessPartner._BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation._Country.CountryThreeDigitISOCode AS CountryThreeDigitISOCode,
  _Disposer._WastePartner._BusinessPartner._BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.Country AS BusinessPartnerCountry,
  case when _Disposer._DisposalFacility._Address_2[ 1: CorrespondenceLanguage = $session.system_language].Country is not null then _Disposer._DisposalFacility._Address_2[ 1: CorrespondenceLanguage = $session.system_language].Country when _Disposer._DisposalFacility._Address_2[ 1: CorrespondenceLanguage = 'E'].Country is not null then _Disposer._DisposalFacility._Address_2[ 1: CorrespondenceLanguage = 'E' ].Country else _Disposer._DisposalFacility._Address_2[ 1: CorrespondenceLanguage is not null ].Country end as Country AS CountryendasCountry,
  _Disposer._WastePartner._BusinessPartner._BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.CityName AS BusinessPartnerCityName,
  case when _Disposer._DisposalFacility._Address_2[ 1: CorrespondenceLanguage = $session.system_language].CityName is not null then _Disposer._DisposalFacility._Address_2[ 1: CorrespondenceLanguage = $session.system_language].CityName when _Disposer._DisposalFacility._Address_2[ 1: CorrespondenceLanguage = 'E'].CityName is not null then _Disposer._DisposalFacility._Address_2[ 1: CorrespondenceLanguage = 'E' ].CityName else _Disposer._DisposalFacility._Address_2[ 1: CorrespondenceLanguage is not null ].CityName end as CityName AS CityNameendasCityName,
  _Disposer._WastePartner._BusinessPartner._BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.StreetName AS BusinessPartnerStreetName,
  case when _Disposer._DisposalFacility._Address_2[ 1: CorrespondenceLanguage = $session.system_language].StreetName is not null then _Disposer._DisposalFacility._Address_2[ 1: CorrespondenceLanguage = $session.system_language].StreetName when _Disposer._DisposalFacility._Address_2[ 1: CorrespondenceLanguage = 'E'].StreetName is not null then _Disposer._DisposalFacility._Address_2[ 1: CorrespondenceLanguage = 'E' ].StreetName else _Disposer._DisposalFacility._Address_2[ 1: CorrespondenceLanguage is not null ].StreetName end as StreetName AS StreetNameendasStreetName,
  _Disposer._WastePartner._BusinessPartner._BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.HouseNumber AS BusinessPartnerHouseNumber,
  case when _Disposer._DisposalFacility._Address_2[ 1: CorrespondenceLanguage = $session.system_language].HouseNumber is not null then _Disposer._DisposalFacility._Address_2[ 1: CorrespondenceLanguage = $session.system_language].HouseNumber when _Disposer._DisposalFacility._Address_2[ 1: CorrespondenceLanguage = 'E'].HouseNumber is not null then _Disposer._DisposalFacility._Address_2[ 1: CorrespondenceLanguage = 'E' ].HouseNumber else _Disposer._DisposalFacility._Address_2[ 1: CorrespondenceLanguage is not null ].HouseNumber end as HouseNumber AS HouseNumberendasHouseNumber,
  _Disposer._WastePartner._BusinessPartner._BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.PostalCode AS BusinessPartnerPostalCode,
  case when _Disposer._DisposalFacility._Address_2[ 1: CorrespondenceLanguage = $session.system_language].PostalCode is not null then _Disposer._DisposalFacility._Address_2[ 1: CorrespondenceLanguage = $session.system_language].PostalCode when _Disposer._DisposalFacility._Address_2[ 1: CorrespondenceLanguage = 'E'].PostalCode is not null then _Disposer._DisposalFacility._Address_2[ 1: CorrespondenceLanguage = 'E' ].PostalCode else _Disposer._DisposalFacility._Address_2[ 1: CorrespondenceLanguage is not null ].PostalCode end as PostalCode AS PostalCodeendasPostalCode,
  ChmlCmplncWasteData.EnvrmtWasteHazardCharcID AS EnvrmtWasteHazardCharcID,
  _Disposer.EnvWstTranspDocTakeAcceptDate AS EnvWstTranspDocTakeAcceptDate,
  EnvrmtWasteTranspDoc.WasteStreamDsplChnlUUID AS WasteStreamDsplChnlUUID,
  EnvrmtWasteTranspDoc.EnvrmtWasteGnrtrUUID AS EHSLocationUUID,
  EnvrmtWasteTranspDocMatl.Material AS Material,
  EnvrmtWasteTranspDoc.WasteIsTransportedAbroad AS WasteIsTransportedAbroad,
  EnvrmtWasteTranspDocMatl.EHSWasteProductIsRecyclable AS EHSWasteProductIsRecyclable,
  EHSAmount.EHSAmountUUID AS EHSAmountUUID,
  EHSAmount.EHSAmountValue AS EHSAmountValue,
  EHSAmount.UnitOfMeasure AS UnitOfMeasure,
  EnvrmtWasteTranspDoc.WasteTranspDocID AS WasteTranspDocID,
  _EHSLocation.EHSLocationID AS EHSLocationID,
  EnvrmtWasteTranspDoc.EnvrmtWasteTranspDocStatus AS EnvrmtWasteTranspDocStatus,
  EnvrmtWasteTranspDoc.EnvrmtWasteTranspDocType AS EnvrmtWasteTranspDocType,
  EnvrmtWasteTranspDoc._Location AS _Location
FROM I_EnvrmtWasteTranspDoc AS EnvrmtWasteTranspDoc
INNER JOIN I_EnvrmtWasteTranspDocMatl AS EnvrmtWasteTranspDocMatl ON /* join condition not captured in parsed metadata */
INNER JOIN I_ChmlCmplncWasteData AS ChmlCmplncWasteData ON /* join condition not captured in parsed metadata */
INNER JOIN I_EHSAmount AS EHSAmount ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_EHSLocation AS _EHSLocation ON _EHSLocation.EHSLocationUUID = EHSLocationUUID AND _EHSLocation.RevisionStartDate <= $session.system_date AND _EHSLocation.RevisionEndDate > $session.system_date  -- association [1..1]
LEFT OUTER JOIN I_EnvrmtWasteTranspDocPart AS _Disposer ON _Disposer.EnvrmtWasteTranspDocUUID = EnvrmtWasteTranspDocUUID AND _Disposer.EnvrmtWastePartnerType = '02'  -- association [0..1]
;

Learn More