FCLM_GLAccount

DDL: FCLMGLACCOUNT SQL: FCLMGLACCOUNT Type: view

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.

2 data source(s) 29 fields

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
KEY GLAccount I_GLAccount GLAccount
ChartOfAccounts I_GLAccount ChartOfAccounts
GLAccountType
GLAccountSubtype
GLAccountGroup I_GLAccount GLAccountGroup
IsBalanceSheetAccount I_GLAccount IsBalanceSheetAccount
ReconciliationAccountType I_GLAccount ReconciliationAccountType
IsOpenItemManaged I_GLAccount IsOpenItemManaged
TaxCategory I_GLAccount TaxCategory
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 
@AbapCatalog.sqlViewName: 'FCLMGLACCOUNT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.dataMaintenance: #RESTRICTED
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'G/L Accounts for Cash Management'
@ObjectModel.usageType: {dataClass: #MASTER, serviceQuality: #C, sizeCategory: #M }

define view FCLM_GLAccount
  as select from           I_GLAccount


    inner join             FQM_COMPANYCODE_ACTIVATED                               on  FQM_COMPANYCODE_ACTIVATED.CompanyCode        = I_GLAccount.CompanyCode
                                                                                   and FQM_COMPANYCODE_ACTIVATED.origin_system      = ''
                                                                                   and FQM_COMPANYCODE_ACTIVATED.origin_application = 'BKPF'
    left outer to one join FCLMGLACCOUNTPAYMENTCLEARING as _PaymentClearingAccount on  I_GLAccount.CompanyCode           = _PaymentClearingAccount.PayingCompanyCode
                                                                                   and I_GLAccount.GLAccount             = _PaymentClearingAccount.BankSubAccount
                                                                                   and I_GLAccount.IsBalanceSheetAccount = 'X'

    left outer to one join FCLMGLAccountBankClearing    as _BankClearingAccount       on  I_GLAccount.CompanyCode           = _BankClearingAccount.PayingCompanyCode
                                                                                      and I_GLAccount.GLAccount             = _BankClearingAccount.BankSubAccount
                                                                                      and I_GLAccount.IsBalanceSheetAccount = 'X'

    left outer to one join atpra                        as _TreasuryClearingAccount                       on  I_GLAccount.CompanyCode           = _TreasuryClearingAccount.bukrs
                                                                                                          and I_GLAccount.GLAccount             = _TreasuryClearingAccount.rprac
                                                                                                          and I_GLAccount.IsBalanceSheetAccount = 'X'
    left outer to one join FCLMGLACCOUNTBAMAccount      as _HouseBankAccount            on  I_GLAccount.CompanyCode           = _HouseBankAccount.CompanyCode
                                                                                        and I_GLAccount.GLAccount             = _HouseBankAccount.GLAccount
                                                                                        and I_GLAccount.IsBalanceSheetAccount = 'X'

  association [0..1] to FQM_ACCOUNT_STAGING as _staging on  I_GLAccount.CompanyCode = _staging.CompanyCode
                                                        and I_GLAccount.GLAccount   = _staging.GLAccount
{
  key I_GLAccount.CompanyCode,
  key I_GLAccount.GLAccount,
      I_GLAccount.ChartOfAccounts,
      I_GLAccount._GLAccountInChartOfAccounts.GLAccountType,
      I_GLAccount._GLAccountInChartOfAccounts.GLAccountSubtype,
      I_GLAccount.GLAccountGroup,
      I_GLAccount.IsBalanceSheetAccount,
      I_GLAccount.ReconciliationAccountType,
      I_GLAccount.IsOpenItemManaged,
      I_GLAccount.TaxCategory,
      I_GLAccount._GLAccountInCompanyCode.IsCashFlowAccount,
      I_GLAccount._GLAccountInCompanyCode.PlanningLevel,
      I_GLAccount._GLAccountInCompanyCode.HouseBank,
      I_GLAccount._GLAccountInCompanyCode.HouseBankAccount,
//      COALESCE( _HouseBankAccount.Nr_Entry, 0)                                                                              as NR_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,
      I_GLAccount._GLAccountInCompanyCode.CreationDate,
      I_GLAccount._GLAccountInCompanyCode.LastChangeDateTime,
      /* Associations */
      _staging,
      I_GLAccount._Text,
      I_GLAccount._ChartOfAccounts,
      I_GLAccount._CompanyCode,
      I_GLAccount._GLAccountInChartOfAccounts,
      I_GLAccount._GLAccountInCompanyCode,
      I_GLAccount._GLAccountInChartOfAccounts._GLAccountType,
      I_GLAccount._GLAccountInChartOfAccounts._GLAccountSubtype
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"FCLMGLACCOUNTBAMACCOUNT",
"FCLMGLACCOUNTBANKCLEARING",
"FCLMGLACCOUNTPAYMENTCLEARING",
"FQM_COMPANYCODE_ACTIVATED",
"I_GLACCOUNT",
"I_GLACCOUNTINCHARTOFACCOUNTS",
"I_GLACCOUNTINCOMPANYCODE",
"ATPRA"
],
"ASSOCIATED":
[
"FQM_ACCOUNT_STAGING",
"I_CHARTOFACCOUNTS",
"I_COMPANYCODE",
"I_GLACCOUNTINCHARTOFACCOUNTS",
"I_GLACCOUNTINCOMPANYCODE",
"I_GLACCOUNTSUBTYPE",
"I_GLACCOUNTTEXTINCOMPANYCODE",
"I_GLACCOUNTTYPE"
],
"BASE":
[
"I_GLACCOUNT",
"I_GLACCOUNTINCHARTOFACCOUNTS"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More