crms4_case_index

DDL: CRMS4_CASE_INDEX SQL: CRMS4_CASEINDEX Type: view
7 Fields 1 Data Sources

CRM Case Index

crms4_case_index is a CDS View that provides data about "CRM Case Index" in SAP S/4HANA. It reads from 1 data source (crmd_case_index) and exposes 7 fields with key field guid.

Data Sources (1)

SourceAliasJoin Type
crmd_case_index crmd_case_index from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CRMS4_CASEINDEX view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label CRM Case Index view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY guid guid UUID 22 char.
case_guid case_guid UUID
CRM_PARTNER_FCT partner_fct Partner Function
CRM_PARTNER_NO partner_no Partner Number
object_type object_type Type
CRM_OBJECT_ID object_id Transaction ID
CRM_PRODUCT_ID product_id Simulated Product ID

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 crms4_case_index.
-- 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: CRMS4_CASEINDEX

CREATE VIEW crms4_case_index AS
SELECT
  guid,
  case_guid,
  partner_fct AS CRM_PARTNER_FCT,
  partner_no AS CRM_PARTNER_NO,
  object_type,
  object_id AS CRM_OBJECT_ID,
  product_id AS CRM_PRODUCT_ID
FROM crmd_case_index
;

Learn More