Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

BI Requirement from MM

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
Not what you were looking for? View more on this topic or Ask a question