P_BPNumInExtSystemValueHelp

DDL: P_BPNUMINEXTSYSTEMVALUEHELP SQL: PBPNUMEXTVH Type: view BASIC Package: ODATA_CUSTOMER_LIST

BP Number in External System

P_BPNumInExtSystemValueHelp is a Basic CDS View that provides data about "BP Number in External System" in SAP S/4HANA. It reads from 1 data source (I_BusinessPartner) and exposes 22 fields with key field BusinessPartner. Part of development package ODATA_CUSTOMER_LIST.

1 data source(s) 22 fields

Data Sources (1)

SourceAliasJoin Type
I_BusinessPartner I_BusinessPartner from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PBPNUMEXTVH view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
VDM.viewType #BASIC view
VDM.private true view
Search.searchable true view
Consumption.ranked true view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner BusinessPartner
BusinessPartnerName BusinessPartnerName
BusinessPartnerIDByExtSystem BusinessPartnerIDByExtSystem
FirstName FirstName
LastName LastName
OrganizationBPName1 OrganizationBPName1
OrganizationBPName2 OrganizationBPName2
GroupBusinessPartnerName1 GroupBusinessPartnerName1
GroupBusinessPartnerName2 GroupBusinessPartnerName2
AuthorizationGroup AuthorizationGroup
IsBusinessPurposeCompleted IsBusinessPurposeCompleted
DataControllerSet DataControllerSet
DataController1 DataController1
DataController2 DataController2
DataController3 DataController3
DataController4 DataController4
DataController5 DataController5
DataController6 DataController6
DataController7 DataController7
DataController8 DataController8
DataController9 DataController9
DataController10 DataController10 
@AbapCatalog.sqlViewName: 'PBPNUMEXTVH'
@ClientHandling.algorithm : #SESSION_VARIABLE

@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED

@VDM.viewType: #BASIC
@VDM.private: true
@Search.searchable: true
@Consumption.ranked: true

@Consumption.dbHints: [ 'USE_HEX_PLAN' ]

define view P_BPNumInExtSystemValueHelp
  as select from I_BusinessPartner
{

      @ObjectModel.text.element: ['BusinessPartnerName']
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
  key BusinessPartner,

      BusinessPartnerName,

      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #MEDIUM
      BusinessPartnerIDByExtSystem,

      @UI.hidden: true
      @Search: {
        defaultSearchElement: true,
        fuzzinessThreshold: 0.8,
        ranking: #LOW
      }
      FirstName,
      @UI.hidden: true
      @Search: {
        defaultSearchElement: true,
        fuzzinessThreshold: 0.8,
        ranking: #LOW
      }
      LastName,
      @UI.hidden: true
      @Search: {
        defaultSearchElement: true,
        fuzzinessThreshold: 0.8,
        ranking: #LOW
      }
      OrganizationBPName1,
      @UI.hidden: true
      @Search: {
        defaultSearchElement: true,
        fuzzinessThreshold: 0.8,
        ranking: #LOW
      }
      OrganizationBPName2,
      @UI.hidden: true
      @Search: {
        defaultSearchElement: true,
        fuzzinessThreshold: 0.8,
        ranking: #LOW
      }
      GroupBusinessPartnerName1,
      @UI.hidden: true
      @Search: {
        defaultSearchElement: true,
        fuzzinessThreshold: 0.8,
        ranking: #LOW
      }
      GroupBusinessPartnerName2,

      // These fields are needed for DCL

      @Consumption.hidden: true
      AuthorizationGroup,
      @Consumption.hidden: true
      IsBusinessPurposeCompleted,

      @UI.hidden: true
      @Consumption.filter.hidden: true
      DataControllerSet,

      @UI.hidden: true
      @Consumption.filter.hidden: true
      DataController1,

      @UI.hidden: true
      @Consumption.filter.hidden: true
      DataController2,

      @UI.hidden: true
      @Consumption.filter.hidden: true
      DataController3,

      @UI.hidden: true
      @Consumption.filter.hidden: true
      DataController4,

      @UI.hidden: true
      @Consumption.filter.hidden: true
      DataController5,

      @UI.hidden: true
      @Consumption.filter.hidden: true
      DataController6,

      @UI.hidden: true
      @Consumption.filter.hidden: true
      DataController7,

      @UI.hidden: true
      @Consumption.filter.hidden: true
      DataController8,

      @UI.hidden: true
      @Consumption.filter.hidden: true
      DataController9,

      @UI.hidden: true
      @Consumption.filter.hidden: true
      DataController10

}
where
  BusinessPartnerIDByExtSystem <> ''

Learn More