topic Re: Function Module for Documetn Flow Reading in Application Development and Automation Discussions

Function Module for Documetn Flow Reading

Former Member — Mon, 22 May 2006 08:55:32 GMT

Hello,

I have requirement to read the document flow of a sales document.

Actually i am using a select statement for the table VBFA. But then it is taking a very long time the performance is very bad.

I remember having used a fucntion module some time before but cant recall the name.

Kindly let me know if anyone of you know which is the function module to read the document flow of a sales document.

Thankyou.

Re: Function Module for Documetn Flow Reading

Former Member — Mon, 22 May 2006 09:05:16 GMT

Dear Brijesh,

You explain your correct requirement, and i shall say you which tables to use for the correct link and faster performance.

regards

Lakshminarayanan

Re: Function Module for Documetn Flow Reading

vinod_gunaware2 — Mon, 22 May 2006 09:09:47 GMT

RV_ORDER_FLOW_INFORMATION Reads sales document flow of sales document after delivery and billing

Don't forget also check direct reference documents for the both starting document # and preceding/following document types that you are searching for (For example, if you search delivery for the given SO, check also LIPS-VGBEL and LIPS-VGPOS, if it's possible with regard to performance).

regards

vinod

Re: Function Module for Documetn Flow Reading

Former Member — Mon, 22 May 2006 09:10:42 GMT

Hi Lakshminarayan,

The exact requirement is to fetch the shipment number i.e Shipment notfication number.

I have the delivery as the input, one more issue here is that for the delivery there would be a select option so if no select option then all the deliveries would be considered.

this is the code i have written

DATA : BEGIN OF g_t_tknum OCCURS 0,

vbelv LIKE likp-vbeln,

vbeln LIKE vttk-tknum,

shtyp LIKE vttk-shtyp,

END OF g_t_tknum.

SELECT vbelv vbeln

INTO CORRESPONDING FIELDS OF TABLE g_t_tknum

FROM vbfa

WHERE vbelv IN s_vbeln

AND posnv = '000000'

AND vbtyp_n = '8'

AND vbtyp_v = 'J'.

Re: Function Module for Documetn Flow Reading

Former Member — Mon, 22 May 2006 09:12:50 GMT

Hi,

check these FM's RV_FLOW

RV_ORDER_FLOW_INFORMATION

Regards

vijay

Re: Function Module for Documetn Flow Reading

Former Member — Mon, 22 May 2006 09:22:36 GMT

See for getting the shipment document against a delivery no, you can go to table VTTP, pass the delivery no into the field VTTP-VBELN.

You can get the shipment document.

For getting the transportation planning point plant you can put a join against VTTK and VTTP and get the field vttk-tplst. This field is same as the plant where order/delivery/invoice has been issued.

Hope this solves your issue.

Lakshminarayanan

Message was edited by: Lakshminarayanan Jagannathan

Re: Function Module for Documetn Flow Reading

Former Member — Mon, 22 May 2006 09:29:36 GMT

Hello Thanks a lot for all your inputs

Re: Function Module for Documetn Flow Reading

Former Member — Mon, 22 May 2006 09:40:44 GMT

Please rewars my first points if you got the solution right.

Re: Function Module for Documetn Flow Reading

Former Member — Mon, 22 May 2006 10:18:53 GMT

Thankyou,

i was not aware of this will keep it in mind from next time to rewaard the points.