How to use table inside a BADI implementation

[Former Member]

Hi Friends,

I have to use one BADI (implementing it) in which I need to pull some data from different database tables but it is not allowing me write TABLES syntax.

So how do we extract data from database apart from using select single.

Thanks,

pradeep

Note : I will reward points to useful answers only.

[Former Member]

Hi Friends,

I have to use one BADI (implementing it) in which I need to pull some data from different database tables but it is not allowing me write TABLES syntax.

So how do we extract data from database apart from using select single.

Thanks,

pradeep

Note : I will reward points to useful answers only.

[uwe_schieferstein]

Hello Pradeep

You have to use (or define) table types,e.g.:

METHOD my_method.

DATA:
  ls_knb1     TYPE knb1,
  lt_knb1      TYPE STANDARD TABLE OF knb1.


  SELECT * FROM knb1 INTO TABLE lt_knb1.

  LOOP AT lt_knb1 INTO ls_knb1.
    " do processing of customer data
  ENDLOOP.

ENDMETHOD.

Note: the same is true for itab's as instance attributes.

Regards

Uwe