I_InspPlanPRTOpTP

DDL: I_INSPPLANPRTOPTP Type: view_entity TRANSACTIONAL Package: VDM_QM_PLANNING

Inspection Plan Op Prod Res Tool TP View

I_InspPlanPRTOpTP is a Transactional CDS View that provides data about "Inspection Plan Op Prod Res Tool TP View" in SAP S/4HANA. It has 2 associations to related views. Part of development package VDM_QM_PLANNING.

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_InspPlanOperationTP _InspPlanOp $projection.InspectionPlanGroup = _InspPlanOp.InspectionPlanGroup and $projection.InspectionPlan = _InspPlanOp.InspectionPlan and $projection.InspectionPlanInternalVersion = _InspPlanOp.InspectionPlanInternalVersion and $projection.BOOOperationInternalID = _InspPlanOp.BOOOperationInternalID and $projection.BOOOpInternalVersionCounter = _InspPlanOp.BOOOpInternalVersionCounter and $projection.BillOfOperationsType = _InspPlanOp.BillOfOperationsType
[1..1] I_InspectionPlanTP _InspPlan $projection.InspectionPlanGroup = _InspPlan.InspectionPlanGroup and $projection.InspectionPlan = _InspPlan.InspectionPlan and $projection.InspectionPlanInternalVersion = _InspPlan.InspectionPlanInternalVersion and $projection.BillOfOperationsType = _InspPlan.BillOfOperationsType

Annotations (10)

NameValueLevelField
EndUserText.label Inspection Plan Op Prod Res Tool TP View view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.writeDraftPersistence QIPPRT_D view

Fields (65)

