JVA report GJLI- View JV line items-Sapsharks

GJLI- View JV line items

GJLI is the go to report for Joint venture reporting. This will show you the line item details for jvs. This report shows the gross costs. 

Access through the menu path below or with the tcode GJLI.

 

This report gives you a lot of options, you can run this report by a joint venture, equity group account number etc.
There are many tabs to explore. Each of those has options that you can explore.
There are two check boxes at the bottom, billable and non billable. 
Uncheck the non billable checkbox if you only want to view billable items.

This report gives you a lot of options; you can run this report by a joint venture, equity group account number, etc.

There are many tabs to explore. Each of those has options that you can explore.

There are two checkboxes at the bottom, billable and non-billable. 

Uncheck the nonbillable checkbox if you only want to view billable items. 

 

and similarly, you can uncheck the billable flag in order to just view non billable items.

and similarly, you can uncheck the billable flag to just view nonbillable items.

(read this if you need to know what are billable items and other jva concepts)

 

You can restrict this report to a certain document number for e.g. by clicking on the document tab and enter the document number.

You can restrict this report to a few document numbers, e.g. by, clicking on the document tab and enter the document number(s).

 

There is also a section for JV information if you want to view certain jv documents.

There is also a section for JV information if you want to view certain JV documents. 

 

The account assignment tab gives you the ability to run this report by a certain G/L account or a cost center.

The account assignment tab gives you the ability to run this report by a csG/L account or a cost center. 

 

or if you want to restrict it by a certain posting date etc.

or if you want to restrict it by a certain posting date etc.

 

There are two radio buttons on the main page which affect your display.
Check the box for ALV grid. I prefer using this display. It makes it much easier to sort, total etc.

There are two radio buttons on the main page which affect your display.

Check the box for ALV grid. I prefer using this display. It makes it much easier to sort, total, etc. 

 

Click on execute after entering all the information and you will see the line items for this JV.

Click on execute after entering all the information, and you will see the line items for this JV.

 

The display above is the alv grid display.
Choose the other option of ALV list if you want to see how it looks.

The display above is the alv grid display.

Choose the other option of ALV list if you want to see how it looks. 

 

As you can see the display isn't as nice. You can't just click on a column and move it around. This is usually the default radio button that is checked.

As you can see the display isn’t as nice. You can’t just click on a column and move it around. This is usually the default radio button that is checked.

 

Click on the change layout icon to add any more fields.

Click on the change layout icon to add any more fields. 

 

Choose the fields you need just like you would do with any alv report.

Choose the fields you need just like you would do with any alv report.

 

GJLI runs off the table JVSO1. You can also use the table JVSO1 to fetch the same information. 
Enter the JV

GJLI runs off the table JVSO1. You can also use the table JVSO1 to fetch the same information. 

Enter the JV 

 

and hit execute. You will see the jv information. This is the same as what you would see in GJLI.

And hit execute. You will see the JV information. This is the same as what you would see in GJLI. 

 

>