R_StoreStockAdjustmentTP

DDL: R_STORESTOCKADJUSTMENTTP Type: view_entity TRANSACTIONAL
23 Fields 1 Data Sources 8 Associations

Store Stock Adjustment

R_StoreStockAdjustmentTP is a Transactional CDS View that provides data about "Store Stock Adjustment" in SAP S/4HANA. It reads from 1 data source (I_StoreStockAdjustment) and exposes 23 fields with key fields Store, StoreStockAdjustmentUUID. It has 8 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_StoreStockAdjustment I_StoreStockAdjustment from

Associations (8)

CardinalityTargetAliasCondition
[0..1] P_StoreStockAdjustmentSum _Sum $projection.Store = _Sum.Store and $projection.StoreStockAdjustmentUUID = _Sum.StoreStockAdjustmentUUID
[0..1] P_StoreStockAdjmtProductCount _Count $projection.Store = _Count.Store and $projection.StoreStockAdjustmentUUID = _Count.StoreStockAdjustmentUUID
[0..1] I_StorageLocation _StorageLoc $projection.Store = _StorageLoc.Plant and $projection.StorageLocation = _StorageLoc.StorageLocation
[0..1] I_RetailStoreUserAssignment _RetailStoreUserAssignment $projection.Store = _RetailStoreUserAssignment.Store and _RetailStoreUserAssignment.AssignedUser = $session.user
[0..1] I_StoreStockAdjmtReasonVH _Reason $projection.Store = _Reason.Store and $projection.GoodsMovementType = _Reason.GoodsMovementType and $projection.StockAdjustmentReason = _Reason.RetailStoreBusinessTransType
[0..1] I_UserDescription _User $projection.CreatedByUser = _User.UserID
[0..1] I_StoreStockAdjustmentStatus _Status $projection.StockAdjustmentStatus = _Status.StockAdjustmentStatus
[0..*] R_StoreStockAdjustmentItemTP _Items

Annotations (9)

NameValueLevelField
VDM.viewType #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
EndUserText.label Store Stock Adjustment view
ObjectModel.sapObjectNodeType.name StoreStockAdjustment view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY Store Store Plant
KEY StoreStockAdjustmentUUID StoreStockAdjustmentUUID Stock Adjust UUID
GoodsMovementType GoodsMovementType Movement Type
StockAdjustmentReason StockAdjustmentReason Adjustment Reason
StorageLocation StorageLocation StorageLocation
StockAdjustmentStatus StockAdjustmentStatus Stock Adjustment Status
CreatedByUser CreatedByUser User Name
CreationDateTime CreationDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
GrossAmount _Sum GrossAmount Gross value
NumberOfProducts _Count NumberOfProducts
Currency _Sum Currency Valuation Crcy
AssignedUser _RetailStoreUserAssignment AssignedUser
CreationDate CreationDate Time Stamp
LastChangeDate LastChangeDate Time Stamp
MaterialDocument MaterialDocument Material Doc.
GoodsMovementReasonCode GoodsMovementReasonCode Reason for Mvmt
_Items _Items
_StorageLoc _StorageLoc
_Reason _Reason
_User _User
_Status _Status

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 R_StoreStockAdjustmentTP.
-- 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 R_StoreStockAdjustmentTP AS
SELECT
  Store,
  StoreStockAdjustmentUUID,
  GoodsMovementType,
  StockAdjustmentReason,
  StorageLocation,
  StockAdjustmentStatus,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  LastChangeDateTime,
  _Sum.GrossAmount AS GrossAmount,
  _Count.NumberOfProducts AS NumberOfProducts,
  _Sum.Currency AS Currency,
  _RetailStoreUserAssignment.AssignedUser AS AssignedUser,
  CreationDate,
  LastChangeDate,
  MaterialDocument,
  GoodsMovementReasonCode
FROM I_StoreStockAdjustment
LEFT OUTER JOIN P_StoreStockAdjustmentSum AS _Sum ON Store = _Sum.Store AND StoreStockAdjustmentUUID = _Sum.StoreStockAdjustmentUUID  -- association [0..1]
LEFT OUTER JOIN P_StoreStockAdjmtProductCount AS _Count ON Store = _Count.Store AND StoreStockAdjustmentUUID = _Count.StoreStockAdjustmentUUID  -- association [0..1]
LEFT OUTER JOIN I_StorageLocation AS _StorageLoc ON Store = _StorageLoc.Plant AND StorageLocation = _StorageLoc.StorageLocation  -- association [0..1]
LEFT OUTER JOIN I_RetailStoreUserAssignment AS _RetailStoreUserAssignment ON Store = _RetailStoreUserAssignment.Store AND _RetailStoreUserAssignment.AssignedUser = $session.user  -- association [0..1]
LEFT OUTER JOIN I_StoreStockAdjmtReasonVH AS _Reason ON Store = _Reason.Store AND GoodsMovementType = _Reason.GoodsMovementType AND StockAdjustmentReason = _Reason.RetailStoreBusinessTransType  -- association [0..1]
LEFT OUTER JOIN I_UserDescription AS _User ON CreatedByUser = _User.UserID  -- association [0..1]
LEFT OUTER JOIN I_StoreStockAdjustmentStatus AS _Status ON StockAdjustmentStatus = _Status.StockAdjustmentStatus  -- association [0..1]
LEFT OUTER JOIN R_StoreStockAdjustmentItemTP AS _Items ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More