IC_UnionSplitUJ

DDL: FINS_IC_SPL_ACD_UNION SQL: FINSV_IC_UNION Type: view

IC: Union between UJ and SPL line items

IC_UnionSplitUJ is a CDS View that provides data about "IC: Union between UJ and SPL line items" in SAP S/4HANA. It reads from 2 data sources (IC_AggrSplitLineItems, IC_AggrUJLineItems) and exposes 18 fields with key fields rclnt, project_id, rldnr_proj, rldnr, rbukrs.

2 data source(s) 18 fields

Data Sources (2)

SourceAliasJoin Type
IC_AggrSplitLineItems IC_AggrSplitLineItems from
IC_AggrUJLineItems IC_AggrUJLineItems union_all

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName FINSV_IC_UNION 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: Union between UJ and SPL line items view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY rclnt rclnt
KEY project_id project_id
KEY rldnr_proj rldnr_proj
KEY rldnr rldnr
KEY rbukrs rbukrs
KEY belnr belnr
KEY gjahr gjahr
KEY buzei buzei
KEY curtp curtp
KEY project_id project_id
KEY rldnr_proj rldnr_proj
KEY rldnr rldnr
KEY rbukrs rbukrs
KEY belnr belnr
KEY gjahr gjahr
KEY buzei buzei
KEY curtp curtp
wrbtr 
@AbapCatalog.sqlViewName: 'FINSV_IC_UNION'
@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: Union between UJ and SPL line items'
define view IC_UnionSplitUJ as select from IC_AggrSplitLineItems
{
key rclnt,
key project_id,
key rldnr_proj,
key rldnr,
key rbukrs,
key belnr,
key gjahr,
key buzei,
key curtp,
wrbtr
}
union all select from IC_AggrUJLineItems
{
key rclnt,
key project_id,
key rldnr_proj,
key rldnr,
key rbukrs,
key belnr,
key gjahr,
key buzei,
key curtp,
- wrbtr as wrbtr 
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"IC_AGGRSPLITLINEITEMS",
"IC_AGGRUJLINEITEMS"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More