Select alphanumeric values in Interval in Partitions SPO

[Former Member]

Hi experts,

i have some values that I want to use them in partitions of SPOs as criteria which are alphanumeric(ex. "21-Cars"). So I created a partitions selecting the interval between 0* and 9* and I assume that all the values between 0-9 and starting with 0-9 will be falling in this interval. But actually this doesn't work. It works for characters like A* - B* or for numbers 0* - 9* but not for alphanumerical values. Could you please suggest how can I capture the alphanumeric values in the selection internval.

Thank you,
Regys

[Former Member]

Also some of the characters are also not loaded to the target like entries starting with S, M, F. So I am wondering perhaps is the issue in the flat file loading but I tried different files and still it didn't work. Below is the partition I am working on.

Any help on this issue please.

Regards,

Regys

[anindya_bose]

Hi Regys

Is it possible for you to create a field which will have 2 values 1 and 2 based on whether the original field is Alphanumeric or not  ?

Original Field        new Field

21-Cars                     1

21-21-21                    0

33-Bus                        1

Now, you can use new field for partitioning .

Regards

Anindya

[Former Member]

Hi Anindya,

thank you for your response. The thing is that the SAP users may create different materials in SAP ERP and when I import them in SAP BW, some of them could be alphanumerical as in this case. (Ex. 21-cars"). Because I cannot restrict the naming of materials, I was thinking how could I capture also these materials. For this reason I created an interval say 0*-9* so that every material(even alphanumerical) that starts with one of such values in interval could fall on it.

For characters ex. A* it works and also for number ex. 0* but I cannot understand why it doesn't work for alphanumerical values. I think maybe it is at the syntax. I also tried 0% but still didn't work.

Thank you though for the response.

Regards,

Regys

[anindya_bose]

Hi Regys

If you use 0* - 9* or 0*   both '021-CARS'   and '021123* would fall in the same category logically.

My understanding is you are trying to keep alphanumeric material in separate partition .  Is the assumption correct ?

What is your Data Flow ?  A)  PSA---->SPO   or  B ) PSA---->DSO---->SPO ?

Did you try  *A*  -   *B*   ?  ---- here I am assuming either you have alphanumeric or full numeric material number ..

Is it possible to use "Underscore" as partitioning criterion or non-alphanumeric material also contains under score ?

You can have a look at BAdi based SPO and explore that option .

Regards

Anindya

[Former Member]

Hi Anindya,

If you use 0* - 9* or 0*   both '021-CARS'   and '021123* would fall in the same category logically. 

yes I was thinking the same but it wasn't working. No, I am not trying to keep alphanumeric in a separate partition, I wanted them to fall under this partition: 0*-9*.

What is your Data Flow ?  A)  PSA---->SPO   or  B ) PSA---->DSO---->SPO ?

My dataflow is PSA-DSO-SPO.

Did you try  *A*  -   *B*   ?  ---- here I am assuming either you have alphanumeric or full numeric material number ..

I didn't try this, I tried only A*-B*. I wonder if I try *A* it would select all the materials that have A in it and this is not what I want.

Perhaps maybe some other syntax would make the work but I am not finding it right.

Regards,

Regys