A_GLAccountInChartOfAccounts

DDL: A_GLACCOUNTINCHARTOFACCOUNTS SQL: AFIGLACCINCOA Type: view BASIC

API G/L Account In Chart Of Accounts

A_GLAccountInChartOfAccounts is a Basic CDS View that provides data about "API G/L Account In Chart Of Accounts" in SAP S/4HANA. It reads from 1 data source (I_GLAccountInChartOfAccounts) and exposes 20 fields with key fields ChartOfAccounts, GLAccount. It has 1 association to related views.

1 data source(s) 20 fields

Data Sources (1)

SourceAliasJoin Type
I_GLAccountInChartOfAccounts I_GLAccountInChartOfAccounts from

Associations (1)

CardinalityTargetAliasCondition
[0..*] A_GLAccountText _Text $projection.ChartOfAccounts = _Text.ChartOfAccounts and $projection.GLAccount = _Text.GLAccount

Annotations (12)

NameValueLevelField
EndUserText.label API G/L Account In Chart Of Accounts view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
AbapCatalog.sqlViewName AFIGLACCINCOA view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #B view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY ChartOfAccounts ChartOfAccounts
KEY GLAccount GLAccount
IsBalanceSheetAccount IsBalanceSheetAccount
GLAccountGroup GLAccountGroup
CorporateGroupAccount CorporateGroupAccount
ProfitLossAccountType ProfitLossAccountType
SampleGLAccount SampleGLAccount
AccountIsMarkedForDeletion AccountIsMarkedForDeletion
AccountIsBlockedForCreation AccountIsBlockedForCreation
AccountIsBlockedForPosting AccountIsBlockedForPosting
AccountIsBlockedForPlanning AccountIsBlockedForPlanning
PartnerCompany PartnerCompany
FunctionalArea FunctionalArea
CreationDate CreationDate
CreatedByUser CreatedByUser
LastChangeDateTime LastChangeDateTime
GLAccountType GLAccountType
GLAccountExternal GLAccountExternal
IsProfitLossAccount IsProfitLossAccount
_Text _Text 
@EndUserText.label: 'API G/L Account In Chart Of Accounts'
@VDM.viewType: #BASIC
@VDM.lifecycle.contract.type:#PUBLIC_REMOTE_API
@AbapCatalog.sqlViewName: 'AFIGLACCINCOA'
//@ObjectModel.entityChangeStateId: 'LastChangeDateTime'   // To prevent error Property 'LastChangeDateTime': Nullvalue '0' not allowed as key component

@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.dataClass:  #MASTER
@ObjectModel.usageType.serviceQuality: #B
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@AccessControl.authorizationCheck: #CHECK

// A-view annotations

@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true

define view A_GLAccountInChartOfAccounts
  as select from I_GLAccountInChartOfAccounts
    association [0..*] to A_GLAccountText             as _Text                      on  $projection.ChartOfAccounts = _Text.ChartOfAccounts
                                                                                    and $projection.GLAccount       = _Text.GLAccount
{
    //I_GLAccountInChartOfAccounts 

    key ChartOfAccounts, 
    key GLAccount, 
    IsBalanceSheetAccount, 
    GLAccountGroup, 
    CorporateGroupAccount, 
    ProfitLossAccountType, 
    SampleGLAccount, 
    AccountIsMarkedForDeletion, 
    AccountIsBlockedForCreation, 
    AccountIsBlockedForPosting, 
    AccountIsBlockedForPlanning, 
    PartnerCompany, 
    FunctionalArea, 
    CreationDate, 
    CreatedByUser, 
    LastChangeDateTime, 
    GLAccountType, 
    GLAccountExternal, 
    IsProfitLossAccount, 
    /* Associations */ 
    _Text

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_GLACCOUNTINCHARTOFACCOUNTS"
],
"ASSOCIATED":
[
"A_GLACCOUNTTEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More