C_DngrsGdsUseOfRegulationTP

DDL: C_DNGRSGDSUSEOFREGULATIONTP SQL: CDGUORTP Type: view CONSUMPTION
14 Fields 1 Data Sources 3 Associations

Dangerous Goods Use of Regulation

C_DngrsGdsUseOfRegulationTP is a Consumption CDS View that provides data about "Dangerous Goods Use of Regulation" in SAP S/4HANA. It reads from 1 data source (I_DngrsGdsUseOfRegulationTP) and exposes 14 fields with key field DngrsGdsUseOfRegulationUUID. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_DngrsGdsUseOfRegulationTP I_DngrsGdsUseOfRegulationTP from

Associations (3)

CardinalityTargetAliasCondition
[0..*] C_DngrsGdsRglnCntryLangTP _DngrsGdsRglnCntryLang $projection.DngrsGdsUseOfRegulationUUID = _DngrsGdsRglnCntryLang.DngrsGdsUseOfRegulationUUID
[0..*] C_DngrsGdsDestCntryLangTP _DngrsGdsDestCntryLang $projection.DngrsGdsUseOfRegulationUUID = _DngrsGdsDestCntryLang.DngrsGdsUseOfRegulationUUID
[0..*] C_DngrsGdsDepartureCntryLangTP _DngrsGdsDepartureCntryLang $projection.DngrsGdsUseOfRegulationUUID = _DngrsGdsDepartureCntryLang.DngrsGdsUseOfRegulationUUID

Annotations (17)

NameValueLevelField
AbapCatalog.sqlViewName CDGUORTP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Dangerous Goods Use of Regulation view
Metadata.allowExtensions true view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.preserveKey true view
ObjectModel.compositionRoot true view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #C view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY DngrsGdsUseOfRegulationUUID DngrsGdsUseOfRegulationUUID Application of Regulations
CreationDateTime CreationDateTime Timestamp
CreatedByUser CreatedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
Country Country Venue: Ctry/Reg
DngrsGoodsModeOfTransport DngrsGoodsModeOfTransport Mode of Transport
ComplianceRequirement ComplianceRequirement Compliance Requirement
_Country _Country
_DngrsGoodsModeOfTransport _DngrsGoodsModeOfTransport
_CmplRq _CmplRq
_DngrsGdsRglnCntryLang _DngrsGdsRglnCntryLang
_DngrsGdsDestCntryLang _DngrsGdsDestCntryLang
_DngrsGdsDepartureCntryLang _DngrsGdsDepartureCntryLang

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_DngrsGdsUseOfRegulationTP.
-- 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: CDGUORTP

CREATE VIEW C_DngrsGdsUseOfRegulationTP AS
SELECT
  DngrsGdsUseOfRegulationUUID,
  CreationDateTime,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser,
  Country,
  DngrsGoodsModeOfTransport,
  ComplianceRequirement
FROM I_DngrsGdsUseOfRegulationTP
LEFT OUTER JOIN C_DngrsGdsRglnCntryLangTP AS _DngrsGdsRglnCntryLang ON DngrsGdsUseOfRegulationUUID = _DngrsGdsRglnCntryLang.DngrsGdsUseOfRegulationUUID  -- association [0..*]
LEFT OUTER JOIN C_DngrsGdsDestCntryLangTP AS _DngrsGdsDestCntryLang ON DngrsGdsUseOfRegulationUUID = _DngrsGdsDestCntryLang.DngrsGdsUseOfRegulationUUID  -- association [0..*]
LEFT OUTER JOIN C_DngrsGdsDepartureCntryLangTP AS _DngrsGdsDepartureCntryLang ON DngrsGdsUseOfRegulationUUID = _DngrsGdsDepartureCntryLang.DngrsGdsUseOfRegulationUUID  -- association [0..*]
;

Learn More