ID Converter (tables)

[Former Member]

Hi Experts!

I have some requirements for data extraction (SNC to BW) and I have to know where the mapping of specific ID´s and its codes is stored.

I already found the transaction /SCA/IDCONVERTER that converts some ID´s (Partner, Location, Product and User Partner). I need a similar transaction or the table for the following fields:

ITMID ( /SCMB/ODM_ITMID --- ODM: Item ID)

NOTEID ( /SCMB/ODM_NOTEID --- ODM: Note ID)

ORDID ( /SCMB/ODM_ORDID --- ODM: Order Document ID)

SDLID ( /SCMB/ODM_SDLID --- ODM: Schedule Line ID )

Kind Regards,

TP

[Former Member · Accepted solution]

Hi TP

Use the transaction /SCA/IDCONVERTER to get the 32bit order id for your PO number

Use the below mentioned tables in orderly fashion to get

/1OM/ORDR2IT3403------ITMID ,

/1OM/ORDR1NOT403----NOTEID

/1OM/ORDR4SDL403-----SDLID

Best Regards

Vinod

[Former Member · Accepted solution]

Hi Vinod,

Thanks for your reply.

My question was not clear, I agree. I already have those ID´s, I need to convert them into numbers.

When you look at /SCA/IDCONVERTER what I have is the fields like Partner ID and what I need is Partner number, but for mentioned fields (ITMID, NOTEID, SDLID).

Thanks in advance,

TP

[Former Member · Accepted solution]

Hi KP

Query this table /1OM/ORDR7MP3403 (CNTRLSHIFTF10)

Here you get PRTID, SDLID & ITMID all linked

But i still doubt you need to have some primary key like location number, product number or user name.

To give as input to the above table.

Or you can enhance the program /SCA/DM_MDL_ID_CONV, take some ABAPER help, as you are already aware of FM and Tables he should be able set up.

Best Regards

Vinod