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