arun_i_c_agg

DDL: ARUN_I_C_AGG SQL: ARUN_IV_C_STAT Type: view Package: ARUN_ITA

ARun Status quantities aggregation at batch stock level

arun_i_c_agg is a CDS View that provides data about "ARun Status quantities aggregation at batch stock level" in SAP S/4HANA. It reads from 1 data source (arun_bdbs) and exposes 4 fields. Part of development package ARUN_ITA.

Data Sources (1)

SourceAliasJoin Type
arun_bdbs arun_bdbs from

Parameters (1)

NameTypeDefault
p_arun_mode arun_armd

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName ARUN_IV_C_STAT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #AUTOMATED view
EndUserText.label ARun Status quantities aggregation at batch stock level view

Fields (4)

KeyFieldSource TableSource FieldDescription
material material Vehicle Model
plant plant Valuation Area
StorageLocation arun_bdbs storage_location Sup. Stor. Loc.
batch batch Lot No.

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 arun_i_c_agg.
-- 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: ARUN_IV_C_STAT
-- Parameters: p_arun_mode : arun_armd

CREATE VIEW arun_i_c_agg AS
SELECT
  material,
  plant,
  arun_bdbs.storage_location AS StorageLocation,
  batch
FROM arun_bdbs
;