P_InjuryIllnessWithPriority

DDL: P_INJURYILLNESSWITHPRIORITY Type: view COMPOSITE Package: EHHSS_BO_INC_IMPL
22 Fields 1 Data Sources

Injury/Illness With Priority

P_InjuryIllnessWithPriority is a Composite CDS View that provides data about "Injury/Illness With Priority" in SAP S/4HANA. It reads from 1 data source (I_IncidentInjuryIllness) and exposes 22 fields with key field InjuryIllnessUUID. Part of development package EHHSS_BO_INC_IMPL.

Data Sources (1)

SourceAliasJoin Type
I_IncidentInjuryIllness injill from

Annotations (11)

NameValueLevelField
VDM.private true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName PINJILLWITHPRIO view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY InjuryIllnessUUID InjuryIllnessUUID UUID
IncidentUUID IncidentUUID Incident UUID
InjuredPersonInfoUUID InjuredPersonInfoUUID
CreationDateTime CreationDateTime Timestamp
CreatedByUser CreatedByUser User Name
_CreatedByUser _CreatedByUser
LastChangeDateTime LastChangeDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
_LastChangedByUser _LastChangedByUser
InjuryIllnessClassification InjuryIllnessClassification
_InjuryIllnessClass _InjuryIllnessClass
MainInjuryIllnessClassfctn
InjuryIllnessType InjuryIllnessType
_InjuryIllnessType _InjuryIllnessType
InjuryIllnessIsRecordable InjuryIllnessIsRecordable Reporting Reqd.
_InjuryIllnessIsRecordable _InjuryIllnessIsRecordable
InjuryIllnessIsMainInjury InjuryIllnessIsMainInjury Main Inj./Ill.
_InjuryIllnessIsMainInjury _InjuryIllnessIsMainInjury
IncidentBodyPart IncidentBodyPart
_IncidentBodyPart _IncidentBodyPart
IncidentBodySide IncidentBodySide
_IncidentBodySide _IncidentBodySide

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 P_InjuryIllnessWithPriority.
-- 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.

CREATE VIEW P_InjuryIllnessWithPriority AS
SELECT
  InjuryIllnessUUID,
  IncidentUUID,
  InjuredPersonInfoUUID,
  CreationDateTime,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser,
  InjuryIllnessClassification,
  cast(concat(_InjuryIllnessClass.InjuryIllnessPriority, InjuryIllnessClassification) as ehhss_inc_main_inj_ill_class) AS MainInjuryIllnessClassfctn,
  InjuryIllnessType,
  InjuryIllnessIsRecordable,
  InjuryIllnessIsMainInjury,
  IncidentBodyPart,
  IncidentBodySide
FROM I_IncidentInjuryIllness AS injill
;

Learn More