I_CnsmpnTaxControlCodeCoCode

DDL: I_CNSMPNTAXCONTROLCODECOCODE SQL: ICNTRLCODECOCODE Type: view BASIC Package: GLO_LOG_IN

Interface view for Company Code based ControlCode

I_CnsmpnTaxControlCodeCoCode is a Basic CDS View (Dimension) that provides data about "Interface view for Company Code based ControlCode" in SAP S/4HANA. It reads from 1 data source (I_ConsumptionTaxControlCode) and exposes 5 fields with key fields ConsumptionTaxCtrlCode, CountryCode. It has 3 associations to related views. Part of development package GLO_LOG_IN.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
I_ConsumptionTaxControlCode CntrlCode_CoCode from

Associations (3)

CardinalityTargetAliasCondition
[1..*] I_CompanyCode _ControlCodeCoCode $projection.CountryCode = _ControlCodeCoCode.Country
[0..*] I_CnsmpnTaxControlCodeText _Text $projection.ConsumptionTaxCtrlCode = _Text.ConsumptionTaxCtrlCode and $projection.CountryCode = _Text.CountryCode
[0..1] I_Country _Country $projection.CountryCode = _Country.Country

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ICNTRLCODECOCODE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Interface view for Company Code based ControlCode view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY ConsumptionTaxCtrlCode I_ConsumptionTaxControlCode ConsumptionTaxCtrlCode
KEY CountryCode I_ConsumptionTaxControlCode CountryCode
_ControlCodeCoCode _ControlCodeCoCode
_Text _Text
_Country _Country 
@AbapCatalog.sqlViewName: 'ICNTRLCODECOCODE'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Interface view for Company Code based ControlCode' 
@Analytics: { dataCategory: #DIMENSION, dataExtraction.enabled: true }
@VDM.viewType: #BASIC
@ObjectModel.representativeKey: [ 'ConsumptionTaxCtrlCode', 'CountryCode']
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory : #S
@ObjectModel.usageType.dataClass: #MIXED
define view I_CnsmpnTaxControlCodeCoCode as 
 select from I_ConsumptionTaxControlCode as CntrlCode_CoCode 
 association [1..*] to I_CompanyCode as _ControlCodeCoCode on  $projection.CountryCode = _ControlCodeCoCode.Country
 association [0..*] to I_CnsmpnTaxControlCodeText as _Text on $projection.ConsumptionTaxCtrlCode = _Text.ConsumptionTaxCtrlCode
                                                        and  $projection.CountryCode = _Text.CountryCode
 association [0..1] to I_Country              as _Country     on  $projection.CountryCode = _Country.Country                                                        
{
   
   key CntrlCode_CoCode.ConsumptionTaxCtrlCode as ConsumptionTaxCtrlCode, 
   @ObjectModel.foreignKey.association:'_Country'   
   key CntrlCode_CoCode.CountryCode as CountryCode ,
    
    _ControlCodeCoCode,
    _Text,
    _Country
}

Learn More