R_UnpckgdDngrsGdsClfnDrft

@EndUserText.label: 'Draft Data of Compliance Requirement Results for DG Patterns'
@VDM.viewType: #BASIC

@ObjectModel.representativeKey: 'CmplRqRsltUUID'
@AccessControl.authorizationCheck: #MANDATORY

@AbapCatalog.sqlViewName: 'RUDGCLFNRDRFT'
@AbapCatalog.compiler.compareFilter: true

@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@AbapCatalog.preserveKey:true

// Client handling by session

@ClientHandling.algorithm: #SESSION_VARIABLE

// note this view is based on a draft table

@ObjectModel.usageType:{ serviceQuality: #C,        // < 15 msec

                         sizeCategory:  #S,         // < 1.000

                         dataClass: #MIXED }

define view R_UnpckgdDngrsGdsClfnDrft
  as select from ehdgmw_crr_dgb

  association [0..*] to R_UnpckgdDngrsGdsClfnDescDrftT as _UnpckgdDngrsGdsClfnDescDrftT on $projection.CmplRqRsltUUID = _UnpckgdDngrsGdsClfnDescDrftT.ParentDraftUUID
  /*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK" ] }*/
  association [0..1] to R_UnpckgdDngrsGdsClfnDetsDrft  as _UnpckgdDngrsGdsClfnDetsDrft  on $projection.CmplRqRsltUUID = _UnpckgdDngrsGdsClfnDetsDrft.CmplRqRsltUUID
  /*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK" ] }*/
  association [0..1] to R_PaDaGdsClfnTxtBsdMoOfTrDrft  as _PaDaGdsClfnTxtBsdMoOfTrDrft  on $projection.CmplRqRsltUUID = _PaDaGdsClfnTxtBsdMoOfTrDrft.CmplRqRsltUUID
  association [1..1] to I_ChmlCmplncInfo as _ChmlCmplncInfo on $projection.ChmlCmplncInfoUUID = _ChmlCmplncInfo.ChmlCmplncInfoUUID
{
  key cmplrqrsltuuid                                                       as CmplRqRsltUUID,
      cmplrqversuuid                                                       as CmplRqVersUUID,
      chmlcmplncinfouuid                                                   as ChmlCmplncInfoUUID,
      substanceuuid                                                        as SubstanceUUID,
      chmlsuplrmatluuid                                                    as ChmlSuplrMatlUUID,
      compliancerequirement                                                as ComplianceRequirement,
      @Semantics.systemDateTime.createdAt: true
      creationdatetime                                                     as CreationDateTime,
      @Semantics.user.createdBy: true
      cast( createdbyuser as vdm_createdbyuserid preserving type )         as CreatedByUser,
      @Semantics.systemDateTime.lastChangedAt: true
      cast( lastchangedatetime as vdm_lastchangedatetime preserving type ) as LastChangeDateTime,
      @Semantics.user.lastChangedBy: true
      cast( lastchangedbyuser as vdm_lastchangedbyuserid preserving type ) as LastChangedByUser,
      cmplrqrsltprocessingstatus                                           as CmplRqRsltProcessingStatus,
      processor                                                            as Processor,
      releasedbyuser                                                       as ReleasedByUser,
      validitystartdatetime                                                as ValidityStartDateTime,
      validityenddatetime                                                  as ValidityEndDateTime,
      cmplrqrsltreldcmplncsts                                              as CmplRqRsltReldCmplncSts,
      cmplrqrsltcalculatedstatus                                           as CmplRqRsltCalculatedStatus,
      cast(cmplrqrsltmanualstatus as ehdgm_transport_permission)           as CmplRqRsltManualStatus,
      cmplrqrsltstatusremark                                               as CmplRqRsltStatusRemark,
      chmlcompositiontype                                                  as ChmlCompositionType,
      activeuuid                                                           as ActiveCmplRqRsltUUID,
      hasactiveentity                                                      as HasActiveEntity,

      _UnpckgdDngrsGdsClfnDescDrftT,
      _UnpckgdDngrsGdsClfnDetsDrft,
      _PaDaGdsClfnTxtBsdMoOfTrDrft,
      _ChmlCmplncInfo

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"EHDGMW_CRR_DGB"
],
"ASSOCIATED":
[
"I_CHMLCMPLNCINFO",
"R_PADAGDSCLFNTXTBSDMOOFTRDRFT",
"R_UNPCKGDDNGRSGDSCLFNDESCDRFTT",
"R_UNPCKGDDNGRSGDSCLFNDETSDRFT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/