SAP table T159L (Default values for inventory management and physical invent.)

SAP table T159L has 2 primary key fields being MANDT,WERKS.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
WERKS Plant CHAR 4 0 T001W WERKS_D
BSTAR Stock type CHAR 1 0 T064A BSTAR
KZCHA Determine Batches for Physical Inventory in Background CHAR 1 0 KZCHA
Determine batches in the foreground with correction option
X Determine batches in the background
XAMEI Handling in Alternative Unit of Measure CHAR 1 0 XAMEI
STLAN BOM Usage CHAR 1 0 * STLAN
XWAOK Goods movement for reservation allowed CHAR 1 0 XWAOK
XLAUT Automatic creation of storage location allowed CHAR 1 0 XLAUT
TWAOK No. of days, if 'movement allowed' is set automatically NUMC 3 0 TWAOK
TLOEK Retention period, in days, for reservation items NUMC 3 0 TLOEK
XELIK Suggest "delivery completed" indicator CHAR 1 0 XELIK
VGART Transaction/Event Type CHAR 2 0 T158V VGART
CAPID Application CHAR 4 0 TC04 CAPID
XCHVW Synchronous posting of batch where-used records CHAR 1 0 XCHVW
XCHVA Batch where-used list deactivated CHAR 1 0 XCHVA
XFHTP Missing parts check active CHAR 1 0 XFHTP
XFVER Summarize missing parts mail messages CHAR 1 0 XFVER
KZXAB GR/GI slip number is active CHAR 1 0 KZXAB
XSMNG RTP stock allowed to become negative CHAR 1 0 XSMNG
XSVNG Stock of ret. packaging w. cust. allowed to become negative CHAR 1 0 XSVNG
XWMHD Check Best Before Date/Production Date CHAR 1 0 XWMHD
XSKNG Consignment stock from vendor allowed to become negative CHAR 1 0 XSKNG
XSONG Stock of material prov. to vendor allowed to become negative CHAR 1 0 XSONG
XSWNG Consignment Stock with Customer Allowed to Become Negative CHAR 1 0 XSWNG
XSENG Sales order stock allowed to become negative CHAR 1 0 XSENG
XSQNG Project stock allowed to become negative CHAR 1 0 XSQNG
GRUND Reason for Inventory Difference NUMC 4 0 T157D GRDIF
XRMAD Create stor. loc. stock data automatically for reservation CHAR 1 0 XRMAD
XAEBL Change Document in Physical Inventory CHAR 1 0 XAEBL
XCAUT Automatic btch no. assignment permitted for GR w. acct assgt CHAR 1 0 XCAUT
XBUIB Adjust Book Inventory in Physical Inventory Document CHAR 1 0 XBUIB
Not active
1 Active, if same date the phys. inv. was before goods mvt
2 Active, if same date the goods mvt was before the phys. inv.
XSERP Print Physical Inventory Document with Serial Numbers CHAR 18 0 XSERP
XSERA Display Serial Numbers in Case of 'Enter Count' CHAR 1 0 XSERA
Serial nos are not displayed in the case of 'Enter count'
X Serial numbers are displayed in the case of 'Enter count'
SERPR Number of Printed Serial Number Lines NUMC 3 0 SERPR
MSR_INSMK_FREE Stock Type for Goods Transfer into Free Available Stock CHAR 1 0 MSR_INSMK_FREE
MSR_INSMK_RCV Stock Type for Receive into Plant for Store Returns CHAR 1 0 MSR_INSMK_RCV

T159L foreign key relationships

Table Field Check Table Check Field
0 T159L CAPID TC04 Applic-Specific Criteria for Alternative Determination MANDT
0 T159L CAPID TC04 Applic-Specific Criteria for Alternative Determination CAPID
1 T159L GRUND T157D Reason for Movement MANDT
0 T159L MANDT T000 Clients MANDT
1 T159L VGART T158V Inv. Mngmt - General: Transaction/Event Types Allowed VGART
0 T159L WERKS T001W Plants/Branches WERKS