I_InspPlanDpndantCharcTP

DDL: I_INSPPLANDPNDANTCHARCTP SQL: IINSPOPDPCHARTP Type: view TRANSACTIONAL
80 Fields 1 Data Sources 3 Associations

Inspection Plan Dependent Charac.

I_InspPlanDpndantCharcTP is a Transactional CDS View that provides data about "Inspection Plan Dependent Charac." in SAP S/4HANA. It reads from 1 data source (I_InspPlanDpndantCharc) and exposes 80 fields with key fields InspectionPlanGroup, InspectionPlan, InspectionPlanInternalVersion, BOOOperationInternalID, BOOOpInternalVersionCounter. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_InspPlanDpndantCharc _InspPlanDpndantCharc from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_InspPlanOpCharcTP _InspPlanCharc $projection.InspectionPlanGroup = _InspPlanCharc.InspectionPlanGroup and $projection.InspectionPlan = _InspPlanCharc.InspectionPlan and $projection.InspectionPlanInternalVersion = _InspPlanCharc.InspectionPlanInternalVersion and $projection.BOOOperationInternalID = _InspPlanCharc.BOOOperationInternalID and $projection.BOOOpInternalVersionCounter = _InspPlanCharc.BOOOpInternalVersionCounter and $projection.BOOCharacteristic = _InspPlanCharc.BOOCharacteristic and $projection.BOOCharacteristicVersion = _InspPlanCharc.BOOCharacteristicVersion and $projection.BillOfOperationsType = _InspPlanCharc.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
[1..1] I_InspPlanOpPRT _InspPlanOpPRT $projection.InspectionPlanGroup = _InspPlanOpPRT.InspectionPlanGroup and $projection.InspectionPlan = _InspPlanOpPRT.InspectionPlan and $projection.InspectionPlanInternalVersion = _InspPlanOpPRT.InspectionPlanInternalVersion and $projection.BOOOperationInternalID = _InspPlanOpPRT.BOOOperationInternalID and $projection.BOOOpInternalVersionCounter = _InspPlanOpPRT.BOOOpInternalVersionCounter and $projection.BOOOperationPRTInternalID = _InspPlanOpPRT.BOOOperationPRTInternalID

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName IINSPOPDPCHARTP view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Inspection Plan Dependent Charac. 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 QIPDPCHARC_D view
AbapCatalog.preserveKey true view

Fields (80)