KeyFieldSource TableSource FieldDescription
KEY InspectionPlanGroup InspectionPlanGroup
KEY InspectionPlan InspectionPlan
KEY InspectionPlanInternalVersion InspectionPlanInternalVersion
KEY BOOOperationInternalID BOOOperationInternalID
KEY BOOOpInternalVersionCounter BOOOpInternalVersionCounter
KEY BOOOperationPRTInternalID BOOOperationPRTInternalID
KEY BillOfOperationsType BillOfOperationsType
BillOfOperationsSequence BillOfOperationsSequence
OperationText _InspPlanOp OperationText
BillOfOperationsDesc _InspPlan BillOfOperationsDesc
ProductionResourceType ProductionResourceType
ProductionResourceInternalID ProductionResourceInternalID
ProdnRsceToolCategoryName ProdnRsceToolCategoryName
ProductionResourceTool ProductionResourceTool
ProductionResourceToolDesc ProductionResourceToolDesc
ValidityStartDate ValidityStartDate
ValidityEndDate ValidityEndDate
ChangeNumber ChangeNumber
ProdnRsceToolItemNumber ProdnRsceToolItemNumber
ProdnRsceToolControlProfile ProdnRsceToolControlProfile
ProdnRsceToolStandardTextCode ProdnRsceToolStandardTextCode
ProdnRsceToolText ProdnRsceToolText
CreationDate CreationDate
CreatedByUser CreatedByUser
LastChangeDate LastChangeDate
LastChangedByUser LastChangedByUser
IsDeleted IsDeleted
IsImplicitlyDeleted IsImplicitlyDeleted
ProdnRsceToolStdWorkQtyUnit ProdnRsceToolStdWorkQtyUnit
ProdnRsceToolStandardWorkQty ProdnRsceToolStandardWorkQty
ProdnRsceToolTotQtyCalcFormula ProdnRsceToolTotQtyCalcFormula
ProdnRsceToolUsageQuantityUnit ProdnRsceToolUsageQuantityUnit
ProdnRsceToolUsageQuantity ProdnRsceToolUsageQuantity
ProdnRsceToolUsageQtyCalcFmla ProdnRsceToolUsageQtyCalcFmla
StartDateOffsetReferenceCode StartDateOffsetReferenceCode
StartDateOffsetDurationUnit StartDateOffsetDurationUnit
StartDateOffsetDuration StartDateOffsetDuration
EndDateOffsetReferenceCode EndDateOffsetReferenceCode
EndDateOffsetDurationUnit EndDateOffsetDurationUnit
EndDateOffsetDuration EndDateOffsetDuration
BillOfOperationsVersion BillOfOperationsVersion
_BillOfOperations _BillOfOperations
_BillOfOperationsGroup _BillOfOperationsGroup
_BillOfOperationsOperation _BillOfOperationsOperation
_BillOfOperationsSequence _BillOfOperationsSequence
_BillOfOperationsType _BillOfOperationsType
_BOOOperationInternalID _BOOOperationInternalID
_BOOOperationPRTInternalID _BOOOperationPRTInternalID
_ChangeMaster _ChangeMaster
_CreatedByUser _CreatedByUser
_EndDateOffsetDurationUnit _EndDateOffsetDurationUnit
_EndDateOffsetReferenceCode _EndDateOffsetReferenceCode
_LastChangedByUser _LastChangedByUser
_ProdnResourceToolUsageUnit _ProdnResourceToolUsageUnit
_ProdnRsceToolControlProfile _ProdnRsceToolControlProfile
_ProdnRsceToolMasterData _ProdnRsceToolMasterData
_ProdnRsceToolStandardText _ProdnRsceToolStandardText
_ProdnRsceToolTotQtyCalcFmla _ProdnRsceToolTotQtyCalcFmla
_ProdnRsceToolUsageQtyCalcFmla _ProdnRsceToolUsageQtyCalcFmla
_ProductionResourceToolUnit _ProductionResourceToolUnit
_StartDateOffsetDurationUnit _StartDateOffsetDurationUnit
_StartDateOffsetReferenceCode _StartDateOffsetReferenceCode
_ProductionResourceType _ProductionResourceType
_InspPlanOp _InspPlanOp
_InspPlan _InspPlan
@EndUserText.label: 'Inspection Plan Op Prod Res Tool TP View'
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #TRANSACTIONAL
@ObjectModel.usageType: { serviceQuality: #C, sizeCategory: #M, dataClass: #MASTER }
@ObjectModel:{
 // draftEnabled : true,

    createEnabled: true,
    updateEnabled: true,
    deleteEnabled: true,
    writeDraftPersistence: 'QIPPRT_D'
}

define view entity I_InspPlanPRTOpTP
  as select distinct from I_InspPlanOpPRT as _InspPlanOpPRT

  association [1..1] to I_InspPlanOperationTP as _InspPlanOp on  $projection.InspectionPlanGroup           = _InspPlanOp.InspectionPlanGroup
                                                             and $projection.InspectionPlan                = _InspPlanOp.InspectionPlan
                                                             and $projection.InspectionPlanInternalVersion = _InspPlanOp.InspectionPlanInternalVersion
                                                             and $projection.BOOOperationInternalID        = _InspPlanOp.BOOOperationInternalID
                                                             and $projection.BOOOpInternalVersionCounter   = _InspPlanOp.BOOOpInternalVersionCounter
                                                             and $projection.BillOfOperationsType          = _InspPlanOp.BillOfOperationsType
                                                             
  association [1..1] to I_InspectionPlanTP    as _InspPlan   on  $projection.InspectionPlanGroup           = _InspPlan.InspectionPlanGroup
                                                             and $projection.InspectionPlan                = _InspPlan.InspectionPlan
                                                             and $projection.InspectionPlanInternalVersion = _InspPlan.InspectionPlanInternalVersion
                                                             and $projection.BillOfOperationsType          = _InspPlan.BillOfOperationsType

{
      //_InspPlanOpPRTAssgmt




  key InspectionPlanGroup,
  key InspectionPlan,
  key InspectionPlanInternalVersion,
  key BOOOperationInternalID,
  key BOOOpInternalVersionCounter,
  key BOOOperationPRTInternalID,
  key BillOfOperationsType,
      BillOfOperationsSequence,
      _InspPlanOp.OperationText,
      _InspPlan.BillOfOperationsDesc,
      // Billofoperationdesc,

      // BOOOperationPRTIntVersCounter,

      ProductionResourceType,
      ProductionResourceInternalID,
      //      ProdnRsceToolCategory,

      ProdnRsceToolCategoryName,
      ProductionResourceTool,
      ProductionResourceToolDesc,
      ValidityStartDate,
      ValidityEndDate,
      ChangeNumber,
      ProdnRsceToolItemNumber,
      ProdnRsceToolControlProfile,
      ProdnRsceToolStandardTextCode,
      ProdnRsceToolText,
      CreationDate,
      CreatedByUser,
      LastChangeDate,
      LastChangedByUser,
      IsDeleted,
      IsImplicitlyDeleted,
      ProdnRsceToolStdWorkQtyUnit,
      @Semantics.quantity.unitOfMeasure: 'PRODNRSCETOOLSTDWORKQTYUNIT' 
ProdnRsceToolStandardWorkQty,
      ProdnRsceToolTotQtyCalcFormula,
      ProdnRsceToolUsageQuantityUnit,
      @Semantics.quantity.unitOfMeasure: 'PRODNRSCETOOLUSAGEQUANTITYUNIT' 
ProdnRsceToolUsageQuantity,
      ProdnRsceToolUsageQtyCalcFmla,
      StartDateOffsetReferenceCode,
      StartDateOffsetDurationUnit,
      @Semantics.quantity.unitOfMeasure: 'STARTDATEOFFSETDURATIONUNIT' 
StartDateOffsetDuration,
      EndDateOffsetReferenceCode,
      EndDateOffsetDurationUnit,
      @Semantics.quantity.unitOfMeasure: 'ENDDATEOFFSETDURATIONUNIT' 
EndDateOffsetDuration,
      BillOfOperationsVersion,
      /* Associations */
      //_InspPlanOpPRTAssgmt

      _BillOfOperations,
      _BillOfOperationsGroup,
      _BillOfOperationsOperation,
      _BillOfOperationsSequence,
      _BillOfOperationsType,
      _BOOOperationInternalID,
      _BOOOperationPRTInternalID,
      _ChangeMaster,
      _CreatedByUser,
      _EndDateOffsetDurationUnit,
      _EndDateOffsetReferenceCode,
      //      _InspectionPlan,

      //      _InspectionPlanVersion,

      _LastChangedByUser,
      _ProdnResourceToolUsageUnit,
      _ProdnRsceToolControlProfile,
      _ProdnRsceToolMasterData,
      _ProdnRsceToolStandardText,
      _ProdnRsceToolTotQtyCalcFmla,
      _ProdnRsceToolUsageQtyCalcFmla,
      _ProductionResourceToolUnit,
      //      _ProductionResourceType,

      _StartDateOffsetDurationUnit,
      _StartDateOffsetReferenceCode,
      //      _ProdnRsceToolCategory,

      _ProductionResourceType,

      @ObjectModel.association.type: [#TO_COMPOSITION_PARENT]
      _InspPlanOp,
      @ObjectModel.association.type: [#TO_COMPOSITION_ROOT]
      _InspPlan

}