aruni_stock_sel

ARun ITA: Physical stock selection | view: ARUNI_V_STK_SEL | TRAN | Extraction: Not supported | Component: Order Allocation Run
Column Name Description
Column Name Description
Column Name Description
OpenStockQty null
StockQty null
pfmenge null
📏 Base Unit of Measure (MaterialBaseUnit):
phmenge null
prmenge null
fmenge null
hmenge null
rmenge null
omenge null
pomenge null
dmenge null
alloc_qty null
Column Name Description
ShelfExpDate Shelf Life Expiration or Best-Before Date
MfgDate Date of Manufacture
BatchCreationDate Created On
LastGRDate Date of last goods receipt
Column Name Description
attyp Material Category Show values
Column Name Description Domain name
Material Material in Respect of Which Stock is Managed MATNR
Plant Plant WERKS
CompanyCode Company Code BUKRS
StorageLocation Storage location LGORT
Batch Batch Number (Stock Identifier) CHARG
InventorySpecialStockType Special Stock Type SOBKZ
Supplier Supplier for Special Stock LIFNR
StockSegment Stock Segment SGT_SRCA
SeasonYear Season Year FSH_CJAHR
Season Season RFM_SAISO
SCollection Fashion Collection FSH_COLLECTION
Theme Fashion Theme FSH_THEME
arun_bsnr Batch Number (Stock Identifier) CHARG
StockSource null
color Characteristic Value for Colors of Variants WRF_ATWRT
size1 Characteristic Value for Main Sizes of Variants WRF_ATWRT
size2 Characteristic Value for Second Size for Variants WRF_ATWRT
color_atinn Internal Charactieristic Number for Color Characteristics ATINN
size1_atinn Internal Char. Number for Characteristics for Main Sizes ATINN
size2_atinn Internal Char. Number for Characteristics for Second Sizes ATINN
STKNAM null
Master Data Relations Join Conditions
Material Group
  • Material Group
  • Client
  • ARUNI_STOCK_SEL.MATKL == T023.MATKL
  • ARUNI_STOCK_SEL.MANDT == T023.MANDT
Cross-Plant Configurable Material
  • Cross-Plant Configurable Material
  • Client
  • ARUNI_STOCK_SEL.SATNR == MARA.MATNR
  • ARUNI_STOCK_SEL.MANDT == MARA.MANDT