FQM_ACT_STARTDT_A

DDL: FQM_ACT_STARTDT_A SQL: FQMSTARTDT_S Type: view

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 5 fields with key fields mandt, company_code.

3 data source(s) 5 fields

Data Sources (3)

SourceAliasJoin Type
fqmc_activation a inner
fqmc_act_startdt s left_outer
t001 t001 from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName FQMSTARTDT_S view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
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 (5)

KeyFieldSource TableSource FieldDescription
KEY mandt fqmc_activation mandt
KEY company_code fqmc_activation company_code
butxt t001 butxt
ort01 t001 ort01
land1 t001 land1 
@AbapCatalog.sqlViewName: 'FQMSTARTDT_S'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@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  FQM_ACT_STARTDT_A  
  as select from t001
  inner join fqmc_activation as a
  on t001.bukrs = a.company_code
     and t001.mandt = a.mandt
  left outer join fqmc_act_startdt as s
  on t001.bukrs = s.company_code
     and t001.mandt = s.mandt
{
  key a.mandt,
  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 = ''
 
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"FQMC_ACTIVATION",
"FQMC_ACT_STARTDT",
"T001"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More