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


ATC Check: View based on an artifact having a proxy object


On a recent ABAP Test Cockpit, ATC check I got errors "View based on an artifact having a proxy object" under check title "S/4HANA: Search for base tables of ABAP Dictionary views". These errors are mainly caused by the change in data model in SAP S/4HANA with material classification for example.

S/4HANA: Search for base tables of ABAP Dictionary views
View based on an artifact having a proxy object
Priority 1
SAP Note Number 2378796
View /KODYAZ/SOMMATSC has TABL MARD as a base table. TABL MARD has a CDS view as a proxy object (See Note(s): 0002206980)
Note: 0002378796
Short text: Material classification: Change in data model in SAP S/4HANA
Cannot be hidden using a pragma or pseudo-comment

ATC check: View based on an artifact having a proxy object

For example, followings are sample of "View based on an artifact having a proxy object" errors.

View /KODYAZ/SOMMATSC has TABL MARD as a base table. TABL MARD has a CDS view as a proxy object (See Note(s): 0002206980)
View /KODYAZ/SOMMATSC has TABL MARC as a base table. TABL MARC has a CDS view as a proxy object (See Note(s): 0002206980)
View /KODYAZ/SOMMATSC has TABL MARC as a base table. TABL MARC has a CDS view as a proxy object (See Note(s): 0002378796)

Please note that ATC error detail points to a SAP Note Number for these ATC results.
The list of CDS view proxy objects for the related ABAP tables (in this case MARD and MARC) are shared in these SAP Notes.

ABAP developers can use SAP transaction code SNOTE to download or browse for a SAP Note number.

Here are the two SAP Notes; 0002206980 and 0002378796

Following is the list published by SAP for ABAP developers. Using the objects displayed in the list an ABAP programmer can replace the table name MARD with NSDM_MIG_MARD for example to get rid of "View based on an artifact having a proxy object" ATC check errors.

MARC Plant Data for Material NSDM_DDL_MARC NSDM_MIG_MARC V_MARC_MD
MARD Storage Location Data for Material NSDM_DDL_MARD NSDM_MIG_MARD V_MARD_MD

For example, I referenced MARD table in FROM or JOIN clause of a SELECT statement in a CDS View object as follows:

from mara
inner join mvke
 on mvke.mandt = mara.mandt and
 mvke.matnr = mara.matnr
inner join marc as marc
 on marc.mandt = mara.mandt and
 marc.matnr = mara.matnr and
 marc.werks = :p_werks
inner join mard as mard
 on mard.mandt = marc.mandt and
 mard.matnr = marc.matnr and
 mard.werks = marc.werks

When I replaced MARD with NSDM_MIG_MARD and database table MARC with NSDM_MIG_MARC I successfully resolved the ATC errors for "View based on an artifact having a proxy object"

from mara
inner join mvke
 on mvke.mandt = mara.mandt and
 mvke.matnr = mara.matnr
inner join nsdm_mig_marc as marc
 on marc.mandt = mara.mandt and
 marc.matnr = mara.matnr and
 marc.werks = :p_werks
inner join nsdm_mig_mard as mard
 on mard.mandt = marc.mandt and
 mard.matnr = marc.matnr and
 mard.werks = marc.werks





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