on 05-12-2010 9:24 AM
hi
i need to add MATNR to bsik table . what is best possible options we can link with other tables?
if i link with bseg tbale to get matnr.
what are primary keys need to use
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
If you want to link BSEG with BSIK use BELNR/BUZEI/BUKRS/GJAHR fields. However, the prformance of such join could limp.
Regards,
Eli
still i am not getting right matnt with these keys. any idea can we use other fields.
or we can ekpo table is better than bseg? or which wilkl be best
You can link to EKPO only if you have reference of purchase order in BSIK...
Hi Suneel,
Let me know what is proper requirement ! Why would have to add MATNR in BSIK table or BSEG table.
Rgds
Suma
hi basically i am SAP BI consultant. i wnat use matnr at report.
You can get MATNR number in BSEG ,MSEG,RSEG & SOME OF PROFIT CENTRE LINE ITEMS. But still i am not clear .which report would you want to design in BI. Is it FI report or PCA reports.
This message was moderated.
i am getting wrong material information if i am usinng bseg or rseg to get matnr with these primary keys
BELNR,GJAHR,BUZEI
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.