Skip to Content
avatar image
Former Member

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

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
//@VDM.viewType: #CONSUMPTION

@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,
c.afblpe
}


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,
BUKRS,
actvt = ’03’ );

}

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

so can any body help me regarding?

thanks in advance

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • 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

    Add comment
    10|10000 characters needed characters exceeded