SQVI needing AUSP

[TedJ]

Hi All, First time posting. Looking for a little help here. 

Writing an SQVI and using following tables so far to pull data with no issues. MCHB, MCH1, LFA1, and MBEW, 

The remaining puzzle piece is to pull in AUSP - ATWRK, saw a post that stated to use MCH1 to AUSP but the CUOBJ-BM does not contain the 12 zeros that the OBJEK has. 

Any help would be greatly appreciated. 

TIA.

Ted from Boston

[raymond_giuseppi]

You may be required to create a dataset with SQ02 and some Abap to handle this kind of join with different type of join fields.

[Florian]

when I rmember correct there might be an menu to do so..

something like EXTRAS -> ADDITIONAL TABLE -> blahblah and specify the OBJEK = MATNR