C_InspLotStatus

DDL: C_INSPLOTSTATUS SQL: CINSPLOTSTATUS Type: view CONSUMPTION Package: ODATA_QM_INSPLOT

Status of Inspection Lot Object Page

C_InspLotStatus is a Consumption CDS View that provides data about "Status of Inspection Lot Object Page" in SAP S/4HANA. It reads from 3 data sources (I_InspectionLot, I_StatusCodeText, I_UserStatusText) and exposes 8 fields with key fields InspectionLot, StatusCode. Part of development package ODATA_QM_INSPLOT.

3 data source(s) 8 fields

Data Sources (3)

SourceAliasJoin Type
I_InspectionLot _InspLot inner
I_StatusCodeText _StatusCodeText left_outer
I_UserStatusText _UserStatusText left_outer

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CINSPLOTSTATUS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
EndUserText.label Status of Inspection Lot Object Page view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #D view
Metadata.ignorePropagatedAnnotations true view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY InspectionLot I_InspectionLot InspectionLot
KEY StatusCode _statusObject StatusCode
IsUserStatus
StatusShortNameendasStatusShortName
StatusNameendasStatusName
Plant I_InspectionLot Plant
InspectionLotType I_InspectionLot InspectionLotType
MatlQualityAuthorizationGroup I_InspectionLot MatlQualityAuthorizationGroup 
@AbapCatalog.sqlViewName: 'CINSPLOTSTATUS'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #CONSUMPTION
@EndUserText.label: 'Status of Inspection Lot Object Page'
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType: {
    dataClass: #MIXED,
    sizeCategory: #L, //expected number of rows < 10.000.000

    serviceQuality: #D 
}
@Metadata.ignorePropagatedAnnotations: true
define view C_InspLotStatus 
as select distinct from I_StatusObjectActiveStatus as _statusObject
    //Retrieve inspection lot number

    inner join I_InspectionLot as _InspLot 
       on _InspLot.StatusObject = _statusObject.StatusObject
    //Retrieve system status short name and description      

    left outer join  I_StatusCodeText as _StatusCodeText 
        on  _statusObject.StatusCode = _StatusCodeText.StatusCode
        and _statusObject.StatusProfile= _StatusCodeText.StatusProfile
        and _StatusCodeText.Language = $session.system_language
    //Retrieve user status short name and description   

    left outer join I_UserStatusText as _UserStatusText
        on  _statusObject.StatusProfile = _UserStatusText.StatusProfile
        and _statusObject.StatusCode    = _UserStatusText.UserStatus
        and _UserStatusText.Language    = $session.system_language
{
    key _InspLot.InspectionLot,
    key _statusObject.StatusCode,
    _statusObject._StatusCode._StatusCodeText[1:Language=$session.system_language].IsUserStatus,
    case _statusObject._StatusCode._StatusCodeText[1:Language=$session.system_language].IsUserStatus
      when 'X' then _UserStatusText.UserStatusShortName 
      else  _StatusCodeText.StatusShortName
      end as StatusShortName,
    case _statusObject._StatusCode._StatusCodeText[1:Language=$session.system_language].IsUserStatus
      when 'X' then _UserStatusText.UserStatusName 
      else _StatusCodeText.StatusName
      end as StatusName,
    @Consumption.hidden: true     //for DCL

    _InspLot.Plant,
    @Consumption.hidden: true     //for DCL

    _InspLot.InspectionLotType,
    @Consumption.hidden: true     //for DCL

    _InspLot.MatlQualityAuthorizationGroup     
     
}

Learn More