SAP table T158 (Transaction Control: Inventory Management)
SAP table T158 has 2 primary key fields being MANDT,TCODE.
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 | |||||||||||||||||||||||||||||
TCODE | Transaction Code | CHAR | 20 | 0 | TSTC | TCODE | |||||||||||||||||||||||||||||
TRTYP | Transaction type | CHAR | 1 | 0 | TRTYP |
|
|||||||||||||||||||||||||||||
BLART | Document Type | CHAR | 2 | 0 | T003 | BLART | |||||||||||||||||||||||||||||
BLAUM | Document type of revaluation document | CHAR | 2 | 0 | T003 | BLAUM | |||||||||||||||||||||||||||||
VGART | Transaction/Event Type | CHAR | 2 | 0 | T158V | VGART | |||||||||||||||||||||||||||||
KZBEW | Movement Indicator | CHAR | 1 | 0 | KZBEW |
|
|||||||||||||||||||||||||||||
FCODE | Function code | CHAR | 20 | 0 | FCODE | ||||||||||||||||||||||||||||||
KZVAR | F status variant with regard to transaction/movement type | CHAR | 1 | 0 | KZVAR | ||||||||||||||||||||||||||||||
KZTIT | Title variant for SET TITLE-BAR | CHAR | 1 | 0 | KZTIT | ||||||||||||||||||||||||||||||
XSELE | Item is proposed preselected | CHAR | 1 | 0 | XSELE | ||||||||||||||||||||||||||||||
WEVER | Version for Printing GR/GI Slip | CHAR | 1 | 0 | WEVER |
|
|||||||||||||||||||||||||||||
PRREG | Checking rule for the availability check | CHAR | 2 | 0 | T441R | PRREG | |||||||||||||||||||||||||||||
BLA2D | Doc. type for additional doc. in purchase account management | CHAR | 2 | 0 | T003 | BLA2D | |||||||||||||||||||||||||||||
XARCH | Storage upon goods movements active | CHAR | 1 | 0 | XOARC |
T158 foreign key relationships
Table | Field | Check Table | Check Field | |
---|---|---|---|---|
0 T158 | BLA2D | T003 | Document Types | MANDT |
1 T158 | BLART | T003 | Document Types | MANDT |
0 T158 | BLAUM | T003 | Document Types | MANDT |
1 T158 | MANDT | T000 | Clients | MANDT |
0 T158 | PRREG | T441R | Values Table for Checking Rule | MANDT |
0 T158 | PRREG | T441R | Values Table for Checking Rule | PRREG |
1 T158 | TCODE | TSTC | SAP Transaction Codes | TCODE |
0 T158 | VGART | T158V | Inv. Mngmt - General: Transaction/Event Types Allowed | VGART |