data base table

[Former Member]

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

[suresh_datti]

MARD & T001L.

~Suresh

[Former Member]

refer the table

MARD Storage Location Data for Material

MCHB | Storage location data with stock

regards

vivek

reward points if this helps

[Former Member]

hi,

check the table T001L - LGOBE field

Regards

[Former Member]

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

and from address number u can get address in table ADRC

[former_member404244]

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

[Former Member]

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

[Former Member]

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

[former_member181966]

Look at tables...

ADRC , MARD,MARDH,MCHB .

Thanks,

Saquib Khan

[Former Member]

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.

[Former Member]

Hello,

Table MARD.

Regs,

Venkat