P_MfgInspCharcResultAll

DDL: P_MFGINSPCHARCRESULTALL Type: view_entity COMPOSITE
45 Fields 2 Data Sources

Insp Charcs Recording Results

P_MfgInspCharcResultAll is a Composite CDS View that provides data about "Insp Charcs Recording Results" in SAP S/4HANA. It reads from 2 data sources (I_InspectionResultValue, P_MfgInspCharcSumzdRslt) and exposes 45 fields with key fields InspectionLot, InspPlanOperationInternalID, InspectionCharacteristic, InspectionSubsetInternalID, InspResultValueInternalID.

Data Sources (2)

SourceAliasJoin Type
I_InspectionResultValue InspectionResultValue inner
P_MfgInspCharcSumzdRslt MfgInspCharcSumzdRslt from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Insp Charcs Recording Results view
Metadata.ignorePropagatedAnnotations true view
VDM.private true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (45)

KeyFieldSource TableSource FieldDescription
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
InspectionResultMeanValue P_MfgInspCharcSumzdRslt InspectionResultMeanValue
InspectionResultMeasuredValue P_MfgInspCharcSumzdRslt InspectionResultMeasuredValue Measured Value
CharacteristicAttributeCodeGrp P_MfgInspCharcSumzdRslt CharacteristicAttributeCodeGrp Code Group
CharacteristicAttributeCode P_MfgInspCharcSumzdRslt CharacteristicAttributeCode Code
InspectionValuationResult P_MfgInspCharcSumzdRslt InspectionValuationResult Valuation
InspectionResultText P_MfgInspCharcSumzdRslt InspectionResultText
InspResultNrOfAddlDcmlsPlaces P_MfgInspCharcSumzdRslt InspResultNrOfAddlDcmlsPlaces Diff. Decimal Places
InspLotHasSubsets P_MfgInspCharcSumzdRslt InspLotHasSubsets
InspectionResultHasMeanValue P_MfgInspCharcSumzdRslt InspectionResultHasMeanValue
InspResultHasMeasuredValue P_MfgInspCharcSumzdRslt InspResultHasMeasuredValue
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 InspectionLot ManufacturingOrder Order
CreatedByUser I_InspectionResultValue CreatedByUser User Name
CreationDate I_InspectionResultValue CreationDate Time Stamp
CreationTime I_InspectionResultValue CreationTime Time of Change
InspectionResultMeanValue
InspectionResultMeasuredValue Measured Value
CharacteristicAttributeCodeGrp I_InspectionResultValue CharacteristicAttributeCodeGrp Code Group
CharacteristicAttributeCode I_InspectionResultValue CharacteristicAttributeCode Code
InspectionValuationResult I_InspectionResultValue InspectionValuationResult Valuation
InspectionResultText
InspResultNrOfAddlDcmlsPlaces I_InspectionResultValue InspResultNrOfAddlDcmlsPlaces Diff. Decimal Places
InspLotHasSubsets InspectionLot InspLotHasSubsets
InspectionResultHasMeanValue
InspResultHasMeasuredValue I_InspectionResultValue InspResultHasMeasuredValue
InspRsltFreeDefinedTestEquip

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_MfgInspCharcResultAll.
-- 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_MfgInspCharcResultAll AS
SELECT
  MfgInspCharcSumzdRslt.InspectionLot AS InspectionLot,
  MfgInspCharcSumzdRslt.InspPlanOperationInternalID AS InspPlanOperationInternalID,
  MfgInspCharcSumzdRslt.InspectionCharacteristic AS InspectionCharacteristic,
  MfgInspCharcSumzdRslt.InspectionSubsetInternalID AS InspectionSubsetInternalID,
  MfgInspCharcSumzdRslt.InspResultValueInternalID AS InspResultValueInternalID,
  MfgInspCharcSumzdRslt.DatabaseTable AS DatabaseTable,
  MfgInspCharcSumzdRslt.ChangeDocument AS ChangeDocument,
  MfgInspCharcSumzdRslt.ShopFloorItem AS ShopFloorItem,
  MfgInspCharcSumzdRslt.ManufacturingOrder AS ManufacturingOrder,
  MfgInspCharcSumzdRslt.CreatedByUser AS CreatedByUser,
  MfgInspCharcSumzdRslt.CreationDate AS CreationDate,
  MfgInspCharcSumzdRslt.CreationTime AS CreationTime,
  MfgInspCharcSumzdRslt.InspectionResultMeanValue AS InspectionResultMeanValue,
  MfgInspCharcSumzdRslt.InspectionResultMeasuredValue AS InspectionResultMeasuredValue,
  MfgInspCharcSumzdRslt.CharacteristicAttributeCodeGrp AS CharacteristicAttributeCodeGrp,
  MfgInspCharcSumzdRslt.CharacteristicAttributeCode AS CharacteristicAttributeCode,
  MfgInspCharcSumzdRslt.InspectionValuationResult AS InspectionValuationResult,
  MfgInspCharcSumzdRslt.InspectionResultText AS InspectionResultText,
  MfgInspCharcSumzdRslt.InspResultNrOfAddlDcmlsPlaces AS InspResultNrOfAddlDcmlsPlaces,
  MfgInspCharcSumzdRslt.InspLotHasSubsets AS InspLotHasSubsets,
  MfgInspCharcSumzdRslt.InspectionResultHasMeanValue AS InspectionResultHasMeanValue,
  MfgInspCharcSumzdRslt.InspResultHasMeasuredValue AS InspResultHasMeasuredValue,
  '' AS InspRsltFreeDefinedTestEquip
FROM P_MfgInspCharcSumzdRslt AS MfgInspCharcSumzdRslt
INNER JOIN I_InspectionResultValue AS InspectionResultValue ON /* join condition not captured in parsed metadata */
;

Learn More