I_ACMContrSnpshtAddlVH

@AbapCatalog.sqlViewName: 'ISNPSHTADDVH'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.dataClass: #MASTER
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Interface view for Snapshot Additional Details Value Help'
define view I_ACMContrSnpshtAddlVH
  as select from I_SnapshotPurposeStatusVH    as PurposeValueHelp
    inner join   I_ACMDfltDomainForPrps       as DomainPurpose on PurposeValueHelp.ACMSnapshotFieldPurpose = DomainPurpose.ACMSnapshotFieldPurpose
    inner join   I_CmmdtyDrvtvGenericDomainVH as DomainVH      on DomainPurpose.DomainValueName = DomainVH.SAPDataDictionaryDomain
  // as select from P_GenericDomainVH( p_domain_name: '/ACCGO/D_OUTPUT_PROC') as OutputProcessing

  //   C_SnapshotProcessingStatusVH as OutputProcessing

  //inner join   I_SnapshotPurposeStatusVH                                 as PurposeValueHelp on PurposeValueHelp.ACMSnapshotFieldPurpose = '1'

{
        @ObjectModel.readOnly: true
        @ObjectModel.filter.enabled: true
        @ObjectModel.text.element: ['ACMTrdgContrSnpshtPrpsDesc']
        @UI.hidden: false
        //key   cast( '1' as /accgo/e_snp_fld_purpose ) as Purpose,

        //key   cast( '1' as /accgo/e_snp_fld_purpose ) as ACMSnapshotFieldPurpose,

  key   PurposeValueHelp.ACMSnapshotFieldPurpose as ACMSnapshotFieldPurpose,

        @UI.textArrangement: #TEXT_LAST
        @ObjectModel.filter.enabled: false
        @ObjectModel.text.element: ['ACMTrdgContrSnpshtFldValDesc']
        @EndUserText:{label: 'Contract Document Status', quickInfo: 'Admin Field Value'}
        @UI.hidden: false
        //key   OutputProcessing.DomainValue         as Value,

        // key   OutputProcessing.DomainValue         as ACMTrdgContrSnapshotFieldValue,


  key   case PurposeValueHelp.ACMSnapshotFieldPurpose
               when '2'
                   then
                   case DomainVH.DomainValue
                       when 'X'
                           then 'Y'
                       else 'N'
                   end
               else
                   DomainVH.DomainValue
            end                                  as ACMTrdgContrSnapshotFieldValue,

        @Semantics.text: true
        @ObjectModel.filter.enabled: false
        @EndUserText:{label: 'Purpose Description', quickInfo: 'Purpose text'}
        @UI.hidden: true
        //key   PurposeValueHelp.ACMTrdgContrSnpshtPrpsDesc        as PurposeText,

  key   PurposeValueHelp.ACMTrdgContrSnpshtPrpsDesc,

        @Semantics.text: true
        @ObjectModel.filter.enabled: false
        @EndUserText:{label: 'Description', quickInfo: 'Admin Field Value text'}
        //OutputProcessing.DomainText          as ValueDescription,

        // OutputProcessing.DomainText          as ACMTrdgContrSnpshtFldValDesc


        case PurposeValueHelp.ACMSnapshotFieldPurpose
               when '2'
                   then
                   case DomainVH.DomainText
                       when 'TRUE'
                           then 'Yes'
                       else 'No'
                   end
               else
                   DomainVH.DomainText
           end                                   as ACMTrdgContrSnpshtFldValDesc

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ACMDFLTDOMAINFORPRPS",
"I_CMMDTYDRVTVGENERICDOMAINVH",
"I_SNAPSHOTPURPOSESTATUSVH"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/