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)