I_InspectionPlan

DDL: I_INSPECTIONPLAN SQL: IINSPPL Type: view BASIC

Inspection Plan

I_InspectionPlan is a Basic CDS View that provides data about "Inspection Plan" in SAP S/4HANA. It reads from 1 data source (I_BillOfOperations) and exposes 10 fields with key fields InspectionPlanGroup, InspectionPlan. It has 2 associations to related views.

1 data source(s) 10 fields

Data Sources (1)

SourceAliasJoin Type
I_BillOfOperations I_BillOfOperations from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_BillOfOperationsType _BillOfOperationsType $projection.BillOfOperationsType = _BillOfOperationsType.BillOfOperationsType
[1..1] I_BillOfOperationsGroup _BillOfOperationsGroup $projection.BillOfOperationsType = _BillOfOperationsGroup.BillOfOperationsType and $projection.InspectionPlanGroup = _BillOfOperationsGroup.BillOfOperationsGroup

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IINSPPL view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Inspection Plan view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.representativeKey InspectionPlan view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY InspectionPlanGroup BillOfOperationsGroup
KEY InspectionPlan BillOfOperationsVariant
BillOfOperationsType BillOfOperationsType
HasChangeNumber HasChangeNumber
IsMarkedForDeletion IsMarkedForDeletion
LastChangeDate LastChangeDate
LastChangeTime LastChangeTime
LastChangedByUser LastChangedByUser
_BillOfOperationsGroup _BillOfOperationsGroup
_BillOfOperationsType _BillOfOperationsType 
@AbapCatalog.sqlViewName: 'IINSPPL'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Inspection Plan'
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: { serviceQuality: #B, sizeCategory: #M, dataClass: #MASTER }
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.representativeKey: 'InspectionPlan'
@ObjectModel.modelingPattern: #ANALYTICAL_DIMENSION
@ObjectModel.supportedCapabilities:
    [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET,#ANALYTICAL_DIMENSION ]
define view I_InspectionPlan as select from I_BillOfOperations 
  association [1..1] to I_BillOfOperationsType        as _BillOfOperationsType        on  $projection.BillOfOperationsType = _BillOfOperationsType.BillOfOperationsType
association [1..1] to I_BillOfOperationsGroup       as _BillOfOperationsGroup       on  $projection.BillOfOperationsType  = _BillOfOperationsGroup.BillOfOperationsType
                                                                                      and $projection.InspectionPlanGroup = _BillOfOperationsGroup.BillOfOperationsGroup
{
  @ObjectModel.foreignKey.association: '_BillOfOperationsGroup'
  key BillOfOperationsGroup   as InspectionPlanGroup,
  key BillOfOperationsVariant as InspectionPlan,
  @ObjectModel.foreignKey.association: '_BillOfOperationsType'
  BillOfOperationsType,
  HasChangeNumber,
  //HasParameterEffectivity,

  
  //LastUsageDate,  

  //NumberOfUsages,  

  
  //BillOfOperationsVersionType,

  //BillOfOperationsSubtype,


  IsMarkedForDeletion,
        
  LastChangeDate,
  LastChangeTime,
  LastChangedByUser,

  //Associations

  _BillOfOperationsGroup,
  _BillOfOperationsType
}
where BillOfOperationsType = 'Q'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BILLOFOPERATIONS"
],
"ASSOCIATED":
[
"I_BILLOFOPERATIONSGROUP",
"I_BILLOFOPERATIONSTYPE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More