R_InspectionPlanVersionTP

DDL: R_INSPECTIONPLANVERSIONTP Type: view_entity TRANSACTIONAL

Inspection Plan Header Version

R_InspectionPlanVersionTP is a Transactional CDS View that provides data about "Inspection Plan Header Version" in SAP S/4HANA. It reads from 1 data source (I_InspectionPlanVersion) and exposes 33 fields with key fields InspectionPlanGroup, InspectionPlan, InspectionPlanInternalVersion.

1 data source(s) 33 fields

Data Sources (1)

SourceAliasJoin Type
I_InspectionPlanVersion I_InspectionPlanVersion from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Inspection Plan Header Version view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (33)

KeyFieldSource TableSource FieldDescription
KEY InspectionPlanGroup InspectionPlanGroup
KEY InspectionPlan InspectionPlan
KEY InspectionPlanInternalVersion InspectionPlanInternalVersion
BillOfOperationsStatus BillOfOperationsStatus
BillOfOperationsUsage BillOfOperationsUsage
BillOfOperationsDesc BillOfOperationsDesc
Plant Plant
IsDeleted IsDeleted
ResponsiblePlannerGroup ResponsiblePlannerGroup
MinimumLotSizeQuantity MinimumLotSizeQuantity
MaximumLotSizeQuantity MaximumLotSizeQuantity
BillOfOperationsUnit BillOfOperationsUnit
ReplacedBillOfOperations ReplacedBillOfOperations
IsMarkedForDeletion IsMarkedForDeletion
InspPlanHasMultipleSpec InspPlanHasMultipleSpec
InspSubsetFieldCombination InspSubsetFieldCombination
InspectionPartialLotAssignment InspectionPartialLotAssignment
SmplDrawingProcedure SmplDrawingProcedure
SmplDrawingProcedureVersion SmplDrawingProcedureVersion
InspectionLotDynamicLevel InspectionLotDynamicLevel
InspLotDynamicRule InspLotDynamicRule
InspExternalNumberingOfValues InspExternalNumberingOfValues
ChangeNumber ChangeNumber
ValidityStartDate ValidityStartDate
ValidityEndDate ValidityEndDate
CreationDate CreationDate
CreatedByUser CreatedByUser
LastChangeDate LastChangeDate
LastChangedByUser LastChangedByUser
ChangedDateTime _InspPlan ChangedDateTime
_InspPlan _InspPlan
_InspPlanMatlAssgmtVers _InspPlanMatlAssgmtVers
_InspPlanOpVersion _InspPlanOpVersion 
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Inspection Plan Header Version'
@Metadata.ignorePropagatedAnnotations: true

@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #M,
  dataClass: #MASTER
}

//@ObjectModel.representativeKey: 'InspectionPlanInternalVersion'

@VDM: { viewType: #TRANSACTIONAL, lifecycle.contract.type: #SAP_INTERNAL_API }

define view entity R_InspectionPlanVersionTP as select from I_InspectionPlanVersion

association[0..*] to R_InspPlanMatlAssgmtVersionTP as _InspPlanMatlAssgmtVers on $projection.InspectionPlanGroup = _InspPlanMatlAssgmtVers.InspectionPlanGroup
                                                                             and $projection.InspectionPlan      = _InspPlanMatlAssgmtVers.InspectionPlan
                                                                             and $projection.ValidityEndDate    >= _InspPlanMatlAssgmtVers.ValidityStartDate
                                                                             and $projection.ValidityStartDate  <= _InspPlanMatlAssgmtVers.ValidityEndDate
                                                                
association[0..*] to R_InspPlanOperationVersionTP as _InspPlanOpVersion on $projection.InspectionPlanGroup = _InspPlanOpVersion.InspectionPlanGroup
                                                                       and $projection.InspectionPlan      = _InspPlanOpVersion.InspectionPlan
                                                                       and $projection.ValidityEndDate    >= _InspPlanOpVersion.ValidityStartDate
                                                                       and $projection.ValidityStartDate  <= _InspPlanOpVersion.ValidityEndDate                                          

association to parent R_InspectionPlanTP as _InspPlan on $projection.InspectionPlanGroup = _InspPlan.InspectionPlanGroup
                                                      and $projection.InspectionPlan      = _InspPlan.InspectionPlan
{
  key InspectionPlanGroup,
  key InspectionPlan,
  key InspectionPlanInternalVersion,
  
  BillOfOperationsStatus,
  BillOfOperationsUsage,
  BillOfOperationsDesc,
  
  Plant,
  
  IsDeleted,

  ResponsiblePlannerGroup,
  @Semantics.quantity.unitOfMeasure: 'BillOfOperationsUnit'
  MinimumLotSizeQuantity,
  @Semantics.quantity.unitOfMeasure: 'BillOfOperationsUnit'
  MaximumLotSizeQuantity,
  BillOfOperationsUnit,
  ReplacedBillOfOperations,
  IsMarkedForDeletion,
  @Semantics.booleanIndicator: true
  InspPlanHasMultipleSpec,

  InspSubsetFieldCombination,
  InspectionPartialLotAssignment,
  SmplDrawingProcedure,
  SmplDrawingProcedureVersion,
  InspectionLotDynamicLevel,
  InspLotDynamicRule,
  InspExternalNumberingOfValues,

  ChangeNumber,
  ValidityStartDate,
  ValidityEndDate,

  CreationDate,
  CreatedByUser,
  LastChangeDate,
  LastChangedByUser,
  _InspPlan.ChangedDateTime,  
  
  _InspPlan,
  _InspPlanMatlAssgmtVers,
  _InspPlanOpVersion
} where BillOfOperationsType = 'Q' 
  and IsDeleted <> 'X'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_INSPECTIONPLANVERSION",
"R_INSPECTIONPLANTP"
],
"ASSOCIATED":
[
"R_INSPECTIONPLANTP",
"R_INSPPLANMATLASSGMTVERSIONTP",
"R_INSPPLANOPERATIONVERSIONTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More