how to filter Billing Document Date

[Former Member]

Hello SAP Consultant

I'm using vbrk and vbrp to fetch the data according to selection screen. Also i'm using Billing Document no as vbrp-vbeln and Billing date vbrp-fkdate. But i'm not able to filter the data according to billing document date.

I'm using condition on vbeln fields exits in both the table vbrk and vbrp.

Plz help me <removed by moderator>.

Lot of thanks in advance.

Edited by: Thomas Zloch on Nov 27, 2010 2:21 PM - priority normalised

[Former Member]

Hi

You need to filter the header (VBRK) only and then get item in according to header:

SELECT * FROM VBRK 
     WHERE VBELN IN S_VBELN
            AND FKDATE IN S_DATE.
        SELECT * FROM VBAP WHERE VBELN = VBRK-VBELN
             ..........................

Max

[Former Member]

Hi

You need to filter the header (VBRK) only and then get item in according to header:

SELECT * FROM VBRK 
     WHERE VBELN IN S_VBELN
            AND FKDATE IN S_DATE.
        SELECT * FROM VBAP WHERE VBELN = VBRK-VBELN
             ..........................

Max