I_InspectionSubsetTP

DDL: I_INSPECTIONSUBSETTP Type: view_entity TRANSACTIONAL Package: VDM_QM_INSPECTION

Inspection Point of Inspection Operation

I_InspectionSubsetTP is a Transactional CDS View that provides data about "Inspection Point of Inspection Operation" in SAP S/4HANA. It reads from 1 data source (I_InspectionSubset) and exposes 60 fields with key fields InspectionLot, InspPlanOperationInternalID, InspectionSubsetInternalID. It has 3 associations to related views. Part of development package VDM_QM_INSPECTION.

Data Sources (1)

SourceAliasJoin Type
I_InspectionSubset InspectionSubset from

Associations (3)

CardinalityTargetAliasCondition
[0..*] I_InspSubsetCharcResultTP _InspSubsetCharcResult $projection.InspectionLot = _InspSubsetCharcResult.InspectionLot and $projection.InspPlanOperationInternalID = _InspSubsetCharcResult.InspPlanOperationInternalID and $projection.InspectionSubsetInternalID = _InspSubsetCharcResult.InspectionSubsetInternalID
[1..1] I_UserContactCard _CreatedByUser $projection.UserID = _CreatedByUser.ContactCardID
[1..1] I_UserContactCard _LastChangedByUser $projection.ContactCardID = _LastChangedByUser.ContactCardID

Annotations (18)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Inspection Point of Inspection Operation view
VDM.viewType #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.compositionRoot true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.draftEnabled true view
ObjectModel.writeDraftPersistence QINSPSUBSETRR_D view
ObjectModel.entityChangeStateId ChangedDateTime view
ObjectModel.lifecycle.enqueue.expiryBehavior #RELATIVE_TO_LAST_CHANGE view
ObjectModel.lifecycle.enqueue.expiryInterval PT15M view
ObjectModel.lifecycle.processing.expiryBehavior #RELATIVE_TO_LAST_CHANGE view
ObjectModel.lifecycle.processing.expiryInterval PT30M view

Fields (60)

KeyFieldSource TableSource FieldDescription
KEY InspectionLot I_InspectionSubset InspectionLot
KEY InspPlanOperationInternalID I_InspectionSubset InspPlanOperationInternalID
KEY InspectionSubsetInternalID I_InspectionSubset InspectionSubsetInternalID
InspectionLotForEdit
InspectionOperationForEdit
InspectionOperation
InspSubsetStatus
InspectionSubsetSortKey I_InspectionSubset InspectionSubsetSortKey
InspectionOperations
ChangedDateTime I_InspectionSubset ChangedDateTime
InspSubsetTimeInterval
InspSubsetTimeIntervalUnit
SelectedCodeSetPlant SelectedCodeSet SelectedCodeSetPlant
SelectedCodeSet SelectedCodeSet SelectedCodeSet
InspSubsetUsageDcsnCodeGroup I_InspectionSubset InspSubsetUsageDcsnCodeGroup
InspSubsetUsageDcsnCode I_InspectionSubset InspSubsetUsageDcsnCode
InspSubsetUsageDcsnValuation I_InspectionSubset InspSubsetUsageDcsnValuation
InspectionSubsetTime I_InspectionSubset InspectionSubsetTime
InspSbstTimeFldProperty SelectedCodeSet InspSbstTimeFldProperty
InspectionSubsetDate I_InspectionSubset InspectionSubsetDate
InspSbstDateFldProperty SelectedCodeSet InspSbstDateFldProperty
InspectionSubsetTimeZone I_InspectionSubset InspectionSubsetTimeZone
InspSubsetLongNumericKey I_InspectionSubset InspSubsetLongNumericKey
InspSbstLongNmbrFldProperty I_InspectionSubset InspSbstLongNmbrFldProperty
InspSubsetShortNumericKey I_InspectionSubset InspSubsetShortNumericKey
InspSbstShrtNmbrFldProperty I_InspectionSubset InspSbstShrtNmbrFldProperty
InspectionSubsetLongCharKey I_InspectionSubset InspectionSubsetLongCharKey
InspSbstLongTxtFldProperty I_InspectionSubset InspSbstLongTxtFldProperty
InspectionSubsetShortCharKey I_InspectionSubset InspectionSubsetShortCharKey
InspSbstShrtTxtFldProperty I_InspectionSubset InspSbstShrtTxtFldProperty
InspSubsetTimeFieldName SelectedCodeSet InspSubsetTimeFieldName
InspSubsetDateFieldName SelectedCodeSet InspSubsetDateFieldName
InspSubsetLongTxtFieldName SelectedCodeSet InspSubsetLongTxtFieldName
InspSubsetShortTxtFieldName SelectedCodeSet InspSubsetShortTxtFieldName
InspSubsetLongNmbrFieldName SelectedCodeSet InspSubsetLongNmbrFieldName
InspSubsetShortNmbrFieldName SelectedCodeSet InspSubsetShortNmbrFieldName
InspectionSubsetYieldQty I_InspectionSubset InspectionSubsetYieldQty
InspectionSubsetScrapQty I_InspectionSubset InspectionSubsetScrapQty
InspectionSubsetReworkQty I_InspectionSubset InspectionSubsetReworkQty
InspectionSubsetQtyUnit I_InspectionSubset InspectionSubsetQtyUnit
Inspector I_InspectionSubset Inspector
UserID I_InspectionSubset CreatedByUser
ContactCardID I_InspectionSubset LastChangedByUser
CreatedByUser _CreatedByUser FullName
CreationDate I_InspectionSubset CreationDate
CreationTime I_InspectionSubset CreationTime
LastChangedByUser _LastChangedByUser FullName
LastChangeDate I_InspectionSubset LastChangeDate
LastChangeTime I_InspectionSubset LastChangeTime
_InspSubsetCharcResult _InspSubsetCharcResult
_InspectionLot I_InspectionSubset _InspectionLot
_InspectionOperation I_InspectionSubset _InspectionOperation
_InspectionSubsetInternalID I_InspectionSubset _InspectionSubsetInternalID
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser
_UsageDecisionCodeGroup I_InspectionSubset _UsageDecisionCodeGroup
_UsageDecisionCode I_InspectionSubset _UsageDecisionCode
_InspSubsetUsageDcsnValn I_InspectionSubset _InspSubsetUsageDcsnValn
_InspSubsetUsageDcsnValnTxt I_InspectionSubset _InspSubsetUsageDcsnValnTxt
_Unit I_InspectionSubset _Unit
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Inspection Point of Inspection Operation'
@VDM.viewType: #TRANSACTIONAL 
@AccessControl.privilegedAssociations:  [ '_CreatedByUser' ]
//@ObjectModel.representativeKey: 'InspectionSubsetInternalID'

