reg Date

[mallikarjun_vaja]

hi,

I want to print the values of records past 2 days from today.

I have given select stmt in this way.

I am getting error.

Can u plz correct me.

DATA : DATE LIKE SY-DATUM.

SELECT BUKRS BELNR GJAHR AUGCP AUGBL WRBTR

WMWST LIFNR SKNTO EBELN NEBTR

FROM BSEG

INTO TABLE I_BSEG1

FOR ALL ENTRIES IN I_COVP

WHERE BUKRS = I_COVP-REFBK

AND BELNR = I_COVP-REFBN

AND GJAHR = I_COVP-REFGJ

AND AUGCP = DATE - 2.

WAITNG FOR UR ANSWERS

Regards

Vaja

[Former Member]

Hi

write like this.

DATA : DATE LIKE SY-DATUM.

<b>date = sy-datum - 2.</b>

if not I_COVP[] is initial.

SELECT BUKRS BELNR GJAHR AUGCP AUGBL WRBTR

WMWST LIFNR SKNTO EBELN NEBTR

FROM BSEG

INTO TABLE I_BSEG1

FOR ALL ENTRIES IN I_COVP

WHERE BUKRS = I_COVP-REFBK

AND BELNR = I_COVP-REFBN

AND GJAHR = I_COVP-REFGJ

AND AUGCP = DATE.

endif.

<b>Reward points for useful Answers</b>

Regards

Anji

[mallikarjun_vaja]

THANKS ....SOLVED PROBLEM.

GIVEN POINTS

[Former Member]

Hi Vaja,

Use this.

DATA : DATE LIKE SY-DATUM.

<b>date = sy-datum - 2.</b>

SELECT BUKRS BELNR GJAHR AUGCP AUGBL WRBTR

WMWST LIFNR SKNTO EBELN NEBTR

FROM BSEG

INTO TABLE I_BSEG1

FOR ALL ENTRIES IN I_COVP

WHERE BUKRS = I_COVP-REFBK

AND BELNR = I_COVP-REFBN

AND GJAHR = I_COVP-REFGJ

<b>AND AUGCP = DATE.</b>

Regards,

Atish

[mallikarjun_vaja]

THANKS ....SOLVED PROBLEM.

GIVEN POINTS