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)
The Cost center code which is the output from BSEG above has to be looked into below structures for the cost center group which it belongs, as we need report to be divided into two parts.(1) CATERING_E – catering cost JET class (2) CATERING_F – catering cost First class
Thus each of Expense head has to be print in two section based on the cost center group.
Cost center group structures – GRPVALUES, GRPOBJECTS, GRPDYNP
The Service tax has to be find out from GL 27611002, once the vendors are known from BSEG. This for each vendor the cumulative amount of service tax in this GL has to be summarize for the period give in initial screen.
The vendor names also needs to be fetched up from LFA1 by vendor code found from BSEG, and to be printed on report.
The sequence of searching data for GL accounts must be same as above and also sequence of heads in report should be same as in report layout below.
The report display for two parts(JET class & JET First clss) is shown below
Report – Catering Service Expenses
Date From -
To------
JET Class
Expense Head Vendor 1 Vendor 2 Vendor 3 Vendor 4 Vendor 5 Vendor 6 Vendor 7
F&B
Handling
Hi- Lift
Stores
Off_Loading
Laundry
Srv Tax
Total Rs
Date From -
To------
JET First
Expense Head Vendor 1 Vendor 2 Vendor 3 Vendor 4 Vendor 5 Vendor 6 Vendor 7
F&B
Handling
Hi- Lift
Stores
Off_Loading
Laundry
Srv Tax
Total Rs
Bluesky
