C_DangerousGoodsRegulatoryData

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_DangerousGoodsRegulatoryData.
-- 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 C_DangerousGoodsRegulatoryData AS
SELECT
  CmplRqVersUUID,
  DangerousGoodsIdnNumber AS ProdCmplncDngrsGdsIdnNmbr,
  DangerousGoodsIdnNumberType AS ProdCmplncDngrsGdsIdnNmbrType,
  DangerousGoodsListItemVariant,
  DangerousGoodsPackingGroup,
  CmplRqVersDngrsGdsPrt1ItmUUID,
  ProperShippingName,
  DangerousGoodsListItmAddlDesc,
  DangerousGoodsClass,
  DangerousGoodsSubsidiaryRisk1,
  DangerousGoodsSubsidiaryRisk2,
  DangerousGoodsSubsidiaryRisk3,
  cast( '' as boolean preserving type ) AS IdnNmbrIsOnOrganicPrxdList,
  cast( '' as boolean preserving type ) AS IdnNmbrIsOnSelfReactvSubstList,
  cast ('' as specialprovisionlisttxt) AS SpecialProvisionListTxt,
  TransportPermission,
  _TransportPermission.TransportPermissionCriticality AS TransportPermissionCriticality,
  _CmplRqVersEnhanced.CmplRqVersEnglishName AS CmplRqVersEnglishName,
  _CmplRqVersEnhanced.CmplRqVersName AS CmplRqVersName,
  _CmplRqVersEnhanced.CmplRqPattern AS CmplRqPattern,
  _CmplRqVersEnhanced._CompReqPattern.CmplRqPatternName AS CmplRqPatternName,
  MarinePollutantCode,
  IMDGEmSchedFire,
  IMDGEmSchedFireIsUnderlined,
  IMDGEmSchedSpill,
  IMDGEmSchedSpillIsUnderlined,
  DangerousGoodsStowageCategory,
  cast ('' as dangerousgoodsstowagelisttxt) AS DangerousGoodsStowageListTxt,
  cast ('' as specialprovisionhndlglisttxt) AS SpecialProvisionHndlgListTxt,
  cast ('' as segregationgrouplisttxt) AS SegregationGroupListTxt,
  cast ('' as segregationlisttxt) AS SegregationListTxt,
  EmergencyResponseGuidebookCode,
  HazardChmlEmergencyActnCode,
  InitialEmergencyRspGuideCode,
  AU_ADGEmgyRspGuidebookCode,
  cast ('' as dngrsgdssymbolslisttxt) AS DngrsGdsSymbolsListTxt,
  DangerousGoodsHazardIdnNumber,
  DangerousGoodsEUADRClass,
  DangerousGoodsClassification,
  cast ('' as specialprovisionoplisttxt) AS SpecialProvisionOpListTxt,
  TunnelRestrictionCode,
  DangerousGoodsTransportCat,
  MaxTotalQtyPerTransptUnitUnit,
  DangerousGoodsQuantityFactor,
  DangerousGoodsQuantityType,
  cast ('' as spclprvsncarriageinbulklisttxt) AS SpclPrvsnCarriageInBulkListTxt,
  cast ('' as spclprvsnmsrbfrloadglisttxt) AS SpclPrvsnMsrBfrLoadgListTxt,
  cast ('' as spclprvsnhndlgstowagelisttxt) AS SpclPrvsnHndlgStowageListTxt,
  cast ('' as spclprvsnmsrduringloadglisttxt) AS SpclPrvsnMsrDuringLoadgListTxt,
  EUADNCarriagePermitted,
  EUADNNumberOfBlueConesLights
FROM P_CMPLRQVERSDNGRSGDSPART1ITEM
LEFT OUTER JOIN I_CmplRqVersEnhanced AS _CmplRqVersEnhanced ON CmplRqVersUUID = _CmplRqVersEnhanced.CmplRqVersUUID  -- association [1..1]
LEFT OUTER JOIN I_CmplRqVersActvtn AS _CmplRqVersActvtn ON CmplRqVersUUID = _CmplRqVersActvtn.CmplRqVersUUID  -- association [1..1]
LEFT OUTER JOIN I_TransportPermission AS _TransportPermission ON TransportPermission = _TransportPermission.TransportPermission  -- association [0..1]
LEFT OUTER JOIN I_TransportPermissionText AS _TransportPermissionText ON TransportPermission = _TransportPermissionText.TransportPermission  -- association [0..*]
LEFT OUTER JOIN C_DngrsGdsEnclrSpcfcDta AS _EnclrSpcfcDta ON CmplRqVersUUID = _EnclrSpcfcDta.CmplRqVersUUID AND ProdCmplncDngrsGdsIdnNmbr = _EnclrSpcfcDta.ProdCmplncDngrsGdsIdnNmbr AND ProdCmplncDngrsGdsIdnNmbrType = _EnclrSpcfcDta.ProdCmplncDngrsGdsIdnNmbrType AND DangerousGoodsListItemVariant = _EnclrSpcfcDta.DangerousGoodsListItemVariant AND DangerousGoodsPackingGroup = _EnclrSpcfcDta.DangerousGoodsPackingGroup  -- association [0..*]
LEFT OUTER JOIN C_DngrsGdsOrganicPrxdData AS _OrganicPrxdData ON CmplRqVersUUID = _OrganicPrxdData.CmplRqVersUUID AND ProdCmplncDngrsGdsIdnNmbr = _OrganicPrxdData.ProdCmplncDngrsGdsIdnNmbr AND ProdCmplncDngrsGdsIdnNmbrType = _OrganicPrxdData.ProdCmplncDngrsGdsIdnNmbrType  -- association [0..*]
LEFT OUTER JOIN C_DngrsGdsSelfReactvSubstData AS _SelfReactiveSubstanceData ON CmplRqVersUUID = _SelfReactiveSubstanceData.CmplRqVersUUID AND ProdCmplncDngrsGdsIdnNmbr = _SelfReactiveSubstanceData.ProdCmplncDngrsGdsIdnNmbr AND ProdCmplncDngrsGdsIdnNmbrType = _SelfReactiveSubstanceData.ProdCmplncDngrsGdsIdnNmbrType  -- association [0..*]
LEFT OUTER JOIN I_DngrsGdsPackingGroupText AS _DngrsGdsPackingGroupText ON DangerousGoodsPackingGroup = _DngrsGdsPackingGroupText.DangerousGoodsPackingGroup  -- association [0..*]
LEFT OUTER JOIN I_DngrsGdsQtyTypeTxt AS _DngrsGdsQtyTypeTxt ON DangerousGoodsQuantityType = _DngrsGdsQtyTypeTxt.DangerousGoodsQuantityType  -- association [0..*]
LEFT OUTER JOIN I_UnitOfMeasure AS _MaxTotQtyUnitText ON MaxTotalQtyPerTransptUnitUnit = _MaxTotQtyUnitText.UnitOfMeasure  -- association [0..1]
;