Report through PML concept required.

In a pipe i have much atta(NAME -BQ001,BQ002........BQ189).structure name of atta is like(BQ001/SUP, BQ002/SUP,........BQ189/SUP,) AND  Some atta does not have its own structure.

On this case I need to extract a report from PDMS as below.

need below report concept through PML .

Name of atta ; bore of atta  ; stru name       ; type(stru frmw mem)  ; SPREF OF STRU

BQ001          ; 50                 ; BQ001/SUP   ; SCTN                         ; /XXXXXX

BQ001          ; 50                 ; BQ001/SUP   ; SCTN                         ; /ZZZZZZZ

BQ001          ; 50                 ; BQ001/SUP   ; PANE                         ; /YYYYYY

BQ002          ; 50                 ;              -         ;     -                              ;        -            ( AS NO OWN STRU )

THANKS ALL