PROVIDE SYNTAX?

[Former Member]

Hi,

If i take one infotype data we are taking like this...

PROVIDE * FROM P0002 BETWEEN PN-BEGDA AND PN-ENDDA.

WRITE: P0002-PERNR, P0002-NACHN, P0002-VORNA.

ENDPROVIDE.

But i want multiple infotypes data like 0000,0006,0008....?Give me the syntax of that provide stmt with multiple infotypes?

Thanks

Sree

[Former Member]

Hi ,

check the below syntax.

SELECT SINGLE VORNA NACHN ANRED GESCH

INTO S_P0002

FROM PA0002 WHERE PERNR = 1.

W_VORNA = S_P0002-VORNA.

W_NACHN = S_P0002-NACHN.

SELECT SINGLE ANREX INTO W_ANREX FROM T522

WHERE ANRED = S_P0002-ANRED AND GESCH = S_P0002-GESCH.

SELECT SINGLE ORT01 STATE LAND1 INTO S_P0006

FROM PA0006 WHERE PERNR = 1.

W_ORT01 = S_P0006-ORT01.

SELECT SINGLE BEZEI INTO W_BEZEI FROM T005U

WHERE BLAND = S_P0006-STATE AND LAND1 = S_P0006-LAND1.

SELECT SINGLE INTERVIEW_DATE INTERVIEW_TIME

INTERVIEW_VENUE VACANCY_ID

INTO S_P9010 FROM PB9010 WHERE PERNR = 1.

W_INTERVIEW_DATE = S_P9010-INTERVIEW_DATE.

W_INTERVIEW_TIME = S_P9010-INTERVIEW_TIME.

W_INTERVIEW_VENUE = S_P9010-INTERVIEW_VENUE.

SELECT SINGLE PLSTX INTO W_PLSTX FROM T528T

WHERE PLANS = S_P9010-VACANCY_ID.

[Former Member]

Hi Sree,

The infotype records are imported to internal tables Pnnnn (for example, P0006 for infotype 0006).These tables are then processed in a PROVIDE-ENDPROVIDE loop.

Syntax for retrieving data from multiple infotypes using PROVIDE:

GET PERNR.

PROVIDE * FROM P0002

• FROM P0006

BETWEEN PN-BEGDA AND PN-ENDDA

WHERE P0006-SUBTY = '1'.

IF P0006_VALID = 'X'.

WRITE...

ENDIF.

ENDPROVIDE.

PROVIDE STELL

ENAME FROM P0001

GBDAT FROM P0002

BETWEEN PN-BEGDA AND PN-ENDDA.

WRITE: P0001-ENAME,

P0002-GBDAT.

ENDPROVIDE.

<b>reward points if found useful.</b>

[Former Member]

Thanks Prem Raj , its helpfull.