C_GLAccountValueHelp

DDL: C_GLACCOUNTVALUEHELP SQL: CGLACOUNTTVH Type: view CONSUMPTION Package: ODATA_PS_COS_PROJFIN_MNTR

GL Account Value Help

C_GLAccountValueHelp is a Consumption CDS View that provides data about "GL Account Value Help" in SAP S/4HANA. It reads from 1 data source (I_GLAccountStdVH) and exposes 4 fields with key fields GLAccount, CompanyCode. It is used in 1 Fiori application: Project Cost Report - Overview. Part of development package ODATA_PS_COS_PROJFIN_MNTR.

Data Sources (1)

SourceAliasJoin Type
I_GLAccountStdVH I_GLAccountStdVH from

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName CGLACOUNTTVH view
AbapCatalog.compiler.compareFilter true view
EndUserText.label GL Account Value Help view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #CHECK view
ObjectModel.representativeKey GLAccount view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
OData.publish true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.dataCategory #VALUE_HELP view
AbapCatalog.preserveKey true view
Search.searchable true view
Consumption.ranked true view

Fiori Apps (1)

App IDApp NameTypeDescription
F2513 Project Cost Report - Overview Analytical An application to compare the plan versus actual costs of a project.

Project Cost Report - Overview

Business Role: Project Financial Controller

This feature enables you to easily monitor aggregated and non-aggregated project costs by allowing you to compare plan costs with actual costs. You can also monitor the variance and costs at individual line item level, configure two cost planning categories and use one category for calculation of variance. You can also enter the level to which a project tree has to be expanded, and view cost details of multiple projects or WBS elements from different projects and hierarchies.

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY GLAccount GLAccount G/L Account
KEY CompanyCode CompanyCode Company Code
GLAccountName G/L Account Name
ChartOfAccounts ChartOfAccounts
@AbapCatalog.sqlViewName: 'CGLACOUNTTVH'
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'GL Account Value Help'
@VDM.viewType: #CONSUMPTION
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.representativeKey: 'GLAccount'
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.dataClass:  #MASTER
@ObjectModel.usageType.serviceQuality: #C
@OData.publish: true
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.dataCategory: #VALUE_HELP
@AbapCatalog.preserveKey:true
@Search.searchable: true
@Consumption.ranked: true

define view C_GLAccountValueHelp
  as select from I_GLAccountStdVH
{
      @ObjectModel.text.element:  [ 'GLAccountName' ]
      @EndUserText.label: 'G/L Account'
      @EndUserText.quickInfo: 'G/L Account'
      @Search: { defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.8 }
  key GLAccount,
  
      @EndUserText.label: 'Company Code'
      @EndUserText.quickInfo: 'Company Code'
      @Search: { defaultSearchElement: true, ranking: #MEDIUM, fuzzinessThreshold: 0.8 }
  key CompanyCode,

      @Semantics.text: true
      @EndUserText.label: 'G/L Account Name'
      @EndUserText.quickInfo: 'G/L Account Name'
      @Search: { defaultSearchElement: true, ranking: #LOW, fuzzinessThreshold: 0.8 }
      _Text[1:Language =  $session.system_language].GLAccountName,

      @Consumption.hidden: true
      ChartOfAccounts
}