P_CashFlowCFAWthNewRecnclnSts

DDL: P_CASHFLOWCFAWTHNEWRECNCLNSTS Type: view_entity COMPOSITE Package: FCLM_CFA
62 Fields 1 Data Sources 1 Associations

Cash Flow for CFA with New Reconciliation Status

P_CashFlowCFAWthNewRecnclnSts is a Composite CDS View that provides data about "Cash Flow for CFA with New Reconciliation Status" in SAP S/4HANA. It reads from 1 data source (P_CASHFLOWCFA) and exposes 62 fields with key fields OriginSystem, OriginApplication, OriginDocument, OriginTransaction, OriginTransactionQualifier. It has 1 association to related views. Part of development package FCLM_CFA.

Data Sources (1)

SourceAliasJoin Type
P_CASHFLOWCFA _flow from

Parameters (1)

NameTypeDefault
P_CashFlowSnapshotDateTime timestampl

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_CshFlwRcnlnBndlItmWthDeleted _recn _flow.OriginSystem = _recn.OriginSystem and _flow.OriginApplication = _recn.OriginApplication and _flow.OriginDocument = _recn.OriginDocument and _flow.OriginTransaction = _recn.OriginTransaction and _flow.OriginTransactionQualifier = _recn.OriginTransactionQualifier and _flow.CashFlow = _recn.CashFlow and _recn.CashFlowReconciliationStrategy = '1' and _recn.CreationDateTime <= $parameters.P_CashFlowSnapshotDateTime and ( _recn.LastChangedAtDateTime >= $parameters.P_CashFlowSnapshotDateTime or _recn.CshFlwRecnclnBundleIsDeleted = '' )

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (62)

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
CashTransactionOwner CashTransactionOwner
CreatedByUser CreatedByUser User Name
CompanyCode CompanyCode Receiver Company Code
TransactionDate TransactionDate Value Date
PostingDate PostingDate Posting Date for GR
CertaintyLevel CertaintyLevel
ActualCertaintyLevel ActualCertaintyLevel
Currency Currency Valuation Crcy
Amount Amount Value Amount
BaseCurrency BaseCurrency Local Currency
BaseAmount BaseAmount Local Crcy Amt
BankAccountCurrency BankAccountCurrency Currency
AccountingDocument AccountingDocument Journal Entry
AccountingDocumentItem AccountingDocumentItem Posting View Item
FiscalYear FiscalYear G/L Fiscal Year
FiscalPeriod FiscalPeriod Tax period
FIDocumentType FIDocumentType 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
BankAccountId BankAccountId 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
CostCenter CostCenter Cost Center
WBSElementInternalID WBSElementInternalID WBS Internal ID
WBSElementExternalID WBSElementExternalID WBS Element External ID
TradingPartner TradingPartner Trading Partner
Segment Segment Segment number
LiquidityItem LiquidityItem Liquidity Item
SourceCompanyCode SourceCompanyCode
Fund Fund Sender Fund
GrantID GrantID Sender Grant
ExpirationDate ExpirationDate Expiratn Date
MemoRecordExpirationDateTime MemoRecordExpirationDateTime
NetDueDate NetDueDate Net Due Date
Bank Bank Bank Number
BankCountry BankCountry Bank Ctry/Rgn. Key
BankAccount BankAccount Bank acct
BankAccountType BankAccountType Account Type
IBAN IBAN IBAN House Bank
direction direction Long/Short Position
CashFlowIsIntradayReconciled CashFlowIsIntradayReconciled
CashFlowIsEndOfDayReconciled CashFlowIsEndOfDayReconciled

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_CashFlowCFAWthNewRecnclnSts.
-- 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.
-- Parameters: P_CashFlowSnapshotDateTime : timestampl

CREATE VIEW P_CashFlowCFAWthNewRecnclnSts AS
SELECT
  OriginSystem,
  OriginApplication,
  OriginDocument,
  OriginTransaction,
  OriginTransactionQualifier,
  CashFlow,
  ValidFrom,
  ValidTo,
  CashFlowScopeForAccounting,
  CashFlowID,
  CashTransactionOwner,
  CreatedByUser,
  CompanyCode,
  TransactionDate,
  PostingDate,
  CertaintyLevel,
  ActualCertaintyLevel,
  Currency,
  Amount,
  BaseCurrency,
  BaseAmount,
  BankAccountCurrency,
  AccountingDocument,
  AccountingDocumentItem,
  FiscalYear,
  FiscalPeriod,
  FIDocumentType,
  PaymentMethod,
  GLAccount,
  FinancialAccountType,
  DocumentItemText,
  CashPlanningGroup,
  PlanningLevel,
  HouseBank,
  HouseBankAccount,
  BankAccountId,
  Customer,
  Supplier,
  BusinessPartner,
  Material,
  BusinessArea,
  ProfitCenter,
  CostCenter,
  WBSElementInternalID,
  WBSElementExternalID,
  TradingPartner,
  Segment,
  LiquidityItem,
  SourceCompanyCode,
  Fund,
  GrantID,
  ExpirationDate,
  MemoRecordExpirationDateTime,
  NetDueDate,
  Bank,
  BankCountry,
  BankAccount,
  BankAccountType,
  IBAN,
  direction,
  CashFlowIsIntradayReconciled,
  CashFlowIsEndOfDayReconciled
FROM P_CASHFLOWCFA AS _flow
LEFT OUTER JOIN I_CshFlwRcnlnBndlItmWthDeleted AS _recn ON _flow.OriginSystem = _recn.OriginSystem AND _flow.OriginApplication = _recn.OriginApplication AND _flow.OriginDocument = _recn.OriginDocument AND _flow.OriginTransaction = _recn.OriginTransaction AND _flow.OriginTransactionQualifier = _recn.OriginTransactionQualifier AND _flow.CashFlow = _recn.CashFlow AND _recn.CashFlowReconciliationStrategy = '1' AND _recn.CreationDateTime <= $parameters.P_CashFlowSnapshotDateTime AND ( _recn.LastChangedAtDateTime >= $parameters.P_CashFlowSnapshotDateTime OR _recn.CshFlwRecnclnBundleIsDeleted = '' )  -- association [0..1]
;

Learn More