I_InspCharcsKeyFigCube

DDL: I_INSPCHARCSKEYFIGCUBE Type: view COMPOSITE
43 Fields 1 Data Sources 5 Associations

Characteristics Analytics - Key Figures

I_InspCharcsKeyFigCube is a Composite CDS View (Cube) that provides data about "Characteristics Analytics - Key Figures" in SAP S/4HANA. It reads from 1 data source (I_InspSubsetCharacteristic) and exposes 43 fields with key fields InspectionLot, InspPlanOperationInternalID, InspectionCharacteristic, InspectionSubsetInternalID. It has 5 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_InspSubsetCharacteristic _InspSubsetCharcs from

Parameters (2)

NameTypeDefault
P_StartDate mm_a_delivery_date
P_EndDate mm_a_delivery_date

Associations (5)

CardinalityTargetAliasCondition
[1..1] I_InspectionLot _ILot $projection.InspectionLot = _ILot.InspectionLot
[1..1] I_InspectionOperation _IOperation $projection.InspectionLot = _IOperation.InspectionLot and $projection.InspPlanOperationInternalID = _IOperation.InspPlanOperationInternalID
[1..1] I_InspectionCharacteristic _ICharacteristic $projection.InspectionLot = _ICharacteristic.InspectionLot and $projection.InspPlanOperationInternalID = _ICharacteristic.InspPlanOperationInternalID and $projection.InspectionCharacteristic = _ICharacteristic.InspectionCharacteristic
[0..1] I_InspSubsetResult _ISubsetResult $projection.InspectionLot = _ISubsetResult.InspectionLot and $projection.InspPlanOperationInternalID = _ISubsetResult.InspPlanOperationInternalID and $projection.InspectionSubsetInternalID = _ISubsetResult.InspectionSubsetInternalID and $projection.InspectionCharacteristic = _ISubsetResult.InspectionCharacteristic
[0..1] I_InspSpecificationVersion _InspSpecificationVersion $projection.inspectionspecificationplant = _InspSpecificationVersion.InspectionSpecificationPlant and $projection.inspectionspecification = _InspSpecificationVersion.InspectionSpecification and $projection.inspectionspecificationversion = _InspSpecificationVersion.InspectionSpecificationVersion

Annotations (15)

NameValueLevelField
AbapCatalog.buffering.status #NOT_ALLOWED view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName IINSPCHARKEYFIG view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
Analytics.dataCategory #CUBE view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Characteristics Analytics - Key Figures view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
Metadata.allowExtensions true view

Fields (43)

KeyFieldSource TableSource FieldDescription
KEY InspectionLot I_InspSubsetCharacteristic InspectionLot Inspection Lot
KEY InspPlanOperationInternalID I_InspSubsetCharacteristic InspPlanOperationInternalID Node Number
KEY InspectionCharacteristic I_InspSubsetCharacteristic InspectionCharacteristic Characteristic
KEY InspectionSubsetInternalID I_InspSubsetCharacteristic InspectionSubsetInternalID Sample Number
InspectionLotOrigin _ILot InspectionLotOrigin
WorkCenterInternalID _IOperation WorkCenterInternalID Work Center
InspectionOperation _IOperation InspectionOperation
InspResultHistoryCharc
BillOfOperationsType _ILot BillOfOperationsType Task List Type
BillOfOperationsGroup _ILot BillOfOperationsGroup Group
BillOfOperationsVariant _ILot BillOfOperationsVariant Group Counter
BOOOperationInternalID _IOperation BOOOperationInternalID Task list node
InspectionSpecificationPlant _ICharacteristic InspectionSpecificationPlant
InspectionSpecificationVersion _ICharacteristic InspectionSpecificationVersion
MasterInspCharcsKey
InspectionSpecification _ICharacteristic InspectionSpecification Master IC
InspectionSpecificationText _ICharacteristic InspectionSpecificationText
Plant _ILot Plant Valuation Area
Material _ILot Material Vehicle Model
Supplier _ILot Supplier Supplier
Customer _ILot Customer Sold-to Party
WorkCenter
InspectionOperationPlant _IOperation InspectionOperationPlant
WorkCenterPlantName
NumberOfInspections
int4endasNmbrOfVltdInspections
int4endasNumberOfAcceptedInspCharcs
int4endasNumberOfRejectedInspCharcs
int4endasNumberOfSkipInspCharcs
int4endasNumberOfNotSkipInspCharcs
int4endasInspSkipRatePercent
int4endasInspRsltRjcnRatePercent
int4endasInspRsltNonconformingValsNmbr
int4endasInspResultValidValuesNumber
InspectionLotType _ILot InspectionLotType Inspection Type
InspectionSubsetType _ILot InspectionSubsetType
MatlQualityAuthorizationGroup _ILot MatlQualityAuthorizationGroup QM Matl Auth.
IsBusinessPurposeCompleted _ILot IsBusinessPurposeCompleted Purpose Completed
_Plant _ILot _Plant
_Supplier _ILot _Supplier
_Customer _ILot _Customer
_WorkCenter _IOperation _WorkCenter
_InspSpecificationVersion _InspSpecificationVersion

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_InspCharcsKeyFigCube.
-- 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.
-- Parameters: P_StartDate : mm_a_delivery_date, P_EndDate : mm_a_delivery_date

