master data updation

[Former Member]

Hi All,

I am updating the CSKS master data table. The key fields for this table are controlling area, cost center and 'valid to' date.

I have to do data transfers:

I am sending the same cost center two times and i need to create two corresponding records in the receiver side.

First data transfer: I send cost center 'x' under controlling area 'y' and with 'valid from' date as 1850 (year) and 'valid to' date as 2007(for eg)

Second : I send the same cost center 'X' under controlling area 'y' and with 'valid from' date as 2008 and 'valid to' date as 9999 (note the dates are just the year value and are an eg only).

Now since 'valid to' date is one of the key field and both records have diff 'valid to' dates, I expected two records to be created in the receiver. The first record was sent successfully. However after second ALE, the first record was overwritten even when the key fields are different.

Any suggestions?

Thanks

Mridula.

[Former Member]

Hi Mridula,

This should not happen, just check whether your valid to date is formatted correctly during second ALE.

Just have a look at the data shown below, which I picked from my server, which is satisfying your condition

MANDT KOKRS KOSTL DATBI DATAB

00 1000 0000004100 31.12.1996 01.01.1994

00 1000 0000004100 31.12.9999 01.01.1997

regards

Antony Thomas

[Former Member]

Hi,

Thank you for your reply.

I debugged the posting program COSM and I found that the cost center records are deleted based on cost center and controlling area. So my first record gets deleted. I am not sure how for you there were two records. The date format in my system is mmddyyyy which I am abiding with...

Can anyone suggest what I should do next ?

Thanks for your help !

Mridula

[Former Member]

Hi

we upload master data using standard programs.

Master data is uploaded using lsmw

In case of material master .. sap has developed rmdatind program..

using direct input method it uploads data into database

In case of customer master ..using batch input method we upload data

To know each and everything in detail...

goto lsmw t.code...

select the first step and press f8...

select the first step..i.e.,, standard direct input/batch input

press f4 for object.. u get all master data programs...

reward if useful

[Former Member]

Hi All,

i found the solution myself. If you debug the ale posting process code 'cosm', ale deletes the record in the master data table depending on cost center and controlling area.. it does not allow two records with the same cost center and CA.. even though the table can support it !

thanks

Mridula