SAP table V_TIVEXFIACC (Generated Table for View)

SAP table V_TIVEXFIACC has 4 primary key fields being MANDT,KTOPL,BUKRS,SAKNR.

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
KTOPL Chart of Accounts CHAR 4 0 T004 KTOPL
BUKRS Company Code CHAR 4 0 T001 BUKRS
SAKNR G/L Account Number CHAR 10 0 SKA1 SAKNR
TXT20 G/L Account Short Text CHAR 20 0 TXT20_SKAT
TXT50 G/L Account Long Text CHAR 50 0 TXT50_SKAT
MCOD1SKAT Search Term for Matchcode Search CHAR 25 0 MCDS1
BEGRU Authorization Group CHAR 4 0 BRGRU
BUSAB Accounting Clerk Abbreviation CHAR 2 0 T001S BUSAB
DATLZ Date of Last Interest Calculation Run DATS 8 0 DATLZ
ERDATSKB1 Date on which the Record Was Created DATS 8 0 ERDAT_RF
ERNAMSKB1 Name of Person who Created the Object CHAR 12 0 ERNAM_RF
FDGRV Planning Group CHAR 10 0 T035 FDGRV
FDLEV Planning Level CHAR 2 0 T036 FDLEV
FIPLS Financial Budget Item NUMC 3 0 FIPLS
FSTAG Field status group CHAR 4 0 T004F FSTAG
HBKID Short Key for a House Bank CHAR 5 0 T012 HBKID
HKTID ID for Account Details CHAR 5 0 T012K HKTID
KDFSL Key for Exchange Rate Differences in Foreign Currency Accts CHAR 4 0 T030S KDFSL
MITKZ Account is Reconciliation Account CHAR 1 0 MITKZ
A Assets
D Customers
K Vendors
V Contract accounts receivable
MWSKZ Tax Category in Account Master Record CHAR 2 0 SMWSK
STEXT G/L Account Additional Text CHAR 50 0 STEXT_SKB1
VZSKZ Interest Indicator CHAR 2 0 T056 VZSKZ
WAERS Account Currency CUKY 5 0 TCURC WAERS_SKB1
WMETH Indicator: Account Managed in External System CHAR 2 0 WMETH
Standard account management
X Account managed in another system
XGKON Cash Receipt Account / Cash Disbursement Account CHAR 1 0 XGKON
XINTB Indicator: Is Account only Posted to Automatically? CHAR 1 0 XINTB
XKRES Indicator: Can Line Items Be Displayed by Account? CHAR 1 0 XKRES
XLOEB Indicator: Account Marked for Deletion? CHAR 1 0 XLOEV
XNKON Indicator: Supplement for Automatic Postings ? CHAR 1 0 XNKON
XOPVW Indicator: Open Item Management? CHAR 1 0 XOPVW
XSPEBSKB1 Indicator: Is Account Blocked for Posting? CHAR 1 0 XSPEB
ZINDT Key Date of Last Interest Calculation DATS 8 0 DZINDT
ZINRT Interest Calculation Frequency in Months NUMC 2 0 DZINRT
ZUAWA Key for sorting according to assignment numbers CHAR 3 0 TZUN DZUAWA
ALTKT Alternative Account Number in Company Code CHAR 10 0 ALTKT_SKB1
XMITK Indicator: Reconcil.Acct Ready for Input at Time of Posting? CHAR 1 0 XMITK
RECID Recovery Indicator CHAR 2 0 T8JJ JV_RECIND
FIPOS Commitment Item CHAR 14 0 FIPOS
XMWNO Indicator: Tax code is not a required field CHAR 1 0 XMWNO
XSALH Manage Balances in Local Currency Only (Indicator) CHAR 1 0 XSALH
BEWGP Valuation Group CHAR 10 0 BEWGP
INFKY Inflation Key CHAR 8 0 J_1AINFSKS J_1AIFSKS
TOGRU Tolerance Group for G/L Accounts CHAR 4 0 T043S TOGRU_S
XBILK Indicator: Account is a balance sheet account? CHAR 1 0 XBILK
SAKAN G/L Account Number, Significant Length CHAR 10 0 SAKAN
BILKT Group Account Number CHAR 10 0 SKA1 BILKT
ERDAT Date on which the Record Was Created DATS 8 0 ERDAT_RF
ERNAM Name of Person who Created the Object CHAR 12 0 ERNAM_RF
GVTYP P&L statement account type CHAR 2 0 GVTYP
KTOKS G/L Account Group CHAR 4 0 T077S KTOKS
MUSTR Number of the Sample Account CHAR 10 0 SKM1 MUSTR
VBUND Company ID of Trading Partner CHAR 6 0 T880 RASSC
XLOEV Indicator: Account Marked for Deletion? CHAR 1 0 XLOEV
XSPEA Indicator: Account Is Blocked for Creation ? CHAR 1 0 XSPEA
XSPEB Indicator: Is Account Blocked for Posting? CHAR 1 0 XSPEB
XSPEP Indicator: Account Blocked for Planning ? CHAR 1 0 XSPEP
MCOD1 Search Term for Using Matchcode CHAR 25 0 MCODF
FUNC_AREA Functional Area CHAR 16 0 TFKB FKBER

