R_CmplRqRsltDynPatternDetailTP

@AbapCatalog.viewEnhancementCategory: [#NONE]
@EndUserText.label: 'Dynamic Pattern Assessment Detail - TP'

@AccessControl:
{
  authorizationCheck: #MANDATORY
}

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


@ObjectModel:
{
  usageType:
  {
    dataClass: #TRANSACTIONAL,
    sizeCategory: #L,
    serviceQuality: #C
  }
}
define view entity R_CmplRqRsltDynPatternDetailTP
  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
       CmplRqRsltComponentUUID        as CmplRqRsltComponentUUID,

       --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,

       --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,

       -- 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,

       -- 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,
       _Substance
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CMPLRQRSLTDYNPATTERNDETAIL"
],
"ASSOCIATED":
[
"I_SUBSTANCENAME",
"I_UNITOFMEASURE",
"R_CMPLRQRSLTDYNPATTERNASSMTTP"
],
"BASE":
[
"I_CMPLRQRSLTDYNPATTERNDETAIL"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/