3153416 - Count or Inlinecount Shows Wrong Result in OData Query

Symptom

You are using OData to retrieve data source or report data. You are also using $count or $inlinecount, however you notice that a wrong value is returned (for example smaller or larger than the actual result of your query).

Environment

SAP Business ByDesign
SAP Cloud for Customer

Cause

Some data sources have a specific technical scope, which does not support the count or inline count. The affected data sources are (technical IDs):

byDesign:

BPCSCARB
BPCSCONTB
BPCSCONTB_2
BPCSDB
BPCSFINB
BPCSRSPB
BPSPPB
BPSP_PRD_CAT_LIFE
BUPASUPPLIERCOLLB01
CCABUSINESS_ROLE
FNDCLMB
FND_SUP_ADDRESS
FND_SUP_FINDATA
HCMTLMB13
SCMITEMCHST
SCMLOARESTB03
SCMLOARESTB04
SCMLOARESTB05
SCMLOCLYTB01
SCMPRFB01
SRMIR_B02
SRMPCO_B02
SRMPO_B12
SRMPRC_B01
SRMPR_B03
SRM_PPS_SCALES_MDAV

Cloud for Customer:

ANA_TEST_DTJ_B01
BPCSCARB
BPCSCONTB
BPCSDB
BPCSRSPB
BP_EMPLOYEE_DETAILS
CCABUSINESS_ROLE
CODBPCSCONTB
CODUSMB
CODUTLPREMISE
COD_IND_BANKING_B07
COD_IND_BANKING_B08
COD_IND_BANKING_B09
COD_IND_RET_CUS_CHK_B01
COD_MAINTENANCE_PLAN_B01
COMPETITOR_PRODUCT_B
CRMCASEREPB
CRMCHECKLISTHB
CRMEMPSKILL_B
CRMIBASEHB
CRMIBASEIPOINTHB
CRMIBASESKILLHB
CRMIPOINTHB
CRMIPOINTSKILLHB
CRMMEASUREMENTPOINTDOCHB
CRMOPPHHB
CRMQPPRTB01
CRM_SKILLH_B
FINCACB12
FINCACB13
FINCACB16
FNDCLMB
HCMTLMB05
PDM_MAT
PROCPIB03
PROCPIB06
PROCPIB07
PROCPIB09
PROCPIB11
UTILITIES_CA_ANAL_VIEW

Resolution

In these data sources, count and inlinecount do not provide reliable results and should not be used.

To request changes or enhancements, please use the Influence Portal.

Keywords

odata, count, wrong, inlinecount, report, data source, inline count , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , Product Enhancement

Product

SAP Business ByDesign all versions ; SAP Cloud for Customer core applications all versions