Skip to Content
author's profile photo Former Member
Former Member

CATSDB in CATS0012

Hello,

I am trying to load SAPLXCAT 3000 using the following query in EXIT_SAPLCATS_012:

SELECT SINGLE * FROM catsdb
INTO CORRESPONDING FIELDS OF wa_catsdb
WHERE pernr = sap_catsfields-pernr
AND workdate = sap_catsfields-inputdate.

Regardless of whether I run the query wide open or with the where condition, it does not return any records. The field names match, sap_catsfields-pernr and sap_catsfields-inputdate are both populated, and there is test data in CATSDB. Any insight would be greatly appreciated. Also, I am aware that querying header data from CATSDB is not the most elegant solution, so if anyone knows where CAT2 header information is actually stored, please share. Thanks!

Torey

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Jul 29, 2014 at 02:20 PM

    Hi Torey,

    Use conversion exit to append zeros for Employee number before Select statement.

    sap_catsfields-pernr = '1234'

    "It will append zero to Employee Number

    CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'

    EXPORTING

    INPUT = sap_catsfields-pernr

    IMPORTING

    OUTPUT =sap_catsfields-pernr


    "Please write the select query here

    sap_catsfields-pernr = '000001234'.

    Regards

    Rajkumar Narasimman

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.