C_FldLogsGoodsMvtTypeVH

DDL: C_FLDLOGSGOODSMVTTYPEVH SQL: CFLMVTTYPEVH Type: view CONSUMPTION

Field Logistics:Goods Movement type Value help

C_FldLogsGoodsMvtTypeVH is a Consumption CDS View that provides data about "Field Logistics:Goods Movement type Value help" in SAP S/4HANA. It reads from 1 data source (I_GoodsMovementType) and exposes 3 fields with key fields GoodsMovementType, GoodsMovementTypeName. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_GoodsMovementType I_GoodsMovementType from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_GoodsMovementTypeT _GoodsMovementTypeT $projection.GoodsMovementType = _GoodsMovementTypeT.GoodsMovementType and _GoodsMovementTypeT.Language = $session.system_language

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CFLMVTTYPEVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Field Logistics:Goods Movement type Value help view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.resultSet.sizeCategory #XS view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY GoodsMovementType GoodsMovementType
KEY GoodsMovementTypeName _GoodsMovementTypeT GoodsMovementTypeName
FldLogsItmIsFailed
@AbapCatalog.sqlViewName: 'CFLMVTTYPEVH'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Field Logistics:Goods Movement type Value help'
@VDM.viewType: #CONSUMPTION
@ObjectModel : {
usageType: { dataClass: #MASTER,
                          serviceQuality: #C,
                          sizeCategory: #S } }
@ObjectModel.resultSet.sizeCategory: #XS
@ClientHandling.algorithm: #SESSION_VARIABLE
define view C_FldLogsGoodsMvtTypeVH
  as select from I_GoodsMovementType
  association [0..1] to I_GoodsMovementTypeT as _GoodsMovementTypeT on  $projection.GoodsMovementType = _GoodsMovementTypeT.GoodsMovementType
                                                                    and _GoodsMovementTypeT.Language  = $session.system_language
{
      @ObjectModel.text.element: 'GoodsMovementTypeName'
  key GoodsMovementType,
  key _GoodsMovementTypeT.GoodsMovementTypeName,
      //  key Language,

      case when GoodsMovementType = '101' or GoodsMovementType = '103' or GoodsMovementType = '107'
      then cast('X' as boolean )
      else cast(' ' as boolean ) end as FldLogsItmIsToBeReceived,
      //      @UI.hidden: true

      case when GoodsMovementType = '105' or GoodsMovementType = '109'
      then cast('X' as boolean )
      else cast(' ' as boolean ) end as FldLogsItmIsPreReceived,
      //      @UI.hidden: true

      cast('X' as boolean )          as FldLogsItmIsFailed

}
where
  (
       GoodsMovementType = '101'
    or GoodsMovementType = '103'
    or GoodsMovementType = '105'
    or GoodsMovementType = '107'
    or GoodsMovementType = '109'
  )
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_GOODSMOVEMENTTYPE",
"I_GOODSMOVEMENTTYPET"
],
"ASSOCIATED":
[
"I_GOODSMOVEMENTTYPET"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/