I_InhRepairItemStatusText

Q: Which tables does I_InhRepairItemStatusText use?

I_InhRepairItemStatusText reads from 5 data source(s): I_ServiceDocItemCategory, I_ServiceDocItemCategory, I_SrvcLifeCycleSystemStatusT, I_CustMgmtLfcycUsrStsMapping, I_CustMgmtLifecycleUserStsText.

Q: How many fields does I_InhRepairItemStatusText have?

I_InhRepairItemStatusText has 13 fields. Key fields: Language, InhRepairItemStatus, InhRepairItemCategory, InhRepairItemStatus, InhRepairItemCategory.

DDL: I_INHREPAIRITEMSTATUSTEXT Type: view COMPOSITE

Status of In-House Repair Item - Text

I_InhRepairItemStatusText is a Composite CDS View that provides data about "Status of In-House Repair Item - Text" in SAP S/4HANA. It reads from 5 data sources (I_ServiceDocItemCategory, I_ServiceDocItemCategory, I_SrvcLifeCycleSystemStatusT, I_CustMgmtLfcycUsrStsMapping, I_CustMgmtLifecycleUserStsText) and exposes 13 fields with key fields Language, InhRepairItemStatus, InhRepairItemCategory, InhRepairItemStatus, InhRepairItemCategory. It has 3 associations to related views.

Data Sources (5)

Source	Alias	Join Type
I_ServiceDocItemCategory	I_ServiceDocItemCategory	inner
I_ServiceDocItemCategory	ic	inner
I_SrvcLifeCycleSystemStatusT	sysstattext	union_all
I_CustMgmtLfcycUsrStsMapping	usrstatmapping	inner
I_CustMgmtLifecycleUserStsText	usrstattext	from

Associations (3)

Cardinality	Target	Alias	Condition
[0..1]	I_InhRepairItemStatus	_InhRepairItemStatus	`$projection.InhRepairItemStatus = _InhRepairItemStatus.InhRepairItemStatus and $projection.InhRepairItemCategory = _InhRepairItemStatus.InhRepairItemCategory`
[0..1]	I_Language	_Language	`$projection.Language = _Language.Language`
[0..1]	I_ServiceDocItemCategory	_InhRepairItemCategory	`$projection.InhRepairItemCategory = _InhRepairItemCategory.ServiceDocItemCategory`

Annotations (13)

Name	Value	Level
EndUserText.label	Status of In-House Repair Item - Text	view
VDM.viewType	#COMPOSITE	view
VDM.lifecycle.contract.type	#PUBLIC_LOCAL_API	view
AccessControl.authorizationCheck	#NOT_REQUIRED	view
ObjectModel.dataCategory	#TEXT	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	IIHRITEMSTATUST	view
AbapCatalog.compiler.compareFilter	true	view

Fields (13)

Key	Field	Source Table	Source Field
KEY	Language	I_CustMgmtLifecycleUserStsText	Language
KEY	InhRepairItemStatus
KEY	InhRepairItemCategory	I_ServiceDocItemCategory	ServiceDocItemCategory
	InhRepairItemStatusName
	_InhRepairItemStatus		_InhRepairItemStatus
	_Language		_Language
	Language
KEY	InhRepairItemStatus
KEY	InhRepairItemCategory	I_ServiceDocItemCategory	ServiceDocItemCategory
	InhRepairItemStatusName
	_InhRepairItemStatus		_InhRepairItemStatus
	_Language		_Language
	_InhRepairItemCategory		_InhRepairItemCategory

