UPOV_MIGRATED_DN_STAT_FC

DDL: UPO_INT_V_MIGRATED_DN_STAT_FC SQL: UPOS_MIG_DNFC Type: view
4 Fields 1 Data Sources

Migrated DN with status F & C

UPOV_MIGRATED_DN_STAT_FC is a CDS View that provides data about "Migrated DN with status F & C" in SAP S/4HANA. It reads from 1 data source (upot_mig_run_hd) and exposes 4 fields with key fields dn_no, run_id.

Data Sources (1)

SourceAliasJoin Type
upot_mig_run_hd mig_hd inner

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName UPOS_MIG_DNFC 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 DN with status F & C view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY dn_no mig_dn dn_no Delivery network ID
KEY run_id mig_dn run_id UUID
migr_date_to upot_mig_run_hd migr_date_to Sel End Date
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_DN_STAT_FC.
-- 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_MIG_DNFC

CREATE VIEW UPOV_MIGRATED_DN_STAT_FC AS
SELECT
  mig_dn.dn_no AS dn_no,
  mig_dn.run_id AS run_id,
  mig_hd.migr_date_to AS migr_date_to,
  cast(mig_hd.status as upo_mig_status) AS status
INNER JOIN upot_mig_run_hd AS mig_hd ON /* join condition not captured in parsed metadata */
;

Learn More