SAP table T184L (Sales Documents: Item Category Determination)
SAP table T184L has 5 primary key fields being MANDT,LFART,MTPOS,VWPOS,UEPST.
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 | |
LFART | Delivery Type | CHAR | 4 | 0 | TVLK | LFART | |
MTPOS | Item Category Group from Material Master | CHAR | 4 | 0 | TPTM | MTPOS | |
VWPOS | Item Usage | CHAR | 4 | 0 | VWPOS | ||
UEPST | Item category of the higher-level item | CHAR | 4 | 0 | TVPT | UEPST_VL | |
PSTYV | Default item category for delivery | CHAR | 4 | 0 | TVPT | PSTYD_VL | |
PSTY1 | Manual entries allowed for item category in the delivery | CHAR | 4 | 0 | TVPT | PSTYM_VL | |
PSTY2 | Manual entries allowed for item category in the delivery | CHAR | 4 | 0 | TVPT | PSTYM_VL | |
PSTY3 | Manual entries allowed for item category in the delivery | CHAR | 4 | 0 | TVPT | PSTYM_VL | |
PSTY4 | Manual entries allowed for item category in the delivery | CHAR | 4 | 0 | TVPT | PSTYM_VL | |
PSTY5 | Manual entries allowed for item category in the delivery | CHAR | 4 | 0 | TVPT | PSTYM_VL | |
PSTY6 | Manual entries allowed for item category in the delivery | CHAR | 4 | 0 | TVPT | PSTYM_VL | |
PSTY7 | Manual entries allowed for item category in the delivery | CHAR | 4 | 0 | TVPT | PSTYM_VL | |
PSTY8 | Manual entries allowed for item category in the delivery | CHAR | 4 | 0 | TVPT | PSTYM_VL | |
PSTY9 | Manual entries allowed for item category in the delivery | CHAR | 4 | 0 | TVPT | PSTYM_VL | |
PSTY10 | Manual entries allowed for item category in the delivery | CHAR | 4 | 0 | TVPT | PSTYM_VL | |
PSTY11 | Manual entries allowed for item category in the delivery | CHAR | 4 | 0 | TVPT | PSTYM_VL | |
ERNAM | Name of Person Responsible for Creating the Object | CHAR | 12 | 0 | ERNAM |
T184L foreign key relationships
Table | Field | Check Table | Check Field | |
---|---|---|---|---|
0 T184L | LFART | TVLK | Delivery Types | MANDT |
0 T184L | LFART | TVLK | Delivery Types | LFART |
1 T184L | MANDT | T000 | Clients | MANDT |
0 T184L | MTPOS | TPTM | Materials: Item Category Groups in Material Master | MTPOS |
1 T184L | PSTY1 | TVPT | Sales Documents: Item categories | MANDT |
1 T184L | PSTY1 | TVPT | Sales Documents: Item categories | PSTYV |
0 T184L | PSTY10 | TVPT | Sales Documents: Item categories | MANDT |
0 T184L | PSTY10 | TVPT | Sales Documents: Item categories | PSTYV |
1 T184L | PSTY11 | TVPT | Sales Documents: Item categories | MANDT |
1 T184L | PSTY11 | TVPT | Sales Documents: Item categories | PSTYV |
0 T184L | PSTY2 | TVPT | Sales Documents: Item categories | MANDT |
0 T184L | PSTY2 | TVPT | Sales Documents: Item categories | PSTYV |
1 T184L | PSTY3 | TVPT | Sales Documents: Item categories | MANDT |
1 T184L | PSTY3 | TVPT | Sales Documents: Item categories | PSTYV |
0 T184L | PSTY4 | TVPT | Sales Documents: Item categories | MANDT |
0 T184L | PSTY4 | TVPT | Sales Documents: Item categories | PSTYV |
1 T184L | PSTY5 | TVPT | Sales Documents: Item categories | MANDT |
1 T184L | PSTY5 | TVPT | Sales Documents: Item categories | PSTYV |
0 T184L | PSTY6 | TVPT | Sales Documents: Item categories | MANDT |
0 T184L | PSTY6 | TVPT | Sales Documents: Item categories | PSTYV |
1 T184L | PSTY7 | TVPT | Sales Documents: Item categories | MANDT |
1 T184L | PSTY7 | TVPT | Sales Documents: Item categories | PSTYV |
0 T184L | PSTY8 | TVPT | Sales Documents: Item categories | MANDT |
0 T184L | PSTY8 | TVPT | Sales Documents: Item categories | PSTYV |
1 T184L | PSTY9 | TVPT | Sales Documents: Item categories | MANDT |
1 T184L | PSTY9 | TVPT | Sales Documents: Item categories | PSTYV |
0 T184L | PSTYV | TVPT | Sales Documents: Item categories | MANDT |
0 T184L | PSTYV | TVPT | Sales Documents: Item categories | PSTYV |
1 T184L | UEPST | TVPT | Sales Documents: Item categories | MANDT |
1 T184L | UEPST | TVPT | Sales Documents: Item categories | PSTYV |