Skip to Content

Unable to fetch data from ANLC table through CDS view / AMDP

Sep 14, 2017 at 06:38 AM


avatar image
Former Member

authorization-object.pngpfcg-role-details.pngHi Experts

while fetching data from ANLC table in CDS view or AMDP it is not returning any rows.

even if the CDS view is very basic it is not returning any rows.

below is my CDS view

@AbapCatalog.sqlViewName: ‘zcdsanlc_test’
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
//@AccessControl.authorizationCheck: #NOT_ALLOWED
//@AccessControl.authorizationCheck: #NOT_REQUIRED
//@Analytics.query: true

@EndUserText.label: ‘ANLC Test’

define view zcds_anlc_t
as select from anlc as c
key c.bukrs,
key c.anln1,
key c.anln2,
key c.gjahr,
key c.afabe,
key c.zujhr,
key c.zucod,

I have also tried with all possible combinations of @AccessControl.authorizationCheck: annotation. Also tried with creating one Access control for the CDS view as below but the Access control not helped

@EndUserText.label: ‘zcds_role’
@MappingRole: true
define role zrole_ANLC {
grant select on zcds_anlc_t
where ( bukrs
) =
aspect pfcg_auth ( ZAUTH_ANLC,
actvt = ’03’ );


but I am able to fetch data using open SQL in SE38.

so can any body help me regarding?

thanks in advance

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Sri Jayant Singh Oct 10, 2017 at 08:11 AM

Hello Goutam,

As per my understanding, With SFIN, the asset accounting tables (ANEK, ANEP, ANEA, ANLP, ANLC) have been replaced with the comprehensive ACDOCA data table.

Replacing these tables with views with the same names ensures the continuation of all read accesses to the tables mentioned. So, you may not be getting data out of these tables.

ACDOCA (Universal Journal Entry Line Items) should have all the line items you are looking for.

P.S. You can also look for referance view for these tables and mount your CDS view on top of them.

Regards, Srijayant

10 |10000 characters needed characters left characters exceeded