C_OpActyInstceInspCharcSqnc

DDL: C_OPACTYINSTCEINSPCHARCSQNC Type: view_entity CONSUMPTION
9 Fields 3 Data Sources

IC sequence based on Op Activity

C_OpActyInstceInspCharcSqnc is a Consumption CDS View that provides data about "IC sequence based on Op Activity" in SAP S/4HANA. It reads from 3 data sources (I_InspectionCharacteristic, I_LogisticsOrderBasic, I_OpActyInstceNtwkElmntBasic) and exposes 9 fields with key fields OpActyNtwkInstance, OpActyNtwkElement, InspectionCharacteristic, ShopFloorItem.

Data Sources (3)

SourceAliasJoin Type
I_InspectionCharacteristic InspectionCharacteristic inner
I_LogisticsOrderBasic LogisticsOrderBasic inner
I_OpActyInstceNtwkElmntBasic OpActyInstceNtwkElmntBasic from

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label IC sequence based on Op Activity view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
ObjectModel.updateEnabled true view
ObjectModel.createEnabled true view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY OpActyNtwkInstance I_OpActyInstceNtwkElmntBasic OpActyNtwkInstance Instance ID
KEY OpActyNtwkElement I_OpActyInstceNtwkElmntBasic OpActyNtwkElement Element Number
KEY InspectionCharacteristic I_InspectionCharacteristic InspectionCharacteristic Characteristic
KEY ShopFloorItem
BOOCharcGroup I_InspectionCharacteristic BOOCharcGroup Characteristic Group
InspCharcIsNotPlanned I_InspectionCharacteristic InspCharcIsNotPlanned
OpActyCharacteristicItem OpActyBOOCharcAssgmt OpActyCharacteristicItem Sort No.
OpActyCharcDivnSqnc OpActyBOOCharcAssgmt OpActyCharcDivnSqnc Division Seq No.
OpActyCharcGrpSqnc OpActyBOOCharcAssgmt OpActyCharcGrpSqnc Group Column No.

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_OpActyInstceInspCharcSqnc.
-- 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 C_OpActyInstceInspCharcSqnc AS
SELECT
  OpActyInstceNtwkElmntBasic.OpActyNtwkInstance AS OpActyNtwkInstance,
  OpActyInstceNtwkElmntBasic.OpActyNtwkElement AS OpActyNtwkElement,
  InspectionCharacteristic.InspectionCharacteristic AS InspectionCharacteristic,
  coalesce(InspectionSubset.ShopFloorItem, 0) AS ShopFloorItem,
  InspectionCharacteristic.BOOCharcGroup AS BOOCharcGroup,
  InspectionCharacteristic.InspCharcIsNotPlanned AS InspCharcIsNotPlanned,
  OpActyBOOCharcAssgmt.OpActyCharacteristicItem AS OpActyCharacteristicItem,
  OpActyBOOCharcAssgmt.OpActyCharcDivnSqnc AS OpActyCharcDivnSqnc,
  OpActyBOOCharcAssgmt.OpActyCharcGrpSqnc AS OpActyCharcGrpSqnc
FROM I_OpActyInstceNtwkElmntBasic AS OpActyInstceNtwkElmntBasic
INNER JOIN I_LogisticsOrderBasic AS LogisticsOrderBasic ON /* join condition not captured in parsed metadata */
INNER JOIN I_InspectionCharacteristic AS InspectionCharacteristic ON /* join condition not captured in parsed metadata */
;

Learn More