KeyFieldSource TableSource FieldDescription
KEY InspectionPlanGroup InspectionPlanGroup Group
KEY InspectionPlan InspectionPlan Group Counter
KEY InspectionPlanInternalVersion InspectionPlanInternalVersion
KEY BOOOperationInternalID BOOOperationInternalID Task list node
KEY BOOOpInternalVersionCounter BOOOpInternalVersionCounter Counter
KEY BOOCharacteristic BOOCharacteristic
KEY BOOCharacteristicVersion BOOCharacteristicVersion
KEY BOODpndantCharcSpec BOODpndantCharcSpec
KEY BOODpndantCharcSpecVers BOODpndantCharcSpecVers
KEY BillOfOperationsType BillOfOperationsType Task List Type
InspSpecIsQuantitative _InspPlanCharc InspSpecIsQuantitative Quant.charac.
InspSpecIsDefectsRecgAutomatic _InspPlanCharc InspSpecIsDefectsRecgAutomatic
InspSpecIsSelectedSetRequired _InspPlanCharc InspSpecIsSelectedSetRequired
BillOfOperationsDesc _InspPlan BillOfOperationsDesc
OperationText _InspPlanCharc OperationText Description
Operation _InspPlanCharc Operation Transaction
InspectionSpecificationText _InspPlanCharc InspectionSpecificationText
InspSpecIsDefectRecordingRqd _InspPlanCharc InspSpecIsDefectRecordingRqd
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
ChangeNumber ChangeNumber Change Number
Supplier Supplier Supplier
Customer Customer Sold-to Party
IsDeleted IsDeleted TRUE
BOOOperationPRTInternalID BOOOperationPRTInternalID
ProductionResourceTool _InspPlanOpPRT ProductionResourceTool PRT
ProductionResourceToolDesc _InspPlanOpPRT ProductionResourceToolDesc Description
Material Material Vehicle Model
Plant Plant Valuation Area
BillOfOperationsVariant BillOfOperationsVariant Group Counter
BOOToMaterialInternalID BOOToMaterialInternalID
InspToleranceSpecification InspToleranceSpecification
InspSpecDecimalPlaces InspSpecDecimalPlaces
InspectionSpecificationUnit InspectionSpecificationUnit Unit of Meas.
InspSpecTargetValue InspSpecTargetValue Target Value
InspSpecHasTargetValue InspSpecHasTargetValue
InspSpecUpperLimit InspSpecUpperLimit Upper Limit
InspSpecLowerLimit InspSpecLowerLimit Lower Limit
InspSpecHasUpperLimit InspSpecHasUpperLimit
InspSpecHasLowerLimit InspSpecHasLowerLimit
InspSpecDefectCodeGrpRjcnUpper InspSpecDefectCodeGrpRjcnUpper
InspSpecDefectCodeRjcnUpper InspSpecDefectCodeRjcnUpper
InspSpecDefectCodeGrpRjcnLower InspSpecDefectCodeGrpRjcnLower
InspSpecDefectCodeRjcnLower InspSpecDefectCodeRjcnLower
SelectedCodeSet SelectedCodeSet CodeGrp/SelSet
SelectedCodeSetPlant SelectedCodeSetPlant
InspSpecAdditionalCatalog2 InspSpecAdditionalCatalog2
InspSpecAdditionalSelectedSet2 InspSpecAdditionalSelectedSet2
InspSpecAdditionalCodeGroup2 InspSpecAdditionalCodeGroup2
InspSpecAddlSeldCodeSetPlant2 InspSpecAddlSeldCodeSetPlant2
InspSpecAdditionalCatalog3 InspSpecAdditionalCatalog3
InspSpecAdditionalSelectedSet3 InspSpecAdditionalSelectedSet3
InspSpecAdditionalCodeGroup3 InspSpecAdditionalCodeGroup3
InspSpecAddlSeldCodeSetPlant3 InspSpecAddlSeldCodeSetPlant3
InspSpecAdditionalCatalog4 InspSpecAdditionalCatalog4
InspSpecAdditionalSelectedSet4 InspSpecAdditionalSelectedSet4
InspSpecAdditionalCodeGroup4 InspSpecAdditionalCodeGroup4
InspSpecAddlSeldCodeSetPlant4 InspSpecAddlSeldCodeSetPlant4
InspSpecAdditionalCatalog5 InspSpecAdditionalCatalog5
InspSpecAdditionalSelectedSet5 InspSpecAdditionalSelectedSet5
InspSpecAdditionalCodeGroup5 InspSpecAdditionalCodeGroup5
InspSpecAddlSeldCodeSetPlant5 InspSpecAddlSeldCodeSetPlant5
InspSpecInformationField1 InspSpecInformationField1
InspSpecInformationField2 InspSpecInformationField2
InspSpecInformationField3 InspSpecInformationField3
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
LastChangedByUser LastChangedByUser User Name
LastChangeDate LastChangeDate Time Stamp
BillOfOperationsVersion BillOfOperationsVersion Routing Version
_InspDefectCodeGrpRjcnLower _InspDefectCodeGrpRjcnLower
_InspDefectCodeGrpRjcnUpper _InspDefectCodeGrpRjcnUpper
_InspDefectCodeRjcnLower _InspDefectCodeRjcnLower
_InspDefectCodeRjcnUpper _InspDefectCodeRjcnUpper
_InspSpecUnitOfMeasure _InspSpecUnitOfMeasure
_InspToleranceSpecification _InspToleranceSpecification
_Material _Material
_Plant _Plant
_InspPlanCharc _InspPlanCharc
_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_InspPlanDpndantCharcTP.
-- 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.
-- SQL view name: IINSPOPDPCHARTP

