1. Home
  2. Resources
  3. SAP Tables
  4. SKPF - Header Data: Inventory Sampling

SAP Table SKPF

Header Data: Inventory Sampling

SKPF (Header Data: Inventory Sampling) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link SKPF to other SAP tables.

SKPF table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
SINUM Inventory sampling number MBS_SINUM CHAR 10 0
SJAHR Calendar year of the inventory sampling MBS_SJAHR NUMC 4 0
WAERS Currency key for inventory sampling MBS_WAERS TCURC CUKY 5 0
DATUM Date of inventory sampling MBS_DATUM DATS 8 0
GSDAT Planned count date of inventory sampling MBS_GSDAT DATS 8 0
SISTA Description of the inventory sampling status MBS_SISTA CHAR 2 0
0 New
1 In preparation
2 Active
3 Inventory management units posted
4 Completion successful
5 Completion unsuccessful
2X Active (completion partially successful)
G Deleted
2Y Completed (completion partially successful)
BDSTI ID for area of inventory sampling MBS_BDSTI CHAR 1 0
1 Inventory Management
2 Warehouse Management
XLOEB Include deletion flag MBS_XLOEB CHAR 1 0
X Yes
NULL No
XNULB Consider zero stock balances MBS_XNULB CHAR 1 0
X Yes
NULL No
XABCB Consider ABC indicator MBS_XABCB CHAR 1 0
1 Indicator A for complete-count area
2 Indicators A and B for complete-count area
3 Indicators A, B, and C for complete-count area
4 Indicator B for complete-count area
5 Indicators B and C for complete-count area
6 Indicator C for complete-count area
7 Indicators A and C for complete-count area
XISAP SAP Inventory Sampling MBS_XISAP CHAR 1 0
1 ERP system
2 R/2 System
3 Other Systems
ZPSTI Inventory sampling method MBS_ZPSTI CHAR 1 0
1 Periodic inventory sampling
2 Continuous inventory sampling
HOCHR Extrapolation procedure MBS_HOCHR CHAR 1 0
1 Mean-value estimation
2 Difference estimation
3 Complete count
PREIO Upper price limit for sampling area MBS_PREIO CURR 11 2
KWEIT Class interval uniform for all classes MBS_KWEIT CURR 11 2
WERTO Upper value limit for sampling area MBS_WERTO CURR 13 2
SANZV Lower number of strata for variation MBS_SANZV NUMC 2 0
SANZB Upper number of strata for variation MBS_SANZB NUMC 2 0
NGMIN Minimum sample size per stratum MBS_NGMIN NUMC 5 0
SWAHR Probable degree of confidence (percentage) MBS_SWAHR DEC 4 2
RELSF Relative statistical error MBS_RELSF DEC 4 2
ABWBI Max. relat. deviation betw. book value and actual value MBS_ABWBI DEC 4 2
DSBSE Stock management levels allocated MBS_DSBSE DATS 8 0
NSBSE User Name UNAME CHAR 12 0
DSLGH Stock population generated MBS_DSLGH DATS 8 0
NSLGH User Name UNAME CHAR 12 0
DSSCH Stratification carried out MBS_DSSCH DATS 8 0
NSSCH User Name UNAME CHAR 12 0
DZUFA Random selection carried out MBS_DZUFA DATS 8 0
NZUFA User Name UNAME CHAR 12 0
DAKTU Update carried out MBS_DAKTU DATS 8 0
NAKTU User Name UNAME CHAR 12 0
DHOCH Extrapolation Carried Out MBS_DHOCH DATS 8 0
NHOCH User Name UNAME CHAR 12 0
STEXT Text for inventory sampling MBS_STEXT CHAR 40 0
PWERT Percentage upper value limit MBS_PWERT NUMC 3 0
000 Percentage from 0 to 100
DLOES Deleted MBS_DLOES DATS 8 0
LOESH User Name UNAME CHAR 12 0
XFBEZ Relation of error variance MBS_XFBEZ CHAR 1 0
1 Sampling area
2 Complete-count area
XAKTU Update counted and posted stock management units MBS_XAKTU CHAR 1 0
X Do not update the difference of posted elements
NULL Update the difference of posted elements (S)
XNULA Exclude Zero Stocks MBS_XNULA CHAR 1 0
XSERN Exclude Serial Numbers MBS_XSERN CHAR 1 0

SKPF foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
SKPF MANDT SKPF MANDT T000 Clients MANDT
SKPF WAERS SKPF MANDT TCURC Currency Codes MANDT
SKPF WAERS SKPF WAERS TCURC Currency Codes WAERS