cs4sic_hana_rules_framework_ci

DDL: CS4SIC_HANA_RULES_FRAMEWORK_CI SQL: CS4SICHRFCSTCI Type: view

Customer Analytic Functions (clnt indep)

cs4sic_hana_rules_framework_ci is a CDS View that provides data about "Customer Analytic Functions (clnt indep)" in SAP S/4HANA. It reads from 8 data sources and exposes 7 fields with key fields ApplicationId, FunctionId, FunctionId.

Data Sources (8)

SourceAliasJoin Type
fdt_fnct_0100s AnalyticFunctions from
fdt_fnct_0100t AnalyticFunctions union_all
fdt_admn_0000s ApplicationAdministrativeData inner
fdt_admn_0000t ApplicationAdministrativeData inner
fdt_appl_0000s Applications inner
fdt_appl_0000t Applications inner
fdt_admn_0000s FunctionAdministrativeData inner
fdt_admn_0000t FunctionAdministrativeData inner

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName CS4SICHRFCSTCI view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #AUTOMATED view
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label Customer Analytic Functions (clnt indep) view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY ApplicationId fdt_admn_0000t application_id Universal Unique ID
KEY FunctionId fdt_fnct_0100t id WorklistID
ApplicationName fdt_admn_0000t name Zone name
application_idasApplicationId
KEY FunctionId fdt_fnct_0100t id WorklistID
ApplicationName fdt_admn_0000t name Zone name
FunctionName fdt_admn_0000t name Zone name

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 cs4sic_hana_rules_framework_ci.
-- 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: CS4SICHRFCSTCI

CREATE VIEW cs4sic_hana_rules_framework_ci AS
SELECT
  FunctionAdministrativeData.application_id AS ApplicationId,
  AnalyticFunctions.id AS FunctionId,
  ApplicationAdministrativeData.name AS ApplicationName,
  FunctionAdministrativeData.name as FunctionName AS application_idasApplicationId,
  FunctionAdministrativeData.name AS FunctionName
FROM fdt_fnct_0100s AS AnalyticFunctions
INNER JOIN fdt_admn_0000s AS FunctionAdministrativeData ON /* join condition not captured in parsed metadata */
INNER JOIN fdt_admn_0000s AS ApplicationAdministrativeData ON /* join condition not captured in parsed metadata */
INNER JOIN fdt_appl_0000s AS Applications ON /* join condition not captured in parsed metadata */
INNER JOIN fdt_admn_0000t AS FunctionAdministrativeData ON /* join condition not captured in parsed metadata */
INNER JOIN fdt_admn_0000t AS ApplicationAdministrativeData ON /* join condition not captured in parsed metadata */
INNER JOIN fdt_appl_0000t AS Applications ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): fdt_fnct_0100t
;