P_OpActyNumberOfInspCharcs

DDL: P_OPACTYNUMBEROFINSPCHARCS SQL: POPACTYNMBROFPIC Type: view COMPOSITE
6 Fields 1 Data Sources

P_OpActyNumberOfInspCharcs is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_OpActyBOOCharcAssgmt) and exposes 6 fields with key fields OperationActivity, OperationActyVersionCounter, BillOfOperationsType, BillOfOperationsGroup, BOOOperationInternalID.

Data Sources (1)

SourceAliasJoin Type
I_OpActyBOOCharcAssgmt OpActyBOOCharcAssgmt from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName POPACTYNMBROFPIC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_ALLOWED view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #B view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (6)

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 BOOOperationInternalID I_OpActyBOOCharcAssgmt BOOOperationInternalID Task list node
NumberOfInspCharcs

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_OpActyNumberOfInspCharcs.
-- 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: POPACTYNMBROFPIC

CREATE VIEW P_OpActyNumberOfInspCharcs AS
SELECT
  OpActyBOOCharcAssgmt.OperationActivity AS OperationActivity,
  OpActyBOOCharcAssgmt.OperationActyVersionCounter AS OperationActyVersionCounter,
  OpActyBOOCharcAssgmt.BillOfOperationsType AS BillOfOperationsType,
  OpActyBOOCharcAssgmt.BillOfOperationsGroup AS BillOfOperationsGroup,
  OpActyBOOCharcAssgmt.BOOOperationInternalID AS BOOOperationInternalID,
  count( * ) AS NumberOfInspCharcs
FROM I_OpActyBOOCharcAssgmt AS OpActyBOOCharcAssgmt
;

Learn More