P_NL_SAFTVATCode

DDL: P_NL_SAFTVATCODE SQL: PNLSAFTVATCODE Type: view COMPOSITE Package: GLO_FIN_IS_SAFT_NL

NL Audit File VAT Codes

P_NL_SAFTVATCode is a Composite CDS View that provides data about "NL Audit File VAT Codes" in SAP S/4HANA. It reads from 4 data sources (I_CompanyCode, I_Country, I_NL_TaxAbroadAccountDetn, I_TaxCode) and exposes 10 fields with key fields CompanyCode, TaxItemClassification, TaxCode, Country, ChartOfAccounts. Part of development package GLO_FIN_IS_SAFT_NL.

4 data source(s) 10 fields

Data Sources (4)

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

Parameters (1)

NameTypeDefault
P_CompanyCode bukrs

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PNLSAFTVATCODE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.private true view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_CompanyCode CompanyCode
KEY TaxItemClassification I_NL_TaxAbroadAccountDetn TaxItemClassification
KEY TaxCode I_TaxCode TaxCode
KEY Country I_CompanyCode Country
KEY ChartOfAccounts I_NL_TaxAbroadAccountDetn ChartOfAccounts
TaxCalculationProcedure I_TaxCode TaxCalculationProcedure
GLAccount I_NL_TaxAbroadAccountDetn GLAccount
TaxCodeName
_TaxCalculationProcedure I_TaxCode _TaxCalculationProcedure
_Country I_CompanyCode _Country 
@AbapCatalog.sqlViewName: 'PNLSAFTVATCODE'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.personalData.blocking: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MIXED
@VDM.private: true
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
define view P_NL_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_NL_TaxAbroadAccountDetn   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,

      TaxCode._TaxCalculationProcedure,
      CompanyCode._Country
}

Learn More