SAP table T460A (Special procurement key)
SAP table T460A has 3 primary key fields being MANDT,WERKS,SOBSL.
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
Client
CLNT
3
0
MANDT
Plant
CHAR
4
0
T001W
WERKS_D
Special procurement type
CHAR
2
0
SOBSL
BESKZ
Procurement type
CHAR
1
0
BESCH
Possible values
E
In-house production
F
External procurement
SOBES
Special procurement type
CHAR
1
0
SOBES
Possible values
0
Standard external procurement
2
Consignment
3
Subcontracting
7
Stock transfer
9
IS-OIL only: Stock transfer reservation
E
Standard in-house production
P
Production in plant 2
WRK02
Plant
CHAR
4
0
T001W
WERKS_D
CLCOR
Indicator for Direct Production (Collective Order)
CHAR
1
0
CLCOR
DUMPS
Phantom item indicator
CHAR
1
0
DUMPS
REWFG
Indicator: Withdrawal from an alternative plant
CHAR
1
0
REWFG
REWRK
Issuing Plant for the Dependent Reqmts/Reservation
CHAR
4
0
T001W
REWRK
DIRPR
Direct Procurement Indicator
CHAR
1
0
DIRPR
UMLDB
Indicator for Stock Transfer with MRP Areas
CHAR
1
0
MD_UMLDB
Possible values
Stock Transfer Reservations from the Plant to the MRP Area
1
Purchase Requisitions from the Plant to the MRP Area
ADDIN
Additional Information on BAdI MD_EXT_SUP
CHAR
20
0
MD_ADDIN
MLSCR
Multilevel Subcontracting Indicator
CHAR
1
0
MLSC_RELEVANT
T460A foreign key relationships
Table
Field
Check Table
Check Field
0 T460A
REWRK
T001W Plants/Branches
MANDT
0 T460A
REWRK
T001W Plants/Branches
WERKS
1 T460A
WERKS
T001W Plants/Branches
WERKS
0 T460A
WRK02
T001W Plants/Branches
MANDT
0 T460A
WRK02
T001W Plants/Branches
WERKS