EHENV_AMNS_EXT

CDS View

Amounts Extended View with Mount text

EHENV_AMNS_EXT is a CDS View in S/4HANA. Amounts Extended View with Mount text. It contains 11 fields. 8 CDS views read from this table.

Used by 8 CDS view(s) 11 fields

CDS Views using this table (8)

ViewTypeJoinVDMDescription
Ehenv_Adef_Amns view from Aggregation Amounts
Ehenv_Adef_Amns_At_Location view from Aggregation Amounts At Location
Ehenv_Cdef_Amns view from Calculation Amounts
Ehenv_Cdef_Amns_At_Location view from Calculation Amounts At Location
Ehenv_Mdef_Amns view from Measurement Amounts
Ehenv_Mdef_Amns_At_Location view from Measurement Amounts At Location
Ehenv_Sdef_Amns view from Sampling Amounts
Ehenv_Sdef_Amns_At_Location view from Sampling Amounts at Location

Fields (11)

KeyField CDS FieldsUsed in Views
amount_key amount_key 8
deviation_id deviation_id 8
external_src external_src 8
preliminary_ind preliminary_ind 8
sourcetype sourcetype 8
status amount_status 8
unit_text unit_text 8
value value 8
value_date value_date 4
value_month_txt value_month_txt 8
valuetimestamp valuetimestamp 8 
@ClientHandling.algorithm: #SESSION_VARIABLE //Inserted by VDM CDS Suite Plugin

@AbapCatalog.sqlViewName: 'EHENVV_AMNS_EXT'
//Commented by VDM CDS Suite Plugin:@ClientDependent: true

@AccessControl.authorizationCheck: #NOT_REQUIRED
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'Amounts Extended View with Mount text'

//CDS View Performance annotation

@ObjectModel.usageType:{ serviceQuality: #P,        // < 15 msec

                         sizeCategory:  #L,         // < 10.000.000

                         dataClass: #MIXED }
                         
define view Ehenv_Amns_Ext with parameters p_langu : lang, 
                                           p_sourcetype : ehfnd_amns_src_type
as select from Ehenv_Amns_Ex( p_langu:$parameters.p_langu )
  left outer join t247 on t247.spras = $parameters.p_langu and t247.mnr = substring(cast(Ehenv_Amns_Ex.valuetimestamp as abap.char(17)), 5, 2)

{
  amount_key,
  fault_ind,
  deviation_id,
  missing_ind,
  notavailable_ind,
  warning_ind,
  preliminary_ind,
  source_root_key_ref,
  status,
  sourcetype,
  external_src,
  cast(substring(cast(Ehenv_Amns_Ex.valuetimestamp as abap.char(17)), 1, 8) as abap.dats) as value_date,
  concat(substring(cast(Ehenv_Amns_Ex.valuetimestamp as abap.char(17)), 5, 2), concat( concat( '(', substring( t247.ktx, 1, 5 )), ')') ) as value_month_txt,
  //concat( Ehenv_Amns_Ex.value_month, concat( concat( '(', substring( t247.ktx, 1, 5 )), ')') ) as value_month_txt,

  value,
  unit_text,
  valueunit,
  valuedimension,
  valuetimestamp,
  remark
  
}        

where Ehenv_Amns_Ex.sourcetype = $parameters.p_sourcetype



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

Learn More