A_CmplRqRsltGHSLblAqtcToxty

DDL: A_CMPLRQRSLTGHSLBLAQTCTOXTY Type: view_entity CONSUMPTION Package: EHSDS_API_ODATA_CRR_GHS_LBL
13 Fields 1 Data Sources 2 OData Services

Unknown Aquatic Toxicity

A_CmplRqRsltGHSLblAqtcToxty is a Consumption CDS View that provides data about "Unknown Aquatic Toxicity" in SAP S/4HANA. It reads from 1 data source (R_CmplRqRsltGHSLblAqtcToxtyTP) and exposes 13 fields with key field GHSLblPortnAssgmtUUID. It is exposed through 2 OData services (API_GHSLABELINGASSESSMENT, ASQL_F8817). Part of development package EHSDS_API_ODATA_CRR_GHS_LBL.

Data Sources (1)

SourceAliasJoin Type
R_CmplRqRsltGHSLblAqtcToxtyTP R_CmplRqRsltGHSLblAqtcToxtyTP projection

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Unknown Aquatic Toxicity view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.sapObjectNodeType.name GHSLblAssmtAquaticToxicity view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
VDM.viewType #CONSUMPTION view
OData.entityType.name GHSLblAssmtAquaticToxicity_Type view

OData Services (2)

ServiceBindingVersionContractRelease
API_GHSLABELINGASSESSMENT API_GHSLABELINGASSESSMENT V4 C2 C1
ASQL_F8817 ASQL_F8817 C2 NOT_RELEASED

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY GHSLblPortnAssgmtUUID GHSLblPortnAssgmtUUID Unknown Acute AquaticToxicity Assignment
CmplRqRsltUUID CmplRqRsltUUID SDS Assessment
PCPrptySequence PCPrptySequence Sequence
GHSLblSpclInfoPhrsUUID GHSLblSpclInfoPhrsUUID Special Information
GHSLblSpclInfoPhrs
GHSLblConcnLowrQty GHSLblConcnLowrQty Total Concentration
GHSLblConcnLowrQtyTxt GHSLblConcnLowrQtyTxt Lower Limit Text
GHSLblConcnLowrQtyOptr GHSLblConcnLowrQtyOptr Operator of Lower Limit
GHSLblConcnUprQty GHSLblConcnUprQty Upper Limit Quantity
GHSLblConcnUprQtyTxt GHSLblConcnUprQtyTxt Upper Limit Text
GHSLblConcnUprQtyOptr GHSLblConcnUprQtyOptr Operator of Upper Limit
GHSLblConcnQtySAPUnit Unit of Measurement
GHSLblConcnQtyISOUnit

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_CmplRqRsltGHSLblAqtcToxty.
-- 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_CmplRqRsltGHSLblAqtcToxty AS
SELECT
  GHSLblPortnAssgmtUUID,
  CmplRqRsltUUID,
  PCPrptySequence,
  GHSLblSpclInfoPhrsUUID,
  cast( _GHSLblAqtcToxtyPhrs.ProdCmplncPhrs as ehsds_ghs_lbl_addl_stmnt_id preserving type ) AS GHSLblSpclInfoPhrs,
  GHSLblConcnLowrQty,
  GHSLblConcnLowrQtyTxt,
  GHSLblConcnLowrQtyOptr,
  GHSLblConcnUprQty,
  GHSLblConcnUprQtyTxt,
  GHSLblConcnUprQtyOptr,
  cast( GHSLblConcnUoM as ehsds_ghs_lbl_concn_unit_sap preserving type ) AS GHSLblConcnQtySAPUnit,
  cast( _UnitOfMeasure.UnitOfMeasureISOCode as ehsds_ghs_lbl_concn_unit_iso preserving type ) AS GHSLblConcnQtyISOUnit
FROM R_CmplRqRsltGHSLblAqtcToxtyTP
;

Learn More