I_MDGovBPRoleTypeFltr

DDL: I_MDGOVBPROLETYPEFLTR SQL: IMDGOVBPRLTPFLTR Type: view BASIC

MDG BP Role Type Filter

I_MDGovBPRoleTypeFltr is a Basic CDS View that provides data about "MDG BP Role Type Filter" in SAP S/4HANA. It reads from 1 data source (but100) and exposes 3 fields with key fields BusinessPartner, BusinessPartnerRole, BusinessPartnerDiffTypeValue.

Data Sources (1)

SourceAliasJoin Type
but100 _but100 from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IMDGOVBPRLTPFLTR view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
VDM.viewType #BASIC view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
EndUserText.label MDG BP Role Type Filter view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner but100 partner With Partner
KEY BusinessPartnerRole but100 rltyp Return type
KEY BusinessPartnerDiffTypeValue but100 dfval Diff.type value

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_MDGovBPRoleTypeFltr.
-- 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: IMDGOVBPRLTPFLTR

CREATE VIEW I_MDGovBPRoleTypeFltr AS
SELECT
  _but100.partner AS BusinessPartner,
  _but100.rltyp AS BusinessPartnerRole,
  _but100.dfval AS BusinessPartnerDiffTypeValue
FROM but100 AS _but100
;