R_InspectionSubsetTP

DDL: R_INSPECTIONSUBSETTP Type: view_entity TRANSACTIONAL

Inspection Point - TP

R_InspectionSubsetTP is a Transactional CDS View that provides data about "Inspection Point - TP" in SAP S/4HANA. It reads from 1 data source (I_InspectionSubset) and exposes 45 fields with key fields InspectionLot, InspectionSubsetInternalID, InspPlanOperationInternalID. It has 2 associations to related views.

1 data source(s) 45 fields

Data Sources (1)

SourceAliasJoin Type
I_InspectionSubset InspectionSubset from

Associations (2)

CardinalityTargetAliasCondition
[1..1] R_InspectionLotTP _InspectionLot $projection.InspectionLot = _InspectionLot.InspectionLot
[0..*] R_InspSubsetCharacteristicTP _InspSubsetCharacteristic

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #TRANSACTIONAL view
EndUserText.label Inspection Point - TP view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (45)

KeyFieldSource TableSource FieldDescription
KEY InspectionLot InspectionLot
KEY InspectionSubsetInternalID InspectionSubsetInternalID
KEY InspPlanOperationInternalID InspPlanOperationInternalID
InspectionSubsetSortKey InspectionSubsetSortKey
MaterialSample MaterialSample
InspSbstMatlSmplProperty InspSbstMatlSmplProperty
Equipment Equipment
InspSbstEquipProperty InspSbstEquipProperty
FunctionalLocation FunctionalLocation
InspSbstFuncnlLocProperty InspSbstFuncnlLocProperty
ShopFloorItem ShopFloorItem
InspSbstShopFloorItemProperty InspSbstShopFloorItemProperty
SelectedCodeSetPlant SelectedCodeSetPlant
SelectedCodeSet SelectedCodeSet
InspSubsetUsageDcsnCodeGroup InspSubsetUsageDcsnCodeGroup
InspSubsetUsageDcsnCode InspSubsetUsageDcsnCode
InspSubsetUsageDcsnValuation InspSubsetUsageDcsnValuation
InspectionSubsetTime InspectionSubsetTime
InspSbstTimeFldProperty InspSbstTimeFldProperty
InspectionSubsetDate InspectionSubsetDate
InspSbstDateFldProperty InspSbstDateFldProperty
InspSubsetLongNumericKey InspSubsetLongNumericKey
InspSbstLongNmbrFldProperty InspSbstLongNmbrFldProperty
InspSubsetShortNumericKey InspSubsetShortNumericKey
InspSbstShrtNmbrFldProperty InspSbstShrtNmbrFldProperty
InspectionSubsetLongCharKey InspectionSubsetLongCharKey
InspSbstLongTxtFldProperty InspSbstLongTxtFldProperty
InspectionSubsetShortCharKey InspectionSubsetShortCharKey
InspSbstShrtTxtFldProperty InspSbstShrtTxtFldProperty
InspectionPartialLot InspectionPartialLot
InspectionSubsetYieldQty InspectionSubsetYieldQty
InspectionSubsetScrapQty InspectionSubsetScrapQty
InspectionSubsetReworkQty InspectionSubsetReworkQty
InspectionSubsetQtyUnit InspectionSubsetQtyUnit
Inspector Inspector
CreatedByUser CreatedByUser
CreationDate CreationDate
CreationTime CreationTime
LastChangedByUser LastChangedByUser
LastChangeDate LastChangeDate
LastChangeTime LastChangeTime
ChangedDateTime ChangedDateTime
_InspectionOperation _InspectionOperation
_InspectionLot _InspectionLot
_InspSubsetCharacteristic _InspSubsetCharacteristic 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@VDM.viewType: #TRANSACTIONAL
@EndUserText.label: 'Inspection Point - TP'
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #B,
  sizeCategory: #L,
  dataClass: #TRANSACTIONAL
}

define view entity R_InspectionSubsetTP
  as select from I_InspectionSubset as InspectionSubset

  composition [0..*] of R_InspSubsetCharacteristicTP as _InspSubsetCharacteristic

  association        to parent R_InspectionOperationTP      as _InspectionOperation on  $projection.InspectionLot               = _InspectionOperation.InspectionLot
                                                                                    and $projection.InspPlanOperationInternalID = _InspectionOperation.InspPlanOperationInternalID

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

  key InspectionLot,
  key InspectionSubsetInternalID,
  key InspPlanOperationInternalID,
      InspectionSubsetSortKey,
      MaterialSample,
      InspSbstMatlSmplProperty,
      Equipment,
      InspSbstEquipProperty,
      FunctionalLocation,
      InspSbstFuncnlLocProperty,
      ShopFloorItem,
      InspSbstShopFloorItemProperty,
      SelectedCodeSetPlant,
      SelectedCodeSet,
      InspSubsetUsageDcsnCodeGroup,
      InspSubsetUsageDcsnCode,
      InspSubsetUsageDcsnValuation,
      InspectionSubsetTime,
      InspSbstTimeFldProperty,
      InspectionSubsetDate,
      InspSbstDateFldProperty,
      InspSubsetLongNumericKey,
      InspSbstLongNmbrFldProperty,
      InspSubsetShortNumericKey,
      InspSbstShrtNmbrFldProperty,
      InspectionSubsetLongCharKey,
      InspSbstLongTxtFldProperty,
      InspectionSubsetShortCharKey,
      InspSbstShrtTxtFldProperty,
      InspectionPartialLot,
      @Semantics.quantity.unitOfMeasure: 'InspectionSubsetQtyUnit'
      InspectionSubsetYieldQty,
      @Semantics.quantity.unitOfMeasure: 'InspectionSubsetQtyUnit'
      InspectionSubsetScrapQty,
      @Semantics.quantity.unitOfMeasure: 'InspectionSubsetQtyUnit'
      InspectionSubsetReworkQty,
      InspectionSubsetQtyUnit,
      Inspector,
      CreatedByUser,
      CreationDate,
      CreationTime,
      LastChangedByUser,
      LastChangeDate,
      LastChangeTime,
      ChangedDateTime,

      _InspectionOperation,
      _InspectionLot,
      _InspSubsetCharacteristic
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_INSPECTIONSUBSET"
],
"ASSOCIATED":
[
"R_INSPECTIONLOTTP",
"R_INSPECTIONOPERATIONTP",
"R_INSPSUBSETCHARACTERISTICTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More