SAP Table T169P

Parameters, Invoice Verification

T169P (Parameters, Invoice Verification) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link T169P to other SAP tables.

T169P table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
BUKRS Company Code BUKRS T001 CHAR 4 0
XEKAN Indicator: notification of purchase order header texts XEKAN CHAR 1 0
X Yes
NULL No
XMAIL Indicator: send MAIL automatically XMAIL CHAR 1 0
X Yes
NULL No
XSPST Indicator: stochastic block XSPST CHAR 1 0
X Yes
NULL No
XSPSO Indicator: check item amount XSPSO CHAR 1 0
X Yes
NULL No
BTSTO Threshold value for stochastic block BTSTO CURR 13 2
PRSTO Percentage for stochastic block PRSTO DEC 4 2
TAX_DYNNR Version for entering tax data TAX_DYNNR CHAR 4 0
0801 One tax amount and tax code
0802 Two tax amounts and tax codes
0804 Four tax amounts and tax codes
AB_DYNNR Version for item list (Logistics Invoice Verification) AB_DYNNR CHAR 4 0
PRAVT Price change: carried over from previous to current period PRAVT CHAR 1 0
X Yes
NULL No
XKOERL Indicates that correct invoices are autom. set to completed XKOERL CHAR 1 0
X Yes
NULL No
BNK Indicates unplanned delivery costs t/b posted MM_IV_BNK CHAR 1 0
NULL Distribute among invoice items
2 Different G/L line
1 Distribute Among Invoice Items Incl. Planned Delivery Costs
XPLCU Indicator: treatment of exchange rate differences XPLCU_T169P CHAR 1 0
NULL Exchange rate differences between GR and IR
X Exch. rate differences between IR and assumed exch. rate
N No exchange rate differences, only price differences
KURST Exchange rate type KURST_T169P TCURV CHAR 4 0
XLOGO Display logo MRM_XLOGO CHAR 1 0
X Yes
NULL No
URL Uniform Resource Locator URL CHAR 132 0
XBUKRS Indicator: check company code X_BUKRS CHAR 1 0
X Yes
NULL No
XBLDAT Indicator: check invoice date X_BLDAT CHAR 1 0
X Yes
NULL No
XXBLNR Indicator: Check reference number X_XBLNR CHAR 1 0
X Yes
NULL No
IRTAX Tax Treatment in Invoice Reduction MM_IV_IREDTAX CHAR 1 0
NULL Tax reduction in complaint document
1 Tax reduction in original document
CTHW Currency Type and Valuation View CURTP CHAR 2 0
00 Document currency
10 Company code currency
11 Company code currency, group valuation
12 Company code currency, profit center valuation
20 Controlling area currency
30 Group currency
31 Group currency, group valuation
32 Group currency, profit center valuation
40 Hard currency
50 Index-based currency
60 Global company currency
70 Controlling object currency
71 Controlling object currency, group valuation
72 Controlling object currency, profit center valuation
80 Ledger currency
81 Ledger currency, group valuation
82 Ledger currency, profit center valuation
90 Profit center invoice currency
92 Profit center accounting currency, profit center valuation
A0 Financial management area currency
B0 Operating concern currency
B2 Operating concern currency, profit center valuation
C0 Consolidation unit currency
C1 Consolidation unit currency, group valuation
C2 Consolidation unit currency, profit center valuation
KDHW Treatment of Exchange Rate Diffs. in Company Code Currency KDHW CHAR 1 0
NULL Allocate Exchange Rate Differences in Inventory/Usage
X Post Exchange Rate Differences to Exchange Rate Diff Account
CTML1 Currency Type and Valuation View CURTP CHAR 2 0
00 Document currency
10 Company code currency
11 Company code currency, group valuation
12 Company code currency, profit center valuation
20 Controlling area currency
30 Group currency
31 Group currency, group valuation
32 Group currency, profit center valuation
40 Hard currency
50 Index-based currency
60 Global company currency
70 Controlling object currency
71 Controlling object currency, group valuation
72 Controlling object currency, profit center valuation
80 Ledger currency
81 Ledger currency, group valuation
82 Ledger currency, profit center valuation
90 Profit center invoice currency
92 Profit center accounting currency, profit center valuation
A0 Financial management area currency
B0 Operating concern currency
B2 Operating concern currency, profit center valuation
C0 Consolidation unit currency
C1 Consolidation unit currency, group valuation
C2 Consolidation unit currency, profit center valuation
KDML1 Treatment of Exchange Rate Differences in First ML Currency KDML1 CHAR 1 0
NULL Allocate Exchange Rate Differences in Inventory/Usage
X Post Exchange Rate Differences to Exchange Rate Diff Account
CTML2 Currency Type and Valuation View CURTP CHAR 2 0
00 Document currency
10 Company code currency
11 Company code currency, group valuation
12 Company code currency, profit center valuation
20 Controlling area currency
30 Group currency
31 Group currency, group valuation
32 Group currency, profit center valuation
40 Hard currency
50 Index-based currency
60 Global company currency
70 Controlling object currency
71 Controlling object currency, group valuation
72 Controlling object currency, profit center valuation
80 Ledger currency
81 Ledger currency, group valuation
82 Ledger currency, profit center valuation
90 Profit center invoice currency
92 Profit center accounting currency, profit center valuation
A0 Financial management area currency
B0 Operating concern currency
B2 Operating concern currency, profit center valuation
C0 Consolidation unit currency
C1 Consolidation unit currency, group valuation
C2 Consolidation unit currency, profit center valuation
KDML2 Treatment of Exchange Rate Differences in Second ML Currency KDML2 CHAR 1 0
NULL Allocate Exchange Rate Differences in Inventory/Usage
X Post Exchange Rate Differences to Exchange Rate Diff Account
RETDUEDATE Due Date for Retention is a Required Field RET_DUE_DATE_MANDATORY CHAR 1 0
X Yes
NULL No
RETUMSKZ Special G/L Indicator RET_UMSKZ T074U CHAR 1 0
RETWHTAX Post Withholding Tax in Retention Document RET_WHTAX CHAR 1 0
X Yes
NULL No
INV_CHANGE Allow Changes to Posted Invoices INV_CHANGE_ACTIVE CHAR 1 0

T169P foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
T169P BUKRS T169P MANDT T001 Company Codes MANDT
T169P BUKRS T169P BUKRS T001 Company Codes BUKRS
T169P KURST T169P MANDT TCURV Exchange rate types for currency translation MANDT
T169P KURST T169P KURST TCURV Exchange rate types for currency translation KURST
T169P MANDT T169P MANDT T000 Clients MANDT
T169P RETUMSKZ T169P MANDT T074U Special G/L Indicator Properties MANDT
T169P RETUMSKZ * T074U Special G/L Indicator Properties KOART
T169P RETUMSKZ T169P RETUMSKZ T074U Special G/L Indicator Properties UMSKZ