| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | P2B2_C1 | HCM Declustering B2 - Cost Distribution Table C1 | 46 | SGRANT_NBR | Sender Grant | nvarchar | 20 | 0 | | |
2 | P2PL_RETROADJ | Payroll Result PL: Retro, originals and changes | 56 | SGRANT_NBR | Sender Grant | nvarchar | 20 | 0 | | |
3 | P2PL_RETRODIF | Payroll Result PL: Retro, originals and changes | 56 | SGRANT_NBR | Sender Grant | nvarchar | 20 | 0 | | |
4 | P2PL_RETROMEM | Payroll Result PL: Retro, originals and changes | 56 | SGRANT_NBR | Sender Grant | nvarchar | 20 | 0 | | |
5 | P2RG_COSTS | Distribution of Employer's Cost (Payroll Function XDEC) | 63 | SGRANT_NBR | Sender Grant | nvarchar | 20 | 0 | | |
6 | P2RT_CZDAV | P18_03 | 47 | SGRANT_NBR | Sender Grant | nvarchar | 20 | 0 | | |
7 | P2RU_COSTS | Distribution of Employer's Cost (Payroll Function XDEC) | 63 | SGRANT_NBR | Sender Grant | nvarchar | 20 | 0 | | |
8 | P2RX_C1 | Cost Distribution Table C1 | 44 | SGRANT_NBR | Sender Grant | nvarchar | 20 | 0 | | |
TOPConstruction Industry |
9 | T5DBV | Construction Pay: Cost Assignment: Hostels | 43 | SGRANT_NBR | Sender Grant | nvarchar | 20 | 0 | | |
10 | T5DBX | Construction Pay: Incentive Wage Connection | 43 | SGRANT_NBR | Sender Grant | nvarchar | 20 | 0 | | |
TOPControlling |
11 | COPPP_ITM | CO Postprocessing List - Items | 23 | SGRANT_NBR | Sender Grant | nvarchar | 20 | 0 | | |
TOPCost Element Accounting |
12 | COFIP | Single plan items for reconciliation ledger | 32 | SGRANT_NBR | Sender Grant | nvarchar | 20 | 0 | | |
13 | COFIS | Actual line items for reconciliation ledger | 32 | SGRANT_NBR | Sender Grant | nvarchar | 20 | 0 | | |
14 | COFIT | Totals Records for Reconciliation Ledger | 31 | SGRANT_NBR | Partner Grant | nvarchar | 20 | 0 | | |
TOPFund Accounting |
15 | FMGLFLEX06 | General ledger: Sender SAP additional account assignment | 6 | SGRANT_NBR | Partner Grant | nvarchar | 20 | 0 | | |
16 | FMGLFLEXA | General Ledger: Actual Line Items | 24 | SGRANT_NBR | Partner Grant | nvarchar | 20 | 0 | | |
17 | FMGLFLEXP | General Ledger: Plan Line Items | 26 | SGRANT_NBR | Partner Grant | nvarchar | 20 | 0 | | |
18 | FMGLFLEXT | General Ledger Public Sector: Total | 33 | SGRANT_NBR | Partner Grant | nvarchar | 20 | 0 | | |
19 | PSGLFLEX06 | General ledger: Sender SAP additional account assignment | 6 | SGRANT_NBR | Partner Grant | nvarchar | 20 | 0 | | |
20 | PSGLFLEXA | General Ledger: Actual Line Items | 26 | SGRANT_NBR | Partner Grant | nvarchar | 20 | 0 | | |
21 | PSGLFLEXP | General Ledger: Plan Line Items | 28 | SGRANT_NBR | Partner Grant | nvarchar | 20 | 0 | | |
22 | PSGLFLEXT | General Ledger Public Sector: Total | 35 | SGRANT_NBR | Partner Grant | nvarchar | 20 | 0 | | |
TOPFunds Management |
23 | FMCHA1 | Work List for Reassignment Tool | 22 | SGRANT_NBR | Grant | nvarchar | 20 | 0 | | |
24 | FMSPLITA | Actual line item table | 31 | SGRANT_NBR | Partner Grant | nvarchar | 20 | 0 | | |
25 | FMSPLITP | Plan line items table | 31 | SGRANT_NBR | Partner Grant | nvarchar | 20 | 0 | | |
26 | FMSPLITT | Summary table | 32 | SGRANT_NBR | Partner Grant | nvarchar | 20 | 0 | | |
TOPMaster Data |
27 | GMOMD | Grants Management Object Mapper Table | 7 | SGRANT_NBR | Incoming Grant | nvarchar | 20 | 0 | | |
TOPPayroll |
28 | T5TPSC1SPLIT | Rozdelení nákladu | 54 | SGRANT_NBR | Grant-odesilatel | nvarchar | 20 | 0 | | |
TOPPersonnel Time Management |
29 | ASSOB | Assignment Objects | 42 | SGRANT_NBR | Sender Grant | nvarchar | 20 | 0 | | |
30 | COIFT | Interface to Activity Allocation | 74 | SGRANT_NBR | Sender Grant | nvarchar | 20 | 0 | | |
31 | PTEX2000 | Interface Table for Attendances/Absences Infotype(2001/2002) | 76 | SGRANT_NBR | Sender Grant | nvarchar | 20 | 0 | | |
32 | PTEX2003GEN | Interface Table for IT 2003: General Information | 75 | SGRANT_NBR | Sender Grant | nvarchar | 20 | 0 | | |
33 | PTEX2003SPEC | Interface Table for IT 2003: Interval Information | 51 | SGRANT_NBR | Sender Grant | nvarchar | 20 | 0 | | |
34 | PTEX2010 | Interface Table for EE Remuneration Info. Infotype (2010) | 75 | SGRANT_NBR | Sender Grant | nvarchar | 20 | 0 | | |
TOPTravel Planning |
35 | FTPT_REQ_ACCOUNT | Travel Request Cost Assignment | 46 | SGRANT_NBR | Sender Grant | nvarchar | 20 | 0 | | |