| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /SMERP/STG_PM001 | Data staging - Equipment complex table | 112 | TECHS | Parameter Variant/Standard Variant | nvarchar | 12 | 0 | | |
2 | /SMERP/STG_PM003 | Data staging - Equipment List Set - Hdr - complex tab | 112 | TECHS | Parameter Variant/Standard Variant | nvarchar | 12 | 0 | | |
3 | ZEIM_AFPO | Order item | 45 | TECHS | Parameter Variant/Standard Variant | nvarchar | 12 | 0 | | |
4 | ZEIM_VBAP | Sales Document: Item Data | 202 | TECHS | Parameter Variant/Standard Variant | nvarchar | 12 | 0 | | |
TOPBasic Functions |
5 | VBBE | Sales Requirements: Individual Records | 40 | TECHS | Parameter Variant/Standard Variant | nvarchar | 12 | 0 | | |
TOPClasses |
6 | INOB | Link between Internal Number and Object | 16 | TECHS | Parameter Variant/Standard Variant | nvarchar | 12 | 0 | | |
TOPConfiguration management |
7 | IBINCM | IB: Config.Mang.: Component/Instance | 15 | TECHS | Technical status from | nvarchar | 12 | 0 | | |
TOPCross-Application Components |
8 | VVBAP | Sales Document: Item Data | 202 | TECHS | Parameter Variant/Standard Variant | nvarchar | 12 | 0 | | |
TOPDefense Forces and Public Security |
9 | /ISDFPS/ZEBAN | Copy of EBAN | 105 | TECHS | Parameter Variant/Standard Variant | nvarchar | 12 | 0 | | |
TOPDemand Management |
10 | PBED | Independent Requirements Data | 25 | TECHS | Parameter Variant/Standard Variant | nvarchar | 12 | 0 | | |
TOPEngineering Change Management |
11 | TECN | Effectivity object: change numbers | 2 | TECHS | Parameter Variant/Standard Variant | nvarchar | 12 | 0 | | |
12 | TECS | Master Effectivity Object | 2 | TECHS | Parameter Variant/Standard Variant | nvarchar | 12 | 0 | | |
13 | TECT | Description of Effectivity Object | 2 | TECHS | Parameter Variant/Standard Variant | nvarchar | 12 | 0 | | |
TOPEngineering Configuration Order BOM |
14 | CUOBOM_CHANGE | Manually Changed Items in the Order BOM | 11 | TECHS | Parameter Variant/Standard Variant | nvarchar | 12 | 0 | | |
TOPEquipment |
15 | EQUZ | Equipment time segment | 43 | TECHS | Parameter Variant/Standard Variant | nvarchar | 12 | 0 | | |
16 | IEQT_WL_ITEMS | Interim Statuses - Items | 61 | TECHS | Parameter Variant/Standard Variant | nvarchar | 12 | 0 | | |
17 | IEQT_WL_ITM_BAC | Interim Statuses - Items (Backup) | 62 | TECHS | Parameter Variant/Standard Variant | nvarchar | 12 | 0 | | |
TOPInstalled Base |
18 | IBIN | IB: IBase Components - Condition | 15 | TECHS | Technical status from | nvarchar | 12 | 0 | | |
TOPIntegrated Product and Process Engineering |
19 | PPEFILTEXPL | This table is obsolete, use PPEFILTEXPLPAR | 2 | TECHS | Parameter Variant/Standard Variant | nvarchar | 12 | 0 | | |
20 | PPEFILTEXPLPAR | Explosion Parameters for the iPPE Filter | 3 | TECHS | Parameter Variant/Standard Variant | nvarchar | 12 | 0 | | |
21 | PROFILCUST01 | iPPE: Profile for PS iPPE Interface | 12 | TECHS | Parameter Variant/Standard Variant | nvarchar | 12 | 0 | | |
TOPInventory Management |
22 | RESB | Reservation/dependent requirements | 172 | TECHS | Parameter Variant/Standard Variant | nvarchar | 12 | 0 | | |
TOPMaster Data |
23 | MDSM | Simulative dependent requirements | 98 | TECHS | Parameter Variant/Standard Variant | nvarchar | 12 | 0 | | |
24 | PLAF | Planned Order | 40 | TECHS | Parameter Variant/Standard Variant | nvarchar | 12 | 0 | | |
25 | SNUM | BOM explosion number | 4 | TECHS | Parameter Variant/Standard Variant | nvarchar | 12 | 0 | | |
TOPMaterials Management |
26 | /ISDFPS/CS_EXLST | Exception List: Overwritten Purchase Requisitions | 111 | TECHS | Parameter Variant/Standard Variant | nvarchar | 12 | 0 | | |
TOPProduct Cost Planning |
27 | KEKO | Product Costing - Header Data | 81 | TECHS | Parameter Variant/Standard Variant | nvarchar | 12 | 0 | | |
TOPProduction Orders |
28 | AFPO | Order item | 45 | TECHS | Parameter Variant/Standard Variant | nvarchar | 12 | 0 | | |
29 | AFVC | Operation within an order | 171 | TECHS | Parameter Variant/Standard Variant | nvarchar | 12 | 0 | | |
TOPPurchasing |
30 | EBAN | Purchase Requisition | 105 | TECHS | Parameter Variant/Standard Variant | nvarchar | 12 | 0 | | |
31 | EKPO | Purchasing Document Item | 188 | TECHS | Parameter Variant/Standard Variant | nvarchar | 12 | 0 | | |
32 | MEREQX | Purchase Requisition Change Parameter | 105 | TECHS | Updated information in related user data field | nvarchar | 1 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
33 | /BEV1/RBVBAP | Sales Document: Item Data | 202 | TECHS | Parameter Variant/Standard Variant | nvarchar | 12 | 0 | | |
TOPSales |
34 | VBAP | Sales Document: Item Data | 202 | TECHS | Parameter Variant/Standard Variant | nvarchar | 12 | 0 | | |
TOPSimulation |
35 | VSAFPO_CN | Version: Order items in PP orders | 46 | TECHS | Parameter Variant/Standard Variant | nvarchar | 12 | 0 | | |
36 | VSAFVC_CN | Version: Operation in order | 172 | TECHS | Parameter Variant/Standard Variant | nvarchar | 12 | 0 | | |
37 | VSEBAN_CN | Version: Purchase requisition | 106 | TECHS | Parameter Variant/Standard Variant | nvarchar | 12 | 0 | | |
38 | VSPLAF_CN | Version: Planned order | 41 | TECHS | Parameter Variant/Standard Variant | nvarchar | 12 | 0 | | |
39 | VSRESB_CN | Version: Reservation/Dependent requirements | 173 | TECHS | Parameter Variant/Standard Variant | nvarchar | 12 | 0 | | |
40 | VSVBAP_CN | Version: Sales document: Item data | 203 | TECHS | Parameter Variant/Standard Variant | nvarchar | 12 | 0 | | |