What is P_MfgInspCharcInitialInsert in SAP S/4HANA?

P_MfgInspCharcInitialInsert is a composite CDS view in SAP S/4HANA. IC Recorded Result Initial Insert values It contains 102 fields.

Which tables does P_MfgInspCharcInitialInsert read from?

P_MfgInspCharcInitialInsert reads data from: P_MfgInspCharcSumzdRslt, P_MfgInspCharcSumzdRslt, P_MfgInspCharcSumzdRslt, P_MfgInspCharcSumzdRslt, P_MfgInspCharcSumzdRslt and more.

What VDM layer is P_MfgInspCharcInitialInsert?

P_MfgInspCharcInitialInsert is classified as a Composite view that combines data from multiple basic views.

P_MfgInspCharcInitialInsert

DDL: P_MFGINSPCHARCINITIALINSERT Type: view_entity COMPOSITE

102 Fields 8 Data Sources

IC Recorded Result Initial Insert values

P_MfgInspCharcInitialInsert is a Composite CDS View that provides data about "IC Recorded Result Initial Insert values" in SAP S/4HANA. It reads from 8 data sources and exposes 102 fields with key fields InspectionLot, InspPlanOperationInternalID, InspectionCharacteristic, InspectionSubsetInternalID, InspResultValueInternalID.

Data Sources (8)

Source	Alias	Join Type
P_MfgInspCharcSumzdRslt	InspCharcResultAll	from
P_MfgInspCharcSumzdRslt	InspCharcResultAll	union_all
P_MfgInspCharcSumzdRslt	InspCharcResultAll	union_all
P_MfgInspCharcSumzdRslt	InspCharcResultAll	union_all
P_MfgInspCharcSumzdRslt	InspCharcResultAll	union_all
I_InspectionCharacteristic	InspectionCharacteristic	inner
I_InspectionLot	InspectionLot	union_all
I_InspectionResultValue	InspectionResultValue	inner

Annotations (8)

Name	Value	Level
AccessControl.authorizationCheck	#NOT_REQUIRED	view
EndUserText.label	IC Recorded Result Initial Insert values	view
Metadata.ignorePropagatedAnnotations	true	view
VDM.private	true	view
VDM.viewType	#COMPOSITE	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view

Fields (102)

Key	Field	Source Table	Source Field	Description
KEY	InspectionLot	P_MfgInspCharcSumzdRslt	InspectionLot	Inspection Lot
KEY	InspPlanOperationInternalID	P_MfgInspCharcSumzdRslt	InspPlanOperationInternalID	Node Number
KEY	InspectionCharacteristic	P_MfgInspCharcSumzdRslt	InspectionCharacteristic	Characteristic
KEY	InspectionSubsetInternalID	P_MfgInspCharcSumzdRslt	InspectionSubsetInternalID	Sample Number
KEY	InspResultValueInternalID	P_MfgInspCharcSumzdRslt	InspResultValueInternalID	Indiv. result
	DatabaseTable	P_MfgInspCharcSumzdRslt	DatabaseTable	Table Name
	ChangeDocument	P_MfgInspCharcSumzdRslt	ChangeDocument	Document Number
	ShopFloorItem	P_MfgInspCharcSumzdRslt	ShopFloorItem	Serial.Mat. ID
	ManufacturingOrder	P_MfgInspCharcSumzdRslt	ManufacturingOrder	Order
	CreatedByUser	P_MfgInspCharcSumzdRslt	CreatedByUser	User Name
	CreationDate	P_MfgInspCharcSumzdRslt	CreationDate	Time Stamp
	CreationTime	P_MfgInspCharcSumzdRslt	CreationTime	Time of Change
	ChangeDocDatabaseTableField
	ChangeDocPreviousFieldValue
	ChangeDocItemChangeType
	InspLotHasSubsets	P_MfgInspCharcSumzdRslt	InspLotHasSubsets	Prod. insp.
	InspResultNrOfAddlDcmlsPlaces	P_MfgInspCharcSumzdRslt	InspResultNrOfAddlDcmlsPlaces	Diff. Decimal Places
	InspectionLot			Inspection Lot
