I_EmlTmplCustSuplrCompanyCode

DDL: I_EMLTMPLCUSTSUPLRCOMPANYCODE SQL: IETCUSTSUPLCOCD Type: view COMPOSITE

Email Template Data Provider

I_EmlTmplCustSuplrCompanyCode is a Composite CDS View that provides data about "Email Template Data Provider" in SAP S/4HANA. It reads from 7 data sources and exposes 17 fields with key fields Account, CompanyCode, FinancialAccountType, CompanyCode, FinancialAccountType.

7 data source(s) 17 fields

Data Sources (7)

SourceAliasJoin Type
I_CompanyCode _CompanyCode inner
I_CompanyCode _CompanyCode inner
I_Customer _Customer from
I_CustomerCompany _CustomerCompany inner
I_Supplier _Supplier union_all
I_SupplierCompany _SupplierCompany inner
I_CustomerCompany _SupplierCustomerCompany left_outer

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IETCUSTSUPLCOCD view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.personalData.blocking #REQUIRED view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.supportedCapabilities #OUTPUT_EMAIL_DATA_PROVIDER view
Metadata.ignorePropagatedAnnotations true view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
EndUserText.label Email Template Data Provider view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY Account I_Customer Customer
KEY CompanyCode I_CustomerCompany CompanyCode
KEY FinancialAccountType
Name I_Customer CustomerName
FullName I_Customer CustomerFullName
CompanyCodeName I_CompanyCode CompanyCodeName
AuthorizationGroup I_Customer AuthorizationGroup
ReferenceAccountGroup I_Customer CustomerAccountGroup
SupplierasAccount
KEY CompanyCode I_SupplierCompany CompanyCode
KEY FinancialAccountType
Name I_Supplier SupplierName
FullName I_Supplier SupplierFullName
CompanyCodeName I_CompanyCode CompanyCodeName
AuthorizationGroup I_Supplier AuthorizationGroup
ReferenceAccountGroup I_Supplier SupplierAccountGroup
CoCodeSpcfcAuthorizationGroup I_SupplierCompany AuthorizationGroup 
@AbapCatalog.sqlViewName: 'IETCUSTSUPLCOCD'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.personalData.blocking: #REQUIRED
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType: {
  dataClass: #MASTER,
  serviceQuality: #C,
  sizeCategory: #L
}
@ObjectModel.supportedCapabilities:#OUTPUT_EMAIL_DATA_PROVIDER

@Metadata.ignorePropagatedAnnotations:true 
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #COMPOSITE

@EndUserText.label: 'Email Template Data Provider'
define view I_EmlTmplCustSuplrCompanyCode as select from I_Customer        as _Customer
    inner join   I_CustomerCompany as _CustomerCompany on _Customer.Customer = _CustomerCompany.Customer
    inner join   I_CompanyCode     as _CompanyCode     on _CustomerCompany.CompanyCode = _CompanyCode.CompanyCode
{
  key _Customer.Customer                               as Account,
  key _CustomerCompany.CompanyCode                     as CompanyCode,
  key 'D'                                              as FinancialAccountType,
      _Customer.CustomerName                           as Name,
      _Customer.CustomerFullName                       as FullName,
      _CompanyCode.CompanyCodeName                     as CompanyCodeName,
      @UI.hidden: true
      _Customer.AuthorizationGroup                     as AuthorizationGroup,
      @UI.hidden: true
      _Customer.CustomerAccountGroup                   as ReferenceAccountGroup,
      @UI.hidden: true
      _CustomerCompany.AuthorizationGroup              as CoCodeSpcfcAuthorizationGroup
}

union all

select from  I_Supplier        as _Supplier
  inner join I_SupplierCompany as _SupplierCompany on _Supplier.Supplier = _SupplierCompany.Supplier
  inner join I_CompanyCode     as _CompanyCode     on _SupplierCompany.CompanyCode = _CompanyCode.CompanyCode
  left outer join I_CustomerCompany as _SupplierCustomerCompany
    on _Supplier.Supplier = _SupplierCustomerCompany.Customer
    and _SupplierCompany.CompanyCode = _SupplierCustomerCompany.CompanyCode
{
  key _Supplier.Supplier                               as Account,
  key _SupplierCompany.CompanyCode                     as CompanyCode,
  key 'K'                                              as FinancialAccountType,
      _Supplier.SupplierName                           as Name,
      _Supplier.SupplierFullName                       as FullName,
      _CompanyCode.CompanyCodeName                     as CompanyCodeName,
      @UI.hidden: true
      _Supplier.AuthorizationGroup                     as AuthorizationGroup,
      @UI.hidden: true
      _Supplier.SupplierAccountGroup                   as ReferenceAccountGroup,
      @UI.hidden: true
      _SupplierCompany.AuthorizationGroup              as CoCodeSpcfcAuthorizationGroup
} 
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_COMPANYCODE",
"I_CUSTOMER",
"I_CUSTOMERCOMPANY",
"I_SUPPLIER",
"I_SUPPLIERCOMPANY"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More