arun_i_batch_lines

DDL: ARUN_I_BATCH_LINES SQL: ARUNI_CSTK_LINE Type: view
16 Fields 4 Data Sources

Batch Stock selection at storage level

arun_i_batch_lines is a CDS View that provides data about "Batch Stock selection at storage level" in SAP S/4HANA. It reads from 4 data sources (mcha, nsdm_e_marc, I_MaterialStock, arun_stock_segmt) and exposes 16 fields.

Data Sources (4)

SourceAliasJoin Type
mcha a left_outer
nsdm_e_marc mc inner
I_MaterialStock ms from
arun_stock_segmt s left_outer

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName ARUNI_CSTK_LINE 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 Batch Stock selection at storage level view

Fields (16)

KeyFieldSource TableSource FieldDescription
MaterialBaseUnit I_MaterialStock MaterialBaseUnit Valuation Unit
Material I_MaterialStock Material Vehicle Model
Plant I_MaterialStock Plant Valuation Area
StorageLocation I_MaterialStock StorageLocation StorageLocation
BatchendasBatch
vfdatendasShelfExpDate
hsdatendasMfgDate
ersdaendasBatchCreationDate
lwedtendasLastGRDate
sgt_scatendasStockSegment
fsh_season_yearendasSeasonYear
fsh_seasonendasSeason
fsh_collectionendasSCollection
fsh_themeendasTheme
StockQty
ArunFixBatch nsdm_e_marc arun_fix_batch Assign Batches

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_batch_lines.
-- 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: ARUNI_CSTK_LINE

CREATE VIEW arun_i_batch_lines AS
SELECT
  ms.MaterialBaseUnit AS MaterialBaseUnit,
  ms.Material AS Material,
  ms.Plant AS Plant,
  ms.StorageLocation AS StorageLocation,
  case when mc.arun_fix_batch = '' and ms.Batch != '' then '' else ms.Batch end as Batch AS BatchendasBatch,
  case when mc.arun_fix_batch = '' and ms.Batch != '' then cast( '' as dats ) else a.vfdat end as ShelfExpDate AS vfdatendasShelfExpDate,
  case when mc.arun_fix_batch = '' and ms.Batch != '' then cast( '' as dats ) else a.hsdat end as MfgDate AS hsdatendasMfgDate,
  case when mc.arun_fix_batch = '' and ms.Batch != '' then cast( '' as dats ) else a.ersda end as BatchCreationDate AS ersdaendasBatchCreationDate,
  case when mc.arun_fix_batch = '' and ms.Batch != '' then cast( '' as dats ) else a.lwedt end as LastGRDate AS lwedtendasLastGRDate,
  case when mc.arun_fix_batch = '' and ms.Batch != '' then '' else a.sgt_scat end as StockSegment AS sgt_scatendasStockSegment,
  case when mc.arun_fix_batch = '' and ms.Batch != '' then '' else a.fsh_season_year end as SeasonYear AS fsh_season_yearendasSeasonYear,
  case when mc.arun_fix_batch = '' and ms.Batch != '' then '' else a.fsh_season end as Season AS fsh_seasonendasSeason,
  case when mc.arun_fix_batch = '' and ms.Batch != '' then '' else a.fsh_collection end as SCollection AS fsh_collectionendasSCollection,
  case when mc.arun_fix_batch = '' and ms.Batch != '' then '' else a.fsh_theme end as Theme AS fsh_themeendasTheme,
  sum(ms.MatlWrhsStkQtyInMatlBaseUnit) AS StockQty,
  mc.arun_fix_batch AS ArunFixBatch
FROM I_MaterialStock AS ms
INNER JOIN nsdm_e_marc AS mc ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN arun_stock_segmt AS s ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN mcha AS a ON /* join condition not captured in parsed metadata */
;

Learn More