| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /1CADMC/00000439 | KONV | 7 | STUNR | | nvarchar | 3 | 0 | | |
2 | /BIC/B0000181000 | PSA for 2LIS_11_VAKON T90CLNT090 Sales Document Cond. | 81 | STUNR | | nvarchar | 3 | 0 | | |
3 | /BIC/B0000186000 | PSA for 2LIS_13_VDKON T90CLNT090 Billing Docu. Cond. | 70 | STUNR | | nvarchar | 3 | 0 | | |
4 | CNVTDMS_05_FMIFI | Fill Header for Funds Management | 9 | STUNR | Headid für DIMP | nvarchar | 16 | 0 | | |
5 | CNVTDMS_05_FMIOI | Fill Header for Funds Management | 15 | STUNR | Headid für DIMP | nvarchar | 16 | 0 | | |
6 | KONV | Conditions (Transaction Data) | 4 | STUNR | Step number | nvarchar | 3 | 0 | | |
7 | KONVTOCPFGUID | Linking of document condition to CPF | 4 | STUNR | Step number | nvarchar | 3 | 0 | | |
8 | KONV_SUPPL_LINK | Link table for supplementary KONV data | 5 | STUNR | Step number | nvarchar | 3 | 0 | | |
9 | T683S_VARIANT | Processing Variant Definition of a Procedure (Pricing,...) | 7 | STUNR | Step number | nvarchar | 3 | 0 | | |
10 | VFPRCC_PRCE2VIEW | Pricing Elements to View Mapping | 5 | STUNR | Step number | nvarchar | 3 | 0 | | |
TOPAccounting Interface |
11 | GLE_FI_ITEM_MODF | ECS: Modified FI Line Items (Header/Item/Currency Data) | 241 | STUNR | Step number | nvarchar | 3 | 0 | | |
12 | GLE_FI_ITEM_ORIG | ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F) | 241 | STUNR | Step number | nvarchar | 3 | 0 | | |
TOPActual CostingMaterial Ledger |
13 | MLWERE | Conversion Table between Purchasing and Material Ledger | 5 | STUNR | Step number | nvarchar | 3 | 0 | | |
TOPActual Payments and Forecast |
14 | COFP | Document Lines (project cash management) | 32 | STUNR | Step number | nvarchar | 3 | 0 | | |
TOPBasic Functions |
15 | FDM1 | Cash Management & Forecast: Line Items of MM Documents | 10 | STUNR | Step number | nvarchar | 3 | 0 | | |
TOPChargeback |
16 | WCOCOF | Condition Contract: Document Flow Data | 4 | STUNR | Step number | nvarchar | 3 | 0 | | |
TOPCondition Technique |
17 | /SAPCND/CTLISTI | Elements in Determ. Procedure | 5 | STUNR | Level Number in a Determ. Procedure | nvarchar | 3 | 0 | | |
TOPConditions |
18 | T683S | Pricing Procedure: Data | 5 | STUNR | Step number | nvarchar | 3 | 0 | | |
19 | T683T | Pricing Procedures: Texts | 6 | STUNR | Step number | nvarchar | 3 | 0 | | |
TOPCosting |
20 | COER | Sales Order Value Revenue | 18 | STUNR | Step number | nvarchar | 3 | 0 | | |
TOPCross-Application Components |
21 | VKONV | Conditions (Transaction Data) | 4 | STUNR | Step number | nvarchar | 3 | 0 | | |
TOPData Collection |
22 | S008 | Communications Table SD -> CO/Projects | 14 | STUNR | Step number | nvarchar | 3 | 0 | | |
TOPExchanges |
23 | OIAF7 | Formula Condition Txn Data-Header (enhance CI-Incl.in OICF1) | 4 | STUNR | Step number | nvarchar | 3 | 0 | | |
24 | OIAF8 | Formula Condition Data - Terms (enhance CI-Incl.in OICF2) | 4 | STUNR | Step number | nvarchar | 3 | 0 | | |
25 | OIAF9 | Formula Condition Data-Term Items (enhance CI-Incl.in OICF3) | 4 | STUNR | Step number | nvarchar | 3 | 0 | | |
26 | OIANF | Fee Condition Records | 4 | STUNR | Step number | nvarchar | 3 | 0 | | |
TOPFinancial Accounting |
27 | VBSEGS | Document Segment for Document Parking - G/L Account Database | 94 | STUNR | Step number | nvarchar | 3 | 0 | | |
TOPFree goods |
28 | FGDC_COND_P | Free Goods Procedures | 5 | STUNR | Level Number | nvarchar | 3 | 0 | | |
TOPFreight Processing |
29 | VFKONV | (Freight) Conditions | 4 | STUNR | Step number | nvarchar | 3 | 0 | | |
TOPFunds Management |
30 | FCABP | FI-CA: Document Item | 39 | STUNR | Step number | nvarchar | 3 | 0 | | |
31 | FMCFSIF | FI-FM: Selected Open Documents from FI Update | 7 | STUNR | Number that clearly identifies the line key in database | nvarchar | 16 | 0 | | |
32 | FMCFSIF_TR | Selected Open FI Documents (Settlement) | 7 | STUNR | Number that clearly identifies the line key in database | nvarchar | 16 | 0 | | |
33 | FMCFSIO | FI-FM: Selected Open Commitment Documents | 13 | STUNR | Number that clearly identifies the line key in database | nvarchar | 16 | 0 | | |
34 | FMCFSIO_TR | FI-FM: Selected Open Commitment Documents | 13 | STUNR | Number that clearly identifies the line key in database | nvarchar | 16 | 0 | | |
35 | FMEP | FI-FM Line Items | 34 | STUNR | Step number | nvarchar | 3 | 0 | | |
36 | FMIFIIT | FI Line Item Table in Funds Management | 8 | STUNR | Number that clearly identifies the line key in database | nvarchar | 16 | 0 | | |
37 | FMIOI | Commitment Documents Funds Management | 14 | STUNR | Number that clearly identifies the line key in database | nvarchar | 16 | 0 | | |
38 | FMUDBSEGP | Part.Payt Item for Customer Invoice of a Rev. Incr. the Bgt | 11 | STUNR | Number that clearly identifies the line key in database | nvarchar | 16 | 0 | | |
39 | FMUDIFIIT | Additional Data for FI Line Items f. Revenues Incr. the Bdgt | 8 | STUNR | Number that clearly identifies the line key in database | nvarchar | 16 | 0 | | |
40 | FMUDKBLPP | Item Revenues Increasing Budget for Forecast of Revenue | 9 | STUNR | Number that clearly identifies the line key in database | nvarchar | 16 | 0 | | |
TOPFunds Management-Specific Postings |
41 | FMFUNDTRANSYEAR | Additional Documents for Funds Transfer to Diff. Years | 93 | STUNR | Step number | nvarchar | 3 | 0 | | |
42 | PSOSEGS | Recurring Request Document Segment, G/L Accounts | 92 | STUNR | Step number | nvarchar | 3 | 0 | | |
TOPIndustry Solution Catch Weight Management |
43 | /CWM/MIG_PROT_EK | Saving EKBE and EBKZ with DMBTR = 0 | 10 | STUNR | Step number | nvarchar | 3 | 0 | | |
TOPIntegration |
44 | FKK_KONV_SHORT | Price Conditions for SD Billing Document - Extracts | 8 | STUNR | Step number | nvarchar | 3 | 0 | | |
TOPInventory Management |
45 | MMINKON_UP | Corrections due to Technical Problems with Stock | 40 | STUNR | Step number | nvarchar | 3 | 0 | | |
TOPInvoice Verification |
46 | RBDRSEG | Batch IV: Invoice Document Items | 50 | STUNR | Step number | nvarchar | 3 | 0 | | |
47 | RSEG | Document Item: Incoming Invoice | 65 | STUNR | Step number | nvarchar | 3 | 0 | | |
TOPJoint Venture und Production Sharing Accounting |
48 | JVKONV | IS-Oil / Joint Venture / Data table for CRP pricing data | 4 | STUNR | Step number | nvarchar | 3 | 0 | | |
TOPLocalization |
49 | J_1IKONV | Excise recalculated conditions | 4 | STUNR | Step number | nvarchar | 3 | 0 | | |
TOPMarketing, Accounting and Pricing |
50 | OICQ7 | Formula Condition Txn Data-Header (enhance CI-Incl.in OICF1) | 4 | STUNR | Step number | nvarchar | 3 | 0 | | |
51 | OICQ8 | Formula Condition Data - Terms (enhance CI-Include in OICF2) | 4 | STUNR | Step number | nvarchar | 3 | 0 | | |
52 | OICQ9 | Formula Condition Data-Term Items (enhance CI-Incl.in OICF3) | 4 | STUNR | Step number | nvarchar | 3 | 0 | | |
53 | OIC_CPE_FO_LINK | Relationship Between F&A Formula and CPE Formula | 5 | STUNR | Step number | nvarchar | 3 | 0 | | |
54 | OIC_FORM_ATTRIB | Attributes of Business Context for F&A Formula | 5 | STUNR | Step number | nvarchar | 3 | 0 | | |
55 | OIC_KONV | Conditions (Procedure Data) | 4 | STUNR | Step number | nvarchar | 3 | 0 | | |
56 | OIC_OIANF | Fee Condition Records | 4 | STUNR | Step number | nvarchar | 3 | 0 | | |
TOPMaster Data |
57 | FMALE_SETNUM | FM Document Numbers to be Converted FI Line Item Table FM | 8 | STUNR | Number that clearly identifies the line key in database | nvarchar | 16 | 0 | | |
TOPMaster Data Distribution |
58 | /ISDFPS/FMSETNUM | Last Converted Document Number FI Line Item Table FM | 8 | STUNR | Number that clearly identifies the line key in database | nvarchar | 16 | 0 | | |
TOPPatient Accounting |
59 | NVKONV | IS-H: Conditions | 4 | STUNR | Step number | nvarchar | 3 | 0 | | |
TOPPeriodical Sales and Distribution |
60 | JFREVACC | IS-M/SD: Pl.Cir.f.Rev. - Revenue per Liab.Acct + G/L Account | 7 | STUNR | Step number | nvarchar | 3 | 0 | | |
61 | JKONV | IS-M/SD: Conditions (Transaction Data) | 4 | STUNR | Step number | nvarchar | 3 | 0 | | |
62 | TJY05 | IS-M/SD: Dyn.Menu Entries for Master Data Maint.for Cond. | 7 | STUNR | Step number | nvarchar | 3 | 0 | | |
63 | TJY17 | IS-M/SD: Condition Class for Usage and Application | 5 | STUNR | Step number | nvarchar | 3 | 0 | | |
TOPPricing |
64 | PRCC_COND_PP | Pricing Procedure Data (T683S) | 5 | STUNR | Level Number | nvarchar | 3 | 0 | | |
65 | PRCC_COND_PPT | Texts for Line in Pricing Procedure (T683T) | 6 | STUNR | Level Number | nvarchar | 3 | 0 | | |
66 | PRCD_COND | Price Condition - Item - Condition (KONV) | 4 | STUNR | Level Number | nvarchar | 3 | 0 | | |
TOPProduction and Revenue Accounting |
67 | OIUQ9 | Formula Condition Data - Formula group items | 4 | STUNR | Step number | nvarchar | 3 | 0 | | |
TOPProfitability Analysis |
68 | CEERROR | CO-PA: Incorrect records from SD | 9 | STUNR | Step number | nvarchar | 3 | 0 | | |
TOPPurchasing |
69 | EKBZ | History per Purchasing Document: Delivery Costs | 4 | STUNR | Step number | nvarchar | 3 | 0 | | |
70 | EKBZH | History per Purchasing Document: Delivery Costs | 4 | STUNR | Step number | nvarchar | 3 | 0 | | |
71 | EKBZH_MA | History Table Delivery Costs at Account Assignment Level | 4 | STUNR | Step number | nvarchar | 3 | 0 | | |
72 | EKBZ_MA | Delivery Costs at Account Assignment Level | 4 | STUNR | Step number | nvarchar | 3 | 0 | | |
73 | EKDF | Document Flow for Logistics Differential Invoice | 12 | STUNR | Step number | nvarchar | 3 | 0 | | |
74 | EKRSDC | ERS Procedure: Planned Delivery Costs to be Invoiced | 5 | STUNR | Step number | nvarchar | 3 | 0 | | |
TOPTransaction Manager |
75 | IDCFMFLCALCRLA | Description of simplified flow calc.procedure (amounts) | 3 | STUNR | Step number for Flow Calculation | nvarchar | 3 | 0 | | |
76 | IDCFMFLCALCRLN | Description of simplified flow calculation procedure (lines) | 3 | STUNR | Step number for Flow Calculation | nvarchar | 3 | 0 | | |
77 | IDCFMFLCALCRLP | Description of simplified flow calc.procedure (percentages) | 3 | STUNR | Step number for Flow Calculation | nvarchar | 3 | 0 | | |
78 | VTBSIANF | **Caution! Do not use. Will be deleted!! | 26 | STUNR | Step number | nvarchar | 3 | 0 | | |
79 | VTBSIZU | Hedge Allocation | 34 | STUNR | Step number | nvarchar | 3 | 0 | | |
TOPTransaction Tax Engine |
80 | TTE2C_TAX_MAP | Mapping between Tax Type and Procedure | 5 | STUNR | Level Number | nvarchar | 3 | 0 | | |
TOPTreasury |
81 | FLQITEMPO_FC | Liquidity Calculation - Forecast Line Items for MM POs | 6 | STUNR | Step number | nvarchar | 3 | 0 | | |
TOPVendor Outline Agreements |
82 | MMBSI_PO_SRM_INF | DB table for storing additional SRM data related to PO | 6 | STUNR | Step number | nvarchar | 3 | 0 | | |
TOPWarranty Claim Processing |
83 | WTY_COND_ACCOUNT | Auxiliary Account Assignment of Conditions | 4 | STUNR | Step number | nvarchar | 3 | 0 | | |