SAP table T160S (Selection Parameters for Purchasing Lists)

SAP table T160S has 2 primary key fields being MANDT,SELPA.

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
SELPA Selection parameter for purchasing lists CHAR 10 0 SELPA
WE000 Comparison Operand for Quantity Delivered CHAR 2 0 WE000
WE00E Take "Inward Delivery Completed" Indicator Into Account CHAR 1 0 SELIK
WE00S Indicator: Take GR Blocked Stock Into Account CHAR 1 0 SSPER
WEBE0 Comparison Operand for Quantity Delivered CHAR 2 0 WE000
WEBEE Take "Inward Delivery Completed" Indicator Into Account CHAR 1 0 SELIK
WEBES Indicator: Take GR Blocked Stock Into Account CHAR 1 0 SSPER
WEBET Indicator: Take Underdelivery Tolerance Into Account CHAR 1 0 SUNTO
WERE0 Comparison Operand for Quantity Delivered CHAR 2 0 WE000
WEREE Take "Inward Delivery Completed" Indicator Into Account CHAR 1 0 SELIK
WERES Indicator: Take GR Blocked Stock Into Account CHAR 1 0 SSPER
WERET Indicator: Take Underdelivery Tolerance Into Account CHAR 1 0 SUNTO
WEREP Invoice Variance Tolerance DEC 3 1 REPRZ
RE000 Comparison Operand to Invoice Receipt Quantity CHAR 2 0 RE000
REBE0 Comparison Operand to Invoice Receipt Quantity CHAR 2 0 RE000
REBEP Invoice Variance Tolerance DEC 3 1 REPRZ
AN000 Comparison Operand to Down Payment Amount CHAR 2 0 AN000
WS000 Comparison Operand to GR Blocked Stock CHAR 2 0 WS000
SWEPO Provision for Goods Receipt CHAR 1 0 SWEPO
No selection
+ Provision for GR/IR
- No provision for GR/IR
SREPO Provision for Invoice Receipt CHAR 1 0 SREPO
SLOEK Selection by deletion indicator CHAR 1 0 SLOEK
ZWBW0 Comparison Operand for Target Value CHAR 2 0 DZWBW0
ZWBWT Tolerance for Comparison with Target Value DEC 3 1 DZWBWT
ZMBM0 Comparison Operand for Target Quantity CHAR 2 0 DZMBM0
ZMBMT Tolerance for Comparison with Target Quantity DEC 3 1 DZMBMT
LFZAB Validity period expired CHAR 1 0 LFZAB
BM000 Comparison operand for released/scheduled quantity CHAR 2 0 BM000
ANGEB Selection quotation exists CHAR 1 0 ANGEB
WA000 Comparison Operand Between Quantity Issued and 0 CHAR 2 0 WA000
WAWE0 Comparison Operand Between Quantity Issued and Qty Delivered CHAR 2 0 WAWE0
WABE0 Comparison Operand Between Quantity Issued and Qty Ordered CHAR 2 0 WABE0
AV000 Comparison Operand Between Notified Quantity and 0 CHAR 2 0 AV000
AVWE0 Comparison operand between notified and delivered quantity CHAR 2 0 AVWE0
AVBE0 Comparison operand between notified and ordered quantity CHAR 2 0 AVBE0
VARANZ Display variants CHAR 1 0 VARANZDB
GW000 Comparison Operand Between Rough GR Quantity and Quantity 0 CHAR 2 0 GW000
GWWE0 Comparison Operand Between Rough GR Qty and Qty Delivered CHAR 2 0 GWWE0
GWBE0 Comparison Operator Between Rough GR Qty and Qty Ordered CHAR 2 0 GWBE0
RETOU Selection by Returns CHAR 1 0 RETOU
Including returns items
+ Returns items only
- Excluding returns items
RE00E Take Final Invoice Indicator Into Account CHAR 1 0 SEREK
REBEE Take Final Invoice Indicator Into Account CHAR 1 0 SEREK
SMEMO Indicator for Displaying Held Purchase Orders CHAR 1 0 SMEMO

T160S foreign key relationships

Table Field Check Table Check Field
0 T160S MANDT T000 Clients MANDT