Characteristics CDS View ：I_ClfnObjectCharcValForKeyDate

[Joanna]

Hi, Experts,

I want to use cds view I_ClfnObjectCharcValForKeyDate to do report.

here have one field "Characteristic value counter",

and I find the same characteristic, some material's characteristic value is in counter 001, some material's characteristic value is in counter 002.

Why? how can I get the correct characteristic value?

RGDS

Joanna Qiu

[Amith_Nair · Accepted solution]

Hi joanna1981

I think this is more of functional Question than a CDS view level question. But, as I notice in my tenant, Characteristic value counter is addressed as a field 'Counter' and CHARCVALUE as 'Characteristic Value'. But, I am not equipped enough to answer the data that is populating from the mentioned fields, which probably is Functional Question which I think should be answered by Manufacturing consultant, may be jfromanato001 ?

But here is a screenshot for your reference. Hope this helps too, but otherwise, I can check with my peers to get you an appropriate answer.

Thank you!

Amith Nair

[JulianoRomanato · Accepted solution]

Hello joanna1981 and amiths.nair2.

This Counter is probably related to the sequence of the Characteristic inside the Class. For example, considering the Print Screen from amiths.nair2, for a Batch Class (Class Type 023), the first Characteristic will have the Counter "001", the second Characteristic will have the Counter "002" and successfully.

Regards.

Juliano Romanato.

[AIT-LAHCEN · Accepted solution]

Hi Amith, is there a cds view published for cloud development to get characteristic from PO or SO documents, same as I_ClfnObjectCharcValue for example that gets it from master data (Products, Suppliers, etc...) ?

[mosmart]

Hi ‎@Joanna1981 - I trust you found your answer - for others - and because this took me a while - here is an approach - not the most elegant, but it gets a result.

- Get the ATINN for the characteristic. Use "Export Master Data Products". Look in the downloaded Excel file tab MARA_AUSP - Characteristics

- Get CharcValue from I_ClfnObjectCharcValForKeyDate where ClfnObjectID = product; CharcInternalID = "ATINN" (from above Excel download)- This should return CharcValue

- Get CharcValuePositionNumber value from I_ClfnCharcValueForKeyDate where CharcInternalID = ATINN and CharcValue (from above) This should return the CharcValuePositionNumber (The missing part in the question)

- Get CharcValueDescription from I_ClfnCharcValueDescForKeyDate where CharcInternalID = ATINN and CharcValuePositionNumber (from above) and Language - This should return the description in the required language.

In ABAP for Key Users it looks something like this:

select single c~CharcValueDescription

from I_ClfnObjectCharcValForKeyDate as a inner join I_ClfnCharcValueForKeyDate as b on a~CharcValue eq b~CharcValue and a~CharcInternalID eq b~CharcInternalID inner join I_ClfnCharcValueDescForKeyDate as c on b~CharcValuePositionNumber eq c~CharcValuePositionNumber where a~CharcInternalID = "ATINN" and c~CharcInternalID = "ATINN" and a~ClfnObjectID = "PRODUCT" and c~language eq 'E' into "TARGET FIELD".

[Joanna]

Hi， Morne,

Very thanks for your detail explanation.

RGDS

Joanna Qiu

[mosmart]

One of the drawbacks of this approach is that the ATINN in the Q-System is almost guaranteed not to be the same in the P-System. Another approach is to the derive the ATINN in the query using ATNAM. A prerequisite for this to work is that the characteristic has the same description in both P & Q.

[Tom1-2-3]

Hi there

[Tom1-2-3]

Hi there, we are using S4H Public cloud. I tried to associated all these CDS views from SAP note 3244147 into one Custom CDS view. I_BATCHDISTINCT and I_CLFNOBJECTCHARCVALFORKEYDATE are fine joined. I am also able select the elements from those two views. When it comes to I_CLFNCHARCDESCFORKEYDATE I am able to join between through CharcInternalID of the last two views. But for the latter view I am not able to add its elements: I_CLFNCHARCDESCFORKEYDATE. I am getting an error: "The association "_I_ClfnCharcDescForKeyDate" cannot be used locally in the view (see long text)"