incrementing the date in a select statement

[Former Member]

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.

[Former Member]

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.

[naimesh_patel]

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

[Former Member]

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.