Eliminated tables in S/4 HANA on Premise Edition 1511 – what’s behind them?
Maybe you have read the Simplification List about lots of tables (like MSEK, MKPF, VBUK, VAPMA …) being eliminated in S/4 HANA 1511 on premise edition. When looking at an actual system, have you been wondering (I sure have, see my previous blog ), why they still seem to be there?
-> You see them in SE11 as transparent tables and you can select data from them with SE16n.
Here’s how you can see what’s behind it:
In SE11, goto Menu -> Extras -> Proxy Object:
Here you can see what’s behind it: A CDS-view!
Like SE11 tells you, you can look at the CDS views with ADT (aka ABAP in Eclipse). Or just use report RUTDDLSSHOW2:
I hope you enjoyed this update, keep exploring! (I sure will!)
Best
Joachim
Thanks for sharing....
Hi Joachim,
Thanks for sharing.
But I have an issue. I don't get the option of 'Proxy Object...' , when I navigate as you suggested above.
Any idea ?
Thanks.
Hi B,
sorry, I have no explanation for that! 🙁
Maybe somethin to do with missing authorisation?
(you are on an S/4 HANA 1511 on premise system, right?)
regards
Joachim
It is available, but listed in German for me - Vertreterobjekt. However it is blank if I click on it. Any ideas why?
Only thing I could imagine: you're on a different software version ?!
I'm on
now, and think at the time of writin that blog post I was on
Thank you.
Just one remark(if I am correct) because you mentioned CDS - I assume here we have ABAP CDS view which could be different from HANA CDS (see CDS - One Concept, Two Flavors ).
Also the report RUTDDLSSHOW2 gives more details - note that you have ABAP dictionary object NSDM_V_MKPF and ABAP CDS view entity NSDM_E_MKPF. See http://help.sap.com/abapdocu_740/en/index.htm?file=abencds_f1_define_view.htm
I came back to proxy-object tables today, writing about what to do if you want to append (add custom fields) to one of them: Appending Tables in S/4HANA - easy?! - MBEW
best
Joachim
Hi Joachim,
I see in the image that the CDS view is NSDM_E_NKPF as proxy object .What type of view is this public private....also if you have any wiki link which provide guidelines for creating these proxy views it will be really helpful .
Thanks,
Sujeet.
Hi Sujeet,
I'm not sure if I completely understand your question, but if you want to learn more about those "Replacement Objects" Horst Keller's comment in Appending Tables in S/4HANA - easy?! - MBEW might help you!
best
Joachim
Hello Joachim, thank you so much for sharing this! Your article helps to clarify the topic which was before very confusing to me.
Hi Martin,
thanks very much for your kind feedback!
Hi Team,
I would like to know, What are all the db tables got obsolete in s/4 hana system or atleast suggest me how to find them.
Thanks in advance.
Hi Uday Kiran ,
I think the answer to the question "what tables have been eliminated with S/4HANA?", ist still in the Simplification list.
Here's a Link to the " Simplification List for SAP S/4HANA 2020" : https://help.sap.com/doc/e8f908b4892d44ad90e8c582b0cd1866/2020/en-US/SIMPL_OP2020.pdf