SAP Table for Location/Plant Type

[former_member1002054]

Hi,

I am looking for SAP Table for Location /Plant Type. Any help would be appreciate it.

[VeselinaPeykova]

Where do you see this information and what have you tried so far?

There are plenty of guides explaining how you can look for tables in SAP, just search in Google with terms SAP how to find table.

[michael_piesche]

deepak_mistry2711,

>> I am looking for SAP Table for Location /Plant Type. Any help would be appreciate it.
>> Based on your screenshot, the z-name is ZZLOAPLNT

1. Obviously ZZLOAPLNT is a custom field and it either has its own values, or the values are populated from a standard table field such as T001W-WERKS, but it definitley is not a SAP standard field.
2. And the Screenshot is from the output of a report, so we also cant be too sure, if it is a custom DDIC object (such as a domain/data element/table field)

Where is ZZLOAPLNT used:

• I would guess that you should find ZZLOAPLNT either as data element or as domain with SE11.
• Or check database table DD03L to see if ZZLOAPLNT is the fieldname of a database table or a structure
• Use Report RS_ABAP_SOURCE_SCAN with String ZZLOAPLNT and package Z*, to find where ever in the source code this field/fieldname/type is used

How to find the values stored for ZZLOAPLNT:

• If you found ZZLOAPLNT being a DDIC object (field of table/structure, data element, domain), you can drill down to the domain and check whether it has a value table or fixed values
  => If this is maintained, this will give you the possible/valid values for ZZLOAPLNT
• If you found ZZLOAPLNT to be a domain, check which data elements use this domain with the function "Where-Used-List" from SE11 and use the function "Where-Used-List" on all found data elements to find the database tables that use ZZLOAPLNT and check for used values in these database tables
• If you found ZZLOAPLNT to be a data element use the function "Where-Used-List" on that data element to find the database tables that use ZZLOAPLNT and check for used values in these database tables
• If you found ZZLOAPLNT to be a field of a structure, use the function "Where-Used-List" on that structure to find the database tables that use this structure with ZZLOAPLNT and check for used values in these database tables
• If you found ZZLOAPLNT to be a field of a database table, check for used values in these database tables
• => If you found database tables with ZZLOAPLNT, the values for that field in the database table will either give information about possible/valid values for ZZLOAPLNT in case of a value table, or it will give information about actually used/assigned values for ZZLOAPLNT to other objects

[DominikTylczyn]

Look at ZZLOAPLNT - ZZ means it’s not SAP standard. It’s specific to your installation and it’s kinda hard to tell anything with access to it.

What you can do is display ZZLOAPLNT structure in SE11 and find it’s usage with where-used option.

Best regards

Dominik Tylczynski

[former_member1002054]

Thanks, Could you please provide me the program name for ZZLOPLNT.

[DominikTylczyn]

That I can't do without access to your system. However you somehow access ZZLOAPLNT and from there you made the screen shot, don't you?

[former_member1002054]

Its SAP ERP.

[michael_piesche]

deepak_mistry2711, this very valuable and important piece of information should be part of your question or in a comment to your question, but not as an answer, because it doesnt answer your problem, but describes a lot better your question. Answers are for answers to a problem only.

[DominikTylczyn]

T001W - plants

T001L - storage locations

Is that what you are looking for?

Dominik Tylczynski

[former_member1002054]

No. I am looking for Plant Type example: Plant is Warehouse or Manufacture or CSF or Relief.

[DominikTylczyn]

What kind of SAP system are we talking here?

Would you share some screen shots?

[michael_piesche]

Please be a lot more specific in what you are looking for. A plant is different from a location. And what types are you looking for. Do you have screen shots to help us out with what you are looking for? Or do you even have technical names for table-attributes or data elements?

For example, table T001W has "Sites/Branches" (synonyms for 'plant') and it has several 'type' attributes with the following values:

VLFKZ - VLFKZ Site category (Fixed Values, value and description in table-view DD07V):

• A Store
• B Distribution Center

J_1BBRANCH - J_1BBRANC_ Business Place (Customizing Value Table, value and names in table J_1BBRANCH)

NODETYPE Node type: supply chain network (Customizing Value Table, value and description in MDRP_NODT and MDRP_NODTT)

• A Store
• B Distribution center
• CD Customer warehouse
• DC Distribution center
• EW Central warehouse
• PL Production site
• TS Stock transfer point

STORETYPE - WRF_STORETYPE Store Category to Differentiate Store, Dep. Store, Shop (Fixed Values, value and description in table-view DD07V)

• Store
• 1 Department Store
• 2 Shop