I_AE_CnsmpnTaxCtrlCode

DDL: I_AE_CNSMPNTAXCTRLCODE SQL: IAECTRLCODE Type: view BASIC Package: GLO_LOG_MENA

Consumption Tax Control Code

I_AE_CnsmpnTaxCtrlCode is a Basic CDS View that provides data about "Consumption Tax Control Code" in SAP S/4HANA. It reads from 1 data source (t604f) and exposes 4 fields with key fields CountryCode, ConsumptionTaxCtrlCode. It has 2 associations to related views. Part of development package GLO_LOG_MENA.

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
t604f t604f from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_Country _Country $projection.CountryCode = _Country.Country
[0..*] I_AE_CnsmpnTaxCtrlCodeTxt _ControlCodeText $projection.CountryCode = _ControlCodeText.CountryCode and $projection.ConsumptionTaxCtrlCode = _ControlCodeText.ConsumptionTaxCtrlCode

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName IAECTRLCODE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
EndUserText.label Consumption Tax Control Code view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.representativeKey ConsumptionTaxCtrlCode view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY CountryCode land1
KEY ConsumptionTaxCtrlCode steuc
_Country _Country
_ControlCodeText _ControlCodeText 
@AbapCatalog.sqlViewName: 'IAECTRLCODE'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #BASIC
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@EndUserText.label: 'Consumption Tax Control Code'

@ObjectModel: {

  usageType: {
    dataClass: #MIXED,
    serviceQuality: #C,
    sizeCategory: #L
    
    }
 }

@ObjectModel.representativeKey: 'ConsumptionTaxCtrlCode'
@ObjectModel.modelingPattern:           #ANALYTICAL_DIMENSION
@ObjectModel.supportedCapabilities:  [  #CDS_MODELING_DATA_SOURCE,
                                        #CDS_MODELING_ASSOCIATION_TARGET,
                                        #SQL_DATA_SOURCE,
                                        #ANALYTICAL_DIMENSION               ]
                                        
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true


define view I_AE_CnsmpnTaxCtrlCode
  as select from t604f
  association [0..1] to I_Country                 as _Country         on  $projection.CountryCode = _Country.Country
  association [0..*] to I_AE_CnsmpnTaxCtrlCodeTxt as _ControlCodeText on  $projection.CountryCode            = _ControlCodeText.CountryCode
                                                                      and $projection.ConsumptionTaxCtrlCode = _ControlCodeText.ConsumptionTaxCtrlCode

{
        @ObjectModel.foreignKey.association: '_Country'
  key   land1 as CountryCode,

        @ObjectModel.text.association: '_ControlCodeText'
  key   steuc as ConsumptionTaxCtrlCode,

        _Country, //Make association public


        _ControlCodeText //Make association public


}

Learn More