ZDDSM Répertoire des tableaux
Par AMO
Contenu-Code
select trim(a.cdcode) "Code tableau", trim(b.liblon) "Libellé", c.daeff "Date d'effet", c.borinf "Borne inf.", c.borsup "Borne sup.", c.mtforf "Valeur", c.txpou1 "Pourcentage"
from zd00 a, zd01 b, zddj c
where a.nudoss = b.nudoss
and a.nudoss = c.nudoss
and a.cdregl = 'FDO'
and a.cdstco = 'DSM'
and a.cdcode = '&code_tableau'
order by a.cdcode, c.borinf ;
nota Penser à adapter le code réglementaire.