Ehhss_Sampling_Amounts

DDL: EHHSS_SAMPLING_AMOUNTS SQL: EHHSSV_SPLNGAMNT Type: view

Amounts of a Sampling

Ehhss_Sampling_Amounts is a CDS View that provides data about "Amounts of a Sampling" in SAP S/4HANA. It reads from 1 data source (ehfndd_amns_root) and exposes 4 fields.

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
ehfndd_amns_root ehfndd_amns_root from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName EHHSSV_SPLNGAMNT view
EndUserText.label Amounts of a Sampling view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (4)

KeyFieldSource TableSource FieldDescription
subjecttype ehfndd_amns_root subjecttype
value ehfndd_amns_root value
valueunit ehfndd_amns_root valueunit
valuetype ehfndd_amns_root valuetype 
@AbapCatalog.sqlViewName: 'EHHSSV_SPLNGAMNT'
@EndUserText.label: 'Amounts of a Sampling'

// Client handling by session 

@ClientHandling.algorithm: #SESSION_VARIABLE

// this view is not directly consumed

@AccessControl.authorizationCheck: #NOT_REQUIRED

// used for BOBF Transactional Data Object

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

                         sizeCategory:  #L,         // < 10.000.000

                         dataClass: #TRANSACTIONAL }

define view Ehhss_Sampling_Amounts 
                  
// IMPORTANT: ensure that parameters are alphabetically sorted in order for the View to work on HANA prior to SP10    


as select from ehfndd_amns_root 
 
{
    key ehfndd_amns_root.db_key as amount_root_key,

    ehfndd_amns_root.source_root_key_ref,
    ehfndd_amns_root.subject_root_key_ref,
    ehfndd_amns_root.subjecttype,
    ehfndd_amns_root.value,
    ehfndd_amns_root.valueunit,
    ehfndd_amns_root.valuetype,
    ehfndd_amns_root.amountcategory,
    ehfndd_amns_root.valuetimestamp,
//  Begin correction 2535504 18.09.2017 

    ehfndd_amns_root.outofpreciseness_operator
//  End correction 2535504 18.09.2017       

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

Learn More