SELECT BRID00,MRN000,BRBLH0,YBKH00,YBID00,YBLB00,BRXM00,BRXB00,
BRXX00, BRCSRQ,BRHYZK,BRZY00,BRMZ00,BRGJ00,BRZJLX,BRZJBH,FBBH00,
BRGFZH, BRDYFW,BRDH00,BRJTDZ,BRYB00,TYDWID,TYDWMC,BRLXGX,BRLXXM,
BRLXDZ,BRLXDH,BRZTQK, BRJKQK,BRLX00,CZY000,CZRQ00,CZSJ00, SHR000,
SHRQ00,RYCS00,CYQKJE,ZYZT00,SFYX00,BZ0000 
FROM VW_BM_BRXXB_MZBR00 
WHERE BRID00=6582