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 2 fields. 13 CDS views read from this table.

CDS Views using this table (13)

ViewTypeJoinVDMDescription
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
P_ACTVENTPROJACTCOSTSFORLEDGER view inner COMPOSITE
P_EnterpriseProjectActCosts view inner COMPOSITE
P_EnterpriseProjectCmtmtCosts view inner COMPOSITE
P_ENTPROJECTCMTMTCOSTS view inner COMPOSITE
P_IsLeadingLedger view inner COMPOSITE
P_PROJACTUALBUDGETLINEITEMS view inner COMPOSITE
P_ProjActualCostLineItems view inner COMPOSITE
P_PROJCMTMTBUDGETLINEITMS view inner COMPOSITE Project Budget Commitment
P_ProjCmtmtCostLineItms view inner COMPOSITE
P_ProjectStockCostLineItem view inner COMPOSITE Project Stock Cost line item

Fields (2)

KeyField CDS FieldsUsed in Views
KEY Ledger Ledger 10
KEY SourceLedger SourceLedger 2
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.sqlViewName: 'IFILDRSRCLDR'
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.representativeKey: 'SourceLedger'
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@Metadata.allowExtensions: true
@ObjectModel.usageType: {
  dataClass: #CUSTOMIZING,
  serviceQuality: #A,
  sizeCategory: #S
}
@AbapCatalog.buffering:{
  status: #ACTIVE,
  type: #FULL
}
@EndUserText.label: 'Mapping between Ledger and Source Ledger'

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

@AbapCatalog.preserveKey:true 
@ObjectModel.supportedCapabilities: [ #EXTRACTION_DATA_SOURCE, #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET ]

define view 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    
}

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"FINSC_LEDGER_REP"
],
"ASSOCIATED":
[
"I_LEDGER",
"I_LEDGERTEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/