I_InspectionLotStatus1

DDL: I_INSPECTIONLOTSTATUS1 SQL: IINSPLOTSTS1 Type: view COMPOSITE

Inspection Lot Status

I_InspectionLotStatus1 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 5 fields with key fields InspectionLot, StatusCode. It has 1 association to related views.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
I_StatusObjectActiveStatus I_StatusObjectActiveStatus from

Associations (1)

CardinalityTargetAliasCondition
[1] I_InspectionLot _InspectionLot $projection.InspectionLot = _InspectionLot.InspectionLot

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IINSPLOTSTS1 view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Inspection Lot Status view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.representativeKey StatusCode view
ObjectModel.compositionRoot true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #B view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY InspectionLot I_InspectionLot InspectionLot
KEY StatusCode I_StatusObjectActiveStatus StatusCode
StatusObject I_StatusObjectActiveStatus StatusObject
_StatusObject I_StatusObjectActiveStatus _StatusObject
_InspectionLot _InspectionLot 
@AbapCatalog.sqlViewName: 'IINSPLOTSTS1'
@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Inspection Lot Status'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #COMPOSITE
@Metadata.ignorePropagatedAnnotations:true
@ObjectModel.supportedCapabilities:
 [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET ]
@ObjectModel.representativeKey: 'StatusCode'
@ObjectModel.compositionRoot: true
@ObjectModel.usageType: {
    dataClass: #TRANSACTIONAL,
    sizeCategory: #L,
    serviceQuality: #B
}

define view I_InspectionLotStatus1
  as select from           I_StatusObjectActiveStatus
    left outer to one join I_InspectionLot on I_InspectionLot.StatusObject = I_StatusObjectActiveStatus.StatusObject

  association [1] to I_InspectionLot as _InspectionLot on $projection.InspectionLot = _InspectionLot.InspectionLot

{

      @ObjectModel.foreignKey.association: '_InspectionLot'
  key I_InspectionLot.InspectionLot,
  key I_StatusObjectActiveStatus.StatusCode,
      I_StatusObjectActiveStatus.StatusObject,

      I_StatusObjectActiveStatus._StatusObject,
      _InspectionLot
}
where
  I_StatusObjectActiveStatus.StatusObject like 'QL%'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_INSPECTIONLOT",
"I_STATUSOBJECTACTIVESTATUS"
],
"ASSOCIATED":
[
"I_INSPECTIONLOT",
"I_STATUSOBJECT"
],
"BASE":
[
"I_STATUSOBJECTACTIVESTATUS"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More