| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /BIC/B0000170000 | PSA for 0FI_GL_4 T90CLNT090 FI-GL Items Delta | 54 | AWREF | | nvarchar | 10 | 0 | | |
2 | CNVTDMS_05_ACCTH | Collected Header Document Numbers for TDMS_Time-ACCTHD | 4 | AWREF | AWREF for CNVTDMS_05_ACCTHD | nvarchar | 10 | 0 | | |
TOPAccounting Interface |
3 | GLE_FI_ITEM_MODF | ECS: Modified FI Line Items (Header/Item/Currency Data) | 4 | AWREF | Reference Document Number | nvarchar | 10 | 0 | | |
4 | GLE_FI_ITEM_ORIG | ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F) | 4 | AWREF | Reference Document Number | nvarchar | 10 | 0 | | |
TOPActual CostingMaterial Ledger |
5 | CKMI1 | Index for Accounting Documents for Material | 6 | AWREF | Reference Document Number | nvarchar | 10 | 0 | | |
6 | MLHD | Material Ledger Document: Header | 6 | AWREF | Reference Document Number | nvarchar | 10 | 0 | | |
TOPBasic Functions |
7 | ARC_IDX_AT | Index table for ACCTIT/ACCTHD/ACCTCR archives | 2 | AWREF | Reference Document Number | nvarchar | 10 | 0 | | |
8 | ETXDCH | External tax document: header info | 4 | AWREF | Reference Document Number | nvarchar | 10 | 0 | | |
9 | FDS2 | CM&F Line Items in SD Documents (fromr Release 4.0) | 3 | AWREF | Reference Document Number | nvarchar | 10 | 0 | | |
10 | FDSP | Cash Mgmt Adjustment Items from Document Splitting | 4 | AWREF | Reference Document Number | nvarchar | 10 | 0 | | |
11 | GLIDXA | Index to Find FI-SL Documents Based on AWKEY | 2 | AWREF | Reference Document Number | nvarchar | 10 | 0 | | |
12 | TTXI | External tax interface: index file | 3 | AWREF | Reference Document Number | nvarchar | 10 | 0 | | |
13 | TTXY | External tax interface: tax information | 3 | AWREF | Reference Document Number | nvarchar | 10 | 0 | | |
TOPBudgeting |
14 | FMBH | Funds management budget header (entry documents) | 28 | AWREF | Reference Document Number | nvarchar | 10 | 0 | | |
TOPBudgeting and Availability Control |
15 | GMBDGTHEADER | Budget Document Header | 27 | AWREF | Reference Document Number | nvarchar | 10 | 0 | | |
TOPCentral Cash Desk Procedure |
16 | FMFG_PPA_INV_LN | Reason Codes for Accounting Documents (Item Level) | 2 | AWREF | Reference Document Number | nvarchar | 10 | 0 | | |
TOPCollectionsDisbursements |
17 | DIMAAWREFST | AWREF for COPA-Reversal FS-CD | 2 | AWREF | Character Field Length = 10 | nvarchar | 10 | 0 | | |
18 | DIMACOPAST | Reversal of Contracts in CO-PA | 5 | AWREF | Reference Document Number | nvarchar | 10 | 0 | | |
TOPContract Accounts Receivable and Payable |
19 | FKK_JFRK_SHORT | Header Data for IS-M/SD Billing Document - Extracts | 32 | AWREF | Reference Document Number | nvarchar | 10 | 0 | | |
20 | FKK_JLRK_SHORT | Header Data for IS-M/SD Service Settlement - Extracts | 25 | AWREF | Reference Document Number | nvarchar | 10 | 0 | | |
21 | FKK_JLRPCM_SHORT | Item Data for IS-M/SD Commission Settlement - Extracts | 34 | AWREF | Reference Document Number | nvarchar | 10 | 0 | | |
22 | FKK_JLRPHD_SHORT | Item Data for IS-M/SD Home Delivery Settlement - Extracts | 39 | AWREF | Reference Document Number | nvarchar | 10 | 0 | | |
TOPData Retention Tool |
23 | TXW_S_BKPF | Retrieve BKPF from archive | 32 | AWREF | Reference Document Number | nvarchar | 10 | 0 | | |
TOPEnterprise Services - Personnel Time Management |
24 | TIM_SE_EXT_KEY | Mapping Table for IT2004: External Key and Infotype Key | 3 | AWREF | Reference Document Number | nvarchar | 10 | 0 | | |
TOPFinancial Accounting |
25 | ACCTCR | Compressed Data from FI/CO Document - Currencies | 3 | AWREF | Reference Document Number | nvarchar | 10 | 0 | | |
26 | ACCTHD | Compressed Data from FI/CO Document - Header | 3 | AWREF | Reference Document Number | nvarchar | 10 | 0 | | |
27 | ACCTIT | Compressed Data from FI/CO Document | 3 | AWREF | Reference Document Number | nvarchar | 10 | 0 | | |
28 | ARIX_BKPF | FI_DOCUMNT: Header-Oriented Document Index for Archive | 6 | AWREF | Reference Document Number | nvarchar | 10 | 0 | | |
29 | FERC_D2 | Documents per sender and account | 17 | AWREF | Reference Document Number | nvarchar | 10 | 0 | | |
30 | SLPB | Log Table for Valuation | 9 | AWREF | Reference Document Number | nvarchar | 10 | 0 | | |
TOPFunds Management |
31 | BPDK | Header Entry Document | 21 | AWREF | Reference Document Number | nvarchar | 10 | 0 | | |
32 | FCABK | FI-CA: Document Header | 9 | AWREF | Reference Document Number | nvarchar | 10 | 0 | | |
33 | FMFG_PO_SUBSET | ZEKKN number to correct invoices for SES | 11 | AWREF | Reference Document Number | nvarchar | 10 | 0 | | |
34 | FMFG_PO_ZEKKN | ZEKKN data for all FI items referencing service POs | 11 | AWREF | Reference Document Number | nvarchar | 10 | 0 | | |
35 | FMFG_SAV_GLIDXA | Saved GLIDXA data for docs excluded from SL Repost for 600 | 2 | AWREF | Reference Document Number | nvarchar | 10 | 0 | | |
36 | FMIFIHD | FI Header Table in Funds Management | 13 | AWREF | Reference Document Number | nvarchar | 10 | 0 | | |
37 | KBLE | Document Item Processing: Manual Document Entry | 35 | AWREF | Reference Document Number | nvarchar | 10 | 0 | | |
TOPGeneral Ledger Accounting |
38 | FAGLCOFITRACE | Log of Real-Time Integration CO->FI | 9 | AWREF | Reference Document Number | nvarchar | 10 | 0 | | |
39 | FAGL_SPLINFO | Splittling Information of Open Items | 9 | AWREF | Reference Document Number | nvarchar | 10 | 0 | | |
TOPInput Tax Treatment |
40 | VIBETAXD | Zuordnung Vorsteuerbeleg zum Berichtigungsobjekt | 3 | AWREF | Referenzbelegnummer | nvarchar | 10 | 0 | | |
TOPJoint Venture und Production Sharing Accounting |
41 | T8J_POST_ERROR | Documents with errors in JV posting | 3 | AWREF | Reference Document Number | nvarchar | 10 | 0 | | |
42 | T8J_POST_ERROR_C | Documents with errors in JV posting (Open Items) | 3 | AWREF | Reference Document Number | nvarchar | 10 | 0 | | |
TOPLease Accounting |
43 | FILA_GF_ITEMDOCS | Assignment of Process - FI/CO Document Numbers | 7 | AWREF | Reference Document Number | nvarchar | 10 | 0 | | |
44 | FILA_GF_ITEMLINK | Assignment of Objects to Assets | 13 | AWREF | Reference Document Number | nvarchar | 10 | 0 | | |
TOPLoans Management |
45 | VDCHK_AWKEY | Storage of unique links between FI and CML doc | 5 | AWREF | Reference Document Number | nvarchar | 10 | 0 | | |
TOPLocalization |
46 | J_1AINFINV | Inflation: Invoices for Replacement Value Determination | 6 | AWREF | Reference Document Number | nvarchar | 10 | 0 | | |
47 | J_1IEWTPROV | Table for TDS provisions | 8 | AWREF | Reference Document Number | nvarchar | 10 | 0 | | |
48 | J_1ISERVC | Service tax details | 4 | AWREF | Reference document number | nvarchar | 10 | 0 | | |
TOPMaterials Management |
49 | J_1GVL_ML | Material Ledger | 86 | AWREF | Reference Document Number | nvarchar | 10 | 0 | | |
TOPNew Zealand |
50 | PT2001 | HR Time Record: Infotype 2001 (Absences) | 68 | AWREF | Reference Document Number | nvarchar | 10 | 0 | | |
TOPPeriodical Sales and Distribution |
51 | JFREVLIABACC | IS-M/SD: Accr.Table for Rev.Dist.w/Liab.Acct for Transfer | 19 | AWREF | Reference Document Number | nvarchar | 10 | 0 | | |
52 | JFREVLIABACC_REV | IS-M/SD: Reverse Revenue Dist. w/Liability Acct for Trans. | 22 | AWREF | Reference Document Number | nvarchar | 10 | 0 | | |
53 | JFREVPER | IS-M/SD: Accrual Table for Period-Related Revenue Dist. | 20 | AWREF | Reference Document Number | nvarchar | 10 | 0 | | |
54 | JFREVPER_REVERSE | IS-M/SD: Reverse Period-Related Revenue Distribution | 22 | AWREF | Reference Document Number | nvarchar | 10 | 0 | | |
55 | JFREVVA | IS-M/SD: Accr.Table for Issue-Rel.Revenue Dist.w/o Liab.Acct | 19 | AWREF | Reference Document Number | nvarchar | 10 | 0 | | |
56 | JFREVVAACC | IS-M/SD: Accr.Table for Issue-Related Rev.Dist.w/Liab.Acct | 18 | AWREF | Reference Document Number | nvarchar | 10 | 0 | | |
57 | JFREVVAACC_REVER | IS-M/SD: Reverse Issue-Related Revenue Dist. w/Liab. Account | 21 | AWREF | Reference Document Number | nvarchar | 10 | 0 | | |
58 | JFREVVA_REVERSE | IS-M/SD: Reverse Issue-Related Revenue Dist. w/o Liab. Acct | 22 | AWREF | Reference Document Number | nvarchar | 10 | 0 | | |
59 | JFRK | IS-M/SD: Billing - Header Data | 93 | AWREF | Reference Document Number | nvarchar | 10 | 0 | | |
60 | JKACCADD | IS-M/SD: Additional Payments for Renewal Cycle | 11 | AWREF | Reference Document Number | nvarchar | 10 | 0 | | |
61 | JKACCTFPROT | IS-M/SD: Log of Liability Account Transfer | 14 | AWREF | Reference Document Number | nvarchar | 10 | 0 | | |
TOPPersonnel Time Management |
62 | PA2001 | HR Time Record: Infotype 2001 (Absences) | 68 | AWREF | Reference Document Number | nvarchar | 10 | 0 | | |
63 | PA2002 | HR Time Record: Infotype 2002 (Attendances) | 50 | AWREF | Reference Document Number | nvarchar | 10 | 0 | | |
64 | PA2003 | HR Time Record: Infotype 2003 (Substitutions) | 64 | AWREF | Reference Document Number | nvarchar | 10 | 0 | | |
65 | PA2010 | HR Time Record: Infotype 2010 (Employee Remuneration Info.) | 50 | AWREF | Reference Document Number | nvarchar | 10 | 0 | | |
TOPProfitability Analysis |
66 | CEERROR | CO-PA: Incorrect records from SD | 61 | AWREF | Reference Document Number | nvarchar | 10 | 0 | | |
TOPReal Estate Management |
67 | VIMIRA | Instalments for Lease-Out | 6 | AWREF | Reference Document Number | nvarchar | 10 | 0 | | |
68 | VITAXA | Line items for correction items | 4 | AWREF | Reference Document Number | nvarchar | 10 | 0 | | |
69 | VITAXD | Tax Shares per Real Estate Account Assignment | 3 | AWREF | Reference Document Number | nvarchar | 10 | 0 | | |
70 | VITAXR | Outflows for correction items | 4 | AWREF | Reference Document Number | nvarchar | 10 | 0 | | |
71 | VITAXU | Tax transfer posting for advance payments with jurisdiction | 8 | AWREF | Reference Document Number | nvarchar | 10 | 0 | | |
TOPRegulatory reporting for insurance companies |
72 | ISSRPREFLOW | ISSR: Basistabelle/Bewegungstabelle | 45 | AWREF | Numero documento di riferimento | nvarchar | 10 | 0 | | |
TOPTransfer to Financial Accounting |
73 | TRACT_DOCUMENT | Treasury: Accounting Adaptor Document | 7 | AWREF | Reference Document Number | nvarchar | 10 | 0 | | |
TOPTravel Expenses |
74 | PTRV_DOC_HD | Transfer Travel -> FI/CO: Header of TRV int. document | 2 | AWREF | Reference Document Number | nvarchar | 10 | 0 | | |
75 | PTRV_DOC_IT | Transfer Travel -> FI/CO: Lines of TRV interm. document | 2 | AWREF | Reference Document Number | nvarchar | 10 | 0 | | |
76 | PTRV_DOC_MESS | Transfer Travel -> FI/CO: CO Replacements of TRV Receipt | 2 | AWREF | Reference Document Number | nvarchar | 10 | 0 | | |
77 | PTRV_DOC_TAX | Transfer Travel -> FI/CO: Tax lines of TRV document | 2 | AWREF | Reference Document Number | nvarchar | 10 | 0 | | |
78 | PTRV_ROT_AWKEY | Assignment of Trip Results to Posting Doc. Number and Line | 13 | AWREF | Reference Document Number | nvarchar | 10 | 0 | | |
79 | PTRV_RPRPOSTD | Log of Posting Program RPRPOSTD | 3 | AWREF | Reference Document Number | nvarchar | 10 | 0 | | |
TOPTreasury |
80 | FLQITEMSO_FC | Liquidity Calculation-Forecast Line Items from Sales Orders | 3 | AWREF | Reference Document Number | nvarchar | 10 | 0 | | |
TOPUS Prompt Payment Act |
81 | FMFG_PPA_INVSTAT | PPA Invoice Status Table | 2 | AWREF | Reference Document Number | nvarchar | 10 | 0 | | |
82 | FMFG_PPA_INV_HD | PPA invoice header information (reason codes) | 2 | AWREF | Reference Document Number | nvarchar | 10 | 0 | | |
83 | FMFG_PPA_INV_HIS | PPA Invoice Status Change History | 2 | AWREF | Reference Document Number | nvarchar | 10 | 0 | | |
84 | FMFG_PPA_LINK | Link the application log to an Invoice (PPA) | 3 | AWREF | Reference Document Number | nvarchar | 10 | 0 | | |