I_JITStkAnlysAtStorLoc

DDL: I_JITSTKANLYSATSTORLOC Type: view_entity COMPOSITE Package: NJIT_APP_STOCK_AVAILABILITY
13 Fields 1 Data Sources

Stock Analysis for Mat at Sto Loc Level

I_JITStkAnlysAtStorLoc is a Composite CDS View that provides data about "Stock Analysis for Mat at Sto Loc Level" in SAP S/4HANA. It reads from 1 data source (I_MaterialStock) and exposes 13 fields with key fields Material, Plant, StorageLocation, MaterialBaseUnit. Part of development package NJIT_APP_STOCK_AVAILABILITY.

Data Sources (1)

SourceAliasJoin Type
I_MaterialStock I_MaterialStock from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Stock Analysis for Mat at Sto Loc Level view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY Material Material Vehicle Model
KEY Plant Plant Valuation Area
KEY StorageLocation StorageLocation StorageLocation
KEY MaterialBaseUnit MaterialBaseUnit Valuation Unit
UnrestrictedStkInStkUnit
QualityInspectionStockQuantity
TransferStockStorageLocQty
TransferStockPlantQuantity
StockInTransitQuantity
BlockedStockQuantity
_Material _Material
_Plant _Plant
_StorageLocation _StorageLocation

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 I_JITStkAnlysAtStorLoc.
-- 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.

CREATE VIEW I_JITStkAnlysAtStorLoc AS
SELECT
  Material,
  Plant,
  StorageLocation,
  MaterialBaseUnit,
  cast( sum(case InventoryStockType when '01' then MatlWrhsStkQtyInMatlBaseUnit else 0 end) as abap.quan(31,14) ) AS UnrestrictedStkInStkUnit,
  cast( sum(case InventoryStockType when '02' then MatlWrhsStkQtyInMatlBaseUnit else 0 end) as abap.quan(31,14) ) AS QualityInspectionStockQuantity,
  cast( sum(case InventoryStockType when '04' then MatlWrhsStkQtyInMatlBaseUnit else 0 end) as abap.quan(31,14) ) AS TransferStockStorageLocQty,
  cast( sum(case InventoryStockType when '05' then MatlWrhsStkQtyInMatlBaseUnit else 0 end) as abap.quan(31,14) ) AS TransferStockPlantQuantity,
  cast( sum(case InventoryStockType when '08' then MatlWrhsStkQtyInMatlBaseUnit else 0 end) as abap.quan(31,14) ) AS StockInTransitQuantity,
  cast( sum(case InventoryStockType when '07' then MatlWrhsStkQtyInMatlBaseUnit else 0 end) as abap.quan(31,14) ) AS BlockedStockQuantity
FROM I_MaterialStock
;

Learn More