sorry,
here
create table GLCTA
(
IDN char(4),
KARA char(2),
KCTR char(2),
DCAT varchar(50) not null
)
go
insert into GLCTA
select '0099','01','06','Eme3Prodcat2x'
union all
select '0099','01','07','Eme4Prod'
union all
select '0099','02','07','Eme4Prod'