Enhancement need for Goods in Transit Finished Goods in Month End Report

[Former Member]

Hi gurus,

I have to write the report for goods in transist finished goods in month end report. Please see the requirement and advise me for the developing program.

1) The program will process the input data the same way the fs10n transaction processes it. The program should select the outstanding balance of the period by which the report is being run.

2) Customization starts after FS10n using the input parameters, have produced an output. From the output the program should select the references (BKPF-XBLNR) of the documents with document type (BKPF-BLART) WL Goods Issue/Delivery. Program should search each reference entry in table VBUK. The report output should display delivery documents with the following status:

Picking (VBUK-KOSTK): C (Fully picked)

Goods Issue (VBUK-WBSTK): C (Completed)

IntcoBill VBUK-FKIVK : A (Not yet processed)

3) Once the delivery documents created within the time frame required that have not yet been billed have been identified, the program should look into the following tables for the data needed in the output report as follows:

Sales Division Customer Customer Name Country Delivery No.

SKU Qty Amount in loc. Currency (CNY)

Thanks,

venky.

[Former Member]

Hi Venky,

You can submit the program RFGLBALANCE(prog name for transactopn code FS10N) as follows and save the results in internal table and do the formatting part or logic as mentioned by you and show the result as per your requirement.

SUBMIT RFGLBALANCE ...... { [EXPORTING LIST TO MEMORY] AND RETURN.

The list is stored in the ABAP Memory as an internal table of the row type ABAPLIST, ABAPLIST being a structured data type in the ABAP Dictionary.

The calling program can access the list stored once program access is completed, using function modules belonging to the function group SLST.

The function module LIST_FROM_MEMORY loads the list from the ABAP Memory to an internal table of the row type ABAPLIST.

Hope the above logic will work.

Reward points if useful.

Thanks,

Ravi Kanth.M

[Former Member]

Hi Ravikanth,

Can you explain the full details of logic. I have copyied RFGLBALANCE program but I am not understanding where should keep the my logic.

Please advise me for that one. I will give rewards points.

Thanks & Regards,

Venky