A_ProdPlntInspTypeSetting_2

DDL: A_PRODPLNTINSPTYPESETTING_2 Type: view_entity CONSUMPTION

Inspection Type Settings

A_ProdPlntInspTypeSetting_2 is a Consumption CDS View that provides data about "Inspection Type Settings" in SAP S/4HANA. It reads from 1 data source (R_ProdPlntInspTypeSettingTP) and exposes 31 fields with key fields InspectionLotType, Product, Plant.

Data Sources (1)

SourceAliasJoin Type
R_ProdPlntInspTypeSettingTP R_ProdPlntInspTypeSettingTP projection

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Inspection Type Settings view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
Metadata.ignorePropagatedAnnotations true view
OData.entityType.name ProductPlantInspTypSetting_Type 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
_ProductredirectedtoA_Product_2

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 A_ProdPlntInspTypeSetting_2.
-- 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 A_ProdPlntInspTypeSetting_2 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
;