I_TimeDependentTaxStatus

DDL: I_TIMEDEPENDENTTAXSTATUS SQL: ITDTSTATUS Type: view BASIC

View to determine is Time dependent Tax is active

I_TimeDependentTaxStatus is a Basic CDS View that provides data about "View to determine is Time dependent Tax is active" in SAP S/4HANA. It reads from 4 data sources (fot_tdt_actvstat, I_Country, P_ClientBehavior, P_CloudPackage) and exposes 2 fields with key field Country.

4 data source(s) 2 fields

Data Sources (4)

SourceAliasJoin Type
fot_tdt_actvstat fot_tdt_actvstat left_outer
I_Country I_Country from
P_ClientBehavior P_ClientBehavior left_outer
P_CloudPackage P_CloudPackage left_outer

Annotations (10)

NameValueLevelField
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName ITDTSTATUS view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #C view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label View to determine is Time dependent Tax is active view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY Country I_Country Country
TimeDependentTaxActvtnStatus 
@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    
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_COUNTRY",
"P_CLIENTBEHAVIOR",
"P_CLOUDPACKAGE",
"FOT_TDT_ACTVSTAT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More