Hierarchy
EA-FIN (Software Component) EA-FIN⤷
CA-JVA (Application Component) Joint Venture und Production Sharing Accounting⤷
GJV2 (Package) Joint Venture Development
IMG Activity
| ID | SIMG_TLS_0010 | Defining the JADE Report |
| Transaction Code | S_KK4_66000054 | IMG-Aktivität: SIMG_TLS_0010 |
| Created on | 19991013 | |
| Customizing Attributes | SIMG_TLS_0010 | Defining the JADE Report |
| Customizing Activity | SIMG_TLS_0010 | Defining the JADE Report |
Document
| Document Class | SIMG | Hypertext: Object Class - Class to which a document belongs. |
| Document Name | SIMG_TLS_0010 |
JVA offers a facility to support audit inquiries by non-operating partners of expenditures for ventures operated by the company running JVA. Audit inquiries are supported through the Joint Audit Data Exchange (JADE) report. This is essentially an extract file from the JVA expenditure ledger from which an Excel file is generated.
Example
Requirements
Standard settings
Recommendation
Activities
Extraction of the JADE file is executed on the JVA processing menu, but you must first define the fields to be included in the JADE file by performing the following tasks in JVA configuration:
- Define the formatting properties for the fields in the JADE extract file
- Define the JVA-relevant field movement activities and the field movements to be included in generation of the JADE extract file
- Define the detailed fields from the JVA summary ledger based on the field movements that will be included in the JADE extract file
Define Company Code Properties of JADE
The first step in configuring the JADE report is to define the display properties of the fields to be included in the extract file by entering the following information on the Field Movement for JADE - Header: Overview screen:
In the CC field, enter the code for the company for which the JADE file will be generated.
In the AmtLn field, enter the number indicating the length of the amount field in the JADE file.
In the Delimiter field, enter the character to be used to separate selected fields in the JADE file.
In the Surround field, enter the character to be printed at the beginning and end of selected fields in the JADE file.
The amounts included in the JADE file will consist of the number of characters that you specify in the AmtLn field on this screen. When you later define the fields to be included in the JADE extract file during the third step of configuring the JADE report, you can choose to invoke the delimiter you enter here in the Delimiter field. This will indicate that the field should be separated from adjoining fields on the report by the specified delimiter.
Define Field Movement Activities of JADE
The second step in configuring the JADE report is to define the field movement activities to be included in the extract file by entering the following information on the Field Movement for JADE - Usage: Overview screen:
In the Act. field, enter the code for the FI or Special Ledger activity whose data is to be included in the JADE extract file.
In the Ap. field, enter the code for the SAP application module whose data is to be included in the JADE extract file:
SAP Description
Application
Module
FI Financial Accounting
CO Controlling
MM Materials Management
In the No. field, enter the sequence number.
In the M. Name field, enter the user-defined code for the field movement to be included in the JADE extract file.
The Act. or activity field and the Ap. or SAP application field are mutually exclusive. You can either select specific activities whose information will be included in the extraction process for the JADE report, or you can specify an entire SAP application all of whose activities will be included in this process.
You may choose to define field movements depending on the activity. For example, if you wish to include certain data for FI postings in the JADE report, you might make the following entries on the Field Movement for JADE - Usage: Overview screen:
Act. Ap. No. M Name
RFBU Blank 1 FIPOST
RFBU is the field movement activity for FI postings. The Ap.. field is left blank because data is being selected for inclusion in the JADE extract file by activity rather than by SAP application module. The sequence number is used to identify the placement on the JADE report of data from this activity. In this example, the user has chosen to define a movement name of FIPOST for information derived from the FI posting activity RFBU.
The next step in configuring the JADE report will be to assign the specific data fields to the movement FIPOST. At execution of the JADE extraction on the JVA processing menu, data contained in the fields associated with FIPOST will be displayed in the extract file report.
Define the Detailed Fields of JADE
The third step in configuring the JADE report is to define the detailed fields to be included in the extract file report. In this step, you will associate all fields to be included in the report with the field movement you defined on the JADE - Usage screen. You can connect detailed fields to a field movement by entering the following information on the Field Movement for JADE - Details: Overview screen:
In the No. field, enter the sequence number determining the order of display of the field in the JADE extract file.
In the Send Field field, enter the name of the sending field from which data to be included in the JADE extract file is to be derived.
Enter an X in the S field as an indicator that the character specified in the Surround field on the Field Movement for JADE - Header: Overview screen should print before and after the data for this field in the JADE extract file.
Enter an X in the D field as an indicator that the character specified in the Delimiter field on the Field Movement for JADE - Header: Overview screen should print between this field and other data fields in the JADE extract file.
Specifying Sending Fields for JADE
This screen allows you to select fields for inclusion in the JADE extract file for each field movement. You may select any fields in the JVSO1 table, the Joint Venture Line Item Table with Objects for the JVTO1 Table, to be included in the JADE extract file. You can also include the following MM information: purchase order (PO), goods receipt (GR), invoice receipt (IR) as well as the JIB/JIBE class and subclass and the cost object number.
Relationship between Field Movement and Sending Fields
To access the sending fields assigned to a field movement or to assign new fields to a movement on the Field Movement for JADE - Details: Overview screen, you must select a field movement on the Field Movement for JADE - Usage: Overview screen (or enter the selected field movement on a pop-up when prompted).
You should define unique field movements for different activities or SAP applications. If you assign the same movement to two activities on the JADE - Usage screen, the sending fields you assign to that movement will apply to both activities.
You may use the pick list through F4 to review the available sending fields for the selected field movement. This will display a complete list of all sending fields in JVSO1 as well as the additional fields described above. Not all these available sending fields will be needed to meet your audit requirements. Before defining the sending fields whose data will be included in the JADE report, you should determine what data is needed to meet your audit requirements.
The intention of the the JADE extract file report is to support COPAS and PASC audit requirements. You may select any field available through F4 to the Send Field on the JADE - Details screen to any movement you define.
Further notes
Business Attributes
| ASAP Roadmap ID | 207 | Establish Reporting |
| Mandatory / Optional | 2 | Optional activity |
| Critical / Non-Critical | 1 | Critical |
| Country-Dependency | A | Valid for all countries |
Assigned Application Components
| Documentation Object Class | Documentation Object Name | Current line number | Application Component | Application Component Name |
|---|---|---|---|---|
| SIMG | SIMG_TLS_0010 | 0 | ALR0002181 | Joint Venture und Production Sharing Accounting |
Maintenance Objects
| Maintenance object type | C | Customizing Object |
| Assigned objects | ||||||
|---|---|---|---|---|---|---|
| Customizing Object | Object Type | Transaction Code | Sub-object | Do not Summarize | Skip Subset Dialog Box | Description for multiple selections |
| VC_T8JMHDR | C - View cluster | GJJ3 | TLS_0010 | JADE file description |
History
| Last changed by/on | SAP | 20010306 |
| SAP Release Created in |
