topic Re: Fields Validation in Application Development and Automation Discussions

Fields Validation

Former Member — Thu, 21 Feb 2008 11:15:28 GMT

Hi Friends,

Iam getting one input file with werks(plant) matnr(material) kunwe(ship_to) .

Before Iam inserting in to the Ztable i have to check whether werks matnr and kunwe are valid one or not.

For werks i can check in table t001w for matnr i can check in table mara and for matnr and werks combination i will check in marc.

But for kunwe i dont know in which table i have to check.Can any one tell me in which table i have to check for kunwe.And also tell me the table for combination of kunwe and matnr or kunwe and werks or werks and matnrl and kunwe

Pls help me on this

<REMOVED BY MODERATOR>

Edited by: Alvaro Tejada Galindo on Feb 21, 2008 3:31 PM

Re: Fields Validation

Former Member — Thu, 21 Feb 2008 11:21:00 GMT

hi,

u can check all table in which this field is available through T-Code SE15 -

> ABAP Dictionary --->Fields -

> Table Field

<REMOVED BY MODERATOR>

Edited by: Alvaro Tejada Galindo on Feb 21, 2008 3:36 PM

Re: Fields Validation

Former Member — Thu, 21 Feb 2008 11:23:33 GMT

Hello,

Check the table KNA1.

Cheers,

Vasanth

Re: Fields Validation

Former Member — Thu, 21 Feb 2008 11:32:14 GMT

Hi,

Can u check all the fields and their combinations in table starts with KN*.

like KNA , KNB, KNA1.

Etc ..

i think u may get.

Regards.

Re: Fields Validation

Former Member — Thu, 21 Feb 2008 11:35:22 GMT

Hi,

The table which you are lookin for is KNA1.

I will tell how to find such a table for any field.

Open any table which has the field in SE12. Then double click on the field name.

In the displayed window there is a field called "Check Table".. this field will give you the table name to do the validation check for the field.

<REMOVED BY MODERATOR>

Regards.

Edited by: Alvaro Tejada Galindo on Feb 21, 2008 3:37 PM

Re: Fields Validation

Former Member — Thu, 21 Feb 2008 11:36:11 GMT

Hi,

The table which you are lookin for is KNA1.

I will tell how to find such a table for any field.

Open any table which has the field in SE12. Then double click on the field name.

In the displayed window there is a field called "Check Table".. this field will give you the table name to do the validation check for the field.

<REMOVED BY MODERATOR>

Regards.

Edited by: Alvaro Tejada Galindo on Feb 21, 2008 3:37 PM

Re: Fields Validation

Former Member — Thu, 21 Feb 2008 11:36:58 GMT

U can check with table DD03L to find the tables for this field ..

To validate KUNWE check with KUNNR in table KNA1.

Re: Fields Validation

Former Member — Thu, 21 Feb 2008 11:48:27 GMT

Hi Jyothi,

KUNWE is Ship-to-Party, but is still a customer only and will be maintained in Customer Master Table ie KNA1 table.

So using KNA1 as the check table will be the most appropriate.

Regards,

Vignesh K.

Re: Fields Validation

Former Member — Thu, 21 Feb 2008 12:12:29 GMT

Hi Vasanth ,

Is there any table for the combination of ship_to and material or ship_to and plant

Please help me

Re: Fields Validation

Former Member — Thu, 21 Feb 2008 12:21:14 GMT

get the Ship to and Plant in LIKP and get the material and verify the plant in LIPS

regards

Shiva