I_LEDGERSOURCELEDGER

CDS View

Mapping between Ledger and Source Ledger

I_LEDGERSOURCELEDGER is a CDS View in S/4HANA. Mapping between Ledger and Source Ledger. It contains 3 fields. 8 CDS views read from this table.

CDS Views using this table (8)

ViewTypeJoinVDMDescription
F_SourceLedger view_entity from DERIVATION_FUNCTION Derivation function for Source Ledger
I_GLAcctLineItemItemizationBsc view_entity inner BASIC Aged items in Accounting
I_JVAGrossNetAmtByCostObjC view inner COMPOSITE Gross and Net Amounts - Cube
P_ActvENTERPRISEPROJCMTMTCOSTS view inner COMPOSITE Project Cost Line Items with Commitment Costs
P_ACTVENTPROJACTCOSTSFORLEDGER view inner COMPOSITE Project Cost Line Items with Actual Costs
P_ENTPROJECTCMTMTCOSTS view inner COMPOSITE Project Cost Line Items with Commitment Costs
P_IsLeadingLedger view inner COMPOSITE Ledger which have is leading ledger flag set
P_ProjectStockCostLineItem view inner COMPOSITE Project Stock Cost line item

Fields (3)

KeyField CDS FieldsUsed in Views
KEY Ledger Ledger 5
KEY SourceLedger SourceLedger 2
_Ledger _Ledger 1
 @AbapCatalog.entityBuffer.definitionAllowed: true
 @VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.representativeKey: 'SourceLedger'
@Metadata.ignorePropagatedAnnotations: true
@Metadata.allowExtensions: true
@ObjectModel.usageType: {
  dataClass: #CUSTOMIZING,
  serviceQuality: #A,
  sizeCategory: #S
}
@EndUserText.label: 'Mapping between Ledger and Source Ledger'

@Analytics.internalName: #LOCAL
@Analytics: { 
      dataCategory: #DIMENSION, 
      dataExtraction.enabled: true  }
@Analytics.technicalName: 'IFILDRSRCLDR'

@ObjectModel.supportedCapabilities: [ #EXTRACTION_DATA_SOURCE, #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET ]
@ObjectModel.sapObjectNodeType.name: 'Ledger' 

define view entity I_LedgerSourceLedger as select from finsc_ledger_rep 
  association [1..1] to I_Ledger     as _Ledger on $projection.Ledger = _Ledger.Ledger
  association [0..*] to I_LedgerText as _Text   on $projection.Ledger = _Text.Ledger
{
      @ObjectModel.foreignKey.association: '_Ledger'
      @ObjectModel.text.association: '_Text'
  key finsc_ledger_rep.rldnr      as Ledger,
  key finsc_ledger_rep.rldnr_pers as SourceLedger,
  
      _Ledger,
      _Text    
}