04-19-2006 3:25 AM
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
04-19-2006 3:37 AM
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.
04-19-2006 3:37 AM
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.
04-19-2006 4:03 AM
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