M_V_Inforecord_Basic

DDL: M_V_INFORECORD_BASIC SQL: CDS_M_IR_BASIC Type: view

CDS View for InfoRecords validity

M_V_Inforecord_Basic is a CDS View that provides data about "CDS View for InfoRecords validity" in SAP S/4HANA. It reads from 1 data source (eina) and exposes 7 fields with key field infnr. It has 1 association to related views.

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
eina eina from

Associations (1)

CardinalityTargetAliasCondition
[1..*] eine _eine $projection.infnr = _eine.infnr

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName CDS_M_IR_BASIC view
EndUserText.label CDS View for InfoRecords validity view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY infnr eina infnr
matnr matnr
lifnr lifnr
umren umren
umrez umrez
loekz loekz
_eine _eine 
@AbapCatalog.sqlViewName: 'CDS_M_IR_BASIC'
@EndUserText.label: 'CDS View for InfoRecords validity'
@AccessControl.authorizationCheck: #CHECK

@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL

define view M_V_Inforecord_Basic as select from eina 
// association added for cds hardening

association [1..*] to eine as _eine on $projection.infnr = _eine.infnr{
  key eina.infnr,
  case eina.lifab
  when '00000000' then '00000000'
  else eina.lifab
  end as lifab,
  case eina.lifbi
  when '00000000' then '99991231'
  else eina.lifbi
  end as lifbi,
  matnr,
  lifnr,
  umren,
  umrez,
  loekz,
  _eine
} 
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"EINA"
],
"ASSOCIATED":
[
"EINE"
],
"BASE":
[],
"VERSION":0
}
}*/

Learn More