Coding liquidity forecast - big problem - How to?

[HKany]

Hello coders,

I have the honor to code a liquidity forecast. Problem: this theme is bascally a SD theme, but I am FI. Nevertheless I have to code it - somehow, but I do not know how. Does anybody accidentally coded something like this? functionality: selection screen with document type, document number and a start date. Based on the start date the incoming payments are forecasted for 12 periods/months. To be considered: document flow, SD invoices, status of FI documents - payed or not.

With a little help from a colleague I nearly solved the forecast for order-related invoices with or without billing plan.

But now I have to implement it for delivery-related billing documents. It's all Greek to me. A SD consultant explained me the logic only rudimentary, but not in which tables or connections I can find the information, or which document flow I have to read (anyhow) and so on.

Does somebody coded something like this and can give me some advice how to? SAP function modules to read and anaylse it?

Thanks.

[HKany]

Hello coders,

I have the honor to code a liquidity forecast. Problem: this theme is bascally a SD theme, but I am FI. Nevertheless I have to code it - somehow, but I do not know how. Does anybody accidentally coded something like this? functionality: selection screen with document type, document number and a start date. Based on the start date the incoming payments are forecasted for 12 periods/months. To be considered: document flow, SD invoices, status of FI documents - payed or not.

With a little help from a colleague I nearly solved the forecast for order-related invoices with or without billing plan.

But now I have to implement it for delivery-related billing documents. It's all Greek to me. A SD consultant explained me the logic only rudimentary, but not in which tables or connections I can find the information, or which document flow I have to read (anyhow) and so on.

Does somebody coded something like this and can give me some advice how to? SAP function modules to read and anaylse it?

Thanks.

[Former Member]

Delivery data is in LIKP and LIPS...find the delivery by searching table VBFA with Sales Order doc/item, reading forward for proper next document type, or by looking back from LIPS (VGBEL, VGPOS). Consider that, in many or most instances, there may be more than one delivery document for a sales order, so the SO doc and item are significant to finding correct delivery. Like Sales Orders, tables VBUK and VBUP contain delivery status indicator data by document or document/item.

[HKany]

This report will never be finished because of a porous report description....