ATOV_ST_CURRENT_COL_ITEM_CBOM

DDL: ATOV_ST_CURRENT_COL_ITEM_CBOM SQL: ATO_V_ST_CBOM Type: view Package: S_ATO_SYSTEM_TRANSFER

Current collection conti boms

ATOV_ST_CURRENT_COL_ITEM_CBOM is a CDS View that provides data about "Current collection conti boms" in SAP S/4HANA. It reads from 6 data sources and exposes 6 fields with key fields item_counter, bom_pgmid, bom_object. Part of development package S_ATO_SYSTEM_TRANSFER.

6 data source(s) 6 fields

Data Sources (6)

SourceAliasJoin Type
ato_conti_bom bom inner
ato_changel_item item inner
ATOV_ST_RELEVANT_ITEMS latest_item_cl from
ato_changelists list inner
objh objh left_outer
tadir tadir left_outer

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName ATO_V_ST_CBOM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label Current collection conti boms view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY item_counter ato_changel_item item_counter
KEY bom_pgmid ato_conti_bom bom_pgmid
KEY bom_object ato_conti_bom bom_object
bom_counter 0
item_type ato_changel_item item_type
objh_checkid 
@AbapCatalog.sqlViewName: 'ATO_V_ST_CBOM'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_ALLOWED
@EndUserText.label: 'Current collection conti boms'

define view ATOV_ST_CURRENT_COL_ITEM_CBOM
  as select from    ATOV_ST_RELEVANT_ITEMS as latest_item_cl
    inner join      ato_changelists        as list  on list.changelist_id = latest_item_cl.changelist_id
    inner join      ato_changel_item       as item  on  item.changelist_id = latest_item_cl.changelist_id
                                                    and item.item_id       = latest_item_cl.item_id
                                                    and item.item_type     = latest_item_cl.item_type
    inner join      ato_conti_bom          as bom   on  bom.item_id   = latest_item_cl.item_id
                                                    and bom.item_type = latest_item_cl.item_type
    left outer join tadir                  as tadir on  tadir.pgmid    = bom.bom_pgmid
                                                    and tadir.object   = bom.bom_object
                                                    and tadir.obj_name = bom.bom_object_name

    left outer join objh                   as objh  on  objh.objectname = bom.bom_object
                                                    and objh.objecttype = 'L'

{

  key item.changelist_id            as changelist_id,
  key item.item_counter             as item_counter,
  key bom.bom_pgmid                 as bom_pgmid,
  key bom.bom_object                as bom_object,
  key bom.bom_object_name           as bom_object_name,
      0                             as bom_counter,
      ''                            as bom_object_status,
      list.collection_id            as collection_id,
      list.collection_version       as collection_version,
      item.item_type                as item_type,
      case
        when tadir.obj_name is not initial
          then 'X'
          else ''
      end                           as tadir_exist,
      coalesce( objh.checkid , '' ) as objh_checkid

}
where
  (
       item.item_import_status = #ato_item_import_status.'C'
    or item.item_import_status = #ato_item_import_status.'N'
    or item.item_import_status = #ato_item_import_status.'U'
  )

Learn More