SAP table T169L (Supplier-Specific Parameters for Invoice Verification)
SAP table T169L has 3 primary key fields being MANDT,BUKRS,TOGRR.
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 | |
BUKRS | Company Code | CHAR | 4 | 0 | T001 | BUKRS | |
TOGRR | Tolerance Group in Invoice Verification | CHAR | 4 | 0 | TOGRR | ||
TEXT | Explanatory text for IV tolerance group | CHAR | 40 | 0 | TOGRRTEXT | ||
XAKZPU | Indicates Tolerance Limit Check | CHAR | 1 | 0 | XGPJN | ||
TAKZPU | Positive Small Difference | CURR | 13 | 2 | TAKZPU | ||
XAKZPB | Indicates Tolerance Limit Check | CHAR | 1 | 0 | XGPJN | ||
TAKZPB | Absolute Positive Upper Acceptance Limit | CURR | 13 | 2 | TAKZPB | ||
XAKZPP | Indicates Tolerance Limit Check | CHAR | 1 | 0 | XGPJN | ||
TAKZPP | Percentage Positive Upper Acceptance Limit | DEC | 4 | 2 | TAKZPP | ||
XAKZNU | Indicates Tolerance Limit Check | CHAR | 1 | 0 | XGPJN | ||
TAKZNU | Absolute Negative Lower Acceptance Limit | CURR | 13 | 2 | TAKZNU | ||
XAKZNB | Indicates Tolerance Limit Check | CHAR | 1 | 0 | XGPJN | ||
TAKZNB | Negative Small Difference | CURR | 13 | 2 | TAKZNB | ||
XAKZNP | Indicates Tolerance Limit Check | CHAR | 1 | 0 | XGPJN | ||
TAKZNP | Percentage Negative Lower Acceptance Limit | DEC | 4 | 2 | TAKZNP | ||
XRKUER | Indicates Tolerance Limit Check | CHAR | 1 | 0 | XGPJN | ||
TRKPB | Autom. invoice reduction: absolute upper limit | CURR | 13 | 2 | TRKPB | ||
XRKPP | Indicates Tolerance Limit Check | CHAR | 1 | 0 | XGPJN | ||
TRKPP | Autom. invoice reduction: percentage upper limit | DEC | 4 | 2 | TRKPP |
T169L foreign key relationships
Table | Field | Check Table | Check Field | |
---|---|---|---|---|
0 T169L | BUKRS | T001 | Company Codes | BUKRS |
1 T169L | MANDT | T000 | Clients | MANDT |