SELECT TOP {0}
                                LTRIM(RTRIM(p.AKFIRM)) AKFIRM
                                , LTRIM(RTRIM(p.AKIBNR)) AKIBNR
                                , LTRIM(RTRIM(p.AKTXT1)) AKTXT1
                                , LTRIM(RTRIM(ba.PVORT)) PVORT
                                , p.AKZZY21
                                , p.AKZZY13
                                , p.AKZZSTL
                                --, LTRIM(RTRIM(SUBSTRING(f_cvttbsatz(stat.tbtbgr,stat.tbsart,stat.tbsatz), 1, 35))) STATUS_DE
                                --, LTRIM(RTRIM(SUBSTRING(f_cvttbsatz(staten.tbtbgr,staten.tbsart,staten.tbsatz), 1, 35))) STATUS_EN
                                , 'STATUS_DE' STATUS_DE
                                , 'STATUS_EN' STATUS_EN
                                , LTRIM(RTRIM(personal.T9MAIL)) T9MAIL
                                , LTRIM(RTRIM(personal.T9KNAV)) T9KNAV
                                , LTRIM(RTRIM(personal.T9KNAM)) T9KNAM
                                , LTRIM(RTRIM(personal.T9WBEN)) T9WBEN
                                , LTRIM(RTRIM(AKPRJL)) AKPRJL
                                , LTRIM(RTRIM(AKZZBAU)) AKZZBAU
                                , LTRIM(RTRIM(AKZZMOL)) AKZZMOL
                                , LTRIM(RTRIM(personal2.T9MAIL)) T9MAIL2
                                , LTRIM(RTRIM(personal2.T9KNAV)) T9KNAV2
                                , LTRIM(RTRIM(personal2.T9KNAM)) T9KNAM2
                                , LTRIM(RTRIM(personal2.T9WBEN)) T9WBEN2
                                , LTRIM(RTRIM(personal3.T9MAIL)) T9MAIL3
                                , LTRIM(RTRIM(personal3.T9KNAV)) T9KNAV3
                                , LTRIM(RTRIM(personal3.T9KNAM)) T9KNAM3
                                , LTRIM(RTRIM(personal3.T9WBEN)) T9WBEN3
                            FROM
                                BAKPFP p
                                LEFT JOIN BPVTLP ba ON p.AKFIRM = ba.PVFIRM AND p.AKIBNR = ba.PVIBNR AND ba.PVXFKN = 'BA'
                                LEFT JOIN TBPOSP stat ON (stat.TBFIRM = p.AKFIRM AND stat.TBRKEY = p.AKZZSTL AND stat.TBTBGR = 'LIN' AND stat.TBSART = 'ANS' AND stat.TBSPRA = '')
                                LEFT JOIN TBPOSP staten ON (staten.TBFIRM = p.AKFIRM AND staten.TBRKEY = p.AKZZSTL AND staten.TBTBGR = 'LIN' AND staten.TBSART = 'ANS' AND staten.TBSPRA = 'EN')
                                LEFT JOIN ZTPS9P personal1 ON personal1.T9SAKZ = p.AKPRJL AND personal1.T9AUSG <> 'J' AND LTRIM(RTRIM(p.AKPRJL)) <> '' AND LTRIM(RTRIM(personal1.T9WBEN)) <> ''
                                LEFT JOIN ZTPS9P personal2 ON personal2.T9SAKZ = p.AKZZBAU AND personal2.T9AUSG <> 'J' AND LTRIM(RTRIM(p.AKZZBAU)) <> '' AND LTRIM(RTRIM(personal2.T9WBEN)) <> ''
                                LEFT JOIN ZTPS9P personal3 ON personal3.T9SAKZ = p.AKZZMOL AND personal3.T9AUSG <> 'J' AND LTRIM(RTRIM(p.AKZZMOL)) <> '' AND LTRIM(RTRIM(personal3.T9WBEN)) <> ''
                                {1}