topic Reg: Data Dictionary in Application Development and Automation Discussions

Reg: Data Dictionary

Former Member — Wed, 22 Nov 2006 16:39:28 GMT

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

Re: Reg: Data Dictionary

Former Member — Wed, 22 Nov 2006 16:43:36 GMT

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

Re: Reg: Data Dictionary

Former Member — Wed, 22 Nov 2006 16:45:09 GMT

Start with LFA1, LFB1, BSIK, BSAK.

Rob

Re: Reg: Data Dictionary

Former Member — Wed, 22 Nov 2006 16:48:21 GMT

Hi,

Vendor Number 1001895 EKKO-LIFNR

Vendor Name Intergraph Corp. - [bLFA1-NAME1]

Purchasing Grp LI EKKO-EKGRP

PO Number 4300749552 EKKO-EBELN

PO Release Date 28-Jul-05

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

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

Invoice no. 5100001502 EKBE-BELNR WHERE EKBE-VGABE = 2

Invoice date 26-Jan-06 EKBE-BUDAT

Invoice Amt. 123456.00 EKBE-WRBTR

Invoice Currency GBP EKBE-WAERS

Payment terms 0001 EKKO-ZTERM

Payment due date 26-Jan-06

Payment Document no. 1500003200

Payment date 26-Jan-06

Aging in Days (paid before due date) 0 - Calculated

Aging in Days (paid after due date) - Calculated

Aging in Days (Difference in release PO date and payment date) - Calculated

Thanks,

Naren

Re: Reg: Data Dictionary

Former Member — Wed, 22 Nov 2006 16:49:02 GMT

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.

Re: Reg: Data Dictionary

Former Member — Wed, 22 Nov 2006 17:14:04 GMT

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