Fields Validation

[Former Member]

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

[Former Member]

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

[Former Member]

Hello,

Check the table KNA1.

Cheers,

Vasanth

[Former Member]

Hi Vasanth ,

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

Please help me

[Former Member]

Hi

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

regards

Shiva

[Former Member]

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.

[Former Member]

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

[Former Member]

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

[Former Member]

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

To validate KUNWE check with KUNNR in table KNA1.

[Former Member]

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.