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:
CTSTCO Constant Value
CTSTKY Key Value
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