C_CA_AnlytlCmpstnMarnPlltntTDG

DDL: C_CA_ANLYTLCMPSTNMARNPLLTNTTDG SQL: CDGMARNPOLTDG Type: view CONSUMPTION
11 Fields 4 Data Sources

Marine Pollutants for Analytical Composition for TDG

C_CA_AnlytlCmpstnMarnPlltntTDG is a Consumption CDS View that provides data about "Marine Pollutants for Analytical Composition for TDG" in SAP S/4HANA. It reads from 4 data sources (I_CmplRqRslt, I_CmplRqRsltDngrsGdsBscDets, P_CA_MarinePollutantTDG, P_UpaDaGdsClfnTechName) and exposes 11 fields with key fields CmplRqRsltDngrsGdsBscDetsUUID, SubstanceUUID.

Data Sources (4)

SourceAliasJoin Type
I_CmplRqRslt I_CmplRqRslt inner
I_CmplRqRsltDngrsGdsBscDets I_CmplRqRsltDngrsGdsBscDets from
P_CA_MarinePollutantTDG P_CA_MarinePollutantTDG inner
P_UpaDaGdsClfnTechName P_UpaDaGdsClfnTechName inner

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CDGMARNPOLTDG view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Marine Pollutants for Analytical Composition for TDG view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.resultSet.sizeCategory #XS view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY CmplRqRsltDngrsGdsBscDetsUUID I_CmplRqRsltDngrsGdsBscDets CmplRqRsltDngrsGdsBscDetsUUID NodeID
KEY SubstanceUUID P_UpaDaGdsClfnTechName SubstanceUUID Substance
CmplRqVersUUID I_CmplRqRsltDngrsGdsBscDets CmplRqVersUUID NodeID
SubstanceName P_CA_MarinePollutantTDG SubstanceName Substance Name
SubstanceHasNameOnList P_CA_MarinePollutantTDG SubstanceHasNameOnList
ListedSubstanceGroupName P_CA_MarinePollutantTDG ListedSubstanceGroupName
ECNumber P_UpaDaGdsClfnTechName ECNumber EC Number
CASNumber P_UpaDaGdsClfnTechName CASNumber CAS Number
ChmlCmplncInfoUUID I_CmplRqRslt ChmlCmplncInfoUUID Chemical Compliance Information PP
_Substance P_UpaDaGdsClfnTechName _Substance
_ChmlCmplncInfo I_CmplRqRslt _ChmlCmplncInfo

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_CA_AnlytlCmpstnMarnPlltntTDG.
-- 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: CDGMARNPOLTDG

CREATE VIEW C_CA_AnlytlCmpstnMarnPlltntTDG AS
SELECT
  I_CmplRqRsltDngrsGdsBscDets.CmplRqRsltDngrsGdsBscDetsUUID AS CmplRqRsltDngrsGdsBscDetsUUID,
  P_UpaDaGdsClfnTechName.SubstanceUUID AS SubstanceUUID,
  I_CmplRqRsltDngrsGdsBscDets.CmplRqVersUUID AS CmplRqVersUUID,
  P_CA_MarinePollutantTDG.SubstanceName AS SubstanceName,
  P_CA_MarinePollutantTDG.SubstanceHasNameOnList AS SubstanceHasNameOnList,
  P_CA_MarinePollutantTDG.ListedSubstanceGroupName AS ListedSubstanceGroupName,
  P_UpaDaGdsClfnTechName.ECNumber AS ECNumber,
  P_UpaDaGdsClfnTechName.CASNumber AS CASNumber,
  I_CmplRqRslt.ChmlCmplncInfoUUID AS ChmlCmplncInfoUUID,
  P_UpaDaGdsClfnTechName._Substance AS _Substance,
  I_CmplRqRslt._ChmlCmplncInfo AS _ChmlCmplncInfo
FROM I_CmplRqRsltDngrsGdsBscDets
INNER JOIN I_CmplRqRslt ON /* join condition not captured in parsed metadata */
INNER JOIN P_UpaDaGdsClfnTechName ON /* join condition not captured in parsed metadata */
INNER JOIN P_CA_MarinePollutantTDG ON /* join condition not captured in parsed metadata */
;

Learn More