I_CmplRqRsltHzdsClfnTP

DDL: I_CMPLRQRSLTHZDSCLFNTP SQL: ICRRSARATP Type: view TRANSACTIONAL

SARA Classification

I_CmplRqRsltHzdsClfnTP is a Transactional CDS View that provides data about "SARA Classification" in SAP S/4HANA. It reads from 1 data source (I_CmplRqRslt) and exposes 30 fields with key field CmplRqRsltUUID. It has 3 associations to related views.

1 data source(s) 30 fields

Data Sources (1)

SourceAliasJoin Type
I_CmplRqRslt I_CmplRqRslt from

Associations (3)

CardinalityTargetAliasCondition
[0..*] I_CmplRqRsltHzdsClfnCatTP _CmplRqRsltHzdsClfnCat $projection.CmplRqRsltUUID = _CmplRqRsltHzdsClfnCat.CmplRqRsltUUID
[0..1] I_CmplRqRsltHzdsClfnNoteTP _CmplRqRsltHzdsClfnNote $projection.CmplRqRsltUUID = _CmplRqRsltHzdsClfnNote.PCPrptyRootUUID
[0..1] I_CmplRqRsltHzdsClfnAssmtTP _CmplRqRsltHzdsClfnAssmt $projection.CmplRqRsltUUID = _CmplRqRsltHzdsClfnAssmt.CmplRqRsltUUID

Annotations (22)

NameValueLevelField
AbapCatalog.sqlViewName ICRRSARATP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.modelCategory #BUSINESS_OBJECT view
ObjectModel.compositionRoot true view
ObjectModel.draftEnabled true view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled EXTERNAL_CALCULATION view
ObjectModel.writeDraftPersistence ehfndw_crr_sara view
ObjectModel.writeActivePersistence ehfndv_crr view
ObjectModel.entityChangeStateId LastChangeDateTime view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.sapObjectNodeType.name SARAHzdClassfctnAssessment view
EndUserText.label SARA Classification view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY CmplRqRsltUUID CmplRqRsltUUID
ActiveCmplRqRsltUUID CmplRqRsltUUID
ActiveUUIDofCRRCmplRqVersUUID
ChmlCmplncInfoUUID ChmlCmplncInfoUUID
SubstanceUUID SubstanceUUID
ChmlSuplrMatlUUID ChmlSuplrMatlUUID
ComplianceRequirement ComplianceRequirement
CreationDateTime CreationDateTime
CreatedByUser CreatedByUser
LastChangeDateTime LastChangeDateTime
LastChangedByUser LastChangedByUser
CmplRqRsltProcessingStatus CmplRqRsltProcessingStatus
Processor Processor
ReleasedByUser ReleasedByUser
ValidityStartDateTime ValidityStartDateTime
ValidityEndDateTime ValidityEndDateTime
CmplRqRsltReldCmplncSts CmplRqRsltReldCmplncSts
CmplRqRsltCalculatedStatus CmplRqRsltCalculatedStatus
CmplRqRsltManualStatus CmplRqRsltManualStatus
CmplRqRsltStatusRemark CmplRqRsltStatusRemark
ChmlCompositionType ChmlCompositionType
MaterialIsSold MaterialIsSold
MaterialIsTransported MaterialIsTransported
MaterialIsSourced MaterialIsSourced
MaterialIsProduced MaterialIsProduced
_ChmlCmplncInfo _ChmlCmplncInfo
_CmplRqVers _CmplRqVers
_CmplRqRsltHzdsClfnCat _CmplRqRsltHzdsClfnCat
_CmplRqRsltHzdsClfnNote _CmplRqRsltHzdsClfnNote
_CmplRqRsltHzdsClfnAssmt _CmplRqRsltHzdsClfnAssmt 
@AbapCatalog.sqlViewName: 'ICRRSARATP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl:{
    authorizationCheck: #CHECK,
    privilegedAssociations: ['_CmplRqRsltHzdsClfnNote']
}

