Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

ATWRT field is from which database table.

Former Member
0 Kudos

Hi Gurus,

I need to see the field name ATWRT(Manufac Method) for the particular material number.from which database table can i access both the data.Please help me .

Thanks in advance.

Points will be rewarded.

Thanks & Regards,

A.Ashok kumar.

7 REPLIES 7

Former Member
0 Kudos

Hi

these are the tables where atwrt exists:

ABAUSP

AFFV

AFFVB

AFFVD

APICAWN

API_CAWN

API_CCHAR

API_VALI

API_VALUE

API_VAL_IN

CCIHS_IHPRIOT

CCRCS_EHS_SVT_MA

CLGO_MULTIPLE

CLRS_OBJ_KEYS

CLRS_OBJ_VALUES

CLSELSTATISTICS

CLS_CHARAC

COFIV

COFV

COFVP

COME

COMEP

COMER

COMSE

COMW

COVLP

CRMT_IC_SCRIPT_M

CSIM_ST_DETAIL

CTBW_VALUE_TEXT

CTIH_01

CTMSEXIT001

CTMS_02

CUCD_CONF

CUD0_02

CUGEN_SIMPLE_LIT

CUGEN_SIMPLE_SIN

CUGEN_VALUE

CURTO_CU_GEN_SIMPLE_L

CURTO_CU_GEN_SIMPLE_S

CUSL_01

CUSL_02

CUSL_05

CUSL_06

CUSTOMER_FILTER_CHAR

CUXREF

CUXR_OBJ

CUX_EXP_VALUE

DDB_AW

DDB_C01

DDB_C02

DDB_C03

DDB_C04

DDB_C06

DDB_C07

DESCR

DIWPS_ATINN

DIWPS_CA

DIWPS_CONF

DIWPS_CONF_MARK

DIWPS_RV_ATINN

DIWPS_RV_CA

DIWPS_RV_CONF

DIWPS_RV_CONF_MARK

DIWPS_RV_NAV

DIWPS_WA_WORKPACKAGE

DIWPS_WPID_CONF

DIWPS_WP_NAV

E1AUSPM

E1CAWNM

E1CUV1M

E1EDL12

E1EDL15

E1ISU_SDORD_POS_CONF

E1WBB17

DIWPS_ATINN

DIWPS_CA

DIWPS_CONF

DIWPS_CONF_MARK

DIWPS_RV_ATINN

DIWPS_RV_CA

DIWPS_RV_CONF

DIWPS_RV_CONF_MARK

DIWPS_RV_NAV

DIWPS_WA_WORKPACKAGE

DIWPS_WPID_CONF

DIWPS_WP_NAV

E1AUSPM

E1CAWNM

E1CUV1M

E1EDL12

E1EDL15

E1ISU_SDORD_POS_CONF

E1WBB17

E1WTADDI12

E2AUSPM

E2CAWNM

E2CUV1M

E2EDL12

E2EDL15

E2WBB17

E3AUSPM

E3CAWNM

E3CUV1M

E3EDL12

E3EDL15

E3WBB17

ECONF_OUT

EHQMSAPIM1

Regards

Preeti

<b>

Reward if useful</b>

0 Kudos

Hi Preeti,

Thank you for your reply.but my requirement is Data base tables not structure..which contain both matnr and atwrt.Help me on this .

Thank you.

Regards,

Ashok kumar.

0 Kudos

Hi Ashok,

Were you able to get an answer for this? If yes, please advice.

Thank you - shanal

0 Kudos

You check table AUSP - OBJEK is material number prefix with zero's. You need class to get ATWRT value. also check table KSSK and INOB

0 Kudos

Hi

AUSP-OBJEK is nothing but your matnr and it will show you all the values for the all the characteristics.

Br,

Nikhil Patil

Former Member
0 Kudos

Hi Ashok

table is ausp.

ausp-atwrt

reward points to all helpful answers

kiran.M

Former Member
0 Kudos

Hi ,

In such cases u can see table DD03L , in this u give the Fieldname you want to search in the fieldname field .

You will get the list of all the tables in which this field is used .

Atwrt is available in AUSP table ie Characteristics Values...

it stores the value for a object key .

Praveen.

Hope this helps .