I_SAFTVatCode

DDL: I_SAFTVATCODE SQL: ISAFTVATCODE Type: view COMPOSITE

SAFT Vat Codes

I_SAFTVatCode is a Composite CDS View that provides data about "SAFT Vat Codes" in SAP S/4HANA. It reads from 4 data sources (I_CompanyCode, I_Country, I_SAFTTaxAcctDetermination, I_TaxCode) and exposes 10 fields with key fields CompanyCode, TaxItemClassification, TaxCode, Country, ChartOfAccounts.

4 data source(s) 10 fields

Data Sources (4)

SourceAliasJoin Type
I_CompanyCode CompanyCode inner
I_Country Country inner
I_SAFTTaxAcctDetermination TaxAcctDetermination inner
I_TaxCode TaxCode from

Parameters (1)

NameTypeDefault
P_CompanyCode bukrs

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ISAFTVATCODE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label SAFT Vat Codes view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_CompanyCode CompanyCode
KEY TaxItemClassification I_SAFTTaxAcctDetermination TaxItemClassification
KEY TaxCode I_TaxCode TaxCode
KEY Country I_CompanyCode Country
KEY ChartOfAccounts I_SAFTTaxAcctDetermination ChartOfAccounts
TaxCalculationProcedure I_TaxCode TaxCalculationProcedure
GLAccount I_SAFTTaxAcctDetermination GLAccount
TaxCodeName
_TaxCalculationProcedure _TaxCalculationProcedure
_Country I_CompanyCode _Country 
@AbapCatalog.sqlViewName: 'ISAFTVATCODE'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MIXED
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'SAFT Vat Codes'
define view I_SAFTVatCode
  with parameters
    P_CompanyCode : bukrs

  as select from I_TaxCode                  as TaxCode

    inner join   I_CompanyCode              as CompanyCode          on CompanyCode.CompanyCode = $parameters.P_CompanyCode

    inner join   I_Country                  as Country              on  Country.Country                 = CompanyCode.Country
                                                                    and Country.TaxCalculationProcedure = TaxCode.TaxCalculationProcedure

    inner join   I_SAFTTaxAcctDetermination as TaxAcctDetermination on  TaxAcctDetermination.TaxCode = TaxCode.TaxCode
                                                                    and TaxAcctDetermination.ChartOfAccounts = CompanyCode.ChartOfAccounts
                                                                    and TaxAcctDetermination.Country = CompanyCode.Country
{

  key CompanyCode.CompanyCode,
  key TaxAcctDetermination.TaxItemClassification,
  key TaxCode.TaxCode,
      @ObjectModel.foreignKey.association: '_Country'
  key CompanyCode.Country,
  key TaxAcctDetermination.ChartOfAccounts,

      @ObjectModel.foreignKey.association: '_TaxCalculationProcedure'
      TaxCode.TaxCalculationProcedure,
      TaxAcctDetermination.GLAccount,
      coalesce(TaxCode._Text[1: Language = $session.system_language].TaxCodeName, '') as TaxCodeName,

      _TaxCalculationProcedure,
      CompanyCode._Country
}

Learn More