KEY	InspPlanOperationInternalID	P_MfgInspCharcSumzdRslt	InspPlanOperationInternalID	Node Number
KEY	InspectionCharacteristic	P_MfgInspCharcSumzdRslt	InspectionCharacteristic	Characteristic
KEY	InspectionSubsetInternalID	P_MfgInspCharcSumzdRslt	InspectionSubsetInternalID	Sample Number
KEY	InspResultValueInternalID	P_MfgInspCharcSumzdRslt	InspResultValueInternalID	Indiv. result
	DatabaseTable	P_MfgInspCharcSumzdRslt	DatabaseTable	Table Name
	ChangeDocument	P_MfgInspCharcSumzdRslt	ChangeDocument	Document Number
	ShopFloorItem	P_MfgInspCharcSumzdRslt	ShopFloorItem	Serial.Mat. ID
	ManufacturingOrder	P_MfgInspCharcSumzdRslt	ManufacturingOrder	Order
	CreatedByUser	P_MfgInspCharcSumzdRslt	CreatedByUser	User Name
	CreationDate	P_MfgInspCharcSumzdRslt	CreationDate	Time Stamp
	CreationTime	P_MfgInspCharcSumzdRslt	CreationTime	Time of Change
	ChangeDocDatabaseTableField
	ChangeDocPreviousFieldValue
	ChangeDocItemChangeType
	InspLotHasSubsets	P_MfgInspCharcSumzdRslt	InspLotHasSubsets	Prod. insp.
	InspResultNrOfAddlDcmlsPlaces	P_MfgInspCharcSumzdRslt	InspResultNrOfAddlDcmlsPlaces	Diff. Decimal Places
	InspectionLot			Inspection Lot
KEY	InspPlanOperationInternalID	P_MfgInspCharcSumzdRslt	InspPlanOperationInternalID	Node Number
KEY	InspectionCharacteristic	P_MfgInspCharcSumzdRslt	InspectionCharacteristic	Characteristic
KEY	InspectionSubsetInternalID	P_MfgInspCharcSumzdRslt	InspectionSubsetInternalID	Sample Number
KEY	InspResultValueInternalID	P_MfgInspCharcSumzdRslt	InspResultValueInternalID	Indiv. result
	DatabaseTable	P_MfgInspCharcSumzdRslt	DatabaseTable	Table Name
	ChangeDocument	P_MfgInspCharcSumzdRslt	ChangeDocument	Document Number
	ShopFloorItem	P_MfgInspCharcSumzdRslt	ShopFloorItem	Serial.Mat. ID
	ManufacturingOrder	P_MfgInspCharcSumzdRslt	ManufacturingOrder	Order
	CreatedByUser	P_MfgInspCharcSumzdRslt	CreatedByUser	User Name
	CreationDate	P_MfgInspCharcSumzdRslt	CreationDate	Time Stamp
	CreationTime	P_MfgInspCharcSumzdRslt	CreationTime	Time of Change
	ChangeDocDatabaseTableField
	ChangeDocPreviousFieldValue
	ChangeDocItemChangeType
	InspLotHasSubsets	P_MfgInspCharcSumzdRslt	InspLotHasSubsets	Prod. insp.
	InspResultNrOfAddlDcmlsPlaces	P_MfgInspCharcSumzdRslt	InspResultNrOfAddlDcmlsPlaces	Diff. Decimal Places
	InspectionLot			Inspection Lot
KEY	InspPlanOperationInternalID	P_MfgInspCharcSumzdRslt	InspPlanOperationInternalID	Node Number
KEY	InspectionCharacteristic	P_MfgInspCharcSumzdRslt	InspectionCharacteristic	Characteristic
KEY	InspectionSubsetInternalID	P_MfgInspCharcSumzdRslt	InspectionSubsetInternalID	Sample Number
KEY	InspResultValueInternalID	P_MfgInspCharcSumzdRslt	InspResultValueInternalID	Indiv. result
	DatabaseTable	P_MfgInspCharcSumzdRslt	DatabaseTable	Table Name
	ChangeDocument	P_MfgInspCharcSumzdRslt	ChangeDocument	Document Number
	ShopFloorItem	P_MfgInspCharcSumzdRslt	ShopFloorItem	Serial.Mat. ID
	ManufacturingOrder	P_MfgInspCharcSumzdRslt	ManufacturingOrder	Order
	CreatedByUser	P_MfgInspCharcSumzdRslt	CreatedByUser	User Name
	CreationDate	P_MfgInspCharcSumzdRslt	CreationDate	Time Stamp
	CreationTime	P_MfgInspCharcSumzdRslt	CreationTime	Time of Change
	ChangeDocDatabaseTableField
	ChangeDocPreviousFieldValue
	ChangeDocItemChangeType
	InspLotHasSubsets	P_MfgInspCharcSumzdRslt	InspLotHasSubsets	Prod. insp.
	InspResultNrOfAddlDcmlsPlaces	P_MfgInspCharcSumzdRslt	InspResultNrOfAddlDcmlsPlaces	Diff. Decimal Places
	InspectionLot			Inspection Lot
