Skip to Content
0
Former Member
Dec 12, 2007 at 06:51 PM

A table field is not showing.

17 Views

<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:

see" target="_blank">http://i150.photobucket.com/albums/s116/painkiller2007/23drt56g543g67hr/sap_table001.jpg">see image

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.