C_AllocationGLAccPrimSecdryVH

DDL: C_ALLOCATIONGLACCPRIMSECDRYVH SQL: CGLACCPSVH Type: view CONSUMPTION

Allocation Account

C_AllocationGLAccPrimSecdryVH is a Consumption CDS View that provides data about "Allocation Account" in SAP S/4HANA. It reads from 1 data source (P_GLAccountTypeVH) and exposes 8 fields with key fields CompanyCode, GLAccount, GLAccountExternal, ChartOfAccounts.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
P_GLAccountTypeVH P_GLAccountTypeVH from

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CGLACCPSVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.dataCategory #VALUE_HELP view
VDM.viewType #CONSUMPTION view
Search.searchable true view
EndUserText.label Allocation Account view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode
KEY GLAccount GLAccount
KEY GLAccountExternal
KEY ChartOfAccounts ChartOfAccounts
AlternativeGLAccount AlternativeGLAccount
GLAccountType GLAccountType
GLAccountName GLAccountName
GLAccountLongName GLAccountLongName 
@AbapCatalog.sqlViewName: 'CGLACCPSVH'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking:#NOT_REQUIRED

@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.usageType.dataClass: #CUSTOMIZING
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.dataCategory: #VALUE_HELP

@VDM.viewType: #CONSUMPTION

@Search.searchable: true
@EndUserText.label: 'Allocation Account'
define view C_AllocationGLAccPrimSecdryVH as 
select from P_GLAccountTypeVH 
{
    key CompanyCode,
    key GLAccount,
    key cast (P_GLAccountTypeVH.GLAccountExternal as fco_alloc_glaccount_external preserving type) as GLAccountExternal,
    key ChartOfAccounts,
        AlternativeGLAccount,
        GLAccountType,
        GLAccountName,
        GLAccountLongName 
}
where GLAccountType = 'P' or GLAccountType = 'S'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_GLACCOUNTTYPEVH"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More