FCLM_GLAccount

DDL: FCLMGLACCOUNT SQL: FCLMGLACCOUNT Type: view
29 Fields 2 Data Sources 1 Associations

G/L Accounts for Cash Management

FCLM_GLAccount is a CDS View that provides data about "G/L Accounts for Cash Management" in SAP S/4HANA. It reads from 2 data sources (FQM_COMPANYCODE_ACTIVATED, I_GLAccount) and exposes 29 fields with key fields CompanyCode, GLAccount. It has 1 association to related views.

Data Sources (2)

SourceAliasJoin Type
FQM_COMPANYCODE_ACTIVATED FQM_COMPANYCODE_ACTIVATED inner
I_GLAccount I_GLAccount from

Associations (1)

CardinalityTargetAliasCondition
[0..1] FQM_ACCOUNT_STAGING _staging I_GLAccount.CompanyCode = _staging.CompanyCode and I_GLAccount.GLAccount = _staging.GLAccount

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName FCLMGLACCOUNT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.dataMaintenance #RESTRICTED view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label G/L Accounts for Cash Management view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_GLAccount CompanyCode Receiver Company Code
KEY GLAccount I_GLAccount GLAccount General Ledger
ChartOfAccounts I_GLAccount ChartOfAccounts Node Class
GLAccountType
GLAccountSubtype
GLAccountGroup I_GLAccount GLAccountGroup Account Group
IsBalanceSheetAccount I_GLAccount IsBalanceSheetAccount Is Balance Sheet Account
ReconciliationAccountType I_GLAccount ReconciliationAccountType Reconcil. ID
IsOpenItemManaged I_GLAccount IsOpenItemManaged Open Item Management
TaxCategory I_GLAccount TaxCategory Tax Code
IsCashFlowAccount
PlanningLevel
HouseBank
HouseBankAccount
NR_HouseBankAccount
NR_PaymentClearing
NR_BankClearing
NR_TRMClearing
AccountIsMarkedForDeletion
CreationDate
LastChangeDateTime
_staging _staging
_Text I_GLAccount _Text
_ChartOfAccounts I_GLAccount _ChartOfAccounts
_CompanyCode I_GLAccount _CompanyCode
_GLAccountInChartOfAccounts I_GLAccount _GLAccountInChartOfAccounts
_GLAccountInCompanyCode I_GLAccount _GLAccountInCompanyCode
_GLAccountType
_GLAccountSubtype

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 FCLM_GLAccount.
-- 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: FCLMGLACCOUNT

CREATE VIEW FCLM_GLAccount AS
SELECT
  I_GLAccount.CompanyCode AS CompanyCode,
  I_GLAccount.GLAccount AS GLAccount,
  I_GLAccount.ChartOfAccounts AS ChartOfAccounts,
  I_GLAccount._GLAccountInChartOfAccounts.GLAccountType AS GLAccountType,
  I_GLAccount._GLAccountInChartOfAccounts.GLAccountSubtype AS GLAccountSubtype,
  I_GLAccount.GLAccountGroup AS GLAccountGroup,
  I_GLAccount.IsBalanceSheetAccount AS IsBalanceSheetAccount,
  I_GLAccount.ReconciliationAccountType AS ReconciliationAccountType,
  I_GLAccount.IsOpenItemManaged AS IsOpenItemManaged,
  I_GLAccount.TaxCategory AS TaxCategory,
  I_GLAccount._GLAccountInCompanyCode.IsCashFlowAccount AS IsCashFlowAccount,
  I_GLAccount._GLAccountInCompanyCode.PlanningLevel AS PlanningLevel,
  I_GLAccount._GLAccountInCompanyCode.HouseBank AS HouseBank,
  I_GLAccount._GLAccountInCompanyCode.HouseBankAccount AS HouseBankAccount,
  case _HouseBankAccount.GLAccount when I_GLAccount.GLAccount then 1 else 0 end AS NR_HouseBankAccount,
  COALESCE( _PaymentClearingAccount.Nr_Entry, 0) AS NR_PaymentClearing,
  COALESCE( _BankClearingAccount.Nr_Entry, 0) AS NR_BankClearing,
  cast( case _TreasuryClearingAccount.rprac when I_GLAccount.GLAccount then 1 else 0 end as fqm_account_count_trmclr ) AS NR_TRMClearing,
  I_GLAccount._GLAccountInCompanyCode.AccountIsMarkedForDeletion AS AccountIsMarkedForDeletion,
  I_GLAccount._GLAccountInCompanyCode.CreationDate AS CreationDate,
  I_GLAccount._GLAccountInCompanyCode.LastChangeDateTime AS LastChangeDateTime,
  I_GLAccount._Text AS _Text,
  I_GLAccount._ChartOfAccounts AS _ChartOfAccounts,
  I_GLAccount._CompanyCode AS _CompanyCode,
  I_GLAccount._GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts,
  I_GLAccount._GLAccountInCompanyCode AS _GLAccountInCompanyCode,
  I_GLAccount._GLAccountInChartOfAccounts._GLAccountType AS _GLAccountType,
  I_GLAccount._GLAccountInChartOfAccounts._GLAccountSubtype AS _GLAccountSubtype
FROM I_GLAccount
INNER JOIN FQM_COMPANYCODE_ACTIVATED ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN FQM_ACCOUNT_STAGING AS _staging ON I_GLAccount.CompanyCode = _staging.CompanyCode AND I_GLAccount.GLAccount = _staging.GLAccount  -- association [0..1]
;

Learn More