I_FinDtaConstcyIssueDetail

DDL: I_FINDTACONSTCYISSUEDETAIL Type: view_entity BASIC
13 Fields 2 Data Sources 1 Associations

Financial Data Consistency Ananlysis Issues

I_FinDtaConstcyIssueDetail is a Basic CDS View that provides data about "Financial Data Consistency Ananlysis Issues" in SAP S/4HANA. It reads from 2 data sources (fdca_gl_issue, I_FinDtaConstcyRunDetail) and exposes 13 fields with key fields LedgerApplication, LedgerSubApplication, DataConsistencyHandlingStep, ConsistencyAnalysisRun, ConstcyAnlysRunExecDate. It has 1 association to related views.

Data Sources (2)

SourceAliasJoin Type
fdca_gl_issue issue from
I_FinDtaConstcyRunDetail run inner

Associations (1)

CardinalityTargetAliasCondition
[1..*] I_FinDtaConstcyErrMsgText _ErrorMessageText issue.msgid = _ErrorMessageText.SystemMessageClass and issue.msgno = _ErrorMessageText.ErrorMessageNumber

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Financial Data Consistency Ananlysis Issues view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #BASIC view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY LedgerApplication I_FinDtaConstcyRunDetail LedgerApplication
KEY LedgerSubApplication I_FinDtaConstcyRunDetail LedgerSubApplication
KEY DataConsistencyHandlingStep I_FinDtaConstcyRunDetail DataConsistencyHandlingStep Step Number
KEY ConsistencyAnalysisRun I_FinDtaConstcyRunDetail ConsistencyAnalysisRun UUID
KEY ConstcyAnlysRunExecDate I_FinDtaConstcyRunDetail ConstcyAnlysRunExecDate
KEY CompanyCode fdca_gl_issue bukrs Value
KEY AccountingDocument fdca_gl_issue belnr SD Document
KEY JournalEntryFiscalYear fdca_gl_issue gjahr Settlement Year
KEY AccountingDocumentItem fdca_gl_issue buzei Posting View Item
KEY Ledger fdca_gl_issue rldnr Ledger (Compat.)
KEY ErrorMessageNumber
KEY SystemMessageClass fdca_gl_issue msgid Message ID
ErrorMessageTextendasErrorMessageText

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_FinDtaConstcyIssueDetail.
-- 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.

CREATE VIEW I_FinDtaConstcyIssueDetail AS
SELECT
  run.LedgerApplication AS LedgerApplication,
  run.LedgerSubApplication AS LedgerSubApplication,
  run.DataConsistencyHandlingStep AS DataConsistencyHandlingStep,
  run.ConsistencyAnalysisRun AS ConsistencyAnalysisRun,
  run.ConstcyAnlysRunExecDate AS ConstcyAnlysRunExecDate,
  issue.bukrs AS CompanyCode,
  issue.belnr AS AccountingDocument,
  issue.gjahr AS JournalEntryFiscalYear,
  issue.buzei AS AccountingDocumentItem,
  issue.rldnr AS Ledger,
  cast( issue.msgno as abap.char(3) ) AS ErrorMessageNumber,
  issue.msgid AS SystemMessageClass,
  case when _ErrorMessageText[1:Language=$session.system_language].ErrorMessageText is null then _ErrorMessageText[1:Language='E'].ErrorMessageText else _ErrorMessageText[1:Language=$session.system_language].ErrorMessageText end as ErrorMessageText AS ErrorMessageTextendasErrorMessageText
FROM fdca_gl_issue AS issue
INNER JOIN I_FinDtaConstcyRunDetail AS run ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_FinDtaConstcyErrMsgText AS _ErrorMessageText ON issue.msgid = _ErrorMessageText.SystemMessageClass AND issue.msgno = _ErrorMessageText.ErrorMessageNumber  -- association [1..*]
;

Learn More