fiscds_gllit_01

DDL: FISVD_GLLIT_01 SQL: FISV_GLLIT_01 Type: view

GL Line Item (Leading ledger + other)

fiscds_gllit_01 is a CDS View that provides data about "GL Line Item (Leading ledger + other)" in SAP S/4HANA. It reads from 3 data sources (acdoca, finsc_ld_cmp, finsc_ledger_rep) and exposes 8 fields with key fields rldnr, rbukrs, gjahr, belnr, docln.

3 data source(s) 8 fields

Data Sources (3)

SourceAliasJoin Type
acdoca acdoca from
finsc_ld_cmp finsc_ld_cmp inner
finsc_ledger_rep REP1 inner

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName FISV_GLLIT_01 view
EndUserText.label GL Line Item (Leading ledger + other) view
ObjectModel.usageType.serviceQuality #P view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.buffering.status #NOT_ALLOWED view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY rldnr finsc_ledger_rep rldnr
KEY rbukrs rbukrs
KEY gjahr gjahr
KEY belnr belnr
KEY docln docln
kokrs kokrs
kunnr kunnr
lifnr lifnr 
@AbapCatalog.sqlViewName: 'FISV_GLLIT_01'
@EndUserText.label: 'GL Line Item (Leading ledger + other)'
@ObjectModel.usageType.serviceQuality: #P
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.buffering.status: #NOT_ALLOWED
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
define view  fiscds_gllit_01 as 
select from acdoca 
            inner      join finsc_ledger_rep as REP1 on acdoca.rldnr = REP1.rldnr_pers
            
            inner      join finsc_ld_cmp             on acdoca.rldnr = finsc_ld_cmp.rldnr and acdoca.rbukrs = finsc_ld_cmp.bukrs
                        
//  (2)     inner      join ( finsc_ledger_rep as REP2 inner join finsc_ld_cmp  on REP2.rldnr_pers = finsc_ld_cmp.rldnr  ) 

//                                                                                 on acdoca.rbukrs = finsc_ld_cmp.bukrs and REP1.rldnr_pers = finsc_ld_cmp.rldnr

//          inner      join Fiscds_Ld_Cmp_All on acdoca.rldnr = Fiscds_Ld_Cmp_All.rldnr and acdoca.rbukrs = Fiscds_Ld_Cmp_All.bukrs 

                                           
//          left outer join bkpf              on acdoca.rbukrs = bkpf.bukrs and acdoca.belnr = bkpf.belnr and acdoca.gjahr = bkpf.gjahr    <<<< we start first without BKPF

{
key REP1.rldnr,
key rbukrs,
key gjahr,
key belnr,
key docln,

kokrs,
kunnr,
lifnr

}
        
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"ACDOCA",
"FINSC_LD_CMP",
"FINSC_LEDGER_REP"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More