SAP table TWBO1 (Customizing table for opt. PO-based load building profiles)

SAP table TWBO1 has 4 primary key fields being MANDT,BOPNR,BORESTRI,BOTYPI.

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
BOPNR Restriction Profile for PO-Based Load Building CHAR 4 0 TWBO2 BOPNR
BORESTRI Internal restriction code for PO-based load building CHAR 2 0 BORESTRI
01 Value (net)
02 Weight (gross)
03 Volume
04 Units
05 Weight (net)
BOTYPI Internal restriction category indicator for load building CHAR 2 0 BOTYPI
01 Minimum
02 Maximum
03 Multiple
BORESMNG Target volumes of restriction in pur.-ord.-based load buildg QUAN 13 3 BORESMNG
MEINS Base Unit of Measure UNIT 3 0 T006 MEINS
BORESVOL Target volumes of restriction in pur.-ord.-based load buildg QUAN 13 3 BORESVOL
VOLEH Volume unit UNIT 3 0 T006 VOLEH
BORESWGT Target weight of restriction in pur.-ord.-based load buildg QUAN 13 3 BORESWGT
GEWEI Weight Unit UNIT 3 0 T006 GEWEI
BORESVAL Target value of restriction for optimum document calculation CURR 11 2 BORESVAL
WAERS Currency Key CUKY 5 0 TCURC WAERS
KSCHL Condition Type CHAR 4 0 * KSCHA
BOTOL Allowed Toleranace for Load Building Restriction DEC 4 1 BOTOL
BORESPUN Target value of restriction f. optimized PO-based load build QUAN 13 3 BORESPUN
PUNEI Points Unit UNIT 3 0 T006 PUNEI

TWBO1 foreign key relationships

Table Field Check Table Check Field
0 TWBO1 BOPNR TWBO2 Table for restriction profile MANDT
0 TWBO1 BOPNR TWBO2 Table for restriction profile BOPNR
1 TWBO1 GEWEI T006 Units of Measurement MANDT
1 TWBO1 GEWEI T006 Units of Measurement MSEHI
0 TWBO1 MEINS T006 Units of Measurement MANDT
0 TWBO1 MEINS T006 Units of Measurement MSEHI
1 TWBO1 PUNEI T006 Units of Measurement MANDT
0 TWBO1 VOLEH T006 Units of Measurement MANDT
0 TWBO1 VOLEH T006 Units of Measurement MSEHI
1 TWBO1 WAERS TCURC Currency Codes MANDT
1 TWBO1 WAERS TCURC Currency Codes WAERS