topic Re: data base table in Application Development and Automation Discussions

data base table

Former Member — Mon, 25 Sep 2006 14:07:53 GMT

Hi group,

Can any one give me the database table in which the storage location address contain.

The navigation step of storage location in sap is as below.

spro-> Enterprise Structer->Defination-> material management-> mantain storage location-> Enter the plant->

select one storage location- address of storage location(Right side)->select one of them-> address (shift+F5)

plese explain me also how you got the DB Table.

Regards,

sp sahu

Re: data base table

suresh_datti — Mon, 25 Sep 2006 14:13:48 GMT

MARD & T001L.

~Suresh

Re: data base table

Former Member — Mon, 25 Sep 2006 14:14:06 GMT

refer the table

MARD Storage Location Data for Material

MCHB | Storage location data with stock

regards

vivek

reward points if this helps

Re: data base table

Former Member — Mon, 25 Sep 2006 14:15:10 GMT

hi,

check the table T001L - LGOBE field

Regards

Re: data base table

Former Member — Mon, 25 Sep 2006 14:16:19 GMT

u can get the address number from view V_TWLAD or table TWLAD

and from address number u can get address in table ADRC

Re: data base table

former_member404244 — Mon, 25 Sep 2006 14:17:44 GMT

Hi sahu,

goto SE84->ABAPDICTIONARY->fIELDS->TABLEFIELDS.Now in the field give LGORT .U will get all the tables where LGORT is there.

Regards,

Nagaraj

Re: data base table

Former Member — Mon, 25 Sep 2006 14:18:51 GMT

Hi ,

For the Plant and Storage location in Table TWLAD you will have the address number, Go to ADRC and get the address details for this address number.

Regards,

Sudheer

Re: data base table

Former Member — Mon, 25 Sep 2006 14:19:43 GMT

Address are maintained at plant level..pls check table T001W for the same.

Re: data base table

former_member181966 — Mon, 25 Sep 2006 14:19:47 GMT

Look at tables...

ADRC , MARD,MARDH,MCHB .

Thanks,

Saquib Khan

Re: data base table

Former Member — Mon, 25 Sep 2006 14:23:07 GMT

hi,

We can know the list of database tables used in a given program from Environment analysis.

SE38-> Give program name and press ctrlshiftf2.

in popup, select tables checkbox and press ok.

you will get the list of tables used in that program.

regards,

Sailaja.

Re: data base table

Former Member — Mon, 25 Sep 2006 14:25:21 GMT

Hello,

Table MARD.

Regs,

Venkat