FCO_COST_EST_ACDOCP_SDM

DDL: FCO_COST_EST_ACDOCP_SDM SQL: FCOCOSTESTSDM1 Type: view

Cost Estimate with group acdocp fields

FCO_COST_EST_ACDOCP_SDM is a CDS View that provides data about "Cost Estimate with group acdocp fields" in SAP S/4HANA. It reads from 1 data source (acdocp) and exposes 6 fields with key fields pmatnr, werks, budat, kdauf, kdpos.

1 data source(s) 6 fields

Data Sources (1)

SourceAliasJoin Type
acdocp acdocp from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName FCOCOSTESTSDM1 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Cost Estimate with group acdocp fields view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY pmatnr pmatnr
KEY werks werks
KEY budat budat
KEY kdauf kdauf
KEY kdpos kdpos
KEY category category 
@AbapCatalog.sqlViewName: 'FCOCOSTESTSDM1'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Cost Estimate with group acdocp fields'
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MIXED
define view FCO_COST_EST_ACDOCP_SDM
  as select from acdocp
{
  key pmatnr,
  key werks,
  key budat,
  //key costg_from_date,

  //key costg_to_date,

  key kdauf,
  key kdpos,
  key category
}
where
       pmatnr   is not initial
  and(
       category = 'PLANORD02'
    or category = 'PLANORD03'
  )
  and  aufnr    is initial
group by
  pmatnr,
  werks,
  budat,
  //costg_from_date,

  //costg_to_date,

  kdauf,
  kdpos,
  category
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ACDOCP"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More