BI Requirement from MM

[former_member506901]

Hi experts,

I am a BI consultant.

I am extracting purchasing data into BI system. For this i have some fields from Purchase Order which i am unable to extract from R/3 to BI.

I want to know the names of the tables where these fields are existing as per SAP.

If you can guide me in providing atleast names of the tables for some fields is also very helpful to me.

The fields are:

SORT1 Search Term ( Vendor )

SORT2 Search Term ( Vendor )

MWSKZ Tax code

KBETR Condition amount

KWERT Condition Value

AZBET Display Amount

VALVT Value date (Check date)

ZUONR Assignment number

BELNR Accounting Doc no.

BLART Document Type

DMSHB Amount in Local currency with +/- sign

QBSHB withholding tax amount in doc.currency

AUGBL Doc. No. of the clearing document.

DWERT Differnce value

ABLAD Unloading point

LFSNR No. of External delivery note

FRBNR No. of Bill of lading at time of GR

LFBNR Document no of Reference document

ZTERM Terms of payment key

RBLGP Document item in Invoice Doc

No. of External delivery note

BANFN Purchase requisition no.

BADAT Requisition (Request) Date

SAKTO GL Acc no.

ERFMG Quantity in unit of Entry

LSMNG Quantity in unit of measure from delivery note

NORMT Industry standerd description

WRKST Basic material

ZEINR Doc. No.

GROES Size / dimension

BISMT old material no.

EXTWG External material group

VPRSV Price control indicator

WT_QSSHB withholding tax amount in doc.currency BASE AMT. IN

WT_WITHCD wiholding tax code

WT_TYPE Name of withholding tax type

LIFRE Different invoicing party

KTONR acc. No

Full points will be awarded.

Regards,

Nishuv.

[Former Member]

Hi,

Check the following tables

MARA-Material master

EKPO-Purchase Order item

EBAN -Purchase Requisition

EKKO-Purchase Order header

MSEG- Document Segment: Material

BSEG-Accounting Document Segment

LFA1- Vendor

LFB1- Vendor

KONV-Conditions (Transaction Data)

KONP-Conditions (Item)

EINA-Purchase inforecord.

RSEG-Document Item: Incoming Invoice.

Regards

Ravi shankar.

Edited by: Ravi Shankar H N on Sep 8, 2008 5:46 AM

[former_member192897]

I would suggest you two Easy ways of Finding Tables Names by Inputting Field Names.

Go to SE15 ABAP Repository and Select ABAP Dictionary Folder then Again Select Fields Folder and Select Table fields and in Next HalfWindow Input Field Name alone and Execute. Then it will Show all the Tables.

Else Go to Field Press F1 on Field and then Click on Technical Configuration and in Field Data tab you can see the Table name / in the Same tab Double click on Data Element and Select Where Used List Icon then Select Tables Fields Option and Enter Then It will take you to the Tables Section.

Regards,

Ashok

[Former Member]

Hi,

Check this Link you will get all answers

http://www.erpgenie.com/abap/tables_mm.htm

Check the main tables

EBAN -Purchase Requisition

EKKO-Purchase Order

MSEG- Accounting Doc

BSEG-Accounting Doc

LFA1- Vendor

LFB1- Vendor

LF* -you will get all the vendor details table

G.Ganesh Kumar

[Former Member]

Hi,

Check this Link you will get all answers

http://www.erpgenie.com/abap/tables_mm.htm

G.Ganesh Kumar

[former_member506901]

Hi experts,

Anyone please reply me its a very critical

requirement or atleast guide me how i need

to proceed.

Full points will be awarded.

Regards,

Nishuv.