Can anybody help me out as to how this has to be done?wats the check table?

[Former Member]

1. u201CZu201D customizing table to be maintained through TCode SM30 with the following fields:

 Sales Organization

i. **Check Table: V_TVKO

ii. Note: asterisk * could be used as wild card for Sales Organizations

 Order Type

i. Check Table: V_TVAK

 Order Reason

i. Check Table: V_TVAU

ii. Note: more than one order reason can exist for the same combination of Sales Organization and Order Type.

 Order Reason Text

i. Check Table: V_TVAU

2. This u201CZu201D Table should be read every time the Match Code for the Order Reasons is selected when maintaining any kind of Sales Order:

 Sales Order: VA01, VA02, VA03.

 Inquiry: VA11, VA12, VA13

 Quotations: VA21, VA22, VA23

 Scheduling Agreements: VA31, VA32, VA33

 Contracts: VA41, VA42, VA43

[former_member589029]

A check table is a table whose key fields are used to check the foreign key fields of another table. If you define your Z-table, you can assign a check table to any field (e.g. table V_TVKO for the Sales Organization field in your Z-table). The assignment of the check table is done through a foreign key relationship which you define for your Sales Organization field in your Z-table.

The check table is used to check whether the input values are valid and for the input help (F4 help).

Take a look at the [SAP help|http://uksap8.uk.informa.com/saphelp_ism472/helpdata/EN/77/415d363640933fe10000009b38f839/frameset.htm] under foreign keys.

Hope that helps,

Michael