I_BPDataControllerUsage

DDL: I_BPDATACONTROLLERUSAGE SQL: IBPDATACTRUSG Type: view BASIC

BP Data Controller Usage

I_BPDataControllerUsage is a Basic CDS View that provides data about "BP Data Controller Usage" in SAP S/4HANA. It reads from 1 data source (but_dc_link) and exposes 8 fields with key fields BusinessPartner, DataControllerName, BPDataPurposeText.

Data Sources (1)

SourceAliasJoin Type
but_dc_link but_dc_link from

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IBPDATACTRUSG view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label BP Data Controller Usage view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #BASIC view
ObjectModel.representativeKey BusinessPartner view
Metadata.allowExtensions true view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner partner
KEY DataControllerName data_ctrlr
KEY BPDataPurposeText purpose
DataControlAssignmentStatus asgmt_status
BPDataControllerIsDerived data_ctrlr_derived
PurposeDerived pur_derived
PurposeType purpose_type
BusinessPurposeFlag eop_flag
@AbapCatalog.sqlViewName: 'IBPDATACTRUSG'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck:#PRIVILEGED_ONLY
@EndUserText.label: 'BP Data Controller Usage'
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MASTER
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #REQUIRED

@VDM.viewType: #BASIC
@ObjectModel.representativeKey: 'BusinessPartner'
@Metadata.allowExtensions:true

define view I_BPDataControllerUsage
  as select from but_dc_link
{
      //@ObjectModel.foreignKey.association: 'BusinessPartner'

  key partner            as BusinessPartner,
  key data_ctrlr         as DataControllerName,
  key purpose            as BPDataPurposeText,
      @Semantics.booleanIndicator: true
      asgmt_status       as DataControlAssignmentStatus,
      @Semantics.booleanIndicator: true
      data_ctrlr_derived as BPDataControllerIsDerived,
      pur_derived        as PurposeDerived,
      purpose_type       as PurposeType,
      eop_flag           as BusinessPurposeFlag

}
where
  asgmt_status <> 'I'