I_InspectionLotStatus

DDL: I_INSPECTIONLOTSTATUS SQL: IINSPLOTSTS Type: view COMPOSITE

Inspection Lot Status

I_InspectionLotStatus is a Composite CDS View that provides data about "Inspection Lot Status" in SAP S/4HANA. It reads from 1 data source (I_StatusObjectActiveStatus) and exposes 6 fields with key fields StatusObject, StatusCode.

1 data source(s) 6 fields

Data Sources (1)

SourceAliasJoin Type
I_StatusObjectActiveStatus I_StatusObjectActiveStatus from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IINSPLOTSTS view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Inspection Lot Status view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
ObjectModel.representativeKey StatusObject view
ObjectModel.compositionRoot true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY StatusObject StatusObject
KEY StatusCode StatusCode
StatusProfile StatusProfile
_StatusObject _StatusObject
_StatusProfile _StatusProfile
_StatusCode _StatusCode 
@AbapCatalog.sqlViewName: 'IINSPLOTSTS'
@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter: true
// Status data shall be protected and read only in context of the object having this status

@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@EndUserText.label: 'Inspection Lot Status'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #COMPOSITE
@ObjectModel.representativeKey: 'StatusObject'
@ObjectModel.compositionRoot: true
@ObjectModel.usageType: {
    dataClass: #TRANSACTIONAL,
    sizeCategory: #L,
    serviceQuality: #C
}
define view I_InspectionLotStatus as select from I_StatusObjectActiveStatus {
  key StatusObject,
  key StatusCode,
  StatusProfile,
  
  _StatusObject,
  _StatusProfile ,
  _StatusCode

}
where StatusObject like 'QL%'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_STATUSOBJECTACTIVESTATUS"
],
"ASSOCIATED":
[
"I_STATUSCODE",
"I_STATUSOBJECT",
"I_STATUSPROFILE"
],
"BASE":
[
"I_STATUSOBJECTACTIVESTATUS"
],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More