I_CACaseStatus

DDL: I_CACASESTATUS SQL: ICACASESTATUS Type: view COMPOSITE Package: ODATA_O2C_FICA_DISPUTE_MANAGE
4 Fields 2 Data Sources

Dispute case status

I_CACaseStatus is a Composite CDS View that provides data about "Dispute case status" in SAP S/4HANA. It reads from 2 data sources (P_CACaseStatus, I_Caseindividualstatus) and exposes 4 fields with key fields CaseStatusProfile, CaseStatus. Part of development package ODATA_O2C_FICA_DISPUTE_MANAGE.

Data Sources (2)

SourceAliasJoin Type
P_CACaseStatus _CaseType inner
I_Caseindividualstatus _Status from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ICACASESTATUS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
EndUserText.label Dispute case status view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY CaseStatusProfile I_Caseindividualstatus CaseStatusProfile Status Profile
KEY CaseStatus I_Caseindividualstatus CaseStatus Status
CaseStatusName
CaseSystemStatus I_Caseindividualstatus CaseSystemStatus System Status

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_CACaseStatus.
-- 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: ICACASESTATUS

CREATE VIEW I_CACaseStatus AS
SELECT
  _Status.CaseStatusProfile AS CaseStatusProfile,
  _Status.CaseStatus AS CaseStatus,
  _Status._Text[1:Language = $session.system_language].CaseStatusName AS CaseStatusName,
  _Status.CaseSystemStatus AS CaseSystemStatus
FROM I_Caseindividualstatus AS _Status
INNER JOIN P_CACaseStatus AS _CaseType ON /* join condition not captured in parsed metadata */
;

Learn More