EXO - Report on Analysis Codes

Hi Shadoxity ,

You'll want to talk to your Business Partner for indepth reporting help, but in terms of the data structure:

The ANALYSIS table holds the individual Code names/Seqnos

The ANALYSIS_TYPES table holds a key to the different types.

The ANALYSIS_MATRIX table holds the actual links between things.

Example of the ANALYSIS, ANALYSIS_TYPES and ANALYSIS_MATRIX tables

So you can join ANALYSIS and SALESORD_LINES using something like:
Select * from SALESORD_LINES

INNER JOIN ANALYSIS_MATRIX ON ANALYSIS_MATRIX.TRAN_SEQNO=SALESORD_LINES.SEQNO AND ANALYSIS_MATRIX.TRAN_TYPE='L'

INNER JOIN ANALYSIS ON ANALYSIS.SEQNO=ANALYSIS_MATRIX.CODE_SEQNO

Note, the above is a very rough approximation of the syntax, and is the extent of help I can provide.  Your Business Partner will be available to assist if you need further help with analysis codes or report writing.