P_MfgBusinessPartner

DDL: P_MFGBUSINESSPARTNER SQL: PMFGBP Type: view BASIC
8 Fields 1 Data Sources

P_MfgBusinessPartner is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (mpev_usr_profile) and exposes 8 fields with key field MfgBusinessPartner.

Data Sources (1)

SourceAliasJoin Type
mpev_usr_profile mpev_usr_profile from

Annotations (9)

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

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY MfgBusinessPartner mfgbusinesspartner Bus Part
WorkCenter workcenter Work Center
Plant plant Valuation Area
CreatedByUser createdbyuser User Name
CreationDateTime creationdatetime Timestamp
LastChangeDateTime lastchangedatetime Timestamp
LastChangedByUser lastchangedbyuser User Name
CurrentDateTime

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_MfgBusinessPartner.
-- 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: PMFGBP

CREATE VIEW P_MfgBusinessPartner AS
SELECT
  MfgBusinessPartner,
  WorkCenter,
  Plant,
  CreatedByUser,
  CreationDateTime,
  LastChangeDateTime,
  LastChangedByUser,
  tstmp_current_utctimestamp() AS CurrentDateTime
FROM mpev_usr_profile
;

Learn More