I_StoreStockAdjustmentItem

DDL: I_STORESTOCKADJUSTMENTITEM SQL: ISTORESTKADJITM Type: view BASIC Package: RFM_STORE_STOCK_ADJUSTMENT
14 Fields 1 Data Sources 2 Associations

Store Stock Adjustment Item

I_StoreStockAdjustmentItem (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Public Edition with built-in and side-by-side extension capabilities.

StoreStockAdjustmentItem · Cross Applications

I_StoreStockAdjustmentItem is a Basic CDS View (Dimension) that provides data about "Store Stock Adjustment Item" in SAP S/4HANA. It reads from 1 data source (rfm_st_stkadjitm) and exposes 14 fields with key fields Store, StoreStockAdjustmentUUID, Product. It has 2 associations to related views. Part of development package RFM_STORE_STOCK_ADJUSTMENT.

SAP Help Documentation

CategoryIn-Store Inventory Management
Data CategoryDimension
Purpose
This CDS view provides the list of products and their details for stock adjustments in the Adjust Mass Stock application. This CDS view provides the data to answer the following business questions: What are the quantities of the products added in a stock adjustment along with the unit of measure details? What is the sales price for the added products with currency details? What is the cost center to be charged for the adjustment and the service provider for the adjustment? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations Users who want to use this CDS view must have a role with the following restriction types set to read access: WERKS (Plant)

Structure
Business Objects This view is built on the Store Stock Adjustment ( StoreStockAdjustment ) business object. Important Fields Important fields in this view include the following: Field Name Description Store Retail plant Note This is a key field. StoreStockAdjustmentUUID Unique identifier for new stock adjustment Note This is a key field. Product Material Number Note This is a key field. StockAdjustmentQuantity Stock Adjustment Quantity UnitOfMeasure Base Unit of Measure ProductSalesPrice Product Sales Price Currency Currency Key CostCenter Cost Center PaymentServiceProviderName Service Provider ProductClaimDescription Comment CreationDateTime Creation Date and Time of Stock Adjustment LastChangeDateTime UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)

Data Extraction
Data Extraction Type Full (physical deletions are possible in source tables) Delta (change data capture)

View on SAP Help Portal →

SAP API Hub

CategoryBasic
StateC1
Line of BusinessCross Applications
Application ComponentLO-RFM-STO-FIO
CapabilitiesData Source for Data Extraction,Data Source in SQL Select,Data Source for Defining CDS Entities,Association Target for Defining CDS Entities,Analytical Dimension
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Not Released
PackageCross Applications for SAP S/4HANA Cloud Public Edition
Description <p>This CDS view provides the list of products and their details for stock adjustments in the Adjust Mass Stock application.</p> <p>This CDS view provides the data to answer the following business questions:</p> <ul> <li> <p>What are the quantities of the products added in a stock adjustment along with the unit of measure details?</p></li> <li> <p>What is the sales price for the added products with currency details?</p></li> <li> <p>What is the cost center to be charged for the adjustment and the service provider for the adjustment?</p></li> </ul> <p>To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
rfm_st_stkadjitm rfm_st_stkadjitm from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_Site _Site $projection.Store = _Site.Site
[1..1] I_StoreStockAdjustment _StockAdjust $projection.Store = _StockAdjust.Store and $projection.StoreStockAdjustmentUUID = _StockAdjust.StoreStockAdjustmentUUID

Annotations (20)

NameValueLevelField
AbapCatalog.sqlViewName ISTORESTKADJITM view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
Analytics.dataCategory #DIMENSION view
Analytics.internalName #LOCAL view
Analytics.dataExtraction.enabled true view
Analytics.dataExtraction.delta.changeDataCapture.automatic true view
ObjectModel.representativeKey Product view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
ObjectModel.sapObjectNodeType.name StoreStockAdjustmentItem view
EndUserText.label Store Stock Adjustment Item view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY Store store Retail plant
KEY StoreStockAdjustmentUUID storestockadjustmentuuid Unique Identifier for New Stock Adjustment
KEY Product product Material Number
StockAdjustmentQuantity stockadjustmentquantity Stock Adjustment Quantity
UnitOfMeasure unitofmeasure Base Unit of Measure
ProductSalesPrice productsalesprice Product Sales Price
Currency currency Valuation Crcy
CostCenter costcenter Cost Center
PaymentServiceProviderName paymentserviceprovidername Service Provider
ProductClaimDescription productclaimdescription Comment
CreationDateTime creationdatetime Creation date and time of Stock Adjustment
LastChangeDateTime lastchangedatetime UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)
_Site _Site
_StockAdjust _StockAdjust

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_StoreStockAdjustmentItem.
-- 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: ISTORESTKADJITM

CREATE VIEW I_StoreStockAdjustmentItem AS
SELECT
  Store,
  StoreStockAdjustmentUUID,
  Product,
  StockAdjustmentQuantity,
  UnitOfMeasure,
  ProductSalesPrice,
  Currency,
  CostCenter,
  PaymentServiceProviderName,
  ProductClaimDescription,
  CreationDateTime,
  LastChangeDateTime
FROM rfm_st_stkadjitm
LEFT OUTER JOIN I_Site AS _Site ON Store = _Site.Site  -- association [1..1]
LEFT OUTER JOIN I_StoreStockAdjustment AS _StockAdjust ON Store = _StockAdjust.Store AND StoreStockAdjustmentUUID = _StockAdjust.StoreStockAdjustmentUUID  -- association [1..1]
;

Learn More