/CFG/FTI_SERVICE
Services in NDM
/CFG/FTI_SERVICE is a CDS View that provides data about "Services in NDM" in SAP S/4HANA. It reads from 3 data sources (/fti/ft_config, /fti/ft_ui, /fti/ft_scope) and exposes 16 fields with key field ui_id. Part of development package /CFG/FTI_FIORI.
Data Sources (3)
| Source | Alias | Join Type |
|---|---|---|
| /fti/ft_config | config | left_outer |
| /fti/ft_ui | ft_ui | left_outer |
| /fti/ft_scope | scope | left_outer |
Annotations (6)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | /CFG/V_FTI_SRV | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| ObjectModel.usageType.serviceQuality | C | view | |
| ObjectModel.usageType.sizeCategory | L | view | |
| ObjectModel.usageType.dataClass | MIXED | view | |
| EndUserText.label | Services in NDM | view |
Fields (16)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | ui_id | /fti/ft_ui | id | WorklistID |
| kw_link | /fti/ft_ui | kw_link | Knowl Warehouse link | |
| country_dep | /fti/ft_ui | country_dep | Cntry/Rgn Dependency | |
| external_id | /fti/ft_ui | external_id | WEBGUI External ID | |
| entity | /fti/ft_ui | entity | Supply Chain Unit | |
| availability | /fti/ft_ui | availability | Pkg. Release Status | |
| mandatory | /fti/ft_ui | mandatory | Yes/No | |
| default_seq | /fti/ft_scope | default_seq | Sequential Number | |
| ongoing | /fti/ft_config | ongoing | Run | |
| evaluation | /fti/ft_config | evaluation | Valid evaluatn | |
| preparation | /fti/ft_config | reparation | Prepare | |
| realized | /fti/ft_config | realized | Realize | |
| launch | /fti/ft_config | launch | Deploy | |
| company_rel | /fti/ft_config | company_rel | Company | |
| plant_rel | /fti/ft_config | plant_rel | Plant Rel. | |
| sal_org | /fti/ft_config | sal_org | S.Org Rel. |
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 /CFG/FTI_SERVICE.
-- 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: /CFG/V_FTI_SRV
CREATE VIEW /CFG/FTI_SERVICE AS
SELECT
ft_ui.id AS ui_id,
ft_ui.kw_link AS kw_link,
ft_ui.country_dep AS country_dep,
ft_ui.external_id AS external_id,
ft_ui.entity AS entity,
ft_ui.availability AS availability,
ft_ui.mandatory AS mandatory,
scope.default_seq AS default_seq,
config.ongoing AS ongoing,
config.evaluation AS evaluation,
config.reparation AS preparation,
config.realized AS realized,
config.launch AS launch,
config.company_rel AS company_rel,
config.plant_rel AS plant_rel,
config.sal_org AS sal_org
LEFT OUTER JOIN /fti/ft_ui AS ft_ui ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN /fti/ft_config AS config ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN /fti/ft_scope AS scope ON /* join condition not captured in parsed metadata */
;
Learn More
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA