| 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 | 12 | KKBER | | nvarchar | 4 | 0 | | |
2 | /BIC/B0000166000 | PSA for 0FI_AR_4 T90CLNT090 FI-AR Items Delta | 12 | KKBER | | nvarchar | 4 | 0 | | |
3 | /BIC/B0000168000 | PSA for 0FI_GL_40 T90CLNT090 G/L Accounts: Items | 82 | KKBER | | nvarchar | 4 | 0 | | |
4 | /BIC/B0000169000 | PSA for 0FI_GL_41 T90CLNT090 Documents, Compact | 82 | KKBER | | nvarchar | 4 | 0 | | |
5 | /BIC/B0000172000 | PSA for 0FI_GL_14 T90CLNT090 Gen. Ledger: Items | 103 | KKBER | | nvarchar | 4 | 0 | | |
6 | /SMD/MD_____00YM | SID-Tabelle fuer Credit control area | 3 | KKBER | Credit control area | nvarchar | 4 | 0 | | |
7 | BSAD_BAK | Accounting: Secondary index for customers (cleared items) | 135 | KKBER | Credit control area | nvarchar | 4 | 0 | | |
8 | BSEG | Accounting Document Segment | 273 | KKBER | Credit control area | nvarchar | 4 | 0 | | |
9 | BSID_BAK | Accounting: Secondary Index for Customers | 135 | KKBER | Credit control area | nvarchar | 4 | 0 | | |
10 | BSSEG | Accounting Document Segment | 262 | KKBER | Credit control area | nvarchar | 4 | 0 | | |
11 | CNVCMIS_M_VMVLD | CMIS: Generated Pooltable for Matchcode ID VMVL -D | 2 | KKBER | Credit control area | nvarchar | 4 | 0 | | |
12 | CNV_20100_T001 | CNV backup copy for T001 | 16 | KKBER | Credit control area | nvarchar | 4 | 0 | | |
13 | CNV_20200_T001AD | Original settings of company codes (additional fields) | 11 | KKBER | Credit control area | nvarchar | 4 | 0 | | |
14 | FUDT_VDOCBSEG | Verification Document Item with Additional Info | 262 | KKBER | Credit control area | nvarchar | 4 | 0 | | |
15 | FUDT_VDOCBSEGEV | Verification Document Item in the Entry View | 262 | KKBER | Credit control area | nvarchar | 4 | 0 | | |
16 | FUDT_VDOCBSEGH | Verification Document Segment with Additional Info(History) | 262 | KKBER | Credit control area | nvarchar | 4 | 0 | | |
17 | GLPOS_C_CT | FI Document: Entry View | 144 | KKBER | Credit control area | nvarchar | 4 | 0 | | |
18 | GLPOS_C_DEB_CT | GLPOS_C_CT Customer Line Items | 144 | KKBER | Credit control area | nvarchar | 4 | 0 | | |
19 | GLPOS_C_GL_CT | GLPOS_C_CT G/L Line Items | 144 | KKBER | Credit control area | nvarchar | 4 | 0 | | |
20 | GLPOS_C_VEN_CT | GLPOS_C_CT Vendor Line Items | 144 | KKBER | Credit control area | nvarchar | 4 | 0 | | |
21 | GLPOS_N_CT | New General Ledger: Line Item with Currency Type | 146 | KKBER | Credit control area | nvarchar | 4 | 0 | | |
22 | GLPOS_N_GL_CT | New General Ledger: Line Item with Currency Type | 146 | KKBER | Credit control area | nvarchar | 4 | 0 | | |
23 | REGUP | Processed items from payment program | 137 | KKBER | Credit control area | nvarchar | 4 | 0 | | |
24 | T014N | New credit control areas to be set up | 2 | KKBER | Credit control area | nvarchar | 4 | 0 | | |
25 | T691A | Credit management risk categories | 3 | KKBER | Credit control area | nvarchar | 4 | 0 | | |
26 | T691B | "Credit Management Groups" | 3 | KKBER | Credit control area | nvarchar | 4 | 0 | | |
27 | T691C | Credit management group names | 4 | KKBER | Credit control area | nvarchar | 4 | 0 | | |
28 | T691T | Credit management risk classes text | 4 | KKBER | Credit control area | nvarchar | 4 | 0 | | |
29 | ZEIM_VBAK | Sales Document: Header Data | 62 | KKBER | Credit control area | nvarchar | 4 | 0 | | |
TOPAccount Determination |
30 | TVTA | Organizational Unit: Sales Area(s) | 18 | KKBER | Credit control area | nvarchar | 4 | 0 | | |
TOPAccounting Interface |
31 | GLE_FI_ITEM_MODF | ECS: Modified FI Line Items (Header/Item/Currency Data) | 313 | KKBER | Credit control area | nvarchar | 4 | 0 | | |
32 | GLE_FI_ITEM_ORIG | ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F) | 313 | KKBER | Credit control area | nvarchar | 4 | 0 | | |
TOPAdaptor |
33 | UKM_KKBER2SGM | Assignment of Credit Control Area to Credit Segment | 2 | KKBER | Credit control area | nvarchar | 4 | 0 | | |
34 | UKM_TRANSFER_AR | Data from AR for SAP Credit Management | 10 | KKBER | Credit control area | nvarchar | 4 | 0 | | |
35 | UKM_TRANSFER_ARV | Data from AR for SAP Credit Management | 6 | KKBER | Credit control area | nvarchar | 4 | 0 | | |
TOPAdvertising Management |
36 | JHAK | IS-M/AM: Order-Publishing-Media (Header Data) | 24 | KKBER | Credit control area | nvarchar | 4 | 0 | | |
TOPAgency Business Global Trade |
37 | WBRK | Agency business: Header | 75 | KKBER | Credit control area | nvarchar | 4 | 0 | | |
TOPBasic Functions |
38 | BSIX | Index table for customer bills of exchange used | 37 | KKBER | Credit control area | nvarchar | 4 | 0 | | |
39 | KNKK | Customer master credit management: Control area data | 3 | KKBER | Credit control area | nvarchar | 4 | 0 | | |
40 | KNKKF1 | Credit Management: FI Status Data | 4 | KKBER | Credit control area | nvarchar | 4 | 0 | | |
41 | KNKKF2 | Credit Management: Open Items by Days in Arrears | 4 | KKBER | Credit control area | nvarchar | 4 | 0 | | |
42 | T001CM | Permitted Credit Control Areas per Company Code | 3 | KKBER | Credit control area | nvarchar | 4 | 0 | | |
43 | T014 | Credit control areas | 2 | KKBER | Credit control area | nvarchar | 4 | 0 | | |
44 | T014T | Credit control area names | 3 | KKBER | Credit control area | nvarchar | 4 | 0 | | |
45 | T024B | Credit management: Credit representative groups | 3 | KKBER | Credit control area | nvarchar | 4 | 0 | | |
TOPBasis Components |
46 | ZDS400_T001 | Buchungskreise | 15 | KKBER | Kreditkontrollbereich | nvarchar | 4 | 0 | | |
TOPBilling |
47 | VBRK | Billing Document: Header Data | 67 | KKBER | Credit control area | nvarchar | 4 | 0 | | |
TOPConditions |
48 | B015 | Credit Control Area/Cred.Representative Group/Risk Category | 4 | KKBER | Credit control area | nvarchar | 4 | 0 | | |
TOPCredit Management |
49 | T024P | Credit Management: Credit Representatives | 3 | KKBER | Credit control area | nvarchar | 4 | 0 | | |
50 | T691F | Control of Automatic Credit Control | 2 | KKBER | Credit control area | nvarchar | 4 | 0 | | |
51 | T691G | Control of Automatic Credit Control: Description | 3 | KKBER | Credit control area | nvarchar | 4 | 0 | | |
52 | T691H | Document Value Class (Credit Management) | 2 | KKBER | Credit control area | nvarchar | 4 | 0 | | |
TOPCross-Application Components |
53 | BBSID | Accounting: Secondary index for customers | 135 | KKBER | Credit control area | nvarchar | 4 | 0 | | |
54 | VVBAK | Sales Document: Header Data | 62 | KKBER | Credit control area | nvarchar | 4 | 0 | | |
TOPCustomer Master |
55 | KNVV | Customer Master Sales Data | 63 | KKBER | Credit control area | nvarchar | 4 | 0 | | |
TOPData Collection |
56 | S066 | Open orders: credit management | 4 | KKBER | Credit control area | nvarchar | 4 | 0 | | |
57 | S067 | Open deliveries/billing documents (KM) | 4 | KKBER | Credit control area | nvarchar | 4 | 0 | | |
58 | VKMI | Log for Updating Open Credit Values (S066, S067) | 6 | KKBER | Credit control area | nvarchar | 4 | 0 | | |
TOPData Retention Tool |
59 | TXW_S_BSEG | Retrieve BSEG from archive | 93 | KKBER | Credit control area | nvarchar | 4 | 0 | | |
TOPFinancial Accounting |
60 | BSAD | Accounting: Secondary Index for Customers (Cleared Items) | 135 | KKBER | Credit control area | nvarchar | 4 | 0 | | |
61 | BSID | Accounting: Secondary Index for Customers | 135 | KKBER | Credit control area | nvarchar | 4 | 0 | | |
62 | BWFI_AEDA3 | BW FI: Log Table for Changed Credit Management Data | 4 | KKBER | Credit control area | nvarchar | 4 | 0 | | |
63 | T001 | Company Codes | 26 | KKBER | Credit control area | nvarchar | 4 | 0 | | |
64 | VBSEGD | Document Segment for Customer Document Parking | 102 | KKBER | Credit control area | nvarchar | 4 | 0 | | |
TOPFunds Management-Specific Postings |
65 | PSOSEGD | Document Segment: Recurring Request, Customer | 103 | KKBER | Credit control area | nvarchar | 4 | 0 | | |
TOPLocalization |
66 | J_3RFTAX_EXTRD | Tax Extract Detail Lines | 106 | KKBER | Credit control area | nvarchar | 4 | 0 | | |
67 | RFITEMAP_NO_ITEM | Item wise detail for the Vendor Transactions | 105 | KKBER | Credit control area | nvarchar | 4 | 0 | | |
68 | RFITEMAR_NO_ITEM | Item wise detail for the Customer Transactions | 105 | KKBER | Credit control area | nvarchar | 4 | 0 | | |
69 | RFITEMGL_NO_ITEM | Item wise detail for the GL Account Transactions | 105 | KKBER | Credit control area | nvarchar | 4 | 0 | | |
TOPLogistics - General |
70 | CMDET_S06667 | Individual Records for Updating External Credit Data | 20 | KKBER | Credit control area | nvarchar | 4 | 0 | | |
71 | WBHK | Trading Contract: Header Data | 73 | KKBER | Credit control area | nvarchar | 4 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
72 | /BEV1/RBVBAK | Sales Document: Header Data | 62 | KKBER | Credit control area | nvarchar | 4 | 0 | | |
73 | /BEV3/CH1030BSG2 | Document Segment CH Event Ledger Part2 | 29 | KKBER | Credit control area | nvarchar | 4 | 0 | | |
TOPSales |
74 | VAKCR | Sales Index: Orders in Credit Management | 2 | KKBER | Credit control area | nvarchar | 4 | 0 | | |
75 | VBAK | Sales Document: Header Data | 62 | KKBER | Credit control area | nvarchar | 4 | 0 | | |
TOPShipping |
76 | LIKP | SD Document: Delivery Header Data | 73 | KKBER | Credit control area | nvarchar | 4 | 0 | | |
77 | SHP_IDX_CRED | Outbound Deliveries in Credit Check: Blocked and Released | 3 | KKBER | Credit control area | nvarchar | 4 | 0 | | |
TOPSimulation |
78 | VSVBAK_CN | Version: Sales document: Header data | 63 | KKBER | Credit control area | nvarchar | 4 | 0 | | |