I_ElectronicDocCockpitSuplrEml
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)
| Source | Alias | Join Type |
|---|---|---|
| I_AddressEmailAddress | _DefaultCorpEmailAddress | inner |
| I_Supplier | _Supplier | from |
Annotations (13)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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":""
}
}*/
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA