| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | A017 | Material Info Record (Plant-Specific) | 8 | ESOKZ | Purchasing info record category | nvarchar | 1 | 0 | | |
| 2 | A018 | Material Info Record | 7 | ESOKZ | Purchasing info record category | nvarchar | 1 | 0 | | |
| 3 | A025 | Info Record for Non-Stock Item (Plant-Specific) | 9 | ESOKZ | Purchasing info record category | nvarchar | 1 | 0 | | |
| 4 | A028 | Info Record for Non-Stock Item | 8 | ESOKZ | Purchasing info record category | nvarchar | 1 | 0 | | |
| 5 | A046 | Material Group Prices | 6 | ESOKZ | Purchasing info record category | nvarchar | 1 | 0 | | |
| 6 | A047 | Material Group Prices (Plant-Specific) | 6 | ESOKZ | Purchasing info record category | nvarchar | 1 | 0 | | |
| 7 | A049 | Market Price for Material | 5 | ESOKZ | Purchasing info record category | nvarchar | 1 | 0 | | |
| 8 | A054 | Market Price for Material Group | 5 | ESOKZ | Purchasing info record category | nvarchar | 1 | 0 | | |
| 9 | EINSGT | Purchasing Info Record: Segmentation Specific Data | 4 | ESOKZ | Purchasing info record category | nvarchar | 1 | 0 | | |
| TOPBasic Functions |
| 10 | A300 | Statistical Value of Subcontracting Components | 4 | ESOKZ | Purchasing info record category | nvarchar | 1 | 0 | | |
| 11 | A301 | Info Record Type and Incoterms | 4 | ESOKZ | Purchasing info record category | nvarchar | 1 | 0 | | |
| TOPConditions |
| 12 | A066 | Info record per order unit | 7 | ESOKZ | Purchasing info record category | nvarchar | 1 | 0 | | |
| 13 | A067 | Plant Info Record per Order Unit | 7 | ESOKZ | Purchasing info record category | nvarchar | 1 | 0 | | |
| 14 | KOTN001 | Info Record: Plant-Specific per Order Unit | 8 | ESOKZ | Purchasing info record category | nvarchar | 1 | 0 | | |
| 15 | KOTN002 | Info record per order unit | 7 | ESOKZ | Purchasing info record category | nvarchar | 1 | 0 | | |
| TOPCross-Application Components |
| 16 | PLLPO | Task list - operation/activity | 107 | ESOKZ | Purchasing info record category | nvarchar | 1 | 0 | | |
| TOPData Collection |
| 17 | S012 | Purchasing | 12 | ESOKZ | Purchasing info record category | nvarchar | 1 | 0 | | |
| 18 | S012BIW1 | S012BIW1 * Purchasing | 12 | ESOKZ | Purchasing info record category | nvarchar | 1 | 0 | | |
| 19 | S012BIW2 | S012BIW2 * Purchasing | 12 | ESOKZ | Purchasing info record category | nvarchar | 1 | 0 | | |
| 20 | S012E | S012 - Structural Information | 7 | ESOKZ | Purchasing info record category | nvarchar | 1 | 0 | | |
| 21 | S013 | PURCHIS: Statistics for Vendor Evaluation | 12 | ESOKZ | Purchasing info record category | nvarchar | 1 | 0 | | |
| 22 | S013BIW1 | PURCHIS: Statistics for Vendor Evaluation | 12 | ESOKZ | Purchasing info record category | nvarchar | 1 | 0 | | |
| 23 | S013BIW2 | S013BIW2 * PURCHIS: Statistics for vendor evaluation | 7 | ESOKZ | Purchasing info record category | nvarchar | 1 | 0 | | |
| 24 | S013E | S013 - Structural Information | 7 | ESOKZ | Purchasing info record category | nvarchar | 1 | 0 | | |
| TOPMaintenance History |
| 25 | HIVG | PM order history - operations | 46 | ESOKZ | Purchasing info record category | nvarchar | 1 | 0 | | |
| TOPMarketing, Accounting and Pricing |
| 26 | OIC_FORM_ATTRIB | Attributes of Business Context for F&A Formula | 27 | ESOKZ | Purchasing info record category | nvarchar | 1 | 0 | | |
| TOPMaster Data Distribution |
| 27 | /ISDFPS/TL1 | Task List - Operation/Activity | 107 | ESOKZ | Purchasing info record category | nvarchar | 1 | 0 | | |
| TOPNetwork and Activity |
| 28 | TCN41 | Network Defaults | 5 | ESOKZ | Purchasing info record category | nvarchar | 1 | 0 | | |
| TOPProduct Cost Planning |
| 29 | CKIS | Items Unit Costing/Itemization Product Costing | 70 | ESOKZ | Purchasing info record category | nvarchar | 1 | 0 | | |
| TOPProduction Orders |
| 30 | AFVC | Operation within an order | 60 | ESOKZ | Purchasing info record category | nvarchar | 1 | 0 | | |
| TOPPurchasing |
| 31 | A160 | Plant Info Record: Variants | 7 | ESOKZ | Purchasing info record category | nvarchar | 1 | 0 | | |
| 32 | A161 | Info Record: Variants | 6 | ESOKZ | Purchasing info record category | nvarchar | 1 | 0 | | |
| 33 | EINE | Purchasing Info Record: Purchasing Organization Data | 4 | ESOKZ | Purchasing info record category | nvarchar | 1 | 0 | | |
| 34 | EIPA | Order Price History: Info Record | 5 | ESOKZ | Purchasing info record category | nvarchar | 1 | 0 | | |
| 35 | INFREC_ARCHIVE | Archiving Index for info records | 4 | ESOKZ | Purchasing info record category | nvarchar | 1 | 0 | | |
| TOPRetail Pricing |
| 36 | WKBP | Pricing document: item | 57 | ESOKZ | Purchasing info record category | nvarchar | 1 | 0 | | |
| TOPRouting |
| 37 | PLPO | Task list - operation/activity | 107 | ESOKZ | Purchasing info record category | nvarchar | 1 | 0 | | |
| TOPSCM Basis |
| 38 | CIF_IMSRCI | IMod Reference Table for Purchasing Info Records | 4 | ESOKZ | Purchasing info record category | nvarchar | 1 | 0 | | |
| TOPSimulation |
| 39 | VSAFVC_CN | Version: Operation in order | 61 | ESOKZ | Purchasing info record category | nvarchar | 1 | 0 | | |
| TOPStandard Network |
| 40 | TCA41 | Default values for standard networks and profiles | 5 | ESOKZ | Purchasing info record category | nvarchar | 1 | 0 | | |
