R_WasteTranspDocDraft

DDL: R_WASTETRANSPDOCDRAFT Type: view_entity BASIC
44 Fields 1 Data Sources

Waste Transportation Documents

R_WasteTranspDocDraft is a Basic CDS View that provides data about "Waste Transportation Documents" in SAP S/4HANA. It reads from 1 data source (ehewaw_wa_tradoc) and exposes 44 fields with key field EnvrmtWasteTranspDocUUID.

Data Sources (1)

SourceAliasJoin Type
ehewaw_wa_tradoc ehewaw_wa_tradoc from

Annotations (8)

NameValueLevelField
VDM.viewType #BASIC view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Waste Transportation Documents view
Metadata.ignorePropagatedAnnotations true view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view

Fields (44)

KeyFieldSource TableSource FieldDescription
KEY EnvrmtWasteTranspDocUUID envrmtwastetranspdocuuid WTR UUID
WasteTranspDocID wastetranspdocid Trans Doc ID
EnvrmtWasteTranspDocNumber envrmtwastetranspdocnumber Trans Doc Number
EnvrmtWasteTranspDocType envrmtwastetranspdoctype Trans Doc Ty ID
EnvrmtWasteTranspDocStatus envrmtwastetranspdocstatus Trans Doc Status
EnvrmtWasteGnrtrUUID envrmtwastegnrtruuid Waste Generator UUID
EnvrmtWastePartnerNmbr envrmtwastepartnernmbr Busn. Partner
EnvrmtWasteGnrtrID envrmtwastegnrtrid Waste Generator ID
CmplRqVersUUID cmplrqversuuid NodeID
CmplRqVersPermitNumber cmplrqverspermitnumber Permit Number
ChmlCmplncWasteCodeUUID chmlcmplncwastecodeuuid Chml Cmplnc Wst Code
WasteStreamDsplChnlUUID wastestreamdsplchnluuid Dispsl Channel UUI
EnvrmtWasteTotConfirmedQty envrmtwastetotconfirmedqty Confirmed Qty
EnvrmtWasteDcmlTotConfirmedQty envrmtwastedcmltotconfirmedqty Confirmed Qty
EnvrmtWasteTotConfirmedQtyCode envrmtwastetotconfirmedqtycode Unit of Measurement
EnvrmtWasteTotOutgoingQty envrmtwastetotoutgoingqty Total Out Qty
EnvrmtWasteTotOutgoingQtyCode envrmtwastetotoutgoingqtycode Unit of Measurement
EnvWstTranspDocReturnByDate envwsttranspdocreturnbydate Trans Doc Ret Date
EnvWstTranspDocPrintedDate envwsttranspdocprinteddate Trans Doc Print Date
EnvWstTranspDocHandoverDate envwsttranspdochandoverdate Trans Doc HndovrDate
EnvWstTranspDocDescription envwsttranspdocdescription Trans Doc Desc
EnvWstTranspDocRemarkTxt envwsttranspdocremarktxt Transp Doc Remark
WasteTranspDocMatlIsTransfReq wastetranspdocmatlistransfreq Created from WTR
WasteDisposalChannelNumber wastedisposalchannelnumber Number
DngrsGoodsModeOfTransport dngrsgoodsmodeoftransport Mode of Transport
WasteIsTransportedAbroad wasteistransportedabroad
EHSWasteTranspDocIsRecyclable ehswastetranspdocisrecyclable
Country country Venue: Ctry/Reg
EHSAuthorizationCheckHasFailed ehsauthorizationcheckhasfailed Select
EnvWstTranspDocDisposerDate envwsttranspdocdisposerdate Take/Accept Date
WastePartnerDisposerSgntrDate wastepartnerdisposersgntrdate WastePrtn Sgntr Date
WasteDisposerCntctPersnName wastedisposercntctpersnname WastePrtn CntctPersn
CmplRqPermitType cmplrqpermittype Permit Type
EnvrmtWasteGnrtrName envrmtwastegnrtrname Location
CreationDateTime creationdatetime Timestamp
CreatedByUser createdbyuser User Name
LastChangeDateTime lastchangedatetime Timestamp
LastChangedByUser lastchangedbyuser User Name
DraftEntityCreationDateTime draftentitycreationdatetime Draft Created On
DraftEntityLastChangeDateTime draftentitylastchangedatetime Draft Last Changed On
DraftAdministrativeDataUUID draftadministrativedatauuid UUID
DraftEntityOperationCode draftentityoperationcode Draft - Operation Code
HasActiveEntity hasactiveentity TRUE
DraftFieldChanges draftfieldchanges Field Changes

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_WasteTranspDocDraft.
-- 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_WasteTranspDocDraft AS
SELECT
  EnvrmtWasteTranspDocUUID,
  WasteTranspDocID,
  EnvrmtWasteTranspDocNumber,
  EnvrmtWasteTranspDocType,
  EnvrmtWasteTranspDocStatus,
  EnvrmtWasteGnrtrUUID,
  EnvrmtWastePartnerNmbr,
  EnvrmtWasteGnrtrID,
  CmplRqVersUUID,
  CmplRqVersPermitNumber,
  ChmlCmplncWasteCodeUUID,
  WasteStreamDsplChnlUUID,
  EnvrmtWasteTotConfirmedQty,
  EnvrmtWasteDcmlTotConfirmedQty,
  EnvrmtWasteTotConfirmedQtyCode,
  EnvrmtWasteTotOutgoingQty,
  EnvrmtWasteTotOutgoingQtyCode,
  EnvWstTranspDocReturnByDate,
  EnvWstTranspDocPrintedDate,
  EnvWstTranspDocHandoverDate,
  EnvWstTranspDocDescription,
  EnvWstTranspDocRemarkTxt,
  WasteTranspDocMatlIsTransfReq,
  WasteDisposalChannelNumber,
  DngrsGoodsModeOfTransport,
  WasteIsTransportedAbroad,
  EHSWasteTranspDocIsRecyclable,
  Country,
  EHSAuthorizationCheckHasFailed,
  EnvWstTranspDocDisposerDate,
  WastePartnerDisposerSgntrDate,
  WasteDisposerCntctPersnName,
  CmplRqPermitType,
  EnvrmtWasteGnrtrName,
  CreationDateTime,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser,
  DraftEntityCreationDateTime,
  DraftEntityLastChangeDateTime,
  DraftAdministrativeDataUUID,
  DraftEntityOperationCode,
  HasActiveEntity,
  DraftFieldChanges
FROM ehewaw_wa_tradoc
;

Learn More