C_SimulationLogStatusCount

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 C_SimulationLogStatusCount.
-- 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: CSIMLNSTSCNT

CREATE VIEW C_SimulationLogStatusCount AS
SELECT
  SimulationJobUUID,
  SystemMessageNumber,
  SystemMessageIdentification,
  SystemMessageType,
  SystemMessageVariable1,
  SystemMessageVariable2,
  SystemMessageVariable3,
  SystemMessageVariable4,
  cast('' as bapi_msg) AS SystemMessageText,
  cast('' as abap.char( 32 )) AS StatusMessageText,
  cast(count(*) as srtcm_d_executions) AS NumberOfOccurrences,
  cast ('' as ebeln) AS PurchasingDocument,
  _PurchasingDocSimulationJob.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  _PurchasingDocSimulationJob.PurchasingDocumentSubtype AS PurchasingDocumentSubtype,
  _PurchasingDocSimulationJob.CntrlPurContrIsNotActv AS CntrlPurContrIsNotActv,
  _PurchasingDocSimulationJob.CntrlPurReqnIsNotActv AS CntrlPurReqnIsNotActv,
  _PurchasingDocSimulationJob.CntrlPurContrHierIsNotActv AS CntrlPurContrHierIsNotActv,
  _PurchasingDocSimulationJob.PurchaseOrderIsNotActive AS PurchaseOrderIsNotActive
FROM P_SimlnLogSingleSuccess
LEFT OUTER JOIN P_PurchasingDocSimulationJob AS _PurchasingDocSimulationJob ON SimulationJobUUID = _PurchasingDocSimulationJob.SimulationJobUUID  -- association [1..1]
LEFT OUTER JOIN C_MassUpdtPurgDocsMsgDets AS _MassUpdtPurgDocsMsgDets ON SimulationJobUUID = _MassUpdtPurgDocsMsgDets.SimulationJobUUID AND SystemMessageNumber = _MassUpdtPurgDocsMsgDets.SystemMessageNumber AND SystemMessageIdentification = _MassUpdtPurgDocsMsgDets.SystemMessageIdentification AND SystemMessageType = _MassUpdtPurgDocsMsgDets.SystemMessageType AND SystemMessageVariable1 = _MassUpdtPurgDocsMsgDets.SystemMessageVariable1 AND SystemMessageVariable2 = _MassUpdtPurgDocsMsgDets.SystemMessageVariable2 AND SystemMessageVariable3 = _MassUpdtPurgDocsMsgDets.SystemMessageVariable3 AND SystemMessageVariable4 = _MassUpdtPurgDocsMsgDets.SystemMessageVariable4  -- association [1..*]
LEFT OUTER JOIN C_MassUpdtCntrlCtrMsgDets AS _MassUpdtCntrlCtrMsgDets ON SimulationJobUUID = _MassUpdtCntrlCtrMsgDets.SimulationJobUUID AND SystemMessageNumber = _MassUpdtCntrlCtrMsgDets.SystemMessageNumber AND SystemMessageIdentification = _MassUpdtCntrlCtrMsgDets.SystemMessageIdentification AND SystemMessageType = _MassUpdtCntrlCtrMsgDets.SystemMessageType AND SystemMessageVariable1 = _MassUpdtCntrlCtrMsgDets.SystemMessageVariable1 AND SystemMessageVariable2 = _MassUpdtCntrlCtrMsgDets.SystemMessageVariable2 AND SystemMessageVariable3 = _MassUpdtCntrlCtrMsgDets.SystemMessageVariable3 AND SystemMessageVariable4 = _MassUpdtCntrlCtrMsgDets.SystemMessageVariable4  -- association [1..*]
LEFT OUTER JOIN C_MassUpdtCntrlCtrHierMsgDets AS _MassUpdtCntrlCtrHierMsgDets ON SimulationJobUUID = _MassUpdtCntrlCtrHierMsgDets.SimulationJobUUID AND SystemMessageNumber = _MassUpdtCntrlCtrHierMsgDets.SystemMessageNumber AND SystemMessageIdentification = _MassUpdtCntrlCtrHierMsgDets.SystemMessageIdentification AND SystemMessageType = _MassUpdtCntrlCtrHierMsgDets.SystemMessageType AND SystemMessageVariable1 = _MassUpdtCntrlCtrHierMsgDets.SystemMessageVariable1 AND SystemMessageVariable2 = _MassUpdtCntrlCtrHierMsgDets.SystemMessageVariable2 AND SystemMessageVariable3 = _MassUpdtCntrlCtrHierMsgDets.SystemMessageVariable3 AND SystemMessageVariable4 = _MassUpdtCntrlCtrHierMsgDets.SystemMessageVariable4  -- association [1..*]
LEFT OUTER JOIN C_MassUpdtPHRPRqItmMsgDet AS _MassUpdtPHRPRqItmMsgDet ON SimulationJobUUID = _MassUpdtPHRPRqItmMsgDet.SimulationJobUUID AND SystemMessageIdentification = _MassUpdtPHRPRqItmMsgDet.SystemMessageIdentification AND SystemMessageType = _MassUpdtPHRPRqItmMsgDet.SystemMessageType AND SystemMessageVariable1 = _MassUpdtPHRPRqItmMsgDet.SystemMessageVariable1 AND SystemMessageVariable2 = _MassUpdtPHRPRqItmMsgDet.SystemMessageVariable2 AND SystemMessageVariable3 = _MassUpdtPHRPRqItmMsgDet.SystemMessageVariable3 AND SystemMessageVariable4 = _MassUpdtPHRPRqItmMsgDet.SystemMessageVariable4  -- association [1..*]
;