| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | J_1I_EXIM_ACCKEY | EXIM: Account Key | 3 | KVSL1 | Account key | nvarchar | 3 | 0 | | |
2 | KONV | Conditions (Transaction Data) | 29 | KVSL1 | Account key | nvarchar | 3 | 0 | | |
3 | T687 | Account Determination: Account Key | 3 | KVSL1 | Account key | nvarchar | 3 | 0 | | |
4 | T687T | Account Determination: Account Key Texts | 4 | KVSL1 | Account key | nvarchar | 3 | 0 | | |
TOPAdvertising Management |
5 | C290 | IS-M: PURORG/ACCKEY | 6 | KVSL1 | Account key | nvarchar | 3 | 0 | | |
6 | C291 | IS-M: PCORG/ACTASSGRP/ACCTKEY | 7 | KVSL1 | Account key | nvarchar | 3 | 0 | | |
7 | C300 | IS-M/AM: Cust Grp/Service Type/Account Key | 7 | KVSL1 | Account key | nvarchar | 3 | 0 | | |
8 | C301 | IS-M: Service Type/Account Key | 6 | KVSL1 | Account key | nvarchar | 3 | 0 | | |
9 | C302 | IS-PAM: VKORG/GRPDEB/KTOSCHL | 7 | KVSL1 | Account key | nvarchar | 3 | 0 | | |
10 | C303 | IS-M: Account Key Only | 5 | KVSL1 | Account key | nvarchar | 3 | 0 | | |
TOPConditions |
11 | C001 | Cust.Grp/MaterialGrp/AcctKey | 8 | KVSL1 | Account key | nvarchar | 3 | 0 | | |
12 | C002 | Cust.Grp/Account Key | 7 | KVSL1 | Account key | nvarchar | 3 | 0 | | |
13 | C003 | Material Grp/Acct Key | 7 | KVSL1 | Account key | nvarchar | 3 | 0 | | |
14 | C005 | Acct Key | 6 | KVSL1 | Account key | nvarchar | 3 | 0 | | |
15 | C502 | Chart of Accounts/SlsOrg/DChannel/AcctGroup Cust/Account Key | 8 | KVSL1 | Account key | nvarchar | 3 | 0 | | |
16 | KOND | Conditions (Data) | 57 | KVSL1 | Account key | nvarchar | 3 | 0 | | |
17 | T683S | Pricing Procedure: Data | 16 | KVSL1 | Account key | nvarchar | 3 | 0 | | |
TOPCross-Application Components |
18 | VKONV | Conditions (Transaction Data) | 29 | KVSL1 | Account key | nvarchar | 3 | 0 | | |
TOPExchanges |
19 | OIANF | Fee Condition Records | 29 | KVSL1 | Account key | nvarchar | 3 | 0 | | |
TOPIndustry Solution Engineering Construction |
20 | C495 | Document Category/Condition Type/Own-External/Account Key | 8 | KVSL1 | Account key | nvarchar | 3 | 0 | | |
21 | C496 | Condition Type/Account Key | 6 | KVSL1 | Account key | nvarchar | 3 | 0 | | |
22 | C497 | Document Category/Condition Type/Account Key | 7 | KVSL1 | Account key | nvarchar | 3 | 0 | | |
23 | C498 | Doc. Category/Condition Type/Own-Ext./Actvty Type/Acc. Key | 9 | KVSL1 | Account key | nvarchar | 3 | 0 | | |
24 | C499 | Doc. Cat./Cond. Type/Own-Ext./Acty Type/Ctlg Group/Acc. Key | 11 | KVSL1 | Account key | nvarchar | 3 | 0 | | |
TOPJoint Venture und Production Sharing Accounting |
25 | JVKONV | IS-Oil / Joint Venture / Data table for CRP pricing data | 29 | KVSL1 | Account key | nvarchar | 3 | 0 | | |
TOPLocalization |
26 | IDMX_DI_TAXES | Digital Invoice Mexico: Legal Abbreviations of Taxes | 4 | KVSL1 | Account key | nvarchar | 3 | 0 | | |
27 | IDMX_DI_TAXTYP | Table is OBSOLETE (replaced by IDMX_DI_TAXES) | 3 | KVSL1 | Account key | nvarchar | 3 | 0 | | |
TOPMarketing, Accounting and Pricing |
28 | OIC_KONV | Conditions (Procedure Data) | 29 | KVSL1 | Account key | nvarchar | 3 | 0 | | |
29 | OIC_OIANF | Fee Condition Records | 29 | KVSL1 | Account key | nvarchar | 3 | 0 | | |
TOPPatient Accounting |
30 | C400 | IS-H: Account key/case type/private/ext.physician | 5 | KVSL1 | Account key | nvarchar | 3 | 0 | | |
31 | C401 | IS-H: Acct key/case type/srv.catalog/srv./private/ext.phys. | 5 | KVSL1 | Account key | nvarchar | 3 | 0 | | |
32 | NVKONV | IS-H: Conditions | 13 | KVSL1 | Account key | nvarchar | 3 | 0 | | |
TOPPeriodical Sales and Distribution |
33 | C450 | IS-M/SD: SOrg./Publ./Edit./CGrp./AKey/BFreq. | 9 | KVSL1 | Account key | nvarchar | 3 | 0 | | |
34 | C451 | IS-M/SD: SOrg./Publ./CAccGrp./AccKey/BFreq. | 8 | KVSL1 | Account key | nvarchar | 3 | 0 | | |
35 | C452 | IS-M/SD: SOrg./Publ./AKey/BFreq. | 7 | KVSL1 | Account key | nvarchar | 3 | 0 | | |
36 | C453 | IS-M/SD: SOrg./AKey/BFreq. | 6 | KVSL1 | Account key | nvarchar | 3 | 0 | | |
37 | C460 | IS-M/SD: POrg./Publ./Edit./SC/AKey | 9 | KVSL1 | Account key | nvarchar | 3 | 0 | | |
38 | C461 | IS-M/SD: POrg./Publ./Edit./AKey | 8 | KVSL1 | Account key | nvarchar | 3 | 0 | | |
39 | C462 | IS-M/SD: POrg./Publ./AKey | 7 | KVSL1 | Account key | nvarchar | 3 | 0 | | |
40 | C463 | IS-M/SD: POrg./AKey | 6 | KVSL1 | Account key | nvarchar | 3 | 0 | | |
41 | C465 | IS-M/SD: SC/Publ./Edit./EEAcGrp./AKey | 9 | KVSL1 | Account key | nvarchar | 3 | 0 | | |
42 | C466 | IS-M/SD: SC/Publ./Edit./AKey | 8 | KVSL1 | Account key | nvarchar | 3 | 0 | | |
43 | C467 | IS-M/SD: SC/Publ./AKey | 7 | KVSL1 | Account key | nvarchar | 3 | 0 | | |
44 | C468 | IS-M/SD: SC/AKey | 6 | KVSL1 | Account key | nvarchar | 3 | 0 | | |
45 | JKONV | IS-M/SD: Conditions (Transaction Data) | 29 | KVSL1 | Account key | nvarchar | 3 | 0 | | |
TOPPricing |
46 | PRCC_COND_PP | Pricing Procedure Data (T683S) | 9 | KVSL1 | Account Key | nvarchar | 3 | 0 | | |
47 | PRCD_COND | Price Condition - Item - Condition (KONV) | 8 | KVSL1 | Account Key | nvarchar | 3 | 0 | | |
TOPTariffs, Duties and Permits |
48 | C410 | Chart of accts / Account key - acct assign for ED rev | 5 | KVSL1 | Account key | nvarchar | 3 | 0 | | |