P_CASHFLOWCFACASHPOS

DDL: P_CASHFLOWCFACASHPOS SQL: PCSHFLWCFACP Type: view BASIC
56 Fields 2 Data Sources 1 Associations

P_CASHFLOWCFACASHPOS is a Basic CDS View in SAP S/4HANA. It reads from 2 data sources (I_BankAccount, I_CashFlowByScopeForAccounting) and exposes 56 fields with key fields OriginSystem, OriginApplication, OriginDocument, OriginTransaction, OriginTransactionQualifier. It has 1 association to related views.

Data Sources (2)

SourceAliasJoin Type
I_BankAccount _bam left_outer
I_CashFlowByScopeForAccounting _flow from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_WBSElementByInternalKey _WBSElement $projection.WBSElementInternalID = _WBSElement.WBSElementInternalID --left outer join I_BankAccount as _bam on _flow.BankAccountInternalID = _bam.BankAccountInternalID

Annotations (8)

NameValueLevelField
VDM.private true view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #MANDATORY view
AbapCatalog.sqlViewName PCSHFLWCFACP view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view

Fields (56)

KeyFieldSource TableSource FieldDescription
KEY OriginSystem OriginSystem LogSys: Formula
KEY OriginApplication OriginApplication Origin Application
KEY OriginDocument OriginDocument
KEY OriginTransaction OriginTransaction
KEY OriginTransactionQualifier OriginTransactionQualifier
KEY CashFlow CashFlow
KEY ValidFrom ValidFrom Vers.Valid From
KEY ValidTo ValidTo Vers.Valid To
KEY CashFlowScopeForAccounting CashFlowScopeForAccounting
CashFlowID CashFlowID Flow ID
CashTransactionOwner CashTransactionOwner Vehicle Owner
CreatedByUser CreatedByUser User Name
CompanyCode I_CashFlowByScopeForAccounting CompanyCode Receiver Company Code
TransactionDate TransactionDate Value Date
PostingDate PostingDate Posting Date for GR
CertaintyLevel CertaintyLevel
ActualCertaintyLevel
Currency TransactionCurrency Transaction Currency
Amount AmountInTransactionCurrency Pt Crcy Amt
BaseCurrency CompanyCodeCurrency Local Currency
BaseAmount AmountInCompanyCodeCurrency Local Crcy Amt
AccountingDocument AccountingDocument Journal Entry
AccountingDocumentItem AccountingDocumentItem Posting View Item
FiscalYear FiscalYear G/L Fiscal Year
FiscalPeriod PostingFiscalPeriod Period
FIDocumentType AccountingDocumentType Journal Entry Type
PaymentMethod PaymentMethod Pymt Meth.
GLAccount GLAccount General Ledger
FinancialAccountType FinancialAccountType Fin. Account Type
DocumentItemText DocumentItemText Text
CashPlanningGroup CashPlanningGroup Planning Group
PlanningLevel PlanningLevel Planning Level
HouseBank HouseBank House Bank
HouseBankAccount HouseBankAccount House Bank Account
Customer Customer Sold-to Party
Supplier Supplier Supplier
BusinessPartner BusinessPartner Issuing Authority
Material Material Vehicle Model
BusinessArea BusinessArea Business Area
ProfitCenter ProfitCenter Profit Center
CostCenter CostCenter Cost Center
WBSElementInternalID WBSElementInternalID WBS Internal ID
WBSElementExternalID _WBSElement WBSElementExternalID WBS Element External ID
TradingPartner PartnerCompany Trading Partner
Segment Segment Segment number
LiquidityItem LiquidityItem Liquidity Item
SourceCompanyCode SourceCompanyCode
Fund Fund Sender Fund
GrantID GrantID Sender Grant
ExpirationDate ExpirationDate Expiratn Date
Bank
BankCountry
BankAccount
BankAccountType
IBAN
direction

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_CASHFLOWCFACASHPOS.
-- 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: PCSHFLWCFACP

CREATE VIEW P_CASHFLOWCFACASHPOS AS
SELECT
  OriginSystem,
  OriginApplication,
  OriginDocument,
  OriginTransaction,
  OriginTransactionQualifier,
  CashFlow,
  ValidFrom,
  ValidTo,
  CashFlowScopeForAccounting,
  CashFlowID,
  CashTransactionOwner,
  CreatedByUser,
  _flow.CompanyCode AS CompanyCode,
  TransactionDate,
  PostingDate,
  CertaintyLevel,
  case when CertaintyLevel = 'ACTUAL' then CertaintyLevel else '' end AS ActualCertaintyLevel,
  TransactionCurrency AS Currency,
  AmountInTransactionCurrency AS Amount,
  CompanyCodeCurrency AS BaseCurrency,
  AmountInCompanyCodeCurrency AS BaseAmount,
  AccountingDocument,
  AccountingDocumentItem,
  FiscalYear,
  PostingFiscalPeriod AS FiscalPeriod,
  AccountingDocumentType AS FIDocumentType,
  PaymentMethod,
  GLAccount,
  FinancialAccountType,
  DocumentItemText,
  CashPlanningGroup,
  PlanningLevel,
  HouseBank,
  HouseBankAccount,
  Customer,
  Supplier,
  BusinessPartner,
  Material,
  BusinessArea,
  ProfitCenter,
  CostCenter,
  WBSElementInternalID,
  _WBSElement.WBSElementExternalID AS WBSElementExternalID,
  PartnerCompany AS TradingPartner,
  Segment,
  LiquidityItem,
  SourceCompanyCode,
  Fund,
  GrantID,
  ExpirationDate,
  coalesce(_BankAccount.Bank, '') AS Bank,
  coalesce(_BankAccount.BankCountry, '') AS BankCountry,
  coalesce(_BankAccount.BankAccountNumber, '') AS BankAccount,
  coalesce(_BankAccount.BankAccountType, '') AS BankAccountType,
  coalesce(_BankAccount.IBAN, '') AS IBAN,
  case when AmountInTransactionCurrency > 0 then '+' else '-' end AS direction
FROM I_CashFlowByScopeForAccounting AS _flow
LEFT OUTER JOIN I_BankAccount AS _bam ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_WBSElementByInternalKey AS _WBSElement ON WBSElementInternalID = _WBSElement.WBSElementInternalID  -- association [0..1]
;

Learn More