Ugent Modelling issue

24 Views

There are 7 z tables in R/3 and i have made 1 to 1 mapping and created 7 different ods.

now i want to see the possibility of combining the ods and make an another ods for the second layer. i am giving the primary keys of the differnt tables below,pls suggest which can be combined and a second layer can be made.

TABLE1

SERVGRPID CHAR 2 0 Service Group ID

SERVICEID CHAR 3 0 Service ID

TABLE2

MODECODE CHAR 1 0 Shipment Mode

VALIDFROM DATS 8 0 Valid From

VALIDTO DATS 8 0 Valid To

VERSION NUMC 3 0 Version Number

TABLE3

SERVGRPID CHAR 2 0 Service Group ID

SERVICEID CHAR 3 0 Service ID

SHIPMODE CHAR 1 0 Shipment Mode

VENDOR CHAR 10 0 Account Number of Vendor or Creditor

PORT CHAR 3 0 Port Code

CONDIND CHAR 1 0 Condition Indicator

RANGEID CHAR 4 0 Range Id

GJAHR NUMC 4 0 Fiscal Year

VERSION NUMC 3 0 Version Number

TABLE4

SERVGRPID CHAR 2 0 Service Group ID

SERVICEID CHAR 3 0 Service ID

SHIPMODE CHAR 1 0 Shipment Mode

VENDOR CHAR 10 0 Account Number of Vendor or Creditor

PORT CHAR 3 0 Port Code

CONDIND CHAR 1 0 Condition Indicator

RANGEID CHAR 4 0 Range Id

GJAHR NUMC 4 0 Fiscal Year

VERSION NUMC 3 0 Version Number

TABLE5

SERVGRPID CHAR 2 0 Service Group ID

SERVICEID CHAR 3 0 Service ID

SHIPMODE CHAR 1 0 Shipment Mode

VENDOR CHAR 10 0 Account Number of Vendor or Creditor

PORT CHAR 3 0 Port Code

CONDIND CHAR 1 0 Condition Indicator

RANGEID CHAR 4 0 Range Id

GJAHR NUMC 4 0 Fiscal Year

VERSION NUMC 3 0 Version Number

TABLE6

ZONECODE CHAR 3 0 Zone Code

TABLE7

PORTCODE CHAR 3 0 Port Code