Select language:

Background documentationFI-AR: Customer Line Items: Payment Forecast (for BW)

 

SAP HANA calculation view: sap.bicont.fi.ar.CV_AR_PAYMENT_FC

 

This SAP HANA calculation view supplies the data for payment forecast analysis. It is used by the BW VirtualProvider FI-AR: Payment Forecast (SAP HANA) (/IMO/FIAR_V03).

The view supplies the following values:

  • Amount due per calendar day, based on the net due date for open items.

    • Reads open line items to retrieve the amount due per calendar day, based on the net due date.

    • All amounts with net due dates before today are accumulated and assigned to yesterday.

    • The amount is provided in field CM_AMT_DUEDATE.

  • Amount due per calendar day, based on the historical payment pattern for open items.

    • The payment pattern is derived using the payment history stored in BW for the customer. The payment pattern is defined as the average difference in days between the net due date and the actual payment date.

    • Reads open line items to retrieve the amount due per calendar day, based on the payment pattern defined above.

    • If the due date is in the past, the amount is assigned to yesterday.

    • The amount is provided in field CM_AMT_PAYPAT.

  • Amount paid per calendar day, based on incoming payments.

    • Reads closed line items to retrieve the total for all payments that were received on the current date

The HANA Calculation View consumes the following HANA Analytical Views:

  • sap.bicont.fi.ar.AN_AR_ITEMS_CLEARED

  • sap.bicont.fi.ar.AN_AR_ITEMS_OPEN

  • system-local.bw.bw2hana.imo.FIAR_D30

More Information

For detailed information about a specific SAP HANA information model, use the Auto Documentation function in SAP HANA Studio. This function provides a PDF document for each model, including all fields of the model, and a list of models that are referenced.

For more information about SAP HANA Studio, see the SAP HANA Developer Guide at   http://help.sap.com  SAP In-Memory Computing  SAP HANA Appliance  Development Information  SAP HANA Developer Guide  .