SQL Server administration and T-SQL development, Web Programming with ASP.NET, HTML5 and Javascript, Windows Phone 8 app development, SAP Smartforms and ABAP Programming, Windows 7, Visual Studio and MS Office software SAP ABAP Programming and HANA Database Tutorials
Development resources, articles, tutorials, code samples and tools and downloads for ASP.Net, SQL Server, R Script, Windows, Windows Phone, AWS, SAP HANA and ABAP, like SAP UI5, Screen Personas, etc.




Install SAP Free


ABAP ATC Check on S4HANA TABL T001 has been replaced


On a recent ATC (ABAP Test Cockpit) tool check on my custom code developments on SAP, "TABL T001 has been replaced (See Note(s): 0002431747)" error was one of the ATC findings. The error pointed a CDS view (Core Data Services) object where I used T001 Company Codes database table in FROM clause of the CDS View SELECT statement.

The CDS view code that ATC check finds a priority 1 error was similar to one as shown below

@AbapCatalog.sqlViewName: '/KODYAZ/TVKO_CDS'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Sales Organization CDS View'
define view /KODYAZ/TVKO_INFO
as

select
tvko.bukrs,
tvko.vkorg,
t001.kkber
from tvko
inner join t001
on tvko.bukrs = t001.bukrs

When I check the DDL SQL View object on SE11 transaction using ATC, following below menu options:
View > Check > ABAP Test Cockpit with...
I got following ATC error

S/4HANA: Search for base tables of ABAP Dictionary views
View based on a replaced artifact
View /KODYAZ/TVKO_CDS has TABL T001 as a base table. TABL T001 has been replaced (See Note(s): 0002431747)

To get rid of this error and solve the ATC finding, I replaced the T001 base table (Company Codes) with IFICOMPANYCODE Company Code DDL SQL View as follows in the SELECT statement

select
tvko.vkorg,
tvko.bukrs,
t001.CreditControlArea as kkber
from tvko
inner join I_CompanyCode as t001
on tvko.bukrs = t001.CompanyCode

After this modification in the source codes of the CDS view, the ATC check did not find any error fortunately. There are other tables and views for company code data but I see that most miss the Credit Control Area information KKBER field data, so I think it is good to use IFICOMPANYCODE DDL SQL View instead of using T001 database table.

company code CDS view as shown DDL SQL View DDIC entry

A similar problem can happen if the ABAP programmer used VBFA Sales Document Flow base table directly in a CDS view SELECT statement.
TABL VBFA has been replaced (See Note(s): 0002198647)
To resolve such an ATC finding, ABAP base table VBFA can be replaced with DDL SQL View ISDDOCMLPROCFLOW SD Document Multi Level Process Flow.






SAP Tutorials

SAP Tutorial

SAP Forums

SAP Tools

SAP Transaction Codes Table








Copyright © 2004 - 2019 Eralper YILMAZ. All rights reserved.
Community Server by Telligent Systems