Thursday, December 18, 2008

Cross Reference System Table in Movex/M3

One of the most important tables in Movex/M3 is CSYTAB, the cross reference system table. Lot of the cross reference programs (CRSxxx) stores data in CSYTAB.

The primary key for CSYTAB is the following fields:
CTCONO Company
CTDIVI Division
CTSTCO Constant Value
CTSTKY Key Value
CTLNCD Language

The following SQL statement will show all the records entered in Movex/M3 program or function CRS040 (Item Type. Open):

Select CTSTCO, CTSTKY, CTTX15, CTTX40 from CSYTAB where
CTSTCO = 'ITTY'

CTSTCO CTSTKY CTTX15 CTTX40
ITTY 010 Raw materials Raw materials
ITTY 030 Finished Goods Finished Goods
ITTY 040 Packaging Packaging
ITTY 070 Subcontract Subcontract

The CTSTCO indicated the Constant Value referencing to a group of values. The value ‘ITTY’ in CTSTCO indicates for item type.

The field CTSTKY indicates a key value, which is a value included in the group of Constant Value CTSTCO.

The SQL statement “Select distinct CTSTCO from CSYTAB” will list all the Constant value used in your system.

Some Cross functional programs will use the field CTDIVI, allowing different values to be entered at Division level.

Cross function programs like CRS070 (Delivery method. Open) will use CTLNCD to allow entering same key value for different Language. The SQL statement below includes the CTLNCD:

Select CTSTCO, CTSTKY, CTLNCD, CTTX15, CTTX40 from CSYTAB where CTSTCO = 'MODL'
CTSTCO CTSTKY CTLNCD CTTX15 CTTX40
MODL A00 GB LTL shipment LTL shipment
MODL ONS GB On-Site On-Site

8 comments:

shrirang said...

Hi Shiva

Hope you will place me ... Sadhya kuthe astaat ... pl send me detail mail

shrirang
shrirang_n@hotmail.com
00919176695432
00919820557732

Anonymous said...

Do u have any query for Fixed Assets?

Onildo

Shiva said...

No, I do not have query for the fixed assests.

AM said...

Hello!

Are you going to post again? You're very good!

Anonymous said...
This comment has been removed by a blog administrator.
Anonymous said...

MESSAGE OF JOHN - USA :

yestarday a haved ridden a good information on this blog about a free tool for MOVEX /M3 cross reference , but i don't see this post any more (why ?)

the web site was :

http://m3scan.free.fr

I have tested this tool on my iSeries : very good !

(uncomparable with some other tools more simple as MDP Meta Data Plublisher)

Thank you very much to this blog and for this information !

John.

ashutosh said...

this site also can help http://techrelatedinfo.com/category/movex-erp/

ashutosh said...

hello shiva, i am also working on Movex, so we can share information to each other, can mail: maniashu123@gmail.com