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
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