CREATE VIEW I_InspCharcsKeyFigCube AS
SELECT
  _InspSubsetCharcs.InspectionLot AS InspectionLot,
  _InspSubsetCharcs.InspPlanOperationInternalID AS InspPlanOperationInternalID,
  _InspSubsetCharcs.InspectionCharacteristic AS InspectionCharacteristic,
  _InspSubsetCharcs.InspectionSubsetInternalID AS InspectionSubsetInternalID,
  _ILot.InspectionLotOrigin AS InspectionLotOrigin,
  _IOperation.WorkCenterInternalID AS WorkCenterInternalID,
  _IOperation.InspectionOperation AS InspectionOperation,
  concat(concat(concat(concat(concat( concat ( concat (concat( _ILot.BillOfOperationsType, '-'), ltrim( _ILot.BillOfOperationsGroup , '0') ), '-'), _ILot.BillOfOperationsVariant), '-'), _IOperation.InspectionOperation), '-'), _InspSubsetCharcs.InspectionCharacteristic) AS InspResultHistoryCharc,
  _ILot.BillOfOperationsType AS BillOfOperationsType,
  _ILot.BillOfOperationsGroup AS BillOfOperationsGroup,
  _ILot.BillOfOperationsVariant AS BillOfOperationsVariant,
  _IOperation.BOOOperationInternalID AS BOOOperationInternalID,
  _ICharacteristic.InspectionSpecificationPlant AS InspectionSpecificationPlant,
  _ICharacteristic.InspectionSpecificationVersion AS InspectionSpecificationVersion,
  concat( concat ( concat (concat( _ICharacteristic.InspectionSpecification, '-'), _ICharacteristic.InspectionSpecificationPlant), '-'), ltrim(_ICharacteristic.InspectionSpecificationVersion, '0') ) AS MasterInspCharcsKey,
  _ICharacteristic.InspectionSpecification AS InspectionSpecification,
  _ICharacteristic.InspectionSpecificationText AS InspectionSpecificationText,
  _ILot.Plant AS Plant,
  _ILot.Material AS Material,
  _ILot.Supplier AS Supplier,
  _ILot.Customer AS Customer,
  _IOperation._WorkCenter.WorkCenter AS WorkCenter,
  _IOperation.InspectionOperationPlant AS InspectionOperationPlant,
  _IOperation._Plant.PlantName AS WorkCenterPlantName,
  cast( 1 as abap.int4 ) AS NumberOfInspections,
  case when (_ILot.InspLotHasSubsets = 'X' and (_ISubsetResult.InspectionResultStatus <> '4' and _InspSubsetCharcs.InspectionCharacteristicStatus <> '4' ) and ( _ISubsetResult.InspectionValuationResult = 'A' or _ISubsetResult.InspectionValuationResult = 'R' ) ) or (_ILot.InspLotHasSubsets <> 'X' and (_ICharacteristic._InspectionResult.InspectionResultStatus <> '4' or _ICharacteristic.InspectionCharacteristicStatus <> '4' ) and ( _ICharacteristic._InspectionResult.InspectionValuationResult = 'A' or _ICharacteristic._InspectionResult.InspectionValuationResult = 'R' ) ) then cast( 1 as abap.int4 ) else cast( 0 as abap.int4 ) end as NmbrOfVltdInspections AS int4endasNmbrOfVltdInspections,
  case when (_ILot.InspLotHasSubsets = 'X' and _ISubsetResult.InspectionValuationResult = 'A' and (_ISubsetResult.InspectionResultStatus <> '4' and _InspSubsetCharcs.InspectionCharacteristicStatus <> '4' )) or (_ILot.InspLotHasSubsets <> 'X' and _ICharacteristic._InspectionResult.InspectionValuationResult = 'A' and (_ICharacteristic._InspectionResult.InspectionResultStatus <> '4' and _ICharacteristic.InspectionCharacteristicStatus <> '4' )) then cast( 1 as abap.int4 ) else cast( 0 as abap.int4 ) end as NumberOfAcceptedInspCharcs AS int4endasNumberOfAcceptedInspCharcs,
  case when (_ILot.InspLotHasSubsets = 'X' and _ISubsetResult.InspectionValuationResult = 'R' and (_ISubsetResult.InspectionResultStatus <> '4' and _InspSubsetCharcs.InspectionCharacteristicStatus <> '4' )) or (_ILot.InspLotHasSubsets <> 'X' and _ICharacteristic._InspectionResult.InspectionValuationResult = 'R' and (_ICharacteristic._InspectionResult.InspectionResultStatus <> '4' and _ICharacteristic.InspectionCharacteristicStatus <> '4' )) then cast( 1 as abap.int4 ) else cast( 0 as abap.int4 ) end as NumberOfRejectedInspCharcs AS int4endasNumberOfRejectedInspCharcs,
  case when (_ILot.InspLotHasSubsets = 'X' and (_InspSubsetCharcs.InspectionCharacteristicStatus = '4' or _ISubsetResult.InspectionResultStatus = '4' )) or (_ILot.InspLotHasSubsets <> 'X' and (_ICharacteristic.InspectionCharacteristicStatus = '4'or _ICharacteristic._InspectionResult.InspectionResultStatus = '4' ) ) then cast( 1 as abap.int4 ) else cast( 0 as abap.int4 ) end as NumberOfSkipInspCharcs AS int4endasNumberOfSkipInspCharcs,
  case when (_ILot.InspLotHasSubsets = 'X' and _ISubsetResult.InspectionResultStatus = '5' and _InspSubsetCharcs.InspectionCharacteristicStatus <> '4' ) or (_ILot.InspLotHasSubsets <> 'X' and _ICharacteristic._InspectionResult.InspectionResultStatus = '5' and _ICharacteristic.InspectionCharacteristicStatus <> '4') then cast( 1 as abap.int4 ) else cast( 0 as abap.int4 ) end as NumberOfNotSkipInspCharcs AS int4endasNumberOfNotSkipInspCharcs,
  case when (_ILot.InspLotHasSubsets = 'X' and (_InspSubsetCharcs.InspectionCharacteristicStatus = '4' or _ISubsetResult.InspectionResultStatus = '4' )) or (_ILot.InspLotHasSubsets <> 'X' and (_ICharacteristic.InspectionCharacteristicStatus = '4'or _ICharacteristic._InspectionResult.InspectionResultStatus = '4' ) ) then cast( 100 as abap.int4 ) else cast( 0 as abap.int4 ) end as InspSkipRatePercent AS int4endasInspSkipRatePercent,
  case when (_ILot.InspLotHasSubsets = 'X' and (_ISubsetResult.InspectionResultStatus <> '4' or _InspSubsetCharcs.InspectionCharacteristicStatus <> '4' ) and ( _ISubsetResult.InspectionValuationResult = 'R' ) ) or (_ILot.InspLotHasSubsets <> 'X' and (_ICharacteristic._InspectionResult.InspectionResultStatus <> '4' or _ICharacteristic.InspectionCharacteristicStatus <> '4' ) and ( _ICharacteristic._InspectionResult.InspectionValuationResult = 'R' ) ) then cast( 100 as abap.int4 ) else cast( 0 as abap.int4 ) end as InspRsltRjcnRatePercent AS int4endasInspRsltRjcnRatePercent,
  case when (_ILot.InspLotHasSubsets = 'X' and (_InspSubsetCharcs.InspectionCharacteristicStatus <> '4' and _ISubsetResult.InspectionResultStatus <> '4' )) then _ISubsetResult.InspRsltNonconformingValsNmbr when (_ILot.InspLotHasSubsets <> 'X' and (_ICharacteristic.InspectionCharacteristicStatus <> '4' and _ICharacteristic._InspectionResult.InspectionResultStatus <> '4' ) ) then _ICharacteristic._InspectionResult.InspRsltNonconformingValsNmbr else cast( 0 as abap.int4 ) end as InspRsltNonconformingValsNmbr AS int4endasInspRsltNonconformingValsNmbr,
  case when (_ILot.InspLotHasSubsets = 'X' and (_InspSubsetCharcs.InspectionCharacteristicStatus <> '4' and _ISubsetResult.InspectionResultStatus <> '4' )) then _ISubsetResult.InspResultValidValuesNumber when (_ILot.InspLotHasSubsets <> 'X' and (_ICharacteristic.InspectionCharacteristicStatus <> '4'and _ICharacteristic._InspectionResult.InspectionResultStatus <> '4' ) ) then _ICharacteristic._InspectionResult.InspResultValidValuesNumber else cast( 0 as abap.int4 ) end as InspResultValidValuesNumber AS int4endasInspResultValidValuesNumber,
  _ILot.InspectionLotType AS InspectionLotType,
  _ILot.InspectionSubsetType AS InspectionSubsetType,
  _ILot.MatlQualityAuthorizationGroup AS MatlQualityAuthorizationGroup,
  _ILot.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  _ILot._Plant AS _Plant,
  _ILot._Supplier AS _Supplier,
  _ILot._Customer AS _Customer,
  _IOperation._WorkCenter AS _WorkCenter
