RESB and EKKO and EKPO

[Former Member]

Hi all,

When PR convert to PO, the pur order document field in RESB not updated. Why the field exist in the RESB but no being used ?

I was trying to link RESB to EKKO , EKPO, any idea how to link ?

Thanks .

[bpawanchand]

Hi

I have found a link between RESB, EKKO and EKPO but how far it can help you just check it out

RESB-EBELN ==== EKKO-EBELN

now store a result ina internal table and now try to link EKKO and EKPO based on two fields using FOR ALL ENTRIES in the internal table,

EKKO-EBELN ===== EKPO-EBELN

EKKO-LPONR ===== EKPO-EBELP

Regards

Pavan

[Former Member]

Refer EBAN table to know the link between the PR and PO.

EKBE is a PO history table, contains all the links between the PO and other documents.

Regrads,

Kiran Bobbala

[Former Member]

HI,

To find link between any 2 or more tables:

1) Go to SQVI transaction.

2) Create a quick view ztest.

3) Give description.

4) Select data source as table join. Enter

5) Now one screen will come with blank data (blue screen)

6) Enter <Table1> and <Table2>.

8) Click on define condition.

9) Now an image will come with links between <Table1> and <Table2>.

Regards,

Swati