P_SubstTechPrxdFllbckAllLang

DDL: P_SUBSTTECHPRXDFLLBCKALLLANG SQL: PTSUBNAMPRXDFBAL Type: view COMPOSITE
3 Fields 1 Data Sources 3 Associations

P_SubstTechPrxdFllbckAllLang is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (P_SubstanceNameFallbackAllLang) and exposes 3 fields with key fields SubstanceUUID, Language. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
P_SubstanceNameFallbackAllLang Substance from

Parameters (3)

NameTypeDefault
P_CmplRqVersUUID sysuuid_x
P_DangerousGoodsIdnNumber ehdgm_dangerous_good_idn
P_DangerousGoodsIdnNumberType ehdgm_dangerous_good_idn_type

Associations (3)

CardinalityTargetAliasCondition
[0..*] P_SubstTechNameTextForSubst _SubstanceTechName Substance.SubstanceUUID = _SubstanceTechName.SubstanceUUID
[0..*] P_OrganicPrxdFallbackAllLang _OrganicPeroxide _OrganicPeroxide.SubstanceUUID = Substance.SubstanceUUID and _OrganicPeroxide.CmplRqVersUUID = $parameters.P_CmplRqVersUUID and _OrganicPeroxide.ProdCmplncDngrsGdsIdnNmbrType = $parameters.P_DangerousGoodsIdnNumberType and _OrganicPeroxide.ProdCmplncDngrsGdsIdnNmbr = $parameters.P_DangerousGoodsIdnNumber and _OrganicPeroxide.Language = Substance.Language
[0..*] P_SelfReactvSubstFllbckAllLang _SelfReactiveSubstances _SelfReactiveSubstances.SubstanceUUID = Substance.SubstanceUUID and _SelfReactiveSubstances.CmplRqVersUUID = $parameters.P_CmplRqVersUUID and _SelfReactiveSubstances.ProdCmplncDngrsGdsIdnNmbrType = $parameters.P_DangerousGoodsIdnNumberType and _SelfReactiveSubstances.ProdCmplncDngrsGdsIdnNmbr = $parameters.P_DangerousGoodsIdnNumber and _SelfReactiveSubstances.Language = Substance.Language

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PTSUBNAMPRXDFBAL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.dataMaintenance #DISPLAY_ONLY view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY SubstanceUUID P_SubstanceNameFallbackAllLang SubstanceUUID Substance
KEY Language P_SubstanceNameFallbackAllLang Language Report Text Language
CompanySubstance CompanySubstance Internal Number

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_SubstTechPrxdFllbckAllLang.
-- 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: PTSUBNAMPRXDFBAL
-- Parameters: P_CmplRqVersUUID : sysuuid_x, P_DangerousGoodsIdnNumber : ehdgm_dangerous_good_idn, P_DangerousGoodsIdnNumberType : ehdgm_dangerous_good_idn_type

CREATE VIEW P_SubstTechPrxdFllbckAllLang AS
SELECT
  Substance.SubstanceUUID AS SubstanceUUID,
  Substance.Language AS Language,
  CompanySubstance
FROM P_SubstanceNameFallbackAllLang AS Substance
LEFT OUTER JOIN P_SubstTechNameTextForSubst AS _SubstanceTechName ON Substance.SubstanceUUID = _SubstanceTechName.SubstanceUUID  -- association [0..*]
LEFT OUTER JOIN P_OrganicPrxdFallbackAllLang AS _OrganicPeroxide ON _OrganicPeroxide.SubstanceUUID = Substance.SubstanceUUID AND _OrganicPeroxide.CmplRqVersUUID = $parameters.P_CmplRqVersUUID AND _OrganicPeroxide.ProdCmplncDngrsGdsIdnNmbrType = $parameters.P_DangerousGoodsIdnNumberType AND _OrganicPeroxide.ProdCmplncDngrsGdsIdnNmbr = $parameters.P_DangerousGoodsIdnNumber AND _OrganicPeroxide.Language = Substance.Language  -- association [0..*]
LEFT OUTER JOIN P_SelfReactvSubstFllbckAllLang AS _SelfReactiveSubstances ON _SelfReactiveSubstances.SubstanceUUID = Substance.SubstanceUUID AND _SelfReactiveSubstances.CmplRqVersUUID = $parameters.P_CmplRqVersUUID AND _SelfReactiveSubstances.ProdCmplncDngrsGdsIdnNmbrType = $parameters.P_DangerousGoodsIdnNumberType AND _SelfReactiveSubstances.ProdCmplncDngrsGdsIdnNmbr = $parameters.P_DangerousGoodsIdnNumber AND _SelfReactiveSubstances.Language = Substance.Language  -- association [0..*]
;

Learn More