FAC_P_PROFIT_CENTER

DDL: FAC_P_PROFIT_CENTER SQL: PFACPC Type: view Package: FINS_GEN_UTILS

private view for profit center

FAC_P_PROFIT_CENTER is a CDS View that provides data about "private view for profit center" in SAP S/4HANA. It reads from 5 data sources (cepc_bukrs, cepc_bukrs, tka02, cepc, cepc) and exposes 11 fields with key fields prctr, datbi, kokrs, bukrs, datbi. Part of development package FINS_GEN_UTILS.

5 data source(s) 11 fields

Data Sources (5)

SourceAliasJoin Type
cepc_bukrs _CompanyCodeAssignment from
cepc_bukrs _CompanyCodeAssignment left_outer
tka02 _CompanyCodeControllingAreaMap inner
cepc _ProfitCenterMasterData inner
cepc _ProfitCenterMasterData union_all

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PFACPC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label private view for profit center view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY prctr cepc prctr
KEY datbi cepc datbi
KEY kokrs cepc kokrs
KEY bukrs cepc_bukrs bukrs
verak cepc verak
prctr
KEY datbi cepc datbi
KEY kokrs cepc kokrs
KEY bukrs tka02 bukrs
verak cepc verak
verak_user cepc verak_user 
@AbapCatalog.sqlViewName: 'PFACPC'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'private view for profit center'
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType: {
  serviceQuality: #C,
  sizeCategory: #M,
  dataClass: #MASTER
}

define view FAC_P_PROFIT_CENTER
  as select from    cepc_bukrs as _CompanyCodeAssignment
    inner join      cepc       as _ProfitCenterMasterData     on  _ProfitCenterMasterData.kokrs = _CompanyCodeAssignment.kokrs
                                                              and _ProfitCenterMasterData.prctr = _CompanyCodeAssignment.prctr
{
  key _ProfitCenterMasterData.prctr,
  key _ProfitCenterMasterData.datbi,
  key _ProfitCenterMasterData.kokrs,
  key _CompanyCodeAssignment.bukrs,
      
      _ProfitCenterMasterData.verak,
      _ProfitCenterMasterData.verak_user
      
}
where _ProfitCenterMasterData.datbi >= $session.system_date
  and  _ProfitCenterMasterData.datab <= $session.system_date
union all

select from       cepc       as _ProfitCenterMasterData
  inner join      tka02      as _CompanyCodeControllingAreaMap on _CompanyCodeControllingAreaMap.kokrs = _ProfitCenterMasterData.kokrs
  left outer join cepc_bukrs as _CompanyCodeAssignment         on  _ProfitCenterMasterData.kokrs = _CompanyCodeAssignment.kokrs
                                                               and _ProfitCenterMasterData.prctr = _CompanyCodeAssignment.prctr

{
  key _ProfitCenterMasterData.prctr,
  key _ProfitCenterMasterData.datbi,
  key _ProfitCenterMasterData.kokrs,
  key _CompanyCodeControllingAreaMap.bukrs,
      
      _ProfitCenterMasterData.verak,
      _ProfitCenterMasterData.verak_user
      
}
where (_ProfitCenterMasterData.datbi >= $session.system_date
  and  _ProfitCenterMasterData.datab <= $session.system_date )
  and (_CompanyCodeAssignment.bukrs  is null or _CompanyCodeAssignment.bukrs  = '' )

Learn More