I_BizConfignCheckDetail

DDL: I_BIZCONFIGNCHECKDETAIL Type: view_entity TRANSACTIONAL Package: BUCC_UI
12 Fields 1 Data Sources 5 Associations

Business Configuration Check Execution Detail

I_BizConfignCheckDetail is a Transactional CDS View that provides data about "Business Configuration Check Execution Detail" in SAP S/4HANA. It reads from 1 data source (I_BusinessConfigurationCheck) and exposes 12 fields with key field BizConfignCheckID. It has 5 associations to related views. Part of development package BUCC_UI.

Data Sources (1)

SourceAliasJoin Type
I_BusinessConfigurationCheck I_BusinessConfigurationCheck from

Associations (5)

CardinalityTargetAliasCondition
[0..1] I_BizConfignCheckStatus _CheckExceStatus $projection.BizConfignCheckID = _CheckExceStatus.BizConfignCheckID
[0..1] C_BizConfignChkRsEnty _CheckEntity $projection.BizConfignCheckID = _CheckEntity.BizConfignCheckID
[0..1] I_BusinessConfigurationCheckT _CheckText $projection.BizConfignCheckID = _CheckText.BizConfignCheckID
[0..1] I_BizConfignCheckStatusVH _CheckStatus _CheckStatus.BizConfignCheckStatus = 'NS'
[0..1] I_BizConfignCheckExecStsVH _ExecStatus _ExecStatus.BizConfignCheckExecSts = 'NS'

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Business Configuration Check Execution Detail view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #TRANSACTIONAL view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY BizConfignCheckID BizConfignCheckID Check ID
BizConfignChkDocnNavgnPgm BizConfignChkDocnNavgnPgm
BizConfignChkDocnNavgnText BizConfignChkDocnNavgnText TRUE
BizConfignCheckName _CheckText BizConfignCheckName
BizConfignCheckExecSts _CheckExceStatus BizConfignCheckExecSts
BizConfignCheckExecStsText
BizConfignCheckStatus _CheckExceStatus BizConfignCheckStatus
BizConfignCheckStatusText
BizConfignChkExecDteTme _CheckExceStatus BizConfignChkExecDteTme
BizConfignChkExecChgDteTme _CheckExceStatus BizConfignChkExecChgDteTme
BizConfignCheckExecJobSts _CheckExceStatus BizConfignCheckExecJobSts
_CheckText _CheckText

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_BizConfignCheckDetail.
-- 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_BizConfignCheckDetail AS
SELECT
  BizConfignCheckID,
  BizConfignChkDocnNavgnPgm,
  BizConfignChkDocnNavgnText,
  _CheckText.BizConfignCheckName AS BizConfignCheckName,
  _CheckExceStatus.BizConfignCheckExecSts AS BizConfignCheckExecSts,
  coalesce(_CheckExceStatus._ExecStatus.BizConfignCheckExecStsText, _ExecStatus.BizConfignCheckExecStsText) AS BizConfignCheckExecStsText,
  _CheckExceStatus.BizConfignCheckStatus AS BizConfignCheckStatus,
  coalesce(_CheckExceStatus._CheckStatus.BizConfignCheckStatusText, _CheckStatus.BizConfignCheckStatusText) AS BizConfignCheckStatusText,
  _CheckExceStatus.BizConfignChkExecDteTme AS BizConfignChkExecDteTme,
  _CheckExceStatus.BizConfignChkExecChgDteTme AS BizConfignChkExecChgDteTme,
  _CheckExceStatus.BizConfignCheckExecJobSts AS BizConfignCheckExecJobSts
FROM I_BusinessConfigurationCheck
LEFT OUTER JOIN I_BizConfignCheckStatus AS _CheckExceStatus ON BizConfignCheckID = _CheckExceStatus.BizConfignCheckID  -- association [0..1]
LEFT OUTER JOIN C_BizConfignChkRsEnty AS _CheckEntity ON BizConfignCheckID = _CheckEntity.BizConfignCheckID  -- association [0..1]
LEFT OUTER JOIN I_BusinessConfigurationCheckT AS _CheckText ON BizConfignCheckID = _CheckText.BizConfignCheckID  -- association [0..1]
LEFT OUTER JOIN I_BizConfignCheckStatusVH AS _CheckStatus ON _CheckStatus.BizConfignCheckStatus = 'NS'  -- association [0..1]
LEFT OUTER JOIN I_BizConfignCheckExecStsVH AS _ExecStatus ON _ExecStatus.BizConfignCheckExecSts = 'NS'  -- association [0..1]
;

Learn More