ATOV_COL_VER_IMP_ITEM

DDL: ATOV_COL_VER_IMP_ITEM SQL: ATO_V_CV_IMPI Type: view

Import-relevant collection version items

ATOV_COL_VER_IMP_ITEM is a CDS View that provides data about "Import-relevant collection version items" in SAP S/4HANA. It reads from 3 data sources (ATOV_CL_ITEM, ATOV_COL_VER_IMP_VER_KEY, ATOV_Cl) and exposes 10 fields with key fields item_type, item_id.

Data Sources (3)

SourceAliasJoin Type
ATOV_CL_ITEM Change_List_Item inner
ATOV_COL_VER_IMP_VER_KEY Collection_Version from
ATOV_Cl Latest_Change_List inner

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName ATO_V_CV_IMPI view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Import-relevant collection version items view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY item_type ATOV_CL_ITEM item_type Type
KEY item_id ATOV_CL_ITEM item_id Simulation Item ID
item_exists ATOV_CL_ITEM item_exists
status ATOV_CL_ITEM status Workflow Status
img_activity ATOV_CL_ITEM img_activity IMG Activity
item_counter ATOV_CL_ITEM item_counter INT4
Adaptation_Type_Texts ATOV_CL_ITEM Adaptation_Type_Texts
Change_List ATOV_CL_ITEM Change_List
Import_Status_Texts ATOV_CL_ITEM Import_Status_Texts
ImgActivityDescription ATOV_CL_ITEM ImgActivityDescription

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 ATOV_COL_VER_IMP_ITEM.
-- 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: ATO_V_CV_IMPI

CREATE VIEW ATOV_COL_VER_IMP_ITEM AS
SELECT
  Change_List_Item.item_type AS item_type,
  Change_List_Item.item_id AS item_id,
  Change_List_Item.item_exists AS item_exists,
  Change_List_Item.status AS status,
  Change_List_Item.img_activity AS img_activity,
  Change_List_Item.item_counter AS item_counter,
  Change_List_Item.Adaptation_Type_Texts AS Adaptation_Type_Texts,
  Change_List_Item.Change_List AS Change_List,
  Change_List_Item.Import_Status_Texts AS Import_Status_Texts,
  Change_List_Item.ImgActivityDescription AS ImgActivityDescription
FROM ATOV_COL_VER_IMP_VER_KEY AS Collection_Version
INNER JOIN ATOV_Cl AS Latest_Change_List ON /* join condition not captured in parsed metadata */
INNER JOIN ATOV_CL_ITEM AS Change_List_Item ON /* join condition not captured in parsed metadata */
;