Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Alternative For Select Queries

Former Member

‎08-22-2008 6:22 AM

0 Kudos

H All,

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

5 REPLIES 5

Former Member

‎08-22-2008 6:29 AM

0 Kudos

hi Ravi chandra

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

Regards

Deva

former_member585060
Active Contributor

‎08-22-2008 6:34 AM

0 Kudos

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

‎08-22-2008 6:55 AM

0 Kudos

You Can use :

BAPI

Views

SQVI

former_member181995
Active Contributor

‎08-22-2008 7:13 AM

0 Kudos

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

‎08-22-2008 1:23 PM

0 Kudos

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.