<b>PLS HELP. I am a newbie.</b> I have 3 tables. The WA-PRODUCT field is not appearing. I am suppose to get "POLO" output but the result is blank. Please see the image below:
Please help. <b>Thanks.</b>
.............................................................
data: begin of WA, CUSTID like ZCUSTPROFILE-CUSTID, CUSTFNAME like ZCUSTPROFILE-CUSTFNAME, PRODUCTID like ZORDER-PRODUCTID, PRODUCT like ZPRODUCT-PRODNAME, end of WA. data: ITAB like table of WA. select ZC~CUSTID ZC~CUSTFNAME ZO~PRODUCTID ZP~PRODNAME from ( ( ZCUSTPROFILE as ZC inner join ZORDER as ZO on ZO~CUSTID = ZC~CUSTID ) inner join ZPRODUCT as ZP on ZO~PRODUCTID = ZP~PRODUCTID ) into corresponding fields of table ITAB where ZC~CUSTID = 3. loop at ITAB into WA. write: / WA-CUSTID, WA-CUSTFNAME, WA-PRODUCTID, WA-PRODUCT. endloop.