topic Reading Posting Documents in Application Development and Automation Discussions

Reading Posting Documents

Former Member — Thu, 28 Jul 2005 15:44:48 GMT

Hi all,

is there anyway to read posting documents in CO?

if so can someone point me in the right direction on how to do this from a programming aspect.

SAP reads them through transaction pcp0, I was wondering how I could do this through a programming aspect.

thanks.

Re: Reading Posting Documents

RichHeilman — Thu, 28 Jul 2005 15:46:17 GMT

You could do a SQL trace on transaction pcp0. This will tell you the tables that it is hitting.

Regards,

Rich Heilman

Re: Reading Posting Documents

RichHeilman — Thu, 28 Jul 2005 15:49:34 GMT

Check the following tables in these select statements. These statements I pulled directly out of that transaction.




  SELECT PEVST~TYPE PEVST~RUNID PEVST~NAME PEVST~SIMU H1~STATUS
         H2~CREATOR H2~CREADATE H2~CREATIME
         INTO CORRESPONDING FIELDS OF TABLE RUNTAB
<b>         FROM PEVST JOIN PEVSH AS H1 ON  H1~TYPE  = PEVST~TYPE
                                     AND H1~RUNID = PEVST~RUNID
                    JOIN PEVSH AS H2 ON  H2~TYPE  = PEVST~TYPE
                                     AND H2~RUNID = PEVST~RUNID</b>
        WHERE PEVST~TYPE IN VALID_TYPES
         AND   H1~ACTUAL = 'X'
         AND   H2~SEQNO = '00'
         ORDER BY PEVST~TYPE PEVST~RUNID.

  SELECT TYPE RUNID ATTR VALUE
         INTO TABLE ATTRIBUTES
<b>         FROM PEVAT</b>
         WHERE TYPE IN VALID_TYPES
*        AND   ATTR IN ('AKPER', 'SPECRUN')               "PF_2002/05/21
*        new attribute BEGDAENDDA: Only used by type PF
         AND   ATTR IN ('AKPER', 'SPECRUN', 'BEGDAENDDA') "PF_2002/05/21
         AND   ID = '00'
         ORDER BY TYPE RUNID.

Regards

Rich Heilman

Message was edited by: Rich Heilman