M_V_INFORECORD_BASIC

CDS View

CDS View for InfoRecords validity

M_V_INFORECORD_BASIC is a CDS View in S/4HANA. CDS View for InfoRecords validity. It contains 3 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 3 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
m_v_inforecord_sos view from MM-PUR: CDS View for SOS

Fields (3)

KeyField CDS FieldsUsed in Views
infnr infnr 1
lifnr lifnr 1
matnr matnr 1 
@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