V_TIVEXFIACC foreign key relationships

Table Field Check Table Check Field
0 V_TIVEXFIACC BILKT SKA1 G/L Account Master (Chart of Accounts) MANDT
0 V_TIVEXFIACC BILKT SKA1 G/L Account Master (Chart of Accounts) KTOPL
0 V_TIVEXFIACC BILKT SKA1 G/L Account Master (Chart of Accounts) SAKNR
1 V_TIVEXFIACC BUKRS T001 Company Codes BUKRS
0 V_TIVEXFIACC BUSAB T001S Accounting Clerks MANDT
0 V_TIVEXFIACC BUSAB T001S Accounting Clerks BUKRS
0 V_TIVEXFIACC BUSAB T001S Accounting Clerks BUSAB
1 V_TIVEXFIACC FDGRV T035 Planning groups GRUPP
0 V_TIVEXFIACC FDLEV T036 Planning levels EBENE
1 V_TIVEXFIACC FSTAG T004F Field status definition groups MANDT
1 V_TIVEXFIACC FSTAG T004F Field status definition groups BUKRS
0 V_TIVEXFIACC FUNC_AREA TFKB Functional areas FKBER
1 V_TIVEXFIACC HBKID T012 House Banks BUKRS
0 V_TIVEXFIACC HKTID T012K House Bank Accounts MANDT
0 V_TIVEXFIACC HKTID T012K House Bank Accounts BUKRS
0 V_TIVEXFIACC HKTID T012K House Bank Accounts HBKID
0 V_TIVEXFIACC HKTID T012K House Bank Accounts HKTID
1 V_TIVEXFIACC INFKY J_1AINFSKS Inflation Keys - G/L Account MANDT
1 V_TIVEXFIACC INFKY J_1AINFSKS Inflation Keys - G/L Account LAND1
0 V_TIVEXFIACC KDFSL T030S Accts for Foreign Currency Assets Exchange Rate Differences KTOPL
0 V_TIVEXFIACC KDFSL T030S Accts for Foreign Currency Assets Exchange Rate Differences CURTP
1 V_TIVEXFIACC KTOKS T077S G/L account groups MANDT
1 V_TIVEXFIACC KTOKS T077S G/L account groups KTOPL
0 V_TIVEXFIACC KTOPL T004 Directory of Charts of Accounts MANDT
1 V_TIVEXFIACC MANDT T000 Clients MANDT
0 V_TIVEXFIACC MUSTR SKM1 Sample G/L accounts MANDT
0 V_TIVEXFIACC MUSTR SKM1 Sample G/L accounts KTOPL
0 V_TIVEXFIACC MUSTR SKM1 Sample G/L accounts MUSTR
1 V_TIVEXFIACC RECID T8JJ Recovery Indicator MANDT
1 V_TIVEXFIACC RECID T8JJ Recovery Indicator BUKRS
0 V_TIVEXFIACC SAKNR SKA1 G/L Account Master (Chart of Accounts) MANDT
0 V_TIVEXFIACC SAKNR SKA1 G/L Account Master (Chart of Accounts) KTOPL
0 V_TIVEXFIACC SAKNR SKA1 G/L Account Master (Chart of Accounts) SAKNR
1 V_TIVEXFIACC TOGRU T043S Tolerances for Groups of G/L Accounts MANDT
1 V_TIVEXFIACC TOGRU T043S Tolerances for Groups of G/L Accounts BUKRS
1 V_TIVEXFIACC TOGRU T043S Tolerances for Groups of G/L Accounts TOGRU
0 V_TIVEXFIACC VBUND T880 Global Company Data (for KONS Ledger) MANDT
0 V_TIVEXFIACC VBUND T880 Global Company Data (for KONS Ledger) RCOMP
1 V_TIVEXFIACC VZSKZ T056 Interest Indicator MANDT
1 V_TIVEXFIACC VZSKZ T056 Interest Indicator VZSKZ
0 V_TIVEXFIACC WAERS TCURC Currency Codes MANDT
0 V_TIVEXFIACC WAERS TCURC Currency Codes WAERS