P_OrganicPeroxideInAllLanguage

DDL: P_ORGANICPEROXIDEINALLLANGUAGE SQL: PORGPRXALLLNG Type: view COMPOSITE
13 Fields 2 Data Sources

P_OrganicPeroxideInAllLanguage is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_Language, P_OrganicPeroxide) and exposes 13 fields with key fields CmplRqVersOrganicPrxdUUID, Language.

Data Sources (2)

SourceAliasJoin Type
I_Language I_Language cross
P_OrganicPeroxide OrganicPeroxide from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PORGPRXALLLNG view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY CmplRqVersOrganicPrxdUUID P_OrganicPeroxide CmplRqVersOrganicPrxdUUID
KEY Language I_Language Language Report Text Language
ProdCmplncDngrsGdsIdnNmbrType P_OrganicPeroxide ProdCmplncDngrsGdsIdnNmbrType Number (Prefix)
ProdCmplncDngrsGdsIdnNmbr P_OrganicPeroxide ProdCmplncDngrsGdsIdnNmbr Number
ListedSubstance P_OrganicPeroxide ListedSubstance Listed Substance
DngrsGdsPositionOnSource P_OrganicPeroxide DngrsGdsPositionOnSource Position on Source
SubstanceListUUID P_OrganicPeroxide SubstanceListUUID Substance List
CmplRqVersUUID P_OrganicPeroxide CmplRqVersUUID NodeID
DngrsGdsOrganicPrxdName P_OrganicPeroxide DngrsGdsOrganicPrxdName Organic Peroxide Name
SubstanceUUID P_OrganicPeroxide SubstanceUUID Substance
ActiveSubstanceUUID P_OrganicPeroxide ActiveSubstanceUUID Substance
_OrgPeroxidePrintedName P_OrganicPeroxide _OrgPeroxidePrintedName
_Text I_Language _Text

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 P_OrganicPeroxideInAllLanguage.
-- 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: PORGPRXALLLNG

CREATE VIEW P_OrganicPeroxideInAllLanguage AS
SELECT
  OrganicPeroxide.CmplRqVersOrganicPrxdUUID AS CmplRqVersOrganicPrxdUUID,
  I_Language.Language AS Language,
  OrganicPeroxide.ProdCmplncDngrsGdsIdnNmbrType AS ProdCmplncDngrsGdsIdnNmbrType,
  OrganicPeroxide.ProdCmplncDngrsGdsIdnNmbr AS ProdCmplncDngrsGdsIdnNmbr,
  OrganicPeroxide.ListedSubstance AS ListedSubstance,
  OrganicPeroxide.DngrsGdsPositionOnSource AS DngrsGdsPositionOnSource,
  OrganicPeroxide.SubstanceListUUID AS SubstanceListUUID,
  OrganicPeroxide.CmplRqVersUUID AS CmplRqVersUUID,
  OrganicPeroxide.DngrsGdsOrganicPrxdName AS DngrsGdsOrganicPrxdName,
  OrganicPeroxide.SubstanceUUID AS SubstanceUUID,
  OrganicPeroxide.ActiveSubstanceUUID AS ActiveSubstanceUUID,
  OrganicPeroxide._OrgPeroxidePrintedName AS _OrgPeroxidePrintedName,
  I_Language._Text AS _Text
FROM P_OrganicPeroxide AS OrganicPeroxide
CROSS JOIN I_Language
;

Learn More