Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Can't recognized my tables

Former Member
0 Kudos

HI! PLease help me out on this. Tables are correct but still there's something wrong of declaring on the form method. And it doesn't recognized the table. ON the

Error: The list "(GOVT_LIC-ID" after "INTO" is not of the form (f1, ...,fn), or contains an undefined field. excludes specification of a field list.

Code:

    • Licenses and Certificates

PERFORM lic_cert TABLES govt_lic certificate train_cert USING

employee_no.

FORM lic_cert TABLES govt_lic

certificate

train_cert

STRUCTURE zhr_bapi_pd_govt_lic

zhr_bapi_pd_certificate

zhr_bapi_pd_train_cert

USING employee_no.

      • PERSONAL ID INFOTYPE 185

DATA: lv_slabs TYPE slabs,

lv_subty TYPE subty,

lv_begda TYPE begda.

SELECT slabs

subty

begda

INTO (lv_slabs,

lv_subty,

lv_begda)

FROM PA0022

WHERE pernr = employee_no.

CASE lv_subty.

WHEN 'Z6'.

    • Get Government License

SELECT SINGLE slabs

stext

INTO (govt_lic-id,

govt_lic-text)

FROM t519t

WHERE sprsl = 'E'

AND slabs = lv_slabs.

govt_lic-begda = lv_begda.

APPEND govt_lic.

WHEN 'Z7'.

    • Get Certificate

SELECT SINGLE slabs

stext

INTO (certificate-id,

certificate-text)

FROM t519t

WHERE slabs = lv_slabs

AND sprsl = 'E'.

certificate-begda = lv_begda.

APPEND certificate.

WHEN 'Z8'.

      • Get Trainings/ Cetificates/ Seminars

SELECT SINGLE slart " Subtype Z8

insti " Conductor by

dptmt " Training Name

begda " Date Obtained

INTO (train_cert-type,

train_cert-insti,

train_cert-dept,

train_cert-begda)

FROM PA0022

WHERE pernr = employee_no

AND slart = lv_subty.

train_cert-begda = lv_begda.

APPEND train_cert.

ENDCASE.

CLEAR govt_lic.

CLEAR certificate.

CLEAR train_cert.

ENDSELECT.

ENDFORM. "lic_cert

1 ACCEPTED SOLUTION

Former Member
0 Kudos

Hi maui,

I think the form method declaration is incorrect.

Try this one.


PERFORM lic_cert
      TABLES govt_lic
             certificate
             train_cert
      USING  employee_no.

FORM lic_cert
        TABLES govt_lic STRUCTURE zhr_bapi_pd_govt_lic
               certificate STRUCTURE zhr_bapi_pd_certificate
               train_cert STRUCTURE zhr_bapi_pd_train_cert
        USING employee_no.

2 REPLIES 2

Former Member
0 Kudos

Hi maui,

I think the form method declaration is incorrect.

Try this one.


PERFORM lic_cert
      TABLES govt_lic
             certificate
             train_cert
      USING  employee_no.

FORM lic_cert
        TABLES govt_lic STRUCTURE zhr_bapi_pd_govt_lic
               certificate STRUCTURE zhr_bapi_pd_certificate
               train_cert STRUCTURE zhr_bapi_pd_train_cert
        USING employee_no.

Former Member
0 Kudos

What is the data statement for GOVT_LIC ?

It doesn't matter. Wenceslaus is correct - just add the structures in the form statement.

Rob

Message was edited by: Rob Burbank