how to filter Billing Document Date

Former Member — Sat, 27 Nov 2010 11:27:11 GMT

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

Re: how to filter Billing Document Date

Former Member — Sat, 27 Nov 2010 15:16:37 GMT

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

topic Re: how to filter Billing Document Date in Application Development and Automation Discussions

how to filter Billing Document Date

Re: how to filter Billing Document Date