| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /GSINS/INH_CD2_C | CD Posting: GL item settings | 6 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
2 | /GSINS/INH_CD3_C | CD Posting: BP item settings | 5 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
3 | DFKKSAFTINV_3PC | SAF-T source document extraction rules for Third Party | 10 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
4 | DFKKSAFTINV_3PV | SAF-T Third Party Business Partner Assignment | 10 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
5 | DFKK_BIT_TEST | Test Data for BITs | 16 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
6 | FKKID_EXP_HDR_A | Cr.Mem.&Exp.Conf.: Export Confirmation Header | 9 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
7 | TFK036V | Different Planning Levels By Transactions | 4 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
8 | T7PIQSINGLEFEES | Define Attributes for Individual Fees | 10 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
9 | T7PIQ_NL_COBJ | Maintain Contract Object Types for Fee Calculation | 4 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
10 | TCMAC06D | Derivation of ISR Scenario Related Data | 11 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
11 | TCMACFAINT04 | Financial Aid Relevant Main and Sub-transaction | 2 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
TOPBilling in Contract Accounts Receivable and Payable |
12 | TFK8008A | Transaction Determination for Billing Rate Item | 6 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
TOPCollectionsDisbursements |
13 | BROK_SALD_CUST | Balance Key Assignment - Transactions | 3 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
14 | ITAGCYCOMMPLAN | Agency Coll.: Main/Sub-Transactns f.Commission in PlndPrincp | 2 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
15 | ITAGCYSUBCOMM | Commission to Subagencies (Main and Subtransactions) | 2 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
16 | TIBRCLARREAS | Clarification Codes for Broker Report | 9 | HVORG | Main Trans. for New Created Open Items from Broker Report | nvarchar | 4 | 0 | | |
17 | TIBRDEFAULTS | Broker Collections - Default Values for Broker Report | 10 | HVORG | Main Trans. for New Created Open Items from Broker Report | nvarchar | 4 | 0 | | |
18 | TKKVHVTV | FS-CD Transactions | 3 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
19 | TKKVHVTVT | FS-CD Transactions: Texts | 4 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
20 | TKKVIVV | Assign Internal Sub-Transactions to External Transactions | 5 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
21 | VVKKCFREC | Cash Receipts to be Transferred to Claims System | 14 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
22 | VVKKFOP | Single Doc in Posting Data Interface | 7 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
23 | VVKKFOPT | Table for FS-CD Test Data of Structure VKKKFOP | 7 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
24 | VVKK_COINS_PLPR | Coinsurance Reporting: Transactions for Debt Procedure | 3 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
25 | VVSCITEM | Bill Scheduling: Scheduling Document | 32 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
26 | VVSCITEM_MAN | Scheduling Items: Temp. Storage for Manual -> Auto Change | 32 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
27 | VVSCPOS | Payment Plan Item | 54 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
TOPContract Accounts Receivable and Payable |
28 | DFKCRPO | Clarification Worklist Credit | 11 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
29 | DFKK1099 | 1099 Statutory Reporting Data | 19 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
30 | DFKKDOUBTD_W | Buffer: Create Printout for Receivables Adjustment | 25 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
31 | DFKKIPBW_ORIG | Installment Plan Original Items for Business Warehouse | 13 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
32 | DFKKMOP | Items in contract account document | 21 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
33 | DFKKOP | Items in contract account document | 21 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
34 | DFKKOPCOLL | Collection: Log of Receivables Submitted | 16 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
35 | DFKKOP_REP | Open Items from FPO4 | 25 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
36 | DFKKOP_SHORT | Partner Items for FI-CA Document - Extracts | 17 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
37 | DFKKORDERPOS | Requests: Items | 9 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
38 | DFKKORDERPOS_S | Request Templates: Items | 9 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
39 | DFKKRDI | Revenue Distribution | 18 | HVORG | Main Transaction for Distribution Line Item | nvarchar | 4 | 0 | | |
40 | DFKKRDI_AGGRF_C | Auxiliary Table for Aggregated Distribution Information | 4 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
41 | DFKKTHI | Transfer Records for Invoice Issue by Third Party | 23 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
42 | DFKKTHI_SUM | Aggregated Transfer Records for Invoicing | 14 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
43 | DFKKTHP | Transfer Records for Billing on Behalf of 3rd Party | 26 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
44 | DFKKTRANSKEY_TR | Turkey: Transaction Key -Combination of Main and Sub Trans. | 3 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
45 | TE305 | Transactions for Company Code and Division | 5 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
46 | TE305T | Transactions for Company Code and Division (Texts) | 6 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
47 | TE514 | Invoicing: Item Selection for Account Maintenance | 5 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
48 | TECOD | IS-U: CO account assignment key / allocation | 7 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
49 | TEIVV | (DON'T FILL/RE AD!!!Alloc. of Intern. Transacts to Trans. | 5 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
50 | TFK047K | Charge Categories Per Schedule | 4 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
51 | TFK056A | Interest Key Table for FI-CA | 10 | HVORG | Not Used (Main Transaction for Interest Keys) | nvarchar | 4 | 0 | | |
52 | TFK059QV | Transaction-Specific Withholding Tax Code | 4 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
53 | TFK063A | Charge Categories for Installment Plan Surcharges | 5 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
54 | TFK113F | Clearing: Due Date Intervals for OI Selection | 5 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
55 | TFK113G | Clearing: Write-Off Statistical Items | 6 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
56 | TFKBA_TRANS | Assignment of Transactions to Balances Categories | 3 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
57 | TFKHHVO | Main Transactions for Credit Postings in FI-CA | 3 | HVORG | Main Transaction for Credit Posting for Line Item | nvarchar | 4 | 0 | | |
58 | TFKHVO | Main transactions in contract accts receivable and payable | 3 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
59 | TFKHVOT | Main transactions in contract accts receivable and payable | 4 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
60 | TFKIVV | Assignment of Internal Transactions to External Transactions | 5 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
61 | TFKRDI_DISGRP_RL | Transactions Summarized for Distribution Group | 3 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
62 | TFKSHVO | Main Transactions for Debit Postings in FI-CA | 3 | HVORG | Main Transaction for Debit Posting for Line Item | nvarchar | 4 | 0 | | |
63 | TFKTVO | Sub-transactions in Contract Accounts Receivable and Payable | 3 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
64 | TFKTVOT | Sub-transactions in Contract Accounts Receivable and Payable | 4 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
65 | TFKZWEX | Exceptiions for Doubtful Entries/Individual Value Adjustment | 3 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
66 | TFK_CRPO | Credit Processing: Customizing ID Credit | 4 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
67 | TFK_EXTDOC_AR3 | Determination of Report Classification | 6 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
68 | TFK_EXTDOC_OP | Transactions for Official Document Number | 2 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
69 | TFK_PAYMENTREL_N | FICA: Customizing Payment Release Disbursements - New | 3 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
TOPContract Billing |
70 | ERCH | Billing Doc. Data | 18 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
71 | ERCH_SHORT | Header Data for Billing Document - Extract | 12 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
72 | TEPREPAY | Customizing Settings for Prepayment Meter | 16 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
TOPFinancial Services Localization |
73 | /GSINS/REU_TSBTR | Insurance ETL Customizing Table | 4 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
74 | /GSINS/UPR_DEFRE | UPR - Calculation of unearned insurance premium reserve | 11 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
TOPGeneral Application Functions |
75 | TFIS010 | FSCM: Bill Transactions | 3 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
TOPGeneric Contract Accounts Receivable and Payable |
76 | TFSCHVTV | Transactions for Company Code and Division | 5 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
77 | TFSCHVTVT | Transactions for Company Code and Division (Texts) | 6 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
TOPIncentive and Commission Management ICM |
78 | CACSCD_ACRCD | Account Assignments of Remun.Types for FS-CD Stt.System | 5 | HVORG | Main Transaction for Document Item | nvarchar | 4 | 0 | | |
79 | CACSCD_DOCCD_PD | Settlement to FS-CD: Reference Document Line Items | 11 | HVORG | Main Transaction for Document Item | nvarchar | 4 | 0 | | |
TOPIntercompany Data Exchange |
80 | EDEREG_SIDPROINT | Interpretation of Internal ID | 3 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
81 | TEFKTVOS | Tax Table: Relevant Transactions in Convergent Billing | 2 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
82 | TEFKTVOSBILL | Contract A/R and A/P items to be transfered for IDoc bill | 2 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
83 | TEFKTVOSBILLT | Text for contract A/R and A/P items in IDoc bill | 2 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
84 | TINV_INV_TRANSF | Transfer Table for Bill Data to FI-CA | 39 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
85 | TINV_TRNSF_SHORT | Extract of Bill Receipt (Eval. System): FI-CA Transfer Data | 23 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
TOPInvoicing |
86 | DBERDL | Print Document Line Items | 29 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
87 | DBERDLB | Reference of a Print Doc. Line Item to a Bill.Doc. Line Item | 6 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
88 | DBERDZ | DB Table: Individ. Lines - Print Document | 11 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
89 | DEABPS | Customer change table: Logical view of BB amounts | 16 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
90 | EABPL | Sample Lines for Budget Billing Plan | 9 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
91 | ERDZ_SHORT | Internal Table for Individual Print Doc.Lines -Extract Data | 25 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
92 | TE529 | Item Selection for Bill Display | 4 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
93 | TEABSTVOR | Define Debit/Credit ID for BB Amount Subtransactions | 3 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
TOPInvoicing in Contract Accounts Receivable and Payable |
94 | DFKKINVBILL_I | Billing Document Items | 24 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
95 | DFKKINVDOC_I | Items of Invoicing Document | 13 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
96 | TFK2617 | Charges/Discounts | 6 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
TOPLease Accounting |
97 | /LSIERP/COND_MAP | Assign FI-CA Transactions to CRM Conditions | 3 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
98 | /LSIERP/EXCL_NA | Transactions Not Assigned a Non-Accrual Status | 4 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
TOPPublic Sector Contract Accounts Receivable and Payable |
99 | DFMCA_BRF150 | Text Parameters for Billing Line | 11 | HVORG | BRF: Expression | nvarchar | 20 | 0 | | |
100 | DFMCA_BRF152 | BRF: Parameters for Calculation Line Items | 11 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
101 | DFMCA_BRF730 | BRF: Read Tax Liabilities | 11 | HVORG | BRF: Expression | nvarchar | 20 | 0 | | |
102 | PS4SC_STATUS_RUL | Social Services: Status - Message Document Rules | 3 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
103 | TFMCA004 | Parameters for Main/Sub-Transactions | 3 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
104 | TFMCA008 | Company Code-Dependent Indicator for Subtransactions | 3 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
105 | TFMCA_BRF221 | BRF: Parameters for Calculation Line Items | 12 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
106 | TFMCA_PREPAY | Main and Subtransaction for Open Items | 4 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
107 | TFMCA_REFUND | Main/Subtransaction for Refund Items | 5 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
108 | TFMCA_REVTYPE | Revenue Types | 4 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
TOPSAP Utilities |
109 | TE014_COMP_IND | Components for LPC, PPI, Interest | 5 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |
110 | TE872_COMP_IND | Security Deposit Revisions : Relevant Billing Components | 5 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | |