‎2008 Mar 29 10:56 AM
Hi Frds
Im getting dump error in given below program...
can anyone correct my mistake .
DATA : COM_NO LIKE PRPS-PBUKR,
BUSS LIKE PRPS-PGSBR,
WBS LIKE PRPS-PSPHI.
SELECTION-SCREEN: BEGIN OF BLOCK 01.
SELECTION-SCREEN: BEGIN OF BLOCK 02 WITH FRAME .
SELECT-OPTIONS COMPANY FOR COM_NO.
SELECT-OPTIONS BUS_AREA FOR BUSS.
SELECT-OPTIONS WBS_NO FOR WBS.
SELECTION-SCREEN: END OF BLOCK 02.
SELECTION-SCREEN: END OF BLOCK 01.
DATA : BEGIN OF IPRPS OCCURS 0,
PBUKR LIKE PRPS-PBUKR,
PGSBR LIKE PRPS-PGSBR,
PSPHI LIKE PRPS-PSPHI,
END OF IPRPS.
SELECT PBUKR PGSBR POSID FROM PRPS APPENDING TABLE IPRPS
WHERE PBUKR IN COMPANY AND
PGSBR IN BUS_AREA AND
PSPHI IN WBS_NO.
WRITE:/ IPRPS-PBUKR ,IPRPS-PGSBR ,IPRPS-PSPHI.
‎2008 Mar 29 11:12 AM
Hi,
I the select query u r fetching the posid from prps but it is storing in the field psphi which is ther in the internal table IPRPS.
So declare the same field name in internal table which u want to retrieve.I mean to say code vl b as follows.
data : begin of iprps occurs 0,
pbukr like prps-pbukr,
pgsbr like prps-pgsbr,
psphi like prps-psphi,
end of iprps.
select pbukr pgsbr psphi
appending table iprps
from prps
where pbukr in company
and pgsbr in bus_area
and psphi in wbs_no.
Thanks & Regards,
R.P.Sastry
‎2008 Mar 29 11:15 AM
HAI PARI JSUT CHANGE THE CODE IN THIS WAY U WILL GET IT
DATA : COM_NO LIKE PRPS-PBUKR,
BUSS LIKE PRPS-PGSBR,
WBS LIKE PRPS-PSPHI.
SELECTION-SCREEN: BEGIN OF BLOCK 01.
SELECTION-SCREEN: BEGIN OF BLOCK 02 WITH FRAME .
SELECT-OPTIONS COMPANY FOR COM_NO.
SELECT-OPTIONS BUS_AREA FOR BUSS.
SELECT-OPTIONS WBS_NO FOR WBS.
SELECTION-SCREEN: END OF BLOCK 02.
SELECTION-SCREEN: END OF BLOCK 01.
DATA : BEGIN OF IPRPS OCCURS 0,
PBUKR LIKE PRPS-PBUKR,
PGSBR LIKE PRPS-PGSBR,
PSPHI LIKE PRPS-PSPHI,
END OF IPRPS.
SELECT PBUKR PGSBR POSID FROM PRPS APPENDING CORRESPONDING FIELDS OF TABLE IPRPS
WHERE PBUKR IN COMPANY AND
PGSBR IN BUS_AREA AND
PSPHI IN WBS_NO.
WRITE:/ IPRPS-PBUKR ,IPRPS-PGSBR ,IPRPS-PSPHI.
‎2008 Mar 29 11:19 AM
hi do like this..
report .
DATA : COM_NO LIKE PRPS-PBUKR,
BUSS LIKE PRPS-PGSBR,
WBS LIKE PRPS-PSPHI.
SELECTION-SCREEN: BEGIN OF BLOCK 01.
SELECTION-SCREEN: BEGIN OF BLOCK 02 WITH FRAME .
SELECT-OPTIONS COMPANY FOR COM_NO.
SELECT-OPTIONS BUS_AREA FOR BUSS.
SELECT-OPTIONS WBS_NO FOR WBS.
SELECTION-SCREEN: END OF BLOCK 02.
SELECTION-SCREEN: END OF BLOCK 01.
DATA : BEGIN OF IPRPS OCCURS 0,
PBUKR LIKE PRPS-PBUKR,
PGSBR LIKE PRPS-PGSBR,
PSPHI LIKE PRPS-PSPHI,
END OF IPRPS.
SELECT PBUKR PGSBR POSID FROM PRPS
into APPENDING corresponding fields of TABLE IPRPS
WHERE PBUKR IN COMPANY AND
PGSBR IN BUS_AREA AND
PSPHI IN WBS_NO.
WRITE:/ IPRPS-PBUKR ,IPRPS-PGSBR ,IPRPS-PSPHI.
regards,
venkat.
‎2008 Mar 29 11:35 AM
Try the below code
DATA : COM_NO LIKE PRPS-PBUKR,
BUSS LIKE PRPS-PGSBR,
WBS LIKE PRPS-PSPHI.
SELECTION-SCREEN: BEGIN OF BLOCK 01.
SELECTION-SCREEN: BEGIN OF BLOCK 02 WITH FRAME .
SELECT-OPTIONS COMPANY FOR COM_NO.
SELECT-OPTIONS BUS_AREA FOR BUSS.
SELECT-OPTIONS WBS_NO FOR WBS.
SELECTION-SCREEN: END OF BLOCK 02.
SELECTION-SCREEN: END OF BLOCK 01.
DATA : BEGIN OF IPRPS OCCURS 0,
PBUKR LIKE PRPS-PBUKR,
PGSBR LIKE PRPS-PGSBR,
PSPHI LIKE PRPS-PSPHI,
END OF IPRPS.
SELECT PBUKR PGSBR POSID FROM PRPS INTO CORRESPONDING FIELDS OF TABLE IPRPS
WHERE PBUKR IN COMPANY AND
PGSBR IN BUS_AREA AND
PSPHI IN WBS_NO.
WRITE:/ IPRPS-PBUKR ,IPRPS-PGSBR ,IPRPS-PSPHI.
Regards,
Chandru
‎2008 Mar 29 1:22 PM
Hi,
The structure declared by you is
DATA : BEGIN OF IPRPS OCCURS 0,
PBUKR LIKE PRPS-PBUKR,
PGSBR LIKE PRPS-PGSBR,
PSPHI LIKE PRPS-PSPHI,
END OF IPRPS.
but in your select query you have selected the field 'POSID' which is not in the declared structure IPRPS,
SELECT PBUKR PGSBR POSID FROM PRPS APPENDING TABLE IPRPS
WHERE PBUKR IN COMPANY AND
PGSBR IN BUS_AREA AND
PSPHI IN WBS_NO.
Regards,
Jeniphin
Edited by: Jeniphin on Mar 29, 2008 2:23 PM