fac_opp_cds_co_ctrl_area

DDL: FAC_OPP_CDS_CO_CTRL_AREA SQL: FACOPPV_CO_KOKRS Type: view

CDS View For CO Controlling Area

fac_opp_cds_co_ctrl_area is a CDS View that provides data about "CDS View For CO Controlling Area" in SAP S/4HANA. It reads from 2 data sources (t009, tka01) and exposes 2 fields with key field ctrl_area.

2 data source(s) 2 fields

Data Sources (2)

SourceAliasJoin Type
t009 t009 inner
tka01 tka01 from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName FACOPPV_CO_KOKRS view
ClientHandling.type #CLIENT_DEPENDENT view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label CDS View For CO Controlling Area view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY ctrl_area tka01 kokrs
fyv t009 periv 
@AbapCatalog.sqlViewName: 'FACOPPV_CO_KOKRS'
@ClientHandling.type: #CLIENT_DEPENDENT
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'CDS View For CO Controlling Area'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.dataClass:  #MIXED
@ObjectModel.usageType.serviceQuality: #C

define view fac_opp_cds_co_ctrl_area

  as select from tka01
    inner join   t009 on tka01.lmona = t009.periv
{
  key tka01.kokrs as ctrl_area,

      tka01.bezei as ctrl_area_descr,

      t009.periv  as fyv,

      t009.anzbp as normal_periods,
      t009.anzsp as special_periods,
      
      cast( t009.anzbp as abap.int1) + cast( t009.anzsp as abap.int1) as total_periods
      
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"T009",
"TKA01"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More