R_InspectionPlanVersionTP

DDL: R_INSPECTIONPLANVERSIONTP Type: view_entity TRANSACTIONAL
33 Fields 1 Data Sources

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.

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 Group
KEY InspectionPlan InspectionPlan Group Counter
KEY InspectionPlanInternalVersion InspectionPlanInternalVersion
BillOfOperationsStatus BillOfOperationsStatus
BillOfOperationsUsage BillOfOperationsUsage
BillOfOperationsDesc BillOfOperationsDesc
Plant Plant Valuation Area
IsDeleted IsDeleted TRUE
ResponsiblePlannerGroup ResponsiblePlannerGroup
MinimumLotSizeQuantity MinimumLotSizeQuantity Min. Lot Size
MaximumLotSizeQuantity MaximumLotSizeQuantity Max. Lot Size
BillOfOperationsUnit BillOfOperationsUnit
ReplacedBillOfOperations ReplacedBillOfOperations
IsMarkedForDeletion IsMarkedForDeletion Purch.org. data
InspPlanHasMultipleSpec InspPlanHasMultipleSpec
InspSubsetFieldCombination InspSubsetFieldCombination
InspectionPartialLotAssignment InspectionPartialLotAssignment
SmplDrawingProcedure SmplDrawingProcedure
SmplDrawingProcedureVersion SmplDrawingProcedureVersion
InspectionLotDynamicLevel InspectionLotDynamicLevel
InspLotDynamicRule InspLotDynamicRule
InspExternalNumberingOfValues InspExternalNumberingOfValues
ChangeNumber ChangeNumber Change Number
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
CreationDate CreationDate Time Stamp
CreatedByUser CreatedByUser User Name
LastChangeDate LastChangeDate Time Stamp
LastChangedByUser LastChangedByUser User Name
ChangedDateTime _InspPlan ChangedDateTime Time Stamp
_InspPlan _InspPlan
_InspPlanMatlAssgmtVers _InspPlanMatlAssgmtVers
_InspPlanOpVersion _InspPlanOpVersion

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 R_InspectionPlanVersionTP.
-- 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 R_InspectionPlanVersionTP AS
SELECT
  InspectionPlanGroup,
  InspectionPlan,
  InspectionPlanInternalVersion,
  BillOfOperationsStatus,
  BillOfOperationsUsage,
  BillOfOperationsDesc,
  Plant,
  IsDeleted,
  ResponsiblePlannerGroup,
  MinimumLotSizeQuantity,
  MaximumLotSizeQuantity,
  BillOfOperationsUnit,
  ReplacedBillOfOperations,
  IsMarkedForDeletion,
  InspPlanHasMultipleSpec,
  InspSubsetFieldCombination,
  InspectionPartialLotAssignment,
  SmplDrawingProcedure,
  SmplDrawingProcedureVersion,
  InspectionLotDynamicLevel,
  InspLotDynamicRule,
  InspExternalNumberingOfValues,
  ChangeNumber,
  ValidityStartDate,
  ValidityEndDate,
  CreationDate,
  CreatedByUser,
  LastChangeDate,
  LastChangedByUser,
  _InspPlan.ChangedDateTime AS ChangedDateTime
FROM I_InspectionPlanVersion
;

Learn More