I_RECostElementGLAcctAssgmt

DDL: I_RECOSTELEMENTGLACCTASSGMT SQL: IRECEGLACCTASS Type: view_entity BASIC

RE Cost Settlmt Cost Element GL Account Assignment

I_RECostElementGLAcctAssgmt is a Basic CDS View (Dimension) that provides data about "RE Cost Settlmt Cost Element GL Account Assignment" in SAP S/4HANA. It reads from 2 data sources (t001, tivcsceglaccass) and exposes 8 fields with key fields ChartOfAccounts, CompanyCode, GLAccount, RECostCategory. It has 4 associations to related views.

2 data source(s) 8 fields

Data Sources (2)

SourceAliasJoin Type
t001 t001 inner
tivcsceglaccass tivcsceglaccass from

Associations (4)

CardinalityTargetAliasCondition
[1..1] I_ChartOfAccounts _ChartOfAccounts $projection.ChartOfAccounts = _ChartOfAccounts.ChartOfAccounts
[1..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode
[0..1] I_RECostCategory _RECostCategory $projection.RECostCategory = _RECostCategory.RECostCategory
[1..1] I_GLAccount _GLAccount ( $projection.CompanyCode = _GLAccount.CompanyCode and $projection.GLAccount = _GLAccount.GLAccount and $projection.ChartOfAccounts = _GLAccount.ChartOfAccounts )

Annotations (12)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label RE Cost Settlmt Cost Element GL Account Assignment view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.representativeKey GLAccount view
VDM.viewType #BASIC view
Search.searchable true view
Metadata.ignorePropagatedAnnotations true view
Analytics.dataCategory #DIMENSION view
Analytics.internalName #LOCAL view
Analytics.dataExtraction.enabled true view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY ChartOfAccounts tivcsceglaccass ktopl
KEY CompanyCode t001 bukrs
KEY GLAccount tivcsceglaccass saknr
KEY RECostCategory tivcsceglaccass costcategory
_ChartOfAccounts _ChartOfAccounts
_CompanyCode _CompanyCode
_RECostCategory _RECostCategory
_GLAccount _GLAccount 
//@AbapCatalog.sqlViewName: 'IRECEGLACCTASS'

@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'RE Cost Settlmt Cost Element GL Account Assignment'
@ObjectModel.usageType.dataClass: #CUSTOMIZING
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.representativeKey: 'GLAccount'
@ObjectModel.semanticKey: ['ChartOfAccounts', 'CompanyCode','GLAccount','RECostCategory' ]
//@ClientDependent: true

@VDM.viewType: #BASIC
@Search.searchable: true

@Metadata.ignorePropagatedAnnotations: true

@ObjectModel.supportedCapabilities:  [  #ANALYTICAL_DIMENSION,
                                        #CDS_MODELING_ASSOCIATION_TARGET,
                                        #SQL_DATA_SOURCE,
                                        #CDS_MODELING_DATA_SOURCE,
                                        #EXTRACTION_DATA_SOURCE,
                                        #SEARCHABLE_ENTITY      ]

@Analytics:{
    dataCategory: #DIMENSION,
    internalName: #LOCAL,
    dataExtraction: {
        enabled: true
    }
}
define view entity I_RECostElementGLAcctAssgmt
  as select from tivcsceglaccass
    inner join t001 on tivcsceglaccass.ktopl   = t001.ktopl
                      and(
                        tivcsceglaccass.bukrs    = t001.bukrs
                        or tivcsceglaccass.bukrs = ''
                      )
  association [1..1] to I_ChartOfAccounts as _ChartOfAccounts on $projection.ChartOfAccounts = _ChartOfAccounts.ChartOfAccounts
  association [1..1] to I_CompanyCode     as _CompanyCode     on $projection.CompanyCode = _CompanyCode.CompanyCode
  association [0..1] to I_RECostCategory  as _RECostCategory  on $projection.RECostCategory = _RECostCategory.RECostCategory
  association [1..1] to I_GLAccount       as _GLAccount       on (
           $projection.CompanyCode         = _GLAccount.CompanyCode
           and $projection.GLAccount       = _GLAccount.GLAccount
           and $projection.ChartOfAccounts = _GLAccount.ChartOfAccounts
         )
{
         @ObjectModel.foreignKey.association: '_ChartOfAccounts'
  key    tivcsceglaccass.ktopl        as ChartOfAccounts,
         @ObjectModel.foreignKey.association: '_CompanyCode'
  key    t001.bukrs                   as CompanyCode,
//         @ObjectModel.foreignKey.association: '_GLAccount'

  key    tivcsceglaccass.saknr        as GLAccount,
         @Search.defaultSearchElement: true
         @ObjectModel.foreignKey.association: '_RECostCategory'
  key    tivcsceglaccass.costcategory as RECostCategory,

        /* Associations */
         _ChartOfAccounts,
         _CompanyCode,
         _RECostCategory,
         _GLAccount

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"T001",
"TIVCSCEGLACCASS"
],
"ASSOCIATED":
[
"I_CHARTOFACCOUNTS",
"I_COMPANYCODE",
"I_GLACCOUNT",
"I_RECOSTCATEGORY"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More