I_InspPlanPRTOpTP

DDL: I_INSPPLANPRTOPTP Type: view_entity TRANSACTIONAL Package: VDM_QM_PLANNING
65 Fields 2 Associations

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 Task list node
KEY BOOOpInternalVersionCounter BOOOpInternalVersionCounter Counter
KEY BOOOperationPRTInternalID BOOOperationPRTInternalID
KEY BillOfOperationsType BillOfOperationsType Task List Type
BillOfOperationsSequence BillOfOperationsSequence Sequence
OperationText _InspPlanOp OperationText Description
BillOfOperationsDesc _InspPlan BillOfOperationsDesc
ProductionResourceType ProductionResourceType Object Type
ProductionResourceInternalID ProductionResourceInternalID Object ID
ProdnRsceToolCategoryName ProdnRsceToolCategoryName Description
ProductionResourceTool ProductionResourceTool PRT
ProductionResourceToolDesc ProductionResourceToolDesc Description
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
ChangeNumber ChangeNumber Change Number
ProdnRsceToolItemNumber ProdnRsceToolItemNumber Item Number
ProdnRsceToolControlProfile ProdnRsceToolControlProfile
ProdnRsceToolStandardTextCode ProdnRsceToolStandardTextCode
ProdnRsceToolText ProdnRsceToolText
CreationDate CreationDate Time Stamp
CreatedByUser CreatedByUser User Name
LastChangeDate LastChangeDate Time Stamp
LastChangedByUser LastChangedByUser User Name
IsDeleted IsDeleted TRUE
IsImplicitlyDeleted IsImplicitlyDeleted
ProdnRsceToolStdWorkQtyUnit ProdnRsceToolStdWorkQtyUnit Unit
ProdnRsceToolStandardWorkQty ProdnRsceToolStandardWorkQty Quantity
ProdnRsceToolTotQtyCalcFormula ProdnRsceToolTotQtyCalcFormula
ProdnRsceToolUsageQuantityUnit ProdnRsceToolUsageQuantityUnit
ProdnRsceToolUsageQuantity ProdnRsceToolUsageQuantity
ProdnRsceToolUsageQtyCalcFmla ProdnRsceToolUsageQtyCalcFmla
StartDateOffsetReferenceCode StartDateOffsetReferenceCode
StartDateOffsetDurationUnit StartDateOffsetDurationUnit
StartDateOffsetDuration StartDateOffsetDuration
EndDateOffsetReferenceCode EndDateOffsetReferenceCode
EndDateOffsetDurationUnit EndDateOffsetDurationUnit
EndDateOffsetDuration EndDateOffsetDuration
BillOfOperationsVersion BillOfOperationsVersion Routing Version
_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

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_InspPlanPRTOpTP.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_InspPlanPRTOpTP AS
SELECT
  InspectionPlanGroup,
  InspectionPlan,
  InspectionPlanInternalVersion,
  BOOOperationInternalID,
  BOOOpInternalVersionCounter,
  BOOOperationPRTInternalID,
  BillOfOperationsType,
  BillOfOperationsSequence,
  _InspPlanOp.OperationText AS OperationText,
  _InspPlan.BillOfOperationsDesc AS BillOfOperationsDesc,
  ProductionResourceType,
  ProductionResourceInternalID,
  ProdnRsceToolCategoryName,
  ProductionResourceTool,
  ProductionResourceToolDesc,
  ValidityStartDate,
  ValidityEndDate,
  ChangeNumber,
  ProdnRsceToolItemNumber,
  ProdnRsceToolControlProfile,
  ProdnRsceToolStandardTextCode,
  ProdnRsceToolText,
  CreationDate,
  CreatedByUser,
  LastChangeDate,
  LastChangedByUser,
  IsDeleted,
  IsImplicitlyDeleted,
  ProdnRsceToolStdWorkQtyUnit,
  ProdnRsceToolStandardWorkQty,
  ProdnRsceToolTotQtyCalcFormula,
  ProdnRsceToolUsageQuantityUnit,
  ProdnRsceToolUsageQuantity,
  ProdnRsceToolUsageQtyCalcFmla,
  StartDateOffsetReferenceCode,
  StartDateOffsetDurationUnit,
  StartDateOffsetDuration,
  EndDateOffsetReferenceCode,
  EndDateOffsetDurationUnit,
  EndDateOffsetDuration,
  BillOfOperationsVersion
LEFT OUTER JOIN I_InspPlanOperationTP AS _InspPlanOp ON InspectionPlanGroup = _InspPlanOp.InspectionPlanGroup AND InspectionPlan = _InspPlanOp.InspectionPlan AND InspectionPlanInternalVersion = _InspPlanOp.InspectionPlanInternalVersion AND BOOOperationInternalID = _InspPlanOp.BOOOperationInternalID AND BOOOpInternalVersionCounter = _InspPlanOp.BOOOpInternalVersionCounter AND BillOfOperationsType = _InspPlanOp.BillOfOperationsType  -- association [1..1]
LEFT OUTER JOIN I_InspectionPlanTP AS _InspPlan ON InspectionPlanGroup = _InspPlan.InspectionPlanGroup AND InspectionPlan = _InspPlan.InspectionPlan AND InspectionPlanInternalVersion = _InspPlan.InspectionPlanInternalVersion AND BillOfOperationsType = _InspPlan.BillOfOperationsType  -- association [1..1]
;

Learn More