datum problem

[Former Member]

hi experts !

there is a program for displaying domestic sales figures as per

customer/document type/Invoice wise.

input data for report is

Company code

DOCUMENT TYPE

START DATE & END DATE

FINANCIAL YEAR.

problem is in date when i entered date 01.05.07 to 04.05.07 or 02.05.07 to 05.05.07 or 02.05.07 to 06.05.07 its taking data for all 3 line items in invoice and showing correct data. but if date is 01.05.07 to 05.05.07 or 01.05.07 to 06.05.07 its taking data for two line items leaving 1st line item in invoice . Date for these invoice creation is 02.05.07, its showing correct data for it . but not showing correct data in some date intervals(i.e its taking data for two line items leaving 1st line item in invoice ) . for other invoices its giving correct data except in this specific doc.no. otherwise it is correct . can anybody help me why its showing incorrect data for only one specific doc.no.

code for date is

i have checked fb03 and its showing correct 3 line items in invoice

FORM FORM_COLLECT_BKPF.

SELECT BUKRS BELNR GJAHR BLDAT BUDAT BLART XBLNR BKTXT USNAM CPUDT

CPUTM FROM BKPF

INTO CORRESPONDING FIELDS OF TABLE IT_BKPF

WHERE BUKRS = PR_BUKRS

AND GJAHR = PR_GJAHR

AND BLART IN SO_BLART

AND BUDAT IN SO_BUDAT

AND XREVERSAL = ''

AND BSTAT = ''.

IF IT_BKPF[] IS INIT

[Former Member]

Such long questions are not practical. and not easy to understand.

Sorry because this is not an answer you wait.

[JozsefSzikszai]

hi ranjna,

if I understand right this is one document with three line items. In this case the problem is not with the BKPF selection, but with the line item selections. Pls. check your code or copy it here and people can have a look.

hope this helps

ec