I_RecmddLiquidityItem

DDL: I_RECMDDLIQUIDITYITEM SQL: IRECMDDLYQITM Type: view COMPOSITE
33 Fields 1 Data Sources

Detect abnormal liquidity items

I_RecmddLiquidityItem is a Composite CDS View that provides data about "Detect abnormal liquidity items" in SAP S/4HANA. It reads from 1 data source (I_CashFlow) and exposes 33 fields with key fields OriginSystem, OriginApplication, OriginDocument, OriginTransaction, OriginTransactionQualifier.

Data Sources (1)

SourceAliasJoin Type
I_CashFlow flow from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IRECMDDLYQITM view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Detect abnormal liquidity items view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.allowExtensions true view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.dataClass #MIXED view

Fields (33)

KeyFieldSource TableSource FieldDescription
KEY OriginSystem I_CashFlow OriginSystem LogSys: Formula
KEY OriginApplication I_CashFlow OriginApplication Origin Application
KEY OriginDocument I_CashFlow OriginDocument
KEY OriginTransaction I_CashFlow OriginTransaction
KEY OriginTransactionQualifier I_CashFlow OriginTransactionQualifier
KEY CashFlow I_CashFlow CashFlow
LiquidityItem I_CashFlow LiquidityItem Liquidity Item
DocumentItemText I_CashFlow DocumentItemText Text
CompanyCode I_CashFlow CompanyCode Receiver Company Code
TransactionDate I_CashFlow TransactionDate Value Date
CertaintyLevel I_CashFlow CertaintyLevel
Currency I_CashFlow TransactionCurrency Transaction Currency
AmountInTransactionCurrency I_CashFlow AmountInTransactionCurrency Pt Crcy Amt
PlanningLevel I_CashFlow PlanningLevel Planning Level
CashPlanningGroup I_CashFlow CashPlanningGroup Planning Group
GLAccount I_CashFlow GLAccount General Ledger
BusinessPartner I_CashFlow BusinessPartner Issuing Authority
Customer I_CashFlow Customer Sold-to Party
Supplier I_CashFlow Supplier Supplier
PartnerCompany I_CashFlow PartnerCompany Trading Partner
CostCenter I_CashFlow CostCenter Cost Center
ProfitCenter I_CashFlow ProfitCenter Profit Center
Segment I_CashFlow Segment Segment number
BusinessArea I_CashFlow BusinessArea Business Area
Material I_CashFlow Material Vehicle Model
WBSElement I_CashFlow WBSElementInternalID WBS Internal ID
HouseBank I_CashFlow HouseBank House Bank
HouseBankAccount I_CashFlow HouseBankAccount House Bank Account
PaymentMethod I_CashFlow PaymentMethod Pymt Meth.
FinancialAccountType I_CashFlow FinancialAccountType Fin. Account Type
FinancialTransactionType I_CashFlow FinancialTransactionType Transact. Type
BankAccountInternalID I_CashFlow BankAccountInternalID Technical ID
AccountingDocument I_CashFlow AccountingDocument Journal Entry

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_RecmddLiquidityItem.
-- 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: IRECMDDLYQITM

CREATE VIEW I_RecmddLiquidityItem AS
SELECT
  flow.OriginSystem AS OriginSystem,
  flow.OriginApplication AS OriginApplication,
  flow.OriginDocument AS OriginDocument,
  flow.OriginTransaction AS OriginTransaction,
  flow.OriginTransactionQualifier AS OriginTransactionQualifier,
  flow.CashFlow AS CashFlow,
  flow.LiquidityItem AS LiquidityItem,
  flow.DocumentItemText AS DocumentItemText,
  flow.CompanyCode AS CompanyCode,
  flow.TransactionDate AS TransactionDate,
  flow.CertaintyLevel AS CertaintyLevel,
  flow.TransactionCurrency AS Currency,
  flow.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  flow.PlanningLevel AS PlanningLevel,
  flow.CashPlanningGroup AS CashPlanningGroup,
  flow.GLAccount AS GLAccount,
  flow.BusinessPartner AS BusinessPartner,
  flow.Customer AS Customer,
  flow.Supplier AS Supplier,
  flow.PartnerCompany AS PartnerCompany,
  flow.CostCenter AS CostCenter,
  flow.ProfitCenter AS ProfitCenter,
  flow.Segment AS Segment,
  flow.BusinessArea AS BusinessArea,
  flow.Material AS Material,
  flow.WBSElementInternalID AS WBSElement,
  flow.HouseBank AS HouseBank,
  flow.HouseBankAccount AS HouseBankAccount,
  flow.PaymentMethod AS PaymentMethod,
  flow.FinancialAccountType AS FinancialAccountType,
  flow.FinancialTransactionType AS FinancialTransactionType,
  flow.BankAccountInternalID AS BankAccountInternalID,
  flow.AccountingDocument AS AccountingDocument
FROM I_CashFlow AS flow
;

Learn More