BI Requirement from MM
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.