I_LU_SAFTGenLedgerMultiBP

DDL: I_LU_SAFTGENLEDGERMULTIBP Type: view_entity COMPOSITE Package: GLO_FIN_IS_SAFT_LU

SAFT LU Multiple BP On Same Document

I_LU_SAFTGenLedgerMultiBP is a Composite CDS View that provides data about "SAFT LU Multiple BP On Same Document" in SAP S/4HANA. It reads from 2 data sources (I_JournalEntryItem, I_JournalEntryItem) and exposes 10 fields with key fields CompanyCode, FiscalYear, AccountingDocument, Ledger, FiscalYear. Part of development package GLO_FIN_IS_SAFT_LU.

2 data source(s) 10 fields

Data Sources (2)

SourceAliasJoin Type
I_JournalEntryItem I_JournalEntryItem from
I_JournalEntryItem I_JournalEntryItem union

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label SAFT LU Multiple BP On Same Document view
Metadata.ignorePropagatedAnnotations true view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode
KEY FiscalYear FiscalYear
KEY AccountingDocument AccountingDocument
KEY Ledger Ledger
PostingDate PostingDate
KEY FiscalYear FiscalYear
KEY AccountingDocument AccountingDocument
KEY Ledger Ledger
PostingDate PostingDate
NumberOfRecords 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.personalData.blocking: #BLOCKED_DATA_INCLUDED
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MIXED
@EndUserText.label: 'SAFT LU Multiple BP On Same Document'
@Metadata.ignorePropagatedAnnotations: true
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
define view entity I_LU_SAFTGenLedgerMultiBP
  as select from I_JournalEntryItem
{
  key CompanyCode,
  key FiscalYear,
  key AccountingDocument,
  key Ledger,

      PostingDate,

      count( distinct Customer ) as NumberOfRecords
}

where
  FinancialAccountType = 'D'

group by
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  Ledger,
  PostingDate

union select from I_JournalEntryItem
{
  key CompanyCode,
  key FiscalYear,
  key AccountingDocument,
  key Ledger,

      PostingDate,

      count( distinct Supplier ) as NumberOfRecords
}

where
  FinancialAccountType = 'K'

group by
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  Ledger,
  PostingDate

Learn More