I_EWM_StockWithMaterial_2
Stock Material Technical Key
I_EWM_StockWithMaterial_2 is a Basic CDS View that provides data about "Stock Material Technical Key" in SAP S/4HANA. It reads from 1 data source (/scwm/stock_iw01) and exposes 10 fields with key fields EWMWarehouse, ProductUUID, EWMStockType, EWMStockUsage, EWMStockOwner.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| /scwm/stock_iw01 | /scwm/stock_iw01 | from |
Annotations (6)
| Name | Value | Level | Field |
|---|---|---|---|
| AccessControl.authorizationCheck | #NOT_REQUIRED | view | |
| VDM.viewType | #BASIC | view | |
| ObjectModel.usageType.serviceQuality | #B | view | |
| ObjectModel.usageType.sizeCategory | #XL | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| EndUserText.label | Stock Material Technical Key | view |
Fields (10)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | EWMWarehouse | lgnum_stock | ||
| KEY | ProductUUID | |||
| KEY | EWMStockType | cat | ||
| KEY | EWMStockUsage | stock_usage | ||
| KEY | EWMStockOwner | owner | ||
| KEY | StockOwnerPartnerRole | owner_role | ||
| KEY | EntitledToDisposeParty | entitled | ||
| KEY | EntitledToDisposePartnerRole | entitled_role | ||
| KEY | CounterForStockSeparation | stock_cnt | ||
| StockItemUUID | guid_stock |
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType:#BASIC
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@EndUserText.label: 'Stock Material Technical Key'
define view entity I_EWM_StockWithMaterial_2 as select from /scwm/stock_iw01{
///SCWM/STOCK_IW01
key lgnum_stock as EWMWarehouse,
key cast( matid as matid_no_conv preserving type ) as ProductUUID,
key cat as EWMStockType,
key stock_usage as EWMStockUsage,
key owner as EWMStockOwner,
key owner_role as StockOwnerPartnerRole,
key entitled as EntitledToDisposeParty,
key entitled_role as EntitledToDisposePartnerRole,
key stock_cnt as CounterForStockSeparation,
guid_stock as StockItemUUID
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"/SCWM/STOCK_IW01"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA