C_FinCustomerInvoiceEDP

DDL: C_FINCUSTOMERINVOICEEDP Type: view_entity CONSUMPTION Package: FINS_OUTPUT_MGMT_FO_FICUS_INV

FI Customer Invoice Email Data Provider

C_FinCustomerInvoiceEDP is a Consumption CDS View that provides data about "FI Customer Invoice Email Data Provider" in SAP S/4HANA. It reads from 2 data sources (I_CompanyCode, I_JournalEntry) and exposes 9 fields with key fields CompanyCode, FiscalYear, AccountingDocument. Part of development package FINS_OUTPUT_MGMT_FO_FICUS_INV.

Data Sources (2)

SourceAliasJoin Type
I_CompanyCode _CompanyCode inner
I_JournalEntry JournalEntry from

Annotations (8)

NameValueLevelField
EndUserText.label FI Customer Invoice Email Data Provider view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #REQUIRED view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #CONSUMPTION view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_JournalEntry CompanyCode
KEY FiscalYear I_JournalEntry FiscalYear
KEY AccountingDocument I_JournalEntry AccountingDocument
AccountingDocumentType I_JournalEntry AccountingDocumentType
DocumentDate I_JournalEntry DocumentDate
PostingDate I_JournalEntry PostingDate
FiscalPeriod I_JournalEntry FiscalPeriod
UserDescription _User UserDescription
CompanyCodeName I_CompanyCode CompanyCodeName
@AbapCatalog.viewEnhancementCategory: [#NONE]
@EndUserText.label: 'FI Customer Invoice Email Data Provider'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
@AccessControl.personalData.blocking: #REQUIRED
@AccessControl.authorizationCheck: #MANDATORY
@ObjectModel.supportedCapabilities: [#OUTPUT_EMAIL_DATA_PROVIDER]
@VDM.viewType: #CONSUMPTION

define view entity C_FinCustomerInvoiceEDP as select from I_JournalEntry as JournalEntry
    inner join   I_CompanyCode          as _CompanyCode on _CompanyCode.CompanyCode = JournalEntry.CompanyCode
    left outer to one join I_User as _User on _User.UserID = $session.user
{
      
  key JournalEntry.CompanyCode as CompanyCode,                
  key JournalEntry.FiscalYear  as FiscalYear,                  
  key JournalEntry.AccountingDocument as AccountingDocument,         
      JournalEntry.AccountingDocumentType,
      JournalEntry.DocumentDate,
      JournalEntry.PostingDate,
      JournalEntry.FiscalPeriod,
      
      _User.UserDescription,
      _CompanyCode.CompanyCodeName     as CompanyCodeName

}