Why same fields appearing more than once in a Table like EKPO , KNA1 ???

[Former Member]

hi ,

in SAP IDES version u will see :

In EKPO table : Two fields MATNR and EMATNR having same spec. and

showing same redundant data in IDES version .

IN KNA1 table : NAME1 field appears twice ...

why so ? any utilities / Reason ????

[Former Member]

HI,

kna1 is customer master table.

now 1 customer can have 2 names like 1 official and one nick name or 2 persons or brothers who are given only 1 customer no kunnr by their vendor.

these things are done by seeing all the business scenarios.

now in table EKPO

MATNR IS PRODUCT NO

EMATNR IS MATERIAL NO.

now there is a difference between product and material.

a material can be a raw material semi finished or finished good,but a product is always a material which is been purchased through the purchase order from the vendor.

the matnr is essentially the final stage of the product by the vendor.

in many cases these contain same data but there are a lot of cases when these things worry.

if you have accesss to your production system then you can check there.

thanks

reward if helpful

vivekanand