UPOV_MIGRATED_MP

DDL: UPO_INT_V_MIGRATED_MP SQL: UPOS_MIGRATED_MP Type: view

Migrated MP

UPOV_MIGRATED_MP is a CDS View that provides data about "Migrated MP" in SAP S/4HANA. It reads from 6 data sources and exposes 13 fields.

Data Sources (6)

SourceAliasJoin Type
oiu_pr_dn_link dn_link inner
oiu_pr_dn_link dn_link inner
oiu_pr_node_dn node_dn inner
oiu_pr_node_dn node_dn inner
oiu_pr_node_mp node_mp inner
oiu_pr_node_mp node_mp inner

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName UPOS_MIGRATED_MP view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Migrated MP view

Fields (13)

KeyFieldSource TableSource FieldDescription
run_id mig_dn run_id UUID
dn_no mig_dn dn_no Delivery network ID
mp_no oiu_pr_node_mp mp_no Measurement Pt
migr_date_to mig_dn migr_date_to Sel End Date
hdr_status mig_dn hdr_status
migr_step_id mig_dn migr_step_id Migration Step
run_id UUID
dn_no mig_dn dn_no Delivery network ID
mp_no oiu_pr_node_mp mp_no Measurement Pt
migr_date_to mig_dn migr_date_to Sel End Date
hdr_status mig_dn hdr_status
migr_step_id mig_dn migr_step_id Migration Step
step_status mig_dn step_status Status

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 UPOV_MIGRATED_MP.
-- 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: UPOS_MIGRATED_MP

CREATE VIEW UPOV_MIGRATED_MP AS
SELECT
  mig_dn.run_id AS run_id,
  mig_dn.dn_no AS dn_no,
  node_mp.mp_no AS mp_no,
  mig_dn.migr_date_to AS migr_date_to,
  mig_dn.hdr_status AS hdr_status,
  mig_dn.migr_step_id AS migr_step_id,
  mig_dn.step_status AS step_status
INNER JOIN oiu_pr_node_dn AS node_dn ON /* join condition not captured in parsed metadata */
INNER JOIN oiu_pr_dn_link AS dn_link ON /* join condition not captured in parsed metadata */
INNER JOIN oiu_pr_node_mp AS node_mp ON /* join condition not captured in parsed metadata */
;