cs4sic_hana_rules_framework_cd

DDL: CS4SIC_HANA_RULES_FRAMEWORK_CD SQL: CS4SICHRFCSTCD Type: view Package: SFDT_HRF

Customer Analytic Functions (clnt dep)

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

Data Sources (8)

SourceAliasJoin Type
fdt_fnct_0100 AnalyticFunctions from
fdt_fnct_0100a AnalyticFunctions union_all
fdt_admn_0000 ApplicationAdministrativeData inner
fdt_admn_0000a ApplicationAdministrativeData inner
fdt_appl_0000 Applications inner
fdt_appl_0000a Applications inner
fdt_admn_0000 FunctionAdministrativeData inner
fdt_admn_0000a FunctionAdministrativeData inner

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName CS4SICHRFCSTCD view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #AUTOMATED view
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label Customer Analytic Functions (clnt dep) 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_0000a application_id Universal Unique ID
KEY FunctionId fdt_fnct_0100a id WorklistID
ApplicationName fdt_admn_0000a name Zone name
application_idasApplicationId
KEY FunctionId fdt_fnct_0100a id WorklistID
ApplicationName fdt_admn_0000a name Zone name
FunctionName fdt_admn_0000a 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_cd.
-- 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: CS4SICHRFCSTCD

CREATE VIEW cs4sic_hana_rules_framework_cd 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_0100 AS AnalyticFunctions
INNER JOIN fdt_admn_0000 AS FunctionAdministrativeData ON /* join condition not captured in parsed metadata */
INNER JOIN fdt_admn_0000 AS ApplicationAdministrativeData ON /* join condition not captured in parsed metadata */
INNER JOIN fdt_appl_0000 AS Applications ON /* join condition not captured in parsed metadata */
INNER JOIN fdt_admn_0000a AS FunctionAdministrativeData ON /* join condition not captured in parsed metadata */
INNER JOIN fdt_admn_0000a AS ApplicationAdministrativeData ON /* join condition not captured in parsed metadata */
INNER JOIN fdt_appl_0000a AS Applications ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): fdt_fnct_0100a
;