| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | KONV | Conditions (Transaction Data) | 30 | SAKN1 | G/L Account Number | nvarchar | 10 | 0 | | |
TOPAdvertising Management |
2 | C290 | IS-M: PURORG/ACCKEY | 7 | SAKN1 | G/L Account Number | nvarchar | 10 | 0 | | |
3 | C291 | IS-M: PCORG/ACTASSGRP/ACCTKEY | 8 | SAKN1 | G/L Account Number | nvarchar | 10 | 0 | | |
4 | C300 | IS-M/AM: Cust Grp/Service Type/Account Key | 8 | SAKN1 | G/L Account Number | nvarchar | 10 | 0 | | |
5 | C301 | IS-M: Service Type/Account Key | 7 | SAKN1 | G/L Account Number | nvarchar | 10 | 0 | | |
6 | C302 | IS-PAM: VKORG/GRPDEB/KTOSCHL | 8 | SAKN1 | G/L Account Number | nvarchar | 10 | 0 | | |
7 | C303 | IS-M: Account Key Only | 6 | SAKN1 | G/L Account Number | nvarchar | 10 | 0 | | |
TOPConditions |
8 | C000 | Condition Table for Acct.Determination: $ | 6 | SAKN1 | G/L Account Number | nvarchar | 10 | 0 | | |
9 | C001 | Cust.Grp/MaterialGrp/AcctKey | 9 | SAKN1 | G/L Account Number | nvarchar | 10 | 0 | | |
10 | C002 | Cust.Grp/Account Key | 8 | SAKN1 | G/L Account Number | nvarchar | 10 | 0 | | |
11 | C003 | Material Grp/Acct Key | 8 | SAKN1 | G/L Account Number | nvarchar | 10 | 0 | | |
12 | C004 | General | 6 | SAKN1 | G/L Account Number | nvarchar | 10 | 0 | | |
13 | C005 | Acct Key | 7 | SAKN1 | G/L Account Number | nvarchar | 10 | 0 | | |
14 | C006 | SlsOrg/Card cat. | 7 | SAKN1 | G/L Account Number | nvarchar | 10 | 0 | | |
15 | C008 | SlsOrg/Dist.chan. | 7 | SAKN1 | G/L Account Number | nvarchar | 10 | 0 | | |
16 | C009 | SlsOrg/Dist.chan./Div. | 8 | SAKN1 | G/L Account Number | nvarchar | 10 | 0 | | |
17 | C502 | Chart of Accounts/SlsOrg/DChannel/AcctGroup Cust/Account Key | 9 | SAKN1 | G/L Account Number | nvarchar | 10 | 0 | | |
TOPContract Handling |
18 | C402 | Item cat. | 6 | SAKN1 | G/L Account Number | nvarchar | 10 | 0 | | |
TOPCross-Application Components |
19 | VKONV | Conditions (Transaction Data) | 30 | SAKN1 | G/L Account Number | nvarchar | 10 | 0 | | |
TOPData Collection |
20 | S008 | Communications Table SD -> CO/Projects | 95 | SAKN1 | G/L Account Number | nvarchar | 10 | 0 | | |
TOPExchanges |
21 | OIANF | Fee Condition Records | 30 | SAKN1 | G/L Account Number | nvarchar | 10 | 0 | | |
TOPIndustry Solution Engineering Construction |
22 | C495 | Document Category/Condition Type/Own-External/Account Key | 9 | SAKN1 | G/L Account Number | nvarchar | 10 | 0 | | |
23 | C496 | Condition Type/Account Key | 7 | SAKN1 | G/L Account Number | nvarchar | 10 | 0 | | |
24 | C497 | Document Category/Condition Type/Account Key | 8 | SAKN1 | G/L Account Number | nvarchar | 10 | 0 | | |
25 | C498 | Doc. Category/Condition Type/Own-Ext./Actvty Type/Acc. Key | 10 | SAKN1 | G/L Account Number | nvarchar | 10 | 0 | | |
26 | C499 | Doc. Cat./Cond. Type/Own-Ext./Acty Type/Ctlg Group/Acc. Key | 12 | SAKN1 | G/L Account Number | nvarchar | 10 | 0 | | |
TOPIntegration |
27 | FKK_KONV_SHORT | Price Conditions for SD Billing Document - Extracts | 24 | SAKN1 | G/L Account Number | nvarchar | 10 | 0 | | |
TOPInterest |
28 | TZIN2 | Interest Document:Segment Int.Indicator & Valuation Category | 7 | SAKN1 | G/L Account Number | nvarchar | 10 | 0 | | |
TOPJoint Venture und Production Sharing Accounting |
29 | JVKONV | IS-Oil / Joint Venture / Data table for CRP pricing data | 30 | SAKN1 | G/L Account Number | nvarchar | 10 | 0 | | |
TOPMarketing, Accounting and Pricing |
30 | OIC_KONV | Conditions (Procedure Data) | 30 | SAKN1 | G/L Account Number | nvarchar | 10 | 0 | | |
31 | OIC_OIANF | Fee Condition Records | 30 | SAKN1 | G/L Account Number | nvarchar | 10 | 0 | | |
TOPPatient Accounting |
32 | C400 | IS-H: Account key/case type/private/ext.physician | 9 | SAKN1 | G/L Account Number | nvarchar | 10 | 0 | | |
33 | C401 | IS-H: Acct key/case type/srv.catalog/srv./private/ext.phys. | 12 | SAKN1 | G/L Account Number | nvarchar | 10 | 0 | | |
34 | NVKONV | IS-H: Conditions | 14 | SAKN1 | G/L Account Number | nvarchar | 10 | 0 | | |
TOPPeriodical Sales and Distribution |
35 | C450 | IS-M/SD: SOrg./Publ./Edit./CGrp./AKey/BFreq. | 11 | SAKN1 | G/L Account Number | nvarchar | 10 | 0 | | |
36 | C451 | IS-M/SD: SOrg./Publ./CAccGrp./AccKey/BFreq. | 10 | SAKN1 | G/L Account Number | nvarchar | 10 | 0 | | |
37 | C452 | IS-M/SD: SOrg./Publ./AKey/BFreq. | 9 | SAKN1 | G/L Account Number | nvarchar | 10 | 0 | | |
38 | C453 | IS-M/SD: SOrg./AKey/BFreq. | 8 | SAKN1 | G/L Account Number | nvarchar | 10 | 0 | | |
39 | C460 | IS-M/SD: POrg./Publ./Edit./SC/AKey | 10 | SAKN1 | G/L Account Number | nvarchar | 10 | 0 | | |
40 | C461 | IS-M/SD: POrg./Publ./Edit./AKey | 9 | SAKN1 | G/L Account Number | nvarchar | 10 | 0 | | |
41 | C462 | IS-M/SD: POrg./Publ./AKey | 8 | SAKN1 | G/L Account Number | nvarchar | 10 | 0 | | |
42 | C463 | IS-M/SD: POrg./AKey | 7 | SAKN1 | G/L Account Number | nvarchar | 10 | 0 | | |
43 | C464 | IS-M/SD: POrg. | 6 | SAKN1 | G/L Account Number | nvarchar | 10 | 0 | | |
44 | C465 | IS-M/SD: SC/Publ./Edit./EEAcGrp./AKey | 10 | SAKN1 | G/L Account Number | nvarchar | 10 | 0 | | |
45 | C466 | IS-M/SD: SC/Publ./Edit./AKey | 9 | SAKN1 | G/L Account Number | nvarchar | 10 | 0 | | |
46 | C467 | IS-M/SD: SC/Publ./AKey | 8 | SAKN1 | G/L Account Number | nvarchar | 10 | 0 | | |
47 | C468 | IS-M/SD: SC/AKey | 7 | SAKN1 | G/L Account Number | nvarchar | 10 | 0 | | |
48 | C469 | IS-M/SD: SC | 6 | SAKN1 | G/L Account Number | nvarchar | 10 | 0 | | |
49 | JFXTJL26DL | IS-M: Backup Transfer Internal Table XTJL26 | 5 | SAKN1 | Interim Account for Revenue Accrual | nvarchar | 10 | 0 | | |
50 | JKONV | IS-M/SD: Conditions (Transaction Data) | 30 | SAKN1 | G/L Account Number | nvarchar | 10 | 0 | | |
51 | TJF20 | Convert Bank Clearing Account to Interim Account (Bank Rtns) | 3 | SAKN1 | Bank account/bank clearing account (G/L account) | nvarchar | 10 | 0 | | |
52 | TJF30 | IS-M/SD: Conversion of Clearing Acct to Real G/L Acct (Run) | 4 | SAKN1 | Interim Account for Revenue Accrual | nvarchar | 10 | 0 | | |
53 | TJL26 | IS-M/SD: Conversion of Clearing Account - Real G/L Account | 3 | SAKN1 | Interim Account for Revenue Accrual | nvarchar | 10 | 0 | | |
TOPPOS Interface |
54 | C007 | Vendor | 6 | SAKN1 | G/L Account Number | nvarchar | 10 | 0 | | |
TOPService Station Retailing |
55 | C011 | Company Code/Payment card type/Splitting result | 8 | SAKN1 | G/L Account Number | nvarchar | 10 | 0 | | |
56 | C012 | Sales Org / Card type / split result | 8 | SAKN1 | G/L Account Number | nvarchar | 10 | 0 | | |
57 | C013 | Company Code / card type | 7 | SAKN1 | G/L Account Number | nvarchar | 10 | 0 | | |
58 | C014 | Card Type | 6 | SAKN1 | G/L Account Number | nvarchar | 10 | 0 | | |
TOPTariffs, Duties and Permits |
59 | C410 | Chart of accts / Account key - acct assign for ED rev | 6 | SAKN1 | G/L Account Number | nvarchar | 10 | 0 | | |