| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /ATL/FORDOCSPLIT | Document Header and Line details for Splitting | 5 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
2 | /OPT/VIM_1ITEM_S | Document Item | 32 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
3 | /OPT/VIM_TITEM | Document Item | 32 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
4 | BSAD_BAK | Accounting: Secondary index for customers (cleared items) | 96 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
5 | BSAK_BAK | Accounting: Secondary Index for Vendors (Cleared Items) | 100 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
6 | BSAS_BAK | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 65 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
7 | BSEG | Accounting Document Segment | 221 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
8 | BSID_BAK | Accounting: Secondary Index for Customers | 96 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
9 | BSIK_BAK | Accounting: Secondary index for vendors | 100 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
10 | BSIS_BAK | Accounting: Secondary Index for G/L Accounts | 65 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
11 | BSSEG | Accounting Document Segment | 210 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
12 | CNV_20100_SKB1 | CNV backup copy for SKB1 | 36 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
13 | FAGLBSAS_BAK | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 65 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
14 | FAGLBSIS_BAK | Accounting: Secondary Index for G/L Accounts | 65 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
15 | FIAPSAD_ADPSF | Settelement Details for KSA | 11 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
16 | FIAPSAD_ORDR_LT | Line Item for Order Number KSA | 22 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
17 | FMADB_DEFAULT_AA | FMADB: Default Account Assignment for Petty Amounts | 4 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
18 | FUDT_VDOCBSEG | Verification Document Item with Additional Info | 210 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
19 | FUDT_VDOCBSEGEV | Verification Document Item in the Entry View | 210 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
20 | FUDT_VDOCBSEGH | Verification Document Segment with Additional Info(History) | 210 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
21 | GLPOS_C_CT | FI Document: Entry View | 114 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
22 | GLPOS_C_DEB_CT | GLPOS_C_CT Customer Line Items | 114 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
23 | GLPOS_C_GL_CT | GLPOS_C_CT G/L Line Items | 114 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
24 | GLPOS_C_VEN_CT | GLPOS_C_CT Vendor Line Items | 114 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
25 | GLPOS_N_CT | New General Ledger: Line Item with Currency Type | 116 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
26 | GLPOS_N_GL_CT | New General Ledger: Line Item with Currency Type | 116 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
27 | P2B2_C1 | HCM Declustering B2 - Cost Distribution Table C1 | 22 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
28 | P2B2_CWST | HCM Declustering B2 - PDC Time Tickets | 129 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
29 | P2B2_WST | HCM Declustering B2 - PDC Time Tickets | 129 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
30 | P2PL_RETROADJ | Payroll Result PL: Retro, originals and changes | 32 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
31 | P2PL_RETRODIF | Payroll Result PL: Retro, originals and changes | 32 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
32 | P2PL_RETROMEM | Payroll Result PL: Retro, originals and changes | 32 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
33 | P2RG_COSTS | Distribution of Employer's Cost (Payroll Function XDEC) | 39 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
34 | P2RT_CZDAV | P18_03 | 23 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
35 | P2RU_COSTS | Distribution of Employer's Cost (Payroll Function XDEC) | 39 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
36 | P2RX_C1 | Cost Distribution Table C1 | 20 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
37 | REGUP | Processed items from payment program | 97 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
38 | YVIM_1ITEM | Document Item | 32 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
39 | ZEIM_LIPS | SD document: Delivery: Item data | 117 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
40 | ZSAFI | Zuordnung Sako-Fipo | 5 | FIPOS | Finanzposition | nvarchar | 14 | 0 | | |
TOPAccounting Interface |
41 | GLE_FI_ITEM_MODF | ECS: Modified FI Line Items (Header/Item/Currency Data) | 181 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
42 | GLE_FI_ITEM_ORIG | ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F) | 181 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
TOPActual CostingMaterial Ledger |
43 | MLCO | Material valuation document account assignment information | 10 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
TOPBasic Functions |
44 | SKB1 | G/L account master (company code) | 35 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
45 | SKM1 | Sample G/L accounts | 33 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
TOPConfirmations |
46 | AFRV | Confirmation pool | 30 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
47 | AFRV_DEL | Backup Copy for Confirmation Pool | 30 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
TOPConstruction Industry |
48 | T5DBV | Construction Pay: Cost Assignment: Hostels | 19 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
49 | T5DBX | Construction Pay: Incentive Wage Connection | 19 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
TOPCross-Application Components |
50 | BBSID | Accounting: Secondary index for customers | 96 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
TOPData Transfer |
51 | PPDIT | Transfer to Accounting: Lines in HR IDOCs | 26 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
52 | PPDST | Transfer to Accounting: Substituted Acc. Assig. Object | 15 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
TOPDefense Forces and Public Security |
53 | /ISDFPS/ZEBAN | Copy of EBAN | 85 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
TOPElectronic Bank Statement |
54 | FEB_ACCNT_SAVE | Saving of Posting Lines for Postprocessing (Account Assign.) | 57 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
55 | FEB_ACT | Acct Assignment Templates | 57 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
TOPExpense-Related Billing |
56 | PRSD_DMRP_ACC_CH | Engagement Mgmt: Accrual Characteristics for DMR Lines | 14 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
TOPExternal Services |
57 | ESKN | Account Assignment in Service Package | 33 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
TOPFinancial Accounting |
58 | /OPT/VIM_1ITEM | Document Item | 32 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
59 | ACCTIT | Compressed Data from FI/CO Document | 102 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
60 | BSAD | Accounting: Secondary Index for Customers (Cleared Items) | 96 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
61 | BSAK | Accounting: Secondary Index for Vendors (Cleared Items) | 100 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
62 | BSAS | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 65 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
63 | BSID | Accounting: Secondary Index for Customers | 96 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
64 | BSIK | Accounting: Secondary Index for Vendors | 100 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
65 | BSIS | Accounting: Secondary Index for G/L Accounts | 65 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
66 | KMZEI | FI: Account Assignment Model Item Information | 54 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
67 | KOMU | Account Assignment Templates for G/L Account Items | 54 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
68 | VBSEGA | Document Segment for Document Parking - Asset Database | 35 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
69 | VBSEGD | Document Segment for Customer Document Parking | 86 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
70 | VBSEGK | Document Segment for Vendor Document Parking | 100 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
71 | VBSEGS | Document Segment for Document Parking - G/L Account Database | 85 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
TOPFreight Processing |
72 | VFKN | Account Determination in Shipment Costs Item | 32 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
TOPFund Accounting |
73 | FMPPFUND | Items for Partial Payment by Fund Process | 10 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
TOPFunds Management |
74 | FM01S | Additional master data for budgeting tools | 4 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
75 | FMAVC | is being deleted | 3 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
76 | FMCFSIF | FI-FM: Selected Open Documents from FI Update | 26 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
77 | FMCFSIO | FI-FM: Selected Open Commitment Documents | 29 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
78 | FMCFSIO_TR | FI-FM: Selected Open Commitment Documents | 29 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
79 | FMCI | Commitment items master data | 34 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
80 | FMCOPI | CO-FM: Plan Data Transfer - Annual/Overall Values | 13 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
81 | FMDECK3 | Cover eligibility: amount management for sender budget obj. | 5 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
82 | FMFPO | FIFM: Commitment Item | 3 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
83 | FMFPOT | Texts for a Financia Management Item | 4 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
84 | FMFXPO | Commitment item, internal and external number (conversion) | 2 | FIPOS | Commitment item | nvarchar | 14 | 0 | | |
85 | FMICOIT | FM/CO integration: Line item | 9 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
86 | FMPP | Commitment Item in Chart of Commitment Items | 10 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
87 | FMRC_BSEG | Reconciliation of Lines from FI | 8 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
88 | FMVORTR | Cmmt items for carryover item category of totals records | 5 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
89 | FMWF_BDGRP | FM Account Groups for FM Role Definition | 5 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
90 | FMZUCH | Change information on allocation of CO Object to FM Object | 10 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
91 | FMZUGR | Allocation of CO Group to FM Account Assignment | 10 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
92 | FMZUKA | Allocation of Cost Element to FM Account Assignment | 7 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
93 | FMZUOB | Allocation of CO Object to FM Account Assignment | 8 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
94 | KBLP | Document Item: Manual Document Entry | 22 | FIPOS | Commitment item | nvarchar | 14 | 0 | | |
95 | TBPFM | FM Active Availability Control | 4 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
96 | TBPW1 | is being deleted | 5 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
TOPFunds Management-Specific Postings |
97 | FMFUNDTRANSYEAR | Additional Documents for Funds Transfer to Diff. Years | 84 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
98 | FMPSO_ACQU_TAX | Table of Commitment Items that Represent Acquisition Taxes | 2 | FIPOS | Commitment Item | nvarchar | 24 | 0 | | |
99 | PSOSEGA | Document Segment for Assets Document Parking | 36 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
100 | PSOSEGD | Document Segment: Recurring Request, Customer | 87 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
101 | PSOSEGK | Recurring Request Document Segment, Vendors | 101 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
102 | PSOSEGS | Recurring Request Document Segment, G/L Accounts | 83 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
TOPGeneral Ledger Accounting |
103 | BSEG_ADD | Entry View of Accounting Document for Additional Ledgers | 43 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
104 | FAGLBSAS | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 65 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
105 | FAGLBSIS | Accounting: Secondary Index for G/L Accounts | 65 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
106 | FAGL_SPLINFO | Splittling Information of Open Items | 29 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
TOPGL Account Posting |
107 | TCJ_POSITIONS | Cash Journal Document Items | 64 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
TOPInventory Management |
108 | MSEG | Document Segment: Material | 119 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
109 | MWXMSEG | ZMSEG: Interface for Posting of Value | 119 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
110 | MWZMSEG | ZMSEG:Interface for Posting of Value | 119 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
111 | RESB | Reservation/dependent requirements | 178 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
112 | RKPF | Document Header: Reservation | 35 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
TOPInvoice Verification |
113 | RBCO | Document Item, Incoming Invoice, Account Assignment | 12 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
TOPLocal Currency Changeover |
114 | EWUFI_SCA | EMU conversion: Table of the clearings to be adjusted | 24 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
TOPMaterials Management |
115 | /ISDFPS/CS_EXLST | Exception List: Overwritten Purchase Requisitions | 90 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
TOPPayment Transactions |
116 | CRACC | Payment Cards: Account Assignments in Card Master Record | 23 | FIPOS | Commitment item | nvarchar | 14 | 0 | | |
117 | CRNUM | Payment cards: Card master record | 44 | FIPOS | Commitment item | nvarchar | 14 | 0 | | |
TOPPayroll |
118 | T5TPSC1SPLIT | Rozdelení nákladu | 30 | FIPOS | Rozpoctová položka | nvarchar | 14 | 0 | | |
TOPPersonnel Time Events |
119 | TPTCOR_KOSTL | Cost Assignment (Correction Scenario) | 20 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
TOPPersonnel Time Management |
120 | ASSOB | Assignment Objects | 18 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
121 | CC1ERP | Incorrect Time Events from CC1, Postings | 119 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
122 | COIFT | Interface to Activity Allocation | 50 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
123 | PTEX2000 | Interface Table for Attendances/Absences Infotype(2001/2002) | 59 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
124 | PTEX2003GEN | Interface Table for IT 2003: General Information | 58 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
125 | PTEX2003SPEC | Interface Table for IT 2003: Interval Information | 34 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
126 | PTEX2010 | Interface Table for EE Remuneration Info. Infotype (2010) | 58 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
127 | TEVEN_MORE | Additional Data for Time Events | 118 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
TOPPlant Data Collection |
128 | RUECK | Temp. storage for subsystem confirmations | 25 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
TOPPurchasing |
129 | EBAN | Purchase Requisition | 85 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
130 | EBKN | Purchase Requisition Account Assignment | 35 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
131 | EKCPA | Purchasing Contract Commitment Plan Account Assignment Data | 9 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
132 | EKKN | Account Assignment in Purchasing Document | 38 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
133 | EKPO | Purchasing Document Item | 99 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
134 | MEREQX | Purchase Requisition Change Parameter | 85 | FIPOS | Updated information in related user data field | nvarchar | 1 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
135 | /BEV3/CH1030BSG1 | Document Segment CH Event Ledger Part1 | 212 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
TOPRepetitive Manufacturing |
136 | COMPMOVE | Goods Movement of Components | 121 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
TOPRevenues and Earnings |
137 | AD01DLI | Dynamic items (DI) | 13 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
TOPSelf-Service Procurement |
138 | /SRMERP/D_ACC_IT | Account assignment item | 32 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
TOPShipping |
139 | LIPS | SD document: Delivery: Item data | 117 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
TOPSimulation |
140 | VSEBAN_CN | Version: Purchase requisition | 85 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
141 | VSEBKN_CN | Version: Purchase requisition account assignment | 36 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
142 | VSRESB_CN | Version: Reservation/Dependent requirements | 182 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
TOPTechnical Application Support |
143 | CNV_20425_SCA | EMU conversion: Table of the clearings to be adjusted | 21 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
TOPTravel Expenses |
144 | PTRV_DOC_IT | Transfer Travel -> FI/CO: Lines of TRV interm. document | 25 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
TOPTravel Planning |
145 | FTPT_REQ_ACCOUNT | Travel Request Cost Assignment | 22 | FIPOS | Commitment Item | nvarchar | 14 | 0 | | |
TOPTreasury |
146 | FLQLPOS_FIPOS | Relationship: Liquidity Items - Commitment Items | 4 | FIPOS | Liquidity Calculation: Short Commitment Item | nvarchar | 10 | 0 | | |