| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /BIC/B0000103000 | PSA for /CPD/PFP_DS_AFVC T90CLNT090 DataSource for NWA | 5 | VORNR | | nvarchar | 4 | 0 | | |
2 | /BIC/B0000103001 | PSA for /CPD/PFP_DS_AFVC T90CLNT090 DataSource for NWA | 5 | VORNR | | nvarchar | 4 | 0 | | |
3 | /BIC/B0000111000 | Error Stack DTP_00O2TFWN1YKGA5W5VMZCQUQ9C 0001 | 4 | VORNR | | nvarchar | 4 | 0 | | |
4 | /OPT/VIM_1ITEM_S | Document Item | 57 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
5 | /OPT/VIM_TITEM | Document Item | 57 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
6 | /SYCLO/AUFNR_M1 | Syclo - Work Order Mobile Data Header | 3 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
7 | P2B2_C1 | HCM Declustering B2 - Cost Distribution Table C1 | 16 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
8 | P2B2_CWST | HCM Declustering B2 - PDC Time Tickets | 104 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
9 | P2B2_WST | HCM Declustering B2 - PDC Time Tickets | 104 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
10 | P2PL_RETROADJ | Payroll Result PL: Retro, originals and changes | 26 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
11 | P2PL_RETRODIF | Payroll Result PL: Retro, originals and changes | 26 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
12 | P2PL_RETROMEM | Payroll Result PL: Retro, originals and changes | 26 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
13 | P2RG_COSTS | Distribution of Employer's Cost (Payroll Function XDEC) | 33 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
14 | P2RT_CZDAV | P18_03 | 17 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
15 | P2RU_COSTS | Distribution of Employer's Cost (Payroll Function XDEC) | 33 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
16 | P2RX_C1 | Cost Distribution Table C1 | 14 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
17 | P2RX_FUND | Accounting Structure for Funds Management | 26 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
18 | S981 | OF ARTICLES POSTES | 9 | VORNR | Numéro d'opération | nvarchar | 4 | 0 | | |
19 | S981E | S981 - Info structurelles | 4 | VORNR | Numéro d'opération | nvarchar | 4 | 0 | | |
20 | S983 | SUIVI ATELIER | 10 | VORNR | Numéro d'opération | nvarchar | 4 | 0 | | |
21 | S983E | S983 - Info structurelles | 5 | VORNR | Numéro d'opération | nvarchar | 4 | 0 | | |
22 | YVIM_1ITEM | Document Item | 57 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
23 | ZMES_RES_PO | MES: Rescheduled Production Order | 3 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
24 | ZQUALITY_PARMS | Inspection Lot Parameters for material quality task lists | 4 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
TOPABAP List-Based PI Sheet |
25 | COFTP | PI Sheet: Process Instructions | 7 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
TOPAccounting Interface |
26 | GLE_FI_ITEM_MODF | ECS: Modified FI Line Items (Header/Item/Currency Data) | 399 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
27 | GLE_FI_ITEM_ORIG | ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F) | 399 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
TOPActive Quality Control |
28 | QDQL | Quality level | 14 | VORNR | Operation Number in the Quality Level | nvarchar | 4 | 0 | | |
TOPAttendancesAbsences |
29 | CATSHR | Cross-Application Time Sheet (CATS): Transfer to HR | 34 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
TOPConfirmations |
30 | AFRD | Default values for collective confirmation | 62 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
31 | AFRP0 | Table of planned changes for confirmation (PDC) | 14 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
32 | AFRU | Order Confirmations | 70 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
33 | AFRV | Confirmation pool | 24 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
34 | AFRV_DEL | Backup Copy for Confirmation Pool | 24 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
TOPConstruction Industry |
35 | T5DB4 | HR Construction Site File | 8 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
36 | T5DB8 | Construction Sector: Team Assignment to Work Site | 30 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
37 | T5DBV | Construction Pay: Cost Assignment: Hostels | 13 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
38 | T5DBX | Construction Pay: Incentive Wage Connection | 13 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
TOPCost Object |
39 | FCO_DOC_HEAD | Failure Cost Document Header | 18 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
TOPCross-Application Components |
40 | PLLPO | Task list - operation/activity | 16 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
TOPData Collection |
41 | S022 | SFIS: Order Operation Data for Work Center | 16 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
42 | S022E | S022 - Structural information | 7 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
43 | S028 | Reporting Point Statistics | 15 | VORNR | Reporting Point | nvarchar | 4 | 0 | | |
44 | S028E | S028 - Structural Information | 10 | VORNR | Reporting Point | nvarchar | 4 | 0 | | |
45 | S161 | Inspection Results: General | 28 | VORNR | QMIS Operation Number | nvarchar | 4 | 0 | | |
46 | S162 | Quantitative Inspection Results | 30 | VORNR | QMIS Operation Number | nvarchar | 4 | 0 | | |
47 | S163 | Quantitative Inspection Result: Vendor | 29 | VORNR | QMIS Operation Number | nvarchar | 4 | 0 | | |
48 | S164 | Quantitative Inspection Result: Vendor | 31 | VORNR | QMIS Operation Number | nvarchar | 4 | 0 | | |
49 | S165 | Inspection Results (General): Customers | 30 | VORNR | QMIS Operation Number | nvarchar | 4 | 0 | | |
50 | S166 | Quantitative Inspection Results: Customer | 31 | VORNR | QMIS Operation Number | nvarchar | 4 | 0 | | |
TOPData Transfer |
51 | PPDIT | Transfer to Accounting: Lines in HR IDOCs | 22 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
52 | PPDST | Transfer to Accounting: Substituted Acc. Assig. Object | 11 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
53 | PPKIX | Transfer FI/CO: Index of Account Assignment Combinations | 13 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
TOPElectronic Bank Statement |
54 | FEB_ACCNT_SAVE | Saving of Posting Lines for Postprocessing (Account Assign.) | 33 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
55 | FEB_ACT | Acct Assignment Templates | 33 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
TOPESS Based on WD ABAP |
56 | HRESS_D_CATS_FAV | CATS Favorites: database table | 125 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
TOPFinancial Accounting |
57 | /OPT/VIM_1ITEM | Document Item | 57 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
58 | KMZEI | FI: Account Assignment Model Item Information | 79 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
59 | KOMU | Account Assignment Templates for G/L Account Items | 79 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
60 | VBSEGA | Document Segment for Document Parking - Asset Database | 51 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
61 | VBSEGS | Document Segment for Document Parking - G/L Account Database | 102 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
TOPFreight Processing |
62 | VFKN | Account Determination in Shipment Costs Item | 27 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
TOPFunds Management |
63 | KBLP | Document Item: Manual Document Entry | 105 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
TOPFunds Management-Specific Postings |
64 | FMFUNDTRANSYEAR | Additional Documents for Funds Transfer to Diff. Years | 101 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
65 | PSOSEGS | Recurring Request Document Segment, G/L Accounts | 101 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
TOPGeneral Ledger Reorganization |
66 | FAGL_R_SPL | Reorganization: Splitting Information of the Open Items | 18 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
TOPGL Account Posting |
67 | TCJ_POSITIONS | Cash Journal Document Items | 40 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
TOPInformation System |
68 | MCAFVGV | Versions: Order Procedure | 9 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
69 | MCSFIS | R/2 SFIS Data: Old | 72 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
TOPInterface to External Project Software |
70 | NVGUID | GUIDs for Network Activity | 6 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
TOPInventory Management |
71 | RESB | Reservation/dependent requirements | 99 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
TOPInvoice Verification |
72 | RBCO | Document Item, Incoming Invoice, Account Assignment | 65 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
TOPJapan |
73 | T7JPSK_CONTT | Shukko Contract Template | 13 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
TOPJoint Venture und Production Sharing Accounting |
74 | JVCO1 | JV Object Table 2 for JVTO1 | 4 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
75 | JVPO1 | JVA: Plan Line Items | 34 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
76 | JVSO1 | JV LI Table with Objects for JVTO1 | 34 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
77 | JVTO1 | JV Summary Table with Objects | 29 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
TOPLogbook |
78 | DIACL_DIS_SIG | DS : Order operation within Logbook (For Distribution) | 4 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
TOPLogistics Information System LIS |
79 | S281 | Order Operation, BW | 9 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
80 | S281BIW1 | S281BIW1 * Order Process, BW | 9 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
81 | S281BIW2 | S281BIW2 * Order Process, BW | 9 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
TOPMaintenance History |
82 | AFVC_DIS_SIG | Digital Signature of Order Operation for Distribution | 4 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
83 | HIMA | PM order history - materials | 3 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
84 | HIVG | PM order history - operations | 3 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
TOPMaintenance Orders |
85 | /CUM/ACTIONM | CU: Example Action-Task List Operation Mapping Table | 3 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
TOPMaster Data |
86 | MDSM | Simulative dependent requirements | 82 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
TOPMaster Data Distribution |
87 | /ISDFPS/TL1 | Task List - Operation/Activity | 16 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
TOPMaterial Identification and Reconciliation |
88 | BEREIT | Material identification: staging data | 7 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
89 | MISTATUS | Status Table for Material Identification on Mat./Batch Level | 7 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
TOPPayroll |
90 | T5TPSC1SPLIT | Rozdelení nákladu | 24 | VORNR | Císlo operace | nvarchar | 4 | 0 | | |
TOPPermits |
91 | IHSG | Object-Related Permits in Plant Maintenance | 17 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
TOPPersonnel Time Events |
92 | TPTCOR_LOGISTIC | Logistics Orders (Correction Scenario) | 23 | VORNR | Operation number | nvarchar | 4 | 0 | | |
TOPPersonnel Time Management |
93 | ASSOB | Assignment Objects | 12 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
94 | CC1ERP | Incorrect Time Events from CC1, Postings | 37 | VORNR | Operation number | nvarchar | 4 | 0 | | |
95 | CC1TEV | Temporary Buffer for Time Events from CC1 | 29 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
96 | COIFT | Interface to Activity Allocation | 44 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
97 | PTEX2000 | Interface Table for Attendances/Absences Infotype(2001/2002) | 54 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
98 | PTEX2003GEN | Interface Table for IT 2003: General Information | 53 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
99 | PTEX2003SPEC | Interface Table for IT 2003: Interval Information | 29 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
100 | PTEX2010 | Interface Table for EE Remuneration Info. Infotype (2010) | 53 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
101 | TEVEN_MORE | Additional Data for Time Events | 36 | VORNR | Operation number | nvarchar | 4 | 0 | | |
TOPPlant Data Collection |
102 | RUECK | Temp. storage for subsystem confirmations | 19 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
TOPPlant Maintenance |
103 | Z9I_STK_IF_NPV | PM/PS-Schnittstelle: Netzplanvorgänge | 7 | VORNR | Vorgangsnummer | nvarchar | 4 | 0 | | |
104 | Z9I_STK_IF_NPV_W | PM/PS-Schnittstelle: Netzplanvorgänge Werkstattsicht | 7 | VORNR | Vorgangsnummer | nvarchar | 4 | 0 | | |
105 | Z9I_STK_VORGANG | Terminkontrolle Stillstandsplanung: Relevante Vorgänge | 14 | VORNR | Vorgangsnummer | nvarchar | 4 | 0 | | |
106 | Z9MIANF | Stillstanndsplanung - Daten für Anfragen | 12 | VORNR | Vorgangsnummer | nvarchar | 4 | 0 | | |
TOPPosition Budgeting and Control |
107 | HRFPM_DIFFERENCE | HRFPM: Personnel Costs Savings/ Overrun | 35 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
108 | HRFPM_FM_POS | HRFPM: FM Documents - Items | 19 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
109 | HRFPM_FM_POS_BU | HRFPM: FM Documents - Items for Budget | 20 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
110 | HRFPM_FPM_POS | HRFPM: FPM Documents - Items | 33 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
111 | HRFPM_FPM_POS_BU | HRFPM: FPM Documents - Items for Budget | 34 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
112 | HRFPM_OBJECTS | HRFPM: Object table of the commitment engine | 29 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
TOPProcess Management |
113 | COCQ | PPPI/QM Integration: Buffer Table for Reporting Results | 4 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
114 | COFT | Process Management: Process Instructions in Control Recipe | 5 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
115 | COMQ | Temporary Storage for Material Production Messages for QM | 7 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
TOPProduct Cost Planning |
116 | CKIS | Items Unit Costing/Itemization Product Costing | 89 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
TOPProduction Orders |
117 | AFVC | Operation within an order | 11 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
118 | COWIPB_CHVW | WIP Batches with Where-Used List | 28 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
119 | ORDCOM | Communication control Operation download | 8 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
120 | ORDLY | Table of delays for production order | 5 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
TOPProject System |
121 | PSHLPDB_HIER_TMP | Table to store temporary hierarchy data | 11 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
122 | PSHLP_HIER_DB | Local cache:Project/Independent Network hierarchy | 11 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
TOPPurchasing |
123 | EKCPA | Purchasing Contract Commitment Plan Account Assignment Data | 16 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
TOPQuality Inspection |
124 | TQ30 | Inspection types | 16 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
TOPRemote Logistics Management |
125 | OIO_RT_RTDOC_MT | Returns document - material items | 18 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
TOPRepetitive Manufacturing |
126 | COMPMOVE | Goods Movement of Components | 120 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
127 | RMRP | HR Data of Repetitive Manufacturing Backflush | 6 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
TOPResults Recording |
128 | QEWL | QM Handheld: Worklist for Transfer | 6 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
129 | QIWL | Transfer table for QM subsystems | 5 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
TOPRouting |
130 | PLPO | Task list - operation/activity | 16 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
TOPSamples and SPC |
131 | QASH | Quality control chart | 34 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
TOPScheduling |
132 | KBED | Capacity Requirements Records | 48 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
TOPSelf-Service Procurement |
133 | /SRMERP/D_ACC_IT | Account assignment item | 45 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
TOPSimulation |
134 | VSAFVC_CN | Version: Operation in order | 12 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
135 | VSKBED_CN | Version: Capacity requirement records | 49 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
136 | VSRESB_CN | Version: Reservation/Dependent requirements | 100 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
TOPSocial Insurance |
137 | T5D3P | HR Technical Assignments for Workers' Compensation Assoc. | 8 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
TOPStructures |
138 | PSPR_GRP_IND_PR | Grouping Indicators and purchase requisition numbers | 5 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
139 | PSPR_GR_IND_REL | Assignment of group indicator data | 5 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
140 | PSSKF_RATES_TAB | Save the SKF rates for the calculation of the work duration. | 11 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
TOPTime Sheet |
141 | CATS_TEMP | CATS: Database Table for Templates | 75 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
TOPTime Tickets |
142 | EVHR | HR Order Confirmations (Times/Time Events) | 36 | VORNR | Operation number | nvarchar | 4 | 0 | | |
143 | LSHR | HR Order Confirmations (Durations/Time Tickets) | 36 | VORNR | Operation number | nvarchar | 4 | 0 | | |
TOPTravel Expenses |
144 | PTRV_DOC_IT | Transfer Travel -> FI/CO: Lines of TRV interm. document | 21 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
TOPTravel Planning |
145 | FTPT_REQ_ACCOUNT | Travel Request Cost Assignment | 16 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
TOPVehicle Management System |
146 | VLCSMORDNOT | VELO : Link Between Service Notif. and Service Order | 6 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | |
TOPWork Clearance Management |
147 | WCAAP | WCM: Application | 38 | VORNR | Activity number replaced by sub-network | nvarchar | 4 | 0 | | |
148 | WCAHE | WCM: Work Clearance Document (Header) | 38 | VORNR | Activity number replaced by sub-network | nvarchar | 4 | 0 | | |
149 | WCAW | WCM: Work Approval | 36 | VORNR | Activity number replaced by sub-network | nvarchar | 4 | 0 | | |