Modeling

[Former Member]

Hi All,

I have the following requirement:

Plant customer code

1 c1 M1

1 c2 M2

1 c2 M3

1 c2 M4

1 c2 M5

2 c1 M6

2 c2 M7

2 c3 M8

2 c3 M9

i get only the code from the transaction data i need to model that, so how do i go by modeling, I already have the master data for plant and customer, does it help if I make the code as nav. Attribute for plant and make it cust specific but a particulat cust may have many codes for one plant.

[Former Member · Accepted solution]

What is this code and how is it related to plant and customer?

[Former Member · Accepted solution]

it is a supplier location from where the materials are shiped to the customers and each customer may have different supplier locations shipping to them and the supplier locations fall under a particular plant.

[Ashwin · Accepted solution]

Hi!

it is not clear what you mean by modelling.(ODS, cube, Report...????)

but in any case i think acording to the scenario it is not a right option to have the code as an attribute of plant as each plant can be associated with multiple codes...

can you explain with more details like what do you get in datasource and what you want to display in query and what you want to store in infoprovider.

with regards

ashwin

[Former Member · Accepted solution]

Hi,

As far as I remember, the shipping point may belong to several plants. And items to a particular customer may be shipped from different shipping points. So, it's not logical to make a shipping point as a nav attribute to either plant or a customer. Make it as an independent attribute. Your transaction data should contain shipping/delivery information (maybe through shipment/delivery # ).

Best regards,

Eugene

[Former Member · Accepted solution]

Hi Eugene,

Can you explain in detail what do i do after creating an indepedent attribute?what should my transaction data contain?

[Ashwin · Accepted solution]

hi!

if you are storing in a ODS then you should have customer and plant in key and code must be in data part . if you are using cube then you must have all 3 charecteristics aailable in cube. i cant say how you design cube as you dont have any key figure here.

with regards

ashwin

[Former Member · Accepted solution]

as far as my senario is concerned, a shipping point is assigned to one and only one plant and each customer is shipped from any shipping location falling under any plant, i am trying to create a infoobject that kind of combines customer, plant and the code, finally i will be using this in reporting where i need to report on each shipping loc, plant and code, does this help?

[Ashwin · Accepted solution]

Hi!

ok if you are sure of this association beetween one code to only one plant . as you mentioned that you are getting code as a part of your transactional data so it is better to maintain plant as a navigational attribute of code because one code has only one plant.

with regards

ashwin

[Former Member · Accepted solution]

and waht about customer????

[Ashwin · Accepted solution]

Hi!

you havent specified any information on what is available from infosource for transaction data.

Ok i assumed that you get

Customer., Code ... and xxx in your transactional data infosource

you can create a data target containing these customer anc code. then you can use plant in your queries as it is a navigational attribute of code.

with regards

ashwin

[Ashwin · Accepted solution]

I think if the customer is not directly deleverd in transactional infosource ..then you have to findit using some kid of routine in your update rules because each delivery transaction will definatly have a customer ..and may be you can find it using the order no.

other wise it would be dificult to link a transactional data record to a customer because there can be multiple customers who get the deliveries from same code and same plant...

so in short in my openion customer and code must be part of your data target as transactional data.

with regards

ashwin

[Former Member · Accepted solution]

I have one more Question. if i create a info object with 0customer as reference char, and i use it in my infosource and upload the trans data, lets say that there are some entries for the new info object which are not in 0customer so will they be updated only in the master data of the new infoobject or even the 0customer's master data is modified?

[Ashwin · Accepted solution]

hi!

actually when you createa ne IO as a reference of 0customer all the master data is stored in the 0customer tables so there will not be any seperecords maintained for the new IO.

if there are new entries in your data then these records are entered in to 0customer masterdata and SIDs are created.

with regards

ashwin

[Former Member · Accepted solution]

in the previous case making plant as navigational attrib of code will work if there is a 1 to many relation between plant and code?

[Ashwin · Accepted solution]

It works even if A plant has more than one code...

because you are accesing plant youing code as a key and each code is associated only to one plant so you can get the plant information.

It works...

with regards

ashwin