topic Re: Data from Z-table in Application Development and Automation Discussions

Data from Z-table

Former Member — Mon, 23 Oct 2006 17:44:18 GMT

Hi ,

My requireent is as follows . I have a z-table for which company code (BUKRS) is the only keyfield . Now I need to dislpay a list of all company codes which are in t001 but not on the z-table .

This is my follwoing code :

TABLES: t001, zfinfc .


DATA : BEGIN OF t_bukrs OCCURS 0 ,
       bukrs LIKE zfinfc-bukrs ,
       END OF t_bukrs .


DATA : w_bukrs LIKE t001-bukrs .

SELECT * FROM t001 INTO CORRESPONDING FIELDS OF TABLE t_bukrs .

LOOP AT t_bukrs .
  SELECT SINGLE bukrs FROM zfinfc INTO w_bukrs
                      WHERE bukrs EQ t_bukrs-bukrs .

  IF sy-subrc NE 0  .
    WRITE :/ t_bukrs-bukrs .
  ENDIF .
ENDLOOP .

Can anyone suggest me if there is any other way to do this instead of the above procedure . IS ther any select statement which does that .

Regards ,

Daniel .

Re: Data from Z-table

Former Member — Mon, 23 Oct 2006 17:54:33 GMT

You can try this...

Regards,

Raj

TABLES: t001, zfinfc .

DATA : BEGIN OF t_zfinfc OCCURS 0 ,

bukrs LIKE t001-bukrs ,

END OF t_zfinfc .

TABLES: t001, zfinfc .

DATA : BEGIN OF t_bukrs OCCURS 0 ,

bukrs LIKE zfinfc-bukrs ,

END OF t_bukrs .

SELECT bukrs FROM t001 INTO CORRESPONDING FIELDS OF TABLE t_bukrs .

if not t_bukrs[] is initial.

sort t_bukrs by bukrs.

endif.

*- Get data from Ztable

SELECT bukrs FROM zfinfc INTO CORRESPONDING FIELDS OF TABLE t_zfinfc .

if not t_zfinfc[] is initial.

sort t_zfinfc by bukrs.

endif.

loop at t_bukrs.

clear t_zfinfc.

read table t_zfinfc with key bukrs = t_bukrs-bukrs.

if sy-subrc <> 0.

WRITE 😕 t_bukrs-bukrs .

endif.

endloop.

Re: Data from Z-table

messier31 — Mon, 23 Oct 2006 17:56:43 GMT

Hi Daniel,

Just out this

select * from t001 into corresponding fields of itab

for all entries in ztable where

bukrs <> ztable-bukrs.

Enjoy SAP.

Pankaj Singh.

Re: Data from Z-table

Former Member — Mon, 23 Oct 2006 17:56:45 GMT

U can try to do this:

RANGES: R_BUKRS FOR T001-BUKRS.

SELECT BUKRS INTO R_BUKRS-LOW FROM ZFINC.

R_BUKRS(3) = 'EEQ'.

APPEND R_BUKRS.

ENDSELECT.

SELECT * FROM t001 INTO CORRESPONDING FIELDS OF TABLE t_bukrs WHERE BUKRS IN R_BUKRS.

LOOP AT t_bukrs .

WRITE 😕 t_bukrs-bukrs .

ENDLOOP.

I think your solution is good so: choose the best one

Max

Re: Data from Z-table

Former Member — Mon, 23 Oct 2006 18:05:09 GMT

Hi,

Check this..

DATA: T_T001 LIKE T001 OCCURS 0 WITH HEADER LINE.

SELECT BUKRS FROM T001

INTO TABLE T_T001

WHERE NOT EXISTS (

SELECT * FROM ZFINFC

WHERE BUKRS = T001~BUKRS ).

LOOP AT T_T001.

WRITE: / T_T001-BUKRS.

ENDLOOP.

Re: Data from Z-table

Former Member — Mon, 23 Oct 2006 18:13:21 GMT

Hi ,

The replies provided by Narendran and Pankaj did not work for me . Anyway thank you all for your time and suggestions .

Thanks and Regards ,

Daniel .

Re: Data from Z-table

Former Member — Mon, 23 Oct 2006 18:19:08 GMT

Hi,

The reason is I missed INTO CORRESPONDIND FIELDS OF

SELECT BUKRS FROM T001

INTO <b>CORRESPONDING FIELDS OF</b> TABLE T_T001

WHERE NOT EXISTS (

SELECT * FROM ZFINFC

WHERE BUKRS = T001~BUKRS ).

LOOP AT T_T001.

WRITE: / T_T001-BUKRS.

ENDLOOP.

Please check it and let me know if it is working..

Thanks,

Naren

Re: Data from Z-table

Former Member — Mon, 23 Oct 2006 18:20:17 GMT

Hi Daniel

Naren solution is very good, he uses SQL stataments aren't usually used in SAP.

See the <a href="http://help.sap.com/saphelp_nw2004s/helpdata/en/fc/eb3a1f358411d1829f0000e829fbfe/content.htm">help</a>

Max

Re: Data from Z-table

Former Member — Mon, 23 Oct 2006 18:25:40 GMT

Hi Max,

I got this from SAP Help..

Check this link..

http://help.sap.com/saphelp_nw2004s/helpdata/en/dc/dc7614099b11d295320000e8353423/content.htm

Thanks,

Naren

Re: Data from Z-table

Former Member — Mon, 23 Oct 2006 18:30:15 GMT

Hi Naren

I've jut found it.

Thanks very much.

Max

Re: Data from Z-table

Former Member — Mon, 23 Oct 2006 18:33:42 GMT

Hi ,

Thank you Narendra for your solution .

Max, thank you for guiding me to a very good solution .

Regards ,

Daniel .