Skip to Content
0
Former Member
Feb 08, 2007 at 09:34 AM

Report

49 Views

Hi! I am giving you the prog logic. anybody could help me out to develop a program for that.

Thanks.

SELECTION SCREEN:

Following fields will be available on initial screen of report.

Field Name Tech Name Range Field status

Doc Date BLDAT From -To -- Mandatory

Vendor LIFNR From -


To----- optional

SAP TABLES:

TABLES:BSEG, LFA1,MAKT are to be used for having output of report.

Report has to be run for specific GL accounts only which are to be hard coded in the program logic. Based on user’s input “Range of Date” all the documents within the range are to be selected along with below criteria from Table BKPF

Transaction code = “ML81N”

If user enters vendor range then select vendors (input values) from Table BSEG after selecting documents from BKPF based on date & TC as above.

Once the Document are selected from BKPF give as input to BSEG along with below list of GL account (field- HKONT) Below GL to be hard coded in program.

1001 Services - Catering -Food/Beverages

1002 Services - Catering - Hi Lift

1003 Services - Catering - Handling

1004 Services - Catering - Stores

1005 Services - Catering - Laundry

1006 Services - Catering – Offloading

Based on above selection the output data from BSEG will be-

Vendor Cost Centre Amount in LC

(LIFNR) (KOSTL) (DMBTR)