Inconsistent data in CIF tables

[Former Member]

Hi

While doing a check of active integration models (the check icon) i get messages related to inconsistent data in following tables

CIF_IMORD,

CIF_IMPLO,

CIF_IMPO

CIF_IMRSV

All these tables have same selections and same # entries.

What corrective action do i need to take. Why do such errors occure,

PS: for now i have deleted all the integration models and recreating again. i am hoping i will not encoutrer this with iniital tranfer again.

Regards,

Lok

[Former Member · Accepted solution]

What is the message number and message class of the message?

Is CIF_IMOD empty after deleting all tables?

What does /sapapo/cq look like?

[Former Member · Accepted solution]

Hi David,

The table CIF_IMOD still has entries.

Theres are several entries of model CIFDELTAMO with field status=R, S and T

The actual integration models that I created have field status = blank.

In /sapapo/cq, these are the logs in SCM inbound. For ECC inbound and outbound and SCM outbound there are no errors/logs.

SCM Inbound- Error initial transfer

Log 1:

Location G065 of type 1011 (BSG ECP_600) already exists in APO

No mapping entry for G065 1011 ECP_600

Message incomplete (seriousness, area, number, or exception missing)

Message incomplete (seriousness, area, number, or exception missing)

Message incomplete (seriousness, area, number, or exception missing)

Message incomplete (seriousness, area, number, or exception missing)

Message incomplete (seriousness, area, number, or exception missing)

Message incomplete (seriousness, area, number, or exception missing)

Message incomplete (seriousness, area, number, or exception missing)

Message incomplete (seriousness, area, number, or exception missing)

Log2:

Product for external product number 000000000100000123 and BSG ECP_600 does not exist

Location product 000000000100000123 AA00 not maintained

Procurement relationship not created for 3 5300000000 SBC1 AA00

Log3:

same as log1

What should i do know. I checked BSG assignment to logical system is correct. CIF does not have any exclusions in selections. All MD and TD exists in SCM, BUT Products and location level are not seen.

Regards,

Loknath

[Former Member]

Lok,

Here are some easy things to try:

1. Deactivate, regenerate, and reactivate ALL your IMs

2. Run program RAPOKZFX

3. Run program RCFUPDCR

4. Run program RCFORDCH

5. Run program RCIFIMAX

6. Run program RCIFIMDL

(all these are on the ECC side)

Not all of them will have impact on IMOD tables, but they generally won't hurt anything either.

Once you are done these, and you still have issues, you probably need to get an ABAPer to help you debug.

Regards,

DB49

[Former Member]

Hi,

Please check if any user exits are activated for integrating the material master. We had similar problem and after deactivating user exit, this problem was solved.

Thanks and Regards,

K7