C_AllocationReceiverGLAcctVH

DDL: C_ALLOCATIONRECEIVERGLACCTVH SQL: CGLACCPSXNVH Type: view CONSUMPTION Package: ODATA_MANAGE_ALLOCATION

Account Number

C_AllocationReceiverGLAcctVH is a Consumption CDS View that provides data about "Account Number" 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 CGLACCPSXNVH 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 Account Number 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
GLAccountName GLAccountName
GLAccountLongName GLAccountLongName
GLAccountTypeText _GLAccountTypeText GLAccountTypeText 
@AbapCatalog.sqlViewName: 'CGLACCPSXNVH'
@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: 'Account Number'
define view C_AllocationReceiverGLAcctVH 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.selectionField.position: 90
        @UI.lineItem.position: 90
    key CompanyCode,
        @UI.selectionField.position: 50
        @UI.lineItem.position: 50
    key GLAccount,
        @UI.selectionField.position: 70
        @UI.lineItem.position: 70
    key cast (P_GLAccountTypeVH.GLAccountExternal as fco_alloc_glaccount_external preserving type) as GLAccountExternal,
        @UI.selectionField.position: 60
        @UI.lineItem.position: 60
    key ChartOfAccounts,
        @UI.selectionField.position: 40
        @UI.lineItem.position: 40
        AlternativeGLAccount,
        @UI.selectionField.position: 80
        @UI.lineItem.position: 80
        @Consumption.valueHelpDefinition: [ { entity: { name: 'C_UnivAllocGLAccountTypeVH', element: 'GLAccountType'  } } ]
        GLAccountType,
        @UI.selectionField.position: 20
        @UI.lineItem.position: 20
        GLAccountName,
        @UI.selectionField.position: 30
        @UI.lineItem.position: 30
        GLAccountLongName,
        @UI.selectionField.position: 90
        @UI.lineItem.position: 90
        _GLAccountTypeText.GLAccountTypeText
}
where GLAccountType = 'P' or GLAccountType = 'S' or GLAccountType = 'X'  or GLAccountType = 'N'

Learn More