| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /SMERP/STG_PM001 | Data staging - Equipment complex table | 50 | SERNR | Serial Number | nvarchar | 18 | 0 | | |
2 | /SMERP/STG_PM003 | Data staging - Equipment List Set - Hdr - complex tab | 50 | SERNR | Serial Number | nvarchar | 18 | 0 | | |
3 | ZEIM_AFPO | Order item | 44 | SERNR | BOM explosion number | nvarchar | 8 | 0 | | |
4 | ZEIM_LIPS | SD document: Delivery: Item data | 134 | SERNR | BOM explosion number | nvarchar | 8 | 0 | | |
5 | ZEIM_VBAP | Sales Document: Item Data | 142 | SERNR | BOM explosion number | nvarchar | 8 | 0 | | |
6 | ZEIM_VBEP | Sales Document: Schedule Line Data | 51 | SERNR | BOM explosion number | nvarchar | 8 | 0 | | |
TOPAP-LIM Logistics Inventory Management Engine |
7 | /LIME/PN_SERIAL | /LIME/DOC - PN Document for Serial Numbers | 9 | SERNR | Serial Number | nvarchar | 30 | 0 | | |
8 | /LIME/USID_I001 | LIME - USID Key Serial Number (R/3) | 2 | SERNR | Serial Number | nvarchar | 30 | 0 | | |
TOPAuto-ID Backend Integration |
9 | AIDEPCREF | Obsolite: EPC Reference | 10 | SERNR | Serial Number | nvarchar | 18 | 0 | | |
TOPBasic Functions |
10 | ANLA | Asset Master Record Segment | 131 | SERNR | Serial number | nvarchar | 18 | 0 | | |
TOPBasic functions |
11 | HUINV_SERNR | Handling Unit Phys. Inv. Doc. - Serial Numbers for Item | 4 | SERNR | Serial Number | nvarchar | 18 | 0 | | |
12 | HUMSEG_SER | Serial Numbers for the HUMSEG Table | 4 | SERNR | Serial Number | nvarchar | 18 | 0 | | |
13 | HUWM_LOAD_PROT | Log Table of Initial Data Transfer for Subsequent Posting | 65 | SERNR | Serial Number | nvarchar | 18 | 0 | | |
TOPBasic Functions |
14 | T850H | Upload Methods: Field Catalogs | 4 | SERNR | Sequential field number | nvarchar | 2 | 0 | | |
15 | VBBE | Sales Requirements: Individual Records | 34 | SERNR | BOM explosion number | nvarchar | 8 | 0 | | |
16 | VBBS | Sales Requirement Totals Record | 22 | SERNR | BOM explosion number | nvarchar | 8 | 0 | | |
TOPBilling |
17 | VBRP | Billing Document: Item Data | 114 | SERNR | BOM explosion number | nvarchar | 8 | 0 | | |
TOPClinical System |
18 | N1MATVM | IS-H*MED: Medical info for material consumpt. documentation | 8 | SERNR | BOM Explosion Number | nvarchar | 20 | 0 | | |
TOPConsolidation |
19 | TF011 | Generate Request Screen: Formating Instructions | 2 | SERNR | Four-digit number | nvarchar | 4 | 0 | | |
20 | TF382 | Upload Methods: Field Catalogs | 4 | SERNR | Sequential field number | nvarchar | 2 | 0 | | |
21 | TF656 | Activities - Default Sequence | 3 | SERNR | Sequence number | nvarchar | 2 | 0 | | |
TOPCross-Application Components |
22 | /GCDSMIC/REPRINT | Reprint | 6 | SERNR | Validity: serial number | nvarchar | 18 | 0 | | |
23 | VVBAP | Sales Document: Item Data | 142 | SERNR | BOM explosion number | nvarchar | 8 | 0 | | |
24 | VVBEP | Sales Document: Schedule Line Data | 51 | SERNR | BOM explosion number | nvarchar | 8 | 0 | | |
TOPData Collection |
25 | S120 | Sales as per receipts | 46 | SERNR | BOM Explosion Number | nvarchar | 25 | 0 | | |
26 | S120BIW1 | S120BIW1 * Sales as Per Receipts | 46 | SERNR | BOM Explosion Number | nvarchar | 25 | 0 | | |
27 | S120BIW2 | S120BIW2 * Sales as Per Receipts | 46 | SERNR | BOM Explosion Number | nvarchar | 25 | 0 | | |
TOPDefense Forces and Public Security |
28 | /ISDFPS/ZEBAN | Copy of EBAN | 55 | SERNR | BOM explosion number | nvarchar | 8 | 0 | | |
TOPDemand Management |
29 | PBED | Independent Requirements Data | 14 | SERNR | BOM explosion number | nvarchar | 8 | 0 | | |
TOPEquipment |
30 | EQUI | Equipment master data | 45 | SERNR | Serial Number | nvarchar | 18 | 0 | | |
31 | IEQT_WL_HDR_BAC | Interim Statuses - Header Data (Backup) | 14 | SERNR | Serial Number | nvarchar | 18 | 0 | | |
32 | IEQT_WL_HEADER | Interim Statuses - Header Data | 13 | SERNR | Serial Number | nvarchar | 18 | 0 | | |
TOPGeneral Ledger Accounting |
33 | FAGL_RRI_CUST | Customiz. for Report Interface (NewGL: FI-CO Reconciliation) | 4 | SERNR | BRST Sequence Number | nvarchar | 4 | 0 | | |
34 | FAGL_RRI_CUST_D | Default Contents for Table FAGL_RRI_CUST | 3 | SERNR | BRST Sequence Number | nvarchar | 4 | 0 | | |
TOPGreat Britain |
35 | T5G_P46ARV | HR-GB: Archive for P46(Car)-Forms | 2 | SERNR | HR-GB: Serial number of P46(Car)-Forms for employee | nvarchar | 4 | 0 | | |
TOPInformation System |
36 | MCAFPOV | Versions: Order Item | 34 | SERNR | BOM explosion number | nvarchar | 8 | 0 | | |
37 | MCSFIS | R/2 SFIS Data: Old | 65 | SERNR | BOM explosion number | nvarchar | 8 | 0 | | |
TOPInventory Management |
38 | RESB | Reservation/dependent requirements | 33 | SERNR | BOM explosion number | nvarchar | 8 | 0 | | |
TOPLogbook |
39 | DIACL_CLIST | DI CLIST: Component data | 5 | SERNR | Serial Number | nvarchar | 18 | 0 | | |
TOPMaintenance Orders |
40 | /CUM/AFCU | CU: CU Instances | 12 | SERNR | BOM explosion number | nvarchar | 8 | 0 | | |
TOPMalaysia |
41 | T5LSQ | Serial no Table for EA form - Malaysia | 9 | SERNR | Serial number for EA form | nvarchar | 6 | 0 | | |
TOPMaster Data |
42 | MDSM | Simulative dependent requirements | 72 | SERNR | BOM explosion number | nvarchar | 8 | 0 | | |
43 | MDTB | MRP Table | 53 | SERNR | BOM explosion number | nvarchar | 8 | 0 | | |
44 | PLAF | Planned Order | 38 | SERNR | BOM explosion number | nvarchar | 8 | 0 | | |
45 | SNUC | Changed revision levels (for creating MRP records RM61SR00) | 2 | SERNR | BOM explosion number | nvarchar | 8 | 0 | | |
46 | SNUM | BOM explosion number | 2 | SERNR | BOM explosion number | nvarchar | 8 | 0 | | |
47 | SUMS | New key assignment: BOM explosion no.->New BOM explosion no. | 4 | SERNR | BOM explosion number | nvarchar | 8 | 0 | | |
TOPMaterials Management |
48 | /ISDFPS/CS_EXLST | Exception List: Overwritten Purchase Requisitions | 60 | SERNR | BOM explosion number | nvarchar | 8 | 0 | | |
49 | /ISDFPS/REO_PLAN | Planned Transfer Postings for Reorganizations | 10 | SERNR | Serial Number | nvarchar | 18 | 0 | | |
50 | /ISDFPS/REO_PSER | Planned Transfer Postings for Reorganizations (Serial Nos) | 4 | SERNR | Serial Number | nvarchar | 18 | 0 | | |
51 | /ISDFPS/SERMATWM | Assignment: Serial. Material -> Stor. Bin (Loading Object) | 3 | SERNR | Serial Number | nvarchar | 18 | 0 | | |
TOPOLAP Technology |
52 | RSBBSCUBE | BW: InfoCube Receiver | 3 | SERNR | BRST Sequence Number | nvarchar | 4 | 0 | | |
53 | RSBBSCUBEMAPPING | Fixed Mapping for BW-R/RI | 3 | SERNR | BRST Sequence Number | nvarchar | 4 | 0 | | |
54 | RSBBSCUBET | BW: Texts for InfoCube Receiver | 4 | SERNR | BRST Sequence Number | nvarchar | 4 | 0 | | |
55 | RSBBSQRYMAPPING | Fixed Mapping for BW-R/RI | 4 | SERNR | BRST Sequence Number | nvarchar | 4 | 0 | | |
56 | RSBBSQUERY | BW: Query Receiver | 4 | SERNR | BRST Sequence Number | nvarchar | 4 | 0 | | |
57 | RSBBSQUERYT | BW: Texts for Query Receiver | 5 | SERNR | BRST Sequence Number | nvarchar | 4 | 0 | | |
TOPPension fund Netherlands |
58 | T5NK9 | Kasstroom overzicht - log | 4 | SERNR | Volgnummer | nvarchar | 5 | 0 | | |
TOPProduction Orders |
59 | AFPO | Order item | 44 | SERNR | BOM explosion number | nvarchar | 8 | 0 | | |
60 | OCMHOMO_ARCH | Backup Table of Homogeneity List in Case of Archiving | 8 | SERNR | BOM explosion number | nvarchar | 8 | 0 | | |
TOPPurchasing |
61 | EBAN | Purchase Requisition | 55 | SERNR | BOM explosion number | nvarchar | 8 | 0 | | |
62 | EKEH | Scheduling Agreement Release Documentation | 12 | SERNR | BOM explosion number | nvarchar | 8 | 0 | | |
63 | EKEHH | Removed Scheduling Agreement Release Documentation | 12 | SERNR | BOM explosion number | nvarchar | 8 | 0 | | |
64 | EKET | Scheduling Agreement Schedule Lines | 21 | SERNR | BOM explosion number | nvarchar | 8 | 0 | | |
65 | EKETH | Scheduling Agreement Schedules: History Tables | 21 | SERNR | BOM explosion number | nvarchar | 8 | 0 | | |
66 | MEREQX | Purchase Requisition Change Parameter | 55 | SERNR | Updated information in related user data field | nvarchar | 1 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
67 | /BEV1/RBVBAP | Sales Document: Item Data | 142 | SERNR | BOM explosion number | nvarchar | 8 | 0 | | |
TOPReportReport Interface |
68 | TRSTI | BRST assignment sender -> receiver (Communication Handler) | 8 | SERNR | BRST Sequence Number | nvarchar | 4 | 0 | | |
69 | TRSTI0 | R/R Interface: Assignment Cross-Client Senders to Receivers | 7 | SERNR | BRST Sequence Number | nvarchar | 4 | 0 | | |
70 | TRSTI0T | Assignment Cross-Client Senders to Receivers: Receiver Texts | 8 | SERNR | BRST Sequence Number | nvarchar | 4 | 0 | | |
71 | TRSTIT | BRST assignment sender -> receiver: Receiver texts | 9 | SERNR | BRST Sequence Number | nvarchar | 4 | 0 | | |
TOPSales |
72 | VBAP | Sales Document: Item Data | 142 | SERNR | BOM explosion number | nvarchar | 8 | 0 | | |
73 | VBEP | Sales Document: Schedule Line Data | 51 | SERNR | BOM explosion number | nvarchar | 8 | 0 | | |
74 | VBSN | Change status relating to scheduling agreements | 8 | SERNR | BOM explosion number | nvarchar | 8 | 0 | | |
TOPSerial Numbers |
75 | EQSE | Serial Number Records | 4 | SERNR | Serial Number | nvarchar | 18 | 0 | | |
76 | OBJK | Plant Maintenance Object List | 11 | SERNR | Serial Number | nvarchar | 18 | 0 | | |
77 | SERBL | Plant Maintenance Object List | 4 | SERNR | BOM explosion number | nvarchar | 8 | 0 | | |
78 | SERI | Serial Numbers | 3 | SERNR | Serial Number | nvarchar | 18 | 0 | | |
TOPService Processing |
79 | VBPM | Supplement for Sales Document Items: Technical PM Objects | 6 | SERNR | Serial Number | nvarchar | 18 | 0 | | |
TOPShipping |
80 | LIPS | SD document: Delivery: Item data | 134 | SERNR | BOM explosion number | nvarchar | 8 | 0 | | |
TOPSimulation |
81 | VSAFPO_CN | Version: Order items in PP orders | 45 | SERNR | BOM explosion number | nvarchar | 8 | 0 | | |
82 | VSEBAN_CN | Version: Purchase requisition | 56 | SERNR | BOM explosion number | nvarchar | 8 | 0 | | |
83 | VSPLAF_CN | Version: Planned order | 39 | SERNR | BOM explosion number | nvarchar | 8 | 0 | | |
84 | VSRESB_CN | Version: Reservation/Dependent requirements | 34 | SERNR | BOM explosion number | nvarchar | 8 | 0 | | |
85 | VSVBAP_CN | Version: Sales document: Item data | 143 | SERNR | BOM explosion number | nvarchar | 8 | 0 | | |
86 | VSVBEP_CN | Version: Sales document: Schedule line data | 52 | SERNR | BOM explosion number | nvarchar | 8 | 0 | | |
TOPSoftware Management |
87 | S426 | Variant Config.1---IBASE | 14 | SERNR | Serial Number | nvarchar | 18 | 0 | | |
88 | S427 | Variant Config.2---IBASE | 18 | SERNR | Serial Number | nvarchar | 18 | 0 | | |
TOPStructures Workbench |
89 | /ISDFPS/EQUIPLN | Materials Planned for Force Element (Serialized) | 5 | SERNR | Serial Number | nvarchar | 18 | 0 | | |
90 | /ISDFPS/MATSPPLN | Materials Planned for Force Element | 15 | SERNR | Serial Number | nvarchar | 18 | 0 | | |
91 | /ISDFPS/STOCK_MV | Background Relocation Stocks to Be Transferred | 7 | SERNR | Serial Number | nvarchar | 18 | 0 | | |
TOPTakeoverHandover of Technical Objects |
92 | PHINT | Phase In Table | 20 | SERNR | Serial Number | nvarchar | 18 | 0 | | |
TOPTechnical Objects |
93 | TITOB_IBASE | Creation of IBase: Buffer Table Structures | 7 | SERNR | Serial Number | nvarchar | 18 | 0 | | |
TOPUnique Identification |
94 | IUID_MAN_DATA | Manually Maintained Values for IUID Messages | 7 | SERNR | Serial Number | nvarchar | 18 | 0 | | |
95 | IUID_PEDIGREE | UII IDoc Message Data for Supporting Supplier Collaboration | 7 | SERNR | Serial Number | nvarchar | 18 | 0 | | |
96 | UII_IUID | Unique Item Identifier | 10 | SERNR | Serial Number | nvarchar | 18 | 0 | | |
TOPWaste Management |
97 | EWA_ORDER_OBJECT | Item Table for Waste Disposal Order | 6 | SERNR | Serial Number | nvarchar | 18 | 0 | | |