C_EnvrmtWasteTranspDocMatlTP

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_EnvrmtWasteTranspDocMatlTP.
-- 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_EnvrmtWasteTranspDocMatlTP AS
SELECT
  EnvWstTranspDocMatlAssgdUUID,
  EnvrmtWasteTranspDocUUID,
  ChmlCmplncInfoUUID,
  Material,
  WasteTransfReqUUID,
  WasteTransferRequestNumber,
  WasteStreamContainerType,
  ChmlCmplncWasteCodeUUID,
  EHSOutgoingAmountUUID,
  EnvrmtWasteOutgoingQuantity,
  EnvrmtWasteOutgoingQtyCode AS EnvrmtWasteUnitOfMeasure,
  _UnitOfMeasureText[1:UnitOfMeasure = envrmtwasteunitofmeasure and Language = $session.system_language].UnitOfMeasureLongName AS EnvrmtWasteUnitOfMeasureText,
  EHSDisposedAmountUUID,
  EnvrmtWasteConfirmedQuantity,
  EnvrmtWasteConfirmedQtyCode,
  _UnitOfMeasureText[1:UnitOfMeasure = envrmtwasteconfirmedqtycode and Language = $session.system_language].UnitOfMeasureLongName AS UnitOfMeasureLongName,
  EnvrmtWasteConfdMgmtMethCode,
  EHSWasteProductIsRecyclable,
  EnvrmtWasteNumberOfPackages,
  WasteStreamUUID,
  virtual TransportPermissionCriticality : abap.int1 AS int1,
  virtual TransportPermissionName : val_text AS virtualTransportPermissionNameval_text,
  virtual WasteContainerTypeIsShown : boolean AS virtualWasteContainerTypeIsShownboolean,
  virtual EnvrmtWasteCodeString : abap.sstring( 1000 ) AS sstring1000,
  virtual UICT_WasteCodeIsHidden : boolean AS virtualUICT_WasteCodeIsHiddenboolean,
  _OutAmount.UnitOfMeasureName AS UnitOfMeasureName,
  ProductDescription,
  _TranspDoc._WastePartner[1:EnvrmtWastePartnerType='01'].EnvrmtWastePartnerUUID AS EnvrmtWasteTranspPartnerUUID,
  _TranspDoc.ChmlCmplncWasteCodeUUID AS LeadingWasteCodeUUID,
  _TranspDoc.CmplRqVersUUID AS CmplRqVersUUID,
  _TranspDoc._Permit.CmplRqVersPermitNumber AS CmplRqVersPermitNumber,
  _TranspDoc.EnvrmtWasteGnrtrUUID AS EnvrmtWasteGnrtrUUID,
  _TranspDoc._WastePartner[1:EnvrmtWastePartnerType='02'].EnvrmtWastePartDsplFcltyUUID AS EnvrmtWastePartDsplFcltyUUID,
  _TranspDoc._WastePartner[1:EnvrmtWastePartnerType='02'].EnvrmtWastePartnerUUID AS EnvrmtWastePartnerUUID,
  _TranspDoc.WasteTranspDocMatlIsTransfReq AS WasteTranspDocMatlIsTransfReq,
  CreationDateTime,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser
FROM R_EnvrmtWasteTranspDocMatlTP
;