Symptom
- 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.
Environment
SAP S/4HANA Cloud
Reproducing the Issue
- Create and publish a Custom CDS View YY1_I_CASHFLOWCUBE with the data source as I_CashFlowCube.
- Preview the data on the Custom CDS View.
- The "Value Date" column on the certainty level PAY_N and REC_N is zero (0000-00-00) or blank.
- Compare the cash flow in the App Check Cash Flow Items. The "Value Date" column is displaying a date value.
Cause
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".
Resolution
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.
Keywords
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