07-29-2014 3:15 PM
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
07-29-2014 3: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