select

[Former Member]

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

[Former Member]

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

[Former Member]

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...

[Former Member]

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)