I_CN_GoldenTaxCustomerTypeDetn

DDL: I_CN_GOLDENTAXCUSTOMERTYPEDETN Type: view COMPOSITE Package: GLO_FIN_TAX_GTI_CN

Golden Tax Customer Type Determination

I_CN_GoldenTaxCustomerTypeDetn is a Composite CDS View that provides data about "Golden Tax Customer Type Determination" in SAP S/4HANA. It reads from 1 data source (I_Customer) and exposes 16 fields with key field Customer. It has 1 association to related views. Part of development package GLO_FIN_TAX_GTI_CN.

1 data source(s) 16 fields

Data Sources (1)

SourceAliasJoin Type
I_Customer _Customer from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_CN_GoldenTaxPersonalSetting _GTPersonalSetting _GTPersonalSetting.UserID = $session.user

Annotations (11)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
AbapCatalog.sqlViewName ICNGTCUSTTPDET view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Golden Tax Customer Type Determination view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY Customer I_Customer Customer
CN_GldnTxElectronicInvcIsSuppd _GTCustomerType CN_GldnTxElectronicInvcIsSuppd
IsBusinessPurposeCompleted I_Customer IsBusinessPurposeCompleted
AuthorizationGroup I_Customer AuthorizationGroup
CustomerAccountGroup I_Customer CustomerAccountGroup
DataControllerSet I_Customer DataControllerSet
DataController1 I_Customer DataController1
DataController2 I_Customer DataController2
DataController3 I_Customer DataController3
DataController4 I_Customer DataController4
DataController5 I_Customer DataController5
DataController6 I_Customer DataController6
DataController7 I_Customer DataController7
DataController8 I_Customer DataController8
DataController9 I_Customer DataController9
DataController10 I_Customer DataController10 
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #REQUIRED
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #D,
  sizeCategory: #S,
  dataClass: #MIXED
}
@ObjectModel.semanticKey: ['Customer']
@VDM: {
  viewType:#COMPOSITE
}
@AbapCatalog: {
  sqlViewName: 'ICNGTCUSTTPDET',
  compiler.compareFilter: true,
  viewEnhancementCategory: [#NONE]
}
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
@EndUserText.label: 'Golden Tax Customer Type Determination'
define view I_CN_GoldenTaxCustomerTypeDetn 
as select from I_Customer as _Customer
left outer to one join I_CN_GoldenTaxCustomerType as _GTCustomerType
 on _Customer.Customer = _GTCustomerType.Customer
association [0..1] to I_CN_GoldenTaxPersonalSetting as _GTPersonalSetting
 on _GTPersonalSetting.UserID = $session.user
{
  key _Customer.Customer,
  case
    when _GTCustomerType.Customer is null
      then 
        case
          when _GTPersonalSetting.UserID is null
            or _GTPersonalSetting._GTInvcKey.CN_GoldenTaxCustomerType is null
            then 
              cast( '1' as gtdcustyp )
          else
            _GTPersonalSetting._GTInvcKey.CN_GoldenTaxCustomerType
          end
    else
      _GTCustomerType.CN_GoldenTaxCustomerType
  end as CN_GoldenTaxCustomerType,
  @Semantics.booleanIndicator: true
  _GTCustomerType.CN_GldnTxElectronicInvcIsSuppd,
  
  @Semantics.booleanIndicator:true
  _Customer.IsBusinessPurposeCompleted,
  _Customer.AuthorizationGroup,
  _Customer.CustomerAccountGroup,
  _Customer.DataControllerSet,
  _Customer.DataController1,
  _Customer.DataController2,
  _Customer.DataController3,
  _Customer.DataController4,
  _Customer.DataController5,
  _Customer.DataController6,
  _Customer.DataController7,
  _Customer.DataController8,
  _Customer.DataController9,
  _Customer.DataController10
}

Learn More