topic Re: Alternative For Select Queries in Application Development and Automation Discussions

Alternative For Select Queries

Former Member — Fri, 22 Aug 2008 05:22:12 GMT

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 — Fri, 22 Aug 2008 05:29:04 GMT

hi Ravi chandra

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

Regards

Deva

former_member585060 — Fri, 22 Aug 2008 05:34:09 GMT

U can use

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

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 — Fri, 22 Aug 2008 05:55:18 GMT

You Can use :

BAPI

Views

SQVI

Former Member — Fri, 22 Aug 2008 06:13:54 GMT

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 — Fri, 22 Aug 2008 12:23:50 GMT

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.