FROM I_InspSubsetCharacteristic AS _InspSubsetCharcs
LEFT OUTER JOIN I_InspectionLot AS _ILot ON InspectionLot = _ILot.InspectionLot  -- association [1..1]
LEFT OUTER JOIN I_InspectionOperation AS _IOperation ON InspectionLot = _IOperation.InspectionLot AND InspPlanOperationInternalID = _IOperation.InspPlanOperationInternalID  -- association [1..1]
LEFT OUTER JOIN I_InspectionCharacteristic AS _ICharacteristic ON InspectionLot = _ICharacteristic.InspectionLot AND InspPlanOperationInternalID = _ICharacteristic.InspPlanOperationInternalID AND InspectionCharacteristic = _ICharacteristic.InspectionCharacteristic  -- association [1..1]
LEFT OUTER JOIN I_InspSubsetResult AS _ISubsetResult ON InspectionLot = _ISubsetResult.InspectionLot AND InspPlanOperationInternalID = _ISubsetResult.InspPlanOperationInternalID AND InspectionSubsetInternalID = _ISubsetResult.InspectionSubsetInternalID AND InspectionCharacteristic = _ISubsetResult.InspectionCharacteristic  -- association [0..1]
LEFT OUTER JOIN I_InspSpecificationVersion AS _InspSpecificationVersion ON inspectionspecificationplant = _InspSpecificationVersion.InspectionSpecificationPlant AND inspectionspecification = _InspSpecificationVersion.InspectionSpecification AND inspectionspecificationversion = _InspSpecificationVersion.InspectionSpecificationVersion  -- association [0..1]
;

Learn More