C_AllocationGLAccPrimSecdryVH

DDL: C_ALLOCATIONGLACCPRIMSECDRYVH SQL: CGLACCPSVH Type: view CONSUMPTION Package: ODATA_MANAGE_ALLOCATION

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 9 fields with key fields CompanyCode, GLAccount, GLAccountExternal, ChartOfAccounts. It has 1 association to related views. It is exposed through 1 OData service (UI_FCO_MANAGE_ALLOCATION). Part of development package ODATA_MANAGE_ALLOCATION.

1 data source(s) Exposed by 1 service(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
P_GLAccountTypeVH P_GLAccountTypeVH from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_UnivAllocGLAccountTypeText _GLAccountTypeText $projection.GLAccountType = _GLAccountTypeText.GLAccountType and _GLAccountTypeText.Language = $session.system_language

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

OData Services (1)

ServiceBindingVersionContractRelease
UI_FCO_MANAGE_ALLOCATION UI_FCOUA_MANAGE_ALLOCATION V2 C1 NOT_RELEASED

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode
KEY GLAccount GLAccount
KEY GLAccountExternal
KEY ChartOfAccounts ChartOfAccounts
AlternativeGLAccount AlternativeGLAccount
GLAccountType GLAccountType
GLAccountTypeText _GLAccountTypeText GLAccountTypeText
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 
  association [0..1] to I_UnivAllocGLAccountTypeText as _GLAccountTypeText on $projection.GLAccountType = _GLAccountTypeText.GLAccountType
                                                                          and _GLAccountTypeText.Language = $session.system_language  
{   
    @UI.lineItem.position: 40
    @Search.defaultSearchElement: true
    @UI.selectionField.position: 40
    key CompanyCode,
    
    @UI.lineItem.position: 10
    @Search.defaultSearchElement: true
    @UI.selectionField.position: 10
    key GLAccount,
    
    @UI.lineItem.position: 80
    @Search.defaultSearchElement: true
    @UI.selectionField.position: 80
    key cast (P_GLAccountTypeVH.GLAccountExternal as fco_alloc_glaccount_external preserving type) as GLAccountExternal,
    
    @UI.lineItem.position: 50
    @Search.defaultSearchElement: true
    @UI.selectionField.position: 50
    key ChartOfAccounts,
        
        @UI.lineItem.position: 60
        @Search.defaultSearchElement: true
        @UI.selectionField.position: 60
        AlternativeGLAccount,
        
        @UI.lineItem.position: 70
        @Search.defaultSearchElement: true
        @UI.selectionField.position: 70
        @Consumption.valueHelpDefinition: [ { entity: { name: 'C_UnivAllocGLAccountTypeVH', element: 'GLAccountType'  } } ]
        GLAccountType,
        
        @UI.lineItem.position: 75
        @Search.defaultSearchElement: true
        @UI.selectionField.position: 75
        _GLAccountTypeText.GLAccountTypeText,
        
        @UI.lineItem.position: 20
        @Search.defaultSearchElement: true
        @UI.selectionField.position: 20
        GLAccountName,
        
        @UI.lineItem.position: 30
        @Search.defaultSearchElement: true
        @UI.selectionField.position: 30
        GLAccountLongName 
}
where GLAccountType = 'P' or GLAccountType = 'S'

Learn More