C_MfgOrdPlndInspCharcInfoList

DDL: C_MFGORDPLNDINSPCHARCINFOLIST SQL: CMPEICLIST Type: view CONSUMPTION
21 Fields 2 Data Sources

Inspection Charcs assigned to OA

C_MfgOrdPlndInspCharcInfoList is a Consumption CDS View that provides data about "Inspection Charcs assigned to OA" in SAP S/4HANA. It reads from 2 data sources (I_BOOCharacteristicVersion, I_OpActyBOOCharcAssgmt) and exposes 21 fields with key fields OperationActivity, OperationActyVersionCounter, BillOfOperationsType, BillOfOperationsGroup, BillOfOperationsVersion.

Data Sources (2)

SourceAliasJoin Type
I_BOOCharacteristicVersion BOOCharcVers inner
I_OpActyBOOCharcAssgmt OpActyBOOCharcAssgmt from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName CMPEICLIST view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
EndUserText.label Inspection Charcs assigned to OA view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY OperationActivity I_OpActyBOOCharcAssgmt OperationActivity Operation Activity
KEY OperationActyVersionCounter I_OpActyBOOCharcAssgmt OperationActyVersionCounter OA Version
KEY BillOfOperationsType I_OpActyBOOCharcAssgmt BillOfOperationsType Task List Type
KEY BillOfOperationsGroup I_OpActyBOOCharcAssgmt BillOfOperationsGroup Group
KEY BillOfOperationsVersion I_BOOCharacteristicVersion BillOfOperationsVersion Routing Version
KEY BOOOperationInternalID I_OpActyBOOCharcAssgmt BOOOperationInternalID Task list node
KEY InspectionCharacteristic I_OpActyBOOCharcAssgmt BOOCharacteristic Characteristic
OpActyCharacteristicItem I_OpActyBOOCharcAssgmt OpActyCharacteristicItem Sort No.
OpActyCharcGrpSqnc I_OpActyBOOCharcAssgmt OpActyCharcGrpSqnc Group Column No.
OpActyCharcDivnSqnc I_OpActyBOOCharcAssgmt OpActyCharcDivnSqnc Division Seq No.
InspectionSpecification I_BOOCharacteristicVersion InspectionSpecification Master IC
InspectionSpecificationText I_BOOCharacteristicVersion InspectionSpecificationText SText insp.char
InspSpecLowerLimit I_BOOCharacteristicVersion InspSpecLowerLimit Lower Limit
InspSpecUpperLimit I_BOOCharacteristicVersion InspSpecUpperLimit Upper Limit
InspSpecTargetValue I_BOOCharacteristicVersion InspSpecTargetValue Target Value
InspectionSpecificationUnit I_BOOCharacteristicVersion InspectionSpecificationUnit Unit of Meas.
InspCharacteristicSampleUnit I_BOOCharacteristicVersion InspCharacteristicSampleUnit Sample Unit
InspSpecSampleQuantityFactor I_BOOCharacteristicVersion BOOCharcSampleQuantity Base smpl. qty
InspCharcGrpDesc InspCharcGrpDesc InspCharcGrpDesc Characteristic Group
InspCharcGrpDivnDesc InspCharcGrpDivnDesc InspCharcGrpDivnDesc Division Desc.
SelectedCodeSetText CharAttribSelectedCodeSetText SelectedCodeSetText

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 C_MfgOrdPlndInspCharcInfoList.
-- 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.
-- SQL view name: CMPEICLIST

CREATE VIEW C_MfgOrdPlndInspCharcInfoList AS
SELECT
  OpActyBOOCharcAssgmt.OperationActivity AS OperationActivity,
  OpActyBOOCharcAssgmt.OperationActyVersionCounter AS OperationActyVersionCounter,
  OpActyBOOCharcAssgmt.BillOfOperationsType AS BillOfOperationsType,
  OpActyBOOCharcAssgmt.BillOfOperationsGroup AS BillOfOperationsGroup,
  BOOCharcVers.BillOfOperationsVersion AS BillOfOperationsVersion,
  OpActyBOOCharcAssgmt.BOOOperationInternalID AS BOOOperationInternalID,
  OpActyBOOCharcAssgmt.BOOCharacteristic AS InspectionCharacteristic,
  OpActyBOOCharcAssgmt.OpActyCharacteristicItem AS OpActyCharacteristicItem,
  OpActyBOOCharcAssgmt.OpActyCharcGrpSqnc AS OpActyCharcGrpSqnc,
  OpActyBOOCharcAssgmt.OpActyCharcDivnSqnc AS OpActyCharcDivnSqnc,
  BOOCharcVers.InspectionSpecification AS InspectionSpecification,
  BOOCharcVers.InspectionSpecificationText AS InspectionSpecificationText,
  BOOCharcVers.InspSpecLowerLimit AS InspSpecLowerLimit,
  BOOCharcVers.InspSpecUpperLimit AS InspSpecUpperLimit,
  BOOCharcVers.InspSpecTargetValue AS InspSpecTargetValue,
  BOOCharcVers.InspectionSpecificationUnit AS InspectionSpecificationUnit,
  BOOCharcVers.InspCharacteristicSampleUnit AS InspCharacteristicSampleUnit,
  BOOCharcVers.BOOCharcSampleQuantity AS InspSpecSampleQuantityFactor,
  InspCharcGrpDesc.InspCharcGrpDesc AS InspCharcGrpDesc,
  InspCharcGrpDivnDesc.InspCharcGrpDivnDesc AS InspCharcGrpDivnDesc,
  CharAttribSelectedCodeSetText.SelectedCodeSetText AS SelectedCodeSetText
FROM I_OpActyBOOCharcAssgmt AS OpActyBOOCharcAssgmt
INNER JOIN I_BOOCharacteristicVersion AS BOOCharcVers ON /* join condition not captured in parsed metadata */
;

Learn More