P_Domain_texts

DDL: P_DOMAIN_TEXTS Type: view_entity BASIC Package: FTR_ACCOUNTING_ADAPTOR_CORE

Domain text selections with type mismatches

P_Domain_texts is a Basic CDS View that provides data about "Domain text selections with type mismatches" in SAP S/4HANA. It reads from 1 data source (dd07t) and exposes 4 fields. Part of development package FTR_ACCOUNTING_ADAPTOR_CORE.

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
dd07t domain_texts from

Annotations (3)

NameValueLevelField
VDM.viewType #BASIC view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (4)

KeyFieldSource TableSource FieldDescription
domname dd07t domname
ddlanguage dd07t ddlanguage
domain_val dd07t domvalue_l
ddtext dd07t ddtext 
@VDM.viewType: #BASIC
@VDM.private: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
//@EndUserText.label: 'Domain text selections with type mismatches'

define view entity 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_TRPRSTATE' 
   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'

Learn More