There is a problem here, in order to create a report on a table format, we have to "Normalized" the "BKICPMAT" table.
DBA tables where created in 1988? 1987?
This is what I mean:
http://en.wikipedia.org/wiki/Database_normalization The BKICPMAT table has the following structure:
SELECT
BKICPMAT.BKIC_PMAT_CUST,
BKICPMAT.BKIC_PMAT_PCODE,
BKICPMAT.BKIC_PMAT_PNUM,
BKICPMAT.BKIC_PMAT_RATE_1,
BKICPMAT.BKIC_PMAT_RATE_2,
BKICPMAT.BKIC_PMAT_RATE_3,
BKICPMAT.BKIC_PMAT_RATE_4,
etc, etc, etc
For each line there is a corresponding field on the table. That shouldn't be.
Any ways the reports is possible.
Kelloggs