I_ChmlCmplncInfoVH

DDL: I_CHMLCMPLNCINFOVH Type: view COMPOSITE Package: EHFND_BO_CCI
16 Fields 1 Data Sources 5 OData Services

Value Help for Chemical Compliance Information

I_ChmlCmplncInfoVH is a Composite CDS View that provides data about "Value Help for Chemical Compliance Information" in SAP S/4HANA. It reads from 1 data source (I_ChmlCmplncInfo) and exposes 16 fields with key field ChmlCmplncInfoUUID. It is exposed through 5 OData services (ASQL_F2647, ASQL_F3219, ASQL_F3221, ...). Part of development package EHFND_BO_CCI.

Data Sources (1)

SourceAliasJoin Type
I_ChmlCmplncInfo ChemicalComplianceInfo from

Annotations (14)

NameValueLevelField
EndUserText.label Value Help for Chemical Compliance Information view
AbapCatalog.sqlViewName ICCMPLCNINFOVH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.representativeKey ChmlCmplncInfoUUID view
Metadata.ignorePropagatedAnnotations true view
ClientHandling.algorithm #SESSION_VARIABLE view
Search.searchable true view

OData Services (5)

ServiceBindingVersionContractRelease
ASQL_F2647 ASQL_F2647 C2 NOT_RELEASED
ASQL_F3219 ASQL_F3219 C2 NOT_RELEASED
ASQL_F3221 ASQL_F3221 C2 NOT_RELEASED
ASQL_F5995 ASQL_F5995 C2 NOT_RELEASED
ASQL_F9011 ASQL_F9011 C2 NOT_RELEASED

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY ChmlCmplncInfoUUID I_ChmlCmplncInfo ChmlCmplncInfoUUID Chemical Compliance Information PP
Material PrimaryMaterial Material Vehicle Model
ProductName
ChmlCmplncInternalName I_ChmlCmplncInfo ChmlCmplncInternalName Internal Name
ProdStewardshipRespUnit I_ChmlCmplncInfo ProdStewardshipRespUnit Responsible Unit
DngrsGdsRespUnit I_ChmlCmplncInfo DngrsGdsRespUnit Responsible Unit for Dangerous Goods
ChmlCmplncInfoType I_ChmlCmplncInfo ChmlCmplncInfoType Type of Chemical Compliance Information
MaterialIsSold I_ChmlCmplncInfo MaterialIsSold Is Sold
MaterialIsTransported I_ChmlCmplncInfo MaterialIsTransported Is Transported
MaterialIsSourced I_ChmlCmplncInfo MaterialIsSourced Is Purchased
MaterialIsProduced I_ChmlCmplncInfo MaterialIsProduced Is Produced
MaterialIsDisposed I_ChmlCmplncInfo MaterialIsDisposed Is Disposed
MaterialIsEmissionRelevant I_ChmlCmplncInfo MaterialIsEmissionRelevant Emission Relevant
MatlIsMultiComponentProduct I_ChmlCmplncInfo MatlIsMultiComponentProduct
ChmlCmplncProdIsResearched I_ChmlCmplncInfo ChmlCmplncProdIsResearched R&D Sample
Specification I_ChmlCmplncInfo Specification Specification

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 I_ChmlCmplncInfoVH.
-- 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 I_ChmlCmplncInfoVH AS
SELECT
  ChemicalComplianceInfo.ChmlCmplncInfoUUID AS ChmlCmplncInfoUUID,
  PrimaryMaterial.Material AS Material,
  MaterialData._Text[1: Language = $session.system_language].ProductName AS ProductName,
  ChemicalComplianceInfo.ChmlCmplncInternalName AS ChmlCmplncInternalName,
  ChemicalComplianceInfo.ProdStewardshipRespUnit AS ProdStewardshipRespUnit,
  ChemicalComplianceInfo.DngrsGdsRespUnit AS DngrsGdsRespUnit,
  ChemicalComplianceInfo.ChmlCmplncInfoType AS ChmlCmplncInfoType,
  ChemicalComplianceInfo.MaterialIsSold AS MaterialIsSold,
  ChemicalComplianceInfo.MaterialIsTransported AS MaterialIsTransported,
  ChemicalComplianceInfo.MaterialIsSourced AS MaterialIsSourced,
  ChemicalComplianceInfo.MaterialIsProduced AS MaterialIsProduced,
  ChemicalComplianceInfo.MaterialIsDisposed AS MaterialIsDisposed,
  ChemicalComplianceInfo.MaterialIsEmissionRelevant AS MaterialIsEmissionRelevant,
  ChemicalComplianceInfo.MatlIsMultiComponentProduct AS MatlIsMultiComponentProduct,
  ChemicalComplianceInfo.ChmlCmplncProdIsResearched AS ChmlCmplncProdIsResearched,
  ChemicalComplianceInfo.Specification AS Specification
FROM I_ChmlCmplncInfo AS ChemicalComplianceInfo
;

Learn More