| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /GEP/T_NEED | Graphischer Leitstand: Bedarfe (einzuplanende Objekte) | 19 | KDAUF | Verkaufsbeleg | nvarchar | 10 | 0 | | |
2 | /GEP/T_SPLIT | Graphischer Leitstand: Splits (eingeplante Objekte) | 20 | KDAUF | Verkaufsbeleg | nvarchar | 10 | 0 | | |
3 | /SMERP/STG_PM001 | Data staging - Equipment complex table | 192 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
4 | /SMERP/STG_PM003 | Data staging - Equipment List Set - Hdr - complex tab | 186 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
5 | AUAA | Settlement Document: Receiver Segment | 29 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
6 | GLPCA_CT | Profit Center Documents | 77 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
7 | GLPCA_T_CT | Profit Center Documents | 93 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
8 | P2B2_C1 | HCM Declustering B2 - Cost Distribution Table C1 | 17 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
9 | P2B2_CWST | HCM Declustering B2 - PDC Time Tickets | 105 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
10 | P2B2_WST | HCM Declustering B2 - PDC Time Tickets | 105 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
11 | P2PL_RETROADJ | Payroll Result PL: Retro, originals and changes | 27 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
12 | P2PL_RETRODIF | Payroll Result PL: Retro, originals and changes | 27 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
13 | P2PL_RETROMEM | Payroll Result PL: Retro, originals and changes | 27 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
14 | P2RG_COSTS | Distribution of Employer's Cost (Payroll Function XDEC) | 34 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
15 | P2RT_CZDAV | P18_03 | 18 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
16 | P2RU_COSTS | Distribution of Employer's Cost (Payroll Function XDEC) | 34 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
17 | P2RX_C1 | Cost Distribution Table C1 | 15 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
18 | S980 | ORDRES DE FABRICATION | 52 | KDAUF | Numéro de la commande client | nvarchar | 10 | 0 | | |
19 | S981 | OF ARTICLES POSTES | 62 | KDAUF | Numéro de la commande client | nvarchar | 10 | 0 | | |
20 | ZEIM_AFPO | Order item | 11 | KDAUF | Sales order number | nvarchar | 10 | 0 | | |
21 | ZEIM_LIPS | SD document: Delivery: Item data | 109 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
TOPAccounting Interface |
22 | GLE_FI_ITEM_MODF | ECS: Modified FI Line Items (Header/Item/Currency Data) | 195 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
23 | GLE_FI_ITEM_ORIG | ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F) | 195 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
TOPActual CostingMaterial Ledger |
24 | CKMLDUVCO | Usage Differences for Each Account Assignment Object | 17 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
25 | CKMLMV013 | Assignment table: Process for production order | 14 | KDAUF | Sales order number | nvarchar | 10 | 0 | | |
26 | FCML_ALT | Alternatives | 17 | KDAUF | Sales Document Number (Alternative) | nvarchar | 10 | 0 | | |
27 | FCML_PROC | Business Processes | 19 | KDAUF | Sales Document Number (Process) | nvarchar | 10 | 0 | | |
28 | MLCO | Material valuation document account assignment information | 28 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
TOPAlternative Valuation Run |
29 | CKMLAVRDOCIT | Lines for Cumulation Posting Document | 52 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
TOPConfirmations |
30 | AFFW | Goods Movements with Errors from Confirmations | 15 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
31 | AFRV | Confirmation pool | 25 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
32 | AFRV_DEL | Backup Copy for Confirmation Pool | 25 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
TOPConstruction Industry |
33 | T5DB4 | HR Construction Site File | 9 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
34 | T5DB8 | Construction Sector: Team Assignment to Work Site | 32 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
35 | T5DBV | Construction Pay: Cost Assignment: Hostels | 14 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
36 | T5DBX | Construction Pay: Incentive Wage Connection | 14 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
TOPContract Accounts Receivable and Payable |
37 | DFKKDEFREV_POS | Line Item Table (Event-Based Deferred Revenues) | 32 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
38 | DFKKMOPK | Items in contract account document | 11 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
39 | DFKKOPK | Items in contract account document | 11 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
40 | DFKKORDERPOS | Requests: Items | 48 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
41 | DFKKORDERPOS_S | Request Templates: Items | 42 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
42 | DFKKSUM | Posting totals from FI-CA | 20 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
43 | DFKKSUMOLD | Totals Records Without Account Assignment Changes | 7 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
44 | FKKDEFREV | Trigger Table for Deferred Revenue Postings | 20 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
TOPCost Object |
45 | FCO_DOC_HEAD | Failure Cost Document Header | 10 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
TOPCross-Application Components |
46 | AAUUFK | Order master data | 70 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
TOPData Collection |
47 | S225 | Goods receipts: repetitive manufacturing | 14 | KDAUF | Sales order number | nvarchar | 10 | 0 | | |
48 | S225E | S225 - Structural Information | 9 | KDAUF | Sales order number | nvarchar | 10 | 0 | | |
49 | S226 | Material usage: repetitive manufacturing | 12 | KDAUF | Sales order number | nvarchar | 10 | 0 | | |
50 | S226E | S226 - Structural Information | 7 | KDAUF | Sales order number | nvarchar | 10 | 0 | | |
51 | S227 | Product costs: repetitive manufacturing | 13 | KDAUF | Sales order number | nvarchar | 10 | 0 | | |
52 | S227E | S227 - Structural Information | 8 | KDAUF | Sales order number | nvarchar | 10 | 0 | | |
53 | S279 | Transfer BW: Bestandsführung | 37 | KDAUF | Klantordernummer | nvarchar | 10 | 0 | | |
54 | S279BIW1 | S279BIW1 * BW Transfer: Inventory Management | 37 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
55 | S279BIW2 | S279BIW2 * BW Transfer: Inventory Management | 37 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
TOPData Retention Tool |
56 | TXW_S_MSEG | Retrieve MSEG from archive | 34 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
TOPData Transfer |
57 | PPDIT | Transfer to Accounting: Lines in HR IDOCs | 23 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
58 | PPDST | Transfer to Accounting: Substituted Acc. Assig. Object | 12 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
59 | PPKIX | Transfer FI/CO: Index of Account Assignment Combinations | 14 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
TOPDemand Management |
60 | PBID | Planned independent requirements index: MRP area | 33 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
61 | PBIM | Independent Requirements for Material | 31 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
TOPDistribution of Usage Variances |
62 | CKMLDUVNCO | Usage Differences for Each Account Assignment Object | 17 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
TOPElectronic Bank Statement |
63 | FEB_ACCNT_SAVE | Saving of Posting Lines for Postprocessing (Account Assign.) | 44 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
64 | FEB_ACT | Acct Assignment Templates | 44 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
TOPExchanges |
65 | OIA12I | Movement Based Netting document item | 18 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
66 | OIAQB | Exchange Movements Index | 25 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
TOPFinancial Accounting |
67 | ACCTIT | Compressed Data from FI/CO Document | 70 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
68 | T076K | FI-EDI: Additional Account Assignments | 11 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
69 | VBSEGA | Document Segment for Document Parking - Asset Database | 46 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
70 | VBSEGS | Document Segment for Document Parking - G/L Account Database | 37 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
TOPFunds Management-Specific Postings |
71 | FMFUNDTRANSYEAR | Additional Documents for Funds Transfer to Diff. Years | 38 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
72 | PSOSEGS | Recurring Request Document Segment, G/L Accounts | 37 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
TOPGeneral Ledger Accounting |
73 | FAGL_SPLINFO | Splittling Information of Open Items | 20 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
TOPGeneral Ledger Reorganization |
74 | FAGL_R_SPL | Reorganization: Splitting Information of the Open Items | 24 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
TOPGL Account Posting |
75 | TCJ_POSITIONS | Cash Journal Document Items | 51 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
TOPInformation System |
76 | MCAFPOV | Versions: Order Item | 28 | KDAUF | Sales order number | nvarchar | 10 | 0 | | |
77 | MCCOMPV | Versions: Material Components | 18 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
78 | MCSFIS | R/2 SFIS Data: Old | 62 | KDAUF | Sales order number | nvarchar | 10 | 0 | | |
TOPInterface to Terminal Automation System |
79 | OIK02B | IS-OIL/TAS: Status of processed functions - messages | 18 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
80 | OIK29 | IS-OIL/TPI: Status of processed inbound IDoc OILSHI01 | 9 | KDAUF | Sales Document | nvarchar | 10 | 0 | | |
81 | OIK29C | IS-OIL/TPI: Status of processed functions - messages | 17 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
82 | OIK29D | IS-OIL/TPI: Status of processed inbound IDoc OILSHI01 | 10 | KDAUF | Sales Document | nvarchar | 10 | 0 | | |
TOPInventory Management |
83 | CHVW | Table CHVW for Batch Where-Used List | 10 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
84 | ISEG | Physical Inventory Document Items | 11 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
85 | MSEG | Document Segment: Material | 21 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
86 | MWXMSEG | ZMSEG: Interface for Posting of Value | 21 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
87 | MWZMSEG | ZMSEG:Interface for Posting of Value | 21 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
88 | RESB | Reservation/dependent requirements | 34 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
89 | RKPF | Document Header: Reservation | 17 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
TOPLogistics Information System LIS |
90 | S280 | Order header and item, BW | 52 | KDAUF | Sales order number | nvarchar | 10 | 0 | | |
91 | S280BIW1 | S280BIW1 * Order header and item, BW | 52 | KDAUF | Sales order number | nvarchar | 10 | 0 | | |
92 | S280BIW2 | S280BIW2 * Order Header and Item, BW | 52 | KDAUF | Sales order number | nvarchar | 10 | 0 | | |
93 | S281 | Order Operation, BW | 62 | KDAUF | Sales order number | nvarchar | 10 | 0 | | |
94 | S281BIW1 | S281BIW1 * Order Process, BW | 62 | KDAUF | Sales order number | nvarchar | 10 | 0 | | |
95 | S281BIW2 | S281BIW2 * Order Process, BW | 62 | KDAUF | Sales order number | nvarchar | 10 | 0 | | |
96 | S282 | Order Component, BW | 20 | KDAUF | Sales order number | nvarchar | 10 | 0 | | |
97 | S282BIW1 | S282BIW1 * Order Components, BW | 20 | KDAUF | Sales order number | nvarchar | 10 | 0 | | |
98 | S282BIW2 | S282BIW2 * Order Components, BW | 20 | KDAUF | Sales order number | nvarchar | 10 | 0 | | |
TOPMaintenance Notifications |
99 | QMIH | Quality message - maintenance data excerpt | 31 | KDAUF | Sales Document | nvarchar | 10 | 0 | | |
TOPMaintenance Orders |
100 | AUFM | Goods movements for order | 14 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
TOPMaintenance Program Definition |
101 | MPDITEM | Maintenance Plan Items | 12 | KDAUF | Sales Document | nvarchar | 10 | 0 | | |
TOPMaintenance Task Lists |
102 | MPOS | Maintenance item | 39 | KDAUF | Sales Document | nvarchar | 10 | 0 | | |
TOPMaster Data |
103 | BLPK | Document log header | 11 | KDAUF | Sales and Distribution Document Number | nvarchar | 10 | 0 | | |
104 | KBVL | Individual Customer Plng File Entry, MRP Area Long-Term Plng | 7 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
105 | KBVM | Individual Customer Planning File Entry, MRP Area | 6 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
106 | KDPL | Index customer order -> planned order | 2 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
107 | KDVL | Individual Customer Planning File Entry, Long-Term Planning | 5 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
108 | KDVM | Individual Customer Planning File Entry | 4 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
109 | MDSM | Simulative dependent requirements | 90 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
110 | PLAF | Planned Order | 22 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
111 | PSPL | Index project -> planned order | 7 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
112 | PUMS | Project number new key assignment (structure) | 2 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
TOPMaterials Management |
113 | /ISDFPS/CHVW_E | External Batch Where-Used List | 10 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
114 | J_1GVL_ML | Material Ledger | 93 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
TOPOverhead Cost Orders |
115 | AUFK | Order master data | 70 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
116 | COBRB | Distribution Rules Settlement Rule Order Settlement | 46 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
TOPPayroll |
117 | T5TPSC1SPLIT | Rozdelení nákladu | 25 | KDAUF | Císlo zakázky odberatele | nvarchar | 10 | 0 | | |
TOPPersonnel Time Events |
118 | TPTCOR_KOSTL | Cost Assignment (Correction Scenario) | 7 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
TOPPersonnel Time Management |
119 | ASSOB | Assignment Objects | 13 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
120 | CC1ERP | Incorrect Time Events from CC1, Postings | 106 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
121 | CC1TEV | Temporary Buffer for Time Events from CC1 | 30 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
122 | COIFT | Interface to Activity Allocation | 45 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
123 | PTEX2000 | Interface Table for Attendances/Absences Infotype(2001/2002) | 55 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
124 | PTEX2003GEN | Interface Table for IT 2003: General Information | 54 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
125 | PTEX2003SPEC | Interface Table for IT 2003: Interval Information | 30 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
126 | PTEX2010 | Interface Table for EE Remuneration Info. Infotype (2010) | 54 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
127 | TEVEN_MORE | Additional Data for Time Events | 105 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
TOPPlant Data Collection |
128 | RUECK | Temp. storage for subsystem confirmations | 20 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
TOPProduction Backflush |
129 | PPC_COMAT | Maximum Bill of Material of Backflushed Materials (for CO) | 8 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
130 | PPC_HEAD | Document PP Backflush - Header | 13 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
131 | PPC_MAT_DET | Super BOM: Special Account/Batch Information | 4 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
132 | PPC_STEP2 | Goods Movements Table for New PPCGO Logic (2 Steps) | 14 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
TOPProduction Orders |
133 | AFPO | Order item | 11 | KDAUF | Sales order number | nvarchar | 10 | 0 | | |
TOPProfit Center Accounting |
134 | GLPCA | EC-PCA: Actual Line Items | 72 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
135 | GLPCP | EC-PCA: Plan Line Items | 130 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
TOPProfitability Analysis Basic Functions |
136 | K840001 | Summarization level KT: 800 KK 01 KKROBJ 000001 | 12 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
137 | K840005 | Summarization level KT: 800 KK 01 KKROBJ 000003 | 12 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
138 | K840009 | Summarization level KT: 800 KK 01 KKROBJ 000005 | 12 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
TOPQuality Inspection |
139 | QALS | Inspection lot record | 110 | KDAUF | Sales Order Number of Valuated Sales Order Stock | nvarchar | 10 | 0 | | |
TOPQuality Notifications |
140 | TQ8CO | Assignment of reference orders to notification type | 12 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
TOPRepetitive Manufacturing |
141 | COMPMOVE | Goods Movement of Components | 116 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
142 | RMUSER | User Settings for REM Backflush Transactions | 7 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
TOPSerial Numbers |
143 | EQBS | Serial Number Stock Segment | 10 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
TOPShipping |
144 | LIPS | SD document: Delivery: Item data | 109 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
TOPSimulation |
145 | VSAFPO_CN | Version: Order items in PP orders | 12 | KDAUF | Sales order number | nvarchar | 10 | 0 | | |
146 | VSAUFK_CN | Version: Order master data | 71 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
147 | VSPLAF_CN | Version: Planned order | 23 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
148 | VSRESB_CN | Version: Reservation/Dependent requirements | 35 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
TOPSocial Insurance |
149 | T5D3P | HR Technical Assignments for Workers' Compensation Assoc. | 9 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
TOPTariffs, Duties and Permits |
150 | OIH14 | Tax rate revaluation - obsolete | 9 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
TOPTravel Expenses |
151 | PTRV_DOC_IT | Transfer Travel -> FI/CO: Lines of TRV interm. document | 22 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |
TOPTravel Planning |
152 | FTPT_REQ_ACCOUNT | Travel Request Cost Assignment | 17 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | |