SAP table TWRF11 (Plant blocking reasons)

SAP table TWRF11 has 2 primary key fields being MANDT,SPGR1.

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
SPGR1 Blocking Reason CHAR 2 0 SPGR1
SPVAA Blocking reason, SD order, general CHAR 2 0 TVAST SPVAA
SPVAV Blocking reason SD sales order, sales area CHAR 2 0 TVAST SPVAV
SPVLA Blocking reason, SD delivery, general CHAR 2 0 TVLS SPVLA
SPVLV Blocking reason, SD delivery, sales area CHAR 2 0 TVLS SPVLV
SPVFA Blocking reason, SD billing doc., general CHAR 2 0 TVFS SPVFA
SPVFV Blocking reason, SD billing document, sales area CHAR 2 0 TVFS SPVFV
SPMDL Block POS master data outbound processing CHAR 2 0 SPMDL
SPDISPO Stock Planning Block in F&R CHAR 2 0 SPDISPO
01 Automatic MRP: Warning / Manual MRP: Warning
02 Automatic MRP: Warning / Manual MRP: Error
03 Automatic MRP: Error / Manual MRP: Warning
04 Automatic MRP: Error / Manual MRP: Error
05 Automatic MRP: No Check / Manual MRP: Error
06 Automatic MRP: No Check / Manual MRP: Warning
07 Automatic MRP: Error / Manual MRP: No Check
08 Automatic MRP: Warning / Manual MRP: No Check
SPINFO Block (Purely Informative) CHAR 1 0 SPINFO
Operational Lock (Not Informational)
X Purely Informational Block

TWRF11 foreign key relationships

Table Field Check Table Check Field
0 TWRF11 SPVAA TVAST Sales Document Blocking Reasons: Texts MANDT
0 TWRF11 SPVAA TVAST Sales Document Blocking Reasons: Texts SPRAS
1 TWRF11 SPVAV TVAST Sales Document Blocking Reasons: Texts MANDT
1 TWRF11 SPVAV TVAST Sales Document Blocking Reasons: Texts SPRAS
0 TWRF11 SPVFA TVFS Billing: Reasons for Blocking FAKSP
1 TWRF11 SPVFV TVFS Billing: Reasons for Blocking FAKSP
0 TWRF11 SPVLA TVLS Deliveries: Blocking Reasons/Criteria MANDT
0 TWRF11 SPVLA TVLS Deliveries: Blocking Reasons/Criteria LIFSP
1 TWRF11 SPVLV TVLS Deliveries: Blocking Reasons/Criteria MANDT
1 TWRF11 SPVLV TVLS Deliveries: Blocking Reasons/Criteria LIFSP