Skip to Content

How to handle Distinct and *GO command in SAP BPC NW version

Hi ,,

just need a help of you all in SAP BPC Nw version, how can handle the following command in NW.

1) *SELECT(%MAT%,"DISTINCT(MAT_GRP)",MATERIAL,PLANT=XXX)

2) *GO

I will thankful, if you could help

Obaid

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Dec 30, 2011 at 06:43 AM

    In MS ,purpose of *GO is to commit calculated values above it . Updated value of "Sales" would not be available for next when statement if *GO is not placed in between .

    *WHEN ACCOUNT
    *IS UnitsSold
    *REC(FACTOR=2, ACCOUNT=Sales)
    *ENDWHEN
    *GO
    *WHEN ACCOUNT
    *IS Sales
    *REC(FACTOR=.08, ACCOUNT=SaleTaxes)
    *ENDWHEN
    

    In NW , *ENDWHEN would commit values . No extra key word is defined for this pupose. ie updated value of "Sales" would be available for next when statement

    what does the Select statement that you have specified do?

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Obaid shaikh

      LIKE is not supported in NW . Within select multiple conditions are also not supported . Select statement which you have specified in previous post can be replaced with xdim_memberset .

      *XDIM_MEMBERSET Meterial as %MAT% = M_1, M_11,M_10,M_12

      Krishna

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.