I_CmplRqRsltDngrsGdsBscDetsTP

DDL: I_CMPLRQRSLTDNGRSGDSBSCDETSTP Type: view TRANSACTIONAL
44 Fields 1 Data Sources 4 Associations

TP View for CR Result DG Basic Classification Details

I_CmplRqRsltDngrsGdsBscDetsTP is a Transactional CDS View that provides data about "TP View for CR Result DG Basic Classification Details" in SAP S/4HANA. It reads from 1 data source (I_CmplRqRsltDngrsGdsBscDets) and exposes 44 fields with key field CmplRqRsltDngrsGdsBscDetsUUID. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_CmplRqRsltDngrsGdsBscDets I_CmplRqRsltDngrsGdsBscDets from

Associations (4)

CardinalityTargetAliasCondition
[1..1] I_CmplRqRsltDngrsGdsBscClfnTP _CmplRqRslt $projection.CmplRqRsltUUID = _CmplRqRslt.CmplRqRsltUUID
[0..*] I_CmplRqRsltDngrsGdsSgrgtnTP _CmplRqRsltDngrsGdsSgrgtn $projection.CmplRqRsltDngrsGdsBscDetsUUID = _CmplRqRsltDngrsGdsSgrgtn.CmplRqRsltDngrsGdsBscDetsUUID
[0..*] I_CmplRqRsltSegregationCodeTP _CmplRqRsltSegregationCode $projection.CmplRqRsltDngrsGdsBscDetsUUID = _CmplRqRsltSegregationCode.CmplRqRsltDngrsGdsBscDetsUUID
[0..*] I_DngrsGdsBscClfnVesselStwgTP _DngrsGdsBscClfnVesselStwg $projection.CmplRqRsltDngrsGdsBscDetsUUID = _DngrsGdsBscClfnVesselStwg.CmplRqRsltDngrsGdsBscDetsUUID

Annotations (19)

NameValueLevelField
AbapCatalog.sqlViewName ICRRBCTDETTP view
AbapCatalog.compiler.compareFilter true view
EndUserText.label TP View for CR Result DG Basic Classification Details view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.modelCategory #BUSINESS_OBJECT view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.writeDraftPersistence ehdgmw_crr_dgb_d view
ObjectModel.writeActivePersistence ehdgmv_crr_dgb_d view
ObjectModel.representativeKey CmplRqRsltDngrsGdsBscDetsUUID view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.entityChangeStateId LastChangeDateTime view

Fields (44)

