Query creation

[Former Member]

Hi,

I have to Create query/report to compare the number of salesorders entered against the number of order confirmation documents sent by fax by taking the following selection criteria

Sales org

Distribution channel

Order type,

Creation date

Output type

Destination

Please let me know the Tables and fields that we have to use to creattion of query by taking above selection criteria

and Please explain the detailed process of creation of query.

Thanks in Advance

Venkat

[Former Member]

Please use tables VBAK, NAST and NACH.

To get the printer destination you have to first find the table associated with your output condition records for your output type. For that use transaction V V 13 enter the output type and then press F1->technical information to find out the table name that stores the output condition records. Typically it will be a table that starts with a B. B900 or B200 etc. Link condition record number of this B-table to NACH table to get the destination.

Sales org (VBAK)

Distribution channel (VBAK)

Order type (VBAK)

Creation date (VBAK)

Output type (NAST)

Destination (NACH and the B-Table)