I_JVALedger

DDL: I_JVALEDGER SQL: IJVALEDGER Type: view COMPOSITE

JVA Ledger For Company Code

I_JVALedger is a Composite CDS View that provides data about "JVA Ledger For Company Code" in SAP S/4HANA. It reads from 1 data source (I_CompanyCode) and exposes 2 fields with key field CompanyCode.

1 data source(s) 2 fields

Data Sources (1)

SourceAliasJoin Type
I_CompanyCode ccfi from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IJVALEDGER view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label JVA Ledger For Company Code view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_CompanyCode CompanyCode
LedgerendasLedger 
@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