| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | ZPS12F | Project system: Text symbol assign. Standard netw/Routing | 6 | PLNFL | Sequence | nvarchar | 6 | 0 | | |
TOPActive Quality Control |
2 | QDQL | Quality level | 7 | PLNFL | Sequence of Operations Within a Plan | nvarchar | 6 | 0 | | |
TOPAssortment |
3 | WRF_APC_MPA | Markdown Profile Assignment | 16 | PLNFL | Checkbox | nvarchar | 1 | 0 | | |
TOPControlling |
4 | CPZPBACK | Production Reporting Points Periodic Totals Values (Temp) | 8 | PLNFL | Sequence | nvarchar | 6 | 0 | | |
5 | CPZPTEMP | Production Reporting Points Periodic Totals Values (Temp) | 8 | PLNFL | Sequence | nvarchar | 6 | 0 | | |
6 | QRP_CPZP | Reporting Points - Total Values per Date | 9 | PLNFL | Sequence | nvarchar | 6 | 0 | | |
TOPCost Object |
7 | FCO_DOC_HEAD | Failure Cost Document Header | 19 | PLNFL | Sequence | nvarchar | 6 | 0 | | |
8 | PZPS | Production Measuring Point for Totals Record | 6 | PLNFL | Sequence | nvarchar | 6 | 0 | | |
TOPData Collection |
9 | S022 | SFIS: Order Operation Data for Work Center | 15 | PLNFL | Sequence | nvarchar | 6 | 0 | | |
TOPDistribution Requirements Planning |
10 | PLPLAN_PARAM | BOM-dependent planning parameter | 13 | PLNFL | Sequence | nvarchar | 6 | 0 | | |
TOPInformation System |
11 | MCAFVGV | Versions: Order Procedure | 8 | PLNFL | Sequence | nvarchar | 6 | 0 | | |
12 | MCSFIS | R/2 SFIS Data: Old | 71 | PLNFL | Sequence | nvarchar | 6 | 0 | | |
TOPIntegrated Product and Process Engineering |
13 | CMIG_MAPPING | Mapping Table (Classic PP and iPPE Objekt Key) | 13 | PLNFL | Sequence | nvarchar | 6 | 0 | | |
TOPInventory Management |
14 | RESB | Reservation/dependent requirements | 98 | PLNFL | Sequence | nvarchar | 6 | 0 | | |
TOPMaintenance Task Lists |
15 | PLWP | Allocation of maintenance packages to task list operations | 5 | PLNFL | Sequence | nvarchar | 6 | 0 | | |
TOPMaster Data |
16 | MDSM | Simulative dependent requirements | 81 | PLNFL | Sequence | nvarchar | 6 | 0 | | |
TOPProduct Cost by Period |
17 | CEZP | Reporting Points Line Items | 11 | PLNFL | Sequence | nvarchar | 6 | 0 | | |
18 | CHZP | Reporting Points - Change History | 10 | PLNFL | Sequence | nvarchar | 6 | 0 | | |
19 | CPZP | Reporting Points - Periodic Totals Values | 8 | PLNFL | Sequence | nvarchar | 6 | 0 | | |
TOPProduction Orders |
20 | AFFL | Work order sequence | 7 | PLNFL | Sequence | nvarchar | 6 | 0 | | |
21 | AFVC | Operation within an order | 4 | PLNFL | Sequence | nvarchar | 6 | 0 | | |
22 | ORDLY | Table of delays for production order | 6 | PLNFL | Sequence | nvarchar | 6 | 0 | | |
TOPResults Recording |
23 | QIWL | Transfer table for QM subsystems | 4 | PLNFL | Sequence | nvarchar | 6 | 0 | | |
TOPRouting |
24 | PLAS | Task list - selection of operations/activities | 5 | PLNFL | Sequence | nvarchar | 6 | 0 | | |
25 | PLFH | Task list - production resources/tools | 19 | PLNFL | Sequence | nvarchar | 6 | 0 | | |
26 | PLFL | Task list - sequences | 5 | PLNFL | Sequence | nvarchar | 6 | 0 | | |
27 | PLMZ | Allocation of bill of material items to operations | 12 | PLNFL | Sequence | nvarchar | 6 | 0 | | |
TOPRouting EBOM Assignment |
28 | /PLMI/RTGRCALNKH | Routing Component Assignment Link | 10 | PLNFL | Sequence | nvarchar | 6 | 0 | | |
TOPSamples and SPC |
29 | QASH | Quality control chart | 9 | PLNFL | Sequence | nvarchar | 6 | 0 | | |
TOPScheduling |
30 | KBED | Capacity Requirements Records | 41 | PLNFL | Sequence | nvarchar | 6 | 0 | | |
TOPSimulation |
31 | VSAFFL_CN | Version: Order sequences PP orders | 8 | PLNFL | Sequence | nvarchar | 6 | 0 | | |
32 | VSAFVC_CN | Version: Operation in order | 5 | PLNFL | Sequence | nvarchar | 6 | 0 | | |
33 | VSKBED_CN | Version: Capacity requirement records | 42 | PLNFL | Sequence | nvarchar | 6 | 0 | | |
34 | VSRESB_CN | Version: Reservation/Dependent requirements | 99 | PLNFL | Sequence | nvarchar | 6 | 0 | | |