I_InhRepairItemStatus

DDL: I_INHREPAIRITEMSTATUS Type: view COMPOSITE
6 Fields 2 Data Sources 2 Associations

Status of In-House Service Object

I_InhRepairItemStatus is a Composite CDS View that provides data about "Status of In-House Service Object" in SAP S/4HANA. It reads from 2 data sources (I_ServiceDocItemCategory, P_SrvcDocItmLifeCycUserStatus) and exposes 6 fields with key fields InhRepairItemStatus, InhRepairItemCategory, InhRepairItemCategory. It has 2 associations to related views.

SAP Help Documentation

CategoryService Operations and Processes
Data CategoryDimension
StatusStatus
Purpose
This CDS view is designed to provide information about the status of in-house repair items. It integrates data from lifecycle user status mappings and repair document item categories to offer a comprehensive view of the current status of repair items within an organization. This CDS view provides the data to answer the following business questions: What is the current status of in-house repair items? How are repair items categorized based on their lifecycle status? What are the textual descriptions associated with each repair item status? How can we track and manage the lifecycle of repair items effectively? What are the associations between repair item categories and their respective statuses?

Prerequisites
Authorizations Users who want to use this CDS view don't need any special authorization.

Structure
Important Fields Important fields in this view include the following: Field Name Description INHREPAIRITEMSTATUS Status INHREPAIRITEMCATEGORY Item category

View on SAP Help Portal →

Data Sources (2)

SourceAliasJoin Type
I_ServiceDocItemCategory ic union_all
P_SrvcDocItmLifeCycUserStatus usr from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_ServiceDocItemCategory _InhRepairItemCategory $projection.InhRepairItemCategory = _InhRepairItemCategory.ServiceDocItemCategory
[0..*] I_InhRepairItemStatusText _InhRepairItemStatusText $projection.InhRepairItemStatus = _InhRepairItemStatusText.InhRepairItemStatus and $projection.InhRepairItemCategory = _InhRepairItemStatusText.InhRepairItemCategory

Annotations (12)

NameValueLevelField
EndUserText.label Status of In-House Service Object view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.representativeKey InhRepairItemStatus view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
Metadata.ignorePropagatedAnnotations true view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName IIHRITEMSTATUS view
AbapCatalog.compiler.compareFilter true view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY InhRepairItemStatus P_SrvcDocItmLifeCycUserStatus CustMgmtLifecycleUserStatus
KEY InhRepairItemCategory P_SrvcDocItmLifeCycUserStatus ServiceDocItemCategory Item Category
_InhRepairItemStatusText _InhRepairItemStatusText
KEY InhRepairItemCategory I_ServiceDocItemCategory ServiceDocItemCategory Item Category
_InhRepairItemStatusText _InhRepairItemStatusText
_InhRepairItemCategory _InhRepairItemCategory

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_InhRepairItemStatus.
-- 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 I_InhRepairItemStatus AS
SELECT
  usr.CustMgmtLifecycleUserStatus AS InhRepairItemStatus,
  usr.ServiceDocItemCategory AS InhRepairItemCategory
FROM P_SrvcDocItmLifeCycUserStatus AS usr
LEFT OUTER JOIN I_ServiceDocItemCategory AS _InhRepairItemCategory ON InhRepairItemCategory = _InhRepairItemCategory.ServiceDocItemCategory  -- association [0..1]
LEFT OUTER JOIN I_InhRepairItemStatusText AS _InhRepairItemStatusText ON InhRepairItemStatus = _InhRepairItemStatusText.InhRepairItemStatus AND InhRepairItemCategory = _InhRepairItemStatusText.InhRepairItemCategory  -- association [0..*]
-- UNION ALL with additional select branch(es): I_ServiceDocItemCategory
;

Learn More