P_StRpCashFLowLqdyItemCal

DDL: P_STRPCASHFLOWLQDYITEMCAL SQL: PSRCASHLQDYITMC Type: view COMPOSITE

P_StRpCashFLowLqdyItemCal is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (P_StRpCashFLowLqdyItemBase) and exposes 22 fields.

Data Sources (1)

SourceAliasJoin Type
P_StRpCashFLowLqdyItemBase flow from

Parameters (8)

NameTypeDefault
P_FromPostingDate fis_budat_from
P_ToPostingDate fis_budat_to
P_ComprnFromPostingDate fis_comprn_budat_from
P_ComprnToPostingDate fis_comprn_budat_to
P_HistoryDateTime timestampl
P_DisplayCurrency vdm_v_display_currency
P_ExchangeRateType kurst_curr
P_ExchangeRateDate vdm_v_exchange_rate_date

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PSRCASHLQDYITMC view
VDM.viewType #COMPOSITE view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.dataClass #MIXED view

Fields (22)

KeyFieldSource TableSource FieldDescription
BankAccountInternalID P_StRpCashFLowLqdyItemBase BankAccountInternalID Technical ID
BusinessPartner P_StRpCashFLowLqdyItemBase BusinessPartner Issuing Authority
BusinessArea P_StRpCashFLowLqdyItemBase BusinessArea Business Area
CompanyCode P_StRpCashFLowLqdyItemBase CompanyCode Receiver Company Code
AccountingDocument P_StRpCashFLowLqdyItemBase AccountingDocument Journal Entry
AccountingDocumentItem P_StRpCashFLowLqdyItemBase AccountingDocumentItem Posting View Item
CostCenter P_StRpCashFLowLqdyItemBase CostCenter Cost Center
ControllingArea P_StRpCashFLowLqdyItemBase ControllingArea Controlling Area
GLAccount P_StRpCashFLowLqdyItemBase GLAccount General Ledger
HouseBank P_StRpCashFLowLqdyItemBase HouseBank House Bank
HouseBankAccount P_StRpCashFLowLqdyItemBase HouseBankAccount House Bank Account
LiquidityItem P_StRpCashFLowLqdyItemBase LiquidityItem Liquidity Item
CashPlanningGroup P_StRpCashFLowLqdyItemBase CashPlanningGroup Planning Group
PlanningLevel P_StRpCashFLowLqdyItemBase PlanningLevel Planning Level
ProfitCenter P_StRpCashFLowLqdyItemBase ProfitCenter Profit Center
Segment P_StRpCashFLowLqdyItemBase Segment Segment number
TradingPartner P_StRpCashFLowLqdyItemBase TradingPartner Trading Partner
WBSElement P_StRpCashFLowLqdyItemBase WBSElement WBS Internal ID
CertaintyLevel P_StRpCashFLowLqdyItemBase CertaintyLevel
TransactionCurrency P_StRpCashFLowLqdyItemBase TransactionCurrency Transaction Currency
TransactionDate P_StRpCashFLowLqdyItemBase TransactionDate Value Date
FiscalYear P_StRpCashFLowLqdyItemBase FiscalYear G/L Fiscal Year

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 P_StRpCashFLowLqdyItemCal.
-- 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: PSRCASHLQDYITMC
-- Parameters: P_FromPostingDate : fis_budat_from, P_ToPostingDate : fis_budat_to, P_ComprnFromPostingDate : fis_comprn_budat_from, P_ComprnToPostingDate : fis_comprn_budat_to, P_HistoryDateTime : timestampl, P_DisplayCurrency : vdm_v_display_currency, P_ExchangeRateType : kurst_curr, P_ExchangeRateDate : vdm_v_exchange_rate_date

CREATE VIEW P_StRpCashFLowLqdyItemCal AS
SELECT
  flow.BankAccountInternalID AS BankAccountInternalID,
  flow.BusinessPartner AS BusinessPartner,
  flow.BusinessArea AS BusinessArea,
  flow.CompanyCode AS CompanyCode,
  flow.AccountingDocument AS AccountingDocument,
  flow.AccountingDocumentItem AS AccountingDocumentItem,
  flow.CostCenter AS CostCenter,
  flow.ControllingArea AS ControllingArea,
  flow.GLAccount AS GLAccount,
  flow.HouseBank AS HouseBank,
  flow.HouseBankAccount AS HouseBankAccount,
  flow.LiquidityItem AS LiquidityItem,
  flow.CashPlanningGroup AS CashPlanningGroup,
  flow.PlanningLevel AS PlanningLevel,
  flow.ProfitCenter AS ProfitCenter,
  flow.Segment AS Segment,
  flow.TradingPartner AS TradingPartner,
  flow.WBSElement AS WBSElement,
  flow.CertaintyLevel AS CertaintyLevel,
  flow.TransactionCurrency AS TransactionCurrency,
  flow.TransactionDate AS TransactionDate,
  flow.FiscalYear AS FiscalYear
FROM P_StRpCashFLowLqdyItemBase AS flow
;