@EndUserText.label: 'Status of In-House Repair Item - Text'
@VDM: {
    viewType: #COMPOSITE,
    lifecycle.contract.type: #PUBLIC_LOCAL_API
}
@AccessControl: {
    authorizationCheck: #NOT_REQUIRED
}
@ObjectModel: {
    dataCategory: #TEXT,
    representativeKey: 'InhRepairItemStatus',
    usageType: {serviceQuality: #C, sizeCategory: #S, dataClass: #CUSTOMIZING}
}
@Metadata: {
    ignorePropagatedAnnotations: true
}
@ClientHandling: {
    algorithm: #SESSION_VARIABLE
}
@AbapCatalog: {
    sqlViewName: 'IIHRITEMSTATUST',
    compiler.compareFilter: true
}

define view I_InhRepairItemStatusText
  as select from I_CustMgmtLifecycleUserStsText as usrstattext
    inner join   I_CustMgmtLfcycUsrStsMapping   as usrstatmapping on usrstatmapping.CustMgmtLifecycleUserStatus = usrstattext.CustMgmtLifecycleUserStatus
    inner join   I_ServiceDocItemCategory                         on  I_ServiceDocItemCategory.ServiceObjectType = 'BUS2000257'
                                                                  and I_ServiceDocItemCategory.StatusProfile     = usrstatmapping.StatusProfile

  association [0..1] to I_InhRepairItemStatus    as _InhRepairItemStatus   on  $projection.InhRepairItemStatus   = _InhRepairItemStatus.InhRepairItemStatus
                                                                           and $projection.InhRepairItemCategory = _InhRepairItemStatus.InhRepairItemCategory
  association [0..1] to I_Language               as _Language              on  $projection.Language = _Language.Language
  association [0..1] to I_ServiceDocItemCategory as _InhRepairItemCategory on  $projection.InhRepairItemCategory = _InhRepairItemCategory.ServiceDocItemCategory

{
      @Semantics.language: true
      @ObjectModel.foreignKey.association: '_Language'
  key usrstattext.Language,
      @ObjectModel.foreignKey.association: '_InhRepairItemStatus'
  key cast(usrstattext.CustMgmtLifecycleUserStatus as crms4_repa_item_status_lbl preserving type) as InhRepairItemStatus,
      @ObjectModel.foreignKey.association: '_InhRepairItemCategory'
  key I_ServiceDocItemCategory.ServiceDocItemCategory                                             as InhRepairItemCategory,

      @Semantics.text: true
      cast(usrstattext.CustMgmtLifecycleUserStsName as crms4_repa_item_status_dsc_lbl )           as InhRepairItemStatusName,

      /* Associations */
      _InhRepairItemStatus,
      _Language,
      _InhRepairItemCategory
}
where
  usrstatmapping.CustMgmtLifecycleUserStsField = 'STAT_LIFECYCLE'

union all

select from              I_SrvcLifeCycleSystemStatusT as sysstattext

  inner join             I_ServiceDocItemCategory     as ic on ic.ServiceObjectType = 'BUS2000257'
  left outer to one join P_ItmSrvcObjTypeHavingUsrSts as ot on  ot.ServiceObjectType      = ic.ServiceObjectType
                                                            and ot.ServiceDocItemCategory = ic.ServiceDocItemCategory


association [0..1] to I_InhRepairItemStatus    as _InhRepairItemStatus   on  $projection.InhRepairItemStatus   = _InhRepairItemStatus.InhRepairItemStatus
                                                                         and $projection.InhRepairItemCategory = _InhRepairItemStatus.InhRepairItemCategory
association [0..1] to I_Language               as _Language              on  $projection.Language = _Language.Language
association [0..1] to I_ServiceDocItemCategory as _InhRepairItemCategory on  $projection.InhRepairItemCategory = _InhRepairItemCategory.ServiceDocItemCategory

{

      @Semantics.language: true
      @ObjectModel.foreignKey.association: '_Language'
  key sysstattext.Language,
      @ObjectModel.foreignKey.association: '_InhRepairItemStatus'
  key cast(sysstattext.SrvcLifeCycleSystemStatus as crms4_repa_item_status_lbl preserving type)          as InhRepairItemStatus,
      @ObjectModel.foreignKey.association: '_InhRepairItemCategory'
  key ic.ServiceDocItemCategory                                                                          as InhRepairItemCategory,

      @Semantics.text: true
      cast( sysstattext.SrvcLifeCycleSystemStatusName as crms4_repa_item_status_dsc_lbl preserving type) as InhRepairItemStatusName,

      /* Associations */
      _InhRepairItemStatus,
      _Language,
      _InhRepairItemCategory
}
where
      ot.ServiceObjectType                  is null
  and sysstattext.SrvcLifeCycleSystemStatus <> 'D'

Depth:

I_InhRepairItemStatusText view