RECN entries in SVT confirmed table

[ashish_angus]

Hello,

We are trying to build a solution in SAP EHS - Substance volume Tracking (SVT), which can show confirmed qty data per sales export with sale order number and supplier name in an another customized transaction (copy of report  CBRC20). Standard SAP SVT functionality has limitation in showing detailed confirmed qty data. 

What we observed is, there is a table called CCRCT_SOLO which plays important role. It collects values from MSEG table and also collects RECN number (sequential record number) from SVT table CCRCT_SO.  Thus it is a link between SVT data and Material document data and the link is RECN number from SVT table.  We are struggling to find why CCRCT_SO table entries do not have RECN number available. Without RECN number we cannot proceed further.

Is it anything missing  that it is not filling any RECN number?

Note that in Sand Box  system  AEY- 400, we activated business function LOG_EHS_CI_2 and here we can see the RECN number in several CCRCT_SO entries (but not all).

• Is RECN number display associated with activation of Business function LOG_EHS_CI_2.
• Is there any settings that needs so that RECN number is available for table CCRCT_SO entries.           

Regards,

Ashish

[christoph_bergemann]

Hello I assume you memorize this discussion ?

https://community.sap.com/t5/supply-chain-management-q-a/sap-ehs-svt-display-confirmed-quantity-per-...

[christoph_bergemann]

Hello

and by the way: never received an answer in this thread https://community.sap.com/t5/product-lifecycle-management-q-a/svt-test-confirmed-quantities/qaq-p/34...

Nearly similar topic

C.B.

[christoph_bergemann]

Hello

we are not using SAP standard solution. They SAP is using this "RECN". never understood. If i remember correct: the SAP standard limitation is: they store data only back to at max 90 days.

As you clearly know: as long as we are in the "planned" phase you will find data in CCRCT_SOPL.

The CCRCT_SOLO contains a reference to the "material document"

The issues is: in theory you can have many relevant data. I never have understood how SAP would like to use the "RECN" in CCRCT_SO as it is NOT part of the key.

But you have BADi etc. to enhance the process if needed. Check for reference (if really needed): https://help.sap.com/docs/SAP_ERP/e3e7c06560a54d14ba7f4c52a86635da/83a6ce5314894208e10000000a174cb4....

Here you will find the "90 day" limitation story

I wish you the best

C.B.

[ashish_angus]

Hi Christoph,

Thank you so much for the suggestions and references to the threads provided.  I agree, it has reference to one of the threads created by me which had similar requirement I have put earlier. However, this time we are looking for entire customized report in one dashboard for confirmed qty.  We had already activated  BADI_EHSRC_TRACK_PROC  in Sandbox earlier but it  also needs activation of BF  LOG_EHS_CI_2 ,  and we want to avoid that in other environment due to effects on CG02 report management history display.  Besides, after activating the given BADI, we were able to view only one item at a time. That means, in CBRC20 we need to click  only one item of consolidated confirmed qty to drill down  for detailed confirmed qty history for that substance.

There is a program called RREGCH_EVALUATE_QUANTITIES .  Passing necessary variants there, one can get the Material document and substance information in one screen, but it also uses one material at a time.

Exploring further on this topic.

Regards,

Ashish

[christoph_bergemann]

Hello

one hint of "warning"

Many companies are doing "archiving" of logistic documents to save memory. The strategy to do so is different.

RREGCH_EVALUATE_QUANTITIES

Can be used if the "logistic" documents are not archived and as you have explained only for one material

The SAP standard does work from "CBRC20" hit list and as mentioned only support 90 days.

So if you need a longer period (in most of the cases the answer is "yes") you need to look fo ther options

Now we come to the crucial topic: WHAT IS TO BE SUPPORTED Exactly?

And based on that: you will easily find a customer solution. And on top: what is the "performance" to support?

What i can share: many companies use a trend of "extracting" the data to "combine" the outside of SAP. Some are trying to use e.g. SAP BW.

The SAP original solution is clearly not a bad option. If you can "modify" the 90 day rule without modification.. not sure

To go for a customer solution is as well possible.

I wish you the best

C.B.

PS: if you analyse RREGCH_EVALUATE_QUANTITIES you might get ideas regarding a potential customer solution. Currently this ABAP report can only be used for a "single" case and not by "mass"