I_ProdPlntInspTypeSettingTP_3

DDL: I_PRODPLNTINSPTYPESETTINGTP_3 Type: view_entity TRANSACTIONAL Package: VDM_MD_PRODUCT_BO_INTERFACE_V2

Inspection Type Settings - TP

I_ProdPlntInspTypeSettingTP_3 is a Transactional CDS View that provides data about "Inspection Type Settings - TP" in SAP S/4HANA. It reads from 1 data source (R_ProdPlntInspTypeSettingTP_2) and exposes 31 fields with key fields InspectionLotType, Product, Plant. Part of development package VDM_MD_PRODUCT_BO_INTERFACE_V2.

Data Sources (1)

SourceAliasJoin Type
R_ProdPlntInspTypeSettingTP_2 R_ProdPlntInspTypeSettingTP_2 projection

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Inspection Type Settings - TP view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.modelingPattern #TRANSACTIONAL_INTERFACE view
Metadata.ignorePropagatedAnnotations true view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY InspectionLotType InspectionLotType Inspection Type
KEY Product Product Product Sold
KEY Plant Plant Valuation Area
InspLotIsTaskListRequired InspLotIsTaskListRequired
InspLotHasMaterialSpec InspLotHasMaterialSpec
InspLotHasConfignSpecification InspLotHasConfignSpecification
InspLotHasBatchCharc InspLotHasBatchCharc
InspLotHasAutomSpecAssgmt InspLotHasAutomSpecAssgmt
InspLotHasCharc InspLotHasCharc
HasPostToInspectionStock HasPostToInspectionStock Post to insp. stk
InspLotIsAutomUsgeDcsnPossible InspLotIsAutomUsgeDcsnPossible
SamplingProcedure SamplingProcedure
InspLotDynamicRule InspLotDynamicRule
InspLotSampleQuantityInPercent InspLotSampleQuantityInPercent
InspectionLotIsFullInspection InspectionLotIsFullInspection
InspLotSkipIsAllowed InspLotSkipIsAllowed
InspLotHasManualSampleSize InspLotHasManualSampleSize
InspLotIsSmplCalcMnlTriggered InspLotIsSmplCalcMnlTriggered
InspLotIsSerialNmbrPossible InspLotIsSerialNmbrPossible
InspLotDurationInDays InspLotDurationInDays
InspLotSummaryControl InspLotSummaryControl
InspQualityScoreProcedure InspQualityScoreProcedure
InspLotAcceptedScrapRatioInPct InspLotAcceptedScrapRatioInPct
InspectionLotHasAppraisalCosts InspectionLotHasAppraisalCosts
QualityCostCollector QualityCostCollector
ProdInspTypeSettingIsActive ProdInspTypeSettingIsActive
InspTypeIsPrfrd InspTypeIsPrfrd
InspLotHasHandlingUnit InspLotHasHandlingUnit
InspLotHasMultipleSpec InspLotHasMultipleSpec
InspLotOfEWMSummaryControl InspLotOfEWMSummaryControl
_ProductredirectedtoI_ProductTP_3

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_ProdPlntInspTypeSettingTP_3.
-- 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_ProdPlntInspTypeSettingTP_3 AS
SELECT
  InspectionLotType,
  Product,
  Plant,
  InspLotIsTaskListRequired,
  InspLotHasMaterialSpec,
  InspLotHasConfignSpecification,
  InspLotHasBatchCharc,
  InspLotHasAutomSpecAssgmt,
  InspLotHasCharc,
  HasPostToInspectionStock,
  InspLotIsAutomUsgeDcsnPossible,
  SamplingProcedure,
  InspLotDynamicRule,
  InspLotSampleQuantityInPercent,
  InspectionLotIsFullInspection,
  InspLotSkipIsAllowed,
  InspLotHasManualSampleSize,
  InspLotIsSmplCalcMnlTriggered,
  InspLotIsSerialNmbrPossible,
  InspLotDurationInDays,
  InspLotSummaryControl,
  InspQualityScoreProcedure,
  InspLotAcceptedScrapRatioInPct,
  InspectionLotHasAppraisalCosts,
  QualityCostCollector,
  ProdInspTypeSettingIsActive,
  InspTypeIsPrfrd,
  InspLotHasHandlingUnit,
  InspLotHasMultipleSpec,
  InspLotOfEWMSummaryControl
FROM R_ProdPlntInspTypeSettingTP_2
;