SAP Table DFKKTXINV
Tax Invoices
DFKKTXINV (Tax Invoices) 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 DFKKTXINV to other SAP tables.
DFKKTXINV table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||
| OPBEL | Number of Contract Accts Rec. & Payable Doc. | OPBEL_KK | DFKKKO | CHAR | 12 | 0 | ||||||
| BUKRS | Company Code | BUKRS | T001 | CHAR | 4 | 0 | ||||||
| TXINVZ | Counter for Tax Invoice | TXINVZ_KK | NUMC | 4 | 0 | |||||||
| BUPLA | Business Place | BUPLA | J_1BBRANCH | CHAR | 4 | 0 | ||||||
| GPART | Business Partner Number | GPART_KK | BUT000 | CHAR | 10 | 0 | ||||||
| VKONT | Contract Account Number | VKONT_KK | CHAR | 12 | 0 | |||||||
| BUDAT | Posting Date in the Document | BUDAT | DATS | 8 | 0 | |||||||
| ERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | 0 | |||||||
| DRUCKDAT | Print Date | DRUCKDAT_KK | DATS | 8 | 0 | |||||||
| XCANC | Document Reversed | XCANC_KK | CHAR | 1 | 0 |
Possible values
|
||||||
| TXINV | Number of Tax Invoice | TXINV_KK | CHAR | 16 | 0 | |||||||
| TXYER | Year of Tax Return | TXYER_KK | NUMC | 4 | 0 | |||||||
| BETRH | Amount In Local Currency With +/- Signs | BETRH_KK | CURR | 13 | 2 | |||||||
DFKKTXINV foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| DFKKTXINV | BUKRS | DFKKTXINV | BUKRS | T001 | Company Codes | BUKRS |
| DFKKTXINV | BUKRS | DFKKTXINV | MANDT | T001 | Company Codes | MANDT |
| DFKKTXINV | BUPLA | DFKKTXINV | MANDT | J_1BBRANCH | Business Place | MANDT |
| DFKKTXINV | BUPLA | DFKKTXINV | BUKRS | J_1BBRANCH | Business Place | BUKRS |
| DFKKTXINV | BUPLA | DFKKTXINV | BUPLA | J_1BBRANCH | Business Place | BRANCH |
| DFKKTXINV | GPART | DFKKTXINV | MANDT | BUT000 | BP: General data I | CLIENT |
| DFKKTXINV | GPART | DFKKTXINV | GPART | BUT000 | BP: General data I | PARTNER |
| DFKKTXINV | MANDT | DFKKTXINV | MANDT | T000 | Clients | MANDT |
| DFKKTXINV | OPBEL | DFKKTXINV | MANDT | DFKKKO | Header Data in Open Item Accounting Document | MANDT |
| DFKKTXINV | OPBEL | DFKKTXINV | OPBEL | DFKKKO | Header Data in Open Item Accounting Document | OPBEL |
