SAP table T161W (Order Types for Stock Transfer)
SAP table T161W has 4 primary key fields being MANDT,RESWK,WERKS,BSTYP.
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
RESWK
Supplying (issuing) plant in case of stock transport order
CHAR
4
0
*
RESWK
WERKS
Plant
CHAR
4
0
T001W
EWERK
BSTYP
Purchasing Document Category
CHAR
1
0
BSTYP
Possible values
A
Request for quotation
B
Purchase requisition
C
Central Contract
F
Purchase order
I
Info record
K
Contract
L
Scheduling agreement
N
Central Request for Quotation
O
Quotation
Q
Service entry sheet
R
Request for Quotation
S
Simplified service entry sheet
T
Central Quotation
W
Source list
BSART
Purchasing Document Type
CHAR
4
0
T161
ESART
UML1S
Stock Transfer According to One-Step Procedure
CHAR
1
0
UML1S
ZOLLA
Customs Office: Office of Exit/Entry for Foreign Trade
CHAR
6
0
T615
DZOLLS
EXPVZ
Mode of Transport at the Border (Intrastat)
CHAR
1
0
T618
EXPVZ
EXPRF
Procedure
CHAR
8
0
T616
EXPRF
TOLKZ
Indicator: Underdelivery Tolerance for Stock Transfers
CHAR
1
0
TOLKZ
CMM_MTM_STO_MODE
Determination of Exposure
CHAR
1
0
CMM_MTM_STO_MIRRORING
Possible values
Determination for Receiving Company Code Only
1
Determination for Receiving and Issuing Company Code
2
Determination for Issuing Company Code Only
LOGTRM_STO_MODE
Raw Exposure Mode for Cross-Company Stock Transport Document
CHAR
1
0
LOGTRM_STO_MODE
Possible values
Raw Exposure from Receiving Company Code Only
1
Raw Exposure from Receiving and Issuing Company Code
2
Raw Exposure from Issuing Company Code Only
PORTI
Port/Airport
CHAR
4
0
/ECRS/TPRT
/ECRS/PORTI
T161W foreign key relationships
Table
Field
Check Table
Check Field
0 T161W
BSART
T161
Purchasing Document Types
MANDT
1 T161W
EXPRF
T616
Procedure
LAND1
0 T161W
EXPVZ
T618
Mode of Transport at the Border
LAND1
1 T161W
MANDT
T000
Clients
MANDT
0 T161W
WERKS
T001W
Plants/Branches
WERKS
1 T161W
ZOLLA
T615
Foreign Trade: Customs Offices
LAND1
1 T161W
ZOLLA
T615
Foreign Trade: Customs Offices
ZOLLA