Background
Three tables and their relationship as below:
VBAP(1) : VBFA(N) : Memo(1)
Requirement
I want to create a table with three columns:
Column #1: “Reason Code”( From table: Memo , it is a dimension column) , it is done
Column #2 : “Memo#” , with PQL: COUNT(DISTINCT "memos"."vbeln" || ' ' || "memos"."mandt" , it is done
Need your help on this:
Column#3: “Total number of VBAP” . I don’t want the value of “Reason Code” cross filter table “VBAP” which means the all the value should be the same , for example: 13298
I have tried 2 PQL below:
- PQL#1:
Global (
SUM (
PU_COUNT (
"Memos" ,
BIND (
"VBFA" ,
"VBAP"."VBELN"
)
)
)
)
- PQL# 2:
GLOBAL ( COUNT_TABLE ( "VBAP" ) )
I may also enable pre-filter in this table level. But the Column#3 “Total number of VBAP” should NOT be impacted.