ICA_PROFITCENTER

DDL: ICA_PROFITCENTER SQL: ICAPRCTR Type: view

ICA_PROFITCENTER is a CDS View in SAP S/4HANA. It reads from 2 data sources (cepc, cepct) and exposes 3 fields.

2 data source(s) 3 fields

Data Sources (2)

SourceAliasJoin Type
cepc cepc from
cepct cepct left_outer

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName ICAPRCTR view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #M view

Fields (3)

KeyFieldSource TableSource FieldDescription
kokrs cepc kokrs
prctr cepc prctr
unitName cepct ltext 
@AbapCatalog.sqlViewName: 'ICAPRCTR'
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.sizeCategory: #M
define view ICA_PROFITCENTER 
as select from cepc
 left outer join cepct on cepct.prctr = cepc.prctr 
                      and cepct.kokrs = cepc.kokrs 
                      and cepct.datbi = cepc.datbi
                      and cepct.spras = $session.system_language
 {
    cepc.kokrs,
    cepc.prctr,
    cepct.ltext as unitName
} where cepc.mandt = $session.client
    and cepc.datab <= $session.system_date
    and cepc.datbi >= $session.system_date
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"CEPC",
"CEPCT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More