on 12-29-2014 10:26 AM
Hi,
Can we create variables on key figures, If yes,Please let me know the process step by step.
My requirement is we have key figures Supply Elements(SE) like purchase order,production order,planned order etc and Demand Elements(DE) like Deliveries,Sales order etc. All these Key figures are dragged and available in Rows.
Now my clients wants variables on SE and DE.
For SE & DE = Variable type is OPTIONAL and Variable input value =LIST VALUES.
Can any one help me on this.
Your Effort will be Valued.
Regards,
Krishna.
Hi Krishna,
Supply Elements(SE) like purchase order,production order,planned order etc and Demand Elements(DE) like Deliveries,Sales order etc..
those are not Key figures, these are char fields... may be they are placed in Rows, and char fields are maintained in columns..
Query once execute in excel & check it.
Br,
Kamal
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Kamal,
These are the Keyfigures with Data type QUAN with unit:0BASE_UOM.
Under :
SE - Purchase Req (ZSEOOPR),Purchase Order(ZSEOOPO),Production Order(ZSEOOPRQ) Etc..
DE-Safety Stock(ZDESS),Sales Order(ZDESRSO),Deliveries(ZDESRD) Etc..
In column it has structure which displays the month of Jan-Dec.
The output of the report snapshot attached
Now my client requirement is
S8e | Demand Elements | No | Text | N/A | N/A | N/A | N/A | Yes | Optional | List Values | Default to All |
S8e | Supply Elements | No | Text | N/A | N/A | N/A | N/A | Yes | Optional | List Values | Default to All |
Regards,
Krishna.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.