P_DDMRPController

DDL: P_DDMRPCONTROLLER Type: view_entity BASIC Package: ODATA_PP_DD_ORD_DET

MRP Controller Details

P_DDMRPController is a Basic CDS View that provides data about "MRP Controller Details" in SAP S/4HANA. It reads from 6 data sources and exposes 9 fields with key fields Plant, MRPController. Part of development package ODATA_PP_DD_ORD_DET.

6 data source(s) 9 fields

Data Sources (6)

SourceAliasJoin Type
adr6 _email left_outer
adrp _name left_outer
adr2 _phone left_outer
t024d _t024d from
usr02 _usr02 left_outer
usr21 _usr21 left_outer

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
VDM.private true view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY Plant t024d werks
KEY MRPController t024d dispo
MRPControllerName t024d dsnam
RecipientType t024d usrtyp
UserID usr21 bname
UserGroup usr02 class
InternalContactName adrp name_text
dstelendasPhoneNumber
EmailAddress adr6 smtp_addr 
@AccessControl.authorizationCheck: #CHECK
//@EndUserText.label: 'MRP Controller Details'

@VDM.private: true
@VDM.viewType: #BASIC
@ObjectModel.usageType: {serviceQuality: #X, sizeCategory: #XL, dataClass: #MASTER}
define view entity P_DDMRPController
  as select from    t024d as _t024d
    left outer join usr02 as _usr02 on  _t024d.usrkey = _usr02.bname
                                    and _t024d.usrtyp = 'US'
    left outer join usr21 as _usr21 on _usr02.bname = _usr21.bname
    left outer join adrp  as _name  on _usr21.persnumber = _name.persnumber
    left outer join adr2  as _phone on  _phone.addrnumber = _usr21.addrnumber
                                    and _phone.persnumber = _usr21.persnumber
                                    and _phone.flgdefault = 'X'
    left outer join adr6  as _email on  _email.addrnumber = _usr21.addrnumber
                                    and _email.persnumber = _usr21.persnumber
{
  key _t024d.werks                                               as Plant,
  key _t024d.dispo                                               as MRPController,
      _t024d.dsnam                                               as MRPControllerName,
      _t024d.usrtyp                                              as RecipientType,
      _usr21.bname                                               as UserID,
      @Consumption.hidden: true
      _usr02.class                                               as UserGroup,
      _name.name_text                                            as InternalContactName,
      case
      when _t024d.usrtyp = 'US'
      then concat_with_space(_phone.tel_number,_phone.tel_extens, 1)
      else _t024d.dstel
      end                                                        as PhoneNumber,
      _email.smtp_addr                                           as EmailAddress
}

Learn More