FQM_ACT_STARTDT_A

DDL: FQM_ACT_STARTDT_A Type: view_entity Package: FQM_CORE

FQM Start Date help view

FQM_ACT_STARTDT_A is a CDS View that provides data about "FQM Start Date help view" in SAP S/4HANA. It reads from 3 data sources (fqmc_activation, fqmc_act_startdt, t001) and exposes 4 fields with key field company_code. Part of development package FQM_CORE.

3 data source(s) 4 fields

Data Sources (3)

SourceAliasJoin Type
fqmc_activation a inner
fqmc_act_startdt s left_outer
t001 t001 from

Annotations (5)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label FQM Start Date help view view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #CUSTOMIZING view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY company_code fqmc_activation company_code
butxt t001 butxt
ort01 t001 ort01
land1 t001 land1 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'FQM Start Date help view'
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.usageType.serviceQuality: #A 
@ObjectModel.usageType.dataClass: #CUSTOMIZING
define view  entity FQM_ACT_STARTDT_A  
  as select from t001
  inner join fqmc_activation as a
  on t001.bukrs = a.company_code
  left outer join fqmc_act_startdt as s
  on t001.bukrs = s.company_code
{
key a.company_code ,
  key a.origin_system,
  key a.origin_application,
  t001.butxt,
  t001.ort01,
  t001.land1,
  s.start_value_date,
  s.start_posting_date
   
} where a.activation_status = '1' and a.origin_system = ''

Learn More