Is there any table instead of RSEG table ?

[Former Member]

Linking the shipment cost document item to the purchase order to the AP document: ( My functional consultant suggested me like below ) :

The purchase order number and reference number is stored on the line item of the shipment cost document. So, I have to use the value in table-field VFKP-EBELN (purchase order number on the shipment cost document) to determine the purchase order number and table-field VFKP-EXTI1 to determine the reference number for that shipment cost item. I need to take that purchase order number and lookup in table-field RSEG-EBELN (purchase order number) and take the reference number for that shipment cost item and look up in table-field RSEG-XBLNR. Return table-field RSEG-BELNR (AP doc number) for that combination.

He said lile below :

RSEG is a huge table, and there certainly may be a better way to do it.

Could anybody suggest me, instead of RSEG table is there any other alternative table to do this better way ?

[Former Member]

Hi Sam Kumar,

You can use the BSAK --Accounting: for Vendors (Cleared Items)

BSAS Accounting: for G/L Accounts (Cleared Items).

Thses tables we are having the secondary indexes.

BKPF_BSIK_AEDAT View these is based up on the AEDAT.

Thanks & Regards,

Nelson

Reward with Points if the Answer is really Heplfull.

[Former Member]

Hi,

get BELNR(material Doc ) from EKBE where BEWTP = 'E' for the PO.

Regards,

Bhaskar