SKPF SAP (Header Data: Inventory Sampling) Table details
Dictionary Type: Table
Description: Header Data: Inventory Sampling
Description: Header Data: Inventory Sampling
Table field list including key, data, relationships and ABAP select examples
SKPF is a standard SAP Table which is used to store Header Data: Inventory Sampling data and is available within R/3 SAP systems depending on the version and release level.
The SKPF table consists of various fields, each holding specific information or linking keys about Header Data: Inventory Sampling data available in SAP. These include SINUM (Inventory sampling number), SJAHR (Calendar year of the inventory sampling), WAERS (Currency key for inventory sampling), DATUM (Date of inventory sampling).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP SKPF table fields - Full list of fields found in SAP data dictionary
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
| MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
| SINUM | Inventory sampling number | MBS_SINUM | CHAR | 10 | ALPHA | MBS_SINUM | SIN | ||
| SJAHR | Calendar year of the inventory sampling | MBS_SJAHR | NUMC | 4 | GJAHR | GJAHR | MJA | ||
| WAERS | Currency key for inventory sampling | MBS_WAERS | CUKY | 5 | TCURC | WAERS | |||
| DATUM | Date of inventory sampling | MBS_DATUM | DATS | 8 | DATUM | ||||
| GSDAT | Planned count date of inventory sampling | MBS_GSDAT | DATS | 8 | DATUM | ||||
| SISTA | Description of the inventory sampling status | MBS_SISTA | CHAR | 2 | MBS_SISTA | ||||
| BDSTI | ID for area of inventory sampling | MBS_BDSTI | CHAR | 1 | MBS_BDSTI | ||||
| XLOEB | Include deletion flag | MBS_XLOEB | CHAR | 1 | XFELD | ||||
| XNULB | Consider zero stock balances | MBS_XNULB | CHAR | 1 | XFELD | ||||
| XABCB | Consider ABC indicator | MBS_XABCB | CHAR | 1 | MBS_XABCB | ||||
| XISAP | SAP Inventory Sampling | MBS_XISAP | CHAR | 1 | MBS_XISAP | ||||
| ZPSTI | Inventory sampling method | MBS_ZPSTI | CHAR | 1 | MBS_ZPSTI | ||||
| HOCHR | Extrapolation procedure | MBS_HOCHR | CHAR | 1 | MBS_HOCHR | ||||
| PREIO | Upper price limit for sampling area | MBS_PREIO | CURR | 11(2) | WERT11 | ||||
| KWEIT | Class interval uniform for all classes | MBS_KWEIT | CURR | 11(2) | WERT11 | ||||
| WERTO | Upper value limit for sampling area | MBS_WERTO | CURR | 13(2) | WERT13 | ||||
| SANZV | Lower number of strata for variation | MBS_SANZV | NUMC | 2 | NUM02 | ||||
| SANZB | Upper number of strata for variation | MBS_SANZB | NUMC | 2 | NUM02 | ||||
| NGMIN | Minimum sample size per stratum | MBS_NGMIN | NUMC | 5 | NUM05 | ||||
| SWAHR | Probable degree of confidence (percentage) | MBS_SWAHR | DEC | 4(2) | PRZ22 | ||||
| RELSF | Relative statistical error | MBS_RELSF | DEC | 4(2) | PRZ22 | ||||
| ABWBI | Max. relat. deviation betw. book value and actual value | MBS_ABWBI | DEC | 4(2) | PRZ22 | ||||
| DSBSE | Stock management levels allocated | MBS_DSBSE | DATS | 8 | DATUM | ||||
| NSBSE | User Name | UNAME | CHAR | 12 | UNAME | ||||
| DSLGH | Stock population generated | MBS_DSLGH | DATS | 8 | DATUM | ||||
| NSLGH | User Name | UNAME | CHAR | 12 | UNAME | ||||
| DSSCH | Stratification carried out | MBS_DSSCH | DATS | 8 | DATUM | ||||
| NSSCH | User Name | UNAME | CHAR | 12 | UNAME | ||||
| DZUFA | Random selection carried out | MBS_DZUFA | DATS | 8 | DATUM | ||||
| NZUFA | User Name | UNAME | CHAR | 12 | UNAME | ||||
| DAKTU | Update carried out | MBS_DAKTU | DATS | 8 | DATUM | ||||
| NAKTU | User Name | UNAME | CHAR | 12 | UNAME | ||||
| DHOCH | Extrapolation Carried Out | MBS_DHOCH | DATS | 8 | DATUM | ||||
| NHOCH | User Name | UNAME | CHAR | 12 | UNAME | ||||
| STEXT | Text for inventory sampling | MBS_STEXT | CHAR | 40 | TEXT40 | ||||
| PWERT | Percentage upper value limit | MBS_PWERT | NUMC | 3 | PROZENT | ||||
| DLOES | Deleted | MBS_DLOES | DATS | 8 | DATUM | ||||
| LOESH | User Name | UNAME | CHAR | 12 | UNAME | ||||
| XFBEZ | Relation of error variance | MBS_XFBEZ | CHAR | 1 | MBS_XFBEZ | ||||
| XAKTU | Update counted and posted stock management units | MBS_XAKTU | CHAR | 1 | MBS_XAKTU | ||||
| XNULA | Exclude Zero Stocks | MBS_XNULA | CHAR | 1 | MBS_XNULA | ||||
| XSERN | Exclude Serial Numbers | MBS_XSERN | CHAR | 1 | MBS_XSERN |
| Key field | Non-key field |
How do I retrieve data from SAP table SKPF using ABAP code
The following ABAP code Example will allow you to do a basic selection on SKPF to SELECT all data from the tableDATA: WA_SKPF TYPE SKPF.
SELECT SINGLE *
FROM SKPF
INTO CORRESPONDING FIELDS OF WA_SKPF
WHERE...
How to access SAP table SKPF
Within an ECC or HANA version of SAP you can also view further information about SKPF and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects