on 2023 Mar 14 4:12 AM
Hi All,
We are working on S/4 HANA brownfield implementation and during code remediation check below errors are thrown for all the databases operations(SELECT, MODIFY etc.) that these all are legacy tables which need to be replaced with new tables in S/4.
Could you please provide list of new tables for the below legacy tables?
S/4HANA: Search for database operations-KNA1
S/4HANA: Search for database operations-TKA01
S/4HANA: Search for database operations-CSKB
S/4HANA: Search for database operations-MARA
S/4HANA: Search for database operations-MARC
S/4HANA: Search for database operations-KNVV
S/4HANA: Search for database operations-LFA1
S/4HANA: Search for database operations-LFM1
S/4HANA: Search for database operations-KNB1
S/4HANA: Search for database operations-LFB1
S/4HANA: Search for database operations-PROJ
S/4HANA: Search for database operations-AUFK
S/4HANA: Search for database operations-EKKO
S/4HANA: Search for database operations-PRPS
S/4HANA: Search for database operations-TKA02
S/4HANA: Search for database operations-RBKP
S/4HANA: Search for database operations-EBAN
S/4HANA: Search for database operations-CSKA
S/4HANA: Search for database operations-MVKE
S/4HANA: Search for database operations-SKA1
S/4HANA: Search for database operations-T001
S/4HANA: Search for database operations-ANLA
S/4HANA: Search for database operations-VBRK
S/4HANA: Search for database operations-KONH
S/4HANA: Search for database operations-EKPO
S/4HANA: Search for database operations-MARD
S/4HANA: Search for database operations-MSEG
S/4HANA: Search for database operations-EKBE
S/4HANA: Search for database operations-COES
S/4HANA: Search for database operations-COSP
S/4HANA: Search for database operations-BSID
S/4HANA: Search for database operations-BSAD
S/4HANA: Search for database operations-BSEG
S/4HANA: Search for database operations-VBRP
S/4HANA: Search for database operations-VBPA
S/4HANA: Search for database operations-MBEW
S/4HANA: Search for database operations-EKBZ
S/4HANA: Search for database operations-KONV
S/4HANA: Search for database operations-SKB1
S/4HANA: Search for database operations-BSIS
S/4HANA: Search for database operations-BSAS
S/4HANA: Search for database operations-BUT000
S/4HANA: Search for database operations-VBAK
S/4HANA: Search for database operations-KNVP
S/4HANA: Search for database operations-VBFA
S/4HANA: Search for database operations-VBAP
S/4HANA: Search for database operations-VBSE
GSS/4HANA: Search for database operations-COEP
S/4HANA: Search for database operations-RBCO
S/4HANA: Search for database operations-COSS
S/4HANA: Search for database operations-LFC1
S/4HANA: Search for database operations-LFC3
S/4HANA: Search for database operations-CSKU
S/4HANA: Search for database operations-BSIK
S/4HANA: Search for database operations-KNC1
S/4HANA: Search for database operations-COVP
S/4HANA: Search for database operations-VSPRPS_CN
S/4HANA: Search for database operations-VSPROJ_CNS
/4HANA: Search for database operations-KNVK
S/4HANA: Search for database operations-WBGT
S/4HANA: Search for database operations-FAGL_ACTIVEC
S/4HANA: Search for database operations-T881
S/4HANA: Search for database operations-FAGL_SPLINFO
S/4HANA: Search for database operations-BSEG_ADD
S/4HANA: Search for database operations-T001A
S/4HANA: Search for database operations-GLT0
S/4HANA: Search for database operations-T004
S/4HANA: Search for database operations-BSAK
S/4HANA: Search for database operations-SKAT
S/4HANA: Search for database operations-T012K
S/4HANA: Search for database operations-VBUK
S/4HANA: Search for database operations-VBUP
S/4HANA: Search for database operations-FPLT
S/4HANA: Search for database operations-FAGLFLEXT
S/4HANA: Search for database operations-FILCT
S/4HANA: Search for database operations-EINE
S/4HANA: Search for database operations-RSEG
S/4HANA: Search for database operations-AFVC
S/4HANA: Search for database operations-VF_DEBI
S/4HANA: Search for database operations-VF_KRED
S/4HANA: Search for database operations-VSAFVC_CN
S/4HANA: Search for database operations-VSFPLT_CN
S/4HANA: Search for database operations-VSMLST_CN
S/4HANA: Search for database operations-VSRSADD_CN
Request clarification before answering.
Hello omprakash.jha
You do not need to look for any table replacements. SAP has already done that for you. They have build a virtual data model and has provided replacements in the form of CDS views. For instance, MKPF and MSEG are no longer used in S/4HANA. They are replaced with MATDOC. But you can still use MKPF and MSEG - as replacement objects (CDS views) have been provided for those tables.
Do you think that SAP has refactored all of their code to use the new data model? Of course not, there is too much work and too little to gain. SAP standard code, at least pre S/4HANA one, still uses the old data model, through the replacement objects.
If SAP standard code can work like that, your code can too. Your legacy code is going to work just fine, at least in the most of the cases. Your code will not even notice the difference as SELECT statements will be automatically redirected to the replacement objects.
So far I have encountered one case of a table not used in S/4HANA and without a replacement object. It is VBBS - see SAP NOTE 2209696 - ATP Transition to S/4
Focus on tests instead of on refactoring your code to the new data model.
Best regards
Dominik Tylczynski
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Dominik,
Thanks for your response.
CDS views can be used for retrieving the data.
But If we want to perform any DB operation using modify or insert statement we have to know the exact tables in S/4.
Could you please let me know any source of information, from where we can get the information which tables are still valid/same in S/4 and which are replacement tables for the below ECC tables?
S/4HANA: Search for database operations-KNA1
S/4HANA: Search for database operations-TKA01
S/4HANA: Search for database operations-CSKB
S/4HANA: Search for database operations-MARA
S/4HANA: Search for database operations-MARC
S/4HANA: Search for database operations-KNVV
S/4HANA: Search for database operations-LFA1
S/4HANA: Search for database operations-LFM1
S/4HANA: Search for database operations-KNB1
S/4HANA: Search for database operations-LFB1
S/4HANA: Search for database operations-PROJ
S/4HANA: Search for database operations-AUFK
S/4HANA: Search for database operations-EKKO
S/4HANA: Search for database operations-PRPS
S/4HANA: Search for database operations-TKA02
S/4HANA: Search for database operations-RBKP
S/4HANA: Search for database operations-EBAN
S/4HANA: Search for database operations-CSKA
S/4HANA: Search for database operations-MVKE
S/4HANA: Search for database operations-SKA1
S/4HANA: Search for database operations-T001
S/4HANA: Search for database operations-ANLA
S/4HANA: Search for database operations-VBRK
S/4HANA: Search for database operations-KONH
S/4HANA: Search for database operations-EKPO
S/4HANA: Search for database operations-MARD
S/4HANA: Search for database operations-MSEG
S/4HANA: Search for database operations-EKBE
S/4HANA: Search for database operations-COES
S/4HANA: Search for database operations-COSP
S/4HANA: Search for database operations-BSID
S/4HANA: Search for database operations-BSAD
S/4HANA: Search for database operations-BSEG
S/4HANA: Search for database operations-VBRP
S/4HANA: Search for database operations-VBPA
S/4HANA: Search for database operations-MBEW
S/4HANA: Search for database operations-EKBZ
S/4HANA: Search for database operations-KONV
S/4HANA: Search for database operations-SKB1
S/4HANA: Search for database operations-BSIS
S/4HANA: Search for database operations-BSAS
S/4HANA: Search for database operations-BUT000
S/4HANA: Search for database operations-VBAK
S/4HANA: Search for database operations-KNVP
S/4HANA: Search for database operations-VBFA
S/4HANA: Search for database operations-VBAP
S/4HANA: Search for database operations-VBSE
GSS/4HANA: Search for database operations-COEP
S/4HANA: Search for database operations-RBCO
S/4HANA: Search for database operations-COSS
S/4HANA: Search for database operations-LFC1
S/4HANA: Search for database operations-LFC3
S/4HANA: Search for database operations-CSKU
S/4HANA: Search for database operations-BSIK
S/4HANA: Search for database operations-KNC1
S/4HANA: Search for database operations-COVP
S/4HANA: Search for database operations-VSPRPS_CN
S/4HANA: Search for database operations-VSPROJ_CNS
/4HANA: Search for database operations-KNVK
S/4HANA: Search for database operations-WBGT
S/4HANA: Search for database operations-FAGL_ACTIVEC
S/4HANA: Search for database operations-T881
S/4HANA: Search for database operations-FAGL_SPLINFO
S/4HANA: Search for database operations-BSEG_ADD
S/4HANA: Search for database operations-T001A
S/4HANA: Search for database operations-GLT0
S/4HANA: Search for database operations-T004
S/4HANA: Search for database operations-BSAK
S/4HANA: Search for database operations-SKAT
S/4HANA: Search for database operations-T012K
S/4HANA: Search for database operations-VBUK
S/4HANA: Search for database operations-VBUP
S/4HANA: Search for database operations-FPLT
S/4HANA: Search for database operations-FAGLFLEXT
S/4HANA: Search for database operations-FILCT
S/4HANA: Search for database operations-EINE
S/4HANA: Search for database operations-RSEG
S/4HANA: Search for database operations-AFVC
S/4HANA: Search for database operations-VF_DEBI
S/4HANA: Search for database operations-VF_KRED
S/4HANA: Search for database operations-VSAFVC_CN
S/4HANA: Search for database operations-VSFPLT_CN
S/4HANA: Search for database operations-VSMLST_CN
S/4HANA: Search for database operations-VSRSADD_CN
Regards,
Om
omprakash.jha You say: "But If we want to perform any DB operation using modify or insert statement we have to know the exact tables in S/4." - that is not correct. If you need to perform write operation on SAP object, you need to know SAP provided interface like BAPI, IDoc or API. You must not write data directly to SAP tables. SAP data model is very complex and writing data directly to DB is a sure recipe for data inconsistency.
You can check in SE11 all those tables you listed and verify if they have replacement objects. To some extend that would answer your question, but only to some extend - see my example of the VBBS table. What you are trying to do is a waste of time in my opinion. Tell your buinsess requirements, then SAP Community might help you.
Hello omprakash.jha,
Please refer below SAP Blog. Hope it's helpful to you.
Regards,
Neeraj Jain
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Neeraj, Thanks for your response.
My question is - Can we have list of new S/4 HANA replacement tables for the below legacy tables?
KNA1
TKA01
CSKB
MARA
MARC
KNVV
LFA1
LFM1
KNB1
LFB1
PROJ
AUFK
EKKO
PRPS
TKA02
RBKP
EBAN
CSKA
MVKE
SKA1
T001
ANLA
VBRK
KONH
EKPO
MARD
MSEG
EKBE
COES
COSP
BSID
BSAD
BSEG
VBRP
VBPA
MBEW
EKBZ
KONV
SKB1
BSIS
BSAS
BUT000
VBAK
KNVP
VBFA
VBAP
VBSE
GSCO
EPRB
COCO
SSLF
C1LF
C3CS
KUBSIKKNC1COVPVSPRPS_CNVSPROJ_CNKNVKWBGTFAGL_ACTIVECT881FAGL_SPLINFOBSEG_ADDT001AGLT0T004BSAKSKATT012KVBUKVBUPFPLTFAGLFLEXTFILCTEINERSEGAFVCVF_DEBIVF_KREDVSAFVC_CNVSFPLT_CNVSMLST_CNVSRSADD_CN
Would like to bring into your notice another case( S/4 1909 On Prem) where the table -WB2_D_BUSVOLBASE is used in a report program and it gives the following ATC error. However the note does not give any details of simplification object to use instead.
Adding to that, the same error exists if the table is replaced with the standard CDS - I_CndnContrBusVolSelCriteria.
Syntactically incompatible change of existing functionality (TABL WB2_D_BUSVOLBASE, see Note(s): 0002198035): S/4HANA: Search for usages of simplified objects
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello omprakash.jha
It is a very good thing that you are using the ATC. Normally, for each ATC finding related to such a change of the database table, a SAP Note will be shown next to it, since this is a simplification item. Very often, in the corresponding SAP Note, there will be a detailed attachment explaining what is at stake with the change, and recommendations on how to handle the changes. For example,
Best regards
Renaud
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
omprakash.jha
Hello,
Based on this question, I do not believe you follow the recommended approach. Are you using an ATC?
Best regards
Renaud
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Renaud,
Yes, We are using ATC configuration to perform the check using variant FUNCTIONAL_DB and S4_READINESS_CHECK. Since, It's brownfield implementation so the code which are migrated from ECC to S/4 contain many INSERT and MODIFY statements on tables due to old fashioned way of coding.
As per the SAP development standards these all INSERT and MODIFY statements to be replaced with BAPIs. However we are still thinking if these MODIFY/INSERT or SELECT statement keep exist in the code then what could be the replacement tables against each of them as at then end BAPI also updates DB tables only.
I have already listed out all the tables which we found. Please have a look.
DD02L-VIEVREF might help. For example; MARD shouldn't be accessed directly any more; instead, it should be accessed over NSDM_V_MARD which can be seen in DD02L-VIEWREF.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Karim,
Thanks for your response.
For KNA1 table - VIEWREF is showing blank.
Same for other tables also.
From where I can get the list of new view or tables?
User | Count |
---|---|
127 | |
9 | |
7 | |
6 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.