Data retrieve

[Former Member]

hi,

I want to retrieve the data from the different tables for the vendor invoice

here is the list of tables and fields

BKPF---- BKTXT, XBLNR, BLDAT, CPUDT, BLART, USNAM, PPNAM,

MONAT, GJAHR, BURKS ( WITH THE KEYS -- BURKS, BELNR,

GJAHR)

BSEG- WRBTR, BELNR ( KEY----BUKRS, BLENR, GJAHR, BUZEI)

LFA1- LIFNR, NAME1 ( KEY--LIFNR)

EKKO- EBELN (KEY EBELN)

T001W- WERKS ( KEY WERKS)

Pls some one help to do this task its bit urgent

SIRI

[Former Member]

Hi,

What is the selection criterio. What are the field available to you based on which you want to retrieve these data.

Please clarify.

Regards,

RS

[Former Member]

RS,

selection screen includes all the select options...

BSEG -

---

BUKRS,

BKPF-- GJAHR, MONAT, USNAM, PPNAM, CPUDT, BLART, BKTXT,

EKKO--- EBELN,

LFA1- LIFNR, NAME1

T001W-- WERKS

can help me solve this RS..

SIRI

[Former Member]

Hi,

One more question.

Are these fields mandatory? Or user may enter only one value in any one selection veriable and you want to retrieve other information.

I think some fields should mandatory. I does not make sense that user enters BKTXT or NOMAT or GJAHR or PPNAM or NAME1 and the report should give all the data.

Please let me know what are the different combination use may enter selection field value for.

Regards,

RS

[Former Member]

There is no mandatory field in the above list RS

there r three differnet radio buttons like whether the invoice is parked or open or close i think this is the filed from vbuk table

VBUK-GBSTK = A/B/C

C -- complete

B -partial

A --not yet processed

can u give the proper performance wise better code RS

SIRI