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
⤷ 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 | Table Relationship Diagram |
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 | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | SINUM | MBS_SINUM | MBS_SINUM | CHAR | 10 | 0 | Inventory sampling number | ||
3 | SJAHR | MBS_SJAHR | GJAHR | NUMC | 4 | 0 | Calendar year of the inventory sampling | ||
4 | WAERS | MBS_WAERS | WAERS | CUKY | 5 | 0 | Currency key for inventory sampling | TCURC | |
5 | DATUM | MBS_DATUM | DATUM | DATS | 8 | 0 | Date of inventory sampling | ||
6 | GSDAT | MBS_GSDAT | DATUM | DATS | 8 | 0 | Planned count date of inventory sampling | ||
7 | SISTA | MBS_SISTA | MBS_SISTA | CHAR | 2 | 0 | Description of the inventory sampling status | ||
8 | BDSTI | MBS_BDSTI | MBS_BDSTI | CHAR | 1 | 0 | ID for area of inventory sampling | ||
9 | XLOEB | MBS_XLOEB | XFELD | CHAR | 1 | 0 | Include deletion flag | ||
10 | XNULB | MBS_XNULB | XFELD | CHAR | 1 | 0 | Consider zero stock balances | ||
11 | XABCB | MBS_XABCB | MBS_XABCB | CHAR | 1 | 0 | Consider ABC indicator | ||
12 | XISAP | MBS_XISAP | MBS_XISAP | CHAR | 1 | 0 | SAP Inventory Sampling | ||
13 | ZPSTI | MBS_ZPSTI | MBS_ZPSTI | CHAR | 1 | 0 | Inventory sampling method | ||
14 | HOCHR | MBS_HOCHR | MBS_HOCHR | CHAR | 1 | 0 | Extrapolation procedure | ||
15 | PREIO | MBS_PREIO | WERT11 | CURR | 11 | 2 | Upper price limit for sampling area | ||
16 | KWEIT | MBS_KWEIT | WERT11 | CURR | 11 | 2 | Class interval uniform for all classes | ||
17 | WERTO | MBS_WERTO | WERT13 | CURR | 13 | 2 | Upper value limit for sampling area | ||
18 | SANZV | MBS_SANZV | NUM02 | NUMC | 2 | 0 | Lower number of strata for variation | ||
19 | SANZB | MBS_SANZB | NUM02 | NUMC | 2 | 0 | Upper number of strata for variation | ||
20 | NGMIN | MBS_NGMIN | NUM05 | NUMC | 5 | 0 | Minimum sample size per stratum | ||
21 | SWAHR | MBS_SWAHR | PRZ22 | DEC | 4 | 2 | Probable degree of confidence (percentage) | ||
22 | RELSF | MBS_RELSF | PRZ22 | DEC | 4 | 2 | Relative statistical error | ||
23 | ABWBI | MBS_ABWBI | PRZ22 | DEC | 4 | 2 | Max. relat. deviation betw. book value and actual value | ||
24 | DSBSE | MBS_DSBSE | DATUM | DATS | 8 | 0 | Stock management levels allocated | ||
25 | NSBSE | UNAME | UNAME | CHAR | 12 | 0 | User Name | ||
26 | DSLGH | MBS_DSLGH | DATUM | DATS | 8 | 0 | Stock population generated | ||
27 | NSLGH | UNAME | UNAME | CHAR | 12 | 0 | User Name | ||
28 | DSSCH | MBS_DSSCH | DATUM | DATS | 8 | 0 | Stratification carried out | ||
29 | NSSCH | UNAME | UNAME | CHAR | 12 | 0 | User Name | ||
30 | DZUFA | MBS_DZUFA | DATUM | DATS | 8 | 0 | Random selection carried out | ||
31 | NZUFA | UNAME | UNAME | CHAR | 12 | 0 | User Name | ||
32 | DAKTU | MBS_DAKTU | DATUM | DATS | 8 | 0 | Update carried out | ||
33 | NAKTU | UNAME | UNAME | CHAR | 12 | 0 | User Name | ||
34 | DHOCH | MBS_DHOCH | DATUM | DATS | 8 | 0 | Extrapolation Carried Out | ||
35 | NHOCH | UNAME | UNAME | CHAR | 12 | 0 | User Name | ||
36 | STEXT | MBS_STEXT | TEXT40 | CHAR | 40 | 0 | Text for inventory sampling | ||
37 | PWERT | MBS_PWERT | PROZENT | NUMC | 3 | 0 | Percentage upper value limit | ||
38 | DLOES | MBS_DLOES | DATUM | DATS | 8 | 0 | Deleted | ||
39 | LOESH | UNAME | UNAME | CHAR | 12 | 0 | User Name | ||
40 | XFBEZ | MBS_XFBEZ | MBS_XFBEZ | CHAR | 1 | 0 | Relation of error variance | ||
41 | XAKTU | MBS_XAKTU | MBS_XAKTU | CHAR | 1 | 0 | Update counted and posted stock management units | ||
42 | XNULA | MBS_XNULA | MBS_XNULA | CHAR | 1 | 0 | Exclude Zero Stocks | ||
43 | XSERN | 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 | T000 | MANDT | KEY | 1 | CN |
2 | SKPF | WAERS | TCURC | WAERS | REF | 1 | CN |
History
Last changed by/on | SAP | 20040210 |
SAP Release Created in |