Selection Field Value Options Restriction for SAP Query

[Former Member]

Hi all,

I have created a SAP Query Report having "Sales Document" as a selection field.

However, when I clicked the value options button nearby the "Sales Document" Selection Field, system listed out all sales related docs, including sales quotations, sales orders, delivery notes and so on.

I only expect the Sales orders numbers to be input the "Sales Document" selection Field. Could anyone tell me how to set the restrictions so that only sales order numbers are listed at the value option list?

Cheers,

Simon

[Former Member]

hi simon,

Create a search help for the sales document in se11 transaction and use it while declaring in selection screen.

then when you click the value option button you will get only sales document.

for example.

SELECTION-SCREEN : BEGIN OF SCREEN 9001.

SELECT-OPTIONS matnr FOR mara-matnr MATCHCODE OBJECT z451mat .

SELECTION-SCREEN END OF SCREEN 9001.

rewardif useful

Regards,

Sivakumar.B

[Former Member]

Hi All

PLZ see this file is very nice

SQ01 is the transaction

http://www.olemiss.edu/projects/sap/SQ01_10_03.pdf

Regards;

Rakan ALDossary