MSKA

Sales Order Stock | view | #masterdata | Component: Basic Functions
Column Name Description
MANDT FK Client
MATNR FK Material Number
WERKS FK Plant
LGORT FK Storage location
CHARG FK Batch Number
SOBKZ FK Special Stock Indicator
VBELN Sales and Distribution Document Number
POSNR Item number of the SD document
Column Name Description
Column Name Description
📏 Base Unit of Measure (MARA.MEINS):
KALAB Valuated Unrestricted-Use Stock
KAINS Stock in Quality Inspection
KASPE Blocked Stock
KAVLA Valuated unrestricted-use stock in previous period
KAVIN Stock in Quality Inspection in Previous Period
KAVSP Blocked stock of previous period
KAEIN Total Stock of All Restricted Batches
KAVEI Restricted-Use Stock in Previous Period
FSH_SALLOC_QTY Allocated Stock Quantity
/CWM/KALAB Valuated Unrestricted-Use Stock
/CWM/KAINS Stock in Quality Inspection
/CWM/KASPE Blocked Stock
/CWM/KAEIN Total Stock of All Restricted Batches
/CWM/KAVLA Valuated unrestricted-use stock in previous period
/CWM/KAVIN Stock in Quality Inspection in Previous Period
/CWM/KAVSP Blocked stock of previous period
/CWM/KAVEI Restricted-Use Stock in Previous Period
Column Name Description
KADLL Date of Last Posted Count
ERSDA Created On
Column Name Description
KASPR Physical Inventory Blocking Indicator Show values
KARUE MxxxH rec. already exists for per. before last of Mxxx per. Show values
Column Name Description Domain name
LFGJA Fiscal Year of Current Period GJAHR
LFMON Current period (posting period) MONAT
KAILL Physical inventory indicator for whse stock in current year INVKZ
KAILQ Phys. inventory ind. f. stock in qual. insp. in current year INVKZ
KAILS Physical inventory indicator for blocked stock INVKZ
KAVLL Physical inventory indicator for stock in previous year INVKZ
KAVLQ Phys. inventory ind. f. stock in qual. insp. in prev. period INVKZ
KAVLS Phys. inventory indicator for blocked stock in prev. period INVKZ
KAFLL Physical inventory indicator for stock in following year INVKZ
KAFLQ Physical inventory indicator, quality insp.stck, follow.yr. INVKZ
KAFLS Phys. inventory ind. for blocked stock in following period INVKZ
KAJIN Fiscal year of current physical inventory indicator GJAHR
SGT_SCAT Stock Segment SGT_SRCA
FSH_SEASON_YEAR Season Year FSH_CJAHR
FSH_SEASON Season RFM_SAISO
FSH_COLLECTION Fashion Collection FSH_COLLECTION
FSH_THEME Fashion Theme FSH_THEME
Master Data Relations Join Conditions
Batch
  • Material Number
  • Batch Number
  • Plant
  • MSKA.MANDT == MCHA.MANDT
  • MSKA.MATNR == MCHA.MATNR
  • MSKA.CHARG == MCHA.CHARG
  • MSKA.WERKS == MCHA.WERKS
Storage location
  • Plant
  • Material Number
  • Storage location
  • MSKA.MANDT == MARD.MANDT
  • MSKA.WERKS == MARD.WERKS
  • MSKA.MATNR == MARD.MATNR
  • MSKA.LGORT == MARD.LGORT
Client MSKA.MANDT == T000.MANDT
Material
  • Material Number
  • Client
  • MSKA.MATNR == MARA.MATNR
  • MSKA.MANDT == MARA.MANDT
Special Stock Indicator
  • MSKA.MANDT == T148.MANDT
  • MSKA.SOBKZ == T148.SOBKZ
Plant
  • Material Number
  • Client
  • Plant
  • MSKA.MATNR == MARC.MATNR
  • MSKA.MANDT == MARC.MANDT
  • MSKA.WERKS == MARC.WERKS