topic Re: incrementing the date in a select statement in Application Development and Automation Discussions

incrementing the date in a select statement

Former Member — Mon, 28 Aug 2006 14:45:21 GMT

SELECT AFKO_{AUFNR AFKO}PLNBEZ AFKO_{GAMNG AFKO}GLTRP

MARA_{BISMT VBAK}AUDAT VBAP~KWMENG

VBEP~MBDAT

INTO CORRESPONDING FIELDS OF ITAB

FROM AFKO

INNER JOIN MARA ON MARA_{MATNR = AFKO}PLNBEZ

INNER JOIN VBAP ON VBAP_{MATNR = MARA}MATNR

INNER JOIN VBAK ON VBAK_{VBELN = VBAP}VBELN

INNER JOIN VBEP ON VBEP_{VBELN = VBAP}VBELN

WHERE AFKO~AUFNR IN S_AUFNR and AFKO-GLTRP + 2 = VBAK-AUDAT.

I need to increment the date of afko-gltrp by 2 how can i do that in a select statement.

Re: incrementing the date in a select statement

naimesh_patel — Mon, 28 Aug 2006 14:53:42 GMT

Hello,

Do like this,

SELECT AFKO_{AUFNR AFKO}PLNBEZ AFKO_{GAMNG AFKO}GLTRP

MARA_{BISMT VBAK}AUDAT VBAP~KWMENG

VBEP~MBDAT

INTO CORRESPONDING FIELDS OF ITAB

FROM AFKO

INNER JOIN MARA ON MARA_{MATNR = AFKO}PLNBEZ

INNER JOIN VBAP ON VBAP_{MATNR = MARA}MATNR

INNER JOIN VBAK ON VBAK_{VBELN = VBAP}VBELN

INNER JOIN VBEP ON VBEP_{VBELN = VBAP}VBELN

WHERE AFKO~AUFNR IN S_AUFNR and <b>AFKO-GLTRP = ( VBAK-AUDAT - 2 ).</b>

regards,

Naimesh

Re: incrementing the date in a select statement

Former Member — Mon, 28 Aug 2006 14:55:32 GMT

Hi,

you certainly get an error message because you try to modify the selection parameters in AFKO, when you have to modify the values as your selection criteria.

It must be something like this:

data: MYAUDAT like VBAK-AUDAT.

MYAUDAT = VBAK-AUDAT + 2.

WHERE AFKO~AUFNR IN S_AUFNR and AFKO-GLTRP = MYAUDAT.