sycm_aps_c_procedure

DDL: SYCM_APS_C_PROCEDURE SQL: SYCMVCPROC Type: view Package: SYCM_APS
6 Fields 3 Data Sources 1 OData Services 1 Fiori Apps

Procedures

sycm_aps_c_procedure is a CDS View that provides data about "Procedures" in SAP S/4HANA. It reads from 3 data sources (sycma_halstead, sycm_aps_i_procedure_type_text, sycma_tadir_d) and exposes 6 fields with key fields project_id, obj_name, object, proc_type, proc_name. It is exposed through 1 OData service (SYCM_APS_SCOPING). It is used in 1 Fiori application: Custom Code Migration. Part of development package SYCM_APS.

Data Sources (3)

SourceAliasJoin Type
sycma_halstead halstead from
sycm_aps_i_procedure_type_text procedure_type_text left_outer
sycma_tadir_d tadir inner

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName SYCMVCPROC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Procedures view
Metadata.allowExtensions true view
Search.searchable true view

OData Services (1)

ServiceBindingVersionContractRelease
SYCM_APS_SCOPING SYCM_APS_SCOPING V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F3191 Custom Code Migration Transactional The Custom Code Migration app enables you to create three different kinds of projects: 1. SAP S/4HANA Migration Project: Analyze custom code that shall be migrated from an existing product like SAP Business Suite to a new product such as SAP S/4HANA 2021. To evaluate the custom objects to be adapted, it performs the SAP S/4HANA custom code checks. 2. SAP BTP Analysis Project: Analyze custom code for readiness to run in SAP BTP, ABAP environment. 3. Custom Code Analysis Project: Analyze custom code with arbitrary ATC check variants. In addition, this app supports you with identifying unused custom code based on your collected usage data. This enables you to remove unused custom code during a system conversion to SAP S/4HANA.

Custom Code Migration

Business Role: Quality Manager - Software Development

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY project_id sycma_halstead project_id Project UUID
KEY obj_name sycma_halstead obj_name Object Name
KEY object sycma_halstead object TRFM Object
KEY proc_type sycma_halstead proc_type Transaction Type
KEY proc_name sycma_halstead proc_name Proc. Name
devclass sycma_tadir_d devclass Package (Obsolete)

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 sycm_aps_c_procedure.
-- 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: SYCMVCPROC

CREATE VIEW sycm_aps_c_procedure AS
SELECT
  halstead.project_id AS project_id,
  halstead.obj_name AS obj_name,
  halstead.object AS object,
  halstead.proc_type AS proc_type,
  halstead.proc_name AS proc_name,
  tadir.devclass AS devclass
FROM sycma_halstead AS halstead
INNER JOIN sycma_tadir_d AS tadir ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN sycm_aps_i_procedure_type_text AS procedure_type_text ON /* join condition not captured in parsed metadata */
;

Learn More