Material Number Origins Within BSEG
Hope I've selected the correct space for this posting, Please let me know if what I'm asking doesn't make sense.
I am looking at multiple ways to get data contained in BSEG without actually using BSEG. I know, this is a rather old topic of sorts. Without going into a lot of detail, I will just say that I want to hit actual SAP DB tables and not utilize SAP app layer (this is not from within SAP). I am familiar with many of the BSIx and BSAx tables. For the most part they provide what is needed. I recently came across something though that I cannot resolve. I am having a difficult time determining exactly where best to get the material number (MATNR) from BSEG. Being a clustered table, I would expect that I can find anything seen through BSEG in the app layer within a transparent DB table. I'm hitting a dead end with the material number. I realize BSIM exists but it does not cover everything. Manual journals with material numbers would not be in BSIM. I've tracked much of the data to profit center table GLPCA but that doesn't have it all either (not all material movements). I also doubt the material number seen in BSEG is being referenced from profit center accounting at run time, but what do I know. I understand the accounting doc to material doc connection but again, that is only if there is an actual material movement.... not all cases.
Could someone help me with where the material field is coming from? I expected there was a single underlying table and assumed BSIM was it, but no such luck.
Thanks for any help!