| 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 | 86 | BUPLA | | nvarchar | 4 | 0 | | |
2 | /BIC/B0000169000 | PSA for 0FI_GL_41 T90CLNT090 Documents, Compact | 86 | BUPLA | | nvarchar | 4 | 0 | | |
3 | /BIC/B0000172000 | PSA for 0FI_GL_14 T90CLNT090 Gen. Ledger: Items | 115 | BUPLA | | nvarchar | 4 | 0 | | |
4 | /OPT/VIM_1ITEM_S | Document Item | 70 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
5 | /OPT/VIM_TITEM | Document Item | 70 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
6 | BSAD_BAK | Accounting: Secondary index for customers (cleared items) | 151 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
7 | BSAK_BAK | Accounting: Secondary Index for Vendors (Cleared Items) | 147 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
8 | BSAS_BAK | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 55 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
9 | BSED | Bill of Exchange Fields Document Segment | 29 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
10 | BSEG | Accounting Document Segment | 294 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
11 | BSET | Tax Data Document Segment | 34 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
12 | BSID_BAK | Accounting: Secondary Index for Customers | 151 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
13 | BSIK_BAK | Accounting: Secondary index for vendors | 147 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
14 | BSIS_BAK | Accounting: Secondary Index for G/L Accounts | 55 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
15 | BSSEG | Accounting Document Segment | 283 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
16 | DFKKEPRT | Log for Inconsistent FI-CA Documents | 9 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
17 | FAGLBSAS_BAK | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 55 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
18 | FAGLBSIS_BAK | Accounting: Secondary Index for G/L Accounts | 55 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
19 | FIKZD_CONTR_MAPP | Subsoil use contracts mapping | 19 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
20 | FUDT_VDOCBSED | Bill of Exchange Fields Document Seg. of Verif. Doc | 29 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
21 | FUDT_VDOCBSEDH | Bill of Exchange Fields Segment of Verification Doc(History) | 29 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
22 | FUDT_VDOCBSEG | Verification Document Item with Additional Info | 283 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
23 | FUDT_VDOCBSEGEV | Verification Document Item in the Entry View | 283 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
24 | FUDT_VDOCBSEGH | Verification Document Segment with Additional Info(History) | 283 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
25 | FUDT_VDOCBSET | Tax Data Document Segment of Verification Document | 34 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
26 | FUDT_VDOCBSETH | Tax Data Document Segment of Verification Document(History) | 34 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
27 | GLPOS_C_CT | FI Document: Entry View | 68 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
28 | GLPOS_C_DEB_CT | GLPOS_C_CT Customer Line Items | 68 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
29 | GLPOS_C_GL_CT | GLPOS_C_CT G/L Line Items | 68 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
30 | GLPOS_C_VEN_CT | GLPOS_C_CT Vendor Line Items | 68 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
31 | GLPOS_N_CT | New General Ledger: Line Item with Currency Type | 68 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
32 | GLPOS_N_GL_CT | New General Ledger: Line Item with Currency Type | 68 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
33 | P2KR_KRTAX | Payroll Result Korea : Tax | 8 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
34 | REGUP | Processed items from payment program | 161 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
35 | TFK_ODNNR_DET | Assign Number Range Numbers to Document Classes | 4 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
36 | YVIM_1ITEM | Document Item | 70 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
TOPAccounting Interface |
37 | GLE_FI_ITEM_MODF | ECS: Modified FI Line Items (Header/Item/Currency Data) | 74 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
38 | GLE_FI_ITEM_ORIG | ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F) | 74 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
TOPBasic Data |
39 | VIBDBE | Business Entity | 41 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
40 | VIBDBU | Building | 88 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
41 | VIBDPR | Land | 63 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
TOPBasic Functions |
42 | BSIX | Index table for customer bills of exchange used | 24 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
TOPBilling |
43 | VBRK | Billing Document: Header Data | 94 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
TOPBusiness transactions |
44 | DFKKTXINV | Tax Invoices | 5 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
TOPContract Accounts Receivable and Payable |
45 | DFKKDEFREV_POS | Line Item Table (Event-Based Deferred Revenues) | 40 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
46 | DFKKMOP | Items in contract account document | 8 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
47 | DFKKMOPK | Items in contract account document | 7 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
48 | DFKKOP | Items in contract account document | 8 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
49 | DFKKOPK | Items in contract account document | 7 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
50 | DFKKOP_REP | Open Items from FPO4 | 12 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
51 | DFKKQSR | Individual Records for Withholding Tax Report | 8 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
52 | DFKKREP06 | Tax Report Data (Invoicing Time or Triggered) | 9 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
53 | DFKKREP06_S | Tax Report Data - Shadow Table for Posting Date | 9 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
54 | DFKKREP07 | Tax Report Data (Clearing Time) | 9 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
55 | DFKKSUM | Posting totals from FI-CA | 15 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
56 | DFKKZK | Payment lot: Header data | 55 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
57 | FKKDEFREV | Trigger Table for Deferred Revenue Postings | 42 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
58 | FKKVKP | Contract Account Partner-Specific | 74 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
TOPContract Billing |
59 | DBERCHZ3 | Individual line items (amount and price data) | 33 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
60 | DBERCHZ7 | Document line items (amount/price data, unimportant rows) | 33 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
TOPCross-Application Components |
61 | BBSID | Accounting: Secondary index for customers | 151 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
TOPFinancial Accounting |
62 | /OPT/VIM_1HEAD | Document Header | 147 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
63 | /OPT/VIM_1ITEM | Document Item | 70 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
64 | ACCTIT | Compressed Data from FI/CO Document | 142 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
65 | BSAD | Accounting: Secondary Index for Customers (Cleared Items) | 151 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
66 | BSAK | Accounting: Secondary Index for Vendors (Cleared Items) | 147 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
67 | BSAS | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 55 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
68 | BSID | Accounting: Secondary Index for Customers | 151 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
69 | BSIK | Accounting: Secondary Index for Vendors | 147 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
70 | BSIS | Accounting: Secondary Index for G/L Accounts | 55 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
71 | T058B | Number Range Assignment for Receipts | 6 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
72 | VBSEGA | Document Segment for Document Parking - Asset Database | 65 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
73 | VBSEGD | Document Segment for Customer Document Parking | 113 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
74 | VBSEGK | Document Segment for Vendor Document Parking | 124 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
75 | VBSEGS | Document Segment for Document Parking - G/L Account Database | 118 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
TOPGeneral Ledger Accounting |
76 | BSEG_ADD | Entry View of Accounting Document for Additional Ledgers | 66 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
77 | FAGLBSAS | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 55 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
78 | FAGLBSIS | Accounting: Secondary Index for G/L Accounts | 55 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
TOPGL Account Posting |
79 | TCJ_DOCUMENTS | Cash Journal Documents (Header Data) | 33 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
TOPInvoice Verification |
80 | RBKP | Document Header: Invoice Receipt | 125 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
TOPInvoicing in Contract Accounts Receivable and Payable |
81 | DFKKINVBILL_I | Billing Document Items | 21 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
82 | DFKKINVDOC_H | Invoicing Document Header | 46 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
83 | DFKKINVDOC_I | Items of Invoicing Document | 28 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
84 | DFKKINV_TRIG | Invoicing Order | 21 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
TOPKorea |
85 | T7KR0P | HR Personnel area/subarea (KOR) | 4 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
86 | T7KRBP | Business Place KR | 3 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
TOPLocalization |
87 | IDTW_VAT | VAT (Taiwan): Current Values | 3 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
88 | J_1HWTCTNCO4 | Withholding tax certificate numbering concept 4 | 4 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
89 | J_1IEWTCALID | Calendar for Payment Due date-EWT India | 3 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
90 | J_1IEWTNUMGR | Number Groups For Internal Challan Numbers- EWT India. | 3 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
91 | J_1IEWT_CERT | SAPscript Forms/section indicators for E WT Certificates | 3 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
92 | J_1IEWT_CERTIF | Certificate Issued Details-EWT India | 4 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
93 | J_1ISER_BSEG | Transaction table having the Invoices with Service Category | 30 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
94 | J_1IT030K | India Tax account determination ( T030K + BWMOD ) | 5 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
95 | J_1I_BUPLA_SECCO | Maps Business Place to Section code for TCS | 3 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
96 | J_3RFTAX_EXTRD | Tax Extract Detail Lines | 118 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
97 | OFF_NUM_ID | Settings for Official Document Numbering Indonesia | 3 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
98 | OFNUM_TW_2 | Official Numbering by Business Places-enabled ranges(TW) | 3 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
99 | RFITEMAP_NO_ITEM | Item wise detail for the Vendor Transactions | 117 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
100 | RFITEMAR_NO_ITEM | Item wise detail for the Customer Transactions | 117 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
101 | RFITEMGL_NO_ITEM | Item wise detail for the GL Account Transactions | 117 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
TOPMaster Data |
102 | EVER | IS-U Cont. | 66 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
103 | T012 | House Banks | 10 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
TOPPayment Transactions |
104 | FPRL_ITEM | Item Data | 77 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
105 | REGUV | Control records for the payment program | 14 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
TOPPublic Sector Contract Accounts Receivable and Payable |
106 | TFICA_DEF | Samples for Contract Account Types | 49 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
TOPSales and Distribution |
107 | IDVKBUR_BUPLA | Assignment of Business Place to Sales Office | 4 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
TOPTransfer to Financial Accounting |
108 | TRACT_DOCUMENT | Treasury: Accounting Adaptor Document | 31 | BUPLA | Business Place | nvarchar | 4 | 0 | | |
109 | TRACT_POSCONTEXT | Treasury: Position Context Table | 8 | BUPLA | Business Place | nvarchar | 4 | 0 | | |