Skip to Content

Possibility of Adding Product Name in Final SDS Report

We want possibility of adding a new parameter based on which we can determine the Product Name for a particular Material assigned to a specification.

We want to have a logic based on which the product name for a material (to be displayed on the SDS) is determined :

  1. Customer Material Info Record
  1. Else, Sales Text of the Material
  2. Else, Material Description

We do not use the report Shipping functionality.

We were thinking of adding a new parameter for the user to enter during the final report generation in the 'Report Management' and 'Report information System' Screen so that he can select the right product name from the Identifiers in form of a drop down list.

  1. Can anyone help on how we can add this parameter in the above screen?
  2. How this parameter would be made available in as a report Symbol?

Thank you in Advance for your inputs and suggestions.

capture.jpg (52.8 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • Aug 16, 2017 at 08:04 AM

    Hi Gaurish,

    The Parameter report symbols are with the expansion type 20, that means they are expanded in the MSDS report only during the Report Shipping Stage. During Report Management and while viewing reports in Report Information System, they needed to be manually added whenever a pop up is shown.

    it will be challenging to pull the description from the CMIR, as during the Report Management / Report Information system report view we do not have input field for entering the customers unless it used for report shipment. Similarly Sales Text would be difficult to retrieve without actually NAST entries. Material description is feasible from Material master but Material number needs to be input manually during the report information system.

    When you define the parameter symbols in the WWI template, system will automatically shows you that during the Report Management / Information System. If you are not seeing them means the symbols is suppressed while viewing the report. Log out of the transaction and again check the report in CG50 / CG54.

    Thanks and Regards

    Jayakumar

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 19, 2017 at 06:48 AM

    Dear Gaurish

    based on you requirement: you must (should) start "different" First

    You have to differentiate the different "report shipment "processes. The main processes are:

    SD_CALL/SUB_CALL

    MAN_CALL
    EXP_CALL

    If we ignore for a "second" MAN_CALL and "EXP_CALL" you have to start" different. First you must enlarge the SAP SD / SAP EHS interface for report shipment so that the required data from SAP SD process can be handed over to SAP EHS. Then you need to change WWI layuut and prepare a new parameter symbol of type "20" which can use the data from SAP EHS and process this data to show a "product name"

    On the top you should decide: is this a "general" process or e.g. only valid for "EU" but not for US" (as you would need different WWI layouts etc.)

    Depending on the fact: is there sitll a report shipment actrive yes/no: you need to define your blueprint (as you can not support "historic report shipment processes"

    For MAN_CALL: here it depends on your "demand". You can prepare the new report symbol in such a way that the user can enter: either "Customer Material Info record data" or "Sales text" or.. But this is then training (and from my point of view: to complex. just use here "material descritpion" only)

    for EXP_CALL:: it is not a good idea to have "flexibility" here. Here you should only use "Material DescriptioN" (any other demand would be complex)

    C.B.

    PS: you will ffind some thredas here discussing "Paramater symbol" topics. I can remember one blog on top. In any caase. Check on top Marketplace, I believe there is a "note" for parameter symbols (bot 100% sure)

    Propolal: Check frist SAPO original symbol. Then do a "copy" and add your logic

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 22, 2017 at 07:16 PM

    Dear Gaurish

    some add on:

    In context of "We were thinking of adding a new parameter for the user to enter during the final report generation in the 'Report Management' and 'Report information System' Screen so that he can select the right product name from the Identifiers in form of a drop down list."

    a.) in CG54 or CG50 you have the topion to "switch" the "application". E.g. you can use "material masrer data" or "Specification view"!

    b.) You topic is currently related to an "ad hoc final report generation" and this does not have any value. You need a process for "Report distrbution"

    c.) you can not add "field" in the screen. This would be a "modification". but if you have prepared a "parameter symbol" you will get a "popup" and then you can enter the data (or sewlect or...) But this is of "no value" as you can not use the same approach in "reporet distribution"

    d.) normally you do not use" identifiers" to select (this is as well "useless"). Identifiers are "always" part of "raw report" (with some exemptions)

    e.) may be you know? you can add "own developed" applications (thsi is the term as ussed in CG54; not a "good term"). But if you would like to use approach this approach you need to change generation variant as well; nether tried it by my own

    C.B.

    PS: make sure that your "really" understand the "normal" use of CG54/CG50

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 30, 2017 at 06:18 PM

    Dear Gaurish

    after rereading´your demand as:

    1. Customer Material Info Record
    1. Else, Sales Text of the Material
    2. Else, Material Description

    We do not use the report Shipping functionality.

    Some additional feedback

    1.) to get data using "Customer Material Info Record" you need to enter in Cg54/Cg50 two parameters (according to my knowledge of SAP SD)

    a.) one material number (which you need not to enter if you are in "material view" in comparisaon to "specificaiton view")

    b.) a customer number.

    In most cases: person acting does have "lack" of knowledge in SAP SD. But there is normally no "search" machnism availble: so you need to programm your self

    2.) For "sales text of material". you need material number and additional informaiotn

    3.) only for "material descxription" you would need only "material number"§

    From my poitn of view. you shoult stop your approach. Any time the user trying to use CG54/Cg50 you must enter again and again the requested data to get SDS shown properly. Not a good idea. On top: if you use "GLM": this would be a "disaster" as you need to enter the same "parameters" in GLM process to get thr same "name" on label. And this is a "legal must". This would be an additional issue (how to make sure that name on SDS and on Label is the same)

    On top: hwo do you handle "delivery note" in SAP SD process? Which "material name" do you print there?

    For customer communication (e.g. within REACH as an example) you approach is a nightmare and you should "change your mimd" and use "report shipment". Here you have a "perfect" interface SAP SD to SAP EHS; you have (by clever use of EHS) no human being to enter data in the process etc.

    Keep in mind: for external communicaiton either material number or "material text" (whatever kind of text you select) is the crucial sucessfactor

    C.B.

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 13, 2017 at 08:12 AM

    Hi CB,

    Thanks for your feedback and I understand your concerns- for the Labels and the SD delivery Note we have a defined material name based on the MATNR and the Customer Number - this will be:

    1. Customer Material Info Record
    1. Else, Sales Text of the Material
    2. Else, Material Description

    This is because the client sells same Material to different customers with different names. we are able to make this change in labeling process and SD delivery as we have access to the customer Number; BUT Since we don't have report Shipping, its difficult for us to get the customer name. The business users have agreed to maintain the Correct name in NAM,PROD identifier and so that it then pulls it on the SDS.

    I have created a new Parameter Symbol with Expansion Time 20 and added it to the SDS template as below:

    we intend to code the FM in the expansion Value to get the PRDO Names.

    But It dosent appear in the Report Management screen where I can enter the Parameter:

    How do I add new Options to this pop-up ?

    @C.B- I did try to change the view of the CG50 in the Utilities option and in the Material Master view I only get the MATNR and Specification as the option (Screenshot 4)

    In the default key, I could find some more options:I want to add the new Symbol created above to this so that we can write an FM to display all the identifiers (of type NAM, PROD) assigned to the specification and users can manually select the PROD Name on the SDS.

    Regards,

    Gaurish

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 04 at 11:13 AM

    Dear Gaurish

    if this is true: "The business users have agreed to maintain the Correct name in NAM,PROD identifier and so that it then pulls it on the SDS." you can not fulfill the demand...

    Let us start once again from top to down:

    1:) if you create a WWI report you can add reports symbols

    2.) we have specification related symbols, material related symbols, and other symbols

    3.) For all of the symbols you must assign an "application". For specification symbols. this is "SUBMASTER", for material ones MATMASTER"

    But there is no "application" yet existing for "your symbol" which you have in mind

    It is not good idea to combine a "parameter" symbol with a "sepcification" symbol. This is your approach

    But first you should understand the importance of this "application" object. based on the "application" you can change the "view" in CG54/Cg50.

    MOst common is "MATMASTER" and "SUBNASTER". But this does not help. A "NAM PROD" does have no ! refeence to any material number nor customer number. Therefore. You can not suceed

    So sorry. If you are not able (or willing) to setup report distribution process: you will not get sucess. Only by using this approach the is a chance to get what you would like to get (and then only via transaction CVD1)

    C.B.

    Add comment
    10|10000 characters needed characters exceeded