I_SrvcDocStatusChangeDocument

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_SrvcDocStatusChangeDocument.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: ISRVCSTATCD

CREATE VIEW I_SrvcDocStatusChangeDocument AS
SELECT
  cast( SrvcMgmtObjStatusChangeNumber as cdchangenr ) AS ChangeDocument,
  cast( _ServiceDocumentEnhcd.ServiceDocumentCharUUID as cdobjectv) AS ChangeDocObject,
  cast( concat(concat( '000' , _ServiceDocumentEnhcd.ServiceDocumentCharUUID ) , SrvcMgmtObjectStatus) as cdtabkey ) AS ChangeDocTableKey,
  cast(SrvcMgmtObjStsChgInformation as cdchngind ) AS ChangeDocChangeType,
  SrvcMgmtObjectStatus,
  cast( dats_tims_to_tstmp ( ChangeDocumentStatusDate, ChangeDocumentStatusTime, abap_system_timezone( $session.client, 'NULL' ), $session.client, 'NULL' ) as cdcreated ) AS ServiceDocChangedDateTime,
  cast ( SrvcMgmtObjStsChangeUser as cdusername ) AS CreatedByUser,
  StatusObjectUUID
FROM I_SrvcMgmtObjStsChgInformation
INNER JOIN I_ServiceDocumentEnhcd AS _ServiceDocumentEnhcd ON /* join condition not captured in parsed metadata */
INNER JOIN I_ServiceDocumentItemEnhcd AS _ServiceDocumentItemEnhcd ON /* join condition not captured in parsed metadata */
INNER JOIN I_InHouseRepair AS _InHouserepair ON /* join condition not captured in parsed metadata */
INNER JOIN I_InHouseRepairItem AS _InHouserepairItem ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): I_SrvcMgmtObjStsChgInformation
;