I_GLAccountToleranceGroup

DDL: I_GLACCOUNTTOLERANCEGROUP SQL: IFIGLTOLEGRP Type: view BASIC

Tolerance Group for G/L Account

I_GLAccountToleranceGroup is a Basic CDS View (Dimension) that provides data about "Tolerance Group for G/L Account" in SAP S/4HANA. It reads from 1 data source (t043s) and exposes 10 fields with key fields CompanyCode, APARToleranceGroup. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
t043s t043s from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode
[0..*] I_GLAccountToleranceGroupText _Text $projection.CompanyCode = _Text.CompanyCode and $projection.APARToleranceGroup = _Text.APARToleranceGroup
[0..1] I_Currency _Currency $projection.currency = _Currency.Currency

Annotations (12)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #BASIC view
EndUserText.label Tolerance Group for G/L Account view
Analytics.dataCategory #DIMENSION view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.sqlViewName IFIGLTOLEGRP view
ObjectModel.representativeKey APARToleranceGroup view
Metadata.allowExtensions true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode bukrs
KEY APARToleranceGroup togru
MaxRevnClrgDiffAmtInCoCodeCrcy betrs
MaxExpnClrgDiffAmtInCoCodeCrcy betrh
MaxRevnClrgDifferencePercent prozs
MaxExpnClrgDifferencePercent prozh
Currency _CompanyCode Currency
_CompanyCode _CompanyCode
_Currency _Currency
_Text _Text
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@VDM.viewType: #BASIC
@EndUserText.label: 'Tolerance Group for G/L Account'
@Analytics.dataCategory: #DIMENSION
@AccessControl.authorizationCheck: #CHECK
@AbapCatalog.sqlViewName: 'IFIGLTOLEGRP'
@ObjectModel.representativeKey: 'APARToleranceGroup'
@Metadata.allowExtensions:true
@ObjectModel.usageType: {
  serviceQuality: #A,
  sizeCategory: #S,
  dataClass: #MASTER
}

define view I_GLAccountToleranceGroup
  as select from t043s
  association [0..1] to I_CompanyCode                 as _CompanyCode on  $projection.CompanyCode = _CompanyCode.CompanyCode
  association [0..*] to I_GLAccountToleranceGroupText as _Text        on  $projection.CompanyCode        = _Text.CompanyCode
                                                                      and $projection.APARToleranceGroup = _Text.APARToleranceGroup
  association [0..1] to I_Currency                    as _Currency    on  $projection.currency = _Currency.Currency
{
      //--[ GENERATED:012:29JlHNUf7jY4ip0dSlCN8W

      @Consumption.valueHelpDefinition: [ 
        { entity:  { name:    'I_CompanyCodeStdVH',
                     element: 'CompanyCode' }
        }]
      // ]--GENERATED

      @ObjectModel.foreignKey.association: '_CompanyCode'
  key bukrs as CompanyCode,
      @ObjectModel.text.association: '_Text'
  key togru as APARToleranceGroup,

      @DefaultAggregation: #NONE
      @Semantics.amount.currencyCode: 'Currency'
      betrs as MaxRevnClrgDiffAmtInCoCodeCrcy,
      @DefaultAggregation: #NONE
      @Semantics.amount.currencyCode: 'Currency'
      betrh as MaxExpnClrgDiffAmtInCoCodeCrcy,

      prozs as MaxRevnClrgDifferencePercent,
      prozh as MaxExpnClrgDifferencePercent,

      @ObjectModel.foreignKey.association: '_Currency'
      @Semantics.currencyCode: true
      _CompanyCode.Currency,

      _CompanyCode,
      _Currency,
      _Text
}    
 
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_COMPANYCODE",
"T043S"
],
"ASSOCIATED":
[
"I_COMPANYCODE",
"I_CURRENCY",
"I_GLACCOUNTTOLERANCEGROUPTEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/