I_JVALEDGER

CDS View

JVA Ledger For Company Code

I_JVALEDGER is a CDS View in S/4HANA. JVA Ledger For Company Code. It contains 1 fields. 10 CDS views read from this table.

Used by 10 CDS view(s) 1 fields

CDS Views using this table (10)

ViewTypeJoinVDMDescription
I_JVAActualBudgetLineItem view inner COMPOSITE Actual Cost and JV Budget
I_JVAActualCashCallLineItem view inner COMPOSITE Actual Cost and Cash Call for UJE
I_JVADefaultFundCrcy view inner COMPOSITE JVA Default Funding Currencies
I_JVAFsclYearPerdCoCodeForITD view inner COMPOSITE JVA Fiscal Year Period For Company Code
I_JVAFsclYearPerdCoCodeForYTD view inner COMPOSITE JVA Fiscal Year Period For Company Code
I_JVAFundCrcyByLoclCrcy view inner COMPOSITE JVA Funding Currencies by local currency
I_JVAGrossNetAmtByCostObjC view inner COMPOSITE Gross and Net Amounts - Cube
I_JVALineItemCube view inner COMPOSITE JVA Line Item - Cube
I_JVANonOperatorInvoiceFDP view inner COMPOSITE Non Operator Invoice Data
I_JVASuspenseWBSAvgCostLineItm view inner COMPOSITE Avg Cost of Supense WBS Element in JVA

Fields (1)

KeyField CDS FieldsUsed in Views
KEY Ledger Ledger,rldnr 3 
@AbapCatalog.sqlViewName: 'IJVALEDGER'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'JVA Ledger For Company Code'
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass:  #MIXED
@ObjectModel.usageType.serviceQuality: #D
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@ClientHandling.algorithm: #SESSION_VARIABLE

define view I_JVALedger
  as select from            I_CompanyCode        as ccfi

    left outer to one join  I_JntVntrCoCodeParam as ccjva on ccjva.CompanyCode = ccfi.CompanyCode
    left outer to many join I_Ledger             as ld    on ld.IsLeadingLedger = 'X'

{
  key ccfi.CompanyCode,

      case when ccjva.Ledger is null or ccjva.Ledger is initial then
        ld.Ledger
      else
        ccjva.Ledger
      end as Ledger,

      case when ccjva.Ledger is null or ccjva.Ledger is initial then
        ld.IsLeadingLedger
      else
        case when ccjva.Ledger = ld.Ledger
          then ld.IsLeadingLedger
          else 
            cast( ' ' as fagl_flag_leading preserving type )
        end 
      end as IsLeadingLedger

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

Learn More