on 11-07-2017 3:00 PM
Hi Experts,
Is there a way to exclude a Cost element for 1 Location in either Transformation/Conversion file in SAP BPC while extracting data from SAP BI? e.g. Cost element 100000 data exists for 3 Entities (India, China and Brazil) in SAP BI. We have a requirement to exclude 100000 for Brazil only. For India and China, the same Cost element data has to come to BPC. Hope my question is clear.
Please let me know if any questions.
BR, VRR
In the transformation file you can use something like:
COSTCENTER=*IF(0COMP_CODE+0COSTCENTER=*STR(BR0001100000) THEN *STR(TOSKIP); 0COSTCENTER)
assuming 0COMP_CODE for Brasil is BR0001
Then in conversion file for COSTCENTER
TOSKIP *skip
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
13 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.