A_EnvrmtWasteTranspDocMatlTP

DDL: A_ENVRMTWASTETRANSPDOCMATLTP Type: view_entity CONSUMPTION Package: EHEWA_CNS_TRANSPDOC
21 Fields 1 Data Sources 1 OData Services

Products

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

Data Sources (1)

SourceAliasJoin Type
R_EnvrmtWasteTranspDocMatlTP R_EnvrmtWasteTranspDocMatlTP projection

Annotations (9)

NameValueLevelField
EndUserText.label Products view
AccessControl.authorizationCheck #CHECK view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
OData.entityType.name TranspDocMatl_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 (21)

KeyFieldSource TableSource FieldDescription
KEY EnvWstTranspDocMatlAssgdUUID EnvWstTranspDocMatlAssgdUUID Matl Assigd UUID
EnvrmtWasteTranspDocUUID EnvrmtWasteTranspDocUUID WTR UUID
ChmlCmplncInfoUUID ChmlCmplncInfoUUID Chemical Compliance Information PP
Material Material Vehicle Model
WasteStreamContainerType WasteStreamContainerType Wst Strm Contnr Type
ChmlCmplncWasteCodeUUID ChmlCmplncWasteCodeUUID Chml Cmplnc Wst Code
EnvrmtWasteNumberOfPackages EnvrmtWasteNumberOfPackages Number Of Packages
EHSOutgoingAmountUUID EHSOutgoingAmountUUID Key
EHSDisposedAmountUUID EHSDisposedAmountUUID Key
EnvrmtWasteOutgoingQuantity EnvrmtWasteOutgoingQuantity Quantity
EnvrmtWasteOutgoingQtyCode EnvrmtWasteOutgoingQtyCode Base Unit
EnvrmtWasteConfirmedQuantity EnvrmtWasteConfirmedQuantity
EnvrmtWasteConfirmedQtyCode EnvrmtWasteConfirmedQtyCode Base Unit
sstring1000
EnvrmtWasteOutgoingQtyISOCode
EnvrmtWasteConfirmedQtyISOCode
EnvrmtWasteCodeDescription
CreationDateTime CreationDateTime Timestamp
CreatedByUser CreatedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
LastChangedByUser LastChangedByUser User Name

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_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 A_EnvrmtWasteTranspDocMatlTP AS
SELECT
  EnvWstTranspDocMatlAssgdUUID,
  EnvrmtWasteTranspDocUUID,
  ChmlCmplncInfoUUID,
  Material,
  WasteStreamContainerType,
  ChmlCmplncWasteCodeUUID,
  EnvrmtWasteNumberOfPackages,
  EHSOutgoingAmountUUID,
  EHSDisposedAmountUUID,
  EnvrmtWasteOutgoingQuantity,
  EnvrmtWasteOutgoingQtyCode,
  EnvrmtWasteConfirmedQuantity,
  EnvrmtWasteConfirmedQtyCode,
  virtual EnvrmtWasteCodeString : abap.sstring( 1000 ) AS sstring1000,
  cast(_OutgoingQtyUnit.UnitOfMeasureISOCode as ehewa_outgoingqty_code_iso preserving type ) AS EnvrmtWasteOutgoingQtyISOCode,
  cast(_ConfirmedQtyUnit.UnitOfMeasureISOCode as ehewa_confirmedqty_code_iso preserving type ) AS EnvrmtWasteConfirmedQtyISOCode,
  _WasteCodesReleased._WasteCodeText[1: Language = $session.system_language].EnvrmtWasteCodeDescription AS EnvrmtWasteCodeDescription,
  CreationDateTime,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser
FROM R_EnvrmtWasteTranspDocMatlTP
;

Learn More