10-11-2007 9:39 AM
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
10-11-2007 9:49 AM
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
10-11-2007 9:49 AM
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
10-11-2007 9:50 AM
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...
10-11-2007 10:24 AM
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)