topic Re: reg Date in Application Development and Automation Discussions

reg Date

mallikarjun_vaja — Mon, 06 Aug 2007 15:54:33 GMT

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

Re: reg Date

Former Member — Mon, 06 Aug 2007 16:00:46 GMT

write like this.

DATA : DATE LIKE SY-DATUM.

date = sy-datum - 2.

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.

Reward points for useful Answers

Regards

Anji

Re: reg Date

Former Member — Mon, 06 Aug 2007 16:03:16 GMT

Hi Vaja,

Use this.

DATA : DATE LIKE SY-DATUM.

date = sy-datum - 2.

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.

Regards,

Atish

Re: reg Date

mallikarjun_vaja — Mon, 06 Aug 2007 16:07:37 GMT

THANKS ....SOLVED PROBLEM.

GIVEN POINTS

Re: reg Date

mallikarjun_vaja — Mon, 06 Aug 2007 16:08:21 GMT

THANKS ....SOLVED PROBLEM.

GIVEN POINTS