| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /SMERP/KBED_EX | Exchange Table - Capacity Requirements | 5 | APLZL | General counter for order | nvarchar | 8 | 0 | | |
2 | /SYCLO/AUFPL_EX | Syclo Exchange Table - Maintenance Work Order | 5 | APLZL | General counter for order | nvarchar | 8 | 0 | | |
3 | AUAA | Settlement Document: Receiver Segment | 28 | APLZL | Internal counter | nvarchar | 8 | 0 | | |
4 | BSAD_BAK | Accounting: Secondary index for customers (cleared items) | 99 | APLZL | Internal counter | nvarchar | 8 | 0 | | |
5 | BSAK_BAK | Accounting: Secondary Index for Vendors (Cleared Items) | 103 | APLZL | Internal counter | nvarchar | 8 | 0 | | |
6 | BSEG | Accounting Document Segment | 225 | APLZL | General counter for order | nvarchar | 8 | 0 | | |
7 | BSID_BAK | Accounting: Secondary Index for Customers | 99 | APLZL | Internal counter | nvarchar | 8 | 0 | | |
8 | BSIK_BAK | Accounting: Secondary index for vendors | 103 | APLZL | Internal counter | nvarchar | 8 | 0 | | |
9 | BSSEG | Accounting Document Segment | 214 | APLZL | General counter for order | nvarchar | 8 | 0 | | |
10 | FUDT_VDOCBSEG | Verification Document Item with Additional Info | 214 | APLZL | General counter for order | nvarchar | 8 | 0 | | |
11 | FUDT_VDOCBSEGEV | Verification Document Item in the Entry View | 214 | APLZL | General counter for order | nvarchar | 8 | 0 | | |
12 | FUDT_VDOCBSEGH | Verification Document Segment with Additional Info(History) | 214 | APLZL | General counter for order | nvarchar | 8 | 0 | | |
13 | GLPOS_C_CT | FI Document: Entry View | 44 | APLZL | General counter for order | nvarchar | 8 | 0 | | |
14 | GLPOS_C_DEB_CT | GLPOS_C_CT Customer Line Items | 44 | APLZL | General counter for order | nvarchar | 8 | 0 | | |
15 | GLPOS_C_GL_CT | GLPOS_C_CT G/L Line Items | 44 | APLZL | General counter for order | nvarchar | 8 | 0 | | |
16 | GLPOS_C_VEN_CT | GLPOS_C_CT Vendor Line Items | 44 | APLZL | General counter for order | nvarchar | 8 | 0 | | |
17 | GLPOS_N_CT | New General Ledger: Line Item with Currency Type | 44 | APLZL | General counter for order | nvarchar | 8 | 0 | | |
18 | GLPOS_N_GL_CT | New General Ledger: Line Item with Currency Type | 44 | APLZL | General counter for order | nvarchar | 8 | 0 | | |
19 | ODTF_IDOC_LOG_NA | Travel on Demand: Log f. Netw. Activity Replication via IDOC | 3 | APLZL | General counter for order | nvarchar | 8 | 0 | | |
20 | QAOPERATION | Relation between Keyfields of PP and QM | 3 | APLZL | General counter for order | nvarchar | 8 | 0 | | |
21 | REGUP | Processed items from payment program | 101 | APLZL | Internal counter | nvarchar | 8 | 0 | | |
22 | ZPS22F | Project system: Text symbol assign. Standard network seq. | 4 | APLZL | Internal counter | nvarchar | 8 | 0 | | |
23 | ZPS23 | Project System: Text Symbol Assignment - Activities | 4 | APLZL | General counter for order | nvarchar | 8 | 0 | | |
TOPAccounting Interface |
24 | GLE_FI_ITEM_MODF | ECS: Modified FI Line Items (Header/Item/Currency Data) | 178 | APLZL | Internal counter | nvarchar | 8 | 0 | | |
25 | GLE_FI_ITEM_ORIG | ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F) | 178 | APLZL | Internal counter | nvarchar | 8 | 0 | | |
TOPActual CostingMaterial Ledger |
26 | CKMLDUVCO | Usage Differences for Each Account Assignment Object | 23 | APLZL | General counter for order | nvarchar | 8 | 0 | | |
TOPAlternative Valuation Run |
27 | CKMLAVRDOCIT | Lines for Cumulation Posting Document | 48 | APLZL | Internal counter | nvarchar | 8 | 0 | | |
TOPBasic Functions |
28 | FPLA | Billing Plan | 23 | APLZL | General counter for order | nvarchar | 8 | 0 | | |
29 | FPLAPO | Billing Plan | 23 | APLZL | General counter for order | nvarchar | 8 | 0 | | |
30 | VFPLA | Billing Plan | 23 | APLZL | General counter for order | nvarchar | 8 | 0 | | |
TOPBilling |
31 | VBRP | Billing Document: Item Data | 202 | APLZL | Internal counter | nvarchar | 8 | 0 | | |
TOPCapacity Evaluations |
32 | CYOPR_MOVE | Order-/operation data | 3 | APLZL | General counter for order | nvarchar | 8 | 0 | | |
TOPCapacity Leveling |
33 | ISTBED | Actual requirements records | 8 | APLZL | General counter for order | nvarchar | 8 | 0 | | |
TOPConfirmations |
34 | AFFW | Goods Movements with Errors from Confirmations | 36 | APLZL | Internal counter | nvarchar | 8 | 0 | | |
35 | AFRU | Order Confirmations | 67 | APLZL | General counter for order | nvarchar | 8 | 0 | | |
TOPCost Object |
36 | FCO_DOC_HEAD | Failure Cost Document Header | 17 | APLZL | Internal counter | nvarchar | 8 | 0 | | |
TOPCross-Application Components |
37 | BBSID | Accounting: Secondary index for customers | 99 | APLZL | Internal counter | nvarchar | 8 | 0 | | |
38 | ONROS | Object number index for order sequence | 4 | APLZL | Internal counter | nvarchar | 8 | 0 | | |
39 | ONROV | Object number index for order process | 4 | APLZL | Internal counter | nvarchar | 8 | 0 | | |
TOPDistribution of Usage Variances |
40 | CKMLDUVACTCO | Distribution Acty Differences: Diff. Per Acct Assgnmt object | 22 | APLZL | General counter for order | nvarchar | 8 | 0 | | |
41 | CKMLDUVNCO | Usage Differences for Each Account Assignment Object | 23 | APLZL | General counter for order | nvarchar | 8 | 0 | | |
42 | DUVMSEG_EXTRACT | duv mseg extract for performance | 19 | APLZL | Internal counter | nvarchar | 8 | 0 | | |
TOPExternal Services |
43 | ESKN | Account Assignment in Service Package | 31 | APLZL | Internal counter | nvarchar | 8 | 0 | | |
TOPFinancial Accounting |
44 | ACCTIT | Compressed Data from FI/CO Document | 141 | APLZL | Internal counter | nvarchar | 8 | 0 | | |
45 | BSAD | Accounting: Secondary Index for Customers (Cleared Items) | 99 | APLZL | Internal counter | nvarchar | 8 | 0 | | |
46 | BSAK | Accounting: Secondary Index for Vendors (Cleared Items) | 103 | APLZL | Internal counter | nvarchar | 8 | 0 | | |
47 | BSID | Accounting: Secondary Index for Customers | 99 | APLZL | Internal counter | nvarchar | 8 | 0 | | |
48 | BSIK | Accounting: Secondary Index for Vendors | 103 | APLZL | Internal counter | nvarchar | 8 | 0 | | |
TOPFreight Processing |
49 | VFKN | Account Determination in Shipment Costs Item | 30 | APLZL | Internal counter | nvarchar | 8 | 0 | | |
TOPFunds Management |
50 | KBLP | Document Item: Manual Document Entry | 36 | APLZL | General counter for order | nvarchar | 8 | 0 | | |
TOPGeneral Ledger Accounting |
51 | BSEG_ADD | Entry View of Accounting Document for Additional Ledgers | 47 | APLZL | General counter for order | nvarchar | 8 | 0 | | |
52 | FAGL_SPLINFO | Splittling Information of Open Items | 25 | APLZL | Internal counter | nvarchar | 8 | 0 | | |
TOPGeneral Ledger Reorganization |
53 | FAGL_R_SPL | Reorganization: Splitting Information of the Open Items | 20 | APLZL | Internal counter | nvarchar | 8 | 0 | | |
TOPInformation System |
54 | MCAFVGV | Versions: Order Procedure | 6 | APLZL | Internal counter | nvarchar | 8 | 0 | | |
55 | MCSFIS | R/2 SFIS Data: Old | 69 | APLZL | Internal counter | nvarchar | 8 | 0 | | |
TOPInterest |
56 | TZIN1 | Document Header Data from Source Document (PS Int.Calc.) | 18 | APLZL | Internal counter | nvarchar | 8 | 0 | | |
TOPInterface to External Project Software |
57 | NVGUID | GUIDs for Network Activity | 4 | APLZL | General counter for order | nvarchar | 8 | 0 | | |
TOPInventory Management |
58 | MSEG | Document Segment: Material | 116 | APLZL | Internal counter | nvarchar | 8 | 0 | | |
59 | MWXMSEG | ZMSEG: Interface for Posting of Value | 116 | APLZL | Internal counter | nvarchar | 8 | 0 | | |
60 | MWZMSEG | ZMSEG:Interface for Posting of Value | 116 | APLZL | Internal counter | nvarchar | 8 | 0 | | |
61 | RESB | Reservation/dependent requirements | 100 | APLZL | Internal counter | nvarchar | 8 | 0 | | |
62 | RKPF | Document Header: Reservation | 33 | APLZL | Internal counter | nvarchar | 8 | 0 | | |
TOPInvoice Verification |
63 | RBCO | Document Item, Incoming Invoice, Account Assignment | 9 | APLZL | Routing number of operations in the order | nvarchar | 10 | 0 | | |
TOPJoint Venture und Production Sharing Accounting |
64 | JVCO1 | JV Object Table 2 for JVTO1 | 6 | APLZL | General counter for order | nvarchar | 8 | 0 | | |
65 | JVPO1 | JVA: Plan Line Items | 33 | APLZL | General counter for order | nvarchar | 8 | 0 | | |
66 | JVPSC01O | Object table 1 | 19 | APLZL | General counter for order | nvarchar | 8 | 0 | | |
67 | JVSO1 | JV LI Table with Objects for JVTO1 | 33 | APLZL | General counter for order | nvarchar | 8 | 0 | | |
68 | JVTO1 | JV Summary Table with Objects | 31 | APLZL | General counter for order | nvarchar | 8 | 0 | | |
TOPLocal Currency Changeover |
69 | EWUFI_SCA | EMU conversion: Table of the clearings to be adjusted | 22 | APLZL | General counter for order | nvarchar | 8 | 0 | | |
TOPMaintenance History |
70 | HIVG | PM order history - operations | 6 | APLZL | General counter for order | nvarchar | 8 | 0 | | |
TOPMaintenance Notifications |
71 | OPROL | AVO Link to Object List Entry | 3 | APLZL | General counter for order | nvarchar | 8 | 0 | | |
TOPMaintenance Orders |
72 | /MRSS/D_DEM_PS | Rejected and/or deleted requirements | 3 | APLZL | General counter for order | nvarchar | 8 | 0 | | |
73 | AUFM | Goods movements for order | 39 | APLZL | Internal counter | nvarchar | 8 | 0 | | |
TOPMaster Data |
74 | MDSM | Simulative dependent requirements | 83 | APLZL | Internal counter | nvarchar | 8 | 0 | | |
TOPNetwork and Activity |
75 | MLST | Milestone | 19 | APLZL | Internal counter | nvarchar | 8 | 0 | | |
TOPOverhead Cost Orders |
76 | COBRB | Distribution Rules Settlement Rule Order Settlement | 43 | APLZL | Internal counter | nvarchar | 8 | 0 | | |
TOPPlant Maintenance |
77 | Z9I_STK_IF_NPV | PM/PS-Schnittstelle: Netzplanvorgänge | 29 | APLZL | Interner Zähler | nvarchar | 8 | 0 | | |
78 | Z9I_STK_IF_NPV_W | PM/PS-Schnittstelle: Netzplanvorgänge Werkstattsicht | 36 | APLZL | Interner Zähler | nvarchar | 8 | 0 | | |
79 | Z9I_STK_VORGANG | Terminkontrolle Stillstandsplanung: Relevante Vorgänge | 17 | APLZL | Allgemeiner Zähler des Auftrags | nvarchar | 8 | 0 | | |
TOPProcess Order |
80 | AFFT | Order - Process Instructions | 3 | APLZL | General counter for order | nvarchar | 8 | 0 | | |
81 | AFFV | Order - Process Instruction Values | 3 | APLZL | General counter for order | nvarchar | 8 | 0 | | |
82 | COCR_CMX_DB_CS | Context Data for XSteps | 5 | APLZL | General counter for order | nvarchar | 8 | 0 | | |
83 | OPDEV | Order Operation - Schedule Deviations | 3 | APLZL | General counter for order | nvarchar | 8 | 0 | | |
TOPProduct Cost Planning |
84 | CKIS | Items Unit Costing/Itemization Product Costing | 88 | APLZL | Continuous Counter for Differentiating Database Entries | nvarchar | 8 | 0 | | |
TOPProduct Lifecycle Management |
85 | DIWPS_NOTI_PCOMP | Table for Partically Completed Notifications | 9 | APLZL | General counter for order | nvarchar | 8 | 0 | | |
TOPProduction Orders |
86 | AFFL | Work order sequence | 3 | APLZL | Internal counter | nvarchar | 8 | 0 | | |
87 | AFSPOPR | Split Operations in an Order Split | 3 | APLZL | General counter for order | nvarchar | 8 | 0 | | |
88 | AFVC | Operation within an order | 3 | APLZL | General counter for order | nvarchar | 8 | 0 | | |
89 | AFVU | DB structure of the user fields of the operation | 3 | APLZL | General counter for order | nvarchar | 8 | 0 | | |
90 | AFVV | DB structure of the quantities/dates/values in the operation | 3 | APLZL | General counter for order | nvarchar | 8 | 0 | | |
91 | COWIPB_CHVW | WIP Batches with Where-Used List | 26 | APLZL | General counter for order | nvarchar | 8 | 0 | | |
92 | ORDCOM | Communication control Operation download | 3 | APLZL | General counter for order | nvarchar | 8 | 0 | | |
TOPProduction ResourcesTools |
93 | AFFH | PRT assignment data for the work order | 17 | APLZL | Internal counter | nvarchar | 8 | 0 | | |
TOPProject System |
94 | PSHLPDB_HIER_TMP | Table to store temporary hierarchy data | 14 | APLZL | General counter for order | nvarchar | 8 | 0 | | |
95 | PSHLP_HIER_DB | Local cache:Project/Independent Network hierarchy | 14 | APLZL | General counter for order | nvarchar | 8 | 0 | | |
TOPPurchasing |
96 | EBKN | Purchase Requisition Account Assignment | 33 | APLZL | Internal counter | nvarchar | 8 | 0 | | |
97 | EKKN | Account Assignment in Purchasing Document | 36 | APLZL | Internal counter | nvarchar | 8 | 0 | | |
TOPQuality Inspection |
98 | QALS | Inspection lot record | 189 | APLZL | Internal counter | nvarchar | 8 | 0 | | |
TOPQuality Notifications |
99 | TQ8CO | Assignment of reference orders to notification type | 11 | APLZL | Internal counter | nvarchar | 8 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
100 | /BEV3/CH1030BSG1 | Document Segment CH Event Ledger Part1 | 216 | APLZL | General counter for order | nvarchar | 8 | 0 | | |
TOPRepetitive Manufacturing |
101 | COMPMOVE | Goods Movement of Components | 155 | APLZL | General counter for order | nvarchar | 8 | 0 | | |
TOPScheduling |
102 | KBED | Capacity Requirements Records | 35 | APLZL | General counter for order | nvarchar | 8 | 0 | | |
TOPSelf-Service Procurement |
103 | /SRMERP/D_ACC_IT | Account assignment item | 30 | APLZL | Internal counter | nvarchar | 8 | 0 | | |
TOPSimulation |
104 | VSAFFH_CN | Version: PRT allocation to work order | 18 | APLZL | Internal counter | nvarchar | 8 | 0 | | |
105 | VSAFFL_CN | Version: Order sequences PP orders | 4 | APLZL | Internal counter | nvarchar | 8 | 0 | | |
106 | VSAFVC_CN | Version: Operation in order | 4 | APLZL | General counter for order | nvarchar | 8 | 0 | | |
107 | VSAFVU_CN | Version: User fields in operation in order | 4 | APLZL | General counter for order | nvarchar | 8 | 0 | | |
108 | VSAFVV_CN | Version: Quantities/Dates/Values in order operation | 4 | APLZL | General counter for order | nvarchar | 8 | 0 | | |
109 | VSEBKN_CN | Version: Purchase requisition account assignment | 34 | APLZL | Internal counter | nvarchar | 8 | 0 | | |
110 | VSFPLA_CN | Version: Billing schedule | 24 | APLZL | General counter for order | nvarchar | 8 | 0 | | |
111 | VSHIST_NV | Tranfer history for network activity | 3 | APLZL | General counter for order | nvarchar | 8 | 0 | | |
112 | VSHIST_OV | Transfer history activity | 3 | APLZL | General counter for order | nvarchar | 8 | 0 | | |
113 | VSKBED_CN | Version: Capacity requirement records | 36 | APLZL | General counter for order | nvarchar | 8 | 0 | | |
114 | VSMLST_CN | Version: Milestone | 20 | APLZL | Internal counter | nvarchar | 8 | 0 | | |
115 | VSRESB_CN | Version: Reservation/Dependent requirements | 101 | APLZL | Internal counter | nvarchar | 8 | 0 | | |
TOPStructures |
116 | PSHLP_ACT_PM_DT | Table for tracking whether acty dates are determined by pmcs | 3 | APLZL | General counter for order | nvarchar | 8 | 0 | | |
TOPTechnical Application Support |
117 | CNV_20425_SCA | EMU conversion: Table of the clearings to be adjusted | 19 | APLZL | General counter for order | nvarchar | 8 | 0 | | |
TOPWork Clearance Management |
118 | WCAE | WCM: Order Operation <-> Approval Group | 3 | APLZL | General counter for order | nvarchar | 8 | 0 | | |
119 | WCAEQ | WCM: Log (Order Operation <-> Approval Group) | 3 | APLZL | General counter for order | nvarchar | 8 | 0 | | |
120 | WCAF | WCM: Order Operation <-> Work Clearance Document | 3 | APLZL | General counter for order | nvarchar | 8 | 0 | | |
121 | WCAFQ | WCM: Log (Order Operation <-> Work Clearance Document) | 3 | APLZL | General counter for order | nvarchar | 8 | 0 | | |
122 | WCAS | WCM: Application <-> Order Operation | 4 | APLZL | General counter for order | nvarchar | 8 | 0 | | |
123 | WCASQ | WCM: Log (Application <-> Order Operation) | 4 | APLZL | General counter for order | nvarchar | 8 | 0 | | |