Rprt

Former Member — Thu, 08 Feb 2007 07:36:03 GMT

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