What is I_InspLotUsageDecisionTP_2 in SAP S/4HANA?

I_InspLotUsageDecisionTP_2 is a transactional CDS view in SAP S/4HANA. Usage Decision for Inspection Lot - TP It contains 17 fields.

Which tables does I_InspLotUsageDecisionTP_2 read from?

I_InspLotUsageDecisionTP_2 reads data from: R_InspectionLotUsageDecisionTP.

What VDM layer is I_InspLotUsageDecisionTP_2?

I_InspLotUsageDecisionTP_2 is classified as a Transactional view that supports create, update, and delete operations.

I_InspLotUsageDecisionTP_2

DDL: I_INSPLOTUSAGEDECISIONTP_2 Type: view_entity TRANSACTIONAL

17 Fields 1 Data Sources

Usage Decision for Inspection Lot - TP

I_InspLotUsageDecisionTP_2 is a Transactional CDS View that provides data about "Usage Decision for Inspection Lot - TP" in SAP S/4HANA. It reads from 1 data source (R_InspectionLotUsageDecisionTP) and exposes 17 fields with key field InspectionLot.

Data Sources (1)

Source	Alias	Join Type
R_InspectionLotUsageDecisionTP	R_InspectionLotUsageDecisionTP	projection

Annotations (7)

Name	Value	Level
EndUserText.label	Usage Decision for Inspection Lot - TP	view
AccessControl.authorizationCheck	#MANDATORY	view
VDM.viewType	#TRANSACTIONAL	view
ObjectModel.modelingPattern	#TRANSACTIONAL_INTERFACE	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.serviceQuality	#B	view

Fields (17)

Key	Field	Source Field	Description
KEY	InspectionLot	InspectionLot	Inspection Lot
	InspectionLotQualityScore	InspectionLotQualityScore	Inspection Lot Score
	InspLotUsageDecisionCatalog	InspLotUsageDecisionCatalog
	SelectedCodeSetPlant	SelectedCodeSetPlant
	InspLotUsgeDcsnSelectedSet	InspLotUsgeDcsnSelectedSet
	InspLotUsageDecisionCodeGroup	InspLotUsageDecisionCodeGroup
	InspectionLotUsageDecisionCode	InspectionLotUsageDecisionCode
	InspLotUsgeDcsnDynValuation	InspLotUsgeDcsnDynValuation
	InspLotUsageDecisionValuation	InspLotUsageDecisionValuation
	InspLotUsgeDcsnFollowUpAction	InspLotUsgeDcsnFollowUpAction
	InspectionLotUsageDecidedBy	InspectionLotUsageDecidedBy
	InspectionLotUsageDecidedOn	InspectionLotUsageDecidedOn
	InspLotUsageDecisionTime	InspLotUsageDecisionTime
	InspLotUsageDecisionChangedBy	InspLotUsageDecisionChangedBy
	InspLotUsageDecisionChangedOn	InspLotUsageDecisionChangedOn
	InspLotUsgeDcsnChangedTime	InspLotUsgeDcsnChangedTime
	InspLotUsgeDcsnHasLongText	InspLotUsgeDcsnHasLongText

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_InspLotUsageDecisionTP_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 I_InspLotUsageDecisionTP_2 AS
SELECT
  InspectionLot,
  InspectionLotQualityScore,
  InspLotUsageDecisionCatalog,
  SelectedCodeSetPlant,
  InspLotUsgeDcsnSelectedSet,
  InspLotUsageDecisionCodeGroup,
  InspectionLotUsageDecisionCode,
  InspLotUsgeDcsnDynValuation,
  InspLotUsageDecisionValuation,
  InspLotUsgeDcsnFollowUpAction,
  InspectionLotUsageDecidedBy,
  InspectionLotUsageDecidedOn,
  InspLotUsageDecisionTime,
  InspLotUsageDecisionChangedBy,
  InspLotUsageDecisionChangedOn,
  InspLotUsgeDcsnChangedTime,
  InspLotUsgeDcsnHasLongText
FROM R_InspectionLotUsageDecisionTP
;

Depth:

I_InspLotUsageDecisionTP_2 view_entity

R_InspectionLotUsageDecisionTP view_entity