I_FinDtaConstcyIssDetBusProc

DDL: I_FINDTACONSTCYISSDETBUSPROC Type: view_entity BASIC Package: ODATA_FDCA_INSIGHT_OVERVIEW
16 Fields 1 Data Sources 3 Associations 1 OData Services

FinDtaCy Issues Detail With BusProc

I_FinDtaConstcyIssDetBusProc is a Basic CDS View that provides data about "FinDtaCy Issues Detail With BusProc" in SAP S/4HANA. It reads from 1 data source (I_FinDtaConstcyIssueDetail) and exposes 16 fields with key fields ConsistencyAnalysisRun, CompanyCode, AccountingDocument, JournalEntryFiscalYear, AccountingDocumentItem. It has 3 associations to related views. It is exposed through 1 OData service (FINDTACONSTCYRESULT). Part of development package ODATA_FDCA_INSIGHT_OVERVIEW.

Data Sources (1)

SourceAliasJoin Type
I_FinDtaConstcyIssueDetail issue from

Associations (3)

CardinalityTargetAliasCondition
[0..*] I_LedgerText _LedgerText issue.Ledger = _LedgerText.Ledger
[1..1] I_FinDtaConstcyIssCritltyText _Criticalitytext $projection.FinDtaConstcyIssueCriticality = _Criticalitytext.FinDtaConstcyIssueCriticality
[1..1] I_FinDtaConstcyIssCrrtnStsText _CrrtnStsText $projection.IssueCorrectionStatus = _CrrtnStsText.IssueCorrectionStatus

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label FinDtaCy Issues Detail With BusProc view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #BASIC view

OData Services (1)

ServiceBindingVersionContractRelease
FINDTACONSTCYRESULT FINDTACONSTCYRESULT V4 C1 NOT_RELEASED

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY ConsistencyAnalysisRun I_FinDtaConstcyIssueDetail ConsistencyAnalysisRun
KEY CompanyCode I_FinDtaConstcyIssueDetail CompanyCode Receiver Company Code
KEY AccountingDocument I_FinDtaConstcyIssueDetail AccountingDocument Journal Entry
KEY JournalEntryFiscalYear I_FinDtaConstcyIssueDetail JournalEntryFiscalYear Settlement Year
KEY AccountingDocumentItem I_FinDtaConstcyIssueDetail AccountingDocumentItem Posting View Item
KEY Ledger I_FinDtaConstcyIssueDetail Ledger Ledger
KEY ErrorMessageNumber
LedgerName
ErrorMessageText I_FinDtaConstcyIssueDetail ErrorMessageText
Criticality Criticality Number
FinDtaConstcyIssueCriticality I_FinDtaConstcyIssueDetail FinDtaConstcyIssueCriticality
FinDtaConstcyIssCritltyName _Criticalitytext FinDtaConstcyIssCritltyName
IssueCorrectionStatus I_FinDtaConstcyIssueDetail IssueCorrectionStatus
FinDtaConstcyIssCrrtnStsName _CrrtnStsText FinDtaConstcyIssCrrtnStsName
int2asStatusCriticality
ImpactedBusinessProcess

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_FinDtaConstcyIssDetBusProc.
-- 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_FinDtaConstcyIssDetBusProc AS
SELECT
  issue.ConsistencyAnalysisRun AS ConsistencyAnalysisRun,
  issue.CompanyCode AS CompanyCode,
  issue.AccountingDocument AS AccountingDocument,
  issue.JournalEntryFiscalYear AS JournalEntryFiscalYear,
  issue.AccountingDocumentItem AS AccountingDocumentItem,
  issue.Ledger AS Ledger,
  cast ( issue.ErrorMessageNumber as abap.char(3) ) AS ErrorMessageNumber,
  _LedgerText[Language = $session.system_language].LedgerName AS LedgerName,
  issue.ErrorMessageText AS ErrorMessageText,
  cast(issue.FinDtaConstcyIssueCriticality as abap.int2) AS Criticality,
  issue.FinDtaConstcyIssueCriticality AS FinDtaConstcyIssueCriticality,
  _Criticalitytext.FinDtaConstcyIssCritltyName AS FinDtaConstcyIssCritltyName,
  issue.IssueCorrectionStatus AS IssueCorrectionStatus,
  _CrrtnStsText.FinDtaConstcyIssCrrtnStsName AS FinDtaConstcyIssCrrtnStsName,
  cast ( case issue.IssueCorrectionStatus when ' ' then 1 when 'X' then 2 else 3 end as abap.int2 ) as StatusCriticality AS int2asStatusCriticality,
  coalesce(bp.business_process_id, 'Other') AS ImpactedBusinessProcess
FROM I_FinDtaConstcyIssueDetail AS issue
LEFT OUTER JOIN I_LedgerText AS _LedgerText ON issue.Ledger = _LedgerText.Ledger  -- association [0..*]
LEFT OUTER JOIN I_FinDtaConstcyIssCritltyText AS _Criticalitytext ON FinDtaConstcyIssueCriticality = _Criticalitytext.FinDtaConstcyIssueCriticality  -- association [1..1]
LEFT OUTER JOIN I_FinDtaConstcyIssCrrtnStsText AS _CrrtnStsText ON IssueCorrectionStatus = _CrrtnStsText.IssueCorrectionStatus  -- association [1..1]
;

Learn More