I_TIMEDEPENDENTTAXSTATUS

CDS View

View to determine is Time dependent Tax is active

I_TIMEDEPENDENTTAXSTATUS is a CDS View in S/4HANA. View to determine is Time dependent Tax is active. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_CndnTypeTaxClassification view inner BASIC Condition Type Classification 
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AbapCatalog.sqlViewName: 'ITDTSTATUS'
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.usageType.dataClass:  #CUSTOMIZING
@ObjectModel.usageType.serviceQuality: #C
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'View to determine is Time dependent Tax is active'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true

define view I_TimeDependentTaxStatus 

as select from I_Country 

left outer join P_ClientBehavior   on I_Country.mandt = P_ClientBehavior.mandt

left outer join P_CloudPackage on I_Country.mandt = P_CloudPackage.mandt

left outer join  fot_tdt_actvstat    on fot_tdt_actvstat.country = I_Country.Country

{

  key I_Country.Country as Country,  
  coalesce ( activation_status, 0 ) as TimeDependentTaxActvtnStatus, 
  
  case
       when ( activation_status = 5 or activation_status = 6 ) or 
            ( activation_status = 4 and P_CloudPackage.IsCloudSystem = 'X' and P_ClientBehavior.DataIsAuditRelevant = 'X')   
            then 'X'
            else ''
  end as CountryIsTimeDependentTxActive    
}

Learn More