3471073 - Value dates are blank in Custom CDS View YY1_I_CashFlowCube

• Field "Value date" in the data source I_CashFlowCube is appearing as blank or 0000-00-00.
• In the preview of Custom CDS View YY1_I_CASHFLOWCUBE the "Value Date" is blank for certainty levels: - PAY_N and REC_N.

SAP S/4HANA Cloud

1. Create and publish a Custom CDS View YY1_I_CASHFLOWCUBE with the data source as I_CashFlowCube.
2. Preview the data on the Custom CDS View.
3. The "Value Date" column on the certainty level PAY_N and REC_N is zero (0000-00-00) or blank.
4. Compare the cash flow in the App Check Cash Flow Items. The "Value Date" column is displaying a date value.

In the App Check Cash Flow Items, the value date field is displayed because the application uses the "Transaction Date" of certainty levels PAY_N (regular payable) and REC_N (regular receivable) as the "Value Date".

For the custom CDS view I_CashFlowCube, the "Value Date" is showing blank, which is correct because it is not populated in the One Exposure table for the certainty levels PAY_N or REC_N from the source application BSEGV.

For reporting purposes of your regular payables (PAY_N) and regular receivables (REC_N) cash flows, you can use the "Transaction Date" from the Custom CDS View YY1_I_CASHFLOWCUBE.

REC_N, PAY_N, vendor, reconciliation, cash flows, S4_PC, FIN-FSCM-CLM-COP-CP, cds, view, I_CashFlowCube , KBA , FIN-FSCM-CLM-COP-2CL , Cash Operations (Public Cloud) , How To

SAP S/4HANA Cloud Public Edition all versions ; SAP S/4HANA Cloud all versions