I_CaseAttribute

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_CaseAttribute.
-- 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: ICASEATTRIBUTE

CREATE VIEW I_CaseAttribute AS
SELECT
  scmg_t_case_attr.case_guid AS CaseUniqueID,
  scmg_t_case_attr.case_type AS CaseType,
  scmg_t_case_attr.ext_key AS CaseID,
  scmg_t_case_attr.ext_ref AS CaseExternalReference,
  scmg_t_case_attr.created_by AS CaseCreatedBy,
  scmg_t_case_attr.create_time AS CaseCreatedOn,
  scmg_t_case_attr.changed_by AS CaseLastChangedBy,
  scmg_t_case_attr.change_time AS CaseLastChangedOn,
  scmg_t_case_attr.closed_by AS CaseClosedBy,
  scmg_t_case_attr.closing_time AS CaseClosedTime,
  scmg_t_case_attr.plan_end_date AS CasePlannedCloseDate,
  scmg_t_case_attr.processor AS CaseProcessor,
  scmg_t_case_attr.responsible AS CaseResponsible,
  scmg_t_case_attr.case_title AS CaseTitle,
  scmg_t_case_attr.escal_reason AS CaseEscalationReason,
  scmg_t_case_attr.category AS CaseCategory,
  scmg_t_case_attr.priority AS CasePriority,
  scmg_t_case_attr.secure_level AS CaseAuthorizationLevel,
  scmg_t_case_attr.profile_id AS CaseStatusProfile,
  scmg_t_case_attr.stat_orderno AS CaseStatus,
  scmg_t_case_attr.stat_para AS CaseSystemStatus,
  scmg_t_case_attr.stat_objnr AS CaseStatusObjectNumber,
  scmg_t_case_attr.stat_line AS CaseSystemStatusName,
  scmg_t_case_attr.stat_user_line AS CaseUserStatusName,
  scmg_t_case_attr.reason_code AS CaseReason
FROM scmg_t_case_attr
LEFT OUTER JOIN I_Caseentity AS _CaseEntity ON CaseUniqueID = _CaseEntity.CaseUniqueID  -- association [0..1]
LEFT OUTER JOIN I_Casetypes AS _CaseTypes ON CaseType = _CaseTypes.CaseType  -- association [0..1]
LEFT OUTER JOIN I_CaseEscalationReason AS _Escalation ON CaseEscalationReason = _Escalation.CaseEscalationReason  -- association [0..1]
LEFT OUTER JOIN I_CaseCategory AS _Catego ON CaseCategory = _Catego.CaseCategory AND CaseType = _Catego.CaseType  -- association [0..1]
LEFT OUTER JOIN I_CasePriority AS _Priority ON CasePriority = _Priority.CasePriority  -- association [0..1]
LEFT OUTER JOIN I_Caseauthorizationlevel AS _AuthLevel ON CaseAuthorizationLevel = _AuthLevel.CaseAuthorizationLevel  -- association [0..1]
LEFT OUTER JOIN I_CaseStatusProfile AS _StatProfile ON CaseStatusProfile = _StatProfile.CaseStatusProfile  -- association [0..1]
LEFT OUTER JOIN I_Caseindividualstatus AS _Individual ON CaseStatus = _Individual.CaseStatus AND CaseStatusProfile = _Individual.CaseStatusProfile  -- association [0..1]
LEFT OUTER JOIN I_CaseSystemStatus AS _CaseSystemStatus ON CaseSystemStatus = _CaseSystemStatus.CaseSystemStatus  -- association [0..1]
LEFT OUTER JOIN I_CaseReasons AS _Reasons ON CaseReason = _Reasons.CaseReason AND CaseType = _Reasons.CaseType  -- association [0..1]
;