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 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 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 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.
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.
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.
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.
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.
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.
Please log in again. The login page will open in a new tab. After logging in you can close it and return to this page.