Hi,
Basically I have a large set of data, that displays static settings for materials.
I want to be able to either set up a small list within the load script so I can filter the load each time to see differing data.
So for example
Load 1
filter for Material
1
2
3
4
5
A few days later I only want to see the data for
Materials
6
7
8
9
10
Script so far is
Unqualify *;
[MARC_temp_87d861dd-71d5-4843-84d5-b2e661c5]:
LOAD
[Purchasing Group] AS [MARC.Purchasing Group],
[MRP Controller],
[Plant] AS [MARC.Plant],
[Material],
[Maintenance status],
[Plant-Sp.Matl Status],
[MRP profile],
[MRP Type],
[Planned Deliv. Time],
[GR processing time],
[Lot Sizing Procedure],
[Procurement Type],
[Reorder Point],
[Safety Stock],
[Minimum Lot Size],
[Maximum Lot Size],
[Fixed lot size],
[Mixed MRP],
[In-house production],
[Source list],
[Consumption mode],
[Bwd consumption per.],
[Fwd consumption per.],
[MRP Group],
[Planning Strategy Group],
[Safety Stock Method],
[Minimum lot size],
[Maximum lot size],
[GR Processing Time],
[GI Processing Time]
RESIDENT [MARC];
DROP TABLE [MARC];
[MRP_CONTROLLER_temp_d9326bb3-9f94-51c3-3548-54e12c25]:
LOAD
[Plant] AS [MRP_CONTROLLER.Plant],
[Purchasing Group] AS [MRP_CONTROLLER.Purchasing Group],
[MRP Controller],
[MRP controller name]
RESIDENT [MRP_CONTROLLER];
DROP TABLE [MRP_CONTROLLER];
RENAME TABLE [MARC_temp_87d861dd-71d5-4843-84d5-b2e661c5] to [MARC];
RENAME TABLE [MRP_CONTROLLER_temp_d9326bb3-9f94-51c3-3548-54e12c25] to [MRP_CONTROLLER];
Ideally I just want to be able to copy and paste a vertical list of materials, without having to add commas etc.
Hope this make sense TIA
