I_CmplRqRsltStorageClassTP

DDL: I_CMPLRQRSLTSTORAGECLASSTP SQL: ICRRSTCLTP Type: view TRANSACTIONAL

Storage Class

I_CmplRqRsltStorageClassTP is a Transactional CDS View that provides data about "Storage Class" in SAP S/4HANA. It reads from 1 data source (I_CmplRqRslt) and exposes 29 fields with key field CmplRqRsltUUID. It has 2 associations to related views.

1 data source(s) 29 fields

Data Sources (1)

SourceAliasJoin Type
I_CmplRqRslt I_CmplRqRslt from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_CmplRqRsltStorageClassClfnTP _CmplRqRsltStorageClassClfn $projection.CmplRqRsltUUID = _CmplRqRsltStorageClassClfn.CmplRqRsltUUID
[0..1] I_CmplRqRsltStorageClassNoteTP _CmplRqRsltStorageClassNote $projection.CmplRqRsltUUID = _CmplRqRsltStorageClassNote.PCPrptyRootUUID

Annotations (22)

NameValueLevelField
AbapCatalog.sqlViewName ICRRSTCLTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ClientHandling.algorithm #SESSION_VARIABLE 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_stor 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 StorageClassAssessment view
EndUserText.label Storage Class view

Fields (29)

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
_CmplRqRsltStorageClassClfn _CmplRqRsltStorageClassClfn
_CmplRqRsltStorageClassNote _CmplRqRsltStorageClassNote 
@AbapCatalog.sqlViewName: 'ICRRSTCLTP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl: {
  authorizationCheck: #CHECK,
  privilegedAssociations: ['_CmplRqRsltStorageClassNote']
}

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

@ObjectModel: {
  modelCategory: #BUSINESS_OBJECT,
  compositionRoot: true,
  draftEnabled: true,
  transactionalProcessingEnabled: true,
  createEnabled: true,
  updateEnabled: true,
  deleteEnabled: 'EXTERNAL_CALCULATION',
  writeDraftPersistence: 'ehfndw_crr_stor',
  writeActivePersistence: 'ehfndv_crr',
  entityChangeStateId: 'LastChangeDateTime',
  semanticKey:  [ 'CmplRqRsltUUID' ],

  usageType: {
    dataClass: #TRANSACTIONAL,
    sizeCategory: #XL,
    serviceQuality: #C
  },
  sapObjectNodeType.name: 'StorageClassAssessment'
}

@EndUserText.label: 'Storage Class'
define view I_CmplRqRsltStorageClassTP
  as select from I_CmplRqRslt
  --Child nodes
  association [0..1] to I_CmplRqRsltStorageClassClfnTP as _CmplRqRsltStorageClassClfn on $projection.CmplRqRsltUUID = _CmplRqRsltStorageClassClfn.CmplRqRsltUUID
  association [0..1] to I_CmplRqRsltStorageClassNoteTP as _CmplRqRsltStorageClassNote on $projection.CmplRqRsltUUID = _CmplRqRsltStorageClassNote.PCPrptyRootUUID

{
  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 ]
      _CmplRqRsltStorageClassClfn,

      @ObjectModel.association.type: [ #TO_COMPOSITION_CHILD ]
      _CmplRqRsltStorageClassNote
}
where
  _CmplRqVers.CmplRqPattern = 'CompliancePatternStorageClass';
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CMPLRQRSLT",
"I_CMPLRQVERSENHANCED"
],
"ASSOCIATED":
[
"I_CHMLCMPLNCINFO",
"I_CMPLRQRSLTSTORAGECLASSCLFNTP",
"I_CMPLRQRSLTSTORAGECLASSNOTETP",
"I_CMPLRQVERSENHANCED"
],
"BASE":
[
"I_CMPLRQRSLT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More