KEY	InspPlanOperationInternalID	P_MfgInspCharcSumzdRslt	InspPlanOperationInternalID	Node Number
KEY	InspectionCharacteristic	P_MfgInspCharcSumzdRslt	InspectionCharacteristic	Characteristic
KEY	InspectionSubsetInternalID	P_MfgInspCharcSumzdRslt	InspectionSubsetInternalID	Sample Number
KEY	InspResultValueInternalID	P_MfgInspCharcSumzdRslt	InspResultValueInternalID	Indiv. result
	DatabaseTable	P_MfgInspCharcSumzdRslt	DatabaseTable	Table Name
	ChangeDocument	P_MfgInspCharcSumzdRslt	ChangeDocument	Document Number
	ShopFloorItem	P_MfgInspCharcSumzdRslt	ShopFloorItem	Serial.Mat. ID
	ManufacturingOrder	P_MfgInspCharcSumzdRslt	ManufacturingOrder	Order
	CreatedByUser	P_MfgInspCharcSumzdRslt	CreatedByUser	User Name
	CreationDate	P_MfgInspCharcSumzdRslt	CreationDate	Time Stamp
	CreationTime	P_MfgInspCharcSumzdRslt	CreationTime	Time of Change
	ChangeDocDatabaseTableField
	ChangeDocPreviousFieldValue
	ChangeDocItemChangeType
	InspLotHasSubsets	P_MfgInspCharcSumzdRslt	InspLotHasSubsets	Prod. insp.
	InspResultNrOfAddlDcmlsPlaces	P_MfgInspCharcSumzdRslt	InspResultNrOfAddlDcmlsPlaces	Diff. Decimal Places
	InspectionLot			Inspection Lot
KEY	InspPlanOperationInternalID	I_InspectionResultValue	InspPlanOperationInternalID	Node Number
KEY	InspectionCharacteristic	I_InspectionResultValue	InspectionCharacteristic	Characteristic
KEY	InspectionSubsetInternalID	I_InspectionResultValue	InspectionSubsetInternalID	Sample Number
KEY	InspResultValueInternalID	I_InspectionResultValue	InspResultValueInternalID	Indiv. result
	DatabaseTable			Table Name
	ChangeDocument			Document Number
	ShopFloorItem	InspectionSubset	ShopFloorItem	Serial.Mat. ID
	ManufacturingOrder	I_InspectionLot	ManufacturingOrder	Order
	CreatedByUser	I_InspectionResultValue	CreatedByUser	User Name
	CreationDate	I_InspectionResultValue	CreationDate	Time Stamp
	CreationTime	I_InspectionResultValue	CreationTime	Time of Change
	ChangeDocPreviousFieldValue
	ChangeDocItemChangeType
	InspLotHasSubsets	I_InspectionLot	InspLotHasSubsets	Prod. insp.
	InspResultNrOfAddlDcmlsPlaces	I_InspectionResultValue	InspResultNrOfAddlDcmlsPlaces	Diff. Decimal Places
	DatabaseTableFieldName

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 P_MfgInspCharcInitialInsert.
-- 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 P_MfgInspCharcInitialInsert AS
SELECT
  InspCharcResultAll.InspectionLot AS InspectionLot,
  InspCharcResultAll.InspPlanOperationInternalID AS InspPlanOperationInternalID,
  InspCharcResultAll.InspectionCharacteristic AS InspectionCharacteristic,
  InspCharcResultAll.InspectionSubsetInternalID AS InspectionSubsetInternalID,
  InspCharcResultAll.InspResultValueInternalID AS InspResultValueInternalID,
  InspCharcResultAll.DatabaseTable AS DatabaseTable,
  InspCharcResultAll.ChangeDocument AS ChangeDocument,
  InspCharcResultAll.ShopFloorItem AS ShopFloorItem,
  InspCharcResultAll.ManufacturingOrder AS ManufacturingOrder,
  InspCharcResultAll.CreatedByUser AS CreatedByUser,
  InspCharcResultAll.CreationDate AS CreationDate,
  InspCharcResultAll.CreationTime AS CreationTime,
  cast( 'MITTELWERT' as fieldname ) AS ChangeDocDatabaseTableField,
  cast('' as cdfldvalo) AS ChangeDocPreviousFieldValue,
  'I' AS ChangeDocItemChangeType,
  InspCharcResultAll.InspLotHasSubsets AS InspLotHasSubsets,
  InspCharcResultAll.InspResultNrOfAddlDcmlsPlaces AS InspResultNrOfAddlDcmlsPlaces,
  '' AS DatabaseTableFieldName
FROM P_MfgInspCharcSumzdRslt AS InspCharcResultAll
INNER JOIN I_InspectionCharacteristic AS InspectionCharacteristic ON /* join condition not captured in parsed metadata */
INNER JOIN I_InspectionResultValue AS InspectionResultValue ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): P_MfgInspCharcSumzdRslt, I_InspectionLot
;

Depth:

P_MfgInspCharcInitialInsert view_entity

P_MfgInspCharHistoryAll view_entity