I_CashInformationAccount

DDL: I_CASHINFORMATIONACCOUNT Type: view_entity COMPOSITE Package: FCLM_INFOACCOUNT
23 Fields 1 Data Sources 5 Associations

G/L Account with Default Liquidity Item

I_CashInformationAccount is a Composite CDS View that provides data about "G/L Account with Default Liquidity Item" in SAP S/4HANA. It reads from 1 data source (I_CshInfoAcctRunTime) and exposes 23 fields with key fields CompanyCode, GLAccount, CashInformationAccountVersion. It has 5 associations to related views. Part of development package FCLM_INFOACCOUNT.

Data Sources (1)

SourceAliasJoin Type
I_CshInfoAcctRunTime I_CshInfoAcctRunTime from

Associations (5)

CardinalityTargetAliasCondition
[1..1] I_GLAccount _GLAccount $projection.CompanyCode = _GLAccount.CompanyCode and $projection.GLAccount = _GLAccount.GLAccount
[0..*] I_CashGLClassificationText _GLClassificationText $projection.GeneralLedgerClassification = _GLClassificationText.GeneralLedgerClassification
[0..1] I_LiquidityItem _LiquidityItem $projection.LiquidityItem = _LiquidityItem.LiquidityItem
[0..*] I_CashInfoAccFlagText _CashInfoAccFlagText $projection.CashInformationAccountFlag = _CashInfoAccFlagText.CashInformationAccountFlag
[0..*] I_GLAcctLiquidityItemInfo _InfoAcctItem

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label G/L Account with Default Liquidity Item view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #COMPOSITE view
Search.searchable true view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY GLAccount GLAccount General Ledger
KEY CashInformationAccountVersion CashInformationAccountVersion
ChartOfAccounts _GLAccount ChartOfAccounts Node Class
GLAccountGroup _GLAccount GLAccountGroup Account Group
GLAccountType
GLAccountSubtype
ReconciliationAccountType _GLAccount ReconciliationAccountType Reconcil. ID
IsBalanceSheetAccount _GLAccount IsBalanceSheetAccount Is Balance Sheet Account
IsOpenItemManaged _GLAccount IsOpenItemManaged Open Item Management
LiquidityItem LiquidityItem Liquidity Item
FurtherEvaluationIsExpd FurtherEvaluationIsExpd Furth.Evaluatn
GeneralLedgerClassification GeneralLedgerClassification
CashFlowTypeDebit CashFlowTypeDebit Debit Flow Type
CashFlowTypeCredit CashFlowTypeCredit Credit Flow Type
CashInformationAccountFlag CashInformationAccountFlag
InformationAccountFrom InformationAccountFrom From Account Number
InformationAccountTo InformationAccountTo Up to Account No.
_GLAccount _GLAccount
_LiquidityItem _LiquidityItem
_InfoAcctItem _InfoAcctItem
_CashInfoAccFlagText _CashInfoAccFlagText
_GLClassificationText _GLClassificationText

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 I_CashInformationAccount.
-- 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.

CREATE VIEW I_CashInformationAccount AS
SELECT
  CompanyCode,
  GLAccount,
  CashInformationAccountVersion,
  _GLAccount.ChartOfAccounts AS ChartOfAccounts,
  _GLAccount.GLAccountGroup AS GLAccountGroup,
  _GLAccount._GLAccountInChartOfAccounts.GLAccountType AS GLAccountType,
  _GLAccount._GLAccountInChartOfAccounts.GLAccountSubtype AS GLAccountSubtype,
  _GLAccount.ReconciliationAccountType AS ReconciliationAccountType,
  _GLAccount.IsBalanceSheetAccount AS IsBalanceSheetAccount,
  _GLAccount.IsOpenItemManaged AS IsOpenItemManaged,
  LiquidityItem,
  FurtherEvaluationIsExpd,
  GeneralLedgerClassification,
  CashFlowTypeDebit,
  CashFlowTypeCredit,
  CashInformationAccountFlag,
  InformationAccountFrom,
  InformationAccountTo
FROM I_CshInfoAcctRunTime
LEFT OUTER JOIN I_GLAccount AS _GLAccount ON CompanyCode = _GLAccount.CompanyCode AND GLAccount = _GLAccount.GLAccount  -- association [1..1]
LEFT OUTER JOIN I_CashGLClassificationText AS _GLClassificationText ON GeneralLedgerClassification = _GLClassificationText.GeneralLedgerClassification  -- association [0..*]
LEFT OUTER JOIN I_LiquidityItem AS _LiquidityItem ON LiquidityItem = _LiquidityItem.LiquidityItem  -- association [0..1]
LEFT OUTER JOIN I_CashInfoAccFlagText AS _CashInfoAccFlagText ON CashInformationAccountFlag = _CashInfoAccFlagText.CashInformationAccountFlag  -- association [0..*]
LEFT OUTER JOIN I_GLAcctLiquidityItemInfo AS _InfoAcctItem ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More