I_ElectronicDocCockpitSuplrEml

DDL: I_ELECTRONICDOCCOCKPITSUPLREML SQL: IEDCSE Type: view COMPOSITE

Electronic Document: Supplier and Email

I_ElectronicDocCockpitSuplrEml is a Composite CDS View that provides data about "Electronic Document: Supplier and Email" in SAP S/4HANA. It reads from 2 data sources (I_AddressEmailAddress, I_Supplier) and exposes 21 fields with key fields Supplier, Person, OrdinalNumber.

Data Sources (2)

SourceAliasJoin Type
I_AddressEmailAddress _DefaultCorpEmailAddress inner
I_Supplier _Supplier from

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IEDCSE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
EndUserText.label Electronic Document: Supplier and Email view
Search.searchable true view
VDM.viewType #COMPOSITE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #NOT_REQUIRED view
AccessControl.authorizationCheck #CHECK view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY Supplier I_Supplier Supplier
KEY Person I_AddressEmailAddress Person
KEY OrdinalNumber I_AddressEmailAddress OrdinalNumber
SupplierName I_Supplier SupplierName
SupplierFullName I_Supplier SupplierFullName
AddressID I_Supplier AddressID
EmailAddress I_AddressEmailAddress EmailAddress
SupplierAccountGroup I_Supplier SupplierAccountGroup
AuthorizationGroup I_Supplier AuthorizationGroup
IsBusinessPurposeCompleted I_Supplier IsBusinessPurposeCompleted
DataControllerSet I_Supplier DataControllerSet
DataController1 I_Supplier DataController1
DataController2 I_Supplier DataController2
DataController3 I_Supplier DataController3
DataController4 I_Supplier DataController4
DataController5 I_Supplier DataController5
DataController6 I_Supplier DataController6
DataController7 I_Supplier DataController7
DataController8 I_Supplier DataController8
DataController9 I_Supplier DataController9
DataController10 I_Supplier DataController10
@AbapCatalog.sqlViewName: 'IEDCSE'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@EndUserText.label: 'Electronic Document: Supplier and Email'
@Search.searchable: true
@VDM.viewType: #COMPOSITE
//@ObjectModel.dataCategory: #VALUE_HELP

@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.supportedCapabilities:[#CDS_MODELING_DATA_SOURCE,#SEARCHABLE_ENTITY,#VALUE_HELP_PROVIDER]
@ObjectModel.usageType:{
    serviceQuality: #D,
    sizeCategory: #S,
    dataClass: #CUSTOMIZING
}
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #NOT_REQUIRED
@AccessControl.authorizationCheck:#CHECK
define view I_ElectronicDocCockpitSuplrEml
  as select from I_Supplier            as _Supplier
    inner join   I_AddressEmailAddress as _DefaultCorpEmailAddress on _DefaultCorpEmailAddress.AddressID = _Supplier.AddressID
{
      @ObjectModel.text.element: 'SupplierName'
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
  key _Supplier.Supplier,
  key _DefaultCorpEmailAddress.Person,
  key _DefaultCorpEmailAddress.OrdinalNumber,
      _Supplier.SupplierName,
      _Supplier.SupplierFullName,
      _Supplier.AddressID,
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
      _DefaultCorpEmailAddress.EmailAddress,
      //added only for DCL check

      _Supplier.SupplierAccountGroup,
      _Supplier.AuthorizationGroup,
      @Semantics.booleanIndicator: true
      _Supplier.IsBusinessPurposeCompleted,
      @Consumption.hidden:true
       @UI.hidden:true
      _Supplier.DataControllerSet,
       @Consumption.hidden:true
       @UI.hidden:true
      _Supplier.DataController1,
       //added only for DCL check

       @Consumption.hidden:true
       @UI.hidden:true
      _Supplier.DataController2,
       //added only for DCL check

       @Consumption.hidden:true
       @UI.hidden:true
      _Supplier.DataController3,
      //added only for DCL check

       @Consumption.hidden:true
       @UI.hidden:true
      _Supplier.DataController4,
      //added only for DCL check

       @Consumption.hidden:true
       @UI.hidden:true
      _Supplier.DataController5,
       @Consumption.hidden:true
       @UI.hidden:true
      _Supplier.DataController6,
       //added only for DCL check

       @Consumption.hidden:true
       @UI.hidden:true
      _Supplier.DataController7,
      //added only for DCL check

       @Consumption.hidden:true
       @UI.hidden:true
      _Supplier.DataController8,
      //added only for DCL check

       @Consumption.hidden:true
       @UI.hidden:true
      _Supplier.DataController9,
       //added only for DCL check

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

}
where
  _DefaultCorpEmailAddress.CommNumberIsNotUsed = ' '
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ADDRESSEMAILADDRESS",
"I_SUPPLIER"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/