FIN_SUBSTNVALDTN_FICA_PSM

DDL: FIN_SUBSTNVALDTN_FICA_PSM SQL: FSUBVALDFICA Type: view
13 Fields 1 Data Sources

FIN Substitution Validation Context Structure for PSM FICA

FIN_SUBSTNVALDTN_FICA_PSM is a CDS View that provides data about "FIN Substitution Validation Context Structure for PSM FICA" in SAP S/4HANA. It reads from 1 data source (finsubvalficapsm) and exposes 13 fields with key field CompanyCode.

Data Sources (1)

SourceAliasJoin Type
finsubvalficapsm li from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName FSUBVALDFICA view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.buffering.status #NOT_ALLOWED view
EndUserText.label FIN Substitution Validation Context Structure for PSM FICA view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode finsubvalficapsm bukrs Value
FinancialManagementArea finsubvalficapsm fikrs FM Area
PostingDate finsubvalficapsm budat Posting Date
GLAccount finsubvalficapsm hkont Transfer acct
ControllingArea finsubvalficapsm kokrs Org. Value
CostCenter finsubvalficapsm kostl Substitute CC
ProfitCenter finsubvalficapsm prctr Profit Centers
Fund finsubvalficapsm geber Fund
FunctionalArea finsubvalficapsm fkber Functional Area
GrantID finsubvalficapsm grant_nbr Receiver Grant
BudgetConsumptionType finsubvalficapsm bdgt_cnsmpn_type Budget Consumption Type
REAccount finsubvalficapsm re_account Ex/Rv A/c in CL
Segment finsubvalficapsm segment Segment number

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 FIN_SUBSTNVALDTN_FICA_PSM.
-- 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: FSUBVALDFICA

CREATE VIEW FIN_SUBSTNVALDTN_FICA_PSM AS
SELECT
  li.bukrs AS CompanyCode,
  li.fikrs AS FinancialManagementArea,
  li.budat AS PostingDate,
  li.hkont AS GLAccount,
  li.kokrs AS ControllingArea,
  li.kostl AS CostCenter,
  li.prctr AS ProfitCenter,
  li.geber AS Fund,
  li.fkber AS FunctionalArea,
  li.grant_nbr AS GrantID,
  li.bdgt_cnsmpn_type AS BudgetConsumptionType,
  li.re_account AS REAccount,
  li.segment AS Segment
FROM finsubvalficapsm AS li
;

Learn More