Describe the Source System Data Model

It's important to analyze the relationships between the tables and the existing source data format.

To look at the tables that are used to record the sales data, we can check the tables of the EPM data model in the ITelO source system CIA.

Note

Retailer King uses the same table types to record the sales data.

The table definition is the main source of information and for system CIA, you can find this definition by using transaction SE11.

Different key values distinguish different records. Some tables have a technical key that corresponds to a semantic key. For example, the sales order items table SNWD_SO_I has a technical key field NODE_KEY and corresponds to a combination of the sales order number and position number. The same position number, such as 10, appears in different sales orders. The same sales order number can appear in different records with different position numbers. However, the entries in the NODE_KEY field are unique. Storing data for an existing combination of the sales order number and position number means changing the existing record for this combination.

Let's explore how commonly used business subjects, such as product and employee, are listed in reference tables and used in other tables.