P_CashFlowWthRecnclnStsValid

DDL: P_CASHFLOWWTHRECNCLNSTSVALID SQL: PCASHFLOWWTHRECN Type: view COMPOSITE
50 Fields 2 Data Sources

P_CashFlowWthRecnclnStsValid is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_CashFlow, I_CashReconciliationsFlow) and exposes 50 fields with key fields OriginSystem, OriginApplication, OriginDocument, OriginTransaction, OriginTransactionQualifier.

Data Sources (2)

SourceAliasJoin Type
I_CashFlow flow from
I_CashReconciliationsFlow recon inner

Annotations (8)

NameValueLevelField
VDM.private true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName PCASHFLOWWTHRECN view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view

Fields (50)

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 I_CashFlow ValidFrom Vers.Valid From
KEY ValidTo ValidTo Vers.Valid To
CashFlowID I_CashFlow CashFlowID Flow ID
IsValid IsValid Truth Value
CreatedByUser CreatedByUser User Name
CashTransactionOwner CashTransactionOwner Vehicle Owner
CompanyCode CompanyCode Receiver Company Code
TransactionDate TransactionDate Value Date
PostingDate PostingDate Posting Date for GR
CertaintyLevel CertaintyLevel
TransactionCurrency TransactionCurrency Transaction Currency
AmountInTransactionCurrency
CompanyCodeCurrency CompanyCodeCurrency Local Currency
AmountInCompanyCodeCurrency
CashReleaseStatus CashReleaseStatus Release Status
AccountingDocument AccountingDocument Journal Entry
AccountingDocumentItem AccountingDocumentItem Posting View Item
FiscalYear FiscalYear G/L Fiscal Year
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
BankAccountInternalID BankAccountInternalID Technical ID
Customer Customer Sold-to Party
Supplier Supplier Supplier
BusinessPartner BusinessPartner Issuing Authority
Material Material Vehicle Model
BusinessArea BusinessArea Business Area
ProfitCenter ProfitCenter Profit Center
PartnerCompany PartnerCompany Trading Partner
CostCenter CostCenter Cost Center
Segment Segment Segment number
LiquidityItem LiquidityItem Liquidity Item
SourceCompanyCode SourceCompanyCode
ProductType FinancialInstrumentProductType Product Type Group
FinancialTransactionType FinancialTransactionType Transact. Type
SecurityClass SecurityClass
SecurityAccount SecurityAccount
AssetContract AssetContract Asset Contract
ExpirationDate ExpirationDate Expiratn Date

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_CashFlowWthRecnclnStsValid.
-- 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: PCASHFLOWWTHRECN

CREATE VIEW P_CashFlowWthRecnclnStsValid AS
SELECT
  OriginSystem,
  OriginApplication,
  OriginDocument,
  OriginTransaction,
  OriginTransactionQualifier,
  CashFlow,
  flow.ValidFrom AS ValidFrom,
  ValidTo,
  flow.CashFlowID AS CashFlowID,
  IsValid,
  CreatedByUser,
  CashTransactionOwner,
  CompanyCode,
  TransactionDate,
  PostingDate,
  CertaintyLevel,
  TransactionCurrency,
  0 - AmountInTransactionCurrency AS AmountInTransactionCurrency,
  CompanyCodeCurrency,
  0 - AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  CashReleaseStatus,
  AccountingDocument,
  AccountingDocumentItem,
  FiscalYear,
  PaymentMethod,
  GLAccount,
  FinancialAccountType,
  DocumentItemText,
  CashPlanningGroup,
  PlanningLevel,
  HouseBank,
  HouseBankAccount,
  BankAccountInternalID,
  Customer,
  Supplier,
  BusinessPartner,
  Material,
  BusinessArea,
  ProfitCenter,
  PartnerCompany,
  CostCenter,
  Segment,
  LiquidityItem,
  SourceCompanyCode,
  FinancialInstrumentProductType AS ProductType,
  FinancialTransactionType,
  SecurityClass,
  SecurityAccount,
  AssetContract,
  ExpirationDate
FROM I_CashFlow AS flow
INNER JOIN I_CashReconciliationsFlow AS recon ON /* join condition not captured in parsed metadata */
;

Learn More