I_Ledger

DDL: I_LEDGER SQL: IFILEDGER Type: view BASIC

Ledger

I_Ledger is a Basic CDS View (Dimension) that provides data about "Ledger" in SAP S/4HANA. It reads from 2 data sources (finsc_actve_appl, finsc_ledger) and exposes 12 fields with key field Ledger. It has 3 associations to related views.

Data Sources (2)

SourceAliasJoin Type
finsc_actve_appl finsc_actve_appl inner
finsc_ledger finsc_ledger from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_PredictionLedger _PredictionLedger $projection.Ledger = _PredictionLedger.PredictionLedger
[0..1] I_LedgerType _LedgerType $projection.LedgerType = _LedgerType.LedgerType
[0..*] I_LedgerText _Text $projection.Ledger = _Text.Ledger

Annotations (18)

NameValueLevelField
EndUserText.label Ledger view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
Metadata.allowExtensions true view
VDM.viewType #BASIC view
AbapCatalog.sqlViewName IFILEDGER view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.representativeKey Ledger view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
AbapCatalog.buffering.status #ACTIVE view
AbapCatalog.buffering.type #FULL view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY Ledger rldnr
IsLeadingLedger finsc_ledger xleading
LedgerApplication finsc_ledger appl
LedgerSubApplication finsc_ledger subappl
AccountingValuationView finsc_ledger valutyp
LedgerType finsc_ledger ledger_type
ExtensionLedgerType finsc_ledger ext_ledger_type
ReferenceLedger finsc_ledger fallback_ledger
TechnicalLedger finsc_ledger tech_ledger
_LedgerType _LedgerType
_PredictionLedger _PredictionLedger
_Text _Text
@EndUserText.label: 'Ledger'
@Analytics: { 
  dataCategory: #DIMENSION,
  dataExtraction.enabled: true 
}
@Metadata.allowExtensions:true
@VDM.viewType: #BASIC
@AbapCatalog.sqlViewName: 'IFILEDGER'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.representativeKey: 'Ledger'
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType: {
  dataClass: #CUSTOMIZING,
  serviceQuality: #A,
  sizeCategory: #S
}
@AbapCatalog.buffering:{
  status: #ACTIVE,
  type: #FULL
}
@ObjectModel.supportedCapabilities:[#CDS_MODELING_DATA_SOURCE,#ANALYTICAL_DIMENSION,#CDS_MODELING_ASSOCIATION_TARGET,#SQL_DATA_SOURCE, #EXTRACTION_DATA_SOURCE]
@ObjectModel.modelingPattern: #ANALYTICAL_DIMENSION
define view I_Ledger  
as select from
finsc_ledger inner join finsc_actve_appl on  finsc_ledger.appl    = finsc_actve_appl.appl
                                         and finsc_ledger.subappl = finsc_actve_appl.subappl  
association [0..1] to I_PredictionLedger   as _PredictionLedger on $projection.Ledger = _PredictionLedger.PredictionLedger    
association [0..1] to I_LedgerType         as _LedgerType       on $projection.LedgerType = _LedgerType.LedgerType                                     
association [0..*] to I_LedgerText         as _Text             on $projection.Ledger = _Text.Ledger

{
   @ObjectModel.text.association: '_Text'
    key rldnr as Ledger,
    
  
    finsc_ledger.xleading as IsLeadingLedger,
    
    finsc_ledger.appl as LedgerApplication,
    
    finsc_ledger.subappl as LedgerSubApplication,
    
    finsc_ledger.valutyp as AccountingValuationView,
    
    finsc_ledger.ledger_type as LedgerType,
    
    finsc_ledger.ext_ledger_type as ExtensionLedgerType,
    
    finsc_ledger.fallback_ledger as ReferenceLedger,
    
    @Consumption.hidden: true    
    finsc_ledger.tech_ledger as TechnicalLedger,
    
     
    _LedgerType,
    _PredictionLedger,
    _Text
};   
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"FINSC_ACTVE_APPL",
"FINSC_LEDGER"
],
"ASSOCIATED":
[
"I_LEDGERTEXT",
"I_LEDGERTYPE",
"I_PREDICTIONLEDGER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/