P_MfgOpActyTeamUserAssgmt

DDL: P_MFGOPACTYTEAMUSERASSGMT SQL: POATEAMUSRASSGMT Type: view COMPOSITE
4 Fields 4 Data Sources

P_MfgOpActyTeamUserAssgmt is a Composite CDS View in SAP S/4HANA. It reads from 4 data sources (I_User, I_OpActyRespyMgmtTeamAssgmtBsc, I_BusinessPartner, I_RespyMgmtTeamMember) and exposes 4 fields with key fields OpActyNtwkInstance, OpActyNtwkElement, UserID.

Data Sources (4)

SourceAliasJoin Type
I_User BPUser inner
I_OpActyRespyMgmtTeamAssgmtBsc OpActyRespyMgmtTeamAssgmtBsc from
I_BusinessPartner Partner inner
I_RespyMgmtTeamMember TeamMember inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName POATEAMUSRASSGMT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY OpActyNtwkInstance I_OpActyRespyMgmtTeamAssgmtBsc OpActyNtwkInstance Instance ID
KEY OpActyNtwkElement I_OpActyRespyMgmtTeamAssgmtBsc OpActyNtwkElement Element Number
KEY UserID I_User UserID User Name
MfgOpActyExecutionPriority

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_MfgOpActyTeamUserAssgmt.
-- 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: POATEAMUSRASSGMT

CREATE VIEW P_MfgOpActyTeamUserAssgmt AS
SELECT
  OpActyRespyMgmtTeamAssgmtBsc.OpActyNtwkInstance AS OpActyNtwkInstance,
  OpActyRespyMgmtTeamAssgmtBsc.OpActyNtwkElement AS OpActyNtwkElement,
  BPUser.UserID AS UserID,
  max( OpActyRespyMgmtTeamAssgmtBsc.MfgOpActyExecutionPriority) AS MfgOpActyExecutionPriority
FROM I_OpActyRespyMgmtTeamAssgmtBsc AS OpActyRespyMgmtTeamAssgmtBsc
INNER JOIN I_RespyMgmtTeamMember AS TeamMember ON /* join condition not captured in parsed metadata */
INNER JOIN I_BusinessPartner AS Partner ON /* join condition not captured in parsed metadata */
INNER JOIN I_User AS BPUser ON /* join condition not captured in parsed metadata */
;

Learn More