SAP Table V_TIVEXFIACC
Generated Table for View
V_TIVEXFIACC (Generated Table for View) 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 V_TIVEXFIACC to other SAP tables.
Source: V_TIVEXFIACC (Generated Table for View)
V_TIVEXFIACC table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||||||||||||||||||||
| KTOPL | Chart of Accounts | KTOPL | T004 | CHAR | 4 | 0 | ||||||||||||||||||||||||||
| BUKRS | Company Code | BUKRS | T001 | CHAR | 4 | 0 | ||||||||||||||||||||||||||
| SAKNR | G/L Account Number | SAKNR | SKA1 | CHAR | 10 | 0 | ||||||||||||||||||||||||||
| TXT20 | G/L account short text | TXT20_SKAT | CHAR | 20 | 0 | |||||||||||||||||||||||||||
| TXT50 | G/L Account Long Text | TXT50_SKAT | CHAR | 50 | 0 | |||||||||||||||||||||||||||
| MCOD1SKAT | Search Term for Matchcode Search | MCDS1 | CHAR | 25 | 0 | |||||||||||||||||||||||||||
| BEGRU | Authorization Group | BRGRU | CHAR | 4 | 0 | |||||||||||||||||||||||||||
| BUSAB | Accounting clerk | BUSAB | T001S | CHAR | 2 | 0 | ||||||||||||||||||||||||||
| DATLZ | Date of the last interest calculation run | DATLZ | DATS | 8 | 0 | |||||||||||||||||||||||||||
| ERDATSKB1 | Date on which the Record Was Created | ERDAT_RF | DATS | 8 | 0 | |||||||||||||||||||||||||||
| ERNAMSKB1 | Name of Person who Created the Object | ERNAM_RF | CHAR | 12 | 0 | |||||||||||||||||||||||||||
| FDGRV | Planning group | FDGRV | T035 | CHAR | 10 | 0 | ||||||||||||||||||||||||||
| FDLEV | Planning level | FDLEV | T036 | CHAR | 2 | 0 | ||||||||||||||||||||||||||
| FIPLS | Financial Budget Item | FIPLS | NUMC | 3 | 0 | |||||||||||||||||||||||||||
| FSTAG | Field status group | FSTAG | T004F | CHAR | 4 | 0 | ||||||||||||||||||||||||||
| HBKID | Short Key for a House Bank | HBKID | T012 | CHAR | 5 | 0 | ||||||||||||||||||||||||||
| HKTID | ID for account details | HKTID | T012K | CHAR | 5 | 0 | ||||||||||||||||||||||||||
| KDFSL | Key for Exchange Rate Differences in Foreign Currency Accts | KDFSL | T030S | CHAR | 4 | 0 | ||||||||||||||||||||||||||
| MITKZ | Account is reconciliation account | MITKZ | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
| MWSKZ | Tax Category in Account Master Record | SMWSK | CHAR | 2 | 0 | |||||||||||||||||||||||||||
| STEXT | G/L account additional text | STEXT_SKB1 | CHAR | 50 | 0 | |||||||||||||||||||||||||||
| VZSKZ | Interest calculation indicator | VZSKZ | T056 | CHAR | 2 | 0 | ||||||||||||||||||||||||||
| WAERS | Account currency | WAERS_SKB1 | TCURC | CUKY | 5 | 0 | ||||||||||||||||||||||||||
| WMETH | Indicator: account managed in external system | WMETH | CHAR | 2 | 0 |
Possible values
|
||||||||||||||||||||||||||
| XGKON | Cash receipt account / cash disbursement account | XGKON | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
| XINTB | Indicator: Is account only posted to automatically? | XINTB | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
| XKRES | Indicator: Can Line Items Be Displayed by Account? | XKRES | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
| XLOEB | Indicator: Account marked for deletion? | XLOEV | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
| XNKON | Indicator: Supplement for automatic postings ? | XNKON | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
| XOPVW | Indicator: Open item management? | XOPVW | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
| XSPEBSKB1 | Indicator: Is Account Blocked for Posting? | XSPEB | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
| ZINDT | Key date of the last interest calculation | DZINDT | DATS | 8 | 0 | |||||||||||||||||||||||||||
| ZINRT | Interest calculation frequency in months | DZINRT | NUMC | 2 | 0 |
Possible values
|
||||||||||||||||||||||||||
| ZUAWA | Key for sorting according to assignment numbers | DZUAWA | TZUN | CHAR | 3 | 0 | ||||||||||||||||||||||||||
| ALTKT | Alternative account number in company code | ALTKT_SKB1 | CHAR | 10 | 0 | |||||||||||||||||||||||||||
| XMITK | Indicator: Reconcil.acct ready for input at time of posting? | XMITK | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
| RECID | Recovery Indicator | JV_RECIND | T8JJ | CHAR | 2 | 0 | ||||||||||||||||||||||||||
| FIPOS | Commitment Item | FIPOS | CHAR | 14 | 0 | |||||||||||||||||||||||||||
| XMWNO | Indicator: Tax code is not a required field | XMWNO | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
| XSALH | Indicator: Only Manage Balances in Local Currency | XSALH | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
| BEWGP | Valuation Group | BEWGP | CHAR | 10 | 0 | |||||||||||||||||||||||||||
| INFKY | Inflation Key | J_1AIFSKS | J_1AINFSKS | CHAR | 8 | 0 | ||||||||||||||||||||||||||
| TOGRU | Tolerance Group for G/L Accounts | TOGRU_S | T043S | CHAR | 4 | 0 | ||||||||||||||||||||||||||
| XBILK | Indicator: Account is a balance sheet account? | XBILK | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
| SAKAN | G/L account number, significant length | SAKAN | CHAR | 10 | 0 | |||||||||||||||||||||||||||
| BILKT | Group Account Number | BILKT | SKA1 | CHAR | 10 | 0 | ||||||||||||||||||||||||||
| ERDAT | Date on which the Record Was Created | ERDAT_RF | DATS | 8 | 0 | |||||||||||||||||||||||||||
| ERNAM | Name of Person who Created the Object | ERNAM_RF | CHAR | 12 | 0 | |||||||||||||||||||||||||||
| GVTYP | P&L statement account type | GVTYP | CHAR | 2 | 0 | |||||||||||||||||||||||||||
| KTOKS | G/L Account Group | KTOKS | T077S | CHAR | 4 | 0 | ||||||||||||||||||||||||||
| MUSTR | Number of the sample account | MUSTR | SKM1 | CHAR | 10 | 0 | ||||||||||||||||||||||||||
| VBUND | Company ID of trading partner | RASSC | T880 | CHAR | 6 | 0 | ||||||||||||||||||||||||||
| XLOEV | Indicator: Account marked for deletion? | XLOEV | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
| XSPEA | Indicator: account is blocked for creation ? | XSPEA | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
| XSPEB | Indicator: Is Account Blocked for Posting? | XSPEB | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
| XSPEP | Indicator: account blocked for planning ? | XSPEP | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
| MCOD1 | Search Term for Using Matchcode | MCODF | CHAR | 25 | 0 | |||||||||||||||||||||||||||
| FUNC_AREA | Functional Area | FKBER | TFKB | CHAR | 16 | 0 | ||||||||||||||||||||||||||
V_TIVEXFIACC foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| V_TIVEXFIACC | BILKT | V_TIVEXFIACC | BILKT | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| V_TIVEXFIACC | BILKT | T004 | KKTPL | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| V_TIVEXFIACC | BILKT | V_TIVEXFIACC | MANDT | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| V_TIVEXFIACC | BUKRS | V_TIVEXFIACC | MANDT | T001 | Company Codes | MANDT |
| V_TIVEXFIACC | BUKRS | V_TIVEXFIACC | BUKRS | T001 | Company Codes | BUKRS |
| V_TIVEXFIACC | BUSAB | V_TIVEXFIACC | MANDT | T001S | Accounting Clerks | MANDT |
| V_TIVEXFIACC | BUSAB | V_TIVEXFIACC | BUKRS | T001S | Accounting Clerks | BUKRS |
| V_TIVEXFIACC | BUSAB | V_TIVEXFIACC | BUSAB | T001S | Accounting Clerks | BUSAB |
| V_TIVEXFIACC | FDGRV | V_TIVEXFIACC | MANDT | T035 | Planning groups | MANDT |
| V_TIVEXFIACC | FDGRV | V_TIVEXFIACC | FDGRV | T035 | Planning groups | GRUPP |
| V_TIVEXFIACC | FDLEV | V_TIVEXFIACC | MANDT | T036 | Planning levels | MANDT |
| V_TIVEXFIACC | FDLEV | V_TIVEXFIACC | FDLEV | T036 | Planning levels | EBENE |
| V_TIVEXFIACC | FSTAG | V_TIVEXFIACC | MANDT | T004F | Field status definition groups | MANDT |
| V_TIVEXFIACC | FSTAG | T001 | FSTVA | T004F | Field status definition groups | BUKRS |
| V_TIVEXFIACC | FSTAG | V_TIVEXFIACC | FSTAG | T004F | Field status definition groups | FSTAG |
| V_TIVEXFIACC | FUNC_AREA | V_TIVEXFIACC | FUNC_AREA | TFKB | Functional areas | FKBER |
| V_TIVEXFIACC | FUNC_AREA | V_TIVEXFIACC | MANDT | TFKB | Functional areas | MANDT |
| V_TIVEXFIACC | HBKID | V_TIVEXFIACC | HBKID | T012 | House Banks | HBKID |
| V_TIVEXFIACC | HBKID | V_TIVEXFIACC | BUKRS | T012 | House Banks | BUKRS |
| V_TIVEXFIACC | HBKID | V_TIVEXFIACC | MANDT | T012 | House Banks | MANDT |
| V_TIVEXFIACC | HKTID | V_TIVEXFIACC | BUKRS | T012K | House Bank Accounts | BUKRS |
| V_TIVEXFIACC | HKTID | V_TIVEXFIACC | MANDT | T012K | House Bank Accounts | MANDT |
| V_TIVEXFIACC | HKTID | V_TIVEXFIACC | HKTID | T012K | House Bank Accounts | HKTID |
| V_TIVEXFIACC | HKTID | V_TIVEXFIACC | HBKID | T012K | House Bank Accounts | HBKID |
| V_TIVEXFIACC | INFKY | V_TIVEXFIACC | INFKY | J_1AINFSKS | Inflation Keys - G/L Account | J_1AIFSKS |
| V_TIVEXFIACC | INFKY | T001 | LAND1 | J_1AINFSKS | Inflation Keys - G/L Account | LAND1 |
| V_TIVEXFIACC | INFKY | V_TIVEXFIACC | MANDT | J_1AINFSKS | Inflation Keys - G/L Account | MANDT |
| V_TIVEXFIACC | KDFSL | * | T030S | Accts for Foreign Currency Assets Exchange Rate Differences | CURTP | |
| V_TIVEXFIACC | KDFSL | V_TIVEXFIACC | KDFSL | T030S | Accts for Foreign Currency Assets Exchange Rate Differences | KDFSL |
| V_TIVEXFIACC | KDFSL | SKA1 | KTOPL | T030S | Accts for Foreign Currency Assets Exchange Rate Differences | KTOPL |
| V_TIVEXFIACC | KDFSL | V_TIVEXFIACC | MANDT | T030S | Accts for Foreign Currency Assets Exchange Rate Differences | MANDT |
| V_TIVEXFIACC | KTOKS | V_TIVEXFIACC | MANDT | T077S | G/L account groups | MANDT |
| V_TIVEXFIACC | KTOKS | V_TIVEXFIACC | KTOPL | T077S | G/L account groups | KTOPL |
| V_TIVEXFIACC | KTOKS | V_TIVEXFIACC | KTOKS | T077S | G/L account groups | KTOKS |
| V_TIVEXFIACC | KTOPL | V_TIVEXFIACC | MANDT | T004 | Directory of Charts of Accounts | MANDT |
| V_TIVEXFIACC | KTOPL | V_TIVEXFIACC | KTOPL | T004 | Directory of Charts of Accounts | KTOPL |
| V_TIVEXFIACC | MANDT | V_TIVEXFIACC | MANDT | T000 | Clients | MANDT |
| V_TIVEXFIACC | MUSTR | V_TIVEXFIACC | MANDT | SKM1 | Sample G/L accounts | MANDT |
| V_TIVEXFIACC | MUSTR | V_TIVEXFIACC | KTOPL | SKM1 | Sample G/L accounts | KTOPL |
| V_TIVEXFIACC | MUSTR | V_TIVEXFIACC | MUSTR | SKM1 | Sample G/L accounts | MUSTR |
| V_TIVEXFIACC | RECID | V_TIVEXFIACC | RECID | T8JJ | Recovery Indicator | RECID |
| V_TIVEXFIACC | RECID | V_TIVEXFIACC | BUKRS | T8JJ | Recovery Indicator | BUKRS |
| V_TIVEXFIACC | RECID | V_TIVEXFIACC | MANDT | T8JJ | Recovery Indicator | MANDT |
| V_TIVEXFIACC | SAKNR | V_TIVEXFIACC | SAKNR | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| V_TIVEXFIACC | SAKNR | V_TIVEXFIACC | MANDT | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| V_TIVEXFIACC | SAKNR | T001 | KTOPL | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| V_TIVEXFIACC | TOGRU | V_TIVEXFIACC | MANDT | T043S | Tolerances for Groups of G/L Accounts | MANDT |
| V_TIVEXFIACC | TOGRU | V_TIVEXFIACC | BUKRS | T043S | Tolerances for Groups of G/L Accounts | BUKRS |
| V_TIVEXFIACC | TOGRU | V_TIVEXFIACC | TOGRU | T043S | Tolerances for Groups of G/L Accounts | TOGRU |
| V_TIVEXFIACC | VBUND | V_TIVEXFIACC | VBUND | T880 | Global Company Data (for KONS Ledger) | RCOMP |
| V_TIVEXFIACC | VBUND | V_TIVEXFIACC | MANDT | T880 | Global Company Data (for KONS Ledger) | MANDT |
| V_TIVEXFIACC | VZSKZ | V_TIVEXFIACC | VZSKZ | T056 | Interest settlement | VZSKZ |
| V_TIVEXFIACC | VZSKZ | V_TIVEXFIACC | MANDT | T056 | Interest settlement | MANDT |
| V_TIVEXFIACC | WAERS | V_TIVEXFIACC | WAERS | TCURC | Currency Codes | WAERS |
| V_TIVEXFIACC | WAERS | V_TIVEXFIACC | MANDT | TCURC | Currency Codes | MANDT |
| V_TIVEXFIACC | ZUAWA | V_TIVEXFIACC | ZUAWA | TZUN | Rules for 'Allocation' Field Layout | ZUAWA |
