I_InspPlanOperationVersion_2

DDL: I_INSPPLANOPERATIONVERSION_2 Type: view_entity COMPOSITE Package: VDM_QM_PLANNING

Version of Inspection Plan Operation

I_InspPlanOperationVersion_2 is a Composite CDS View that provides data about "Version of Inspection Plan Operation" in SAP S/4HANA. It reads from 2 data sources (I_BillOfOperationsOpBasic, I_InspPlanOpAssgmtVersion) and exposes 33 fields with key fields InspectionPlanGroup, BOOOperationInternalID, BOOOpInternalVersionCounter, BillOfOperationsType. It has 2 associations to related views. Part of development package VDM_QM_PLANNING.

2 data source(s) 33 fields

Data Sources (2)

SourceAliasJoin Type
I_BillOfOperationsOpBasic _BillOfOperationsOpBasic from
I_InspPlanOpAssgmtVersion _InspPlanOpAssgmt inner

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_InspectionPlanVersion _InspectionPlanVersion $projection.InspectionPlanGroup = _InspectionPlanVersion.InspectionPlanGroup and $projection.InspectionPlan = _InspectionPlanVersion.InspectionPlan and $projection.ValidityStartDate >= _InspectionPlanVersion.ValidityStartDate and $projection.ValidityStartDate <= _InspectionPlanVersion.ValidityEndDate
[1..1] I_BillOfOperationsType _BillOfOperationsType $projection.BillOfOperationsType = _BillOfOperationsType.BillOfOperationsType

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Version of Inspection Plan Operation view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view

Fields (33)

KeyFieldSource TableSource FieldDescription
KEY InspectionPlanGroup I_BillOfOperationsOpBasic BillOfOperationsGroup
KEY BOOOperationInternalID I_BillOfOperationsOpBasic BOOOperationInternalID
KEY BOOOpInternalVersionCounter I_BillOfOperationsOpBasic BOOOpInternalVersionCounter
KEY BillOfOperationsType I_BillOfOperationsOpBasic BillOfOperationsType
InspectionPlan I_InspPlanOpAssgmtVersion InspectionPlan
WorkCenterInternalID I_BillOfOperationsOpBasic WorkCenterInternalID
WorkCenterTypeCode I_BillOfOperationsOpBasic WorkCenterTypeCode
IsImplicitlyDeleted I_BillOfOperationsOpBasic IsImplicitlyDeleted
OperationExternalID I_BillOfOperationsOpBasic OperationExternalID
Operation I_BillOfOperationsOpBasic Operation_2
OperationText I_BillOfOperationsOpBasic OperationText
Plant I_BillOfOperationsOpBasic Plant
OperationControlProfile I_BillOfOperationsOpBasic OperationControlProfile
OperationStandardTextCode I_BillOfOperationsOpBasic OperationStandardTextCode
BillOfOperationsRefType
BillOfOperationsRefGroup I_BillOfOperationsOpBasic BillOfOperationsRefGroup
BillOfOperationsRefVariant I_BillOfOperationsOpBasic BillOfOperationsRefVariant
BOORefOperationIncrementValue I_BillOfOperationsOpBasic BOORefOperationIncrementValue
InspSbstCompletionConfirmation
InspSbstHasNoTimeOrQuantity I_BillOfOperationsOpBasic InspSbstHasNoTimeOrQuantity
OperationReferenceQuantity
OperationUnit I_BillOfOperationsOpBasic OperationUnit
OpQtyToBaseQtyDnmntr I_BillOfOperationsOpBasic OpQtyToBaseQtyDnmntr
OpQtyToBaseQtyNmrtr I_BillOfOperationsOpBasic OpQtyToBaseQtyNmrtr
CreationDate I_BillOfOperationsOpBasic CreationDate
CreatedByUser I_BillOfOperationsOpBasic CreatedByUser
LastChangeDate I_BillOfOperationsOpBasic LastChangeDate
LastChangedByUser I_BillOfOperationsOpBasic LastChangedByUser
ChangeNumber I_BillOfOperationsOpBasic ChangeNumber
ValidityStartDate I_BillOfOperationsOpBasic ValidityStartDate
ValidityEndDate I_BillOfOperationsOpBasic ValidityEndDate
_InspectionPlanVersion _InspectionPlanVersion
_BillOfOperationsType _BillOfOperationsType 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Version of Inspection Plan Operation'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType: { serviceQuality: #C, sizeCategory: #L, dataClass: #MASTER }
@ObjectModel.supportedCapabilities:
    [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET ]
