How to create a Quick-view table

[Former Member]

Hi, experts,

How can I create a Quick-view that include following information:

1. Billing doc no.

2. All delivery no. that link to this billing doc

3. Material in the delivery

4. item no. in the delivery

5. each item's qty

Hope u can tell me the table name and which data field I should use.

Thanks.

[Former Member · Accepted solution]

Join VBRP and LIPS on

VBRP-VGBEL = LIPS-VBELN

VBRG-POSNR = LIPS-POSNR

Fields:

1. Billing doc no. <b> VBRP-VBELN</b>

2. All delivery no. that link to this billing doc <b>VBRP-VGBEL</b>

3. Material in the delivery <b>LIPS-MATNR</b>

4. item no. in the delivery <b>LIPS-POSNR</b>

5. each item's qty <b>LIPS-LFIMG</b>