Table for PO order and material document link

[Former Member]

Hello,

I want to extract PO order and respecitive material documents ( IR , GR docs.)

Can you give table(s) names ?

Thanks,

Ishak

[former_member184494 · Accepted solution]

EKBE will have the PO and PO Item with the material document number.

Another way would be to go to MSEG and the PO number is available there also - this will also give you information on the material document.

EKBE has a GR/IR Indicator which you can use to identify IR and GR...

[former_member181964]

Hi ,

You can use 2LIS_02_ITM ,2LIS_02_SCL DataSource you also check the following DataSources

2LIS_02_SCL Tables EKKO, EKBE, T001, T001W, EKET, EKPA.

2LIS_02_HDR Tables EKKO, EKBE, T001, EKPA.

2LIS_02_ITM Tables EKKO, EKBE, T001, T001W, EKPO, TMCLVBW, T027C, ESSR, T147K, T147

2LIS_02_SCN Tables EKET, EKES, EKPO.

2LIS_02_CGR Tables EKBE, EKES, EKPO.

2LIS_02_SGR Tables EKET, EKBE, KKPO

Thanks

REddy

[dennis_scoville4]

R3/ECC Table Names <--> Associated DataSources

EKKO - PO Header <--> 2LIS_02_HDR

EKPO - PO Line Item <--> 2LIS_02_ITM

EKET - PO Schedule Line <--> 2LIS_02_SCL

EKKN - PO Account Assignment <--> 2LIS_02_ACC (DataSource available starting with ECC6)

EKES - Vendor Confirmations <--> 2LIS_02_CGR

MSEG - Material Documents <--> 2LIS_03_BF

[Former Member]

Hello,

You can try EKPO and EKBE

Thanks

Geeta

Edited by: Geeta Sharma on Dec 8, 2009 4:53 PM