topic Check table & value table in Application Development and Automation Discussions

Check table & value table

Former Member — Fri, 27 Feb 2009 20:13:05 GMT

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.

Re: Check table & value table

RaymondGiuseppi — Fri, 27 Feb 2009 20:23:23 GMT

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

Re: Check table & value table

Former Member — Fri, 27 Feb 2009 20:24:42 GMT

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

Re: Check table & value table

Former Member — Thu, 05 Mar 2009 15:32:32 GMT