fco_cokey

DDL: FCO_COKEY Type: view_entity

Fields from cokey cokey2 tables

fco_cokey is a CDS View that provides data about "Fields from cokey cokey2 tables" in SAP S/4HANA. It reads from 2 data sources (cokey, cokey2) and exposes 25 fields with key field hrkft.

2 data source(s) 25 fields

Data Sources (2)

SourceAliasJoin Type
cokey origin from
cokey2 origin2 left_outer

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Fields from cokey cokey2 tables view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY hrkft cokey hrkft
werks cokey werks
matnr cokey matnr
hkgrp cokey hkgrp
pcver cokey pcver
cbrke cokey cbrke
cbrki cokey cbrki
cbart cokey cbart
drvtp cokey drvtp
cbat cokey cbat
recind cokey recind
bemot cokey bemot
pernr cokey pernr
rsrce cokey rsrce
fkber cokey2 fkber
pfkber cokey2 pfkber
geber cokey2 geber
pgeber cokey2 pgeber
grant_nbr cokey2 grant_nbr
pgrant_nbr cokey2 pgrant_nbr
segment cokey2 segment
psegment cokey2 psegment
budget_pd cokey2 budget_pd
pbudget_pd cokey2 pbudget_pd
prodper cokey2 prodper 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Fields from cokey cokey2 tables'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
define view entity fco_cokey
  as select from    cokey  as origin
    left outer join cokey2 as origin2 on origin2.subkey2 = origin.subkey2
{
  key origin.hrkft,
      origin.werks,
      origin.matnr,
      origin.hkgrp,
      origin.pcver,
      origin.cbrke,
      origin.cbrki,
      origin.cbart,
      origin.drvtp,
      origin.cbat,
      origin.recind,
      origin.bemot,
      origin.pernr,
      origin.rsrce,
      origin2.fkber,
      origin2.pfkber,
      origin2.geber,
      origin2.pgeber,
      origin2.grant_nbr,
      origin2.pgrant_nbr,
      origin2.segment,
      origin2.psegment,
      origin2.budget_pd,
      origin2.pbudget_pd,
      origin2.prodper

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"COKEY",
"COKEY2"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More