Selection and display of data.

[ronaldo_aparecido]

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 :

1º	VBRK	FKART
2º	VBRK	VBELN
3º	KNA1	KUNNR
4º	KNA1	NAME1
5º	BSEG	ZUONR
6º	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.

[ThomasZloch]

Who handed you this requirement? What is the purpose of this report?

Can he/she not explain you what they think the logical relation between these snippets of data is supposed to be?

Thomas

[VenkatRamesh_V]

Sir,

By Assumption i think Billing Type and Billing Doc as Selection Criteria.

Linking Between tables.

VBRK-KUNAG = KNA1-kunnr.

then use concatenate  vbrk-vbeln and vbrk-gjahr  into lv_ref (  lv_ref type bkpf-awkey ).

then use bkpf table using lv_ref.

then link Bkpf  table with  ''belnr'''  field to Bseg table ''belnr''  Field

then link Bseg-gsber  to ztbfi_card-gsber.

Regards,

Venkatramesh.V

[ronaldo_aparecido]

Thanks for help Thomas.

The report displays the data and then you can manually cancel the sale to the administrator of the credit card.

But I  need  show the especific fields to user sees if the data needs to be deleted.

[Jelena]

Not sure it's reasonable to expect a meaningful response regarding a custom table on SCN. How could we possibly know the design and purpose of it? This should be taken back to the person who is supposed to provide the requirements. If after that there is still a specific technical question then please update the discussion.

[ronaldo_aparecido]

Thanks Jelena

I am talking with functional and he is analizing the table relation.