Check table & value table

[Former Member]

Hi All,

Can anyone tell me when does a value table behave like a check table or when a value table can be said to be a check table.

[RaymondGiuseppi]

value table comes usually from domain attached to data element, check table comes from a foreign key, by default value table are proposed as check table, but this can be overridden.

Look at some links like

- [Value Table|http://help.sap.com/saphelp_nw70/helpdata/EN/e2/667092730811d2959500a0c929b3c3/frameset.htm]

- [Foreign Keys|http://help.sap.com/saphelp_nw70/helpdata/EN/cf/21ea77446011d189700000e8322d00/frameset.htm] (of a check table)

so the difference come from the use as a foreign key.

Also perform some [search at sdn|https://www.sdn.sap.com/irj/scn/advancedsearch?query=checkvaluetable&cat=sdn_all].

Regards

[Former Member]

Hi,

Say you have two tables Itab1 & Itab2.

Itab1:F1(Key Field),F2,F3.

Itab2:F4(Key Field),F5,F1(Forign Key Field).

Insert table ITab1 at Domain Level of Field F1.(Value table Field = F1 -->Domain Level)

Make Forign key relation ship between Itab2 and Itab1.

So Value table Itab1 Becomes check table of Itab2.

Itab1 is value and check table both for Itab2.

Value Table will make the preposal for the foreign key relationship bet ween two tables.

[Value table|http://help.sap.com/saphelp_nw70/helpdata/EN/e2/667092730811d2959500a0c929b3c3/frameset.htm]

[Check table|http://help.sap.com/saphelp_nw70/helpdata/EN/63/1b70bcc32111d1950600a0c929b3c3/content.htm]

Regards,

Gurpreet

[Former Member]

q