@ObjectModel.usageType: { serviceQuality: #D, sizeCategory: #L, dataClass: #TRANSACTIONAL }

/* Draft 2.0 */
//@ObjectModel.modelCategory: #BUSINESS_OBJECT

@ObjectModel.semanticKey:  [ 'InspectionLot' , 'InspectionSubsetInternalID' , 'InspPlanOperationInternalID'  ]
@ObjectModel:{
    compositionRoot: true,
    createEnabled: true,
    updateEnabled: true,
    deleteEnabled: true,
    transactionalProcessingEnabled: true,
    draftEnabled: true,
    writeDraftPersistence: 'QINSPSUBSETRR_D',
    entityChangeStateId: 'ChangedDateTime',
    lifecycle.enqueue: {
        expiryBehavior: #RELATIVE_TO_LAST_CHANGE,  // Default #RELATIVE_TO_LAST_CHANGE

        expiryInterval: 'PT15M'                    // Default 'PT15M'

      //  notificationBeforeExpiryInterval: 'PT1M'   // Default 'PT5M'

    },
    lifecycle.processing: {
        expiryBehavior: #RELATIVE_TO_LAST_CHANGE,  // Default #RELATIVE_TO_LAST_CHANGE

        expiryInterval: 'PT30M'                       // Default 'PT30M'

      //  notificationBeforeExpiryInterval: 'PT3M'    // Default 'PT10M'

    }
}

define view entity I_InspectionSubsetTP 
  as select from I_InspectionSubset        as InspectionSubset
    left outer to one join P_InspUsgeDcsnSelectedSetCode as SelectedCodeSet   on  InspectionSubset.InspectionLot                   = SelectedCodeSet.InspectionLot
  association [0..*] to I_InspSubsetCharcResultTP as _InspSubsetCharcResult on  $projection.InspectionLot               = _InspSubsetCharcResult.InspectionLot
                                                                            and $projection.InspPlanOperationInternalID = _InspSubsetCharcResult.InspPlanOperationInternalID
                                                                            and $projection.InspectionSubsetInternalID  = _InspSubsetCharcResult.InspectionSubsetInternalID                                                                           
  association [1..1] to I_UserContactCard         as _CreatedByUser           on  $projection.UserID = _CreatedByUser.ContactCardID
  association [1..1] to I_UserContactCard         as _LastChangedByUser       on  $projection.ContactCardID = _LastChangedByUser.ContactCardID                                                                            


{
      @ObjectModel.foreignKey.association: '_InspectionLot'
  key InspectionSubset.InspectionLot,
      @ObjectModel.foreignKey.association: '_InspectionOperation'
  key InspectionSubset.InspPlanOperationInternalID,
  key InspectionSubset.InspectionSubsetInternalID,
      cast(InspectionSubset.InspectionLot as qplos preserving type )                  as InspectionLotForEdit,
      cast(InspectionSubset.InspPlanOperationInternalID as qlfnkn preserving type )   as InspectionOperationForEdit,
      InspectionSubset._InspectionOperation.InspectionOperation,
      //@ObjectModel.readOnly: true

      cast('' as abap.char( 2 ))                                     as InspSubsetStatus,
      InspectionSubset.InspectionSubsetSortKey,

      //@ObjectModel.readOnly: true

      cast ('' as abap.char(1333))                                   as InspectionOperations,
      // Field for E-tag

      @ObjectModel.readOnly: true
      InspectionSubset.ChangedDateTime,

      cast(00000 as qrastzfak)                                       as InspSubsetTimeInterval,
      cast('' as qrastzeht)                                          as InspSubsetTimeIntervalUnit,

      SelectedCodeSet.SelectedCodeSetPlant,
    //  @ObjectModel.foreignKey.association: '_SelectedCodeSet'

      SelectedCodeSet.SelectedCodeSet,
      @ObjectModel.foreignKey.association: '_UsageDecisionCodeGroup'
      InspectionSubset.InspSubsetUsageDcsnCodeGroup,
      InspectionSubset.InspSubsetUsageDcsnCode,
      @ObjectModel.foreignKey.association: '_InspSubsetUsageDcsnValn'
      InspectionSubset.InspSubsetUsageDcsnValuation,
      InspectionSubset.InspectionSubsetTime,
      SelectedCodeSet.InspSbstTimeFldProperty,
      InspectionSubset.InspectionSubsetDate,
      SelectedCodeSet.InspSbstDateFldProperty,
      InspectionSubset.InspectionSubsetTimeZone,
      InspectionSubset.InspSubsetLongNumericKey,
      InspectionSubset.InspSbstLongNmbrFldProperty,
      InspectionSubset.InspSubsetShortNumericKey,
      InspectionSubset.InspSbstShrtNmbrFldProperty,
      InspectionSubset.InspectionSubsetLongCharKey,
      InspectionSubset.InspSbstLongTxtFldProperty,
      InspectionSubset.InspectionSubsetShortCharKey,
      InspectionSubset.InspSbstShrtTxtFldProperty,  
      SelectedCodeSet.InspSubsetTimeFieldName,
      SelectedCodeSet.InspSubsetDateFieldName,
      
      @Feature: 'QM_IPRR_USER_FIELDS'   
      SelectedCodeSet.InspSubsetLongTxtFieldName,
      @Feature: 'QM_IPRR_USER_FIELDS'
      SelectedCodeSet.InspSubsetShortTxtFieldName,
      @Feature: 'QM_IPRR_USER_FIELDS'
      SelectedCodeSet.InspSubsetLongNmbrFieldName,
      @Feature: 'QM_IPRR_USER_FIELDS'
      SelectedCodeSet.InspSubsetShortNmbrFieldName,
//      @DefaultAggregation:#NONE

      @Semantics.quantity.unitOfMeasure: 'InspectionSubsetQtyUnit'
      InspectionSubset.InspectionSubsetYieldQty,
//      @DefaultAggregation:#NONE

      @Semantics.quantity.unitOfMeasure: 'InspectionSubsetQtyUnit'
      InspectionSubset.InspectionSubsetScrapQty,
//      @DefaultAggregation:#NONE

      @Semantics.quantity.unitOfMeasure: 'InspectionSubsetQtyUnit'
      InspectionSubset.InspectionSubsetReworkQty,
      @ObjectModel.foreignKey.association: '_Unit'
      InspectionSubset.InspectionSubsetQtyUnit,

      //    vetext as InspectionSubset,       QALT.vetext

      InspectionSubset.Inspector,
      
      
//      cast( InspectionSubsetDate as abap.char(8) ) as InspSubsetDateTime,

      
      @ObjectModel.readOnly: true
      InspectionSubset.CreatedByUser                                                           as UserID,
      @ObjectModel.readOnly: true
      InspectionSubset.LastChangedByUser                                      as ContactCardID,

      @ObjectModel.readOnly: true
       _CreatedByUser.FullName                                                 as CreatedByUser,
 //     @Semantics.businessDate.createdAt: true

      @ObjectModel.readOnly: true
      InspectionSubset.CreationDate,
      @Semantics.time: true
      @ObjectModel.readOnly: true
      InspectionSubset.CreationTime,      
      @ObjectModel.readOnly: true
      _LastChangedByUser.FullName                                             as LastChangedByUser,
 //     @Semantics.businessDate.lastChangedAt: true

      @ObjectModel.readOnly: true
      InspectionSubset.LastChangeDate,
      @Semantics.time: true
      @ObjectModel.readOnly: true
      InspectionSubset.LastChangeTime,

      //  Draft Associations

      @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
      _InspSubsetCharcResult,
 
      // Associations

      InspectionSubset._InspectionLot,
      InspectionSubset._InspectionOperation,
      InspectionSubset._InspectionSubsetInternalID,
      _CreatedByUser,
      _LastChangedByUser,
      InspectionSubset._UsageDecisionCodeGroup,
      InspectionSubset._UsageDecisionCode,
     // _SelectedCodeSet,

      InspectionSubset._InspSubsetUsageDcsnValn,
      InspectionSubset._InspSubsetUsageDcsnValnTxt,
      //    _MaterialSample,

      //    _FunctionalLocation,

      //    _ShopFloorItem,

      //    _Equipment,

      
      InspectionSubset._Unit
}