P_Domain_texts

@ClientHandling.algorithm: #SESSION_VARIABLE 
@AbapCatalog.sqlViewName: 'PDDTEXTS'
@VDM.viewType: #BASIC
@VDM.private: true
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
//@EndUserText.label: 'Domain text selections with type mismatches'

define view P_Domain_texts as select from dd07t as domain_texts 

{
   domain_texts.domname       as domname,
   domain_texts.ddlanguage    as ddlanguage,
   domain_texts.domvalue_l    as domain_val,
   
   case when domname = 'TPM_POSTING_CAT' 
          or domname = 'TPM_PRODUCT_GROUP'
          or domname = 'FTR_GEN_POSTING_CATEGORY'
        then cast ( cast (domain_texts.domvalue_l as abap.numc( 10 ) ) as abap.int4)
        else 0 
   end 
   as domain_val_int,

   domain_texts.ddtext        as ddtext
   
} 
where domname = 'T_SPRGRD' 
   or domname = 'TPM_TRACDOCSTATE' 
   or domname = 'TPM_TRPR_RELSTATE' 
   or domname = 'TPM_POSTING_CAT' 
   or domname = 'TPM_ACTIVE_PASSIVE_2'
   or domname = 'TPM_PRODUCT_GROUP'
   or domname = 'FTR_GEN_FIN_INSTR_PROD_GROUP' 
   or domname = 'TPM_QTY_PM_CAT'
   or domname = 'FTR_GEN_POSTING_CATEGORY'
   or domname = 'FTR_GEN_BUSINESS_TRANS_STATUS'
   or domname = 'FTR_GEN_BUS_TRANS_STATUS_FI'      
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"DD07T"
],
"ASSOCIATED":
[],
"BASE":
[],
"VERSION":0
}
}*/