extract data from PA0002

Former Member — Wed, 12 Sep 2007 07:17:17 GMT

Hi experts

I need a program to extract data from PA0002-INITS. it needs first get data from KNVP-PARVW, then to check table PA0002 to get INITS.

can anybody help me?

promise to reward points if helps.

thanks

elly

Re: extract data from PA0002

Former Member — Wed, 12 Sep 2007 08:03:42 GMT

Hmmmmm, don't unsderstand exactly the problem..........

Key for PA0002 is PERNR, so select your record from KNVP based on knvp-keys:

- KUNNR

- VKORG

- VTWEG

- SPART

- PARVW

This will give a you a KNVP-PERNR, with which you can address the PA0002 table and give you the right record.

I would do it like this:


DATA: lf_pernr TYPE pernr_d,
      lf_inits TYPE inits.

SELECT SINGLE pernr
  INTO lf_pernr
  FROM knvp
 WHERE kunnr = 'your CUSTNO'
   AND vkorg = 'your sales org'
   AND vtweg = 'your distr.chann'
   AND spart = 'your div'
   AND parvw = 'your partn. func'.
    
IF sy-subrc = 0.
  SELECT SINGLE inits
   INTO lf_inits
   FROM pa0002
 WHERE pernr = lf_pernr.
ENDIF.

topic extract data from PA0002 in Application Development and Automation Discussions

extract data from PA0002

Re: extract data from PA0002