BSEG

[Former Member]

Hi experts

Which fields can I use from BSEG and BKPF for vendor number, invoice number and vendors banking details.

Thanx for your assistance.

[Former Member]

Hi ,

Use table BSID, BSAD

Regards,

Vijay

[Former Member]

HI,

In BSEG you can use LIFNR for vendor number and BELNR for document number. For vendor banking details u can refer table PAYR

Regards,

Satish

[anuj_srivastava]

Hi ,

Use tables BSIK , BSID , BSAK and BSAD for fetching the details for vendor ( field is LIFNR ) and Document ( field is BELNR).

For fetchin Bank details to go table LFBK and BNKA.

Regards,

Anuj

[Former Member]

Hi Beatrice Nkomo

BSEG is cluster table... it contains huge data.. so if possible checkout below tables you will get the information required from these tables also... there may be performance issue if you will fetch data from BSEG

BSAK ==> Accounting: Secondary Index for Vendors (Cleared items)

BSIK ==> Accounting: Secondary Index for Vendors

LIFNR ==> Vendor

BELNR ==> Accounting Document Number

Relation :

BSAK-BELNR = BKPF-BELNR

BSAK-GJAHR = BKPF-GJAHR

Hope it will solve your problem..

Thanks & Regards

ilesh 24x7

ilesh Nandaniya

[Former Member]

Hi,

To bseg Pass Belnr BUKRs and GJAHR other wise the performance issue will coem..

and Use the same for BKPF table to fetch..

    SELECT bukrs belnr gjahr buzei mwskz zuonr saknr kunnr
            FROM bseg
            INTO TABLE t_bseg
            WHERE belnr = w_belnr      "Document Number or Invoice number
            and  bukrs  = 'IE34'              "Company code
            AND gjahr IN s_gjahr  .       "Fiscial year
If sy-subrc = 0.
* Fetching BKPF Data
  SELECT bukrs belnr gjahr blart bldat budat
         wwert waers xblnr
           FROM bkpf INTO TABLE t_bkpf
           FOR ALL ENTRIES IN t_bseg
           WHERE bukrs = t_bseg-bukrs
           AND   belnr = t_bseg-belnr
           AND   gjahr = t_bseg-gjahr.
  IF sy-subrc = 0.
  Endif.
ENDIF.

Prabhudas