SAP table T150 (Physical Inventory Stock Types and Allocated Movement Types)

SAP table T150 has 3 primary key fields being MANDT,BSTAR,SOBKZ.

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
BSTAR Stock type CHAR 1 0 T064B BSTAR
SOBKZ Special Stock Indicator CHAR 1 0 T148 SOBKZ
BWARS Movement type (inventory management) CHAR 3 0 T156 BWART
BWARH Movement type (inventory management) CHAR 3 0 T156 BWART
XMANU Checkbox CHAR 1 0 XFELD
No
X Yes
CHAZV Indicator: batch status management active CHAR 1 0 CHAZV

T150 foreign key relationships

Table Field Check Table Check Field
0 T150 BSTAR T064B Stock Types and Texts for Physical Inventory SPRAS
0 T150 BSTAR T064B Stock Types and Texts for Physical Inventory BSTAR
1 T150 BWARH T156 Movement Type MANDT
1 T150 BWARH T156 Movement Type BWART
0 T150 BWARS T156 Movement Type MANDT
0 T150 BWARS T156 Movement Type BWART
1 T150 MANDT T000 Clients MANDT
0 T150 SOBKZ T148 Special Stock Indicator MANDT
0 T150 SOBKZ T148 Special Stock Indicator SOBKZ