I_ElectronicDocCockpitSuplrEml

DDL: I_ELECTRONICDOCCOCKPITSUPLREML SQL: IEDCSE Type: view COMPOSITE Package: GLO-EDO-DCC
21 Fields 2 Data Sources

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. Part of development package GLO-EDO-DCC.

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 Supplier
KEY Person I_AddressEmailAddress Person Person/ Farm/ Field
KEY OrdinalNumber I_AddressEmailAddress OrdinalNumber Sequence Number
SupplierName I_Supplier SupplierName Supplier Name
SupplierFullName I_Supplier SupplierFullName
AddressID I_Supplier AddressID Ship-to address
EmailAddress I_AddressEmailAddress EmailAddress E-Mail Address
SupplierAccountGroup I_Supplier SupplierAccountGroup Account group
AuthorizationGroup I_Supplier AuthorizationGroup AuthorizGroup
IsBusinessPurposeCompleted I_Supplier IsBusinessPurposeCompleted Purpose Completed
DataControllerSet I_Supplier DataControllerSet Data Ctrlr. Set
DataController1 I_Supplier DataController1 Data Controller
DataController2 I_Supplier DataController2 Data Controller
DataController3 I_Supplier DataController3 Data Controller
DataController4 I_Supplier DataController4 Data Controller
DataController5 I_Supplier DataController5 Data Controller
DataController6 I_Supplier DataController6 Data Controller
DataController7 I_Supplier DataController7 Data Controller
DataController8 I_Supplier DataController8 Data Controller
DataController9 I_Supplier DataController9 Data Controller
DataController10 I_Supplier DataController10 Data Controller

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_ElectronicDocCockpitSuplrEml.
-- 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: IEDCSE

CREATE VIEW I_ElectronicDocCockpitSuplrEml AS
SELECT
  _Supplier.Supplier AS Supplier,
  _DefaultCorpEmailAddress.Person AS Person,
  _DefaultCorpEmailAddress.OrdinalNumber AS OrdinalNumber,
  _Supplier.SupplierName AS SupplierName,
  _Supplier.SupplierFullName AS SupplierFullName,
  _Supplier.AddressID AS AddressID,
  _DefaultCorpEmailAddress.EmailAddress AS EmailAddress,
  _Supplier.SupplierAccountGroup AS SupplierAccountGroup,
  _Supplier.AuthorizationGroup AS AuthorizationGroup,
  _Supplier.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  _Supplier.DataControllerSet AS DataControllerSet,
  _Supplier.DataController1 AS DataController1,
  _Supplier.DataController2 AS DataController2,
  _Supplier.DataController3 AS DataController3,
  _Supplier.DataController4 AS DataController4,
  _Supplier.DataController5 AS DataController5,
  _Supplier.DataController6 AS DataController6,
  _Supplier.DataController7 AS DataController7,
  _Supplier.DataController8 AS DataController8,
  _Supplier.DataController9 AS DataController9,
  _Supplier.DataController10 AS DataController10
FROM I_Supplier AS _Supplier
INNER JOIN I_AddressEmailAddress AS _DefaultCorpEmailAddress ON /* join condition not captured in parsed metadata */
;

Learn More