I_FinDtaConstcyIssDetBusProc

DDL: I_FINDTACONSTCYISSDETBUSPROC Type: view_entity BASIC
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).

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 (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label FinDtaCy Issues Detail With BusProc view
Metadata.ignorePropagatedAnnotations 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
IssueCorrectionStatus I_FinDtaConstcyIssueDetail IssueCorrectionStatus
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[Language = $session.system_language].FinDtaConstcyIssCritltyName AS FinDtaConstcyIssCritltyName,
  issue.IssueCorrectionStatus AS IssueCorrectionStatus,
  _CrrtnStsText[Language = $session.system_language].FinDtaConstcyIssCrrtnStsName AS FinDtaConstcyIssCrrtnStsName,
  cast ( case issue.IssueCorrectionStatus when 'C' then 3 when 'X' then 2 else 1 end as abap.int2 ) as StatusCriticality AS int2asStatusCriticality,
  coalesce(_BusinessProcess.ImpactedBusinessProcess, 'OTH') 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