SAP Table T159G

Default Values for Inventory Sampling Profile

T159G (Default Values for Inventory Sampling Profile) 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 T159G to other SAP tables.

T159G table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
IGSCH Default key for inventory sampling profile MBS_IGSCH CHAR 2 0
WAERS Currency key for inventory sampling MBS_WAERS TCURC CUKY 5 0
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
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
WERTO Upper value limit for sampling area MBS_WERTO CURR 13 2
KWEIT Class interval uniform for all classes MBS_KWEIT CURR 11 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
PWERT Percentage upper value limit MBS_PWERT NUMC 3 0
000 Percentage from 0 to 100
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

T159G foreign key relationships

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