I_EHSAmountExternalSource

DDL: I_EHSAMOUNTEXTERNALSOURCE Type: view BASIC

External Source

I_EHSAmountExternalSource is a Basic CDS View that provides data about "External Source" in SAP S/4HANA. It reads from 1 data source (I_DataCollectionRootBasic) and exposes 3 fields with key field EHSAmountExternalSource. It has 1 association to related views.

1 data source(s) 3 fields

Data Sources (1)

SourceAliasJoin Type
I_DataCollectionRootBasic I_DataCollectionRootBasic from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_EHSLocationRevision _EHSLocation $projection.EHSLocationUUID = _EHSLocation.EHSLocationUUID and( _EHSLocation.RevisionStartDate <= $session.system_date and _EHSLocation.RevisionEndDate >= $session.system_date )

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IEHSAMNTEXTSRC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
EndUserText.label External Source view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY EHSAmountExternalSource EHSAmountExternalSource
EHSLocationUUID EHSLocationUUID
_EHSLocation _EHSLocation 
@AbapCatalog: { sqlViewName: 'IEHSAMNTEXTSRC',
                compiler.compareFilter: true }

@AccessControl.authorizationCheck: #MANDATORY
@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM.viewType: #BASIC
@ObjectModel.usageType: { dataClass: #MASTER,
                          serviceQuality: #C,
                          sizeCategory: #M }

@EndUserText.label: 'External Source'

/*+[hideWarning] { "IDS" : [ "KEY_CHECK" ] }*/
define view I_EHSAmountExternalSource
  as select from I_DataCollectionRootBasic
  /*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK" ] }*/
  association [1..1] to I_EHSLocationRevision as _EHSLocation on $projection.EHSLocationUUID     = _EHSLocation.EHSLocationUUID
                                                              and(
                                                                _EHSLocation.RevisionStartDate   <= $session.system_date
                                                                and _EHSLocation.RevisionEndDate >= $session.system_date
                                                              )
{
  key EHSAmountExternalSource,
  @ObjectModel.foreignKey.association: null
  EHSLocationUUID,
  /* Associations */
  _EHSLocation
}
where
  EHSAmountExternalSource is not initial

Learn More