Alternative For Select Queries

[Former Member]

H All,

Is there a way to extract sales doc. number of corresponding billing doc. number with out using select query in a report?

[Former Member]

H All,

Is there a way to extract sales doc. number of corresponding billing doc. number with out using select query in a report?

[Former Member]

hi Ravi chandra

use Views or SQVI- QUickView, SAP query ( SQ01 , SQ02 , SQ03)to get Report

Regards

Deva

[former_member585060]

U can use

READ TABLE dbtab [WITH KEY key] -- but it is Obsolute

Ex

PARAMETERS p TYPE c LENGTH 4 DEFAULT '100T'.

t100-sprsl = 'E'.

t100-arbgb = 'BC'.

t100-msgnr = '010'.

READ TABLE t100 SEARCH FKEQ VERSION p.

IF sy-subrc = 0.

...

ENDIF.

[Former Member]

You Can use :

BAPI

Views

SQVI

[Former Member]

Ravi,

Is there a way to extract sales doc. number of corresponding billing doc. number with out using select query in a report?

I want to take shower without getting Wet?

Try with BAPI_SALESORDER_GETDETAILBOS,and see the details from BAPISDFLOW structure.

Amit.

[Former Member]

Hi,

The best way is to search for view.

Search for standard views via SE11( search for standard(sales,billing) starts with which letter)

Another approach is search for BAPI'S all depends

on requirment.

Regards,

Naveen.