R_ChmlCmplncIdfrTP

@EndUserText.label: 'Chemical Compliance Identifier – TP'

@AccessControl:{
  authorizationCheck: #MANDATORY,
  personalData.blocking: #REQUIRED
}
@AccessControl.privilegedAssociations:  [ '_CreatedByUser', '_LastChangedByUser' ]

@VDM:{
  viewType: #TRANSACTIONAL,
  lifecycle.contract.type: #SAP_INTERNAL_API
}

@ObjectModel: {
  semanticKey: ['ChmlCmplncIdfrUUID'],
  sapObjectNodeType.name: 'ChemicalComplianceIdentifier',
  usageType: {
    serviceQuality: #A,
    sizeCategory: #L,
    dataClass: #TRANSACTIONAL
  }
}

define root view entity R_ChmlCmplncIdfrTP
  as select from I_ChmlCmplncIdfr
  
  // Child Compositions

  composition [0..*] of R_ChmlCmplncIdfrValNameTP as _ChmlCmplncIdfrValNameTP
  composition [0..*] of R_ChmlCmplncIdfrValNmbrTP as _ChmlCmplncIdfrValNmbrTP
  composition [0..*] of R_ChmlCmplncIdfrValFmlaTP as _ChmlCmplncIdfrValFmlaTP

  // Text Associations

  association [1..*] to I_ChmlCmplncIdfrParentTypeTxt as _ChmlCmplncIdfrParentTypeTxt on $projection.ChmlCmplncIdfrParentType  = _ChmlCmplncIdfrParentTypeTxt.ChmlCmplncIdfrParentType
  association [1..*] to I_ChmlCmplncIdfrProcgStsTxt   as _ChmlCmplncIdfrProcgStsTxt   on $projection.ChmlCmplncIdfrProcgStatus = _ChmlCmplncIdfrProcgStsTxt.ChmlCmplncIdfrProcgStatus
  
--------------------------------------------------------------------------------------------------------------------
  --Information for Navigation to associated identifiers
  --------------------------------------------------------------------------------------------------------------------
  --Released Identifier
  association [0..1] to I_ChmlCmplncIdfr as _IdentifierReld on $projection.ChmlCmplncIdfrParentUUID      = _IdentifierReld.ChmlCmplncIdfrParentUUID
                                                           and $projection.ChmlCmplncIdfrParentType      = _IdentifierReld.ChmlCmplncIdfrParentType
                                                           and _IdentifierReld.ChmlCmplncIdfrProcgStatus = 'RE'
  --In Progress Identifier
  association [0..1] to I_ChmlCmplncIdfr as _IdentifierInPrgrs on $projection.ChmlCmplncIdfrParentUUID          = _IdentifierInPrgrs.ChmlCmplncIdfrParentUUID
                                                               and $projection.ChmlCmplncIdfrParentType         = _IdentifierInPrgrs.ChmlCmplncIdfrParentType
                                                               and _IdentifierInPrgrs.ChmlCmplncIdfrProcgStatus = 'IP'
{
  key ChmlCmplncIdfrUUID,
  
      // Admin fields  

      CreationUTCDateTime,
      CreatedByUser,
      LastChangeUTCDateTime,
      LastChangedByUser,
      
      // Foreign keys   

      ChmlCmplncIdfrParentID,
      ChmlCmplncIdfrParentUUID,
      ChmlCmplncIdfrParentType,

      ChmlCmplncIdfrProcgStatus,
      ChmlCmplncIdfrProcessor,
            
      ChmlCmplncIdfrReldByUser,
      ValidityStartDateTime,
      ValidityEndDateTime,
      
      /* Associations */
      _ChmlCmplncIdfrValNameTP, 
      _ChmlCmplncIdfrValNmbrTP,
      _ChmlCmplncIdfrValFmlaTP,
//      _ChmlCmplncInfo.ChmlCmplncInfoUUID,


      _ChmlCmplncIdfrParentTypeTxt,
      _ChmlCmplncIdfrProcgStsTxt,
       
      _CreatedByUser,
      _LastChangedByUser,
      _Processor,
      _ReleasedByUser,
      
      _ChmlCmplncInfo,
      _IdentifierReld,
      _IdentifierInPrgrs
}