FINCS_MD_CONSUNIT

DDL: FINCS_MD_CONSUNIT SQL: FINCSMDCONSUNIT Type: view
20 Fields 2 Data Sources

FINCS_MD_CONSUNIT is a CDS View in SAP S/4HANA. It reads from 2 data sources (I_Globalcompany, FINCS_MD_TF16X) and exposes 20 fields with key fields ConsolidationDimension, ConsolidationUnit, ConsolidationVersion, ConsolidationLedger.

Data Sources (2)

SourceAliasJoin Type
I_Globalcompany _rcomp left_outer
FINCS_MD_TF16X FINCS_MD_TF16X from

Parameters (3)

NameTypeDefault
P_FiscalYear fc_ryear
P_FiscalPeriod fc_perid
P_Language spras

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName FINCSMDCONSUNIT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #ORGANIZATIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY ConsolidationDimension _bunit ConsolidationDimension Dimension
KEY ConsolidationUnit _bunit ConsolidationUnit Consolidation Unit
KEY ConsolidationVersion _bunit ConsolidationVersion Version
KEY ConsolidationLedger _bunit ConsolidationLedger Ledger
FiscalYearPeriod _bunit FiscalYearPeriod Period/Year
Language _bunit Language Report Text Language
ConsolidationUnitText _bunit ConsolidationUnitText
ConsolidationUnitMdmText _bunit ConsolidationUnitMdmText
Country _bunit Country Venue: Ctry/Reg
DocumentEntryIsInGroupCurrency _bunit DocumentEntryIsInGroupCurrency
ConsolidationUnitLocalCurrency _bunit ConsolidationUnitLocalCurrency
CnsldtnUnitSndrCrcyForLoclCrcy _bunit CnsldtnUnitSndrCrcyForLoclCrcy
CnsldtnUploadMethod _bunit CnsldtnUploadMethod
CnsldtnDataTransferMethod _bunit CnsldtnDataTransferMethod Univ. Journ. Integr.
CnsldtnReadFrmUnivJrnlEffctvYr _bunit CnsldtnReadFrmUnivJrnlEffctvYr
Company I_Globalcompany Company Owner
CnsldtnCrcyTranslationMethod _bunit CnsldtnCrcyTranslationMethod
CnsldtnUnitSndrCrcyForGrpCrcy _bunit CnsldtnUnitSndrCrcyForGrpCrcy
FiscalYearVariant _bunit FiscalYearVariant FY Variant
TaxRate _bunit TaxRate Tax Rate

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 FINCS_MD_CONSUNIT.
-- 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: FINCSMDCONSUNIT
-- Parameters: P_FiscalYear : fc_ryear, P_FiscalPeriod : fc_perid, P_Language : spras

CREATE VIEW FINCS_MD_CONSUNIT AS
SELECT
  _bunit.ConsolidationDimension AS ConsolidationDimension,
  _bunit.ConsolidationUnit AS ConsolidationUnit,
  _bunit.ConsolidationVersion AS ConsolidationVersion,
  _bunit.ConsolidationLedger AS ConsolidationLedger,
  _bunit.FiscalYearPeriod AS FiscalYearPeriod,
  _bunit.Language AS Language,
  _bunit.ConsolidationUnitText AS ConsolidationUnitText,
  _bunit.ConsolidationUnitMdmText AS ConsolidationUnitMdmText,
  _bunit.Country AS Country,
  _bunit.DocumentEntryIsInGroupCurrency AS DocumentEntryIsInGroupCurrency,
  _bunit.ConsolidationUnitLocalCurrency AS ConsolidationUnitLocalCurrency,
  _bunit.CnsldtnUnitSndrCrcyForLoclCrcy AS CnsldtnUnitSndrCrcyForLoclCrcy,
  _bunit.CnsldtnUploadMethod AS CnsldtnUploadMethod,
  _bunit.CnsldtnDataTransferMethod AS CnsldtnDataTransferMethod,
  _bunit.CnsldtnReadFrmUnivJrnlEffctvYr AS CnsldtnReadFrmUnivJrnlEffctvYr,
  _rcomp.Company AS Company,
  _bunit.CnsldtnCrcyTranslationMethod AS CnsldtnCrcyTranslationMethod,
  _bunit.CnsldtnUnitSndrCrcyForGrpCrcy AS CnsldtnUnitSndrCrcyForGrpCrcy,
  _bunit.FiscalYearVariant AS FiscalYearVariant,
  _bunit.TaxRate AS TaxRate
FROM FINCS_MD_TF16X
LEFT OUTER JOIN I_Globalcompany AS _rcomp ON /* join condition not captured in parsed metadata */
;

Learn More