EXO - Report on Analysis Codes
- 5 years ago
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.
So you can join ANALYSIS and SALESORD_LINES using something like:
Select * from SALESORD_LINESINNER 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.