I_LEDGER

CDS View

Ledger

I_LEDGER is a CDS View in S/4HANA. Ledger. It contains 2 fields. 109 CDS views read from this table.

CDS Views using this table (109)

ViewTypeJoinVDMDescription
A_Ledger view from BASIC API Ledger
C_CN_FsclPerdVH view inner CONSUMPTION Fiscal Period Value Help
C_COGSSplitRelevantGLItems view inner CONSUMPTION Relevant Items from COGS Split and Original Document
C_CostRateLedgerVH view from CONSUMPTION Ledger Value Help
C_CostRateLedgerVH view union CONSUMPTION Ledger Value Help
C_EvtBsdProductionOrderCostOvw view from CONSUMPTION Event-Based Production Order Cost Overview
C_FinStatisticalKeyFigure view inner CONSUMPTION Read Statistical Key Figures per Period
C_FixedAssetOvwLedgerVH view from CONSUMPTION Fixed Asset Ledger VH
C_GrossMarginLedgerVH view from CONSUMPTION Ledger VH for Gross Margin
F_LeadingLedger view from DERIVATION_FUNCTION Leading Ledger
FIS_COGS view inner Cost of Goods Sold
Fml_Curtp_Cell view inner Mapping ML Curtp to Cell in FINSC_LD_CMP
Fml_Relind_Bwkey view inner ML Relevant Indicators per Bwkey
I_AccountingCostRate view inner BASIC Interface view for search model CostRate
I_AdditionalCurrencyRoles view inner BASIC Additional Currency Roles for Company Code
I_CorrespncAddlCurrencyRole view inner BASIC Additional Currency Role for Correspondence
I_CycleRunGroup view inner BASIC Cycle Run Group
I_DepreciationAreaWithLedger view left_outer BASIC Depreciation Area with Ledger
I_FinSGLPostedItem view_entity inner BASIC Financial Services GL Posted Item
I_JVAActualBudgetLineItem view inner COMPOSITE Actual Cost and JV Budget
I_LeadingDeprAreaVH view inner COMPOSITE Leading Depreciation Area Value Help
I_LedgerStdVH view from COMPOSITE Ledger
I_OplAcctgDocItemFreeDfndCrcy view inner BASIC Amount in Freely Defined Currency
I_RealTimeStandardLedgerVH view from COMPOSITE Event Based Standard Ledger
I_SrvcDocBslnPlannedCost view inner COMPOSITE Baseline Planned Cost of Srv Transaction
I_SrvcDocBslnPlannedRevenue view inner COMPOSITE Baseline Planned Revenue of Srv Txn
I_SrvcDocContnsPlannedCost view_entity inner COMPOSITE Ongoing Planned Cost of Srv Transaction
I_SrvcDocContnsPlannedRevenue view_entity inner COMPOSITE Ongoing Planned Revenue of Srv Trans
I_SrvcDocItmBslnPlannedCost view inner COMPOSITE Baseline Planned Cost of Srv Txn Item
I_SrvcDocItmBslnPlannedRevenue view inner COMPOSITE Baseline Planned Revenue of Srv Txn Item
I_SrvcDocItmContnsPlannedCost view_entity inner COMPOSITE Ongoing Planned Cost Srv Trans Item
I_SrvcDocItmContnsPlndRevenue view_entity inner COMPOSITE Ongoing Planned Revenue Srv Trans Item
I_StdLdgrWthoutShadowVH view from COMPOSITE Standard Ledger only without Shadow
I_WorkCenterProdCostCube view inner COMPOSITE Production Cost By Work Center
P_BOPRevnCostItemToFormItem00 view_entity inner COMPOSITE
P_CCLdngLdgrPerDates view inner BASIC
P_CCLdngLdgrPeriodDates view inner BASIC
P_CN_CompanyRecnclnLedger view from COMPOSITE
P_CoCodeLedgerValnCrcyRole view inner BASIC
P_COMfgOrdActlPlnUnion view inner COMPOSITE
P_COMFGOrderPlanStdCube view inner COMPOSITE
P_COMfgOrderPlanStdCube1 view inner COMPOSITE
P_COMFGOrderTargetCube view inner COMPOSITE
P_CurrencyRoleForLedger view inner COMPOSITE
P_EBWObjectActualCosts view inner BASIC
P_EBWObjectPlanCosts view inner BASIC
P_EBWObjectWIPReserves view inner BASIC
P_EngmntProjPlanDataByRscre view inner COMPOSITE
P_EngmntProjPlnAggrgnByPerd view inner COMPOSITE
P_EngmntProjReviewData view inner COMPOSITE
P_EngmntProjSlsOrdItmDet view left_outer COMPOSITE
P_EngmntProjUnbilledRevnAggrgn view inner COMPOSITE
P_EngmntProjWrkPckgUnitKPI view inner COMPOSITE
P_EngmtProjActlPlnSlsOrd view inner COMPOSITE
P_EngmtProjActuals view inner COMPOSITE
P_EPUnbilldRevnInLeadLdgr view inner COMPOSITE
P_FinStatisticalKeyFigureItem1 view inner COMPOSITE
P_GLAcctLineItemEnrcd view inner COMPOSITE
P_GrossMarginUnion view inner COMPOSITE
P_IsLeadingLedger view from COMPOSITE
P_JrnlEntryReferenceDocument view_entity inner COMPOSITE
P_LdngLdgrGlobCrcyTranslation view_entity inner BASIC
P_Materialledger_Relvt_Curtp view inner BASIC
P_Matval_Manage_Md2 view inner COMPOSITE
P_MngProjDmndWorkActual view inner COMPOSITE
P_PCCOrderActualOutputQuantity view inner COMPOSITE Manufacturing order actual output quantity
P_PCCOrderSpclStockValStrategy view inner COMPOSITE
P_PT_GLAccountBOPLineItem view_entity inner COMPOSITE
P_RealTimeMfgOrdBalance view inner COMPOSITE
P_RealTimeMfgOrderPostedKPI view inner COMPOSITE
P_RealTimeMfgOrderReserve view inner COMPOSITE
P_RealTimeMfgOrderToBePostdKPI view inner COMPOSITE
P_RealTimeMfgOrderWIP view inner COMPOSITE
P_RealTimeMFGOrdInspPostdDistr view inner COMPOSITE
P_RealTimeMfgOrdInspPostedRsrv view inner COMPOSITE
P_RealTimeMfgOrdInspPostedVarc view inner COMPOSITE
P_RealTimeMfgOrdInspPostedWIP view inner COMPOSITE
P_RealTimeMfgOrdTotalBalance view inner COMPOSITE
P_RealTimeMfgOrdWIPBalance view inner COMPOSITE
P_RealTimeMfgOrdWIPRlvtActCost view inner COMPOSITE
P_RTPC_PCC_OrderToBePosted view inner COMPOSITE
P_RTPC_REM_ORDER_DELIVEREDCOST view inner BASIC
P_RTPC_REM_OrderPostedKPI view inner COMPOSITE
P_RTPCOrderActlCostForSettlmt view inner BASIC
P_RTPCOrderActualCost view inner BASIC
P_RTPCOrderActualCostSettled view inner BASIC
P_RTPCOrderBalance view inner COMPOSITE
P_RTPCOrderCostDistribution view inner BASIC
P_RTPCOrderCostDistrwthAwref view inner BASIC
P_RTPCOrderDistributedCost view inner BASIC
P_RTPCOrderFxdPrcProdDlvrdCost view inner BASIC
P_RTPCOrderFxdPricePrdDlvValue view inner BASIC
P_RTPCOrderItemFxdPricePrdAct1 view inner BASIC
P_RTPCOrderOutputQuantity view inner BASIC
P_RTPCOrderPostedVariance view inner BASIC
P_RTPCOrderProdDelievedCost view inner BASIC
P_RTPCOrderSettCostForRev view inner BASIC
P_RTPCORDERTOTALPOSTEDVARC view inner BASIC RTPC Order Total Posted Variance
P_RTPCOrderWIPReserve view inner BASIC
P_RTPCORDERWIPRLVTACTCSTWTHREF view inner BASIC
P_RTPCOrdWIPOffstOnCostElmnt view inner COMPOSITE
P_RTPCTOBEDISTRIBUTEDCOST view inner BASIC
P_RU_BPBalance1 view inner CONSUMPTION
P_SlsAcctgParamTrnsfmtn view from COMPOSITE
P_StRpBPTaxItem view inner COMPOSITE
P_StRpBPTaxItem3 view inner COMPOSITE
P_UnrealizedCrcyDiffFilter view inner COMPOSITE
R_PaymentCurrencyRole view inner BASIC Payment Currency Roles
R_SetlMgmtUnivJrnlEntrBizVol view_entity inner BASIC ACDOCA entries for Business Volume

Fields (2)

KeyField CDS FieldsUsed in Views
KEY Ledger LeadingLedger,Ledger 12
IsLeadingLedger IsLeadingLedger 3
@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":""
}
}*/