| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /1CADMC/00000464 | T151 | 5 | KDGRP | | nvarchar | 2 | 0 | | |
2 | /1CADMC/00000465 | T151T | 6 | KDGRP | | nvarchar | 2 | 0 | | |
3 | /1RA/0SD010MI | Items for Class SD01 - Raw Data | 69 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
4 | /1RA/0SD012MI | Items for Class SD01 - Processable | 53 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
5 | /1RA/0SD014MI | Items for Class SD01 - Processed | 53 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
6 | /BIC/B0000177000 | PSA for 2LIS_11_V_ITM T90CLNT090 Sls-Ship.Alloc.Item | 64 | KDGRP | | nvarchar | 2 | 0 | | |
7 | /BIC/B0000178000 | PSA for 2LIS_11_VAITM T90CLNT090 Sales Doc. Item | 122 | KDGRP | | nvarchar | 2 | 0 | | |
8 | /BIC/B0000179000 | PSA for 2LIS_11_VASCL T90CLNT090 Sales Doc. Schedule | 102 | KDGRP | | nvarchar | 2 | 0 | | |
9 | /BIC/B0000180000 | PSA for 2LIS_11_V_SCL T90CLNT090 Sls-Ship.Alloc.Sch. | 73 | KDGRP | | nvarchar | 2 | 0 | | |
10 | /BIC/B0000181000 | PSA for 2LIS_11_VAKON T90CLNT090 Sales Document Cond. | 67 | KDGRP | | nvarchar | 2 | 0 | | |
11 | /BIC/B0000182000 | PSA for 2LIS_12_VCHDR T90CLNT090 Delivery Header Data | 18 | KDGRP | | nvarchar | 2 | 0 | | |
12 | /BIC/B0000183000 | PSA for 2LIS_12_VCITM T90CLNT090 Delivery Item | 19 | KDGRP | | nvarchar | 2 | 0 | | |
13 | /BIC/B0000184000 | PSA for 2LIS_13_VDHDR T90CLNT090 Bill.Doc.Header Data | 19 | KDGRP | | nvarchar | 2 | 0 | | |
14 | /BIC/B0000185000 | PSA for 2LIS_13_VDITM T90CLNT090 Billing Doc. Item | 15 | KDGRP | | nvarchar | 2 | 0 | | |
15 | /BIC/B0000186000 | PSA for 2LIS_13_VDKON T90CLNT090 Billing Docu. Cond. | 15 | KDGRP | | nvarchar | 2 | 0 | | |
16 | /SMD/MD_____00YN | SID-Tabelle fuer Customer group | 3 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
17 | CE1PR22 | Périm. résultat IDES | 65 | KDGRP | Groupe de clients | nvarchar | 2 | 0 | | |
18 | CE2PR22 | Périm. résultat IDES | 49 | KDGRP | Groupe de clients | nvarchar | 2 | 0 | | |
19 | CE4PR22 | Périm. résultat IDES | 34 | KDGRP | Groupe de clients | nvarchar | 2 | 0 | | |
20 | CE4PR22_ACCT | Périm. résultat IDES | 35 | KDGRP | Groupe de clients | nvarchar | 2 | 0 | | |
21 | CE4PR22_FLAG | Périm. résultat IDES | 31 | KDGRP | Flag : caract. imputée manuellement ou via TKEZU | nvarchar | 1 | 0 | | |
22 | CE4PR22_KENC | Périm. résultat IDES | 33 | KDGRP | Groupe de clients | nvarchar | 2 | 0 | | |
23 | FSH_OS_SD | Order Type specific data for sales organisation/distribution | 14 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
24 | FSH_OS_STO | Document type customizing for STO's | 13 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
25 | FSH_SD_PERIODS | Condition Records For Season Determination in SD | 11 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
TOPAdvertising Management |
26 | JHAGA | IS-M/AM: Order-Publishing-Media Billing Dataset | 86 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
27 | JHAISZ | IS-M/AM: Assignment Table of Advertisers for OPM Order | 42 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
28 | JHFREV2 | IS-M/AM: Key Dates for Billing Document Revenue Recognition | 49 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
29 | JHFREV4 | IS-M/AM: Billing Document Revenue Recognition Key Date Qties | 46 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
30 | JHTFP | IS-M/AM: Billing/Settlement Documents - Item | 6 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
31 | JJTBEPART | IS-M/AM: Booking Unit Elements (AI) | 13 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
TOPBasic Functions |
32 | KNKK | Customer master credit management: Control area data | 27 | KDGRP | Customer Group | nvarchar | 8 | 0 | | |
TOPBilling |
33 | A145 | Sales Deal - Customer/Material | 7 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
34 | A146 | Customer Hierarchy | 9 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
35 | A147 | Customer Hierarchy (Sales Deal) | 9 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
36 | VBRK | Billing Document: Header Data | 17 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
TOPConditions |
37 | KOTG601 | DSD-Cust.group/Matl Group | 4 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
TOPCross-Application Components |
38 | VVBKD | Sales Document: Business Data | 5 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
TOPCustomer Master |
39 | KNVV | Customer Master Sales Data | 13 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
TOPData Collection |
40 | CF703 | IDES Profitability | 12 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
41 | CF720 | Top EIS Aspect | 20 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
42 | S008 | Communications Table SD -> CO/Projects | 50 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
43 | S123 | Customer / material group | 70 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
44 | S124 | Customer / material | 70 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
45 | S140 | Product Allocations | 11 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
46 | S140E | S140 - Structural Information | 6 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
47 | S260 | SD - Sales order | 62 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
48 | S260BIW1 | SD - Sales order | 62 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
49 | S260BIW2 | SD - Sales order | 62 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
50 | S261 | SD - Delivery note | 20 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
51 | S261BIW1 | SD - Delivery note | 20 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
52 | S261BIW2 | SD - Delivery note | 20 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
53 | S262 | SD - Billing document | 24 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
54 | S262BIW1 | SD - Billing document | 24 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
55 | S262BIW2 | SD - Billing document | 24 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
56 | S263 | SD - Sales order/delivery note | 52 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
57 | S263BIW1 | SD - Sales order/delivery note | 52 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
58 | S263BIW2 | SD - Sales order/delivery note | 52 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
59 | S264 | SD- Offer | 64 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
60 | S264BIW1 | S264BIW1 * SD - Quotation | 64 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
61 | S264BIW2 | S264BIW2 * SD - Quotation | 64 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
TOPExcise Duty |
62 | /BEV2/ED911 | Excise Duty Customer Groups | 2 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
63 | /BEV2/ED963 | Assignment Customer Groups to Special Partner Types | 2 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
TOPHandheld Connectivity |
64 | /DSD/PR_ASGN | MDSD Promotions - Promotion Assignment | 9 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
65 | /DSD/PR_CUFC | MDSD Promotions - Field Selection | 11 | KDGRP | DSD Deal Conditions - Customer Group Active Flag | nvarchar | 1 | 0 | | |
TOPMarketing, Accounting and Pricing |
66 | A420 | SalesOrg/DistCh/CustGrp/ProdHier/PricDRC | 6 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
67 | A421 | SalesOrg/DistCh/CustGrp/Plant/ProdHier/PricDRC | 6 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
68 | A428 | SalesOrg/DistChann/CustGrp/DRCMetrInd/ProdHier | 6 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
TOPMaterial Maintenance |
69 | T151 | Customers: Customer Groups | 2 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
70 | T151T | Customers: Customer groups: Texts | 3 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
TOPMedia Product Sales and Distribution |
71 | JKSDCONTRACTCHAR | Additional Fields for Sales Quantity Planning | 7 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
TOPMedia Sales and Distribution |
72 | /NAM/TJKAPPL_CMP | Application Access for Complaint Charges | 7 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
73 | /NAM/TJKAPPL_MON | Application Access for Determination of Monitoring | 10 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
74 | /NAM/TJKAPPL_OFR | Application Access for Renewal Offers | 10 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
75 | /NAM/TJKOFF_DATA | Renewal Offer Code Data | 7 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
TOPNon-Ferrous Metal enhancements |
76 | /NFM/TDEF_DIFF | Different Rate Determination | 4 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
TOPPeriodical Sales and Distribution |
77 | JFRK | IS-M/SD: Billing - Header Data | 15 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
78 | JKAPPR | Ad Pre-Print Order: Item Data | 8 | KDGRP | Customer group for which insertions are made | nvarchar | 2 | 0 | | |
79 | JKKD | Sales Order: Business Data | 5 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
80 | JKWWWTEMP_ORDER | IS-M/SD: WWW Temporary Table for Order Data from Internet | 15 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
81 | JVTNCT4 | IS-M/SD: Tab.4 for Netchange (ChNo.Planng View)-see JKVDIS | 31 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
82 | TJI05 | IS-M/SD: Basic Audit Report Category Default: Periodical SD | 4 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
83 | TJI06 | IS-M/SD: Basic Audit Report Category Default - Media Product | 5 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
84 | TJKWW | IS-M/SD: Control Table for Creating Trial Subscriptions | 10 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
85 | TJKWWW_FIX | IS-M/SD: WWW, Combinations of Fixed Order Values | 15 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
TOPProfitability Analysis |
86 | CE18500 | | 59 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
87 | CE1BGIS | Ergebnisbereich für | 59 | KDGRP | Kundengruppe | nvarchar | 2 | 0 | | |
88 | CE1IDEA | Op. Concern BR World | 65 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
89 | CE1IDEB | Ergebnisbereich IDES | 57 | KDGRP | Kundengruppe | nvarchar | 2 | 0 | | |
90 | CE1IDES | Ergebnisbereich IDES | 65 | KDGRP | Kundengruppe | nvarchar | 2 | 0 | | |
91 | CE1INT1 | Ergebnisbereich IDES | 65 | KDGRP | Kundengruppe | nvarchar | 2 | 0 | | |
92 | CE1OC01 | Bike International | 64 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
93 | CE1S001 | Sample operating concern | 42 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
94 | CE1S_GO | Quickstart Template | 59 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
95 | CE28500 | | 43 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
96 | CE2BGIS | Ergebnisbereich für | 43 | KDGRP | Kundengruppe | nvarchar | 2 | 0 | | |
97 | CE2IDEA | Op. Concern BR World | 49 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
98 | CE2IDEB | Ergebnisbereich IDES | 41 | KDGRP | Kundengruppe | nvarchar | 2 | 0 | | |
99 | CE2IDES | Ergebnisbereich IDES | 49 | KDGRP | Kundengruppe | nvarchar | 2 | 0 | | |
100 | CE2INT1 | Ergebnisbereich IDES | 49 | KDGRP | Kundengruppe | nvarchar | 2 | 0 | | |
101 | CE2OC01 | Bike International | 48 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
102 | CE2S001 | Sample operating concern | 32 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
103 | CE2S_GO | Quickstart Template | 43 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
104 | CE48500 | | 28 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
105 | CE48500_ACCT | | 29 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
106 | CE48500_FLAG | | 25 | KDGRP | Flag: Characteristic Assigned Manually or Using TKEZU | nvarchar | 1 | 0 | | |
107 | CE48500_KENC | | 27 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
108 | CE4BGIS | Ergebnisbereich für | 28 | KDGRP | Kundengruppe | nvarchar | 2 | 0 | | |
109 | CE4BGIS_ACCT | Ergebnisbereich für | 29 | KDGRP | Kundengruppe | nvarchar | 2 | 0 | | |
110 | CE4BGIS_FLAG | Ergebnisbereich für | 25 | KDGRP | Flag: Merkmal manuell oder über TKEZU kontiert | nvarchar | 1 | 0 | | |
111 | CE4BGIS_KENC | Ergebnisbereich für | 27 | KDGRP | Kundengruppe | nvarchar | 2 | 0 | | |
112 | CE4IDEA | Op. Concern BR World | 34 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
113 | CE4IDEA_ACCT | Op. Concern BR World | 35 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
114 | CE4IDEA_FLAG | Op. Concern BR World | 31 | KDGRP | Flag: Characteristic Assigned Manually or Using TKEZU | nvarchar | 1 | 0 | | |
115 | CE4IDEA_KENC | Op. Concern BR World | 33 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
116 | CE4IDEB | Ergebnisbereich IDES | 26 | KDGRP | Kundengruppe | nvarchar | 2 | 0 | | |
117 | CE4IDEB_ACCT | Ergebnisbereich IDES | 27 | KDGRP | Kundengruppe | nvarchar | 2 | 0 | | |
118 | CE4IDEB_FLAG | Ergebnisbereich IDES Banking | 23 | KDGRP | Flag: Merkmal manuell oder über TKEZU kontiert | nvarchar | 1 | 0 | | |
119 | CE4IDEB_KENC | Ergebnisbereich IDES | 25 | KDGRP | Kundengruppe | nvarchar | 2 | 0 | | |
120 | CE4IDES | Ergebnisbereich IDES | 34 | KDGRP | Kundengruppe | nvarchar | 2 | 0 | | |
121 | CE4IDES_ACCT | Ergebnisbereich IDES | 35 | KDGRP | Kundengruppe | nvarchar | 2 | 0 | | |
122 | CE4IDES_FLAG | Ergebnisbereich IDES | 31 | KDGRP | Flag: Merkmal manuell oder über TKEZU kontiert | nvarchar | 1 | 0 | | |
123 | CE4IDES_KENC | Ergebnisbereich IDES | 33 | KDGRP | Kundengruppe | nvarchar | 2 | 0 | | |
124 | CE4INT1 | Ergebnisbereich IDES | 34 | KDGRP | Kundengruppe | nvarchar | 2 | 0 | | |
125 | CE4INT1_ACCT | Ergebnisbereich IDES | 35 | KDGRP | Kundengruppe | nvarchar | 2 | 0 | | |
126 | CE4INT1_FLAG | Ergebnisbereich IDES | 31 | KDGRP | Flag: Merkmal manuell oder über TKEZU kontiert | nvarchar | 1 | 0 | | |
127 | CE4INT1_KENC | Ergebnisbereich IDES | 33 | KDGRP | Kundengruppe | nvarchar | 2 | 0 | | |
128 | CE4OC01 | Bike International | 33 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
129 | CE4OC01_ACCT | Bike International | 34 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
130 | CE4OC01_KENC | Bike International | 32 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
131 | CE4S001 | Sample operating concern | 19 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
132 | CE4S001_ACCT | Sample operating con | 27 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
133 | CE4S001_FLAG | Sample Operating Concern 1 | 23 | KDGRP | Flag: Characteristic Assigned Manually or Using TKEZU | nvarchar | 1 | 0 | | |
134 | CE4S001_KENC | Sample operating con | 24 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
135 | CE4S_GO | Quickstart Template | 28 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
136 | CE4S_GO_ACCT | Quickstart Template | 29 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
137 | CE4S_GO_FLAG | Quickstart Template | 25 | KDGRP | Flag: Characteristic Assigned Manually or Using TKEZU | nvarchar | 1 | 0 | | |
138 | CE4S_GO_KENC | Quickstart Template | 27 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
TOPSales |
139 | VBKD | Sales Document: Business Data | 5 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
TOPSales and Distribution SD enhancements |
140 | /SAPMP/SD_LEIHG | Returnable Packaging Settlement | 22 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
141 | /SAPMP/SD_LGFK | Free-of-Charge Period for Customer Group | 4 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
TOPShipping |
142 | LIKP | SD Document: Delivery Header Data | 32 | KDGRP | Customer group | nvarchar | 2 | 0 | | |
TOPSimulation |
143 | VSVBKD_CN | Version: Sales document - commercial data | 6 | KDGRP | Customer group | nvarchar | 2 | 0 | | |