P_DDMRPController

DDL: P_DDMRPCONTROLLER SQL: PDDMRPCONT Type: view BASIC

P_DDMRPController is a Basic CDS View in SAP S/4HANA. It reads from 6 data sources and exposes 9 fields with key fields Plant, MRPController.

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 (9)

NameValueLevelField
AbapCatalog.sqlViewName PDDMRPCONT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.private true view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE 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 
@AbapCatalog.sqlViewName: 'PDDMRPCONT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
//@EndUserText.label: 'MRP Controller Details'

@VDM.private: true
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {serviceQuality: #X, sizeCategory: #XL, dataClass: #MASTER}
define view 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
}

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ADR2",
"ADR6",
"ADRP",
"T024D",
"USR02",
"USR21"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More