KeyFieldSource TableSource FieldDescription
KEY CmplRqRsltDngrsGdsBscDetsUUID CmplRqRsltDngrsGdsBscDetsUUID NodeID
CmplRqRsltUUID CmplRqRsltUUID SDS Assessment
CmplRqVersUUID CmplRqVersUUID NodeID
ComplianceRequirement _CmplRqRslt ComplianceRequirement Compliance Requirement
CreationDateTime CreationDateTime Timestamp
CreatedByUser CreatedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
ClassifiedAsDangerousGood ClassifiedAsDangerousGood Classified As
DangerousGoodsIdnNumber DangerousGoodsIdnNumber Number
DangerousGoodsIdnNumberType DangerousGoodsIdnNumberType Number Prefix
DangerousGoodsClass DangerousGoodsClass Class/Division
DangerousGoodsPackingGroup DangerousGoodsPackingGroup Packing Group
PackingInstruction PackingInstruction Instructions for Packer
DngrsGoodDescForDocsTmplText DngrsGoodDescForDocsTmplText Template for Descriptions for Documents
DangerousGoodsListItemVariant DangerousGoodsListItemVariant Variant
DngrsGdsQualifgWordPrefix DngrsGdsQualifgWordPrefix Prefix
DngrsGdsQualifgWordSuffix DngrsGdsQualifgWordSuffix Suffix
DngrsGdsTechName1SubstUUID DngrsGdsTechName1SubstUUID Technical Name 1
DngrsGdsTechName2SubstUUID DngrsGdsTechName2SubstUUID Technical Name 2
DngrsGdsTechName3SubstUUID DngrsGdsTechName3SubstUUID Technical Name 3
DngrsGdsTechName1PosOnSrce DngrsGdsTechName1PosOnSrce Position 1 on List
DngrsGdsTechName2PosOnSrce DngrsGdsTechName2PosOnSrce Position 2 on List
DngrsGdsTechName3PosOnSrce DngrsGdsTechName3PosOnSrce Position 3 on List
ProdIsEnvironmentalHazardous ProdIsEnvironmentalHazardous Product is Environmentally Hazardous
DngrsGdsMarnPlltnt1SubstUUID DngrsGdsMarnPlltnt1SubstUUID Marine Pollutant Name 1
DngrsGdsMarnPlltnt2SubstUUID DngrsGdsMarnPlltnt2SubstUUID Marine Pollutant Name 2
ProductIsMarinePollutant ProductIsMarinePollutant Product Is Marine Pollutant
ProductIsToxicByInhalation ProductIsToxicByInhalation Product Is Toxic by Inhalation
DngrsGdsRptblQty1SubstUUID DngrsGdsRptblQty1SubstUUID Reportable Quantity Name 1
DngrsGdsRptblQty2SubstUUID DngrsGdsRptblQty2SubstUUID Reportable Quantity Name 2
ReportableQtyIsPrintedOnDoc ReportableQtyIsPrintedOnDoc Print Reportable Quantity Names
ToxicByInhalationHazardZone ToxicByInhalationHazardZone Inhalation Hazard Zone
BasicClassfctnIsOverwritten BasicClassfctnIsOverwritten Basic Classification is Overwritten
DngrsGdsDescTmplIsOverwritten DngrsGdsDescTmplIsOverwritten Description Template is Overwritten
EnclosureVariant EnclosureVariant Enclosure Variant
SpecialProvisionOrExemptionTxt SpecialProvisionOrExemptionTxt Special Provision / Exemption
DngrsGdsIsIgnoredLblFrmRgln DngrsGdsIsIgnoredLblFrmRgln Ignore Labels from Regulation
AddlPlcdIsIgnoredLblFrmRgln AddlPlcdIsIgnoredLblFrmRgln Ignore Placards from Regulation
_CmplRqRslt _CmplRqRslt
_CmplRqRsltDngrsGdsSgrgtn _CmplRqRsltDngrsGdsSgrgtn
_CmplRqRsltSegregationCode _CmplRqRsltSegregationCode
_DngrsGdsBscClfnVesselStwg _DngrsGdsBscClfnVesselStwg
_EnclosureVariant _EnclosureVariant

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 I_CmplRqRsltDngrsGdsBscDetsTP.
-- 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 I_CmplRqRsltDngrsGdsBscDetsTP AS
SELECT
  CmplRqRsltDngrsGdsBscDetsUUID,
  CmplRqRsltUUID,
  CmplRqVersUUID,
  _CmplRqRslt.ComplianceRequirement AS ComplianceRequirement,
  CreationDateTime,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser,
  ClassifiedAsDangerousGood,
  DangerousGoodsIdnNumber,
  DangerousGoodsIdnNumberType,
  DangerousGoodsClass,
  DangerousGoodsPackingGroup,
  PackingInstruction,
  DngrsGoodDescForDocsTmplText,
  DangerousGoodsListItemVariant,
  DngrsGdsQualifgWordPrefix,
  DngrsGdsQualifgWordSuffix,
  DngrsGdsTechName1SubstUUID,
  DngrsGdsTechName2SubstUUID,
  DngrsGdsTechName3SubstUUID,
  DngrsGdsTechName1PosOnSrce,
  DngrsGdsTechName2PosOnSrce,
  DngrsGdsTechName3PosOnSrce,
  ProdIsEnvironmentalHazardous,
  DngrsGdsMarnPlltnt1SubstUUID,
  DngrsGdsMarnPlltnt2SubstUUID,
  ProductIsMarinePollutant,
  ProductIsToxicByInhalation,
  DngrsGdsRptblQty1SubstUUID,
  DngrsGdsRptblQty2SubstUUID,
  ReportableQtyIsPrintedOnDoc,
  ToxicByInhalationHazardZone,
  BasicClassfctnIsOverwritten,
  DngrsGdsDescTmplIsOverwritten,
  EnclosureVariant,
  SpecialProvisionOrExemptionTxt,
  DngrsGdsIsIgnoredLblFrmRgln,
  AddlPlcdIsIgnoredLblFrmRgln
FROM I_CmplRqRsltDngrsGdsBscDets
LEFT OUTER JOIN I_CmplRqRsltDngrsGdsBscClfnTP AS _CmplRqRslt ON CmplRqRsltUUID = _CmplRqRslt.CmplRqRsltUUID  -- association [1..1]
LEFT OUTER JOIN I_CmplRqRsltDngrsGdsSgrgtnTP AS _CmplRqRsltDngrsGdsSgrgtn ON CmplRqRsltDngrsGdsBscDetsUUID = _CmplRqRsltDngrsGdsSgrgtn.CmplRqRsltDngrsGdsBscDetsUUID  -- association [0..*]
LEFT OUTER JOIN I_CmplRqRsltSegregationCodeTP AS _CmplRqRsltSegregationCode ON CmplRqRsltDngrsGdsBscDetsUUID = _CmplRqRsltSegregationCode.CmplRqRsltDngrsGdsBscDetsUUID  -- association [0..*]
LEFT OUTER JOIN I_DngrsGdsBscClfnVesselStwgTP AS _DngrsGdsBscClfnVesselStwg ON CmplRqRsltDngrsGdsBscDetsUUID = _DngrsGdsBscClfnVesselStwg.CmplRqRsltDngrsGdsBscDetsUUID  -- association [0..*]
;

Learn More