provide statement

[Former Member]

Moderator message: duplicate of this has been deleted. Please don't make double postings

hello guru,

i am facing the problem that

PROVIDE PERNR

ENAME

WERKS

BTRTL

BUKRS

PERSG

PERSK

ZZDESG

FROM P0001

PERNR

FAMSA

FAVOR

FGBDT FROM P0021

PERNR

USRTY

USRID_LONG FROM P0105

PERNR

NACHN

VORNA FROM P0002

BETWEEN PN-BEGDA AND PN-ENDDA.

endprovide.

here user need standard input screen of PNP ldb ant when he enters company code data must be accordingly it but if i enter company code 1000 it retrives data of company code 1000 as well as 9050.

how can i solve it?

thanks in advance.

Edited by: Matt on Nov 26, 2008 7:58 AM

Edited by: Matt on Nov 26, 2008 7:58 AM

[Former Member]

Hi,,,,,,,

Use Where Clause after Between statement....

PROVIDE PERNR
ENAME
WERKS
BTRTL
BUKRS
PERSG
PERSK
ZZDESG
FROM P0001
PERNR
FAMSA
FAVOR
FGBDT FROM P0021
PERNR
USRTY
USRID_LONG FROM P0105
PERNR
NACHN
VORNA FROM P0002
BETWEEN PN-BEGDA AND PN-ENDDA
WHERE CODE IN  COMPCODE >>>>>>>>> COMPANY CODE FIELD ON SELECTION SCREEN.
ENDPROVIDE. 

THANKS

SAURABH

[Former Member]

Are you using any HR REPORTING CATEGORY?

If yes, which one.

[Former Member]

no i am not using it i am only using LDB pnp.

[Former Member]

Use HR REPORTING CATEGORY ___00007

[Former Member]

NO FRIEND THOUGH I AM ENTERING COMPANY CODE 1000. IT RETRIVE DATA OF COMPANY CODE 9050 .

[Former Member]

Try using above reporting category, and see if it works fine.

Also check is your client is using concurrent employment concept.

[Former Member]

solved by self