I_INHREPAIRUSERSTATUSTEXT

CDS View

User Status of In-House Repair – Text

I_INHREPAIRUSERSTATUSTEXT is a CDS View in S/4HANA. User Status of In-House Repair – Text. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_InhRepairStatusText view from COMPOSITE In-House Service Status - Text 
@EndUserText.label: 'User Status of In-House Repair – Text'
@VDM: {
    viewType: #BASIC,
    lifecycle.contract.type: #PUBLIC_LOCAL_API
}
@AccessControl: {
    authorizationCheck: #NOT_REQUIRED
}
@ObjectModel: {
    dataCategory: #TEXT,
    representativeKey: 'InhRepairUserStatus',
    usageType: {serviceQuality: #B, sizeCategory: #S, dataClass: #CUSTOMIZING}
}
@Metadata: {
    ignorePropagatedAnnotations: true
}
@ClientHandling: {
    algorithm: #SESSION_VARIABLE
}
@AbapCatalog: {
    sqlViewName: 'IIHRUSRSTATUST',
    compiler.compareFilter: true,
    preserveKey: true
}

define view I_InhRepairUserStatusText
  as select from I_CustMgmtLifecycleUserStsText
    inner join   I_CustMgmtLfcycUsrStsMapping on I_CustMgmtLfcycUsrStsMapping.CustMgmtLifecycleUserStatus = I_CustMgmtLifecycleUserStsText.CustMgmtLifecycleUserStatus
    inner join   I_ServiceDocumentType        on  I_ServiceDocumentType.ServiceObjectType         =  'BUS2000256' //In-House Repair

                                              and I_ServiceDocumentType.SrvcDocTypeBlockingStatus <> 'X'
                                              and I_ServiceDocumentType.StatusProfile             =  I_CustMgmtLfcycUsrStsMapping.StatusProfile
                                              
  association [0..1] to I_ServiceDocumentType as _InhRepairType       on  $projection.InhRepairType = _InhRepairType.ServiceDocumentType
  association [0..1] to I_InhRepairUserStatus as _InhRepairUserStatus on  $projection.InhRepairType       = _InhRepairUserStatus.InhRepairType
                                                                      and $projection.InhRepairUserStatus = _InhRepairUserStatus.InhRepairUserStatus
  association [0..1] to I_Language            as _Language            on  $projection.Language = _Language.Language

{
         @Semantics.language: true
         @ObjectModel.foreignKey.association: '_Language'
  key    Language,
         @ObjectModel.foreignKey.association: '_InhRepairUserStatus'
  key    cast(I_CustMgmtLifecycleUserStsText.CustMgmtLifecycleUserStatus as crms4_repa_header_status_lbl preserving type) as InhRepairUserStatus,
         @ObjectModel.foreignKey.association: '_InhRepairType'
  key    ServiceDocumentType                                                                                              as InhRepairType,
         @Semantics.text: true
         cast(CustMgmtLifecycleUserStsName as crms4_repa_hdr_status_dsc_lbl preserving type)                              as InhRepairUserStatusName,

         /* Associations */
         _InhRepairType,
         _InhRepairUserStatus,
         _Language
}
where
  I_CustMgmtLfcycUsrStsMapping.CustMgmtLifecycleUserStsField = 'STAT_LIFECYCLE'

Learn More