cancel
Showing results for 
Search instead for 
Did you mean: 

Code remediation - ECC tables to be replaced in S/4 brownfield implementation

OmPrakashJha
Participant
0 Kudos
14,635

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

Accepted Solutions (0)

Answers (6)

Answers (6)

DominikTylczyn
Active Contributor

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

OmPrakashJha
Participant
0 Kudos

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

DominikTylczyn
Active Contributor

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.

Neeraj_Jain
Active Contributor

Hello omprakash.jha,

Please refer below SAP Blog. Hope it's helpful to you.

https://blogs.sap.com/2022/03/04/top-5-faqs-frequently-asked-questions-sap-s-4hana-migration-cockpit...

Regards,

Neeraj Jain

OmPrakashJha
Participant
0 Kudos

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

bygineben
Explorer
0 Kudos

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)
  • Finding can be suppressed with pseudo comment "#EC CI_USAGE_OK[2198035]
  • Metrics:
  • Ref. Obj.: WB2_D_BUSVOLBASE (TABL)
  • Note: 0002198035
  • Category: Syntactically incompatible change of existing functionality

Syntactically incompatible change of existing functionality (TABL WB2_D_BUSVOLBASE, see Note(s): 0002198035): S/4HANA: Search for usages of simplified objects

former_member208609
Active Participant
0 Kudos

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,

  • ATC Finding on update of table KONV asks to read SAP Note 2220005 - S/4 HANA: Data Model Changes in Pricing and Condition Technique. The attachment of this SAP Note explains what you need to do if you are currently updating KONV with custom code, or if you have appends.
  • how to deal with MSEG/MKPF is explained in SAP Note 2206980 - Material Inventory Managment: change of data model in S/4HANA . This one does not have an attachment, but very detailed instructions.

Best regards

Renaud

former_member208609
Active Participant
0 Kudos

omprakash.jha

Hello,

Based on this question, I do not believe you follow the recommended approach. Are you using an ATC?

Best regards

Renaud

OmPrakashJha
Participant
0 Kudos

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.

keremkoseoglu
Contributor
0 Kudos

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.

OmPrakashJha
Participant
0 Kudos

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?

schermafbeelding-2023-03-14-065616.png

keremkoseoglu
Contributor
0 Kudos

omprakash.jha as far as I know, KNA1 is still valid. Despite the fact that S4 Hana brought the concept of business partners, KNA1 master is still there. That's probably why you don't see a replacement table.