Reg: Data Dictionary

[Former Member]

Hi,

I need to get this following as output. But for some fields I am not sure, from which table is available. Could any one assist me with the table and field name for all the fields.

Vendor Number 1001895

Vendor Name Intergraph Corp.

Purchasing Grp LI

PO Number 4300749552

PO Release Date 28-Jul-05

Goods Receipt Document/Service Entry sheet no. 5000001324

Goods Receipt Date/ Service entry sheet date 2-Jan-06

Invoice no. 5100001502

Invoice date 26-Jan-06

Invoice Amt. 123456.00

Invoice Currency GBP

Payment terms 0001

Payment due date 26-Jan-06

Payment Document no. 1500003200

Payment date 26-Jan-06

Aging in Days (paid before due date) 0

Aging in Days (paid after due date)

Aging in Days (Difference in release PO date and payment date) 185

Thanks & Regards

Reddy

[Former Member]

You should be able to get the values between EKPO, EKKO, EKBE, MSEG tables.

As EKBE is the history table, you should be able find most of the data there.

Regards,

Ravi

[Former Member]

Start with LFA1, LFB1, BSIK, BSAK.

Rob

[Former Member]

Hi,

Vendor Number 1001895 <b>EKKO-LIFNR</b>

Vendor Name Intergraph Corp. - [bLFA1-NAME1]</b>

Purchasing Grp LI <b>EKKO-EKGRP</b>

PO Number 4300749552 <b>EKKO-EBELN</b>

PO Release Date 28-Jul-05

Goods Receipt Document/Service Entry sheet no. 5000001324 <b>EKBE-BELNR WHERE EKBE-VGABE = 1</b>

Goods Receipt Date/ Service entry sheet date 2-Jan-06 <b>EKBE-BUDAT</b>

Invoice no. 5100001502 <b>EKBE-BELNR WHERE EKBE-VGABE = 2</b>

Invoice date 26-Jan-06 <b>EKBE-BUDAT</b>

Invoice Amt. 123456.00 <b>EKBE-WRBTR</b>

Invoice Currency GBP <b>EKBE-WAERS</b>

Payment terms 0001 <b>EKKO-ZTERM</b>

Payment due date 26-Jan-06

Payment Document no. 1500003200

Payment date 26-Jan-06

Aging in Days (paid before due date) 0 - <b>Calculated</b>

Aging in Days (paid after due date) - <b>Calculated</b>

Aging in Days (Difference in release PO date and payment date) - <b>Calculated</b>

Thanks,

Naren

[Former Member]

Hi,

Could you please tell me from which table I can get this fields. I am confusing here only.

PO Release Date

Payment due date

Payment Document no.

Payment date

Regards

Reddy

[Former Member]

Hi,

Vendor infor -> LFA1/ LFB1

PO infor ->EKKO/EKPO.

Invoice Info -> VBAK/ VBAP

Gd Rec - > pl Check in MSEG

If sounds good pl reward.

Cheers.