| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /ATL/FORDOCLINE | Document line details : Posting key & Block indication | 4 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
2 | /BIC/B0000165000 | PSA for 0FI_AP_4 T90CLNT090 FI-AP: Items Delta | 17 | BSCHL | | nvarchar | 2 | 0 | | |
3 | /BIC/B0000166000 | PSA for 0FI_AR_4 T90CLNT090 FI-AR Items Delta | 17 | BSCHL | | nvarchar | 2 | 0 | | |
4 | /BIC/B0000168000 | PSA for 0FI_GL_40 T90CLNT090 G/L Accounts: Items | 13 | BSCHL | | nvarchar | 2 | 0 | | |
5 | /BIC/B0000169000 | PSA for 0FI_GL_41 T90CLNT090 Documents, Compact | 13 | BSCHL | | nvarchar | 2 | 0 | | |
6 | /BIC/B0000170000 | PSA for 0FI_GL_4 T90CLNT090 FI-GL Items Delta | 15 | BSCHL | | nvarchar | 2 | 0 | | |
7 | /BIC/B0000172000 | PSA for 0FI_GL_14 T90CLNT090 Gen. Ledger: Items | 13 | BSCHL | | nvarchar | 2 | 0 | | |
8 | /CCEE/SIFIPOBOTI | ePoboti: Obligatory manysided reconciliation - XML output | 23 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
9 | /CCEE/SIFI_CDTYP | SI: Cash Sales report - document type assignment | 4 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
10 | /OPT/AT_APPR_HIS | Approval History for Level Based Approvals | 108 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
11 | /OPT/AT_LBA_LOG | Approval History for Level Based Approvals | 109 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
12 | /OPT/VIM_1CLEAR | /OPT/VIM_1HEAD Extension with Clearing Documents (BSAK) | 12 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
13 | BOE_COL_ITEM | Collection item data table | 16 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
14 | BOE_DIS_ITEM | Discount item data table | 5 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
15 | BOE_PAY_ITEM | Payment item data table | 5 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
16 | BSAD_BAK | Accounting: Secondary index for customers (cleared items) | 19 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
17 | BSAK_BAK | Accounting: Secondary Index for Vendors (Cleared Items) | 19 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
18 | BSAS_BAK | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 16 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
19 | BSEG | Accounting Document Segment | 10 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
20 | BSID_BAK | Accounting: Secondary Index for Customers | 19 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
21 | BSIK_BAK | Accounting: Secondary index for vendors | 19 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
22 | BSIS_BAK | Accounting: Secondary Index for G/L Accounts | 16 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
23 | BSSEG | Accounting Document Segment | 10 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
24 | FAGLBSAS_BAK | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 16 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
25 | FAGLBSIS_BAK | Accounting: Secondary Index for G/L Accounts | 16 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
26 | FIDOC_EOP | Document extract for EOP check | 6 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
27 | FIEUD_FIDOC_I | SAFT: FI Transaction Document Item | 68 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
28 | FUCNBUSTRAN | Assign Document Type to Entry Layout | 6 | BSCHL | Posting Key Indicator | nvarchar | 1 | 0 | | |
29 | FUDT_VDOCBSEG | Verification Document Item with Additional Info | 10 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
30 | FUDT_VDOCBSEGEV | Verification Document Item in the Entry View | 10 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
31 | FUDT_VDOCBSEGH | Verification Document Segment with Additional Info(History) | 10 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
32 | GLPOS_C_CT | FI Document: Entry View | 63 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
33 | GLPOS_C_DEB_CT | GLPOS_C_CT Customer Line Items | 63 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
34 | GLPOS_C_GL_CT | GLPOS_C_CT G/L Line Items | 63 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
35 | GLPOS_C_VEN_CT | GLPOS_C_CT Vendor Line Items | 63 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
36 | GLPOS_N_CT | New General Ledger: Line Item with Currency Type | 63 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
37 | GLPOS_N_GL_CT | New General Ledger: Line Item with Currency Type | 63 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
38 | J_1AWTH_TAX_PSTK | Conditions per Posting Key for Applying WithholdingTax | 3 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
39 | MHND | Dunning Data | 25 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
40 | REGUP | Processed items from payment program | 25 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
41 | T017 | is being deleted | 3 | BSCHL | G/L Accounts Posting Key | nvarchar | 2 | 0 | | |
42 | TBSL | Posting Key | 2 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
43 | TBSLT | Posting Key Names | 3 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
44 | VIYCEXPITEM | Expense Items | 16 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
TOPAccounting Interface |
45 | GLE_FI_ITEM_MODF | ECS: Modified FI Line Items (Header/Item/Currency Data) | 80 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
46 | GLE_FI_ITEM_ORIG | ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F) | 80 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
TOPAlternative Valuation Run |
47 | CKMLAVRDOCIT | Lines for Cumulation Posting Document | 21 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
TOPBasic Functions |
48 | BSIW | Index table for customer bills of exchange used | 12 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
49 | BSIX | Index table for customer bills of exchange used | 12 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
TOPCentral Cash Desk Procedure |
50 | FMFGT_IPAC_ACCT | List of DIT & FBT Accounts for IPAC Interface Process | 6 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
TOPCross-Application Components |
51 | BBSID | Accounting: Secondary index for customers | 19 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
52 | J_2GLPFI | Logical Papers for FI | 5 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
TOPData Retention Tool |
53 | TXW_S_BSEG | Retrieve BSEG from archive | 13 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
TOPElectronic Bank Statement |
54 | FEB_ACCNT_SAVE | Saving of Posting Lines for Postprocessing (Account Assign.) | 6 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
55 | FEB_ACT | Acct Assignment Templates | 6 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
56 | FEB_ITEM_SAVE | Saving of Posting Items for Postprocessing (On Account) | 6 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
TOPExtended Rebate |
57 | BON_ENH_LEDGER | Reconciliation Accounts for Rebate Credit Memos | 7 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
TOPExtra Charge |
58 | /BEV1/ECMITD | Extra Charge Reconciliation Accounts | 8 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
TOPFinancial Accounting |
59 | ACCTIT | Compressed Data from FI/CO Document | 24 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
60 | BSAD | Accounting: Secondary Index for Customers (Cleared Items) | 19 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
61 | BSAK | Accounting: Secondary Index for Vendors (Cleared Items) | 19 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
62 | BSAS | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 16 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
63 | BSID | Accounting: Secondary Index for Customers | 19 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
64 | BSIK | Accounting: Secondary Index for Vendors | 19 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
65 | BSIS | Accounting: Secondary Index for G/L Accounts | 16 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
66 | DOCCHG_EWBUCH | Customizing of Posting Transaction | 3 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
67 | EBSEG | Doc.Segment of Fin.Accntng External Documents | 9 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
68 | ICRCA | ICRC: Items to be Reconciled | 19 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
69 | ICRCU | ICRC: Potentially Differing Document Groups | 19 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
70 | ICRCZ | ICRC: Reconciled, Completed Items | 19 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
71 | J_1GJR_PK | Posting key descriptions in Journal | 4 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
72 | J_1GMYF2 | Customer/Vendor invoice selection criteria | 5 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
73 | J_5KFH_CADVTYPE | Advance accounting control settings | 3 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
74 | KMZEI | FI: Account Assignment Model Item Information | 6 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
75 | KOMU | Account Assignment Templates for G/L Account Items | 6 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
76 | VBSEGA | Document Segment for Document Parking - Asset Database | 8 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
77 | VBSEGD | Document Segment for Customer Document Parking | 8 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
78 | VBSEGK | Document Segment for Vendor Document Parking | 8 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
79 | VBSEGS | Document Segment for Document Parking - G/L Account Database | 8 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
TOPFlexible Real Estate Management |
80 | VIXCOTDOC | COA, Distribution of VAT, Documents | 12 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
TOPFund Accounting |
81 | FMGLFLEXA | General Ledger: Actual Line Items | 41 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
82 | PSGLFLEXA | General Ledger: Actual Line Items | 45 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
TOPFunds Management-Specific Postings |
83 | FMFUNDTRANSYEAR | Additional Documents for Funds Transfer to Diff. Years | 10 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
84 | PAYAC10 | Posting Key per DR/CR Indicator | 5 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
85 | PSOSEGA | Document Segment for Assets Document Parking | 9 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
86 | PSOSEGD | Document Segment: Recurring Request, Customer | 9 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
87 | PSOSEGK | Recurring Request Document Segment, Vendors | 9 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
88 | PSOSEGS | Recurring Request Document Segment, G/L Accounts | 9 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
TOPGeneral Ledger Accounting |
89 | BSEG_ADD | Entry View of Accounting Document for Additional Ledgers | 8 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
90 | FAGLBSAS | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 16 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
91 | FAGLBSIS | Accounting: Secondary Index for G/L Accounts | 16 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
92 | FAGLFLEXA | General Ledger: Actual Line Items | 43 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
93 | FAGL_BW_LOG_ITEM | FI-GL: Log for BW Extraction: Line Items | 20 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
94 | FAGL_SPLINFO | Splittling Information of Open Items | 52 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
TOPInformation System |
95 | BWPOS | Valuations for Open Items | 26 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
96 | DKKOP | Balance Audit Trail | 29 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
97 | DKOKP | Open Item Account Balance Audit Trail | 32 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
98 | DSKOP | Balance Audit Trail | 28 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
TOPJoint Venture und Production Sharing Accounting |
99 | JVGLFLEXA | General Ledger: Actual Line Items | 45 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
TOPLocalization |
100 | ISJPSELECTION | Selection of line items for Invoice Summary | 4 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
101 | J_1BIMFI | Movement Types for Vendor Invoices (Brazil) | 5 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
102 | J_1IEWT_CUST | Customer certificates ,Challan customizing EWT- India | 6 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
103 | J_3RFTAX_EXTRD | Tax Extract Detail Lines | 16 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
104 | J_3RNKS_TBSL | Credit memo posting keys for AuC | 2 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
105 | RFITEMAP_NO_ITEM | Item wise detail for the Vendor Transactions | 16 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
106 | RFITEMAR_NO_ITEM | Item wise detail for the Customer Transactions | 16 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
107 | RFITEMGL_NO_ITEM | Item wise detail for the GL Account Transactions | 16 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
TOPPatient Accounting |
108 | TN22P | IS-H: Control Parameters FI Posting Down Payment | 11 | BSCHL | IS-H: Posting key for bank posting | nvarchar | 2 | 0 | | |
109 | TN22R | IS-H: Control Params FI Posting Copayment/Copay.Cred.Memo | 9 | BSCHL | IS-H: Posting key for bank posting | nvarchar | 2 | 0 | | |
TOPPayment Transactions |
110 | FPRL_ITEM | Item Data | 33 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
TOPPeriodical Sales and Distribution |
111 | JFXBPOSDL | IS-M: Backup Transfer Internal Table XBPOS | 9 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
TOPPOS Interface |
112 | TWPIF | Transaction type-dependent control of POS financial trans. | 5 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
TOPReal Estate Management |
113 | VIAKBSEG | Document Line Item from SCS for Interface | 32 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
114 | /BEV1/BO_LEDGER | Reconciliation Accounts for Rebate Credit Memos | 7 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
115 | /BEV1/RBMITD | Rebate Reconciliation Accounts | 7 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
116 | /BEV3/CH1030BSG1 | Document Segment CH Event Ledger Part1 | 12 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
117 | /BEV3/CHABRSTZ_P | CH Settlement Items - With Translations | 55 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
118 | /BEV3/CHA_DRGZUO | Assignment CH business transactions to print groups | 4 | BSCHL | Posting key | nvarchar | 2 | 0 | | |
119 | /BEV3/CHBDMDHST | History of Condit. Modifications from Temp. Settlement Items | 56 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
120 | /BEV3/CHCEV1030X | CH BTE Allowed 00001030 Data | 6 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
121 | /BEV3/CHCEV103X | CH BTE Permissible Events Res. frm Combination CHD/1030 Data | 8 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
122 | /BEV3/CHCEVACDT | Assignment to posting, document and to-settlement date (BTE) | 5 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
123 | /BEV3/CHCEVACPR | Selection of posting line for the date compensation (BTE) | 5 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
124 | /BEV3/CHCEVLASFI | CH BTE: Customizing Event Listener Assessment FI | 4 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
125 | /BEV3/CHCEVLCAC | CH BTE Customizing Event Listener ACCOUNT | 6 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
126 | /BEV3/CHCEVLCAFI | CH BTE: Customizing Event Listener Assessment FI | 5 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
127 | /BEV3/CHCIVRG01 | CI: Customizing Business Process Detail 0001 | 5 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
128 | /BEV3/CHCI_VORG | Customizing Business Processes Header Data | 4 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
129 | /BEV3/CHCTBSCHL | Posting key dependent on CoCd,acc. type/Datepart,sett.method | 6 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
130 | /BEV3/CHCTKMPBCH | Complement Postings (BTE) | 5 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
131 | /BEV3/CHCTKONT | Customizing Account View | 7 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
132 | /BEV3/CHCTSTBSHL | Posting key dependent on CoCd,acc. type/Datepart,sett.method | 6 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
133 | /BEV3/CHCTSTRKZ | CH Settlement Tax Indicator | 6 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
134 | /BEV3/CHCVALI1 | Customizing Validation FI - CH Transactions | 6 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
135 | /BEV3/CHERGSTZ_P | CH Settlement Items - With Translations | 55 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
136 | /BEV3/CHERGSTZ_S | CH Settlement Statistics | 56 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
137 | /BEV3/CHEVLIASFI | CH BTE Event Listener Assessment FI | 9 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
138 | /BEV3/CHEXCSTZ_P | CH Settlement Items/Non-Posted Docs w/o Date Statistics | 55 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
139 | /BEV3/CHRESSTZ_P | CH Settlement Items - Reset Documents (2/Transaction) | 55 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
140 | /BEV3/CHSHTSTZ_P | CH Settlement Item | 55 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
141 | /BEV3/CHSIMBDMDH | CH simulation history of modifications caused by conditions | 56 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
142 | /BEV3/CHSIMSTZ_P | CH Simulation Items | 55 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
143 | /BEV3/CHSIMSTZ_S | CH Simulation Statistics | 56 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
144 | /BEV3/CHTMPMDHST | Temp. history of cond. modifications from temp. settle. item | 56 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
145 | /BEV3/CHTRMSTZ_P | CH Date Item | 55 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
146 | /BEV3/CHTRMSTZ_S | CH Date Statistics | 56 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
147 | /BEV3/CHVABRSTZS | CH Settlement Statistics | 56 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
TOPSAP Healthcare - Industry-Specific Components for Hospitals |
148 | TN22G | IS-H: Steuerungsparameter FI-Buchung amb. Zuzahlung | 8 | BSCHL | IS-H: Buchungsschlüssel für Bankbuchung | nvarchar | 2 | 0 | | |
TOPSpecial Purpose Ledger |
149 | /CCIS/PROFTAXA | Actual Line Items Table for General Ledger | 53 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |
TOPTraders and Schedulers Workbench |
150 | OIJ_RU_FI_POST | Define posting parameters | 3 | BSCHL | Posting Key | nvarchar | 2 | 0 | | |