TABLE NAMES AND FIELD NAMES

[Former Member]

1) My requirement is to take distributor inventory file & compare to sap inventory, then to provide a comparison report identifying SKU's,

that are not in sync.

selection criteria is

a) Plant

b)sap storage location

c)material number

d)as of date.

E) FILE STORAGE LOCATION.

F) EMAIL ADDRESS.

I could not able to find E & F( mentioned above ) .Please

send respective FIELD NAME AND TABLE NAME.

HELP ME, IT IS URGENT.

[Former Member]

Hi,

you can get these fields from Table MARA,MAKT,MARD,MKPF.

Fieldname

-

---

PLAnt -->WERKS

Storage Location-->LGORT

Material Number -->MATNR

DATE -->BUDAT

You can find these fields from above table......do message if you need more information

Rewards Please if satisfied.....

[Former Member]

hi sharma,

Thanks for replying.

I want table names and field names for

E and F i.e E) FILE STORAGE LOCATION.

F) EMAIL ADDRESS.

plz help me.

regards,

saritha.

[Former Member]

Hi,

email addresss :-- ADR6

Pls. reward if useful....

[Former Member]

Hi friends,

Thanks for replying.

I want table names and field names for

E and F i.e E) FILE STORAGE LOCATION.

F) EMAIL ADDRESS.

plz help me.

regards,

saritha.

[Former Member]

Hi,

ADR6-SMTP_ADDR Email address

[Former Member]

Hi,

For file check TPFID or in SE11 -

---

Give TPF* --> press F4 check for required table.

[Former Member]

Hi,

you can use structure RLGRAP

there is fieldname Filename

go to se11->rlgrap->filename

for email address fieldname->SMTP_ADDR

table name->adr6