| 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 | 93 | BEWAR | | nvarchar | 3 | 0 | | |
2 | /BIC/B0000169000 | PSA for 0FI_GL_41 T90CLNT090 Documents, Compact | 93 | BEWAR | | nvarchar | 3 | 0 | | |
3 | /BIC/B0000172000 | PSA for 0FI_GL_14 T90CLNT090 Gen. Ledger: Items | 133 | BEWAR | | nvarchar | 3 | 0 | | |
4 | /OPT/VIM_1ITEM_S | Document Item | 92 | BEWAR | Transaction Type | nvarchar | 3 | 0 | | |
5 | /OPT/VIM_TITEM | Document Item | 92 | BEWAR | Transaction Type | nvarchar | 3 | 0 | | |
6 | BSAS_BAK | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 59 | BEWAR | Transaction Type | nvarchar | 3 | 0 | | |
7 | BSEG | Accounting Document Segment | 59 | BEWAR | Transaction Type | nvarchar | 3 | 0 | | |
8 | BSIS_BAK | Accounting: Secondary Index for G/L Accounts | 59 | BEWAR | Transaction Type | nvarchar | 3 | 0 | | |
9 | BSSEG | Accounting Document Segment | 48 | BEWAR | Transaction Type | nvarchar | 3 | 0 | | |
10 | FAGLBSAS_BAK | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 59 | BEWAR | Transaction Type | nvarchar | 3 | 0 | | |
11 | FAGLBSIS_BAK | Accounting: Secondary Index for G/L Accounts | 59 | BEWAR | Transaction Type | nvarchar | 3 | 0 | | |
12 | FUDT_VDOCBSEG | Verification Document Item with Additional Info | 48 | BEWAR | Transaction Type | nvarchar | 3 | 0 | | |
13 | FUDT_VDOCBSEGEV | Verification Document Item in the Entry View | 48 | BEWAR | Transaction Type | nvarchar | 3 | 0 | | |
14 | FUDT_VDOCBSEGH | Verification Document Segment with Additional Info(History) | 48 | BEWAR | Transaction Type | nvarchar | 3 | 0 | | |
15 | GLPOS_C_CT | FI Document: Entry View | 57 | BEWAR | Transaction Type | nvarchar | 3 | 0 | | |
16 | GLPOS_C_DEB_CT | GLPOS_C_CT Customer Line Items | 57 | BEWAR | Transaction Type | nvarchar | 3 | 0 | | |
17 | GLPOS_C_GL_CT | GLPOS_C_CT G/L Line Items | 57 | BEWAR | Transaction Type | nvarchar | 3 | 0 | | |
18 | GLPOS_C_VEN_CT | GLPOS_C_CT Vendor Line Items | 57 | BEWAR | Transaction Type | nvarchar | 3 | 0 | | |
19 | GLPOS_N_CT | New General Ledger: Line Item with Currency Type | 57 | BEWAR | Transaction Type | nvarchar | 3 | 0 | | |
20 | GLPOS_N_GL_CT | New General Ledger: Line Item with Currency Type | 57 | BEWAR | Transaction Type | nvarchar | 3 | 0 | | |
21 | J_1UF_TP_BSEGCOR | Items of Corrective documents | 13 | BEWAR | Consolidation Transaction Type | nvarchar | 3 | 0 | | |
22 | J_1UF_TP_BSEGORI | Items of Original documents | 13 | BEWAR | Consolidation Transaction Type | nvarchar | 3 | 0 | | |
23 | J_3RF_TP_BSEGCOR | Items of Corrective documents | 13 | BEWAR | Consolidation Transaction Type | nvarchar | 3 | 0 | | |
24 | J_3RF_TP_BSEGORI | Items of Original documents | 13 | BEWAR | Consolidation Transaction Type | nvarchar | 3 | 0 | | |
25 | T030C | Global Standard Account Table | 8 | BEWAR | Transaction Type | nvarchar | 3 | 0 | | |
26 | YVIM_1ITEM | Document Item | 92 | BEWAR | Transaction Type | nvarchar | 3 | 0 | | |
TOPBasic Functions |
27 | BSACC_HIST_TA | Account History: Transaction Types Used | 3 | BEWAR | Transaction Type | nvarchar | 3 | 0 | | |
TOPCollectionsDisbursements |
28 | VVKKFOP | Single Doc in Posting Data Interface | 47 | BEWAR | Transaction Type | nvarchar | 3 | 0 | | |
29 | VVKKFOPT | Table for FS-CD Test Data of Structure VKKKFOP | 41 | BEWAR | Transaction Type | nvarchar | 3 | 0 | | |
TOPData Retention Tool |
30 | TXW_S_BSEG | Retrieve BSEG from archive | 53 | BEWAR | Consolidation Transaction Type | nvarchar | 3 | 0 | | |
TOPFinancial Accounting |
31 | /OPT/VIM_1ITEM | Document Item | 92 | BEWAR | Transaction Type | nvarchar | 3 | 0 | | |
32 | BSAS | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 59 | BEWAR | Transaction Type | nvarchar | 3 | 0 | | |
33 | BSIS | Accounting: Secondary Index for G/L Accounts | 59 | BEWAR | Transaction Type | nvarchar | 3 | 0 | | |
34 | EBSEG | Doc.Segment of Fin.Accntng External Documents | 31 | BEWAR | Transaction Type | nvarchar | 3 | 0 | | |
35 | KMZEI | FI: Account Assignment Model Item Information | 19 | BEWAR | Transaction Type | nvarchar | 3 | 0 | | |
36 | KOMU | Account Assignment Templates for G/L Account Items | 19 | BEWAR | Transaction Type | nvarchar | 3 | 0 | | |
37 | VBSEGD | Document Segment for Customer Document Parking | 125 | BEWAR | Transaction Type | nvarchar | 3 | 0 | | |
38 | VBSEGK | Document Segment for Vendor Document Parking | 137 | BEWAR | Transaction Type | nvarchar | 3 | 0 | | |
TOPGeneral Ledger Accounting |
39 | BSEG_ADD | Entry View of Accounting Document for Additional Ledgers | 19 | BEWAR | Consolidation Transaction Type | nvarchar | 3 | 0 | | |
40 | FAGLBSAS | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 59 | BEWAR | Transaction Type | nvarchar | 3 | 0 | | |
41 | FAGLBSIS | Accounting: Secondary Index for G/L Accounts | 59 | BEWAR | Transaction Type | nvarchar | 3 | 0 | | |
TOPInventory Management |
42 | MWZDM07M1 | ZDM07M1 | 221 | BEWAR | Consolidation Transaction Type | nvarchar | 3 | 0 | | |
TOPPatient Management |
43 | N1VKG | IS-H: Item of Clinical Order (Preregistration) | 48 | BEWAR | IS-H: Movement Type | nvarchar | 2 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
44 | /BEV3/CH1030BSG1 | Document Segment CH Event Ledger Part1 | 50 | BEWAR | Transaction Type | nvarchar | 3 | 0 | | |
45 | /BEV3/CHCBEWAT | Customizing Contract Movement Type, Text | 3 | BEWAR | Contract Movement Type | nvarchar | 4 | 0 | | |
46 | /BEV3/CHCBKRIVBW | Contract MVT dependent on CoCd, RI, Date part, Contract view | 6 | BEWAR | Contract Movement Type | nvarchar | 4 | 0 | | |
47 | /BEV3/CHCTBEWA | Customizing Contract Movement Type | 2 | BEWAR | Contract Movement Type | nvarchar | 4 | 0 | | |
48 | /BEV3/CHCTBWA | Validation Table CH Movement Type/Reconciliation Account | 2 | BEWAR | Contract Movement Type | nvarchar | 4 | 0 | | |
49 | /BEV3/CHCTKONT | Customizing Account View | 4 | BEWAR | Contract Movement Type | nvarchar | 4 | 0 | | |
50 | /BEV3/CHCVBWBKRI | RI, DAPART,contract view dependent on contract movement type | 3 | BEWAR | Contract Movement Type | nvarchar | 4 | 0 | | |