| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /BIC/B0000172000 | PSA for 0FI_GL_14 T90CLNT090 Gen. Ledger: Items | 155 | PS_PSP_PNR | | nvarchar | 8 | 0 | | |
2 | /SMERP/STG_PM001 | Data staging - Equipment complex table | 194 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
3 | /SMERP/STG_PM003 | Data staging - Equipment List Set - Hdr - complex tab | 188 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
4 | CNVCMIS_M_VMPAA | CMIS: Temp. Generated Pooltable for Matchcode Id VMPA-A | 2 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
5 | CNVCMIS_M_VMPAB | CMIS: Temp. Generated Pooltable for Matchcode ID VMPA B | 4 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
6 | CNVTDMS_05_VMPA | Collector table for Work Breakdown Structure Element | 3 | PS_PSP_PNR | PS_PSP_PNR for VMPA | nvarchar | 8 | 0 | | |
7 | GLPCA_CT | Profit Center Documents | 95 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
8 | GLPCA_T_CT | Profit Center Documents | 111 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
9 | S550E | S550 - Structural Information | 5 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
10 | ZEIM_LIPS | SD document: Delivery: Item data | 106 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
11 | ZEIM_VBAK | Sales Document: Header Data | 60 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
12 | ZEIM_VBAP | Sales Document: Item Data | 134 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
13 | T7PIQSINGLEFEES | Define Attributes for Individual Fees | 18 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
14 | TCMAC06D | Derivation of ISR Scenario Related Data | 18 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
TOPAccounting Interface |
15 | GLE_FI_ITEM_MODF | ECS: Modified FI Line Items (Header/Item/Currency Data) | 174 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
16 | GLE_FI_ITEM_ORIG | ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F) | 174 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
TOPActual CostingMaterial Ledger |
17 | MLCO | Material valuation document account assignment information | 22 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
TOPAgency Business Global Trade |
18 | WBRP | Agency business: Item | 143 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
TOPAlternative Valuation Run |
19 | CKMLAVRDOCIT | Lines for Cumulation Posting Document | 45 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
TOPBilling |
20 | VBRP | Billing Document: Item Data | 103 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
TOPConfirmations |
21 | AFFW | Goods Movements with Errors from Confirmations | 62 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
TOPConstruction Equipment Management |
22 | /SAPCEM/PSKOKM | WBS Element per Controlling Area for Material Sales | 3 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
23 | /SAPCEM/PSPBUKRS | CEM Assignment WBS Element to Company Code | 3 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
TOPConstruction Progress Report |
24 | /SAPPCE/TPNV | Construction Progress Report | 3 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
25 | /SAPPCE/TPNV02 | WBS Elements for which a CPR has been created | 2 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
TOPContract Accounts Receivable and Payable |
26 | DFKKDEFREV_POS | Line Item Table (Event-Based Deferred Revenues) | 35 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
27 | DFKKFMBGAINFO | Tax Information for Public-Owned Commercial Operations | 17 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
28 | DFKKMOPK | Items in contract account document | 14 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
29 | DFKKOPK | Items in contract account document | 14 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
30 | DFKKORDERPOS | Requests: Items | 51 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
31 | DFKKORDERPOS_S | Request Templates: Items | 45 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
32 | DFKKSUM | Posting totals from FI-CA | 23 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
33 | DFKKSUMOLD | Totals Records Without Account Assignment Changes | 10 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
34 | DFKK_VT_I | CT: Items of Provider Contract | 43 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
35 | FKKDEFREV | Trigger Table for Deferred Revenue Postings | 23 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
36 | TECOD | IS-U: CO account assignment key / allocation | 12 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
37 | TFKCOD | FI-CA: CO Account Assignment Key/Allocation | 10 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
TOPContract Billing |
38 | DBERCHZ | Individual Line Items | 133 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
39 | DBERCHZ3 | Individual line items (amount and price data) | 25 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
40 | DBERCHZ7 | Document line items (amount/price data, unimportant rows) | 25 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
TOPCross-Application Components |
41 | VVBAK | Sales Document: Header Data | 60 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
42 | VVBAP | Sales Document: Item Data | 134 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
TOPData Collection |
43 | S008 | Communications Table SD -> CO/Projects | 36 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
44 | S409 | Contract & Billing | 14 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
45 | S409E | S409 - Structure Information | 9 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
46 | S550 | Info Structure 06 | 10 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
TOPData Retention Tool |
47 | TXW_S_MSEG | Retrieve MSEG from archive | 47 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
TOPElectronic Bank Statement |
48 | FEB_ACCNT_SAVE | Saving of Posting Lines for Postprocessing (Account Assign.) | 31 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
49 | FEB_ACT | Acct Assignment Templates | 31 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
TOPExternal Services |
50 | ESKN | Account Assignment in Service Package | 27 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
TOPFinancial Accounting |
51 | ACCRFI | Accruals/Deferrals Master Data FI/CO Account Assignment | 10 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
52 | ACCTIT | Compressed Data from FI/CO Document | 66 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
53 | T076K | FI-EDI: Additional Account Assignments | 14 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
54 | VBSEGA | Document Segment for Document Parking - Asset Database | 33 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
55 | VBSEGS | Document Segment for Document Parking - G/L Account Database | 78 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
TOPFreight Processing |
56 | VFKN | Account Determination in Shipment Costs Item | 25 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
TOPFunds Management |
57 | FIWF_ACGRP | Account Assignment Groups for Role Definition | 9 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
TOPFunds Management-Specific Postings |
58 | FMFUNDTRANSYEAR | Additional Documents for Funds Transfer to Diff. Years | 77 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
59 | PSOSEGA | Document Segment for Assets Document Parking | 34 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
60 | PSOSEGS | Recurring Request Document Segment, G/L Accounts | 76 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
TOPGeneral Ledger Accounting |
61 | FAGL_SPLINFO | Splittling Information of Open Items | 28 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
TOPGeneral Ledger Reorganization |
62 | FAGL_R_SPL | Reorganization: Splitting Information of the Open Items | 32 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
TOPGL Account Posting |
63 | TCJ_POSITIONS | Cash Journal Document Items | 38 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
TOPIntercompany Data Exchange |
64 | TINV_INV_LINE_B | Bill Line with Posting Information | 29 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
65 | TINV_INV_LINE_I | Bill Line Item with Information (Not Relevant to Posting) | 29 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
66 | TINV_INV_TRANSF | Transfer Table for Bill Data to FI-CA | 33 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
67 | TINV_LINEB_SHORT | Extract of Bill Receipt (Evaluation System): Bill Lines | 26 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
TOPInventory Management |
68 | ISEG | Physical Inventory Document Items | 42 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
69 | MSEG | Document Segment: Material | 113 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
70 | MWXMSEG | ZMSEG: Interface for Posting of Value | 113 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
71 | MWZMSEG | ZMSEG:Interface for Posting of Value | 113 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
72 | RKPF | Document Header: Reservation | 30 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
TOPInvoice Verification |
73 | RBCO | Document Item, Incoming Invoice, Account Assignment | 24 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
TOPInvoicing |
74 | DBERDZ | DB Table: Individ. Lines - Print Document | 159 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
TOPJapan |
75 | T7JPSK_CONTT | Shukko Contract Template | 11 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
TOPLocalization |
76 | J_1BNFLIN | Nota Fiscal line items | 91 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
TOPLogistics - General |
77 | WBHI | Trading Contract: Item Data | 135 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
78 | WBHK | Trading Contract: Header Data | 101 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
TOPMaintenance Orders |
79 | AUFM | Goods movements for order | 36 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
TOPMaster Data |
80 | EVER | IS-U Cont. | 42 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
TOPMaterial |
81 | LFINF | Delivery information Project System | 13 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
82 | RSPSP | Index: Reservations for WBS elements/Sales order items | 5 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
TOPMaterials Management |
83 | J_1GVL_ML | Material Ledger | 90 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
TOPOverhead Cost Orders |
84 | COBRB | Distribution Rules Settlement Rule Order Settlement | 36 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
TOPPayment Transactions |
85 | CRACC | Payment Cards: Account Assignments in Card Master Record | 28 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
86 | CRNUM | Payment cards: Card master record | 49 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
TOPPeriodical Sales and Distribution |
87 | JLRP | IS-M/SD: Item Data for Settlement | 52 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
TOPProfit Center Accounting |
88 | GLPCA | EC-PCA: Actual Line Items | 71 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
89 | GLPCP | EC-PCA: Plan Line Items | 129 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
TOPProject System |
90 | VMPA | Selection Methods for Search Help VMPA | 2 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
TOPPurchasing |
91 | EBKN | Purchase Requisition Account Assignment | 29 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
92 | EKCPA | Purchasing Contract Commitment Plan Account Assignment Data | 21 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
93 | EKKN | Account Assignment in Purchasing Document | 32 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
TOPQuality Inspection |
94 | QALS | Inspection lot record | 109 | PS_PSP_PNR | Valuated Sales Order Stock WBS Element | nvarchar | 8 | 0 | | |
TOPQuality Notifications |
95 | TQ8CO | Assignment of reference orders to notification type | 9 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
TOPReal Estate Localization Czech Republic |
96 | /CEERE/SDANP | Property tax - master | 120 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
TOPReal Estate Management |
97 | VIAKBSEG | Document Line Item from SCS for Interface | 169 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
98 | VIMI17 | RE: Adjustment Run Header | 21 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
99 | VIMI29 | Maintenance orders - Modernization measure allocation | 4 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
100 | VIMI30 | Allocation of WBS elements to modernization measure | 3 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
101 | /BEV1/RBVBAK | Sales Document: Header Data | 60 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
102 | /BEV1/RBVBAP | Sales Document: Item Data | 134 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
TOPRemote Logistics Management |
103 | OIO_RT_RTDOC_MT | Returns document - material items | 15 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
TOPRepetitive Manufacturing |
104 | COMPMOVE | Goods Movement of Components | 115 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
TOPRevenue recognition |
105 | VBREVAC | Revenue Recognition: Compression of FI Revenue Postings | 8 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
106 | VBREVE | Revenue Recognition: Revenue Recognition Lines | 25 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
107 | VBREVK | Revenue Recognition: Control Lines | 26 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
TOPSales |
108 | VBAK | Sales Document: Header Data | 60 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
109 | VBAP | Sales Document: Item Data | 134 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
TOPSelf-Service Procurement |
110 | /SRMERP/D_ACC_IT | Account assignment item | 26 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
TOPSerial Numbers |
111 | EQBS | Serial Number Stock Segment | 12 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
TOPShipping |
112 | LIPS | SD document: Delivery: Item data | 106 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
TOPSimulation |
113 | VSEBKN_CN | Version: Purchase requisition account assignment | 30 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
114 | VSVBAK_CN | Version: Sales document: Header data | 61 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
115 | VSVBAP_CN | Version: Sales document: Item data | 135 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
TOPWaste Management |
116 | EHSWAT001ACC | MD (BDT): Generator/Disposer/Transporter - Accnt Assignment | 24 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
117 | EHSWAT_ENACC | Disposal Processing: Account Assignments for Entry Document | 21 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
118 | EHSWAT_MNACC | Account Assignments for Disposal Document | 20 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |