| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /SMERP/STG_MM005 | Data staging - Material batch view complex table | 207 | VFDAT | Shelf Life Expiration or Best-Before Date | nvarchar | 8 | 0 | | |
2 | ZEIM_LIPS | SD document: Delivery: Item data | 230 | VFDAT | Shelf Life Expiration or Best-Before Date | nvarchar | 8 | 0 | | |
3 | ZSTOCKINPUT | Utility table to assist with loading of Initial Stock (561) | 14 | VFDAT | Shelf Life Expiration or Best-Before Date | nvarchar | 8 | 0 | | |
TOPBasic Functions |
4 | FEBKO | Electronic Bank Statement Header Records | 12 | VFDAT | Data expiry date | nvarchar | 8 | 0 | | |
TOPBasic functions |
5 | HUWM_LOAD_PROT | Log Table of Initial Data Transfer for Subsequent Posting | 57 | VFDAT | Shelf Life Expiration or Best-Before Date | nvarchar | 8 | 0 | | |
6 | VEPO | Packing: Handling Unit Item (Contents) | 30 | VFDAT | Shelf Life Expiration or Best-Before Date | nvarchar | 8 | 0 | | |
TOPBatches |
7 | CHVW_PRE | Preliminary Batch Where-used List According to Order/PO | 21 | VFDAT | Shelf Life Expiration or Best-Before Date | nvarchar | 8 | 0 | | |
8 | CHVW_WM | Batch Where-Used List for Documentary Batches in WM | 14 | VFDAT | Shelf Life Expiration or Best-Before Date | nvarchar | 8 | 0 | | |
TOPClinical System |
9 | N1BCP | Basic Cat.: Catalog Item | 9 | VFDAT | Basic Catalog: Validity Start Date of an Item | nvarchar | 8 | 0 | | |
10 | N1BCS | OBSOLETE: Basic Cat.: Basic Catalog Set | 7 | VFDAT | Basic Cat.: Validity Start Date of Basic Catalog Set | nvarchar | 8 | 0 | | |
11 | N1BCSH | Basic Catalog Set: Header Data | 8 | VFDAT | Basic Cat.: Validity Start Date of Basic Catalog Set | nvarchar | 8 | 0 | | |
12 | N1BCSMC | Basic Catalog Set: Main Catalog | 8 | VFDAT | Basic Cat.: Validity Start Date of a Catalog in the Set | nvarchar | 8 | 0 | | |
13 | N1BCSPC | Basic Catalog Set: Property Catalog | 7 | VFDAT | Basic Cat.: Validity Start Date of a Catalog in the Set | nvarchar | 8 | 0 | | |
TOPInventory Management |
14 | CHVW | Table CHVW for Batch Where-Used List | 26 | VFDAT | Shelf Life Expiration or Best-Before Date | nvarchar | 8 | 0 | | |
15 | MSEG | Document Segment: Material | 141 | VFDAT | Shelf Life Expiration or Best-Before Date | nvarchar | 8 | 0 | | |
16 | MWXMSEG | ZMSEG: Interface for Posting of Value | 141 | VFDAT | Shelf Life Expiration or Best-Before Date | nvarchar | 8 | 0 | | |
17 | MWZMSEG | ZMSEG:Interface for Posting of Value | 141 | VFDAT | Shelf Life Expiration or Best-Before Date | nvarchar | 8 | 0 | | |
TOPMaterial Master |
18 | MCH1 | Batches (if Batch Management Cross-Plant) | 10 | VFDAT | Shelf Life Expiration or Best-Before Date | nvarchar | 8 | 0 | | |
19 | MCHA | Batches | 11 | VFDAT | Shelf Life Expiration or Best-Before Date | nvarchar | 8 | 0 | | |
TOPMaterials Management |
20 | /ISDFPS/CHVW_E | External Batch Where-Used List | 26 | VFDAT | Shelf Life Expiration or Best-Before Date | nvarchar | 8 | 0 | | |
TOPNursing |
21 | N1SNP | OBSOLETE - Std.Nurs.Plan: Std.Nurs.Plan Header Data | 7 | VFDAT | OBSOLETE | nvarchar | 8 | 0 | | |
22 | N1SNPH | Std.Nurs.Plan: Header Data | 8 | VFDAT | Standard Plan: Validity Start Date | nvarchar | 8 | 0 | | |
TOPQuality Inspection |
23 | QALS | Inspection lot record | 106 | VFDAT | Shelf Life Expiration or Best-Before Date | nvarchar | 8 | 0 | | |
TOPRepetitive Manufacturing |
24 | COMPMOVE | Goods Movement of Components | 80 | VFDAT | Shelf Life Expiration or Best-Before Date | nvarchar | 8 | 0 | | |
TOPShipping |
25 | LIPS | SD document: Delivery: Item data | 230 | VFDAT | Shelf Life Expiration or Best-Before Date | nvarchar | 8 | 0 | | |
TOPWarehouse Management |
26 | LINV | Inventory data per quant | 35 | VFDAT | Shelf Life Expiration or Best-Before Date | nvarchar | 8 | 0 | | |
27 | LQUA | Quants | 47 | VFDAT | Shelf Life Expiration or Best-Before Date | nvarchar | 8 | 0 | | |
28 | LTAP | Transfer order item | 105 | VFDAT | Shelf Life Expiration or Best-Before Date | nvarchar | 8 | 0 | | |
29 | LTBP | Transfer requirement item | 34 | VFDAT | Shelf Life Expiration or Best-Before Date | nvarchar | 8 | 0 | | |