C_EHSCmplRqPmtWasteDataTP

DDL: C_EHSCMPLRQPMTWASTEDATATP SQL: CPMTWASTEDATA Type: view CONSUMPTION Package: EHENV_CNS_CMPLRQ_PERMIT
20 Fields 1 Data Sources 2 Associations

My Permits Waste Data

C_EHSCmplRqPmtWasteDataTP is a Consumption CDS View that provides data about "My Permits Waste Data" in SAP S/4HANA. It reads from 1 data source (I_EHSCmplRqPmtWasteDataTP) and exposes 20 fields with key field CmplRqVersChildUUID. It has 2 associations to related views. Part of development package EHENV_CNS_CMPLRQ_PERMIT.

Data Sources (1)

SourceAliasJoin Type
I_EHSCmplRqPmtWasteDataTP I_EHSCmplRqPmtWasteDataTP from

Associations (2)

CardinalityTargetAliasCondition
[1..1] C_EHSMyPermitsTP _MyPermits $projection.CmplRqVersUUID = _MyPermits.CmplRqVersUUID
[1..1] I_EnvrmtWastePartDsplFclty _DsplFclty $projection.EnvrmtWastePartDsplFcltyUUID = _DsplFclty.EnvrmtWastePartDsplFcltyUUID

Annotations (17)

NameValueLevelField
AbapCatalog.sqlViewName CPMTWASTEDATA view
AbapCatalog.compiler.compareFilter true view
EndUserText.label My Permits Waste Data view
Metadata.allowExtensions true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #CONSUMPTION view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.createEnabled EXTERNAL_CALCULATION view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.semanticKey CmplRqVersID view
ObjectModel.representativeKey CmplRqVersChildUUID view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY CmplRqVersChildUUID CmplRqVersChildUUID NodeID
CmplRqVersID CmplRqVersID Compliance Requirement
CmplRqVersChildCentralID CmplRqVersChildCentralID BCO KEY
CmplRqVersUUID CmplRqVersUUID NodeID
CreationDateTime CreationDateTime Timestamp
CreatedByUser CreatedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
EnvrmtWastePartnerUUID EnvrmtWastePartnerUUID Waste Partner UUID
EnvrmtWastePartDsplFcltyUUID EnvrmtWastePartDsplFcltyUUID Waste Facility UUID
EnvrmtWasteCode _WasteCode EnvrmtWasteCode Waste Code
EnvrmtWasteCodeUUID EnvrmtWasteCodeUUID Waste Code
EnvrmtWasteTotalDisposedQty
EnvrmtWasteCodeDescription
EnvrmtWasteOutgoingQuantity
UnitOfMeasure
EnvrmtWastePartFcltyName _DsplFclty EnvrmtWastePartFcltyName Waste Facility Name
_DsplFclty _DsplFclty
_WasteCode _WasteCode
_MyPermits _MyPermits

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_EHSCmplRqPmtWasteDataTP.
-- 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.
-- SQL view name: CPMTWASTEDATA

CREATE VIEW C_EHSCmplRqPmtWasteDataTP AS
SELECT
  CmplRqVersChildUUID,
  CmplRqVersID,
  CmplRqVersChildCentralID,
  CmplRqVersUUID,
  CreationDateTime,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser,
  EnvrmtWastePartnerUUID,
  EnvrmtWastePartDsplFcltyUUID,
  _WasteCode.EnvrmtWasteCode AS EnvrmtWasteCode,
  EnvrmtWasteCodeUUID,
  cast( 0 as ehewa_pmt_upplimit) AS EnvrmtWasteTotalDisposedQty,
  _WasteCode._WasteCodeText[1: Language = $session.system_language ].EnvrmtWasteCodeDescription AS EnvrmtWasteCodeDescription,
  _WasteCode._WasteLimit.CmplRqEnvrnmtlUpperLimitValue AS EnvrmtWasteOutgoingQuantity,
  _WasteCode._WasteLimit.UnitOfMeasure AS UnitOfMeasure,
  _DsplFclty.EnvrmtWastePartFcltyName AS EnvrmtWastePartFcltyName
FROM I_EHSCmplRqPmtWasteDataTP
LEFT OUTER JOIN C_EHSMyPermitsTP AS _MyPermits ON CmplRqVersUUID = _MyPermits.CmplRqVersUUID  -- association [1..1]
LEFT OUTER JOIN I_EnvrmtWastePartDsplFclty AS _DsplFclty ON EnvrmtWastePartDsplFcltyUUID = _DsplFclty.EnvrmtWastePartDsplFcltyUUID  -- association [1..1]
;

Learn More