Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Can't recognized my tables

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

Tags:
replied

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.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question