@VDM.viewType: #TRANSACTIONAL
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.lifecycle.contract.type:#SAP_INTERNAL_API

@ObjectModel: {
  modelCategory: #BUSINESS_OBJECT,
  compositionRoot: true,
  draftEnabled: true,
  transactionalProcessingEnabled: true,
  createEnabled: true,
  updateEnabled: true,
  deleteEnabled: 'EXTERNAL_CALCULATION',
  writeDraftPersistence: 'ehfndw_crr_sara',
  writeActivePersistence: 'ehfndv_crr',
  semanticKey:  [ 'CmplRqRsltUUID' ],
  entityChangeStateId: 'LastChangeDateTime',
  usageType: {
    dataClass: #TRANSACTIONAL,
    sizeCategory: #XL,
    serviceQuality: #C
  },
  sapObjectNodeType.name: 'SARAHzdClassfctnAssessment'
}

@EndUserText.label: 'SARA Classification'
define view I_CmplRqRsltHzdsClfnTP
  as select from I_CmplRqRslt

  association [0..*] to I_CmplRqRsltHzdsClfnCatTP as _CmplRqRsltHzdsClfnCat on $projection.CmplRqRsltUUID = _CmplRqRsltHzdsClfnCat.CmplRqRsltUUID
  association [0..1] to I_CmplRqRsltHzdsClfnNoteTP   as _CmplRqRsltHzdsClfnNote   on $projection.CmplRqRsltUUID = _CmplRqRsltHzdsClfnNote.PCPrptyRootUUID  
  association [0..1] to I_CmplRqRsltHzdsClfnAssmtTP   as _CmplRqRsltHzdsClfnAssmt   on $projection.CmplRqRsltUUID = _CmplRqRsltHzdsClfnAssmt.CmplRqRsltUUID  

{
  key CmplRqRsltUUID,
      @ObjectModel.readOnly: true
      CmplRqRsltUUID as ActiveCmplRqRsltUUID, --Active UUID of CRR
      CmplRqVersUUID,
      ChmlCmplncInfoUUID,
      SubstanceUUID,
      ChmlSuplrMatlUUID,
      ComplianceRequirement,
      CreationDateTime,
      CreatedByUser,
      LastChangeDateTime,
      LastChangedByUser,
      CmplRqRsltProcessingStatus,
      Processor,
      ReleasedByUser,
      ValidityStartDateTime,
      ValidityEndDateTime,
      CmplRqRsltReldCmplncSts,
      CmplRqRsltCalculatedStatus,
      CmplRqRsltManualStatus,
      CmplRqRsltStatusRemark,
      ChmlCompositionType,
      MaterialIsSold,
      MaterialIsTransported,
      MaterialIsSourced,
      MaterialIsProduced,

      /**** Associations ****/
      _ChmlCmplncInfo,
      _CmplRqVers,

      @ObjectModel.association.type: [ #TO_COMPOSITION_CHILD ]
      _CmplRqRsltHzdsClfnCat,
      @ObjectModel.association.type: [ #TO_COMPOSITION_CHILD ]
      _CmplRqRsltHzdsClfnNote,
      @ObjectModel.association.type: [ #TO_COMPOSITION_CHILD ]
      _CmplRqRsltHzdsClfnAssmt      
}
where
  _CmplRqVers.CmplRqPattern = 'CompliancePatternHazardClass';
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CMPLRQRSLT",
"I_CMPLRQVERSENHANCED"
],
"ASSOCIATED":
[
"I_CHMLCMPLNCINFO",
"I_CMPLRQRSLTHZDSCLFNASSMTTP",
"I_CMPLRQRSLTHZDSCLFNCATTP",
"I_CMPLRQRSLTHZDSCLFNNOTETP",
"I_CMPLRQVERSENHANCED"
],
"BASE":
[
"I_CMPLRQRSLT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More