How can I find the Service Contract that was the basis for a Service Order in CDS views?

[Expert]

Hello Experts,

I need to create some custom logic to populate a field with the Service Contract number to which the Service Order belongs. I cannot find a CDS view which I see this relationship in. I need a CDS view which I can use in Custom Logic to program a SELECT SINGLE with.

T

[Expert · Accepted solution]

Hello!

CDS view C_SERVICEORDERITEMDEX can help you. One of the field is Predecessor ID and object type . These are the fields

SERVICEDOCUMENTPREDECESSORUUID
SERVICEDOCPRDCSSRBUSOBJTYPE

Second one must be BUS2000112 to pick a Service Contract item instead of a quotation or a template. The blog of @Anna Garbar is quite interesting.https://blogs.sap.com/2020/09/01/cds-based-bw-extractors-for-service-in-sap-s-4hana-and-sap-s-4hana-cloud/Hope this helps!