Hi ,
check the below syntax.
SELECT SINGLE VORNA NACHN ANRED GESCH
INTO S_P0002
FROM PA0002 WHERE PERNR = 1.
W_VORNA = S_P0002-VORNA.
W_NACHN = S_P0002-NACHN.
SELECT SINGLE ANREX INTO W_ANREX FROM T522
WHERE ANRED = S_P0002-ANRED AND GESCH = S_P0002-GESCH.
SELECT SINGLE ORT01 STATE LAND1 INTO S_P0006
FROM PA0006 WHERE PERNR = 1.
W_ORT01 = S_P0006-ORT01.
SELECT SINGLE BEZEI INTO W_BEZEI FROM T005U
WHERE BLAND = S_P0006-STATE AND LAND1 = S_P0006-LAND1.
SELECT SINGLE INTERVIEW_DATE INTERVIEW_TIME
INTERVIEW_VENUE VACANCY_ID
INTO S_P9010 FROM PB9010 WHERE PERNR = 1.
W_INTERVIEW_DATE = S_P9010-INTERVIEW_DATE.
W_INTERVIEW_TIME = S_P9010-INTERVIEW_TIME.
W_INTERVIEW_VENUE = S_P9010-INTERVIEW_VENUE.
SELECT SINGLE PLSTX INTO W_PLSTX FROM T528T
WHERE PLANS = S_P9010-VACANCY_ID.
Bluesky
