ars_v_xpra_objs_to_be_migrated

DDL: ARS_V_XPRA_OBJS_TO_BE_MIGRATED SQL: ARS_V_XPRA_MIG Type: view Package: S_ARS_DB_MIGRATION

API Release: Objs to be migrated by XPRA

ars_v_xpra_objs_to_be_migrated is a CDS View that provides data about "API Release: Objs to be migrated by XPRA" in SAP S/4HANA. It reads from 2 data sources (ars_w_api, ars_v_xpra_classif_objs) and exposes 21 fields with key fields object_type, object_name, contract, visibility. Part of development package S_ARS_DB_MIGRATION.

Data Sources (2)

SourceAliasJoin Type
ars_w_api new left_outer
ars_v_xpra_classif_objs old from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName ARS_V_XPRA_MIG view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label API Release: Objs to be migrated by XPRA view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY object_type ars_v_xpra_classif_objs object_type Type
KEY object_name ars_v_xpra_classif_objs object_name Technical Name
KEY contract ars_v_xpra_classif_objs contract Trading Contract
KEY visibility ars_v_xpra_classif_objs visibility Visibility
changed_by ars_v_xpra_classif_objs changed_by User Name
changed_at ars_v_xpra_classif_objs changed_at Timestamp
author ars_v_xpra_classif_objs author User Name
srcdep ars_v_xpra_classif_objs srcdep Repair Flag
genflag ars_v_xpra_classif_objs genflag Generation Flag
edtflag ars_v_xpra_classif_objs edtflag Editable
cproject ars_v_xpra_classif_objs cproject Internal Use
masterlang ars_v_xpra_classif_objs masterlang Single-Character Flag
versid ars_v_xpra_classif_objs versid Version number
paknocheck ars_v_xpra_classif_objs paknocheck Check exception
objstablty ars_v_xpra_classif_objs objstablty Deployment Target
crelease ars_v_xpra_classif_objs crelease SAP Release
delflag ars_v_xpra_classif_objs delflag Yes/No (X/ )
translttxt ars_v_xpra_classif_objs translttxt Translate
created_on ars_v_xpra_classif_objs created_on Variant created on
check_date ars_v_xpra_classif_objs check_date Ck Clr.Time
check_cfg ars_v_xpra_classif_objs check_cfg Check Configuration

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 ars_v_xpra_objs_to_be_migrated.
-- 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: ARS_V_XPRA_MIG

CREATE VIEW ars_v_xpra_objs_to_be_migrated AS
SELECT
  old.object_type AS object_type,
  old.object_name AS object_name,
  old.contract AS contract,
  old.visibility AS visibility,
  old.changed_by AS changed_by,
  old.changed_at AS changed_at,
  old.author AS author,
  old.srcdep AS srcdep,
  old.genflag AS genflag,
  old.edtflag AS edtflag,
  old.cproject AS cproject,
  old.masterlang AS masterlang,
  old.versid AS versid,
  old.paknocheck AS paknocheck,
  old.objstablty AS objstablty,
  old.crelease AS crelease,
  old.delflag AS delflag,
  old.translttxt AS translttxt,
  old.created_on AS created_on,
  old.check_date AS check_date,
  old.check_cfg AS check_cfg
FROM ars_v_xpra_classif_objs AS old
LEFT OUTER JOIN ars_w_api AS new ON /* join condition not captured in parsed metadata */
;