WWi symbol - function module to fetch multiple specification data

[Former Member]

HI,

We have an unique requirement in cover sheet development.

Cover sheet must show the specification details, instead of material Name/No. related to that delivery.

In our business process, there may be chance of more specifications assigned to single material and

Out bound delivery No.Holds 1:N materals.

Have a plan to append the existing structure "RCGSDDOC", to capture the specificaiton details.

Here the main problem is the structure holds the single value.

Does any one have an idea/ worked on this similar scenario, pls., share your ideas.

And also specify the standard function modules available under parameter symbols to fetch delivery related data.

Found the funciton module "c128_dummy_conversion_method", as an example to build.

still have interfacing doubts, that how this works.

Waiting for your valuable replies.

Regards

kamal

[christoph_bergemann]

Dear Kamal

I have some doubt that you will get a solution. The reason is like this:

1.) Cover Sheet is "only" designed to print data using "parameter symbols" (like material number etc.) and not specification details

2.) If we are talking about "normal wwi" document you need a substance generation variant to be combined with the WWI template. The Cover Sheet is not related to a substance generation variant. How would you like to retieve the data? Example: let us assume you would like to print "density" data in the cover sheet. from the perspective of WWI any report symbol availabe is a report symbol which should be used only in connection with a normal WWI document. In the generation variant there is a "logic" to select the "right" data set (by using the combination of rating and usage). This functionality does not exists regarding Cover Sheet.

By using the term "specification details": what do you have in your mind? Identifiers?

I belive you might be able to print DG data on cover sheet (using the dangerous goods master) but I have really doubts what you will get a solution regarding "form, color etc."

If I remember correct there are no standard symbols devilvered to read direct the dangerous goods master.

With best regards

C.B.

PS: can you please explain more your term:

" there may be chance of more specifications assigned to single material "; #

A material is related to a REAL_SUB (not talking about DG part).

A REAL_SUB can have "compositions etc". and therefore "indirect" relations to other specifications but SAP is forcing  that the material = REAL_SUB link must be unique and there are many OSS notes in explaining that you are not make sure that this is not "supported" by standard delivery but that you must do something by your own

PPS: may be read cross the cover sheet topic here: http://help.sap.com/erp2005_ehp_06/helpdata/en/c1/eda0f591ec12408b25e7a1b369ca45/frameset.htm

[Former Member]

Hi Christoph,

Thanks for your reply.

" there may be chance of more specifications assigned to single material "; #

We have a typical requirement, that the single material may have more brand names. These brand names we are maintained in custom specificaiton. Not in REAL_SUB.

Those custom specificaitons are assigned to material, stored in ESTMJ table.

requirement is to, get the brand names into cover sheet......which were maintained inside the specification.

I planned to append the structure RCGSDDOC, which pulls the material name and material no. etc., In addition to that it pulls these specificatoin data along with material No.

But I can able to do that for single specificaiotn at a time. As structure holds the single value

If multiple specificaiotns assigned, then my solution..may not workout.

At same time if the delivery document contains multiple materials, once agian it's going to tough job by appending the structure.

I have a plan to insert the "funciton module", by using the cusotm symbols in wwi template...which fetches the above values. But facing an issue with the function module interface.

Would be appreciated, if any one can share their experience in WWI template function module creation.

Regards

kamal

[christoph_bergemann]

Dear Kamal

I can not completley follow your explanations. I am struggeling with this explanation:

"We have a typical requirement, that the single material may have more brand names. These brand names we are maintained in custom specificaiton. Not in REAL_SUB.

Those custom specificaitons are assigned to material, stored in ESTMJ table."

Therefore i try it different:

In SAP SD etc. logic you will use a material number to handle the whole logistic process. Because of several reasons you will integrate SAP SD process with SAP EH&S Process. One example is dangerous goods management, a different example is MSDS distribution.

Regarding MSDS distribution you must make sure that in chapter one of MSDS the "trade name/brand name "is printed. Same is true regarding label management. On Cover leter you will repeat "Trade name/brand name".

Most of the companies use this model to handle this situation:

a.) they create one REAL_SUB which is used to prepare label and MSDS (raw report)

b.) they assign many material numbers to the same REAL_SUB. These material number differentiate only either by brand name of by packaging sizes etc.

What is the background of:

"Those custom specifications are assigned to material, stored in ESTMJ table."

Does that mean you have a REAL_SUB = material assignment and at the same time the same material number is assigned to a object called like "Z_CUSToMER" (different specification type?) which is used only (?) to store the different brand names?

Can you please help me better to understand whcih data model you are using?

wih best regards

C.B.

PS: keep in mind that during MSDS distribution trade names etc. are stored in corresponding EH&S tables to handel subsequent shipment etc.

[Former Member]

Hi Christoph,

Hope we are deviaiting from the original requirement. Issue is not related to data model.

we are facing an issue with wwi template funciton module creation.

Data model was designed based on the interface we had with the third party tool.

In our case,

1. we have multiple specifications assigned to single material (custom specificaitons not REAL_SUB).

2. We can write an internal table/ structure/ appending an existing structure, to maintain these  specification data.

3. created a function module to fetch the data from above tables to wwi template.

But the values not carried to the final cover sheet report template.

I am expecting a solution that, any precautions/ techniques we have to follow.....while creating the funciton modules for wwi template & configuration side.

Regards

kamal

[christoph_bergemann]

Hello Kamal

very tricky demand. I can not help you on the ABAP level but may be can provide a further tip/hint/advice.

Refer to EHS documentation:

"Since cover sheet templates are always expanded completely as final cover sheets (there are no cover sheet bodies), the system only expands symbol types with an expansion time 20 (symbol value is application-dependent),"

Therefore I am not sure if your data model can be applied here because anything which is maintained on specification level will lead to a report symbol which is expanded at expansion time 10 ! and not 20. I have never tried to define a report symbol which should be expanded at expansion time 20 and should read specification data.

Structure

RCGSDDOC contains MATNR as a value.

Normally by using this value you can retrieve the "material name" of the "MATNR" using an existing EHS symbol in cover sheet template.

Now you have used a clever trick to maintain different trade names using this MATNr in combination with further specifications. But I am still struggeling in understanding your data model which you have used. Therefore can you pleas explain: how do you maintain the trade names on "custom specification" ? as an identifier? What are you thinking about if you will enlarge RCGSDDOC structure by further fields? Which fields would you add?

Some general information regarding "Cover Sheet WWI":

If you would have been able define the "cover sheet" and assigned it to MSDS process the cover sheet will be used in MSDS distrinution in bundling process. It is important to understand that if you then check transaction CVD1 you will find the corresponding cover sheet but ! the report symbols are not retrieved here !! You can check content of cover sheet only ! by first make a "internal call" to a SAP partner (your self) and send it to a printer e.g.

That means: in contrast to MSDS Template in CVD1 you will see only the "report symbols" as part of the cover sheet but no text (or may be only phrase texts).

I am really sorry: Your requirement is very special and therefore I can onbly provide hints and no suitable solution regarding your demand

With best regards

C.B.

[christoph_bergemann]

Dear Kamal

check may be: http://scn.sap.com/thread/3436755

I believe this thread might be helpful for your context

C.B.