R_CmplRqRsltDynPatternDet2TP

@AbapCatalog.viewEnhancementCategory: [ #NONE ]

@AccessControl.authorizationCheck: #MANDATORY

@EndUserText.label: 'Dynamic Pattern Assessment Detail 2 - TP'

@ObjectModel.sapObjectNodeType.name: 'RegulatoryDataDetail2'
@ObjectModel.usageType: { dataClass: #TRANSACTIONAL, sizeCategory: #L, serviceQuality: #C }

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

define view entity R_CmplRqRsltDynPatternDet2TP
  as select from I_CmplRqRsltDynPatternDetail

  association to parent R_CmplRqRsltDynPatternAssmtTP as _CmplRqRsltDynPatternAssmt on $projection.CmplRqRsltUUID = _CmplRqRsltDynPatternAssmt.CmplRqRsltUUID
  association [0..1] to I_SubstanceName               as _Substance                 on $projection.CmplRqRsltComponentUUID = _Substance.SubstanceUUID

{
      -- UUID of Substance Assingment
  key CmplRqRsltDynPatternDetailUUID as CmplRqRsltDynPatternDetailUUID,

      -- CmplRqRsltUUID
      CmplRqRsltUUID                 as CmplRqRsltUUID,

      -- Component UUID
      @ObjectModel.foreignKey.association: '_Substance'
      CmplRqRsltComponentUUID        as CmplRqRsltComponentUUID,

      -- Section
      CmplRqRsltSection              as CmplRqRsltSection,

      -- Value 1
      CmplRqRsltLowrValue1Optr       as CmplRqRsltLowrValue1Optr,
      CmplRqRsltLowrValue1           as CmplRqRsltLowrValue1,
      CmplRqRsltLowrValue1Txt        as CmplRqRsltLowrValue1Txt,
      CmplRqRsltUprValue1Optr        as CmplRqRsltUprValue1Optr,
      CmplRqRsltUprValue1            as CmplRqRsltUprValue1,
      CmplRqRsltUprValue1Txt         as CmplRqRsltUprValue1Txt,

      -- Value 2
      CmplRqRsltLowrValue2Optr       as CmplRqRsltLowrValue2Optr,
      CmplRqRsltLowrValue2           as CmplRqRsltLowrValue2,
      CmplRqRsltLowrValue2Txt        as CmplRqRsltLowrValue2Txt,
      CmplRqRsltUprValue2Optr        as CmplRqRsltUprValue2Optr,
      CmplRqRsltUprValue2            as CmplRqRsltUprValue2,
      CmplRqRsltUprValue2Txt         as CmplRqRsltUprValue2Txt,

      -- Value 3
      CmplRqRsltLowrValue3Optr       as CmplRqRsltLowrValue3Optr,
      CmplRqRsltLowrValue3           as CmplRqRsltLowrValue3,
      CmplRqRsltLowrValue3Txt        as CmplRqRsltLowrValue3Txt,
      CmplRqRsltUprValue3Optr        as CmplRqRsltUprValue3Optr,
      CmplRqRsltUprValue3            as CmplRqRsltUprValue3,
      CmplRqRsltUprValue3Txt         as CmplRqRsltUprValue3Txt,

      -- Value 4
      CmplRqRsltLowrValue4Optr       as CmplRqRsltLowrValue4Optr,
      CmplRqRsltLowrValue4           as CmplRqRsltLowrValue4,
      CmplRqRsltLowrValue4Txt        as CmplRqRsltLowrValue4Txt,
      CmplRqRsltUprValue4Optr        as CmplRqRsltUprValue4Optr,
      CmplRqRsltUprValue4            as CmplRqRsltUprValue4,
      CmplRqRsltUprValue4Txt         as CmplRqRsltUprValue4Txt,

      -- Value 5
      CmplRqRsltLowrValue5Optr       as CmplRqRsltLowrValue5Optr,
      CmplRqRsltLowrValue5           as CmplRqRsltLowrValue5,
      CmplRqRsltLowrValue5Txt        as CmplRqRsltLowrValue5Txt,
      CmplRqRsltUprValue5Optr        as CmplRqRsltUprValue5Optr,
      CmplRqRsltUprValue5            as CmplRqRsltUprValue5,
      CmplRqRsltUprValue5Txt         as CmplRqRsltUprValue5Txt,

      -- Value 6
      CmplRqRsltLowrValue6Optr       as CmplRqRsltLowrValue6Optr,
      CmplRqRsltLowrValue6           as CmplRqRsltLowrValue6,
      CmplRqRsltLowrValue6Txt        as CmplRqRsltLowrValue6Txt,
      CmplRqRsltUprValue6Optr        as CmplRqRsltUprValue6Optr,
      CmplRqRsltUprValue6            as CmplRqRsltUprValue6,
      CmplRqRsltUprValue6Txt         as CmplRqRsltUprValue6Txt,


      -- Quantity 1
      CmplRqRsltLowrQty1Optr         as CmplRqRsltLowrQty1Optr,
      CmplRqRsltLowrQty1             as CmplRqRsltLowrQty1,
      CmplRqRsltLowrQty1Txt          as CmplRqRsltLowrQty1Txt,
      CmplRqRsltUprQty1Optr          as CmplRqRsltUprQty1Optr,
      CmplRqRsltUprQty1              as CmplRqRsltUprQty1,
      CmplRqRsltUprQty1Txt           as CmplRqRsltUprQty1Txt,
      CmplRqRsltQty1UoM              as CmplRqRsltQty1UoM,

      -- Quantity 2
      CmplRqRsltLowrQty2Optr         as CmplRqRsltLowrQty2Optr,
      CmplRqRsltLowrQty2             as CmplRqRsltLowrQty2,
      CmplRqRsltLowrQty2Txt          as CmplRqRsltLowrQty2Txt,
      CmplRqRsltUprQty2Optr          as CmplRqRsltUprQty2Optr,
      CmplRqRsltUprQty2              as CmplRqRsltUprQty2,
      CmplRqRsltUprQty2Txt           as CmplRqRsltUprQty2Txt,
      CmplRqRsltQty2UoM              as CmplRqRsltQty2UoM,

      -- Quantity 3
      CmplRqRsltLowrQty3Optr         as CmplRqRsltLowrQty3Optr,
      CmplRqRsltLowrQty3             as CmplRqRsltLowrQty3,
      CmplRqRsltLowrQty3Txt          as CmplRqRsltLowrQty3Txt,
      CmplRqRsltUprQty3Optr          as CmplRqRsltUprQty3Optr,
      CmplRqRsltUprQty3              as CmplRqRsltUprQty3,
      CmplRqRsltUprQty3Txt           as CmplRqRsltUprQty3Txt,
      CmplRqRsltQty3UoM              as CmplRqRsltQty3UoM,

      -- Quantity 4
      CmplRqRsltLowrQty4Optr         as CmplRqRsltLowrQty4Optr,
      CmplRqRsltLowrQty4             as CmplRqRsltLowrQty4,
      CmplRqRsltLowrQty4Txt          as CmplRqRsltLowrQty4Txt,
      CmplRqRsltUprQty4Optr          as CmplRqRsltUprQty4Optr,
      CmplRqRsltUprQty4              as CmplRqRsltUprQty4,
      CmplRqRsltUprQty4Txt           as CmplRqRsltUprQty4Txt,
      CmplRqRsltQty4UoM              as CmplRqRsltQty4UoM,

      -- Quantity 5
      CmplRqRsltLowrQty5Optr         as CmplRqRsltLowrQty5Optr,
      CmplRqRsltLowrQty5             as CmplRqRsltLowrQty5,
      CmplRqRsltLowrQty5Txt          as CmplRqRsltLowrQty5Txt,
      CmplRqRsltUprQty5Optr          as CmplRqRsltUprQty5Optr,
      CmplRqRsltUprQty5              as CmplRqRsltUprQty5,
      CmplRqRsltUprQty5Txt           as CmplRqRsltUprQty5Txt,
      CmplRqRsltQty5UoM              as CmplRqRsltQty5UoM,

      -- Phrases
      CmplRqRsltPhrase1UUID          as CmplRqRsltPhrase1UUID,
      CmplRqRsltPhrase2UUID          as CmplRqRsltPhrase2UUID,
      CmplRqRsltPhrase3UUID          as CmplRqRsltPhrase3UUID,
      CmplRqRsltPhrase4UUID          as CmplRqRsltPhrase4UUID,

      -- Multi Phrases
      CmplRqRsltMultiPhrase11UUID    as CmplRqRsltMultiPhrase11UUID,
      CmplRqRsltMultiPhrase12UUID    as CmplRqRsltMultiPhrase12UUID,
      CmplRqRsltMultiPhrase13UUID    as CmplRqRsltMultiPhrase13UUID,
      CmplRqRsltMultiPhrase21UUID    as CmplRqRsltMultiPhrase21UUID,
      CmplRqRsltMultiPhrase22UUID    as CmplRqRsltMultiPhrase22UUID,
      CmplRqRsltMultiPhrase23UUID    as CmplRqRsltMultiPhrase23UUID,
      CmplRqRsltMultiPhrase31UUID    as CmplRqRsltMultiPhrase31UUID,
      CmplRqRsltMultiPhrase32UUID    as CmplRqRsltMultiPhrase32UUID,
      CmplRqRsltMultiPhrase33UUID    as CmplRqRsltMultiPhrase33UUID,
      -- Text
      CmplRqRsltText1                as CmplRqRsltText1,

      -- Create at date/time and by user
      CreationDateTime               as CreationDateTime,
      CreatedByUser                  as CreatedByUser,

      -- Update at date/time and by user
      LastChangeDateTime             as LastChangeDateTime,
      LastChangedByUser              as LastChangedByUser,

      /* Associations */
      _CmplRqRsltDynPatternAssmt,
      _UnitOfMeasureQty1,
      _UnitOfMeasureQty2,
      _UnitOfMeasureQty3,
      _UnitOfMeasureQty4,
      _UnitOfMeasureQty5,      
      _Substance
}

where CmplRqRsltSection = '2'