topic Re: select in Application Development and Automation Discussions

select

Former Member — Thu, 11 Oct 2007 08:39:54 GMT

Hi all

i want to write a code where i need to extract the data on the basis of Business Partner active as on 10/10 for the following roles ... Landlord, Payee, and Notice Recipient .

Please advice how do i use select and where clause for the same.

urgent help is appreciated.

thanks

Re: select

Former Member — Thu, 11 Oct 2007 08:49:30 GMT

Use,

Select * from table into itab where <datefieldname> GT (10102007) and <rolefieldname> in ('landlord','payee','Notice recipient').

Pls reward if helpful.

Message was edited by:

Shori

Re: select

Former Member — Thu, 11 Oct 2007 08:50:58 GMT

Hi shwetha,

The table vbpa defines the partner functions example <b>Landlord, Payee, and Notice Recipient</b> for a particular document example sales order . So we need to put a query on that particular data base table with the partner function key in the

<b>where</b> cluase . For example...

Select * from vbak

where KUNNR = vbpa-KUNNR .

Hope this will give u some idea... Reward points if u feel usefull...

Re: select

Former Member — Thu, 11 Oct 2007 09:24:43 GMT

SELECT KNVV~KUNNR

FROM

KNVV

INNER JOIN VBPA

ON KNVV~KUNNR = VBPA-KUNNR

WHERE

VBPA~PARVW IN ( PAYER, LANDLORD, PAYEE) AND

( KNVV~LOEVM NE 'X' OR

KNVV~ AUFSD NE 'X' OR

KNVV~LIFSD NE 'X' OR

KNVV~FAKSD NE 'X' OR

KNVV~CASSD NE 'X' ).

REWARD IF USEFUL.

AMIT SINGLA

HERE :

LOEVM "Deletion flag for customer (sales level)

AUFSD Customer order block (sales area)

LIFSD Customer delivery block (sales area)

FAKSD Billing block for customer (sales and distribution)

CASSD Sales block for customer (sales area)