I_MDIKeyMappingOverviewBP

DDL: I_MDIKEYMAPPINGOVERVIEWBP SQL: IMDIKEYMAPOVWBP Type: view
13 Fields 1 Data Sources

Business Partner Key Mapping Overview

I_MDIKeyMappingOverviewBP is a CDS View that provides data about "Business Partner Key Mapping Overview" in SAP S/4HANA. It reads from 1 data source (I_MDIKeyMappingBaseBP) and exposes 13 fields with key fields keyId, ObjectGroupMergeId.

Data Sources (1)

SourceAliasJoin Type
I_MDIKeyMappingBaseBP _t1 from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName IMDIKEYMAPOVWBP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Business Partner Key Mapping Overview view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY keyId I_MDIKeyMappingBaseBP KeyId Tax Invoice Key
KEY ObjectGroupMergeId I_MDIKeyMappingBaseBP ObjectGroupMergeId Transaction ID
ObjectId I_MDIKeyMappingBaseBP ObjectId Object Value
ObjectTypeCode I_MDIKeyMappingBaseBP ObjectTypeCode Object Type
ObjectTypeCodeText I_MDIKeyMappingBaseBP ObjectTypeCodeText
ObjectIdentifierType I_MDIKeyMappingBaseBP ObjectIdentifierType Scheme ID
ObjectIdentifierTypeText I_MDIKeyMappingBaseBP ObjectIdentifierTypeText
Destination I_MDIKeyMappingBaseBP Destination RFC Destination
BusinessSystem I_MDIKeyMappingBaseBP BusinessSystem SchemeAgencyID
MappingGroupId I_MDIKeyMappingBaseBP MappingGroupId UUID
ObjectInstanceKey
IsLocalBusinessSystem
Counter

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_MDIKeyMappingOverviewBP.
-- 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: IMDIKEYMAPOVWBP

CREATE VIEW I_MDIKeyMappingOverviewBP AS
SELECT
  _t1.KeyId AS keyId,
  _t1.ObjectGroupMergeId AS ObjectGroupMergeId,
  _t1.ObjectId AS ObjectId,
  _t1.ObjectTypeCode AS ObjectTypeCode,
  _t1.ObjectTypeCodeText AS ObjectTypeCodeText,
  _t1.ObjectIdentifierType AS ObjectIdentifierType,
  _t1.ObjectIdentifierTypeText AS ObjectIdentifierTypeText,
  _t1.Destination AS Destination,
  _t1.BusinessSystem AS BusinessSystem,
  _t1.MappingGroupId AS MappingGroupId,
  cast('' as mdo_objectinstancekey) AS ObjectInstanceKey,
  cast (' ' as boole_d) AS IsLocalBusinessSystem,
  cast (0 as mdo_counter) AS Counter
FROM I_MDIKeyMappingBaseBP AS _t1
;

Learn More