A_ChemicalComplianceInfo

DDL: A_CHEMICALCOMPLIANCEINFO Type: view_entity CONSUMPTION Package: EHFND_API_ODATA_CCI
15 Fields 1 Data Sources 2 OData Services

Chemical Compliance Info

A_ChemicalComplianceInfo is a Consumption CDS View that provides data about "Chemical Compliance Info" in SAP S/4HANA. It reads from 1 data source (R_ChemicalComplianceInfoTP) and exposes 15 fields with key field ChmlCmplncInfoUUID. It is exposed through 2 OData services (API_CHEMICALCOMPLIANCEINFO, ASQL_F6753). Part of development package EHFND_API_ODATA_CCI.

Data Sources (1)

SourceAliasJoin Type
R_ChemicalComplianceInfoTP R_ChemicalComplianceInfoTP projection

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Chemical Compliance Info view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #MIXED 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 ChemicalComplianceInfo_Type view

OData Services (2)

ServiceBindingVersionContractRelease
API_CHEMICALCOMPLIANCEINFO API_CHEMICALCOMPLIANCEINFO V4 C2 C1
ASQL_F6753 ASQL_F6753 C2 NOT_RELEASED

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY ChmlCmplncInfoUUID ChmlCmplncInfoUUID Chemical Compliance Information PP
ChemicalComplianceInfo ChemicalComplianceInfo Internal Number
ChmlCmplncInternalName ChmlCmplncInternalName Internal Name
ChmlCmplncInfoType ChmlCmplncInfoType Type of Chemical Compliance Information
ResponsibleUnit ProdStewardshipRespUnit Responsible Unit
DngrsGdsRespUnit DngrsGdsRespUnit Responsible Unit for Dangerous Goods
ProdStewardshipRespUnit ProdStewardshipRespUnit Responsible Unit
MaterialIsSold MaterialIsSold Is Sold
MaterialIsTransported MaterialIsTransported Is Transported
MaterialIsSourced MaterialIsSourced Is Purchased
MaterialIsProduced MaterialIsProduced Is Produced
ChmlCmplncProdIsResearched ChmlCmplncProdIsResearched R&D Sample
SftyDataShtIsNotRequired SftyDataShtIsNotRequired Is Not Product Safety Relevant
MaterialIsDisposed MaterialIsDisposed Is Disposed
MaterialIsEmissionRelevant MaterialIsEmissionRelevant Emission Relevant

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_ChemicalComplianceInfo.
-- 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_ChemicalComplianceInfo AS
SELECT
  ChmlCmplncInfoUUID,
  ChemicalComplianceInfo,
  ChmlCmplncInternalName,
  ChmlCmplncInfoType,
  ProdStewardshipRespUnit AS ResponsibleUnit,
  DngrsGdsRespUnit,
  ProdStewardshipRespUnit,
  MaterialIsSold,
  MaterialIsTransported,
  MaterialIsSourced,
  MaterialIsProduced,
  ChmlCmplncProdIsResearched,
  SftyDataShtIsNotRequired,
  MaterialIsDisposed,
  MaterialIsEmissionRelevant
FROM R_ChemicalComplianceInfoTP
;

Learn More