P_DDMRPController

DDL: P_DDMRPCONTROLLER SQL: PDDMRPCONT Type: view BASIC
9 Fields 6 Data Sources

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.

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 Receiving Plant
KEY MRPController t024d dispo MRP Controller
MRPControllerName t024d dsnam Name
RecipientType t024d usrtyp User Type
UserID usr21 bname User name
UserGroup usr02 class User Group
InternalContactName adrp name_text Full Name
dstelendasPhoneNumber
EmailAddress adr6 smtp_addr E-Mail Address

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_DDMRPController.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: PDDMRPCONT

CREATE VIEW P_DDMRPController AS
SELECT
  _t024d.werks AS Plant,
  _t024d.dispo AS MRPController,
  _t024d.dsnam AS MRPControllerName,
  _t024d.usrtyp AS RecipientType,
  _usr21.bname AS UserID,
  _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 AS dstelendasPhoneNumber,
  _email.smtp_addr AS EmailAddress
FROM t024d AS _t024d
LEFT OUTER JOIN usr02 AS _usr02 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN usr21 AS _usr21 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN adrp AS _name ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN adr2 AS _phone ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN adr6 AS _email ON /* join condition not captured in parsed metadata */
;

Learn More