@VDM.viewType: #COMPOSITE
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
define view entity I_InspPlanOperationVersion_2 
  as select from I_BillOfOperationsOpBasic as _BillOfOperationsOpBasic
    inner join   I_InspPlanOpAssgmtVersion as _InspPlanOpAssgmt on  _BillOfOperationsOpBasic.BillOfOperationsGroup  =  _InspPlanOpAssgmt.InspectionPlanGroup
                                                                and _BillOfOperationsOpBasic.BOOOperationInternalID =  _InspPlanOpAssgmt.BOOOperationInternalID
                                                                and _BillOfOperationsOpBasic.BillOfOperationsType   =  _InspPlanOpAssgmt.BillOfOperationsType
                                                                and _BillOfOperationsOpBasic.ValidityStartDate      >= _InspPlanOpAssgmt.ValidityStartDate
                                                                and _BillOfOperationsOpBasic.ValidityStartDate      <= _InspPlanOpAssgmt.ValidityEndDate
  /*+[hideWarning] { "IDS" :  [ "CARDINALITY_CHECK" ] } */
  association [1..1] to I_InspectionPlanVersion as _InspectionPlanVersion on  $projection.InspectionPlanGroup =  _InspectionPlanVersion.InspectionPlanGroup
                                                                          and $projection.InspectionPlan      =  _InspectionPlanVersion.InspectionPlan
                                                                          and $projection.ValidityStartDate   >= _InspectionPlanVersion.ValidityStartDate
                                                                          and $projection.ValidityStartDate   <= _InspectionPlanVersion.ValidityEndDate

  association [1..1] to I_BillOfOperationsType  as _BillOfOperationsType  on  $projection.BillOfOperationsType = _BillOfOperationsType.BillOfOperationsType

{
//           @ObjectModel.foreignKey.association: '_InspPlanOperation'

  key      _BillOfOperationsOpBasic.BillOfOperationsGroup as InspectionPlanGroup,
//           @ObjectModel.foreignKey.association: '_InspPlanOperation'

  key      _BillOfOperationsOpBasic.BOOOperationInternalID,
  key      _BillOfOperationsOpBasic.BOOOpInternalVersionCounter,
           @ObjectModel.foreignKey.association: '_BillOfOperationsType'
  key      _BillOfOperationsOpBasic.BillOfOperationsType,
           _InspPlanOpAssgmt.InspectionPlan,

           _BillOfOperationsOpBasic.WorkCenterInternalID,
           _BillOfOperationsOpBasic.WorkCenterTypeCode,

           cast( 
             case 
             when _BillOfOperationsOpBasic.IsDeleted = 'X' then 'X'
             when _InspPlanOpAssgmt.IsDeleted = 'X' then 'X'
             else ' '
           end as lkenz preserving type ) as IsDeleted,
           _BillOfOperationsOpBasic.IsImplicitlyDeleted,
           _BillOfOperationsOpBasic.OperationExternalID,
           _BillOfOperationsOpBasic.Operation_2 as Operation,


           _BillOfOperationsOpBasic.OperationText,
           _BillOfOperationsOpBasic.Plant,
           _BillOfOperationsOpBasic.OperationControlProfile,
           _BillOfOperationsOpBasic.OperationStandardTextCode,

           -- Origin
           _BillOfOperationsOpBasic.BillOfOperationsRefType,
           _BillOfOperationsOpBasic.BillOfOperationsRefGroup,
           _BillOfOperationsOpBasic.BillOfOperationsRefVariant,
           _BillOfOperationsOpBasic.BOORefOperationIncrementValue,

           -- Quality management: inspection points
           _BillOfOperationsOpBasic.InspSbstCompletionConfirmation,
           @Semantics.booleanIndicator 
           _BillOfOperationsOpBasic.InspSbstHasNoTimeOrQuantity,

           --Standard Values
           @Semantics.quantity.unitOfMeasure: 'OperationUnit'
           _BillOfOperationsOpBasic.OperationReferenceQuantity,
           _BillOfOperationsOpBasic.OperationUnit,
           _BillOfOperationsOpBasic.OpQtyToBaseQtyDnmntr,
           _BillOfOperationsOpBasic.OpQtyToBaseQtyNmrtr,

           // *************************** Administration ****************************

           _BillOfOperationsOpBasic.CreationDate,
           _BillOfOperationsOpBasic.CreatedByUser,
           _BillOfOperationsOpBasic.LastChangeDate,
           _BillOfOperationsOpBasic.LastChangedByUser,
           _BillOfOperationsOpBasic.ChangeNumber,
           _BillOfOperationsOpBasic.ValidityStartDate,
           _BillOfOperationsOpBasic.ValidityEndDate,


           // **************************** Associations *****************************

           _InspectionPlanVersion,
           _BillOfOperationsType
}
where _BillOfOperationsOpBasic.BillOfOperationsType = 'Q'

Learn More