<?xml version="1.0" encoding="utf-8"?>
<ManualTopic ID="/baanerp/tl/onlinemanual/000036" xml:lang="en">
	<Header>
		<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">To construct a table set</Title>
		<Keyword ContextSensitive="No"><Level1>table sharing</Level1>
		</Keyword>
		<Keyword ContextSensitive="No"><Level1>table set</Level1>
		</Keyword>
	</Header>
	<GeneralSection><Paragraph class="Default">This topic describes how you create and fill a <Link href="/baanerp/tl/glossary/glossary#000002" role="glossary">table set</Link> that you can use to define a suitable table sharing configuration. You can subsequently implement this table sharing configuration by using <Link href="/baanerp/tt/glossary/glossary#000045" role="glossary">table linking</Link> or <Link href="/baanerp/tt/glossary/glossary#000043" role="glossary">data replication</Link>.</Paragraph>
		<Paragraph class="Default">The construction of a table set is an iterative process. You start with a table set with a few tables based upon a functional sharing requirement. Then, you repeatedly verify the table set and add the tables that must be shared for technical reasons. For technical details, refer to the Reference Guide for Multicompany Structures.</Paragraph>
		<Paragraph class="Default">Alternatively, you can import the current table linking situation into a table set, to identify or to diagnose problems. For more information, refer to <Link href="/baanerp/tl/onlinemanual/000032" role="manual">To analyze the present table linking configuration</Link>.</Paragraph>
	</GeneralSection>
	<GeneralSection><SectionTitle>Prerequisites</SectionTitle>
		<Paragraph class="Default">Before you define a table set, you must specify the relevant <Link href="/baanerp/tt/glossary/glossary#000000000000012" role="glossary">package combination(s)</Link> and <Link href="/baanerp/tc/glossary/glossary#Company.tc" role="glossary">companies</Link>. For more information, refer to <Link href="/baanerp/tl/onlinemanual/000034" role="manual">To specify relevant package combinations and companies</Link>.</Paragraph>
	</GeneralSection>
	<GeneralSection><SectionTitle>Procedure to construct a table set</SectionTitle>
		<ProcedureList><ListIntro>To construct a table set, use the following procedure:</ListIntro>
			<ListItem>Start the <GUIRef href="/baanerp/tl/tsm/tltsm1100m000" role="session">Table Sets (tltsm1100m000)</GUIRef> session.</ListItem>
			<ListItem>Define a new table set.</ListItem>
			<ListItem>Use the <GUIRef href="/baanerp/tl/tsm/tltsm1150m000" role="session">Table Sets by Package Combination (tltsm1150m000)</GUIRef> session to link the table set to a package combination. ERP LN uses the link with the package combination to determine which <Link href="/baanerp/tt/glossary/glossary#000046" role="glossary">references</Link> are active for this software version.</ListItem>
			<ListItem>Fill the table set with tables. Use one or more of the following methods: <List><ListItem>To add tables manually, click <GUIRef href="" role="manual">New Table</GUIRef> on the <GUIRef href="" role="manual" Update="No">Lines</GUIRef> menu. You can add tables individually or add entire modules, from which you can exclude specific tables.</ListItem>
					<ListItem>To copy tables from an existing table set, click <GUIRef href="/baanerp/tl/tsm/tltsm1100m000#copy.from.other.ts" role="command">Copy from other Table Set</GUIRef> on the <GUIRef href="" role="manual" Update="No">Specific</GUIRef> menu. For more information, refer to <Link href="/baanerp/tl/onlinemanual/000038" role="manual">Predefined table sets</Link>.</ListItem>
					<ListItem>To add a range of tables or a range of modules, click <GUIRef href="/baanerp/tl/tsm/tltsm1110m000#tltsm1210m000" role="command">Copy from DD</GUIRef> from the <GUIRef href="" role="manual">Specific</GUIRef> menu on the <GUIRef href="" role="manual">Tables by Table Set</GUIRef> tab.</ListItem>
					<ListItem>To use the current table linking configuration (logical tables) as a starting point, click <GUIRef href="/baanerp/tl/tsm/tltsm1110m000#copy.logical.tables" role="command">Import Logical Tables</GUIRef> from the <GUIRef href="" role="manual">Specific</GUIRef> menu on the <GUIRef href="" role="manual">Tables by Table Set</GUIRef> tab.</ListItem>
				</List>
			</ListItem>
			<ListItem>Click <GUIRef href="/baanerp/tl/tsm/tltsm1100m000#tltsm1201m000" role="command">Verify Shared Logical Tables</GUIRef>.</ListItem>
			<ListItem>Click <GUIRef href="/baanerp/tl/tsm/tltsm1100m000#tltsm2100m000" role="command">Table Sharing Exceptions</GUIRef>. (If the <GUIRef href="/baanerp/tl/tsm/tltsm0100m000#tltsm000.fsvr" role="manual">Fast Verification</GUIRef> check box in the <GUIRef href="/baanerp/tl/tsm/tltsm0100m000" role="session">Table Sharing Parameters (tltsm0100m000)</GUIRef> session is selected, the <GUIRef href="/baanerp/tl/tsm/tltsm2100m000" role="session">Table Sharing Exceptions (tltsm2100m000)</GUIRef> session is started automatically when you verify the table set).</ListItem>
			<ListItem>Assess the exceptions found. For a graphical view, click <GUIRef href="/baanerp/tl/tsm/tltsm2100m000#show.relation.tree" role="command">Show Relation Tree</GUIRef>. Check for exceptions with status <GUIRef href="/baanerp/tl/domains/tsm.excs#actual" role="option">Actual</GUIRef>. <List><ListIntro>You can respond to an identified exception in one of the following ways:</ListIntro>
					<ListItemHead><GUIRef href="/baanerp/tl/tsm/tltsm2100m000#accept.one" role="command">Accept</GUIRef>
					</ListItemHead>
					<ListItem>If you accept an exception, the <GUIRef href="/baanerp/tl/tsm/tltsm2100m000#tltsm200.excs" role="manual">Exception Status</GUIRef> turns to <GUIRef href="/baanerp/tl/domains/tsm.excs#accepted" role="option">Accepted</GUIRef>. The exception will no longer block a table sharing set from being made actual.</ListItem>
					<ListItemHead><GUIRef href="/baanerp/tl/tsm/tltsm2100m000#correct.one" role="command">Correct</GUIRef>
					</ListItemHead>
					<ListItem>If you correct an exception, ERP LN adds the <Link href="/baanerp/tt/glossary/glossary#000050" role="glossary">reference table</Link> that produced the exception to the <Link href="/baanerp/tl/glossary/glossary#000002" role="glossary">table set</Link> and removes the exception from the list.</ListItem>
				</List>
			</ListItem>
			<ListItem>Repeat previous steps until all remaining exceptions have the <GUIRef href="/baanerp/tl/domains/tsm.excs#accepted" role="option">Accepted</GUIRef> status.</ListItem>
			<ListItem>In the <GUIRef href="/baanerp/tl/tsm/tltsm1100m009" role="session">Table Sets (tltsm1100m009)</GUIRef> session, set the <GUIRef href="/baanerp/tl/tsm/tltsm1100m009#tltsm100.stat" role="manual">Status</GUIRef> field to <GUIRef href="/baanerp/tl/domains/tsm.tbss#final" role="option">Approved</GUIRef>. (If you need to modify the table set later, you can change its status back to <GUIRef href="/baanerp/tl/domains/tsm.tbss#draft" role="option">Draft</GUIRef> ).</ListItem>
		</ProcedureList>
	</GeneralSection>
	<RelatedTopics><SectionTitle>Related topics</SectionTitle>
		<RelTopic><Link href="/baanerp/tl/onlinemanual/000031" role="manual">To set up a table sharing configuration</Link>
		</RelTopic>
		<RelTopic><Link href="/baanerp/tl/onlinemanual/000038" role="manual">Predefined table sets</Link>
		</RelTopic>
		<RelTopic><Link href="/baanerp/tl/onlinemanual/000035" role="manual">To construct a table sharing set</Link>
		</RelTopic>
	</RelatedTopics>
</ManualTopic>
