I_GLACCOUNT
General Ledger Account
I_GLACCOUNT is a CDS View in S/4HANA. General Ledger Account. It contains 24 fields. 15 CDS views read from this table.
CDS Views using this table (15)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_BalanceAuditTrailAccount | view | from | CONSUMPTION | Accounts for Balance Audit Trail |
| C_CN_GLAcctVH | view | from | CONSUMPTION | GL Account Value Help |
| C_GeneralLedgerAccount | view | from | CONSUMPTION | General Ledger Account |
| C_GLAccountInCompanyCode | view | from | CONSUMPTION | Gl accounts in company code |
| C_MM_GLAccountVH | view | from | CONSUMPTION | GL Account Value Help in Material Management |
| C_MnlPostgAllwdGLAccount | view | from | CONSUMPTION | GL account open for manual postings |
| C_RevnVarcGLAcctVH | view | from | CONSUMPTION | Value help for GL Account |
| C_Ssp_Glaccountvh | view | from | CONSUMPTION | Consumption view for GL Account |
| FAC_POST_CRCY_ADJMT_GLACCT_VH | view_entity | from | Post Currency Adjustments GL Acct VH | |
| FAC_POST_JOUR_ENTRY_GLACCT_VH | view | from | Post Journal Entry GL Acct VH | |
| FAC_POST_TAX_PAYABLE_GLACCT_VH | view | from | Value Help of Post Tax Payable | |
| I_GLAccountStdVH | view | from | COMPOSITE | General Ledger Account |
| Summerizationterm1 | view | from | summerization term with first priority | |
| Summerizationterm2 | view | from | summerization term with second priority | |
| Summerizationterm3 | view | from | summerization term with third priority |
Fields (24)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | ChartOfAccounts | ChartOfAccount,ChartOfAccounts | 4 |
| KEY | CompanyCode | CompanyCode | 5 |
| KEY | GLAccount | GLAccount | 6 |
| KEY | PartnerCompany | PartnerCompany | 2 |
| AccountIsBlockedForCreation | AccountIsBlockedForCreation | 1 | |
| AccountIsBlockedForPlanning | AccountIsBlockedForPlanning | 1 | |
| AccountIsBlockedForPosting | AccountIsBlockedForPosting | 1 | |
| AccountIsMarkedForDeletion | AccountIsMarkedForDeletion | 1 | |
| AcctgDocItmDisplaySequenceRule | AcctgDocItmDisplaySequenceRule | 1 | |
| AlternativeGLAccount | AlternativeGLAccount | 1 | |
| AuthorizationGroup | AuthorizationGroup | 1 | |
| CorporateGroupAccount | CorporateGroupAccount | 1 | |
| CreatedByUser | CreatedByUser | 1 | |
| CreationDate | CreationDate | 1 | |
| FunctionalArea | FunctionalArea | 1 | |
| GLAccountExternal | GLAccountExternal | 1 | |
| GLAccountGroup | GLAccountGroup | 1 | |
| IsBalanceSheetAccount | IsBalanceSheetAccount | 1 | |
| IsOpenItemManaged | IsOpenItemManaged | 1 | |
| IsProfitLossAccount | IsProfitLossAccount | 1 | |
| LineItemDisplayIsEnabled | LineItemDisplayIsEnabled | 1 | |
| ProfitLossAccountType | ProfitLossAccountType | 1 | |
| ReconciliationAccountType | ReconciliationAccountType | 1 | |
| SampleGLAccount | SampleGLAccount | 1 |
@EndUserText.label: 'General Ledger Account'
@Analytics: {dataCategory: #DIMENSION, dataExtraction.enabled: true}
@VDM.viewType: #BASIC
@AbapCatalog: {
sqlViewName: 'IFIGLACCOUNT',
preserveKey: true,
buffering.status: #NOT_ALLOWED
}
@ObjectModel: {
representativeKey: 'GLAccount',
supportedCapabilities:[#CDS_MODELING_DATA_SOURCE,#SEARCHABLE_ENTITY],
usageType: {
sizeCategory: #M,
dataClass: #MASTER,
serviceQuality: #C
}
}
@Metadata.ignorePropagatedAnnotations: true
@Metadata.allowExtensions:true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #CHECK
@Search.searchable: true
//--[ GENERATED:012:29JlHNUf7jY4ip0dSlCN8W
@AccessControl.privilegedAssociations: ['_ChartOfAccountsText']
// ]--GENERATED
define view I_GLAccount
//P-View is needed as CoA is needed and this must not be part of I-View
as select from P_Glacct_In_Cc
//I_GLAccountInChartOfAccounts as GLAccountInChartOfAccounts
// inner join P_Glacct_In_Cc as GLAccountInCompanyCode on GLAccountInChartOfAccounts.GLAccount = GLAccountInCompanyCode.GLAccount
// and GLAccountInChartOfAccounts.ChartOfAccounts = GLAccountInCompanyCode.ChartOfAccounts
//--[ GENERATED:012:29JlHNUf7jY4ip0dSlCN8W
association [0..*] to I_ChartOfAccountsText as _ChartOfAccountsText on $projection.ChartOfAccounts = _ChartOfAccountsText.ChartOfAccounts
// ]--GENERATED
association [0..1] to I_GLAccountInCompanyCode as _GLAccountInCompanyCode on $projection.GLAccount = _GLAccountInCompanyCode.GLAccount
and $projection.CompanyCode = _GLAccountInCompanyCode.CompanyCode
association [1..1] to I_GLAccountInChartOfAccounts as _GLAccountInChartOfAccounts on $projection.ChartOfAccounts = _GLAccountInChartOfAccounts.ChartOfAccounts
and $projection.GLAccount = _GLAccountInChartOfAccounts.GLAccount
association [0..1] to I_ChartOfAccounts as _ChartOfAccounts on $projection.ChartOfAccounts = _ChartOfAccounts.ChartOfAccounts
association [0..*] to I_GlAccountTextInCompanycode as _Text on $projection.CompanyCode = _Text.CompanyCode
and $projection.GLAccount = _Text.GLAccount
association [0..1] to I_CompanyCode as _CompanyCode on $projection.CompanyCode = _CompanyCode.CompanyCode
association [0..1] to I_FunctionalArea as _FunctionalArea on $projection.functionalarea = _FunctionalArea.FunctionalArea
association [0..*] to I_GLAccountHierarchyNode as _GLAccountHierarchyNode on $projection.GLAccount = _GLAccountHierarchyNode.GLAccount
and $projection.ChartOfAccounts = _GLAccountHierarchyNode.ChartOfAccounts
{
@ObjectModel.text.association: '_Text'
@Search.defaultSearchElement:true
@Search.fuzzinessThreshold:0.8
@Search.ranking:#HIGH
key P_Glacct_In_Cc.GLAccount as GLAccount,
//--[ GENERATED:012:29JlHNUf7jY4ip0dSlCN8W
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_CompanyCodeStdVH',
element: 'CompanyCode' }
}]
// ]--GENERATED
@ObjectModel.foreignKey.association: '_CompanyCode'
key P_Glacct_In_Cc.CompanyCode as CompanyCode,
//--[ GENERATED:012:29JlHNUf7jY4ip0dSlCN8W
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_ChartOfAccountsStdVH',
element: 'ChartOfAccounts' }
}]
@ObjectModel.text.association: '_ChartOfAccountsText'
// ]--GENERATED
@ObjectModel.foreignKey.association: '_ChartOfAccounts'
P_Glacct_In_Cc.ChartOfAccounts,
_GLAccountInChartOfAccounts.GLAccountGroup,
_GLAccountInChartOfAccounts.CorporateGroupAccount,
P_Glacct_In_Cc.AccountIsBlockedForPosting,
_GLAccountInChartOfAccounts.AccountIsBlockedForPlanning,
_GLAccountInChartOfAccounts.AccountIsBlockedForCreation,
_GLAccountInChartOfAccounts.IsBalanceSheetAccount,
P_Glacct_In_Cc.AccountIsMarkedForDeletion,
_GLAccountInChartOfAccounts.PartnerCompany,
@ObjectModel.foreignKey.association: '_FunctionalArea'
_GLAccountInChartOfAccounts.FunctionalArea,
P_Glacct_In_Cc.CreationDate,
_GLAccountInChartOfAccounts.SampleGLAccount,
@EndUserText.label: 'Balance Sheet Account'
_GLAccountInChartOfAccounts.IsProfitLossAccount,
_GLAccountInChartOfAccounts.GLAccountType,
P_Glacct_In_Cc.CreatedByUser,
_GLAccountInChartOfAccounts.ProfitLossAccountType,
P_Glacct_In_Cc.ReconciliationAccountType,
P_Glacct_In_Cc.LineItemDisplayIsEnabled,
P_Glacct_In_Cc.IsOpenItemManaged,
P_Glacct_In_Cc.AlternativeGLAccount,
P_Glacct_In_Cc.AcctgDocItmDisplaySequenceRule,
cast( _GLAccountInChartOfAccounts.GLAccountExternal as fac_sakan preserving type ) as GLAccountExternal,
P_Glacct_In_Cc.CountryChartOfAccounts,
P_Glacct_In_Cc.AuthorizationGroup,
P_Glacct_In_Cc.TaxCategory,
P_Glacct_In_Cc.IsAutomaticallyPosted,
_CompanyCode.CompanyCodeName,
_CompanyCode,
_Text,
_GLAccountHierarchyNode,
_ChartOfAccounts,
_FunctionalArea,
_GLAccountInCompanyCode,
_GLAccountInChartOfAccounts,
//--[ GENERATED:012:29JlHNUf7jY4ip0dSlCN8W
@Consumption.hidden: true
_ChartOfAccountsText
// ]--GENERATED
};
// as select from I_GLAccountInChartOfAccounts as GLAccountInChartOfAccounts
// inner join P_Glacct_In_Cc as GLAccountInCompanyCode on GLAccountInChartOfAccounts.GLAccount = GLAccountInCompanyCode.GLAccount
// and GLAccountInChartOfAccounts.ChartOfAccounts = GLAccountInCompanyCode.ChartOfAccounts
//
// //--[ GENERATED:012:29JlHNUf7jY4ip0dSlCN8W
// association [0..*] to I_ChartOfAccountsText as _ChartOfAccountsText on $projection.ChartOfAccounts = _ChartOfAccountsText.ChartOfAccounts
// // ]--GENERATED
// association [0..1] to I_GLAccountInCompanyCode as _GLAccountInCompanyCode on $projection.GLAccount = _GLAccountInCompanyCode.GLAccount
// and $projection.CompanyCode = _GLAccountInCompanyCode.CompanyCode
//
// association [1..1] to I_GLAccountInChartOfAccounts as _GLAccountInChartOfAccounts on $projection.ChartOfAccounts = _GLAccountInChartOfAccounts.ChartOfAccounts
// and $projection.GLAccount = _GLAccountInChartOfAccounts.GLAccount
//
// association [0..1] to I_ChartOfAccounts as _ChartOfAccounts on $projection.ChartOfAccounts = _ChartOfAccounts.ChartOfAccounts
//
// association [0..*] to I_GlAccountTextInCompanycode as _Text on $projection.CompanyCode = _Text.CompanyCode
// and $projection.GLAccount = _Text.GLAccount
//
// association [0..1] to I_CompanyCode as _CompanyCode on $projection.CompanyCode = _CompanyCode.CompanyCode
//
// association [0..1] to I_FunctionalArea as _FunctionalArea on $projection.FunctionalArea = _FunctionalArea.FunctionalArea
//
//{
// @ObjectModel.text.association: '_Text'
// @Search.defaultSearchElement:true
// @Search.fuzzinessThreshold:0.8
// @Search.ranking:#HIGH
//
// key GLAccountInChartOfAccounts.GLAccount as GLAccount,
// //--[ GENERATED:012:29JlHNUf7jY4ip0dSlCN8W
// @Consumption.valueHelpDefinition: [
// { entity: { name: 'I_CompanyCodeStdVH',
// element: 'CompanyCode' }
// }]
// // ]--GENERATED
// @ObjectModel.foreignKey.association: '_CompanyCode'
// key GLAccountInCompanyCode.CompanyCode as CompanyCode,
// //--[ GENERATED:012:29JlHNUf7jY4ip0dSlCN8W
// @Consumption.valueHelpDefinition: [
// { entity: { name: 'I_ChartOfAccountsStdVH',
// element: 'ChartOfAccounts' }
// }]
// @ObjectModel.text.association: '_ChartOfAccountsText'
// // ]--GENERATED
// @ObjectModel.foreignKey.association: '_ChartOfAccounts'
// GLAccountInChartOfAccounts.ChartOfAccounts,
// GLAccountInChartOfAccounts.GLAccountGroup,
// GLAccountInChartOfAccounts.CorporateGroupAccount,
// GLAccountInChartOfAccounts.AccountIsBlockedForPosting,
// GLAccountInChartOfAccounts.AccountIsBlockedForPlanning,
// GLAccountInChartOfAccounts.AccountIsBlockedForCreation,
// GLAccountInChartOfAccounts.IsBalanceSheetAccount,
// GLAccountInChartOfAccounts.AccountIsMarkedForDeletion,
// GLAccountInChartOfAccounts.PartnerCompany,
// @ObjectModel.foreignKey.association: '_FunctionalArea'
// GLAccountInChartOfAccounts.FunctionalArea,
// GLAccountInChartOfAccounts.CreationDate,
// GLAccountInChartOfAccounts.SampleGLAccount,
// @EndUserText.label: 'Balance Sheet Account'
// GLAccountInChartOfAccounts.IsProfitLossAccount,
// GLAccountInChartOfAccounts.GLAccountType,
// GLAccountInChartOfAccounts.CreatedByUser,
// GLAccountInChartOfAccounts.ProfitLossAccountType,
// GLAccountInCompanyCode.ReconciliationAccountType,
// GLAccountInCompanyCode.LineItemDisplayIsEnabled,
// GLAccountInCompanyCode.IsOpenItemManaged,
// GLAccountInCompanyCode.AlternativeGLAccount,
// GLAccountInCompanyCode.AcctgDocItmDisplaySequenceRule,
// cast( GLAccountInChartOfAccounts.GLAccountExternal as fac_sakan ) as GLAccountExternal,
// GLAccountInCompanyCode.CountryChartOfAccounts,
// GLAccountInCompanyCode.AuthorizationGroup,
// GLAccountInCompanyCode.TaxCategory,
// GLAccountInCompanyCode.IsAutomaticallyPosted,
// _CompanyCode.CompanyCodeName,
// _CompanyCode,
// _Text,
// _GLAccountHierarchyNode,
// _ChartOfAccounts,
// _FunctionalArea,
// _GLAccountInCompanyCode,
// _GLAccountInChartOfAccounts,
// //--[ GENERATED:012:29JlHNUf7jY4ip0dSlCN8W
// @Consumption.hidden: true
// _ChartOfAccountsText
// // ]--GENERATED
//
//};