P_TW_TAXITEMTAXCODE

CDS View

TW Tax Item Tax Code

P_TW_TAXITEMTAXCODE is a CDS View in S/4HANA. TW Tax Item Tax Code. It contains 5 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 5 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_TW_AcctgDocLeadingTaxCode view_entity from COMPOSITE Accounting Document Leading Tax Code

Fields (5)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 1
KEY CompanyCode CompanyCode 1
KEY FiscalYear FiscalYear 1
KEY TaxItem TaxItem 1
TaxCodeIsLeading TaxCodeIsLeading 1 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'TW Tax Item Tax Code'
@VDM.viewType: #COMPOSITE
@VDM.private: true
define view entity P_TW_TaxItemTaxCode

  as select distinct from P_TW_LeadingTaxItem  as _TaxItem 
//    left outer join P_TW_TaxItemLeadingTaxCode as _Leading

    association[0..1] to P_TW_TaxItemLeadingTaxCode as _Leading
      on  _TaxItem.CompanyCode        = _Leading.CompanyCode 
      and  _TaxItem.FiscalYear        = _Leading.FiscalYear 
      and _TaxItem.AccountingDocument = _Leading.AccountingDocument
{
  key _TaxItem.CompanyCode          as CompanyCode,
  key _TaxItem.AccountingDocument   as AccountingDocument,
  key _TaxItem.FiscalYear           as FiscalYear,
  case
    when _Leading.TaxCodeIsLeading is null or _Leading.TaxCodeIsLeading = ''
      then _TaxItem.TaxItem 
    when _Leading.TaxCodeIsLeading = 'X'
      then _Leading.TaxItem
    end                             as TaxItem,
  _Leading.TaxCodeIsLeading         as TaxCodeIsLeading
}

Learn More