I_AccountType

DDL: I_ACCOUNTTYPE SQL: IMDACCOUNTTYPE Type: view BASIC

Account Tax Type

I_AccountType is a Basic CDS View that provides data about "Account Tax Type" in SAP S/4HANA. It reads from 3 data sources (j_1afitp, j_1afitpv, j_1afitpvt) and exposes 4 fields with key fields AccountType, AccountTaxType, AccountTaxTypeDescriptionLang.

3 data source(s) 4 fields

Data Sources (3)

SourceAliasJoin Type
j_1afitp alias_j_1afitp from
j_1afitpv J_1AFITPV left_outer
j_1afitpvt J_1AFITPVT left_outer

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IMDACCOUNTTYPE view
EndUserText.label Account Tax Type view
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.dataCategory #TEXT view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
Search.searchable true view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY AccountType j_1afitp koart
KEY AccountTaxType j_1afitp j_1afitp
KEY AccountTaxTypeDescriptionLang j_1afitpvt spras
AccountTaxTypeDescription j_1afitpvt text60 
@AbapCatalog.sqlViewName: 'IMDACCOUNTTYPE'
@EndUserText.label: 'Account Tax Type'
@VDM.viewType: #BASIC
@ObjectModel.usageType.dataClass: #CUSTOMIZING
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.dataCategory: #TEXT
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Search.searchable: true

define view I_AccountType
  as select from    j_1afitp   as alias_j_1afitp
    left outer join j_1afitpv  as J_1AFITPV  on J_1AFITPV.j_1afitp = alias_j_1afitp.j_1afitp
    left outer join j_1afitpvt as J_1AFITPVT on J_1AFITPVT.j_1afitp = J_1AFITPV.j_1afitp
{
      @EndUserText:{
        label: 'Account Type',
        quickInfo: 'Account Type'
      }
  key alias_j_1afitp.koart    as AccountType,
      @EndUserText:{
        label: 'Account Tax Type',
        quickInfo: 'Account Tax Type'
      }
  key alias_j_1afitp.j_1afitp as AccountTaxType,
      @Semantics.language: true
  key J_1AFITPVT.spras        as AccountTaxTypeDescriptionLang,
      @Search.defaultSearchElement: true
      @Semantics.text: true
      @EndUserText:{
        label: 'Account Tax Type Description',
        quickInfo: 'Account Tax Type Description'
      }
      J_1AFITPVT.text60       as AccountTaxTypeDescription
}

Learn More