Store Clustering Details

[Former Member]

Hi,

I am in the process of doing Store Clustering based on few parameters like Vendors, Store Attributes, Product Attributes.

I want to know the table names to get these details. Can someone give me pointers to get the table details.

There are more parameters that I am using, but, they are from Syndicate Data and POS data.   Regards, Gautham

Regards,

Gautham

[Former Member · Accepted solution]

Hi Gautham,

you can get all required detail from the below mentioned tables, hope this will help you.

Vendor   Master	Tables
Vendor Master (General   Section)	LFA1
Vendor Master (Company   Code)	LFB1
Vendor master (VAT   registration numbers general section)	LFAS
Vendor master (dunning   data)	LFB5
Vendor Master (Bank   Details)	LFBK
Vendor master record   (withholding tax types) X	LFBW
Vendor master record   purchasing organization data	LFM1
Vendor Master Record:   Purchasing Data	LFM2
Vendor Subrange	WYT1
Vendor Sub Range   Description	WYT1T
Partner Functions	WYT3
Customer Master	Tables
General Data in   Customer Master	KNA1
Customer Master   (Company Code)	KNB1
Assign customer credit   card	VCKUN
Customer Master   Contact Partner	MASSKNVK
Customer master record   sales request form	MASSKNVD
Customer Master Sales   Data	KNVV
Customer Master   Partner Functions	KNVP
Customer Master   Licenses	KNVL
Customer Master Tax   Indicator	KNVI
Customer Master   Unloading Points	KNVA
Customer master credit   management: Control area data	KNKK
Customer master credit   management: Central data	KNKA
Customer Master: Legal   Control Sanctioned Party List	KNEX
Customer Master (Bank   Details)	KNBK
Customer master   (dunning data)	KNB5
Customer master (VAT   registration numbers general section)	KNAS
Material Master	Tables
General Material Data	MARA
Material Descriptions	MAKT
Plant Data for   Material	MARC
Material Valuation	MBEW
Storage Location Data   for Material	MARD
Units of Measure for   Material	MARM
Sales Data for   Material	MVKE
Forecast Parameters	MPOP
Planning Data	MPGD_MASS
Tax Classification for   Material	MLAN
Material Data for Each   Warehouse Number	MLGN
Material Data for Each   Storage Type	MLGT
Site Master	Tables
Sites/branches	T001W
Valuation area	T001K
Storage location	T001L
Storage location   determination	TWLOF
Scheduling horizons	T436A
Order types for stock   transfers	T161W
Stock planners	T024D
Allowed purchasing   organizations for the site	T024W
Stock levels for   inventory sampling	T064S
Site parameters for   master data maintenance	T130W
Organizational area:   business area determination	T134G
Quantity/value update   control	T134M
Site parameters for   special stock maintenance	T148W
Value table for count   cycles if cycle counting is active	T159C
Default values for   inventory management and physical inventory	T159L

BR

Anup Mishra

[Former Member]

Thanks, Anup,

So, store attributes can be found in Site Master , is it ?

[Former Member]

Yes, you can get all store details/address in site master. for any further detail please let me know.

BR

Anup