cancel
Showing results for 
Search instead for 
Did you mean: 

Interface Determination "Not Equal" Condition is not working

former_member196519
Participant
0 Kudos

Hi Team,

I am working on SAP PO 7.4 and am having in receiver determination condition. Actually I want to stop those records which are having quantity is zero. Its flat file to Idoc scenario. I tried to apply below options but no one is working.

/p1:MTPODSalesLSUK/Record_Set/Data/MTD_Quantity[not(starts-with(.,"0"))] EX

/p1:MTPODSalesLSUK/Record_Set/Data/MTD_Quantity ≠ '0'

/p1:MTPODSalesLSUK/Record_Set/Data/MTD_Quantity ≠ "0"

I see only below conditions in PO7.4.

=

EX

File is :

<wholesale_discount>30</wholesale_discount>

<MTD_Quantity>0</MTD_Quantity>

<MTD_avg_list_price>17.99</MTD_avg_list_price>

I have to apply condition on MTD_Quantity field.

Thanks in advance for your valuable suggestion.

Thanks,

Kumar

Accepted Solutions (1)

Accepted Solutions (1)

former_member196519
Participant
0 Kudos

HI Team,

Thanks for inputs.

I have made changes in line item level in Mapping to stop zero quantity. Now its working fine to me.

Thanks,

Kumar

Answers (3)

Answers (3)

markangelo_dihiansan
Active Contributor
0 Kudos

Hi,


/p1:MTPODSalesLSUK/Record_Set/Data/MTD_Quantity[not(starts-with(.,"0"))] EX

/p1:MTPODSalesLSUK/Record_Set/Data/MTD_Quantity ≠ '0'

/p1:MTPODSalesLSUK/Record_Set/Data/MTD_Quantity ≠ "0"

Don't use apostrophes or double quotes when using NE or EQ. Just use 0 and it should work.

Regards,

Mark

former_member196519
Participant
0 Kudos

Thanks Mark for reply..

But could you please tell which condition I should apply from above three.

Even though I also tried with 0 too but did not work

markangelo_dihiansan
Active Contributor
0 Kudos

Hi,

NE should suffice. Did you check your FCC if it is converting correctly?

Regards,

Mark

former_member192851
Active Participant
0 Kudos

/p1:MTPODSalesLSUK/Record_Set/Data/MTD_Quantity ≠ 0

iaki_vila
Active Contributor
0 Kudos

Hi Kumar,

Try another alternative, you can create a context object in your ESR with that xpath and to do the condition with it.

Regards.

former_member196519
Participant
0 Kudos

HI Mark,

FCC is working fine..

PLease file input.

<wholesale_discount>30</wholesale_discount>
<MTD_Quantity>0</MTD_Quantity>

<MTD_avg_list_price>17.99</MTD_avg_list_price>

Thanks,

former_member196519
Participant
0 Kudos

Hi Artem,

If I apply above logic, it throw an error in sender file adepter as below:

/p1:MTPODSalesLSUK/Record_Set/Data/MTD_Quantity ≠ 0


Error: com.sap.aii.adapter.xi.routing.RoutingException: InterfaceDetermination did not yield any actual interface


Thanks,

SHivdeep Kumar

former_member196519
Participant
0 Kudos

HI Vila,

I did not understand this, Could you please explain ho to do this..

Thanks,

Shivdeep Kumar

iaki_vila
Active Contributor
0 Kudos

Hi Kumar,

You have an example here

Regards.

former_member196519
Participant
0 Kudos

Hi Vila,

I am not worry about receiver. My concern is to stop zero quantity at interface mapping..

Thanks,

Shivdeep Kumar

markangelo_dihiansan
Active Contributor
0 Kudos

Hi,


I am not worry about receiver. My concern is to stop zero quantity at interface mapping..

Which do you want to achieve?

a. Pass only non-zero values in interface mapping - if this is the case, a simple ifElse in message mapping will do the trick

b. Stop message processing - this is not possible using standard mapping (try BPM). At best it would result in an error that says Interface Determination did not yield actual interface. If you don't want any errors, you can do this via enhanced receiver determination.

Regards,

Mark

former_member196519
Participant
0 Kudos

HI Mark,

Actually in my FCC, I have to combine 950 records together so I can not apply this condition in mapping.

Thanks,

Shivdeep Kumar

baskar_gopalakrishnan2
Active Contributor
0 Kudos

/p1:MTPODSalesLSUK/Record_Set/Data/MTD_Quantity eq 0

You might want to check this link.. You can also use equal operator as Abhishek mentioned in this thread...

nabendu_sen
Active Contributor
0 Kudos

Hi Kumar,

Please check the occurrence of the Source Message (XPath) in your mapping. Is it "1"?

Regards,

Nabendu.

former_member196519
Participant
0 Kudos

HI Sen,

Thanks for reply.

Occurrence for this field is 0-1

Regards,

Kumar