FINSCDS_F4_LDKOKRS

DDL: FINSVD_F4_RLDNR_FOR_KOKRS SQL: FINSV_F4_LDKOKRS Type: view

Value help view: Ledger for Controlling Area

FINSCDS_F4_LDKOKRS is a CDS View that provides data about "Value help view: Ledger for Controlling Area" in SAP S/4HANA. It reads from 5 data sources (finsc_actve_appl, finsc_ld_cmp, finsc_ledger_t, t001, tka02) and exposes 5 fields with key fields mandt, rldnr, kokrs. It has 1 association to related views.

5 data source(s) 5 fields

Data Sources (5)

SourceAliasJoin Type
finsc_actve_appl finsc_actve_appl inner
finsc_ld_cmp finsc_ld_cmp inner
finsc_ledger_t finsc_ledger_t left_outer
t001 t001 inner
tka02 tka02 inner

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_LedgerTypeText _ledger_type_name $projection.ledger_type = _ledger_type_name.LedgerType

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName FINSV_F4_LDKOKRS view
ClientDependent true view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Value help view: Ledger for Controlling Area view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY mandt finsc_ld_cmp mandt
KEY rldnr finsc_ld_cmp rldnr
KEY kokrs tka02 kokrs
name finsc_ledger_t name
ledger_type finsc_ledger ledger_type 
@AbapCatalog.sqlViewName: 'FINSV_F4_LDKOKRS'
@ClientDependent: true
@AbapCatalog.compiler.compareFilter: true
//@AccessControl.authorizationCheck: #CHECK commented out because there is no DCL and it is customizing table access only

@EndUserText.label: 'Value help view: Ledger for Controlling Area'
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.usageType.dataClass:  #MASTER
@ObjectModel.usageType.serviceQuality: #C
define view FINSCDS_F4_LDKOKRS as select distinct

from  finsc_ledger  

inner join finsc_ld_cmp  on  finsc_ld_cmp.mandt = finsc_ledger.mandt
                         and finsc_ld_cmp.rldnr = finsc_ledger.rldnr

inner join t001   on    t001.mandt = finsc_ld_cmp.mandt
                  and   t001.bukrs = finsc_ld_cmp.bukrs
                                             
inner join finsc_actve_appl
      on   finsc_actve_appl.mandt   = finsc_ledger.mandt
      and  finsc_actve_appl.appl    = finsc_ledger.appl
      and  finsc_actve_appl.subappl = finsc_ledger.subappl
    
inner join tka02  on  tka02.mandt = finsc_ld_cmp.mandt
                  and tka02.bukrs = finsc_ld_cmp.bukrs

left outer join finsc_ledger_t  on  finsc_ledger_t.mandt = finsc_ledger.mandt
                                and finsc_ledger_t.rldnr = finsc_ledger.rldnr 
                                and finsc_ledger_t.langu = $session.system_language
                                                                     
association [0..*] to I_LedgerTypeText     as _ledger_type_name     on  $projection.ledger_type   = _ledger_type_name.LedgerType
 
{
  key finsc_ld_cmp.mandt,
  key finsc_ld_cmp.rldnr,
  key tka02.kokrs,
      finsc_ledger_t.name,
      finsc_ledger.ledger_type,
      cast( _ledger_type_name[1:Language=$session.system_language].LedgerTypeName as fins_ledger_type_name ) as ledgertypename //to have a smaller column in value help for text

}
 
where t001.kokfi = '1' or t001.kokfi = '2'  //same logic as in function module RK_KOKRS_FIND, exclude Bukrs with DB mismatch

   
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_LEDGERTYPETEXT",
"FINSC_ACTVE_APPL",
"FINSC_LD_CMP",
"FINSC_LEDGER",
"FINSC_LEDGER_T",
"T001",
"TKA02"
],
"ASSOCIATED":
[
"I_LEDGERTYPETEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More