| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /BIC/B0000168000 | PSA for 0FI_GL_40 T90CLNT090 G/L Accounts: Items | 89 | BUZID | | nvarchar | 1 | 0 | | |
2 | /BIC/B0000169000 | PSA for 0FI_GL_41 T90CLNT090 Documents, Compact | 89 | BUZID | | nvarchar | 1 | 0 | | |
3 | /BIC/B0000172000 | PSA for 0FI_GL_14 T90CLNT090 Gen. Ledger: Items | 124 | BUZID | | nvarchar | 1 | 0 | | |
4 | BSAD_BAK | Accounting: Secondary index for customers (cleared items) | 166 | BUZID | Identification of the Line Item | nvarchar | 1 | 0 | | |
5 | BSAK_BAK | Accounting: Secondary Index for Vendors (Cleared Items) | 171 | BUZID | Identification of the Line Item | nvarchar | 1 | 0 | | |
6 | BSAS_BAK | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 69 | BUZID | Identification of the Line Item | nvarchar | 1 | 0 | | |
7 | BSEG | Accounting Document Segment | 6 | BUZID | Identification of the Line Item | nvarchar | 1 | 0 | | |
8 | BSID_BAK | Accounting: Secondary Index for Customers | 166 | BUZID | Identification of the Line Item | nvarchar | 1 | 0 | | |
9 | BSIK_BAK | Accounting: Secondary index for vendors | 171 | BUZID | Identification of the Line Item | nvarchar | 1 | 0 | | |
10 | BSIM_BAK | Secondary Index, Documents for Material | 8 | BUZID | Identification of the Line Item | nvarchar | 1 | 0 | | |
11 | BSIS_BAK | Accounting: Secondary Index for G/L Accounts | 69 | BUZID | Identification of the Line Item | nvarchar | 1 | 0 | | |
12 | BSSEG | Accounting Document Segment | 6 | BUZID | Identification of the Line Item | nvarchar | 1 | 0 | | |
13 | FAGLBSAS_BAK | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 69 | BUZID | Identification of the Line Item | nvarchar | 1 | 0 | | |
14 | FAGLBSIS_BAK | Accounting: Secondary Index for G/L Accounts | 69 | BUZID | Identification of the Line Item | nvarchar | 1 | 0 | | |
15 | FIEUD_FIDOC_I | SAFT: FI Transaction Document Item | 8 | BUZID | Identification of the Line Item | nvarchar | 1 | 0 | | |
16 | FUDT_VDOCBSEG | Verification Document Item with Additional Info | 6 | BUZID | Identification of the Line Item | nvarchar | 1 | 0 | | |
17 | FUDT_VDOCBSEGEV | Verification Document Item in the Entry View | 6 | BUZID | Identification of the Line Item | nvarchar | 1 | 0 | | |
18 | FUDT_VDOCBSEGH | Verification Document Segment with Additional Info(History) | 6 | BUZID | Identification of the Line Item | nvarchar | 1 | 0 | | |
19 | GLPOS_C_CT | FI Document: Entry View | 71 | BUZID | Identification of the Line Item | nvarchar | 1 | 0 | | |
20 | GLPOS_C_DEB_CT | GLPOS_C_CT Customer Line Items | 71 | BUZID | Identification of the Line Item | nvarchar | 1 | 0 | | |
21 | GLPOS_C_GL_CT | GLPOS_C_CT G/L Line Items | 71 | BUZID | Identification of the Line Item | nvarchar | 1 | 0 | | |
22 | GLPOS_C_VEN_CT | GLPOS_C_CT Vendor Line Items | 71 | BUZID | Identification of the Line Item | nvarchar | 1 | 0 | | |
23 | GLPOS_N_CT | New General Ledger: Line Item with Currency Type | 71 | BUZID | Identification of the Line Item | nvarchar | 1 | 0 | | |
24 | GLPOS_N_GL_CT | New General Ledger: Line Item with Currency Type | 71 | BUZID | Identification of the Line Item | nvarchar | 1 | 0 | | |
25 | T169A | Posting String for Invoice Verification | 6 | BUZID | Identification of the Line Item | nvarchar | 1 | 0 | | |
26 | T169W | Posting Strings (Values) for SAPMM08R | 2 | BUZID | Identification of the Line Item | nvarchar | 1 | 0 | | |
TOPAccounting Interface |
27 | GLE_FI_ITEM_MODF | ECS: Modified FI Line Items (Header/Item/Currency Data) | 163 | BUZID | Identification of the Line Item | nvarchar | 1 | 0 | | |
28 | GLE_FI_ITEM_ORIG | ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F) | 163 | BUZID | Identification of the Line Item | nvarchar | 1 | 0 | | |
TOPData Retention Tool |
29 | TXW_S_BSEG | Retrieve BSEG from archive | 115 | BUZID | Identification of the Line Item | nvarchar | 1 | 0 | | |
TOPFinancial Accounting |
30 | ACCTIT | Compressed Data from FI/CO Document | 57 | BUZID | Identification of the Line Item | nvarchar | 1 | 0 | | |
31 | BSAD | Accounting: Secondary Index for Customers (Cleared Items) | 166 | BUZID | Identification of the Line Item | nvarchar | 1 | 0 | | |
32 | BSAK | Accounting: Secondary Index for Vendors (Cleared Items) | 171 | BUZID | Identification of the Line Item | nvarchar | 1 | 0 | | |
33 | BSAS | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 69 | BUZID | Identification of the Line Item | nvarchar | 1 | 0 | | |
34 | BSID | Accounting: Secondary Index for Customers | 166 | BUZID | Identification of the Line Item | nvarchar | 1 | 0 | | |
35 | BSIK | Accounting: Secondary Index for Vendors | 171 | BUZID | Identification of the Line Item | nvarchar | 1 | 0 | | |
36 | BSIS | Accounting: Secondary Index for G/L Accounts | 69 | BUZID | Identification of the Line Item | nvarchar | 1 | 0 | | |
37 | EBSEG | Doc.Segment of Fin.Accntng External Documents | 8 | BUZID | Identification of the Line Item | nvarchar | 1 | 0 | | |
38 | VBSEGS | Document Segment for Document Parking - G/L Account Database | 116 | BUZID | Identification of the Line Item | nvarchar | 1 | 0 | | |
TOPFunds Management-Specific Postings |
39 | FMFUNDTRANSYEAR | Additional Documents for Funds Transfer to Diff. Years | 115 | BUZID | Identification of the Line Item | nvarchar | 1 | 0 | | |
40 | PSOSEGS | Recurring Request Document Segment, G/L Accounts | 115 | BUZID | Identification of the Line Item | nvarchar | 1 | 0 | | |
TOPGeneral Ledger Accounting |
41 | BSEG_ADD | Entry View of Accounting Document for Additional Ledgers | 7 | BUZID | Identification of the Line Item | nvarchar | 1 | 0 | | |
42 | FAGLBSAS | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 69 | BUZID | Identification of the Line Item | nvarchar | 1 | 0 | | |
43 | FAGLBSIS | Accounting: Secondary Index for G/L Accounts | 69 | BUZID | Identification of the Line Item | nvarchar | 1 | 0 | | |
TOPInformation System |
44 | DKKOP | Balance Audit Trail | 31 | BUZID | Identification of the Line Item | nvarchar | 1 | 0 | | |
45 | DSKOP | Balance Audit Trail | 30 | BUZID | Identification of the Line Item | nvarchar | 1 | 0 | | |
TOPInventory Management |
46 | T156W | Posting string values | 13 | BUZID | Identification of the Line Item | nvarchar | 1 | 0 | | |
TOPInvoice Verification |
47 | BSIM | Secondary Index, Documents for Material | 8 | BUZID | Identification of the Line Item | nvarchar | 1 | 0 | | |
TOPLocalization |
48 | J_1BIM01 | MM-IM: Tax posting strings for inventory management | 15 | BUZID | Line Item ID | nvarchar | 1 | 0 | | |
49 | J_1BIMFI | Movement Types for Vendor Invoices (Brazil) | 3 | BUZID | Identification of the Line Item | nvarchar | 1 | 0 | | |
50 | J_1BIV05 | BUZID with special handling for NF | 2 | BUZID | Identification of the Line Item | nvarchar | 1 | 0 | | |
51 | J_3RFTAX_EXTRD | Tax Extract Detail Lines | 132 | BUZID | Identification of the Line Item | nvarchar | 1 | 0 | | |
52 | RFITEMAP_NO_ITEM | Item wise detail for the Vendor Transactions | 132 | BUZID | Identification of the Line Item | nvarchar | 1 | 0 | | |
53 | RFITEMAR_NO_ITEM | Item wise detail for the Customer Transactions | 132 | BUZID | Identification of the Line Item | nvarchar | 1 | 0 | | |
54 | RFITEMGL_NO_ITEM | Item wise detail for the GL Account Transactions | 132 | BUZID | Identification of the Line Item | nvarchar | 1 | 0 | | |
TOPReal Estate Management |
55 | VITAXD | Tax Shares per Real Estate Account Assignment | 49 | BUZID | Identification of the Line Item | nvarchar | 1 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
56 | /BEV3/CH1030BSG1 | Document Segment CH Event Ledger Part1 | 8 | BUZID | Identification of the Line Item | nvarchar | 1 | 0 | | |