C_EnvrmtWastePartnerTP

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_EnvrmtWastePartnerTP.
-- 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_EnvrmtWastePartnerTP AS
SELECT
  EnvrmtWastePartnerUUID,
  EnvrmtWastePartnerType,
  _WastePartnerType._Text[1: Language = $session.system_language].EnvrmtWastePartnerTypeName AS EnvrmtWastePartnerTypeName,
  EnvrmtWastePartnerNmbr,
  _BusinessPartner.EnvrmtWastePartnerName AS EnvrmtWastePartnerName,
  _BusinessPartner.EnvrmtWastePartnerFirstName AS EnvrmtWastePartnerFirstName,
  _BusinessPartner.EnvrmtWastePartnerLastName AS EnvrmtWastePartnerLastName,
  _BusinessPartner._BusinessPartner._CurrentDefaultAddress._Address.HouseNumber AS HouseNumber,
  _BusinessPartner._BusinessPartner._CurrentDefaultAddress._Address.StreetName AS StreetName,
  _BusinessPartner._BusinessPartner._CurrentDefaultAddress._Address.CityName AS CityName,
  _BusinessPartner._BusinessPartner._CurrentDefaultAddress._Address.Country AS BusinessPartnerCountry,
  _BusinessPartner._BusinessPartner._CurrentDefaultAddress._Address.PostalCode AS PostalCode,
  EnvrmtWasteGnrtrUUID,
  cast( EnvrmtWasteGnrtrID as ehfnd_loc_id preserving type ) AS EnvrmtWasteGnrtrID,
  _EHSLocation._EnvrmtWasteGnrtrText.EnvrmtWasteGnrtrName AS EnvrmtWasteGnrtrName,
  '' AS EnvWstPartDsplFcltyIsHidden,
  '' AS EnvWstRegnNmbrIsHidden,
  cast('' as text1024 ) AS EHSLocationURL,
  _EnvrmtWastePartnerIdn.BPIdentificationNumber AS BPIdentificationNumber,
  _EnvrmtWastePartnerIdn.BPIdnNmbrIssuingInstitute AS BPIdnNmbrIssuingInstitute,
  _EHSLocation.Country AS Country,
  _EHSLocation._CountryText.CountryName AS CountryName,
  _EHSLocation.Region AS Region,
  _EHSLocation._RegionText.RegionName AS RegionName,
  cast('' as abap.char( 60 )) AS EnvrmtWasteMgmtMethCodeGrpText,
  _EnvrmtWasteGnrtrByMgrRole.EnvrmtWasteGnrtrHasCurUsrAssgd AS EnvrmtWasteGnrtrHasCurUsrAssgd,
  CreationUTCDateTime,
  CreatedByUser,
  LastChangeUTCDateTime,
  LastChangedByUser
FROM I_EnvrmtWastePartnerTP AS WastePartner
LEFT OUTER JOIN C_EnvrmtWastePartnerIdn AS _EnvrmtWastePartnerIdn ON EnvrmtWastePartnerNmbr = _EnvrmtWastePartnerIdn.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN C_EnvrmtWastePartDsplFcltyTP AS _EnvrmtWastePartDsplFclty ON EnvrmtWastePartnerUUID = _EnvrmtWastePartDsplFclty.EnvrmtWastePartnerUUID  -- association [0..*]
LEFT OUTER JOIN C_EnvrmtWastePartMatlAssgmtTP AS _EnvrmtWastePartMatlAssgmt ON EnvrmtWastePartnerUUID = _EnvrmtWastePartMatlAssgmt.EnvrmtWastePartnerUUID  -- association [0..*]
;