I_CmplRqRsltSpillNoteTP

DDL: I_CMPLRQRSLTSPILLNOTETP SQL: ICRRARMNOTETP Type: view TRANSACTIONAL

Notes for accidental release measures

I_CmplRqRsltSpillNoteTP is a Transactional CDS View that provides data about "Notes for accidental release measures" in SAP S/4HANA. It reads from 1 data source (I_CmplRqRsltSpillNote) and exposes 7 fields. It has 1 association to related views.

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
I_CmplRqRsltSpillNote I_CmplRqRsltSpillNote from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_CmplRqRsltSpillTP _CmplRqRsltSpillTP $projection.PCPrptyRootUUID = _CmplRqRsltSpillTP.CmplRqRsltUUID

Annotations (19)

NameValueLevelField
AbapCatalog.sqlViewName ICRRARMNOTETP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Notes for accidental release measures view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.representativeKey PCPrptyNoteUUID view
ObjectModel.semanticKey PCPrptyNoteUUID view
ObjectModel.transactionalProcessingUnitRoot true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.writeActivePersistence EHFNDV_NOTES view
ObjectModel.writeDraftPersistence EHFNDW_ARM_NOTES view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (7)

KeyFieldSource TableSource FieldDescription
UUIDofNotekeyPCPrptyNoteUUID
TypeofparentPCPrptyParentType
UUIDofparentPCPrptyParentUUID
TypeofrootPCPrptyRootType
UUIDofrootPCPrptyRootUUID
NotePCPrptyNoteText
_CmplRqRsltSpillTP _CmplRqRsltSpillTP 
@AbapCatalog.sqlViewName: 'ICRRARMNOTETP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@EndUserText.label: 'Notes for accidental release measures'

@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API

@ObjectModel: {
    representativeKey: 'PCPrptyNoteUUID',
    semanticKey: 'PCPrptyNoteUUID',
    transactionalProcessingUnitRoot: true,
    createEnabled:true,
    updateEnabled:true,
    deleteEnabled:true,
    writeActivePersistence: 'EHFNDV_NOTES',
    writeDraftPersistence:  'EHFNDW_ARM_NOTES',
    usageType: {
        serviceQuality: #C,
        sizeCategory:  #L,
        dataClass: #TRANSACTIONAL
    }
}
define view I_CmplRqRsltSpillNoteTP 
    as select from I_CmplRqRsltSpillNote
    association [1..1] to I_CmplRqRsltSpillTP           as _CmplRqRsltSpillTP           on $projection.PCPrptyRootUUID = _CmplRqRsltSpillTP.CmplRqRsltUUID
{
    --UUID of Note
  @ObjectModel.mandatory: true
  key PCPrptyNoteUUID,

  --Type of parent
  @ObjectModel.mandatory: true
  PCPrptyParentType,

  --UUID of parent
  @ObjectModel.mandatory: true
  PCPrptyParentUUID, 

  --Type of root
  @ObjectModel.mandatory: true
  PCPrptyRootType,

  --UUID of root
  @ObjectModel.mandatory: true
  PCPrptyRootUUID,

  --Note
  PCPrptyNoteText,

//  /*Association*/

  @ObjectModel.association.type: [#TO_COMPOSITION_PARENT, #TO_COMPOSITION_ROOT]
  _CmplRqRsltSpillTP
  
}
where PCPrptyRootType = 'EHFNDD_CRR'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CMPLRQRSLTSPILLNOTE"
],
"ASSOCIATED":
[
"I_CMPLRQRSLTSPILLTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More