How many fields does I_InhRepairItemStatusText have?

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

I_InhRepairItemStatusText

Q: Which tables does I_InhRepairItemStatusText use?

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

DDL: I_INHREPAIRITEMSTATUSTEXT Type: view_entity BASIC Package: CRMS4_REPAIR_BO

Status of In-House Service Item - Text

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

Data Sources (3)

Source	Alias	Join Type
I_CustMgmtLfcycUsrStsMapping	I_CustMgmtLfcycUsrStsMapping	inner
I_CustMgmtLifecycleUserStsText	I_CustMgmtLifecycleUserStsText	from
I_ServiceDocItemCategory	I_ServiceDocItemCategory	inner

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 (11)

Name	Value	Level
EndUserText.label	Status of In-House Service Item - Text	view
VDM.viewType	#BASIC	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	#B	view
ObjectModel.usageType.sizeCategory	#S	view
ObjectModel.usageType.dataClass	#CUSTOMIZING	view
Analytics.technicalName	IIHRITEMSTATUST	view
Metadata.ignorePropagatedAnnotations	true	view

Fields (7)

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

@EndUserText.label: 'Status of In-House Service Item - Text' //2602 CE : Repair replaced with Service

@VDM: {
    viewType: #BASIC,
    lifecycle.contract.type: #PUBLIC_LOCAL_API
}
@AccessControl: {
    authorizationCheck: #NOT_REQUIRED
}
@ObjectModel: {
    dataCategory: #TEXT,
    representativeKey: 'InhRepairItemStatus',
    usageType: {serviceQuality: #B, sizeCategory: #S, dataClass: #CUSTOMIZING},
    supportedCapabilities: [#SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET,#LANGUAGE_DEPENDENT_TEXT]  //Added 2602 CE

}
@Analytics.technicalName: 'IIHRITEMSTATUST'
@Metadata: {
    ignorePropagatedAnnotations: true
}
define view entity I_InhRepairItemStatusText
  as select from I_CustMgmtLifecycleUserStsText
    inner join   I_CustMgmtLfcycUsrStsMapping on I_CustMgmtLfcycUsrStsMapping.CustMgmtLifecycleUserStatus = I_CustMgmtLifecycleUserStsText.CustMgmtLifecycleUserStatus
    inner join   I_ServiceDocItemCategory     on  I_ServiceDocItemCategory.ServiceObjectType = 'BUS2000257'     //2602 CE : Replacement of I_CustMgmtDocItemCategory ( deprecated ) with I_ServiceDocItemCategory ( Successor )

                                              and I_ServiceDocItemCategory.StatusProfile             = I_CustMgmtLfcycUsrStsMapping.StatusProfile  //2602 CE : Replacement of I_CustMgmtDocItemCategory ( deprecated ) with I_ServiceDocItemCategory ( Successor )


  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  //2602 CE : Replacement of I_CustMgmtDocItemCategory ( deprecated ) with I_ServiceDocItemCategory ( Successor )


{
      @Semantics.language: true
      @ObjectModel.foreignKey.association: '_Language'
  key I_CustMgmtLifecycleUserStsText.Language,
      @ObjectModel.foreignKey.association: '_InhRepairItemStatus'
  key cast(I_CustMgmtLifecycleUserStsText.CustMgmtLifecycleUserStatus as crms4_repa_item_status_lbl preserving type) as InhRepairItemStatus,
      @ObjectModel.foreignKey.association: '_InhRepairItemCategory'
  key I_ServiceDocItemCategory.ServiceDocItemCategory                                                                                  as InhRepairItemCategory, //2602 CE : Replacement of I_CustMgmtDocItemCategory ( deprecated ) with I_ServiceDocItemCategory ( Successor )


      @Semantics.text: true
      cast(I_CustMgmtLifecycleUserStsText.CustMgmtLifecycleUserStsName as crms4_repa_item_status_dsc_lbl preserving type)                           as InhRepairItemStatusName,

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

Depth:

I_InhRepairItemStatusText view_entity