IC_SelectUJLineItems

DDL: FINS_IC_SPL_ACD_3 SQL: FINSV_IC_ACD_3 Type: view

IC: Selection of UJ line items

IC_SelectUJLineItems is a CDS View that provides data about "IC: Selection of UJ line items" in SAP S/4HANA. It reads from 3 data sources (acdoca, finsc_ld_cmp, IC_AggrSplitLineItems) and exposes 9 fields with key fields rclnt, project_id, rldnr_proj, rldnr, rbukrs.

3 data source(s) 9 fields

Data Sources (3)

SourceAliasJoin Type
acdoca a from
finsc_ld_cmp lc inner
IC_AggrSplitLineItems s inner

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName FINSV_IC_ACD_3 view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XXL view
AbapCatalog.preserveKey true view
EndUserText.label IC: Selection of UJ line items view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY rclnt acdoca rclnt
KEY project_id IC_AggrSplitLineItems project_id
KEY rldnr_proj IC_AggrSplitLineItems rldnr_proj
KEY rldnr acdoca rldnr
KEY rbukrs acdoca rbukrs
KEY belnr acdoca belnr
KEY gjahr acdoca gjahr
KEY buzei acdoca buzei
KEY curtp IC_AggrSplitLineItems curtp 
@AbapCatalog.sqlViewName: 'FINSV_IC_ACD_3'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.sizeCategory: #XXL
@AbapCatalog.preserveKey: true
@EndUserText.label: 'IC: Selection of UJ line items'
define view IC_SelectUJLineItems as select from acdoca as a 

-- Only split line items
inner join IC_AggrSplitLineItems as s  on s.rclnt   =  a.rclnt
                                      and s.rldnr   =  a.rldnr 
                                      and s.rbukrs  =  a.rbukrs
                                      and s.belnr   =  a.belnr                                  
                                      and s.gjahr   =  a.gjahr                                  
                                      and s.buzei   =  a.buzei
                                         
-- Ledger customizing                            
inner join finsc_ld_cmp as lc on lc.mandt = a.rclnt
                             and lc.bukrs = a.rbukrs
                             and lc.rldnr = a.rldnr                                                                          
{ 
key a.rclnt,
key s.project_id,
key s.rldnr_proj,
key a.rldnr,
key a.rbukrs,
key a.belnr,
key a.gjahr,
key a.buzei,
key s.curtp,

case when s.curtp = lc.curtph then a.hsl
     when s.curtp = lc.curtpk then a.ksl
     when s.curtp = lc.curtpo then a.osl  
     when s.curtp = lc.curtpv then a.vsl
     when s.curtp = lc.curtpb then a.bsl
     when s.curtp = lc.curtpc then a.csl
     when s.curtp = lc.curtpd then a.dsl
     when s.curtp = lc.curtpe then a.esl
     when s.curtp = lc.curtpf then a.fsl
     when s.curtp = lc.curtpg then a.gsl  else 0 end as wrbtr
}

Learn More