SAP table T184 (Sales Documents: Item Category Determination)
SAP table T184 has 5 primary key fields being MANDT,AUART,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 | |
AUART | Sales Document Type | CHAR | 4 | 0 | TVAK | AUART | |
MTPOS | Item Category Group from Material Master | CHAR | 4 | 0 | TPTM | MTPOS | |
VWPOS | Item Usage | CHAR | 4 | 0 | TVVW | VWPOS | |
UEPST | Item Category of the Higher-Level Item | CHAR | 4 | 0 | TVPT | UEPST | |
PSTYV | Default Item Category for the Document | CHAR | 4 | 0 | TVPT | PSTYD | |
PSTY1 | Manual Entries Allowed for Item Category in the Document | CHAR | 4 | 0 | TVPT | PSTYM | |
PSTY2 | Manual Entries Allowed for Item Category in the Document | CHAR | 4 | 0 | TVPT | PSTYM | |
PSTY3 | Manual Entries Allowed for Item Category in the Document | CHAR | 4 | 0 | TVPT | PSTYM | |
PSTY4 | Manual Entries Allowed for Item Category in the Document | CHAR | 4 | 0 | TVPT | PSTYM | |
PSTY5 | Manual Entries Allowed for Item Category in the Document | CHAR | 4 | 0 | TVPT | PSTYM | |
PSTY6 | Manual Entries Allowed for Item Category in the Document | CHAR | 4 | 0 | TVPT | PSTYM | |
PSTY7 | Manual Entries Allowed for Item Category in the Document | CHAR | 4 | 0 | TVPT | PSTYM | |
PSTY8 | Manual Entries Allowed for Item Category in the Document | CHAR | 4 | 0 | TVPT | PSTYM | |
PSTY9 | Manual Entries Allowed for Item Category in the Document | CHAR | 4 | 0 | TVPT | PSTYM | |
PSTY10 | Manual Entries Allowed for Item Category in the Document | CHAR | 4 | 0 | TVPT | PSTYM | |
PSTY11 | Manual Entries Allowed for Item Category in the Document | CHAR | 4 | 0 | TVPT | PSTYM | |
ERNAM | Name of Person Responsible for Creating the Object | CHAR | 12 | 0 | ERNAM |
T184 foreign key relationships
Table | Field | Check Table | Check Field | |
---|---|---|---|---|
0 T184 | AUART | TVAK | Sales Document Types | MANDT |
0 T184 | AUART | TVAK | Sales Document Types | AUART |
1 T184 | MANDT | T000 | Clients | MANDT |
0 T184 | MTPOS | TPTM | Materials: Item Category Groups in Material Master | MTPOS |
1 T184 | PSTY1 | TVPT | Sales Documents: Item categories | MANDT |
1 T184 | PSTY1 | TVPT | Sales Documents: Item categories | PSTYV |
0 T184 | PSTY10 | TVPT | Sales Documents: Item categories | MANDT |
0 T184 | PSTY10 | TVPT | Sales Documents: Item categories | PSTYV |
1 T184 | PSTY11 | TVPT | Sales Documents: Item categories | MANDT |
1 T184 | PSTY11 | TVPT | Sales Documents: Item categories | PSTYV |
0 T184 | PSTY2 | TVPT | Sales Documents: Item categories | MANDT |
0 T184 | PSTY2 | TVPT | Sales Documents: Item categories | PSTYV |
1 T184 | PSTY3 | TVPT | Sales Documents: Item categories | MANDT |
1 T184 | PSTY3 | TVPT | Sales Documents: Item categories | PSTYV |
0 T184 | PSTY4 | TVPT | Sales Documents: Item categories | MANDT |
0 T184 | PSTY4 | TVPT | Sales Documents: Item categories | PSTYV |
1 T184 | PSTY5 | TVPT | Sales Documents: Item categories | MANDT |
1 T184 | PSTY5 | TVPT | Sales Documents: Item categories | PSTYV |
0 T184 | PSTY6 | TVPT | Sales Documents: Item categories | MANDT |
0 T184 | PSTY6 | TVPT | Sales Documents: Item categories | PSTYV |
1 T184 | PSTY7 | TVPT | Sales Documents: Item categories | MANDT |
1 T184 | PSTY7 | TVPT | Sales Documents: Item categories | PSTYV |
0 T184 | PSTY8 | TVPT | Sales Documents: Item categories | MANDT |
0 T184 | PSTY8 | TVPT | Sales Documents: Item categories | PSTYV |
1 T184 | PSTY9 | TVPT | Sales Documents: Item categories | MANDT |
1 T184 | PSTY9 | TVPT | Sales Documents: Item categories | PSTYV |
0 T184 | PSTYV | TVPT | Sales Documents: Item categories | MANDT |
0 T184 | PSTYV | TVPT | Sales Documents: Item categories | PSTYV |
1 T184 | UEPST | TVPT | Sales Documents: Item categories | MANDT |
1 T184 | UEPST | TVPT | Sales Documents: Item categories | PSTYV |
0 T184 | VWPOS | TVVW | Item Usage | MANDT |