Skip to Content
0
Oct 03, 2007 at 12:06 AM

Select Statement

10 Views

Can Some one guide me how to write a single select statement for following requirement.

Selection screen:

(Fields are all optional however one must be selected in order for the program to run)

- ASN No (LIKP-VBELN)

- Sales order No (VBAK-VBELN)

- Customer no

- Sales Org

- Dist Channel

- Division

- Material no

- Date Range From & to (date defined as ASN creation date)

And output should be as follows

Sold to Party Customer Name (ADDR1 – NAME1)

Customer PO number (VBKD-BSTDK) Sales Document number (VBAK-VBELN)

<i>Reward points will be awared</i>

Regards

Ria

Delivery Document number (LIKP-VBELN) Material id (LIPS-MATNR)

Description (LIPS-ARLTX)

SSCC #(Custom table) Pallet Qty(Custom table)

best before Date(Custom table) Pallet Type(Custom table)<i></i>