I_CnsmpnTaxControlCodeCoCode

DDL: I_CNSMPNTAXCONTROLCODECOCODE SQL: ICNTRLCODECOCODE Type: view BASIC

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 4 fields with key fields ConsumptionTaxCtrlCode, CountryCode. It has 2 associations to related views.

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
I_ConsumptionTaxControlCode CntrlCode_CoCode from

Associations (2)

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

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 (4)

KeyFieldSource TableSource FieldDescription
KEY ConsumptionTaxCtrlCode I_ConsumptionTaxControlCode ConsumptionTaxCtrlCode
KEY CountryCode I_ConsumptionTaxControlCode CountryCode
_ControlCodeCoCode _ControlCodeCoCode
_Text _Text 
@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
{
   
   key CntrlCode_CoCode.ConsumptionTaxCtrlCode as ConsumptionTaxCtrlCode,
    
   key CntrlCode_CoCode.CountryCode as CountryCode ,
    
    _ControlCodeCoCode,
    _Text
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CONSUMPTIONTAXCONTROLCODE"
],
"ASSOCIATED":
[
"I_CNSMPNTAXCONTROLCODETEXT",
"I_COMPANYCODE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More