Link with EKKO and BSIK

[nayanlad]

Dear All

can you tell me the relation link with

BSIK table and EKKO table.

note that purchase order no (EBELN) not often stored

in BSIK table

actual i need the payment terms as per PO and need to create the report of creditor aging so please any buddy can help me?

[bpawanchand]

Hi

Well if you want to know the relation ship between two tables

1. Execute SQVI

2. Enter name and press CREATE

3.Enter Title and in Data Source select TABLE JOIN.and enter

4.Press Shift + F1 ans enter the table name.

continue the step 4 and enter the table names for which you want to know the relation ship.

EKKO-BUKRS -------- BSIK-BUKRS
EKKO-LIFNR----------- BSIK-LIFNR
EKKO-AEDAT--------- BSIK-AUGDT
EKKO-EBELN--------- BSIK-EBELN

I hope this will help you

Regards

Pavan

[Former Member]

Look for more info around the fields BKPF-AWTYP and BKPF-AWKEY as these should have references to the originating MM document

[nayanlad]

THNKYOU

[Former Member]

Why dont you use standared ageing report tocde :S_ALR_87012085