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

Monday, December 1, 2008

WPF - Working with XML file using Linq to XML

Building WPF ListView application to read XML file using Linq to XML

Recently I published my first article on codeproject.com and the link access article is http://www.codeproject.com/KB/WPF/WPFandXML.aspx

The article discuss on building a user interface using Microsoft 's Windows Presentation Foundation (WPF) using customer master table as datasource.

Let me know your comments and feedback on the article.