Which CDS Views use I_LEDGER?

I_LEDGER is used by 126 CDS view(s), including: A_Ledger, C_CN_FsclPerdVH, C_COGSSplitRelevantGLItems, C_CostRateLedgerVH, C_CostRateLedgerVH, C_EvtBsdProductionOrderCostOvw, C_FinStatisticalKeyFigure, C_FixedAssetOvwLedgerVH, C_GrossMarginLedgerVH, C_OutgPaytsOnExpnAcct.

How many fields does I_LEDGER have?

I_LEDGER has 2 fields. Key fields: Ledger.

I_LEDGER

CDS View

Ledger

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

CDS Views using this table (126)

View	Type	Join	VDM	Description
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
C_OutgPaytsOnExpnAcct	view_entity	inner	CONSUMPTION	Outgoing Payments On Expense Accounts
C_PostingsOnExpenseAccount	view_entity	inner	CONSUMPTION	Postings On Expense Account
F_LeadingCommitmentLedgerUnion	view_entity	from	DERIVATION_FUNCTION	Union of leading and commitment ledgers
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_entity	inner	BASIC	Additional Currency Roles for Company Code
I_AU_StRpTPARInvoiceLineItems	view	inner	COMPOSITE	Australia TPAR Invoice Line Items
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_IntcoJrnlEntryForControlling	view_entity	inner	BASIC	Intercompany Journal Entry
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_entity	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	BOP: Revenue/Cost Item non-WRX Result
P_CCLdngLdgrPerDates	view	inner	COMPOSITE	Current/Previous Period Dates for CoCode Leading Ledger
P_CCLdngLdgrPeriodDates	view_entity	inner	COMPOSITE	Period Dates for CoCode Leading Ledger
P_CN_CompanyRecnclnLedger	view	from	COMPOSITE	Bank Reconciliation Ledger
P_CoCodeLedgerValnCrcyRole	view	inner	BASIC	Company code ledger valuation currencyrole
P_COMfgOrdActlPlnUnion	view	inner	COMPOSITE	Manufacturing Orders Actual Plan Costs Union for Work Center
P_COMFGOrderPlanStdCube	view	inner	COMPOSITE	Plan and Standard Costs Cube for Manufacturing Orders
P_COMfgOrderPlanStdCube1	view	inner	COMPOSITE	Plan and Standard Costs Cube for Manufacturing Orders
P_COMFGOrderTargetCube	view	inner	COMPOSITE	Target Costs Cube for Manufacturing Orders
P_CurrencyRoleForLedger	view_entity	inner	COMPOSITE	Private view for external currency roles
P_CZ_StRpTaxItem1	view	inner	COMPOSITE	Czech VAT Tax Items (Clearing Items) 1
P_CZ_StRpTaxItem2	view	inner	COMPOSITE	Czech VAT Tax Items (Clearing Items) 2
P_EBWObjectActualCosts	view	inner	BASIC	Order Actual Cost For WIP
P_EBWObjectPlanCosts	view	inner	BASIC	Order Plan Cost For WIP
P_EBWObjectWIPReserves	view	inner	BASIC	Order Actual Cost For WIP
P_EngmntProjAdjPlnFcst	view	inner	COMPOSITE	Calculate Adjusted Planned Forecast Values
P_EngmntProjPlanDataByRscre	view	inner	COMPOSITE	Engagement project plan data aggregation
P_EngmntProjPlnAggrgnByPerd	view	inner	COMPOSITE	Engagement Project by Period
P_EngmntProjReviewData	view	inner	COMPOSITE	Engagement Project Plan Review Data
P_EngmntProjSlsOrdItmDet	view	left_outer	COMPOSITE	Engagement Project Sales Order Item Detail
P_EngmntProjUnbilledRevnAggrgn	view	inner	COMPOSITE	Engagement Project Unbilled Revenue Aggregation
P_EngmntProjWrkPckgUnitKPI	view	inner	COMPOSITE	WorkPackage Unit KPI
P_EngmtProjActlPlnSlsOrd	view	inner	COMPOSITE	Engagement Projects Actls & Plan
P_EngmtProjActuals	view	inner	COMPOSITE	Project Actuals
P_EntPrjProfnlSrvcPrjActlKPIs	view_entity	inner	COMPOSITE	Basic CDS view for Actuals KPIs
P_EPUnbilldRevnInLeadLdgr	view	inner	COMPOSITE	Engagement Project Unbilled Revenue in Leading Ledger
P_EvtBsdAFYVPeriodConv	view_entity	inner	COMPOSITE	Fiscal Year Period Conversion
P_FinStatisticalKeyFigureItem1	view_entity	inner	COMPOSITE	Statistical Keyfigures per period - Union
P_GLAcctLineItemEnrcd	view	inner	COMPOSITE	GLAccount Line Items Enriched
P_GrossMarginUnion	view	inner	COMPOSITE	Gross Margin Union
P_GrossMarginUnion_2	view	inner	COMPOSITE	Gross Margin Union
P_GrssMargFinPlanningEntryItem	view_entity	inner	COMPOSITE	Gross Margin Plan Entry
P_HU_MM_AUDITREPORTNEWR	view_entity	inner	CONSUMPTION	Documents from MM Module for AuditReport
P_HU_MMINVOICECONSIGNMENTNEWR	view_entity	inner	CONSUMPTION	HU Audit Report: MM invoices for Consignment Process
P_HU_SD_AUDITREPORT_JOURNAL	view_entity	inner	CONSUMPTION	Documents from SD Module for AuditReport
P_IsLeadingLedger	view	from	COMPOSITE	Ledger which have is leading ledger flag set
P_JrnlEntryReferenceDocument	view_entity	inner	COMPOSITE	Journal Entry with Reference Document
P_LdngLdgrGlobCrcyTranslation	view_entity	inner	BASIC	Currency Translation for Global Currency
P_Materialledger_Relvt_Curtp	view_entity	inner	COMPOSITE	ML relevant indicators for analytical reports
P_MngProjDmndWorkActual	view	inner	COMPOSITE	Get actuals from projects demand of work P-View
P_PCCOrderActualOutputQuantity	view	inner	COMPOSITE	Manufacturing order actual output quantity
P_PCCOrderSpclStockValStrategy	view	inner	COMPOSITE	Manufacturing Order Valuation Strategy
P_PT_GLAccountBOPLineItem	view_entity	inner	COMPOSITE	PT BOP Balances Line Items
P_RealTimeMfgOrdBalance	view	inner	COMPOSITE	Event-based Order Balance
P_RealTimeMfgOrderPostedKPI	view	inner	COMPOSITE	Event-based Order KPI
P_RealTimeMfgOrderReserve	view	inner	COMPOSITE	Event-based Order Reserves
P_RealTimeMfgOrderToBePostdKPI	view	inner	COMPOSITE	Event-based Order KPI
P_RealTimeMfgOrderWIP	view	inner	COMPOSITE	Event-based Order WIP
P_RealTimeMFGOrdInspPostdDistr	view	inner	COMPOSITE	Private view of Event based Posted Variance in Inspector
P_RealTimeMfgOrdInspPostedRsrv	view	inner	COMPOSITE	Private view of Event based Posted Reserves in Inspector
P_RealTimeMfgOrdInspPostedVarc	view	inner	COMPOSITE	Private view of Event based Posted Variance in Inspector
P_RealTimeMfgOrdInspPostedWIP	view	inner	COMPOSITE	Private view of Event based Posted WIP in Inspector
P_RealTimeMfgOrdTotalBalance	view	inner	COMPOSITE	Event-Based/Migrated Order Balance
P_RealTimeMfgOrdWIPBalance	view	inner	COMPOSITE	Event-Based/Migrated Order WIP Balance
P_RealTimeMfgOrdWIPRlvtActCost	view	inner	COMPOSITE	Event-based Order WIP Relevant Actual Cost
P_RTPC_PCC_OrderToBePosted	view	inner	COMPOSITE	To be posted Event-Based PCC orders
P_RTPC_REM_ORDER_DELIVEREDCOST	view	inner	BASIC	PCC Order Actual Delivered Cost
P_RTPC_REM_OrderPostedKPI	view	inner	COMPOSITE	Posted Event-Based REM Orders KPI
P_RTPCOrderActlCostForSettlmt	view	inner	BASIC	RTPC Order Actual Cost For Settlement
P_RTPCOrderActualCost	view	inner	BASIC	RTPC Order Actual Cost
P_RTPCOrderActualCostSettled	view	inner	BASIC	RTPC Order Actual Cost Settled
P_RTPCOrderBalance	view	inner	COMPOSITE	Event based order's order balance
P_RTPCOrderCostDistribution	view	inner	BASIC	Cost Distribution for Order
P_RTPCOrderCostDistrwthAwref	view	inner	BASIC	Cost Distribution
P_RTPCOrderDistributedCost	view	inner	BASIC	RTPC Order Distributed Cost
P_RTPCOrderFxdPrcProdDlvrdCost	view	inner	BASIC	RTPC Order Fixed Price CoProducts Delivered Cost
P_RTPCOrderFxdPricePrdDlvValue	view	inner	BASIC	RTPC Order Fixed-Price Products Delivered Value
P_RTPCOrderItemFxdPricePrdAct1	view	inner	BASIC	RTPC Order Fixed Price Products Delivered Value
P_RTPCOrderOutputQuantity	view	inner	BASIC	RTPC Order Output Quantity
P_RTPCOrderPostedVariance	view	inner	BASIC	RTPC Order Posted Variance
P_RTPCOrderProdDelievedCost	view	inner	BASIC	RTPC Order Actual Delivered Cost
P_RTPCOrderSettCostForRev	view	inner	BASIC	RTPC Order Actual Cost For Settlement
P_RTPCORDERTOTALPOSTEDVARC	view	inner	BASIC	RTPC Order Total Posted Variance
P_RTPCOrderWIPReserve	view	inner	COMPOSITE	RTPC Order WIP Reserve
P_RTPCORDERWIPRLVTACTCSTWTHREF	view	inner	BASIC	RTPC Order WIP Relevant Actual Cost with Reference Document
P_RTPCOrdWIPOffstOnCostElmnt	view	inner	COMPOSITE	RTPC Order WIP Relevant Actual Cost
P_RTPCTOBEDISTRIBUTEDCOST	view	inner	BASIC	RTPC Order To Be Distrobuted Cost
P_RU_BPBalance1	view	inner	CONSUMPTION	FI RU Business Partner Balance and Ledger
P_SlsAcctgParamTrnsfmtn	view	from	COMPOSITE	Parameters transformation view
P_StRpBPTaxItem	view	inner	COMPOSITE	Business Partner Tax Item (Journal Entry Item Branch 1)
P_StRpBPTaxItem3	view	inner	COMPOSITE	Business Partner Tax Item (Journal Entry Item Branch 2)
P_SupplierInvoiceDocument	view	inner	COMPOSITE	Supplier Invoice Documents
P_UnrealizedCrcyDiffFilter	view	inner	COMPOSITE	Filter on Unrealized Currency Difference
R_EvtBsdFsclYrPeriodByKeyDate	view	inner	COMPOSITE	Event-Based Fiscal Year Period by Key Date
R_PaymentCurrencyRole	view	inner	BASIC	Payment Currency Roles
R_SetlMgmtUnivJrnlEntrBizVol	view_entity	inner	BASIC	ACDOCA entries for Business Volume
R_SettlmtMgmtRevnRecgnBizVol	view_entity	inner	COMPOSITE	Business Volume on Recognized Revenaue

Fields (2)

Key	Field	CDS Fields	Used in Views
KEY	Ledger	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
@ObjectModel.sapObjectNodeType.name: 'Ledger'

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
};

Depth:

I_LEDGER

CDS Views using this table (126)

Fields (2)

Learn More