topic Data retrieve in Application Development and Automation Discussions

Data retrieve

Former Member — Thu, 19 Apr 2007 20:01:39 GMT

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

Re: Data retrieve

Former Member — Thu, 19 Apr 2007 20:36:05 GMT

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,

Re: Data retrieve

Former Member — Thu, 19 Apr 2007 20:45:58 GMT

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

Re: Data retrieve

Former Member — Thu, 19 Apr 2007 20:52:43 GMT

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,

Re: Data retrieve

Former Member — Thu, 19 Apr 2007 21:04:58 GMT

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