CREATE VIEW I_InspPlanDpndantCharcTP AS
SELECT
  InspectionPlanGroup,
  InspectionPlan,
  InspectionPlanInternalVersion,
  BOOOperationInternalID,
  BOOOpInternalVersionCounter,
  BOOCharacteristic,
  BOOCharacteristicVersion,
  BOODpndantCharcSpec,
  BOODpndantCharcSpecVers,
  BillOfOperationsType,
  _InspPlanCharc.InspSpecIsQuantitative AS InspSpecIsQuantitative,
  _InspPlanCharc.InspSpecIsDefectsRecgAutomatic AS InspSpecIsDefectsRecgAutomatic,
  _InspPlanCharc.InspSpecIsSelectedSetRequired AS InspSpecIsSelectedSetRequired,
  _InspPlan.BillOfOperationsDesc AS BillOfOperationsDesc,
  _InspPlanCharc.OperationText AS OperationText,
  _InspPlanCharc.Operation AS Operation,
  _InspPlanCharc.InspectionSpecificationText AS InspectionSpecificationText,
  _InspPlanCharc.InspSpecIsDefectRecordingRqd AS InspSpecIsDefectRecordingRqd,
  ValidityStartDate,
  ValidityEndDate,
  ChangeNumber,
  Supplier,
  Customer,
  IsDeleted,
  BOOOperationPRTInternalID,
  _InspPlanOpPRT.ProductionResourceTool AS ProductionResourceTool,
  _InspPlanOpPRT.ProductionResourceToolDesc AS ProductionResourceToolDesc,
  Material,
  Plant,
  BillOfOperationsVariant,
  BOOToMaterialInternalID,
  InspToleranceSpecification,
  InspSpecDecimalPlaces,
  InspectionSpecificationUnit,
  InspSpecTargetValue,
  InspSpecHasTargetValue,
  InspSpecUpperLimit,
  InspSpecLowerLimit,
  InspSpecHasUpperLimit,
  InspSpecHasLowerLimit,
  InspSpecDefectCodeGrpRjcnUpper,
  InspSpecDefectCodeRjcnUpper,
  InspSpecDefectCodeGrpRjcnLower,
  InspSpecDefectCodeRjcnLower,
  SelectedCodeSet,
  SelectedCodeSetPlant,
  InspSpecAdditionalCatalog2,
  InspSpecAdditionalSelectedSet2,
  InspSpecAdditionalCodeGroup2,
  InspSpecAddlSeldCodeSetPlant2,
  InspSpecAdditionalCatalog3,
  InspSpecAdditionalSelectedSet3,
  InspSpecAdditionalCodeGroup3,
  InspSpecAddlSeldCodeSetPlant3,
  InspSpecAdditionalCatalog4,
  InspSpecAdditionalSelectedSet4,
  InspSpecAdditionalCodeGroup4,
  InspSpecAddlSeldCodeSetPlant4,
  InspSpecAdditionalCatalog5,
  InspSpecAdditionalSelectedSet5,
  InspSpecAdditionalCodeGroup5,
  InspSpecAddlSeldCodeSetPlant5,
  InspSpecInformationField1,
  InspSpecInformationField2,
  InspSpecInformationField3,
  CreatedByUser,
  CreationDate,
  LastChangedByUser,
  LastChangeDate,
  BillOfOperationsVersion
FROM I_InspPlanDpndantCharc AS _InspPlanDpndantCharc
LEFT OUTER JOIN I_InspPlanOpCharcTP AS _InspPlanCharc ON InspectionPlanGroup = _InspPlanCharc.InspectionPlanGroup AND InspectionPlan = _InspPlanCharc.InspectionPlan AND InspectionPlanInternalVersion = _InspPlanCharc.InspectionPlanInternalVersion AND BOOOperationInternalID = _InspPlanCharc.BOOOperationInternalID AND BOOOpInternalVersionCounter = _InspPlanCharc.BOOOpInternalVersionCounter AND BOOCharacteristic = _InspPlanCharc.BOOCharacteristic AND BOOCharacteristicVersion = _InspPlanCharc.BOOCharacteristicVersion AND BillOfOperationsType = _InspPlanCharc.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]
LEFT OUTER JOIN I_InspPlanOpPRT AS _InspPlanOpPRT ON InspectionPlanGroup = _InspPlanOpPRT.InspectionPlanGroup AND InspectionPlan = _InspPlanOpPRT.InspectionPlan AND InspectionPlanInternalVersion = _InspPlanOpPRT.InspectionPlanInternalVersion AND BOOOperationInternalID = _InspPlanOpPRT.BOOOperationInternalID AND BOOOpInternalVersionCounter = _InspPlanOpPRT.BOOOpInternalVersionCounter AND BOOOperationPRTInternalID = _InspPlanOpPRT.BOOOperationPRTInternalID  -- association [1..1]
;

Learn More