SAP table SDORDERSTOCK (Sales Order Stock, Display)

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
MATNR Material Number CHAR 40 0 MARA MATNR
WERKS Plant CHAR 4 0 MARC WERKS_D
LGORT Storage location CHAR 4 0 MARD LGORT_D
CHARG Batch Number CHAR 10 0 MCHA CHARG_D
SOBKZ Special Stock Indicator CHAR 1 0 T148 SOBKZ
VBELN Sales and Distribution Document Number CHAR 10 0 * VBELN
POSNR Item number of the SD document NUMC 6 0 * POSNR
LFGJA Fiscal Year of Current Period NUMC 4 0 LFGJA
LFMON Current period (posting period) NUMC 2 0 LFMON
KASPR Physical Inventory Blocking Indicator CHAR 1 0 SPERR
No physical inventory defined for material
A Physical inventory not yet completed for material
X Due to phys. inv., material is blocked for movements
KALAB Valuated Unrestricted-Use Stock QUAN 13 3 LABST
KAINS Stock in Quality Inspection QUAN 13 3 INSME
KASPE Blocked Stock QUAN 13 3 SPEME
KAVLA Valuated unrestricted-use stock in previous period QUAN 13 3 VMLAB
KAVIN Stock in Quality Inspection in Previous Period QUAN 13 3 VMINS
KAVSP Blocked stock of previous period QUAN 13 3 VMSPE
KAILL Physical inventory indicator for whse stock in current year CHAR 3 0 KZILL
KAILQ Phys. inventory ind. f. stock in qual. insp. in current year CHAR 3 0 KZILQ
KAILS Physical inventory indicator for blocked stock CHAR 3 0 KZILS
KAVLL Physical inventory indicator for stock in previous year CHAR 3 0 KZVLL
KAVLQ Phys. inventory ind. f. stock in qual. insp. in prev. period CHAR 3 0 KZVLQ
KAVLS Phys. inventory indicator for blocked stock in prev. period CHAR 3 0 KZVLS
KAFLL Physical inventory indicator for stock in following year CHAR 3 0 KZFLL
KAFLQ Physical inventory indicator, quality insp.stck, follow.yr. CHAR 3 0 KZFLQ
KAFLS Phys. inventory ind. for blocked stock in following period CHAR 3 0 KZFLS
KADLL Date of Last Posted Count DATS 8 0 DLINL
KAEIN Total Stock of All Restricted Batches QUAN 13 3 EINME
KAVEI Restricted-Use Stock in Previous Period QUAN 13 3 VMEIN
ERSDA Created On DATS 8 0 ERSDA
KAJIN Fiscal year of current physical inventory indicator NUMC 4 0 GJINV
KARUE MxxxH rec. already exists for per. before last of Mxxx per. CHAR 1 0 SBRUE
SGT_SCAT Stock Segment CHAR 40 0 SGT_SCAT
FSH_SEASON_YEAR Season Year CHAR 4 0 FSH_SAISJ
FSH_SEASON Season CHAR 10 0 FSH_SAISO
FSH_COLLECTION Fashion Collection CHAR 10 0 * FSH_COLLECTION
FSH_THEME Fashion Theme CHAR 10 0 FSH_THEME
FSH_SALLOC_QTY Allocated Stock Quantity QUAN 13 3 FSH_SALLOC_QTY
/CWM/KALAB Valuated Unrestricted-Use Stock QUAN 13 3 LABST
/CWM/KAINS Stock in Quality Inspection QUAN 13 3 INSME
/CWM/KASPE Blocked Stock QUAN 13 3 SPEME
/CWM/KAEIN Total Stock of All Restricted Batches QUAN 13 3 EINME
/CWM/KAVLA Valuated unrestricted-use stock in previous period QUAN 13 3 VMLAB
/CWM/KAVIN Stock in Quality Inspection in Previous Period QUAN 13 3 VMINS
/CWM/KAVSP Blocked stock of previous period QUAN 13 3 VMSPE
/CWM/KAVEI Restricted-Use Stock in Previous Period QUAN 13 3 VMEIN
ARKTX Short text for sales order item CHAR 40 0 ARKTX
MEINS Base Unit of Measure UNIT 3 0 MEINS
SERNR Serial Number CHAR 18 0 GERNR

SDORDERSTOCK foreign key relationships

Table Field Check Table Check Field
0 SDORDERSTOCK CHARG MCHA Batches MANDT
0 SDORDERSTOCK CHARG MCHA Batches WERKS
0 SDORDERSTOCK CHARG MCHA Batches CHARG
1 SDORDERSTOCK LGORT MARD Storage Location Data for Material MANDT
1 SDORDERSTOCK LGORT MARD Storage Location Data for Material MATNR
1 SDORDERSTOCK LGORT MARD Storage Location Data for Material WERKS
1 SDORDERSTOCK LGORT MARD Storage Location Data for Material LGORT
0 SDORDERSTOCK MATNR MARA General Material Data MANDT
0 SDORDERSTOCK MATNR MARA General Material Data MATNR
1 SDORDERSTOCK SOBKZ T148 Special Stock Indicator MANDT
1 SDORDERSTOCK SOBKZ T148 Special Stock Indicator SOBKZ
0 SDORDERSTOCK WERKS MARC Plant Data for Material MANDT
0 SDORDERSTOCK WERKS MARC Plant Data for Material MATNR
0 SDORDERSTOCK WERKS MARC Plant Data for Material WERKS