SAP ABAP Table SKPF (Header Data: Inventory Sampling)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷
CRM (Application Component) Customer Relationship Management
⤷
CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷
MB (Package) Application development R/3 inventory management
⤷
⤷
⤷
Basic Data
| Table Category | TRANSP | Transparent table |
| Transparent table | SKPF |
|
| Short Description | Header Data: Inventory Sampling |
Delivery and Maintenance
| Pool/cluster | ||
| Delivery Class | A | Application Table (Master- and Transaction Data) |
| Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
| |
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|---|---|---|---|---|---|---|---|---|---|
| 1 | |
MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
| 2 | |
MBS_SINUM | MBS_SINUM | CHAR | 10 | 0 | Inventory sampling number | ||
| 3 | |
MBS_SJAHR | GJAHR | NUMC | 4 | 0 | Calendar year of the inventory sampling | ||
| 4 | |
MBS_WAERS | WAERS | CUKY | 5 | 0 | Currency key for inventory sampling | TCURC | |
| 5 | |
MBS_DATUM | DATUM | DATS | 8 | 0 | Date of inventory sampling | ||
| 6 | |
MBS_GSDAT | DATUM | DATS | 8 | 0 | Planned count date of inventory sampling | ||
| 7 | |
MBS_SISTA | MBS_SISTA | CHAR | 2 | 0 | Description of the inventory sampling status | ||
| 8 | |
MBS_BDSTI | MBS_BDSTI | CHAR | 1 | 0 | ID for area of inventory sampling | ||
| 9 | |
MBS_XLOEB | XFELD | CHAR | 1 | 0 | Include deletion flag | ||
| 10 | |
MBS_XNULB | XFELD | CHAR | 1 | 0 | Consider zero stock balances | ||
| 11 | |
MBS_XABCB | MBS_XABCB | CHAR | 1 | 0 | Consider ABC indicator | ||
| 12 | |
MBS_XISAP | MBS_XISAP | CHAR | 1 | 0 | SAP Inventory Sampling | ||
| 13 | |
MBS_ZPSTI | MBS_ZPSTI | CHAR | 1 | 0 | Inventory sampling method | ||
| 14 | |
MBS_HOCHR | MBS_HOCHR | CHAR | 1 | 0 | Extrapolation procedure | ||
| 15 | |
MBS_PREIO | WERT11 | CURR | 11 | 2 | Upper price limit for sampling area | ||
| 16 | |
MBS_KWEIT | WERT11 | CURR | 11 | 2 | Class interval uniform for all classes | ||
| 17 | |
MBS_WERTO | WERT13 | CURR | 13 | 2 | Upper value limit for sampling area | ||
| 18 | |
MBS_SANZV | NUM02 | NUMC | 2 | 0 | Lower number of strata for variation | ||
| 19 | |
MBS_SANZB | NUM02 | NUMC | 2 | 0 | Upper number of strata for variation | ||
| 20 | |
MBS_NGMIN | NUM05 | NUMC | 5 | 0 | Minimum sample size per stratum | ||
| 21 | |
MBS_SWAHR | PRZ22 | DEC | 4 | 2 | Probable degree of confidence (percentage) | ||
| 22 | |
MBS_RELSF | PRZ22 | DEC | 4 | 2 | Relative statistical error | ||
| 23 | |
MBS_ABWBI | PRZ22 | DEC | 4 | 2 | Max. relat. deviation betw. book value and actual value | ||
| 24 | |
MBS_DSBSE | DATUM | DATS | 8 | 0 | Stock management levels allocated | ||
| 25 | |
UNAME | UNAME | CHAR | 12 | 0 | User Name | ||
| 26 | |
MBS_DSLGH | DATUM | DATS | 8 | 0 | Stock population generated | ||
| 27 | |
UNAME | UNAME | CHAR | 12 | 0 | User Name | ||
| 28 | |
MBS_DSSCH | DATUM | DATS | 8 | 0 | Stratification carried out | ||
| 29 | |
UNAME | UNAME | CHAR | 12 | 0 | User Name | ||
| 30 | |
MBS_DZUFA | DATUM | DATS | 8 | 0 | Random selection carried out | ||
| 31 | |
UNAME | UNAME | CHAR | 12 | 0 | User Name | ||
| 32 | |
MBS_DAKTU | DATUM | DATS | 8 | 0 | Update carried out | ||
| 33 | |
UNAME | UNAME | CHAR | 12 | 0 | User Name | ||
| 34 | |
MBS_DHOCH | DATUM | DATS | 8 | 0 | Extrapolation Carried Out | ||
| 35 | |
UNAME | UNAME | CHAR | 12 | 0 | User Name | ||
| 36 | |
MBS_STEXT | TEXT40 | CHAR | 40 | 0 | Text for inventory sampling | ||
| 37 | |
MBS_PWERT | PROZENT | NUMC | 3 | 0 | Percentage upper value limit | ||
| 38 | |
MBS_DLOES | DATUM | DATS | 8 | 0 | Deleted | ||
| 39 | |
UNAME | UNAME | CHAR | 12 | 0 | User Name | ||
| 40 | |
MBS_XFBEZ | MBS_XFBEZ | CHAR | 1 | 0 | Relation of error variance | ||
| 41 | |
MBS_XAKTU | MBS_XAKTU | CHAR | 1 | 0 | Update counted and posted stock management units | ||
| 42 | |
MBS_XNULA | MBS_XNULA | CHAR | 1 | 0 | Exclude Zero Stocks | ||
| 43 | |
MBS_XSERN | MBS_XSERN | CHAR | 1 | 0 | Exclude Serial Numbers |
Foreign Keys
| |
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right |
|---|---|---|---|---|---|---|---|
| 1 | SKPF | MANDT | |
|
KEY | 1 | CN |
| 2 | SKPF | WAERS | |
|
REF | 1 | CN |
History
| Last changed by/on | SAP | 20040210 |
| SAP Release Created in |