I_USFedObjectClass

DDL: I_USFEDOBJECTCLASS SQL: IFMFG_OBJ_CL Type: view BASIC

US Federal Object Class

I_USFedObjectClass (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Cross Applications

I_USFedObjectClass is a Basic CDS View (Dimension) that provides data about "US Federal Object Class" in SAP S/4HANA. It reads from 1 data source (fmci) and exposes 7 fields with key fields FinancialManagementArea, FinMgmtAreaFiscalYear, USFedObjectClass. It has 3 associations to related views.

SAP API Hub

StateC1
Line of BusinessCross Applications
Application ComponentPSM-FG
CapabilitiesAnalytical Dimension
PackageCross Applications for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
fmci fmci from

Associations (3)

CardinalityTargetAliasCondition
[0..*] I_USFedObjectClassText _Text $projection.FinancialManagementArea = _Text.FinancialManagementArea and $projection.USFedObjectClass = _Text.USFedObjectClass and $projection.FinMgmtAreaFiscalYear = _Text.FinMgmtAreaFiscalYear
[1..1] I_FinancialManagementArea _FinancialManagementArea $projection.FinancialManagementArea = _FinancialManagementArea.FinancialManagementArea
[0..1] I_FiscalYearForFinMgmtArea _FiscalYearForFinMgmtArea $projection.FinancialManagementArea = _FiscalYearForFinMgmtArea.FinancialManagementArea and $projection.FinMgmtAreaFiscalYear = _FiscalYearForFinMgmtArea.FinMgmtAreaFiscalYear

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName IFMFG_OBJ_CL view
EndUserText.label US Federal Object Class view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #BASIC view
Analytics.dataCategory #DIMENSION view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
ObjectModel.supportedCapabilities #ANALYTICAL_DIMENSION view
ObjectModel.representativeKey USFedObjectClass view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY FinancialManagementArea fikrs Financial Management Area
KEY FinMgmtAreaFiscalYear Fiscal Year for Financial Management Area
KEY USFedObjectClass Object Class for US Federal
_Text _Text
_FinancialManagementArea _FinancialManagementArea
_FiscalYearForFinMgmtArea _FiscalYearForFinMgmtArea
CommitmentItemAuthznGrp augrp Authorization Group for Commitment Item

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 I_USFedObjectClass.
-- 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: IFMFG_OBJ_CL

CREATE VIEW I_USFedObjectClass AS
SELECT
  fikrs AS FinancialManagementArea,
  cast( gjahr as fmis_fma_fiscal_year preserving type ) AS FinMgmtAreaFiscalYear,
  cast(fipex as fmfg_obj_cl preserving type) AS USFedObjectClass,
  augrp AS CommitmentItemAuthznGrp
FROM fmci
LEFT OUTER JOIN I_USFedObjectClassText AS _Text ON FinancialManagementArea = _Text.FinancialManagementArea AND USFedObjectClass = _Text.USFedObjectClass AND FinMgmtAreaFiscalYear = _Text.FinMgmtAreaFiscalYear  -- association [0..*]
LEFT OUTER JOIN I_FinancialManagementArea AS _FinancialManagementArea ON FinancialManagementArea = _FinancialManagementArea.FinancialManagementArea  -- association [1..1]
LEFT OUTER JOIN I_FiscalYearForFinMgmtArea AS _FiscalYearForFinMgmtArea ON FinancialManagementArea = _FiscalYearForFinMgmtArea.FinancialManagementArea AND FinMgmtAreaFiscalYear = _FiscalYearForFinMgmtArea.FinMgmtAreaFiscalYear  -- association [0..1]
;