| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /BIC/B0000165000 | PSA for 0FI_AP_4 T90CLNT090 FI-AP: Items Delta | 22 | AUGDT | | nvarchar | 8 | 0 | | |
2 | /BIC/B0000166000 | PSA for 0FI_AR_4 T90CLNT090 FI-AR Items Delta | 22 | AUGDT | | nvarchar | 8 | 0 | | |
3 | /BIC/B0000168000 | PSA for 0FI_GL_40 T90CLNT090 G/L Accounts: Items | 9 | AUGDT | | nvarchar | 8 | 0 | | |
4 | /BIC/B0000169000 | PSA for 0FI_GL_41 T90CLNT090 Documents, Compact | 9 | AUGDT | | nvarchar | 8 | 0 | | |
5 | /BIC/B0000170000 | PSA for 0FI_GL_4 T90CLNT090 FI-GL Items Delta | 21 | AUGDT | | nvarchar | 8 | 0 | | |
6 | /BIC/B0000172000 | PSA for 0FI_GL_14 T90CLNT090 Gen. Ledger: Items | 9 | AUGDT | | nvarchar | 8 | 0 | | |
7 | /OPT/VIM_1CLEAR | /OPT/VIM_1HEAD Extension with Clearing Documents (BSAK) | 9 | AUGDT | Clearing Date | nvarchar | 8 | 0 | | |
8 | /OPT/VIM_2HEAD | Additional Fields for Table /OPT/VIM_1HEAD | 22 | AUGDT | Clearing Date | nvarchar | 8 | 0 | | |
9 | /OPT/WT_3S_PYMNT | Supplier Self Service Payment Information | 11 | AUGDT | Clearing Date | nvarchar | 8 | 0 | | |
10 | BSAD_BAK | Accounting: Secondary index for customers (cleared items) | 6 | AUGDT | Clearing Date | nvarchar | 8 | 0 | | |
11 | BSAK_BAK | Accounting: Secondary Index for Vendors (Cleared Items) | 6 | AUGDT | Clearing Date | nvarchar | 8 | 0 | | |
12 | BSAS_BAK | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 4 | AUGDT | Clearing Date | nvarchar | 8 | 0 | | |
13 | BSEG | Accounting Document Segment | 7 | AUGDT | Clearing Date | nvarchar | 8 | 0 | | |
14 | BSID_BAK | Accounting: Secondary Index for Customers | 6 | AUGDT | Clearing Date | nvarchar | 8 | 0 | | |
15 | BSIK_BAK | Accounting: Secondary index for vendors | 6 | AUGDT | Clearing Date | nvarchar | 8 | 0 | | |
16 | BSIS_BAK | Accounting: Secondary Index for G/L Accounts | 4 | AUGDT | Clearing Date | nvarchar | 8 | 0 | | |
17 | BSSEG | Accounting Document Segment | 7 | AUGDT | Clearing Date | nvarchar | 8 | 0 | | |
18 | CNVA_PCREA_GRIRO | GR/IR Items - Results (Level 2) | 5 | AUGDT | Clearing Date | nvarchar | 8 | 0 | | |
19 | CNVTDMS_05_BSAD | Header table for BSAD | 8 | AUGDT | Date for TDMS | nvarchar | 8 | 0 | | |
20 | CNVTDMS_05_BSAD1 | Header table for BSAD | 8 | AUGDT | Date for TDMS | nvarchar | 8 | 0 | | |
21 | CNVTDMS_05_BSAK | Header table for BSAK | 8 | AUGDT | Date for TDMS | nvarchar | 8 | 0 | | |
22 | CNVTDMS_05_BSAK1 | Header table for BSAK | 8 | AUGDT | Date for TDMS | nvarchar | 8 | 0 | | |
23 | CNVTDMS_05_BSAS | Fill Header BSAS - P&G | 5 | AUGDT | Date for TDMS | nvarchar | 8 | 0 | | |
24 | CNVTDMS_05_BSEG | FILL Header BSEG | 5 | AUGDT | Date for TDMS | nvarchar | 8 | 0 | | |
25 | CNVTDMS_05_BSEG1 | FILL Header BSEG | 5 | AUGDT | Date for TDMS | nvarchar | 8 | 0 | | |
26 | CNVTDMS_05_BSIS | Fill Header BSIS - P&G | 5 | AUGDT | Date for TDMS | nvarchar | 8 | 0 | | |
27 | FAGLBSAS_BAK | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 4 | AUGDT | Clearing Date | nvarchar | 8 | 0 | | |
28 | FAGLBSIS_BAK | Accounting: Secondary Index for G/L Accounts | 4 | AUGDT | Clearing Date | nvarchar | 8 | 0 | | |
29 | FIAPPLD_INV_DATE | Cleared Overdue Invoice Details (Poland) | 9 | AUGDT | Clearing Date | nvarchar | 8 | 0 | | |
30 | FIDOC_EOP | Document extract for EOP check | 7 | AUGDT | Clearing Date | nvarchar | 8 | 0 | | |
31 | FIEUD_FIDOC_I | SAFT: FI Transaction Document Item | 65 | AUGDT | Clearing Date | nvarchar | 8 | 0 | | |
32 | FIWTQAD_CERT | Withholding tax certificate details | 10 | AUGDT | Clearing Date | nvarchar | 8 | 0 | | |
33 | FIWTQAD_MCL | Withholding Tax Monthly Clearing for Qatar | 10 | AUGDT | Clearing Date | nvarchar | 8 | 0 | | |
34 | FUDT_VDOCBSEG | Verification Document Item with Additional Info | 7 | AUGDT | Clearing Date | nvarchar | 8 | 0 | | |
35 | FUDT_VDOCBSEGEV | Verification Document Item in the Entry View | 7 | AUGDT | Clearing Date | nvarchar | 8 | 0 | | |
36 | FUDT_VDOCBSEGH | Verification Document Segment with Additional Info(History) | 7 | AUGDT | Clearing Date | nvarchar | 8 | 0 | | |
37 | GLPOS_C_CT | FI Document: Entry View | 50 | AUGDT | Clearing Date | nvarchar | 8 | 0 | | |
38 | GLPOS_C_DEB_CT | GLPOS_C_CT Customer Line Items | 50 | AUGDT | Clearing Date | nvarchar | 8 | 0 | | |
39 | GLPOS_C_GL_CT | GLPOS_C_CT G/L Line Items | 50 | AUGDT | Clearing Date | nvarchar | 8 | 0 | | |
40 | GLPOS_C_VEN_CT | GLPOS_C_CT Vendor Line Items | 50 | AUGDT | Clearing Date | nvarchar | 8 | 0 | | |
41 | GLPOS_N_CT | New General Ledger: Line Item with Currency Type | 50 | AUGDT | Clearing Date | nvarchar | 8 | 0 | | |
42 | GLPOS_N_GL_CT | New General Ledger: Line Item with Currency Type | 50 | AUGDT | Clearing Date | nvarchar | 8 | 0 | | |
43 | IDSAU_WT_CERT | Withholding tax certificate details | 10 | AUGDT | Clearing Date | nvarchar | 8 | 0 | | |
44 | ZARIXFI1 | Archive Information Structure SAP_FI_DOC_002 | 11 | AUGDT | Clearing Date | nvarchar | 8 | 0 | | |
TOPAccounting Interface |
45 | GLE_FI_ITEM_MODF | ECS: Modified FI Line Items (Header/Item/Currency Data) | 287 | AUGDT | Clearing Date | nvarchar | 8 | 0 | | |
46 | GLE_FI_ITEM_ORIG | ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F) | 287 | AUGDT | Clearing Date | nvarchar | 8 | 0 | | |
TOPAutomatic Payments |
47 | PAYRQ | Payment Requests | 137 | AUGDT | Clearing Date | nvarchar | 8 | 0 | | |
TOPBasic Functions |
48 | REGUPW | W/tax information per w/tax type/FI line item in pmnt run | 37 | AUGDT | Clearing Date | nvarchar | 8 | 0 | | |
49 | WITH_ITEM | Witholding tax info per W/tax type and FI line item | 36 | AUGDT | Clearing Date | nvarchar | 8 | 0 | | |
TOPCash Budget Management |
50 | FMCLHD | Cash Budget Management: Clearing Information for Posting | 5 | AUGDT | Clearing Date | nvarchar | 8 | 0 | | |
TOPCollectionsDisbursements |
51 | VVKKCFREC | Cash Receipts to be Transferred to Claims System | 23 | AUGDT | Clearing date | nvarchar | 8 | 0 | | |
TOPContract Accounts Receivable and Payable |
52 | DFKKCIBW | FICA: Extraction of Cleared Items | 21 | AUGDT | Clearing date | nvarchar | 8 | 0 | | |
53 | DFKKCOLI_LOG | Collection Agency Information File: Communication Log | 12 | AUGDT | Clearing Date (Batch Input) | nvarchar | 8 | 0 | | |
54 | DFKKCOLLP_IP_W | Buffer: Collection Agency Info File (Item for Payments) | 19 | AUGDT | Clearing Date (Batch Input) | nvarchar | 8 | 0 | | |
55 | DFKKIPBW_ITEM | Installment Plan Items for Business Warehouse | 18 | AUGDT | Clearing date | nvarchar | 8 | 0 | | |
56 | DFKKIPBW_ORIG | Installment Plan Original Items for Business Warehouse | 21 | AUGDT | Clearing date | nvarchar | 8 | 0 | | |
57 | DFKKMOP | Items in contract account document | 60 | AUGDT | Clearing date | nvarchar | 8 | 0 | | |
58 | DFKKMOPW | Items in contract account document | 16 | AUGDT | Clearing date | nvarchar | 8 | 0 | | |
59 | DFKKOP | Items in contract account document | 60 | AUGDT | Clearing date | nvarchar | 8 | 0 | | |
60 | DFKKOPW | Items in contract account document | 16 | AUGDT | Clearing date | nvarchar | 8 | 0 | | |
61 | DFKKOP_REP | Open Items from FPO4 | 64 | AUGDT | Clearing date | nvarchar | 8 | 0 | | |
62 | DFKKOP_SHORT | Partner Items for FI-CA Document - Extracts | 15 | AUGDT | Clearing date | nvarchar | 8 | 0 | | |
63 | DFKKRAP | Clearing/Reversal History (Line Item Level) < 4.62 | 7 | AUGDT | Clearing date | nvarchar | 8 | 0 | | |
64 | DFKKRAPT | Clearing/Reversal History (Line Item Level) | 7 | AUGDT | Clearing date | nvarchar | 8 | 0 | | |
TOPCross-Application Components |
65 | BBSID | Accounting: Secondary index for customers | 6 | AUGDT | Clearing Date | nvarchar | 8 | 0 | | |
TOPData Retention Tool |
66 | TXW_S_BSEG | Retrieve BSEG from archive | 52 | AUGDT | Clearing Date | nvarchar | 8 | 0 | | |
TOPDown Payment Chains |
67 | /SAPPCE/TDPCIDXC | Down Payment Chain: Index for Cleared Items | 10 | AUGDT | Clearing Date | nvarchar | 8 | 0 | | |
68 | /SAPPCE/TDPCIDXO | Down Payment Chain: Index for Open Items | 10 | AUGDT | Clearing Date | nvarchar | 8 | 0 | | |
TOPFinancial Accounting |
69 | AGKO | Cleared Accounts | 7 | AUGDT | Clearing Date | nvarchar | 8 | 0 | | |
70 | ARIX_BSAD | FI_DOCUMNT: Line-Oriented Index for Archiving Customer Accts | 9 | AUGDT | Clearing Date | nvarchar | 8 | 0 | | |
71 | ARIX_BSAK | FI_DOCUMNT: Line-Oriented Indx for Archiving Vendor Accounts | 9 | AUGDT | Clearing Date | nvarchar | 8 | 0 | | |
72 | ARIX_BSAS | FI_DOCUMNT: Line-Oriented Index for Archiving G/L Accounts | 9 | AUGDT | Clearing Date | nvarchar | 8 | 0 | | |
73 | BFIT_A | FI Subsequent BA/PC Adjustment: G/L Account Items | 10 | AUGDT | Clearing Date | nvarchar | 8 | 0 | | |
74 | BFOD_A | FI Subsequent BA/PC Adjustment: Customer Items | 12 | AUGDT | Clearing Date | nvarchar | 8 | 0 | | |
75 | BFOK_A | FI subsequent BA/PC adjustment: Vendor items | 12 | AUGDT | Clearing Date | nvarchar | 8 | 0 | | |
76 | BFO_A_RA | Versions for Resetting Cleared Items | 10 | AUGDT | Clearing Date | nvarchar | 8 | 0 | | |
77 | BSAD | Accounting: Secondary Index for Customers (Cleared Items) | 6 | AUGDT | Clearing Date | nvarchar | 8 | 0 | | |
78 | BSAK | Accounting: Secondary Index for Vendors (Cleared Items) | 6 | AUGDT | Clearing Date | nvarchar | 8 | 0 | | |
79 | BSAS | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 4 | AUGDT | Clearing Date | nvarchar | 8 | 0 | | |
80 | BSID | Accounting: Secondary Index for Customers | 6 | AUGDT | Clearing Date | nvarchar | 8 | 0 | | |
81 | BSIK | Accounting: Secondary Index for Vendors | 6 | AUGDT | Clearing Date | nvarchar | 8 | 0 | | |
82 | BSIS | Accounting: Secondary Index for G/L Accounts | 4 | AUGDT | Clearing Date | nvarchar | 8 | 0 | | |
TOPFunds Management |
83 | FMPU_MIG_OPITEMS | Migration of Payment Update: Doc. Bundle to Be Closed | 8 | AUGDT | Clearing Date | nvarchar | 8 | 0 | | |
TOPFunds Management-Specific Postings |
84 | PAYRC | Additional Header Data for Recovery Order | 41 | AUGDT | Clearing Date | nvarchar | 8 | 0 | | |
TOPGeneral Ledger Accounting |
85 | BSEG_ADD | Entry View of Accounting Document for Additional Ledgers | 100 | AUGDT | Clearing Date | nvarchar | 8 | 0 | | |
86 | FAGLBSAS | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 4 | AUGDT | Clearing Date | nvarchar | 8 | 0 | | |
87 | FAGLBSIS | Accounting: Secondary Index for G/L Accounts | 4 | AUGDT | Clearing Date | nvarchar | 8 | 0 | | |
88 | FAGL_BW_LOG_ITEM | FI-GL: Log for BW Extraction: Line Items | 17 | AUGDT | Clearing Date | nvarchar | 8 | 0 | | |
TOPGL Account Posting |
89 | TCJ_WTAX_ITEMS | Withholding Tax Items for Cash Journal Document Items | 45 | AUGDT | Clearing Date | nvarchar | 8 | 0 | | |
TOPInformation System |
90 | DKKOP | Balance Audit Trail | 42 | AUGDT | Clearing Date | nvarchar | 8 | 0 | | |
91 | DKOKP | Open Item Account Balance Audit Trail | 12 | AUGDT | Clearing Date | nvarchar | 8 | 0 | | |
92 | DSKOP | Balance Audit Trail | 47 | AUGDT | Clearing Date | nvarchar | 8 | 0 | | |
TOPInvoicing |
93 | DEABPS | Customer change table: Logical view of BB amounts | 53 | AUGDT | Clearing date | nvarchar | 8 | 0 | | |
94 | EABPS_CORR | Sub Budget Billing Plan for Correspondence Print | 37 | AUGDT | Clearing date | nvarchar | 8 | 0 | | |
TOPLocal Currency Changeover |
95 | EWUFI_SCA | EMU conversion: Table of the clearings to be adjusted | 9 | AUGDT | Clearing Date | nvarchar | 8 | 0 | | |
TOPLocalization |
96 | J_1AWITH | Withholding transaction data | 32 | AUGDT | Clearing Date | nvarchar | 8 | 0 | | |
97 | J_1IEWTCHLN | Table for Internal and external Challan nos-EWT India. | 10 | AUGDT | Clearing Date | nvarchar | 8 | 0 | | |
98 | J_3RFTAX_EXTRD | Tax Extract Detail Lines | 12 | AUGDT | Clearing Date | nvarchar | 8 | 0 | | |
99 | RFITEMAP_NO_ITEM | Item wise detail for the Vendor Transactions | 12 | AUGDT | Clearing Date | nvarchar | 8 | 0 | | |
100 | RFITEMAR_NO_ITEM | Item wise detail for the Customer Transactions | 12 | AUGDT | Clearing Date | nvarchar | 8 | 0 | | |
101 | RFITEMGL_NO_ITEM | Item wise detail for the GL Account Transactions | 12 | AUGDT | Clearing Date | nvarchar | 8 | 0 | | |
TOPPayment Transactions |
102 | FPIN_T_POSTEN | Database for Penalty Interest (Chorus) | 11 | AUGDT | Clearing Date | nvarchar | 8 | 0 | | |
103 | REGUH | Settlement data from payment program | 113 | AUGDT | Clearing Date | nvarchar | 8 | 0 | | |
104 | REGUHH | REGUH version before the 'n'th change | 32 | AUGDT | Clearing Date | nvarchar | 8 | 0 | | |
TOPReal Estate Management |
105 | VIAKBSEG | Document Line Item from SCS for Interface | 133 | AUGDT | Clearing Date | nvarchar | 8 | 0 | | |
106 | VIMIIP | Invoice Items | 11 | AUGDT | Clearing Date | nvarchar | 8 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
107 | /BEV3/CH1030BSG1 | Document Segment CH Event Ledger Part1 | 9 | AUGDT | Clearing Date | nvarchar | 8 | 0 | | |
TOPRental Accounting |
108 | VIRALSRHD | Statistics - Returned Debit Memos in RE: Header Data | 13 | AUGDT | Clearing Date | nvarchar | 8 | 0 | | |
TOPTechnical Application Support |
109 | CNV_20425_SCA | EMU conversion: Table of the clearings to be adjusted | 6 | AUGDT | Clearing Date | nvarchar | 8 | 0 | | |
TOPTransaction Manager |
110 | VTBSIZU | Hedge Allocation | 22 | AUGDT | Clearing Date | nvarchar | 8 | 0 | | |