| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /1CADMC/00000458 | T016 | 5 | BRSCH | | nvarchar | 4 | 0 | | |
2 | /1CADMC/00000459 | T016T | 6 | BRSCH | | nvarchar | 4 | 0 | | |
3 | /1RA/0SD010MI | Items for Class SD01 - Raw Data | 57 | BRSCH | Industry key | nvarchar | 4 | 0 | | |
4 | CE1PR22 | Périm. résultat IDES | 68 | BRSCH | Code branche | nvarchar | 4 | 0 | | |
5 | CE2PR22 | Périm. résultat IDES | 52 | BRSCH | Code branche | nvarchar | 4 | 0 | | |
6 | CE4PR22 | Périm. résultat IDES | 37 | BRSCH | Code branche | nvarchar | 4 | 0 | | |
7 | CE4PR22_ACCT | Périm. résultat IDES | 38 | BRSCH | Code branche | nvarchar | 4 | 0 | | |
8 | CE4PR22_FLAG | Périm. résultat IDES | 34 | BRSCH | Flag : caract. imputée manuellement ou via TKEZU | nvarchar | 1 | 0 | | |
9 | CE4PR22_KENC | Périm. résultat IDES | 36 | BRSCH | Code branche | nvarchar | 4 | 0 | | |
10 | T016 | Industries | 2 | BRSCH | Industry key | nvarchar | 4 | 0 | | |
11 | T016T | Industry Names | 3 | BRSCH | Industry key | nvarchar | 4 | 0 | | |
12 | T7SA40 | Saudization Color ranges as per Line of Business | 5 | BRSCH | Industry key | nvarchar | 4 | 0 | | |
13 | TJ016U | Industry Sectors | 2 | BRSCH | Industry key | nvarchar | 4 | 0 | | |
14 | TZD0A | Darwin: Customer default values per trans. type for KNA1 | 10 | BRSCH | Industry key | nvarchar | 4 | 0 | | |
TOPBusiness Partner |
15 | TIVBPVENDORGEN | Vendor Preassignment (General Data) | 8 | BRSCH | Industry key | nvarchar | 4 | 0 | | |
16 | TP17U | Business Partner: Convert Industries | 2 | BRSCH | Industry key | nvarchar | 4 | 0 | | |
TOPBusiness Partner Enhancements for Financial Services |
17 | TP038M1 | Mapping Branchen SAP-GP --> TR GP / Debitor + Kreditor | 4 | BRSCH | ???? | nvarchar | 4 | 0 | | |
18 | TP038M2 | Mapping Branchen TR GP / Debitor / Kreditor --> SAP GP | 2 | BRSCH | ???? | nvarchar | 4 | 0 | | |
TOPCross-Application Components |
19 | BC490KKNA1 | General data in customer master | 25 | BRSCH | Industry key | nvarchar | 4 | 0 | | |
20 | KKNA1 | General Data in Customer Master | 25 | BRSCH | Industry key | nvarchar | 4 | 0 | | |
21 | SKNA1 | Customer Master table for BC417 Course | 25 | BRSCH | Industry key | nvarchar | 4 | 0 | | |
TOPCustomer Master |
22 | KNA1 | General Data in Customer Master | 25 | BRSCH | Industry key | nvarchar | 4 | 0 | | |
TOPData Collection |
23 | CF703 | IDES Profitability | 13 | BRSCH | Industry key | nvarchar | 4 | 0 | | |
24 | S018 | SIS: Address list for sales promotion | 13 | BRSCH | Industry key | nvarchar | 4 | 0 | | |
25 | S018E | S018 - Structural Information | 8 | BRSCH | Industry key | nvarchar | 4 | 0 | | |
TOPFinancial Accounting |
26 | LFA1 | Vendor Master (General Section) | 25 | BRSCH | Industry key | nvarchar | 4 | 0 | | |
TOPFinancial Services Localization |
27 | /GSINS/REU_BRSCH | Insurance ETL Acc Group Customizing Table | 3 | BRSCH | Industry key | nvarchar | 4 | 0 | | |
TOPInformation System |
28 | DKKOS | Balance Audit Trail | 34 | BRSCH | Industry key | nvarchar | 4 | 0 | | |
29 | DKOKS | Open Item Account Balance Audit Trail Master Record | 37 | BRSCH | Industry key | nvarchar | 4 | 0 | | |
TOPJoint Venture und Production Sharing Accounting |
30 | T8PSA_BRSCH | Arms/Non-arms length | 2 | BRSCH | Industry key | nvarchar | 4 | 0 | | |
TOPLocalization |
31 | A343 | BR: Substituiçao Tributária from SD | 12 | BRSCH | Branchenschlüssel | nvarchar | 4 | 0 | | |
32 | LFB1_KR | Vendor Master Enhancement for Korea | 4 | BRSCH | Industry key | nvarchar | 4 | 0 | | |
33 | T042E_KR | Korea : BoE Due Date Determination by Industry | 3 | BRSCH | Industry key | nvarchar | 4 | 0 | | |
TOPMaster Data |
34 | JGTGPNR | IS-M: Central Business Partner Table | 17 | BRSCH | Industry key | nvarchar | 4 | 0 | | |
TOPProfitability Analysis |
35 | CE18500 | | 57 | BRSCH | Industry key | nvarchar | 4 | 0 | | |
36 | CE1BGIS | Ergebnisbereich für | 57 | BRSCH | Branchenschlüssel | nvarchar | 4 | 0 | | |
37 | CE1IDEA | Op. Concern BR World | 68 | BRSCH | Industry key | nvarchar | 4 | 0 | | |
38 | CE1IDEB | Ergebnisbereich IDES | 58 | BRSCH | Branchenschlüssel | nvarchar | 4 | 0 | | |
39 | CE1IDES | Ergebnisbereich IDES | 68 | BRSCH | Branchenschlüssel | nvarchar | 4 | 0 | | |
40 | CE1INT1 | Ergebnisbereich IDES | 68 | BRSCH | Branchenschlüssel | nvarchar | 4 | 0 | | |
41 | CE1OC01 | Bike International | 58 | BRSCH | Industry key | nvarchar | 4 | 0 | | |
42 | CE1S001 | Sample operating concern | 45 | BRSCH | Industry key | nvarchar | 4 | 0 | | |
43 | CE1S300 | Operating Concern IDES | 57 | BRSCH | Industry key | nvarchar | 4 | 0 | | |
44 | CE1S_GO | Quickstart Template | 57 | BRSCH | Industry key | nvarchar | 4 | 0 | | |
45 | CE28500 | | 41 | BRSCH | Industry key | nvarchar | 4 | 0 | | |
46 | CE2BGIS | Ergebnisbereich für | 41 | BRSCH | Branchenschlüssel | nvarchar | 4 | 0 | | |
47 | CE2IDEA | Op. Concern BR World | 52 | BRSCH | Industry key | nvarchar | 4 | 0 | | |
48 | CE2IDEB | Ergebnisbereich IDES | 42 | BRSCH | Branchenschlüssel | nvarchar | 4 | 0 | | |
49 | CE2IDES | Ergebnisbereich IDES | 52 | BRSCH | Branchenschlüssel | nvarchar | 4 | 0 | | |
50 | CE2INT1 | Ergebnisbereich IDES | 52 | BRSCH | Branchenschlüssel | nvarchar | 4 | 0 | | |
51 | CE2OC01 | Bike International | 42 | BRSCH | Industry key | nvarchar | 4 | 0 | | |
52 | CE2S001 | Sample operating concern | 35 | BRSCH | Industry key | nvarchar | 4 | 0 | | |
53 | CE2S300 | Operating Concern IDES | 41 | BRSCH | Industry key | nvarchar | 4 | 0 | | |
54 | CE2S_GO | Quickstart Template | 41 | BRSCH | Industry key | nvarchar | 4 | 0 | | |
55 | CE48500 | | 26 | BRSCH | Industry key | nvarchar | 4 | 0 | | |
56 | CE48500_ACCT | | 27 | BRSCH | Industry key | nvarchar | 4 | 0 | | |
57 | CE48500_FLAG | | 23 | BRSCH | Flag: Characteristic Assigned Manually or Using TKEZU | nvarchar | 1 | 0 | | |
58 | CE48500_KENC | | 25 | BRSCH | Industry key | nvarchar | 4 | 0 | | |
59 | CE4BGIS | Ergebnisbereich für | 26 | BRSCH | Branchenschlüssel | nvarchar | 4 | 0 | | |
60 | CE4BGIS_ACCT | Ergebnisbereich für | 27 | BRSCH | Branchenschlüssel | nvarchar | 4 | 0 | | |
61 | CE4BGIS_FLAG | Ergebnisbereich für | 23 | BRSCH | Flag: Merkmal manuell oder über TKEZU kontiert | nvarchar | 1 | 0 | | |
62 | CE4BGIS_KENC | Ergebnisbereich für | 25 | BRSCH | Branchenschlüssel | nvarchar | 4 | 0 | | |
63 | CE4IDEA | Op. Concern BR World | 37 | BRSCH | Industry key | nvarchar | 4 | 0 | | |
64 | CE4IDEA_ACCT | Op. Concern BR World | 38 | BRSCH | Industry key | nvarchar | 4 | 0 | | |
65 | CE4IDEA_FLAG | Op. Concern BR World | 34 | BRSCH | Flag: Characteristic Assigned Manually or Using TKEZU | nvarchar | 1 | 0 | | |
66 | CE4IDEA_KENC | Op. Concern BR World | 36 | BRSCH | Industry key | nvarchar | 4 | 0 | | |
67 | CE4IDEB | Ergebnisbereich IDES | 27 | BRSCH | Branchenschlüssel | nvarchar | 4 | 0 | | |
68 | CE4IDEB_ACCT | Ergebnisbereich IDES | 28 | BRSCH | Branchenschlüssel | nvarchar | 4 | 0 | | |
69 | CE4IDEB_FLAG | Ergebnisbereich IDES Banking | 24 | BRSCH | Flag: Merkmal manuell oder über TKEZU kontiert | nvarchar | 1 | 0 | | |
70 | CE4IDEB_KENC | Ergebnisbereich IDES | 26 | BRSCH | Branchenschlüssel | nvarchar | 4 | 0 | | |
71 | CE4IDES | Ergebnisbereich IDES | 37 | BRSCH | Branchenschlüssel | nvarchar | 4 | 0 | | |
72 | CE4IDES_ACCT | Ergebnisbereich IDES | 38 | BRSCH | Branchenschlüssel | nvarchar | 4 | 0 | | |
73 | CE4IDES_FLAG | Ergebnisbereich IDES | 34 | BRSCH | Flag: Merkmal manuell oder über TKEZU kontiert | nvarchar | 1 | 0 | | |
74 | CE4IDES_KENC | Ergebnisbereich IDES | 36 | BRSCH | Branchenschlüssel | nvarchar | 4 | 0 | | |
75 | CE4INT1 | Ergebnisbereich IDES | 37 | BRSCH | Branchenschlüssel | nvarchar | 4 | 0 | | |
76 | CE4INT1_ACCT | Ergebnisbereich IDES | 38 | BRSCH | Branchenschlüssel | nvarchar | 4 | 0 | | |
77 | CE4INT1_FLAG | Ergebnisbereich IDES | 34 | BRSCH | Flag: Merkmal manuell oder über TKEZU kontiert | nvarchar | 1 | 0 | | |
78 | CE4INT1_KENC | Ergebnisbereich IDES | 36 | BRSCH | Branchenschlüssel | nvarchar | 4 | 0 | | |
79 | CE4OC01 | Bike International | 27 | BRSCH | Industry key | nvarchar | 4 | 0 | | |
80 | CE4OC01_ACCT | Bike International | 28 | BRSCH | Industry key | nvarchar | 4 | 0 | | |
81 | CE4OC01_KENC | Bike International | 26 | BRSCH | Industry key | nvarchar | 4 | 0 | | |
82 | CE4S001 | Sample operating concern | 22 | BRSCH | Industry key | nvarchar | 4 | 0 | | |
83 | CE4S001_ACCT | Sample operating con | 30 | BRSCH | Industry key | nvarchar | 4 | 0 | | |
84 | CE4S001_FLAG | Sample Operating Concern 1 | 26 | BRSCH | Flag: Characteristic Assigned Manually or Using TKEZU | nvarchar | 1 | 0 | | |
85 | CE4S001_KENC | Sample operating con | 27 | BRSCH | Industry key | nvarchar | 4 | 0 | | |
86 | CE4S300 | Operating Concern IDES | 26 | BRSCH | Industry key | nvarchar | 4 | 0 | | |
87 | CE4S300_ACCT | Operating Concern IDES | 27 | BRSCH | Industry key | nvarchar | 4 | 0 | | |
88 | CE4S300_FLAG | Ergebnisbereich IDES Serv.Prov | 23 | BRSCH | Flag: Merkmal manuell oder über TKEZU kontiert | nvarchar | 1 | 0 | | |
89 | CE4S300_KENC | Operating Concern IDES | 25 | BRSCH | Industry key | nvarchar | 4 | 0 | | |
90 | CE4S_GO | Quickstart Template | 26 | BRSCH | Industry key | nvarchar | 4 | 0 | | |
91 | CE4S_GO_ACCT | Quickstart Template | 27 | BRSCH | Industry key | nvarchar | 4 | 0 | | |
92 | CE4S_GO_FLAG | Quickstart Template | 23 | BRSCH | Flag: Characteristic Assigned Manually or Using TKEZU | nvarchar | 1 | 0 | | |
93 | CE4S_GO_KENC | Quickstart Template | 25 | BRSCH | Industry key | nvarchar | 4 | 0 | | |
TOPProfitability Analysis Basic Functions |
94 | K810005 | Verdichtungsebene KT: 800 KE 01 CE1IDEA 000313 | 3 | BRSCH | Branchenschlüssel | nvarchar | 4 | 0 | | |
TOPReal Estate Management |
95 | VIMI04 | Old. replaced in 3.0 with VIMIMV | 19 | BRSCH | Industry key | nvarchar | 4 | 0 | | |
TOPRecycling Administration Core Functions |
96 | J_7LC32 | REA Data Filters: Customer Industry Key | 3 | BRSCH | Industry key | nvarchar | 4 | 0 | | |
TOPSales Promotions |
97 | SADLSTRECB | Dynamic Part of Address List (Record Body) | 58 | BRSCH | Industry key | nvarchar | 4 | 0 | | |
TOPTreasury |
98 | VZKNA1 | Collector for batch input KNA1 from RF-VV | 7 | BRSCH | Industry key | nvarchar | 4 | 0 | | |