A_GLAccountInChartOfAccounts

DDL: A_GLACCOUNTINCHARTOFACCOUNTS SQL: AFIGLACCINCOA Type: view BASIC
20 Fields 1 Data Sources 1 Associations

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.

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 Node Class
KEY GLAccount GLAccount General Ledger
IsBalanceSheetAccount IsBalanceSheetAccount Is Balance Sheet Account
GLAccountGroup GLAccountGroup Account Group
CorporateGroupAccount CorporateGroupAccount Group Account Number
ProfitLossAccountType ProfitLossAccountType Profit Loss Account Type
SampleGLAccount SampleGLAccount Sample Account
AccountIsMarkedForDeletion AccountIsMarkedForDeletion Deletion Flag
AccountIsBlockedForCreation AccountIsBlockedForCreation Creation Block
AccountIsBlockedForPosting AccountIsBlockedForPosting Posting Block
AccountIsBlockedForPlanning AccountIsBlockedForPlanning Planning Block
PartnerCompany PartnerCompany Trading Partner
FunctionalArea FunctionalArea Sendr Fctl Area
CreationDate CreationDate Time Stamp
CreatedByUser CreatedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
GLAccountType GLAccountType G/L Account Type
GLAccountExternal GLAccountExternal G/L Acct External ID
IsProfitLossAccount IsProfitLossAccount
_Text _Text

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view A_GLAccountInChartOfAccounts.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: AFIGLACCINCOA

CREATE VIEW A_GLAccountInChartOfAccounts AS
SELECT
  ChartOfAccounts,
  GLAccount,
  IsBalanceSheetAccount,
  GLAccountGroup,
  CorporateGroupAccount,
  ProfitLossAccountType,
  SampleGLAccount,
  AccountIsMarkedForDeletion,
  AccountIsBlockedForCreation,
  AccountIsBlockedForPosting,
  AccountIsBlockedForPlanning,
  PartnerCompany,
  FunctionalArea,
  CreationDate,
  CreatedByUser,
  LastChangeDateTime,
  GLAccountType,
  GLAccountExternal,
  IsProfitLossAccount
FROM I_GLAccountInChartOfAccounts
LEFT OUTER JOIN A_GLAccountText AS _Text ON ChartOfAccounts = _Text.ChartOfAccounts AND GLAccount = _Text.GLAccount  -- association [0..*]
;

Learn More