T159L (Default values for inventory management and physical invent.) 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 T159L to other SAP tables.
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||||
|
WERKS
Plant
|
WERKS_D | T001W |
CHAR
|
4 | 0 | |||||||||
|
BSTAR
Stock type
|
BSTAR | T064A |
CHAR
|
1 | 0 | |||||||||
|
KZCHA
Determine Batches for Physical Inventory in Background
|
KZCHA |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
XAMEI
Handling in Alternative Unit of Measure
|
XAMEI |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
STLAN
BOM Usage
|
STLAN |
CHAR
|
1 | 0 | ||||||||||
|
XWAOK
Goods Movement for Reservation Allowed
|
XWAOK |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
XLAUT
Automatic creation of storage location allowed
|
XLAUT |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
TWAOK
No. of days, if 'movement allowed' is set automatically
|
TWAOK |
NUMC
|
3 | 0 | ||||||||||
|
TLOEK
Retention period, in days, for reservation items
|
TLOEK |
NUMC
|
3 | 0 | ||||||||||
|
XELIK
Suggest "delivery completed" indicator
|
XELIK |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
VGART
Transaction/Event Type
|
VGART | T158V |
CHAR
|
2 | 0 | |||||||||
|
CAPID
Application
|
CAPID | TC04 |
CHAR
|
4 | 0 | |||||||||
|
XCHVW
Synchronous posting of batch where-used records
|
XCHVW |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
XCHVA
Batch where-used list deactivated
|
XCHVA |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
XFHTP
Missing parts check active
|
XFHTP |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
XFVER
Summarize missing parts mail messages
|
XFVER |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
KZXAB
GR/GI slip number is active
|
KZXAB |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
XSMNG
RTP stock allowed to become negative
|
XSMNG |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
XSVNG
Stock of ret. packaging w. cust. allowed to become negative
|
XSVNG |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
XWMHD
Check Best Before Date/Production Date
|
XWMHD |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
XSKNG
Consignment stock from vendor allowed to become negative
|
XSKNG |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
XSONG
Stock of material prov. to vendor allowed to become negative
|
XSONG |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
XSWNG
Consignment Stock with Customer Allowed to Become Negative
|
XSWNG |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
XSENG
Sales order stock allowed to become negative
|
XSENG |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
XSQNG
Project stock allowed to become negative
|
XSQNG |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
GRUND
Reason for inventory diff.
|
GRDIF | T157D |
NUMC
|
4 | 0 | |||||||||
|
XRMAD
Create stor. loc. stock data automatically for reservation
|
XRMAD |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
XAEBL
Change Document in Physical Inventory
|
XAEBL |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
XCAUT
Automatic btch no. assignment permitted for GR w. acct assgt
|
XCAUT |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
XBUIB
Adjust Book Inventory in Physical Inventory Document
|
XBUIB |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
XSERP
Print Physical Inventory Document with Serial Numbers
|
XSERP |
CHAR
|
18 | 0 | ||||||||||
|
XSERA
Display Serial Numbers in Case of 'Enter Count'
|
XSERA |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
SERPR
Number of Printed Serial Number Lines
|
SERPR |
NUMC
|
3 | 0 | ||||||||||
|
MSR_INSMK_FREE
Stock Type for Goods Transfer into Free Available Stock
|
MSR_INSMK_FREE |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
MSR_INSMK_RCV
Stock Type for Receive into Plant for Store Returns
|
MSR_INSMK_RCV |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| T159L | BSTAR | T159L | BSTAR |
T064A
Physical Inventory Stock Types
|
BSTAR |
| T159L | CAPID | T159L | MANDT |
TC04
Applic-Specific Criteria for Alternative Determination
|
MANDT |
| T159L | CAPID | T159L | CAPID |
TC04
Applic-Specific Criteria for Alternative Determination
|
CAPID |
| T159L | GRUND | T159L | GRUND |
T157D
Reason for Movement
|
GRUND |
| T159L | GRUND | T159L | MANDT |
T157D
Reason for Movement
|
MANDT |
| T159L | GRUND | * |
T157D
Reason for Movement
|
BWART | |
| T159L | MANDT | T159L | MANDT |
T000
Clients
|
MANDT |
| T159L | VGART | T159L | VGART |
T158V
Inv. Mngmt - General: Transaction/Event Types Allowed
|
VGART |
| T159L | WERKS | T159L | MANDT |
T001W
Plants/Branches
|
MANDT |
| T159L | WERKS | T159L | WERKS |
T001W
Plants/Branches
|
WERKS |