Sycm_Piece_List

DDL: SYCM_PIECE_LIST SQL: SYCMVPLIST Type: view
6 Fields 1 Data Sources

Custom Code Management: Piece list

Sycm_Piece_List is a CDS View that provides data about "Custom Code Management: Piece list" in SAP S/4HANA. It reads from 1 data source (sycm_piecelist) and exposes 6 fields with key fields id, pgmid, object_type, object_name.

Data Sources (1)

SourceAliasJoin Type
sycm_piecelist sycm_piecelist from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName SYCMVPLIST view
ClientDependent false view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Custom Code Management: Piece list view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY id sycm_piecelist piecelist_id GUID 16
KEY pgmid sycm_piecelist pgmid Program Name
KEY object_type sycm_piecelist object_type Type
KEY object_name sycm_piecelist object_name Technical Name
package_name sycm_piecelist package_name Package Name
ps_posid sycm_piecelist ps_posid WBS Element

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_Piece_List.
-- 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: SYCMVPLIST

CREATE VIEW Sycm_Piece_List AS
SELECT
  sycm_piecelist.piecelist_id AS id,
  sycm_piecelist.pgmid AS pgmid,
  sycm_piecelist.object_type AS object_type,
  sycm_piecelist.object_name AS object_name,
  sycm_piecelist.package_name AS package_name,
  sycm_piecelist.ps_posid AS ps_posid
FROM sycm_piecelist
;

Learn More