ICA_COMPANY_SEGMENT

DDL: ICA_COMPANY_SEGMENT SQL: ICACOMP_SGMT Type: view
5 Fields 2 Data Sources

ICA_COMPANY_SEGMENT is a CDS View in SAP S/4HANA. It reads from 2 data sources (fagl_segm, fagl_segmt) and exposes 5 fields.

Data Sources (2)

SourceAliasJoin Type
fagl_segm A from
fagl_segmt B left_outer

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName ICACOMP_SGMT view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #M view

Fields (5)

KeyFieldSource TableSource FieldDescription
segment fagl_segm segment Segment number
rcomp C rcomp Trading Partner
unitName
segment_unitName fagl_segmt name Zone name
rcomp_unitName C name1 PA text

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 ICA_COMPANY_SEGMENT.
-- 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: ICACOMP_SGMT

CREATE VIEW ICA_COMPANY_SEGMENT AS
SELECT
  A.segment AS segment,
  C.rcomp AS rcomp,
  concat_with_space(concat_with_space(C.name1, '/', 1), B.name, 1) AS unitName,
  B.name AS segment_unitName,
  C.name1 AS rcomp_unitName
FROM fagl_segm AS A
LEFT OUTER JOIN fagl_segmt AS B ON /* join condition not captured in parsed metadata */
;

Learn More