Skip to Content
0
Apr 17, 2014 at 01:26 PM

Selection and display of data.

19 Views

Hi Gurus.

I have:

Table ztbfi_card

key - BUKRS

key - GSBER

key - BAND

key - DTRECE

key - CDOPER

I want all fields.

Table vbrk

key - vbeln parametro de tela

FKART parametro de tela.

I want the fields VBELN AND FKART.

Table KNA1

key - KUNNR parametro de tela.

I want the fields NAME1 AND KUNNR

Table BSEG

key -BUKRS

key -BELNR

key -GJAHR

key -BUZEI

I want the fields ZUONR and SGTXT.

I need show in my alv the fields and all of ztbfi_card :

VBRK

FKART

VBRK

VBELN

KNA1

KUNNR

KNA1

NAME1

BSEG

ZUONR

BSEG

SGTXT

I did :

SELECT kunnr

FROM kna1

INTO TABLE t_kna1

WHERE kunnr IN s_kunnr.

IF sy-subrc <> 0.

MESSAGE i000(zsd_001).

v_mark = 'X'.

ENDIF.

SELECT vbeln

fkart

FROM vbrk

INTO TABLE t_vbrk

WHERE vbeln IN s_vbeln

AND fkart IN s_fkart.



SELECT * FROM ztbfi_card

INTO TABLE t_ztbfi_card

WHERE bukrs EQ p_bukrs

AND gsber IN s_gsber.




1- are the selects correct?

2-How Can I relate this data os different tables?to show in my ALV.

3-In ztbfi_card I don´t use all keys in select because i don´t have their, its problem ?

4-More suggestions.


Thanks.