MDM 2.0 - OCI mapping of field "Price Information"

[matthias_kasig2]

Hi SDN,

we are on SRM 5.0.

we are setting up MDM 2.0. We do a new installation, although we were already on MDM 1.0. Anyway, we want to keep the repository from MDM 1.0.

Right now we have problems transferring the price of shopping cart positions from the MDM Web Search UI to EBP.

what we did so far:

1. set up j2ee server and oracle

2. set up MDM 2.0 Server

3. Deploy MDM 2.0 SP 2.0 Java API and UI stuff to j2ee

4. set MDM 1.0 Repository in the appropriate place in the file system of MDM Server and unarchived it in the MDM console

5. run repository upgrade using link from upgrade guide (http://<j2eeserver>:50000/webdynpro/dispatcher/sap.com/tc_mdmsrmcat~uiutil/Utilities)

6. upgrade configuration (same link as before, but step 2)

still, in the OCI Mapping for price, I still have "price - amount" mapped on NEW_ITEM-PRICE

and still, the price, which I can see in the search UI, is not being transferred to EBP...

I am not sure, if I have to have "Price Information - amount" available as OCI mapping field. Right now, this is NOT the case. In MDM 1.0 it used to work fine with "Price - amount"

In my repository in table cataloge items I have the field "Price Information" which is a qualified lookup table, based on look up table "Price". "Price" contains the field amount, which carries the price value.

any clues welcome - regards, Matthias

Edited by: Matthias Kasig on Dec 20, 2007 4:25 PM

[Former Member · Accepted solution]

There is now a correction from SAP for this:

See note: 1135257: [https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=1135257&nlang=EN&smpsrv=https%3a%2f%2fwebsmp101%2esap-ag%2ede]

However, I have noticed something in the latest patch (SRM-MDM Catalog 2.0 SP02 Patch03) causing issues with Service Item mapped in the OCI. It seems that an "X" is transferred in the <input type="hidden" name="NEW_ITEM-SERVICE[1]" value="X"/> over from SRM-MDM when SRM makes an OCI call to MDM. This seems to happen even when Service Item is not "ticked" in the catalog (actually in this situation none of the items in the calog are service items, so seems to be a a bug). Just wanted to check if anyone else noticed the same.

Regards,

John

[matthias_kasig2]

Sorry for not answering to this thread for a while. But in fact we were waiting for PL03 which in fact solved the pricing issue. Now even in german language we get the price information transferred to SRM correctly,

kind regards and thanks to all SDNers involved,

Matthias

[masa_139]

Hi,

If the new repository has same issue, please check the HTTPWatch log.

[/people/masayuki.sekihara/blog/2007/12/07/oci-open-catalog-interface-setting-and-trouble-shooting|/people/masayuki.sekihara/blog/2007/12/07/oci-open-catalog-interface-setting-and-trouble-shooting]

Regards,

Masa

[matthias_kasig2]

Hi Masa,

just another brief status Q:

Now I am able to receive the price in EBP.

But this is a workaround. Just for a test I did a new OCI mapping like this:

I leave the OCI field NEW_ITEM-PRICE blank and use instead

NEW_ITEM-CUST_FIELD4 --> mapped on --> Price Information - Amount.

Thus I am able to get the value of the price field in my BADI bbp_catalog_transfer.

There seems to be a mismatch of field types. In the MDM Console the amount field is of type 'currency' - I assume this is decimal in fact.

In my incoming structure in the BADI I have tabletype catalog_content which is based on structure BBP_WS_OCI_ITEM_S which carries field price of type DEC... seems reasonable to me - but in the debugger I can't see the incoming price value. Instead now I use BBP_WS_OCI_ITEM_S-CUST_FIELD4 which is of type CHAR20. This works! I regard this as a workaround and I am still researching to get the price field mapped correctly to the proper price field in my BADI.

Masi: Concerning your weblog and SLG1 and Errorlog BTC1...

I set up in SPRO the MDM Catalog and also checked "use error log" for the catalog - still

I wonder how I can access this log and esp the OCI fields -- can you guide me there?

I was clicking through the entries of SLG1 but don't get to see the OCI fields of the transfer, though an entry which is because of the data transfer from mdm towards EBP.

kind regards, matthias

btw: SDN was down, hence the delayed response

[matthias_kasig2]

Hi Masa,

ok - I was able to get the BCT1 application log from SLG1. I followed the instructions in SDN-Wiki entry:

[https://www.sdn.sap.com/irj/sdn/wiki?path=/label/bbp_catalog_transfer-app-log&]

Here I found additional coding for the bbp_catalog_transfer BADI which brings about the OCI fields in SLG1.

regards, Matthias

[masa_139]

Hi Matthias,

It looks MDM UI OCI mapping side problem. Can you try to get http log by HTTPwatch tools ? You see the http POST data from MDM UI. Please also check the version SRM-MDM Catalog 2.0 SP ?? Patch ??.

Regards,

Masa

[matthias_kasig2]

Hi Masa,

I switched on NEW_ITEM-PRICE -- "price information -amount" again. In fact in SLG1 BCT1-log I notice that the NEW_ITEM-PRICE field is not in the list at all - as though not processed at all.

I installed httpWatch 5.2.12 by simtec. I assume that is the tool you are recommending - now I am trying to figure out what to do with it

maybe I open an OSS message for the persisting price field problem.

regards, matthias

[matthias_kasig2]

Hi Masa,

I installed httpWatch professional (not basic)- this allows to have a look on the POST data of a webpage... and this is really a smart tool!

Returning from MDM to SRM, at least in the httpWatch-list I can see the NEW_ITEM-PRICE field, which remains empty. It displays:

NEW_ITEM-PRICE[1] 0

I also tried to put different values in there - like SAM Matnr or short description - still nothing comes back to SRM.

Do you have a clue about this?

kind regards,

matthias

[Former Member]

Hi

Also check for the SAP OSS Notes below ->

Note 1003026 Prerequisites for OCI integration in SRM 6.0

Note 1095541 SRM-MDM Catalog 2.0 SP01 Patch03 Release Note

Note 1040778 Longtext not copied from catalog.

Note 447854 EBP, Catalog (OCI): Short dump when value >= 1,000.00

Hope this will help. Do let me know.

Regards

- Atul

[matthias_kasig2]

Hi Masa,

forgot to mention our MDM Version:

it is MDM 2.0 SP02 PL00 - just noticed that today there is PL01 available - I guess we are going for it.

btw: we are on SRM 5.0

kind regards, matthias

Edited by: Matthias Kasig on Dec 20, 2007 4:07 PM

[matthias_kasig2]

Hi Masa et al,

now we are on MDM 2.0 PL01 and the situation is getting worse. Now in the MDM Shopping cart we get a 0,00 Price for each found item (but in the MDM Data Manger we can see, the articles have filled price information amount entries). When turning towards the Shopping Cart Preview the correct price is being shown.

The OCI mapping NEW_ITEM-Price = Price Information - Amount is not working. The SLG1 BTC1 Log does not show the incoming price field at all - and http watch tells a Zero price. I shall create an OSS message for this.

kind regards, matthias

[Former Member]

HI Matthias Kasig ,

You can see the pricing value in MDM Data Manager under the " Price Information" tab,but u are not able to see any of the value coming to the shopping cart. Is this correct ?

If Yes ! Let me know wht all do you see in price information tab. You see the amount and ... .. anything else. If you do not see anything else , then u need to check your mapping in MDM Import Manager .

If the mapping is fine, it should bring the pricing value to shopping cart

This should solve the issue .

Check the above and let me know.

Thanks !

Ram

[masa_139]

Hi Matthias,

Please create a test repository by unarchving the SRM-MDM Catalog 2.0 template archive ? We should check the issue from repository upgrade or not.

Regards,

Masa

[Former Member]

Hi

Which SRM version are you using ?

See related links ->

Hope this will help. Do let me know.

Regards

- Atul

[matthias_kasig2]

Hi SDN,

something new:

in the MDM Console I did:

1. Loading Repository / Updating Indices

2. restart of j2ee

effect:

now I have in the config UI tool:

"Price Information - amount" for the OCI mapping available.

So now I have:

NEW_ITEM-PRICE --> "Price Information - amount"

but still in my incoming BADI bbp_catalog_transfer I can't see the price coming...

what else is missing?

regards, matthias