cancel
Showing results for 
Search instead for 
Did you mean: 

Report Shipping for MSDS & Schema Condition table

MariaWilson
Explorer
0 Kudos
1,102

Hi,

Our US site wants to maintain 2 different MSDS Generation Variants as they want to steadily migrate over to the latest SERC WWI SDS templates. They don't want to do a mass SDS generation as it's too much work for them. They also only want language Z8 - American English only to be generated.

My questions are:

  1. Can 2 different Report Generation Variants be used for the same country?
2. How should the setup be maintained in SPRO: 'Specify Condition Schemas for Report Generation Variant Selection'? 3. Are there other tables/areas in SAP configuration that needs to be maintained?

4. How is the language for the Report Shipping maintained? Is this in CG2B: Ratings/Validity Area?

I have attached a screenshot of how I maintained as per Q2.(attachment encl). We 2 entries set up: SDS_NA_US and SDS_US_GHS.

I added the Sales Org 5000 in SDS_NA_US as SAP wasn't allowing me to have 2 different entries for Country: US. It seemed to require a distrinction between them so I cusersmariawilsondesktopus-report-shipping-query-t.pngcusersmariawilsondesktopus-report-shipping-query-t.pngadded SO 5000. I don't think this is right to be honest.

I have also enclosed an attachment of an email from the site to give you more details of the issue.

In addition, could you also provide me with OSS notes that best match my issues. I don't know anything really about Report Shipping and its setup so any information would be great. I have tried searching the Knowledge Database and not having much luck.

Thanks a lot.

Accepted Solutions (1)

Accepted Solutions (1)

MariaWilson
Explorer
0 Kudos

Thanks a lot for all your help guys.

Answers (4)

Answers (4)

Mark-Pfister
Active Contributor
0 Kudos

Hi Maria,

1) What kind of custom coding do you mean? As the site wants to add an additional RGV to the Report Shipping, is there really a lot of work involved?

Since this is for the US and there are no subsequent report shipping requirements its not that complicated. Basically the coding that selects the GenVar needs to get adjust to first check for US-Z8 and if that is not the for US-EN.

BTW: I don't understand this:

They don't want to do a mass SDS generation as it's too much work for them. They also only want language Z8 - American English only to be generated.
They do not need to review the data - the only thing that can happen is missing phrases text for custom phrases in Z8.....

Another easier solution would be - depending on the amount of SDS needed for the US - the following:

Replace (or set to historic) all SDS_US in language EN with SDS_US in language Z8. Then change the customizing so the language for the US is Z8...

Kind Regards

Mark

former_member212503
Participant
0 Kudos

Hi Mark ,

Can we maintain as many languages to Country under " Assignment of Language Versions to Country Code " if I want to generate reports in many languages in Cg02 " Create report from languages from Gen variant option ?

Mark-Pfister
Active Contributor
0 Kudos

Hi Krisnha,

What prevents you from just trying it out? It'll take you a couple of minutes to change the customizing and observe the affects....

Kind Regards


Mark

Mark-Pfister
Active Contributor
0 Kudos

Hello Maria,

A detailed report shipment configuration guide is available from SAP via OSS Note 1096697 - EH&S report shipping

1. Can 2 different Report Generation Variants be used for the same country?

Yes - I have set up systems in the past to do this.
But this always needed custom coding. I'm not sure if you could do this just with only customizing.

3. Are there other tables/areas in SAP configuration that needs to be maintained?

Yes - basically everything under the IMG Node "Report Shipping". See OSS Note 1096697 - EH&S report shipping

4. How is the language for the Report Shipping maintained? Is this in CG2B: Ratings/Validity Area?

No, it is not CG2B. It is this IMG activity: "Assign Language and Lead Time to Country" under "Basic Settings for Shipping from SD Documents"

Hope this helps


Mark

christoph_bergemann
Active Contributor
0 Kudos

Dear Mark

in context of:

But this always needed custom coding. I'm not sure if you could do this just with only customizing.

It is always ! custom coding. There is no option which i know to solve teh demand using customizing only.

C.B.

christoph_bergemann
Active Contributor
0 Kudos

Hello

for: "They also only want language Z8 - American English only to be generated."

you must differentiate two steps in the process

1.) step one is: generate a WWI report with language "z8" (this is an user action )

2.) step two: by using proper customizing: make sure that "report distribution" process looks only for WWI reports (for US) with language "z8" (and not with EN)

These two topics are only indirect linked

For: "4. How is the language for the Report Shipping maintained? Is this in CG2B: Ratings/Validity Area?" answer is "no" (therefore answer of Jayakumar is wrong; Jayakumar is looking on "content" of WWI. Here he is correct; but not for the "report shipment" process and selecting reports with "Z8" in comparison to EN)

The language definition(that means: which WWI report with which language is "searched for" is part of "report shipment" set up

Based on Jayakumars reply: there are some "exits" for identifing "generationvariant etc.". Can not remember the name; PLease check customizing

In any case. Whatever you do: you must have a "super perfect" blue print (and luckily for US it might work but not for europe). The issue is the "subsequent" shipment (i will not explain the details; this would be a "booklet")

C.B.

PS: there is no "specific" OSS number. Just look for the "general" OSS discussing "report shipment" process. This number is discussed so often here: i will not repeat the OSS number

PPS: please read cross: https://blogs.sap.com/2013/05/18/customer-exits-in-sap-ehs-management/

The "exits" which could be used are listed there (But in your case: it is not an easy task !)

former_member408313
Active Participant
0 Kudos

Thanks Christoph, I missed out on the main part of languages and lead time configuration item.

former_member408313
Active Participant
0 Kudos

Hi Mariya,

It is not possible to define two generation variants for the same country, if some other parameter is not defined like Sales Organization.

Below is more detailed explanation based on your series of questions.

1. No, two Report generation variants be used for same country

2. You can not use Condition Schema 4 for this scenario, you may check the BAdI under report shipping or using some type Regulation / Gen Variant combination logic (which is actually used for TremCard)
but this will have impact all the MSDS Distribution scenairos as system needs to identify a unique MSDS document to ship to the customer

3. Standard out of the box it is not supported to use two different GV for same country combination, unless you separate based on Sales Organization.

4. Yes, it is in the Generation variant CG2B

Finally the solution is to use a one single GV which is stable for a period of time. You need to change the Condition table 4 configuration as and when you need to send a new GV for that country.

Thanks and Regards

Jayakumar