A_EnvrmtWasteTranspDocTP

DDL: A_ENVRMTWASTETRANSPDOCTP Type: view_entity CONSUMPTION Package: EHEWA_CNS_TRANSPDOC
37 Fields 1 Data Sources 1 OData Services

Documents

A_EnvrmtWasteTranspDocTP is a Consumption CDS View that provides data about "Documents" in SAP S/4HANA. It reads from 1 data source (R_EnvrmtWasteTranspDocTP) and exposes 37 fields with key field EnvrmtWasteTranspDocUUID. It is exposed through 1 OData service (API_TRANSP_DOC). Part of development package EHEWA_CNS_TRANSPDOC.

Data Sources (1)

SourceAliasJoin Type
R_EnvrmtWasteTranspDocTP R_EnvrmtWasteTranspDocTP projection

Annotations (9)

NameValueLevelField
EndUserText.label Documents view
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
OData.entityType.name TranspDoc_Type view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
VDM.viewType #CONSUMPTION view

OData Services (1)

ServiceBindingVersionContractRelease
API_TRANSP_DOC API_TRANSPDOC V4 C2 C1

Fields (37)

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
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
EnvWstTranspDocDisposerDate EnvWstTranspDocDisposerDate Take/Accept Date
sstring163
sstring163
EnvrmtWasteTotConfdQtyISOCode
WasteRegistrationNumber
StreetName _Location StreetName Text
CityName _Location CityName Name
PostalCode _Location PostalCode Postal Code
Country _Location Country Venue: Ctry/Reg
CountryNamelocalized
Region _Location Region Venue Region
RegionNamelocalized
CreationDateTime CreationDateTime Timestamp
CreatedByUser CreatedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
_Location _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 A_EnvrmtWasteTranspDocTP.
-- 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 A_EnvrmtWasteTranspDocTP AS
SELECT
  EnvrmtWasteTranspDocUUID,
  WasteTranspDocID,
  EnvrmtWasteTranspDocNumber,
  EnvrmtWasteTranspDocType,
  EnvrmtWasteTranspDocStatus,
  EnvrmtWasteGnrtrUUID,
  EnvrmtWastePartnerNmbr,
  EnvrmtWasteGnrtrID,
  CmplRqVersUUID,
  CmplRqVersPermitNumber,
  ChmlCmplncWasteCodeUUID,
  WasteStreamDsplChnlUUID,
  EnvrmtWasteTotConfirmedQty,
  EnvrmtWasteDcmlTotConfirmedQty,
  EnvrmtWasteTotConfirmedQtyCode,
  EnvWstTranspDocReturnByDate,
  EnvWstTranspDocPrintedDate,
  EnvWstTranspDocHandoverDate,
  EnvWstTranspDocDescription,
  EnvWstTranspDocRemarkTxt,
  EnvWstTranspDocDisposerDate,
  virtual EnvrmtWastePartnerContactName : abap.sstring(163) AS sstring163,
  cast(_Unit.UnitOfMeasureISOCode as ehewa_totconfirmqty_code_iso preserving type ) AS EnvrmtWasteTotConfdQtyISOCode,
  _Location._EHSLocationRoot.WasteRegistrationNumber AS WasteRegistrationNumber,
  _Location.StreetName AS StreetName,
  _Location.CityName AS CityName,
  _Location.PostalCode AS PostalCode,
  _Location.Country AS Country,
  _Location._CountryText.CountryName : localized AS CountryNamelocalized,
  _Location.Region AS Region,
  _Location._RegionText.RegionName : localized AS RegionNamelocalized,
  CreationDateTime,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser
FROM R_EnvrmtWasteTranspDocTP
;

Learn More