topic Re: provide statement in Application Development and Automation Discussions

provide statement

Former Member — Wed, 26 Nov 2008 05:29:26 GMT

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

Re: provide statement

Former Member — Wed, 26 Nov 2008 05:41:19 GMT

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

Re: provide statement

Former Member — Wed, 26 Nov 2008 05:42:58 GMT

Are you using any HR REPORTING CATEGORY?

If yes, which one.

Re: provide statement

Former Member — Wed, 26 Nov 2008 05:46:28 GMT

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

Re: provide statement

Former Member — Wed, 26 Nov 2008 05:50:29 GMT

Use HR REPORTING CATEGORY ___00007

Re: provide statement

Former Member — Wed, 26 Nov 2008 05:53:45 GMT

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

Re: provide statement

Former Member — Wed, 26 Nov 2008 05:55:38 GMT

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

Also check is your client is using concurrent employment concept.

Re: provide statement

Former Member — Thu, 04 Dec 2008 09:03:02 GMT

solved by self