SADL_GW_MDE_DataField

DDL: SADL_GW_MDE_DATAFIELD SQL: V_GW_MDE_DF Type: view

test datafield

SADL_GW_MDE_DataField is a CDS View that provides data about "test datafield" in SAP S/4HANA. It reads from 1 data source (sflight) and exposes 16 fields with key fields mandt, carrid, connid, fldate.

Data Sources (1)

SourceAliasJoin Type
sflight sflight from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName V_GW_MDE_DF view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label test datafield view
Metadata.allowExtensions true view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY mandt mandt
KEY carrid carrid
KEY connid connid
KEY fldate fldate
price price
currency currency
planetype planetype
seatsmax seatsmax
seatsocc seatsocc
paymentsum paymentsum
seatsmax_b seatsmax_b
seatsmax_f seatsmax_f
seatsocc_f seatsocc_f
_Person _Person
_Publication _Publication
seatsocc_b _Person seatsocc_b
@AbapCatalog.sqlViewName: 'V_GW_MDE_DF'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'test datafield'
@Metadata.allowExtensions: true

define view SADL_GW_MDE_DataField 
  as select from sflight
  association[1..*] to SADL_GW_MDE_DATAPOINT as _Publication on $projection.carrid = _Publication.carrid 
  association[1..*] to SADL_GW_MDE_INLINE as _Person on $projection.carrid = _Person.carrid 
  
  {
//sflight 

@UI.hidden: true
key mandt, 
@UI.masked: true
@UI.textArrangement: #TEXT_ONLY
key carrid, 
key connid, 
@UI.textArrangement: #TEXT_FIRST
key fldate,
  @UI.lineItem: [
    { 
      type: #FOR_ACTION, 
      importance: #HIGH, 
      dataAction: 'MPC_EXT:Test' 
     }, 
     { type: #AS_CONTACT,
       value: '_Publication',
       label: 'Contact'
     },
     { type: #AS_CHART,
       value: '_Publication', 
       valueQualifier: 'test' 
      }]

  
price, 

@UI.lineItem: [{ importance:#HIGH, label: 'Country' }]
@UI.fieldGroup: [{ criticality: 'seatsocc_f', type: #STANDARD, groupLabel: 'test' }] 
currency, 
  @UI.facet: [
  { id: '1',       importance: #HIGH,   type: #COLLECTION,             label: 'main'         },
  { id: '2',       importance: #HIGH,   type: #COLLECTION,             purpose: #HEADER      },
  { id: '2.1',     importance: #HIGH,   type: #LINEITEM_REFERENCE,     parentId: '2',     targetQualifier: 'tq0',targetElement: '_Person'  },
  { id: '2.2',     importance: #MEDIUM, type: #COLLECTION,             parentId: '2',     isMap: true           },
  { id: '2.2.1',   importance: #HIGH,   type: #COLLECTION,             parentId: '2.2',   targetElement: 'te'   },
  { id: '2.2.1.1', importance: #HIGH,   type: #CONTACT_REFERENCE,      parentId: '2.2.1', targetElement: '_Publication'   },
  { id: '2.2.2',   importance: #MEDIUM, type: #DATAPOINT_REFERENCE,    parentId: '2.2',   targetQualifier: 'tq' },
  { id: '3',       importance: #LOW,    type: #COLLECTION, label: 'x', purpose: #QUICK_VIEW  }]
planetype, 
  @UI.selectionField: [{ position: 1 }]
seatsmax, 
  @UI.selectionField: [
    { position: 2 } ]
seatsocc, 
paymentsum, 
@UI.lineItem: [{ type: #AS_DATAPOINT, value: '_Person.seatsmax_b' }]
seatsmax_b, 

seatsmax_f, 
  @UI.lineItem: [{ 
    qualifier: 'q',  
    importance: #HIGH, 
    type: #AS_CHART,
    label: 'Person',
    value: '_Person'
      }]
seatsocc_f,

@UI.selectionField: [ { position: 3, element: '_Person.carrid' } ]
  _Person,
@UI.selectionField: [{ position: 4, element: '_Publication.carrid' } ]
  _Publication,
  
@UI.lineItem: [{ type: #STANDARD, label: 'assoc_elem', criticality: 'seatsocc' }]
  _Person.seatsocc_b
  
  
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"SADL_GW_MDE_INLINE",
"SFLIGHT"
],
"ASSOCIATED":
[
"SADL_GW_MDE_DATAPOINT",
"SADL_GW_MDE_INLINE"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/