| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /1RA/0SD030MI | Items for Class SD03 - Raw Data | 27 | DUE_DATE | Invoice Due Date | nvarchar | 8 | 0 | | |
2 | /1RA/0SD032MI | Items for Class SD03 - Processable | 28 | DUE_DATE | Invoice Due Date | nvarchar | 8 | 0 | | |
3 | /1RA/0SD034MI | Items for Class SD03 - Processed | 29 | DUE_DATE | Invoice Due Date | nvarchar | 8 | 0 | | |
4 | /IBS/TRB_ECF_HD | RBD ECF - Value Adjustment Header Data | 5 | DUE_DATE | RBD: Valuation Date | nvarchar | 8 | 0 | | |
5 | /IBS/TRB_ECF_PCF | RBD ECF - Provision Cash Flow | 4 | DUE_DATE | RBD: Due Date | nvarchar | 8 | 0 | | |
6 | /IBS/TRB_ECF_PCO | RBD ECF - Provision Collateral | 4 | DUE_DATE | RBD: Date, Recovery Time | nvarchar | 8 | 0 | | |
7 | /IBS/TRB_ECF_PUT | RBD ECF - Provision Utilization | 4 | DUE_DATE | RBD: Due Date | nvarchar | 8 | 0 | | |
8 | /IBS/TRB_ECF_VCF | RBD ECF - Value Adjustment - Cash Flow | 4 | DUE_DATE | RBD: Due Date | nvarchar | 8 | 0 | | |
9 | /IBS/TRB_ECF_VCO | RBD ECF - Value Adjustment - Collateral | 4 | DUE_DATE | RBD: Date, Recovery Time | nvarchar | 8 | 0 | | |
10 | /IBS/TRB_ECH_HD | RBD ECF - Value Adjustment History - Header Data | 6 | DUE_DATE | RBD: Valuation Date | nvarchar | 8 | 0 | | |
11 | /IBS/TRB_ECH_PCF | RBD ECF - Provision History - Cash Flow | 5 | DUE_DATE | RBD: Due Date | nvarchar | 8 | 0 | | |
12 | /IBS/TRB_ECH_PCO | RBD ECF - Provision History - Collateral | 5 | DUE_DATE | RBD: Date, Recovery Time | nvarchar | 8 | 0 | | |
13 | /IBS/TRB_ECH_PUT | RBD ECF - Provision History - Utilization | 5 | DUE_DATE | RBD: Due Date | nvarchar | 8 | 0 | | |
14 | /IBS/TRB_ECH_VCF | RBD ECF - Value Adjustment History - Cash Flow | 5 | DUE_DATE | RBD: Due Date | nvarchar | 8 | 0 | | |
15 | /IBS/TRB_ECH_VCO | RBD ECF - Value Adjustment History - Collateral | 5 | DUE_DATE | RBD: Date, Recovery Time | nvarchar | 8 | 0 | | |
16 | /OPT/VT_KPI_SRC | Source Table for the Aggregations of the KPI Dashboard | 16 | DUE_DATE | Due Date | nvarchar | 8 | 0 | | |
17 | BOE_PLE_ITEM | Pledge item data table of BoE management | 25 | DUE_DATE | Pledge Due Date | nvarchar | 8 | 0 | | |
18 | EHHSSD_PCI_INQUI | Process Control - Inquiry | 21 | DUE_DATE | Task Due Date | nvarchar | 8 | 0 | | |
19 | EHHSSD_RPL_INQUI | Process Control - Mass Replace Controls - Inquiry | 21 | DUE_DATE | Task Due Date | nvarchar | 8 | 0 | | |
20 | EHPRCD_PSI_INQUI | Process Control - Inquiry | 22 | DUE_DATE | Task Due Date | nvarchar | 8 | 0 | | |
21 | FARR_D_INVOICE | Invoice Entries | 9 | DUE_DATE | Invoice Due Date | nvarchar | 8 | 0 | | |
22 | FIAPPLD_INV_DATE | Cleared Overdue Invoice Details (Poland) | 8 | DUE_DATE | Due Date | nvarchar | 8 | 0 | | |
23 | FIAPPTD_BALANCE | Table to store the Balances for Vendor/Customer/Bank Account | 21 | DUE_DATE | Due Date | nvarchar | 8 | 0 | | |
24 | FIAPPTD_TRANS | Table to store the transaction details of the CBR PT | 26 | DUE_DATE | Due Date | nvarchar | 8 | 0 | | |
25 | FMSAVE_RET | Save Retention Period for Archived Document | 12 | DUE_DATE | Date | nvarchar | 8 | 0 | | |
26 | GRFNCASEIS | Case table of Issue | 6 | DUE_DATE | End Date | nvarchar | 8 | 0 | | |
27 | GRFNMWRTINSTAPPL | MSMP Runtime - Application Specific Attributes | 8 | DUE_DATE | Due Date | nvarchar | 8 | 0 | | |
28 | GRRMOBAGRUN | Aggregation Run | 9 | DUE_DATE | Aggregation Run - Due Date | nvarchar | 8 | 0 | | |
29 | GRRMRESP | Response attributes | 4 | DUE_DATE | Response due date | nvarchar | 8 | 0 | | |
30 | GRRMRISKCONSORG | Orgnization hierarchy of Risk Consolidations | 6 | DUE_DATE | Date | nvarchar | 8 | 0 | | |
31 | GRRMRISKCONSPLAN | Infomation for one plan of risk consolidation. | 7 | DUE_DATE | Date | nvarchar | 8 | 0 | | |
32 | HRFPM_FM_POS_ARC | Archiving Status of Financing Documents | 6 | DUE_DATE | Due Date | nvarchar | 8 | 0 | | |
33 | QAM_L_BCV_A | QIM: Temporary Storage Activities f. Business Context Viewer | 16 | DUE_DATE | Due Date | nvarchar | 8 | 0 | | |
34 | THAEXT_EXPOS_COP | Obsolet: Commodity exposure pricing data | 7 | DUE_DATE | Due Date of an Exposure Position as a Differentiating Term | nvarchar | 8 | 0 | | |
35 | THAEXT_TRANS_COP | Commodity exposure pricing data | 21 | DUE_DATE | Due Date of an Exposure Position as a Differentiating Term | nvarchar | 8 | 0 | | |
36 | THAEXT_TRAN_DCSP | Commodity exposure DCS pricing data | 22 | DUE_DATE | Due Date of an Exposure Position as a Differentiating Term | nvarchar | 8 | 0 | | |
37 | HRT1890 | Table Part Infotype 1890 | 5 | DUE_DATE | Due Date | nvarchar | 8 | 0 | | |
TOPAccounts Receivable Accounting Process Integration |
38 | EBPP_ORDER_PAY | Payment Orders via Biller Direct: Payment Data | 8 | DUE_DATE | Date | nvarchar | 8 | 0 | | |
39 | FDM_INVOICE_MEM | Invoice Information Provided | 10 | DUE_DATE | Net Due Date | nvarchar | 8 | 0 | | |
TOPAuto-ID Infrastructure |
40 | /AIN/DM_DOC | Table with Document information. | 7 | DUE_DATE | Due Date | decimal | 15 | 0 | | |
TOPBack Office |
41 | TRFT_MAN_POST | Manual Posting | 9 | DUE_DATE | Due Date | nvarchar | 8 | 0 | | |
TOPBasic Functions |
42 | BIW_EMMA_CASE | Delta Queue for Process Statistics for Clarification Cases | 7 | DUE_DATE | Case Due Date | nvarchar | 8 | 0 | | |
43 | EMMA_CASE | Clarification Case | 23 | DUE_DATE | Case Due Date | nvarchar | 8 | 0 | | |
TOPBusiness Objects, Common Components |
44 | EHFNDD_PAM_AMTS | Specific Data for Amounts | 6 | DUE_DATE | Task Due Date | nvarchar | 8 | 0 | | |
TOPContract Accounts Receivable and Payable |
45 | FKK_FDT_EXPR000 | BFR/BPEM case expression C table | 8 | DUE_DATE | Original Date of Clarification Case | nvarchar | 8 | 0 | | |
46 | FKK_FDT_EXPR000A | BFR/BPEM case expression table A | 8 | DUE_DATE | Original Date of Clarification Case | nvarchar | 8 | 0 | | |
47 | FKK_FDT_EXPR000S | BFR/BPEM case expression table S | 7 | DUE_DATE | Original Date of Clarification Case | nvarchar | 8 | 0 | | |
48 | FKK_FDT_EXPR000T | BFR/BPEM case expression table T | 7 | DUE_DATE | Original Date of Clarification Case | nvarchar | 8 | 0 | | |
TOPCorporate Performance Monitor |
49 | UMC_TD100 | Task List | 14 | DUE_DATE | System Date | nvarchar | 8 | 0 | | |
TOPCross-Application Components |
50 | /OPT/VIM_HD_DP | VIM IE Monitor: Header Data for DP Invoices | 18 | DUE_DATE | Due Date | nvarchar | 8 | 0 | | |
51 | /OPT/VIM_HD_NPO | VIM IE Monitor: Header Data for Parked NPO Invoices | 21 | DUE_DATE | Due Date | nvarchar | 8 | 0 | | |
52 | /OPT/VIM_HD_PO | VIM IE Monitor: Header Data for Parked PO Invoices | 24 | DUE_DATE | Due Date | nvarchar | 8 | 0 | | |
TOPE-Recruiting |
53 | HRP5135 | DB Table for Infotype 5135 | 21 | DUE_DATE | Due Date | nvarchar | 8 | 0 | | |
54 | HRP5136 | DB Table for Infotype 5136 | 21 | DUE_DATE | Due Date | nvarchar | 8 | 0 | | |
55 | HRP5137 | DB Table for Infotype 5137 | 21 | DUE_DATE | Due Date | nvarchar | 8 | 0 | | |
56 | HRP5138 | DB Table for Infotype 5138 | 21 | DUE_DATE | Due Date | nvarchar | 8 | 0 | | |
57 | HRP5139 | DB Table for Infotype 5139 | 21 | DUE_DATE | Due Date | nvarchar | 8 | 0 | | |
58 | HRP5140 | DB Table for Infotype 5140 | 21 | DUE_DATE | Due Date | nvarchar | 8 | 0 | | |
59 | HRP5141 | DB Table for Infotype 5141 | 21 | DUE_DATE | Due Date | nvarchar | 8 | 0 | | |
60 | HRP5142 | DB Table for Infotype 5142 | 21 | DUE_DATE | Due Date | nvarchar | 8 | 0 | | |
61 | HRP5143 | Database Table for Infotype 5143 | 21 | DUE_DATE | Due Date | nvarchar | 8 | 0 | | |
62 | HRP5144 | Database Table for Infotype 5144 | 21 | DUE_DATE | Due Date | nvarchar | 8 | 0 | | |
63 | HRP5145 | Database Table for Infotype 5145 | 21 | DUE_DATE | Due Date | nvarchar | 8 | 0 | | |
TOPEnvironment, Health and Safety |
64 | /TDAG/EHSRCD_MA | Table for persisting TBOs of type /TDAG/CL_TBO_MA | 19 | DUE_DATE | Date | nvarchar | 8 | 0 | | |
TOPFinancial Accounting |
65 | /OPT/VIM_1HEAD | Document Header | 182 | DUE_DATE | Due Date | nvarchar | 8 | 0 | | |
TOPFunctions for U.S. Federal Government |
66 | FMRES_INST_HIST | Log of all installments created | 10 | DUE_DATE | Date | nvarchar | 8 | 0 | | |
67 | FMROLINE | FM Recurring Obligations - schedule lines | 4 | DUE_DATE | Schedule due date | nvarchar | 8 | 0 | | |
TOPGeneral |
68 | LWMHR_D_MYM_AGND | Agenda Header | 7 | DUE_DATE | System Date | nvarchar | 8 | 0 | | |
TOPGovernance, Risk and Compliance |
69 | GRFNDMFPCCN | DataMart: Facts PC Control | 21 | DUE_DATE | Cases Due Date | nvarchar | 8 | 0 | | |
70 | GRFNDMFPCEC | DataMart: Facts ELC | 20 | DUE_DATE | Cases Due Date | nvarchar | 8 | 0 | | |
71 | GRFNDMFPCSP | DataMart: Facts PC Subprocess | 20 | DUE_DATE | Cases Due Date | nvarchar | 8 | 0 | | |
72 | GRFNMDCR | Master Data Change Request | 12 | DUE_DATE | Field of type DATS | nvarchar | 8 | 0 | | |
73 | GRFNTASKPLANGRP | Data for task plan group | 27 | DUE_DATE | Date | nvarchar | 8 | 0 | | |
TOPGrantor Management |
74 | GTRFIBILL_I | Grantor Billing Document Items | 13 | DUE_DATE | Due date for net payment | nvarchar | 8 | 0 | | |
TOPGRC Risk Management |
75 | GRRMRESPONSE | Table for Response | 3 | DUE_DATE | Response due date | nvarchar | 8 | 0 | | |
TOPIncentive and Commission Management ICM |
76 | CACS00_DOCSE | Commission Document, Settlement | 10 | DUE_DATE | Due Date of Line Item | nvarchar | 8 | 0 | | |
77 | CACS25_SESIT | Settlement Schedule Item | 13 | DUE_DATE | Due Date of Line Item | nvarchar | 8 | 0 | | |
78 | YCRM01_DOCSE | Commission Document: Due Dates | 10 | DUE_DATE | Due Date of Line Item | nvarchar | 8 | 0 | | |
79 | YCRM01_SESIT | Settlement Schedule Item | 13 | DUE_DATE | Due Date of Line Item | nvarchar | 8 | 0 | | |
80 | YHITEC_DOCSE | Commission Document: Due Dates | 10 | DUE_DATE | Due Date of Line Item | nvarchar | 8 | 0 | | |
81 | YSVMA_DOCSE | Commission Document: Due Dates | 10 | DUE_DATE | Due Date of Line Item | nvarchar | 8 | 0 | | |
82 | YSVMA_SESIT | Settlement Schedule Item | 13 | DUE_DATE | Due Date of Line Item | nvarchar | 8 | 0 | | |
83 | YTEL01_DOCSE | Commission Document: Due Dates | 27 | DUE_DATE | Due Date of Line Item | nvarchar | 8 | 0 | | |
84 | YTEL05_DOCSE | Commission Document: Due Dates | 16 | DUE_DATE | Due Date of Line Item | nvarchar | 8 | 0 | | |
85 | YTEL05_SESIT | Settlement Schedule Item | 13 | DUE_DATE | Due Date of Line Item | nvarchar | 8 | 0 | | |
86 | ZICMAG_DOCSE | Commission Document: Due Dates | 10 | DUE_DATE | Due Date of Line Item | nvarchar | 8 | 0 | | |
TOPIncident Reporting |
87 | EHHSSD_IRT_RPT | Report | 8 | DUE_DATE | Report Due Date | nvarchar | 8 | 0 | | |
TOPIncident Workflow and Tasks |
88 | EHHSSD_PII_INQUI | Process Control - Inquiry | 21 | DUE_DATE | Task Due Date | nvarchar | 8 | 0 | | |
TOPLoans Management |
89 | VDCBR_CONTROL | Data Selection for Credit Bureau | 5 | DUE_DATE | Due Date | nvarchar | 8 | 0 | | |
TOPLocalization |
90 | J1B_ERROR_DDA | Master Table for DDA_Brazil (Segment G) | 11 | DUE_DATE | Due date, format DDMMYYYY | nvarchar | 8 | 0 | | |
TOPPortfolio |
91 | VDBILL_CONTROL | Bill Control | 7 | DUE_DATE | Due date | nvarchar | 8 | 0 | | |
92 | VDBILL_HIST | Billing History | 12 | DUE_DATE | Due date/calculation date | nvarchar | 8 | 0 | | |
93 | VDBILL_ITEMS | Billing Items | 10 | DUE_DATE | Payment Date | nvarchar | 8 | 0 | | |
94 | VDBILL_RES_HEAD | Bill Results Header | 9 | DUE_DATE | Due date/calculation date | nvarchar | 8 | 0 | | |
TOPPortfolio Management |
95 | RPM_CTEMPLATE | Custom Development Template | 6 | DUE_DATE | Date | nvarchar | 8 | 0 | | |
TOPPosition Budgeting and Control |
96 | HRFPM_DIFFERENCE | HRFPM: Personnel Costs Savings/ Overrun | 26 | DUE_DATE | Due Date | nvarchar | 8 | 0 | | |
97 | HRFPM_FM_POS | HRFPM: FM Documents - Items | 11 | DUE_DATE | Due Date | nvarchar | 8 | 0 | | |
98 | HRFPM_FM_POS_BU | HRFPM: FM Documents - Items for Budget | 12 | DUE_DATE | Due Date | nvarchar | 8 | 0 | | |
99 | HRFPM_FPM_POS | HRFPM: FPM Documents - Items | 24 | DUE_DATE | Due Date | nvarchar | 8 | 0 | | |
100 | HRFPM_FPM_POS_BU | HRFPM: FPM Documents - Items for Budget | 25 | DUE_DATE | Due Date | nvarchar | 8 | 0 | | |
101 | HRFPM_OBJECTS | HRFPM: Object table of the commitment engine | 43 | DUE_DATE | Due Date | nvarchar | 8 | 0 | | |
TOPProcess Controls |
102 | GRPCAODINFO | aod infos | 10 | DUE_DATE | End Date | nvarchar | 8 | 0 | | |
103 | GRPCCAPAACTION | Corrective Actions & Preventive Actions for CAPA Plan | 5 | DUE_DATE | Due Date | nvarchar | 8 | 0 | | |
104 | GRPCCASEAS | Assessment | 18 | DUE_DATE | Due Date | nvarchar | 8 | 0 | | |
105 | GRPCCASECP | CAPA Plan | 9 | DUE_DATE | Due Date | nvarchar | 8 | 0 | | |
106 | GRPCCASEIS | Issue | 22 | DUE_DATE | End Date | nvarchar | 8 | 0 | | |
107 | GRPCCASETL | Test log | 27 | DUE_DATE | Due Date | nvarchar | 8 | 0 | | |
TOPPublic Sector Contract Accounts Receivable and Payable |
108 | DFMCA_BRF131 | BRF: Parameter for Inbound Correspondence Request | 11 | DUE_DATE | BRF: Expression | nvarchar | 20 | 0 | | |
109 | DFMCA_RETURN | Data Table for Tax Returns | 41 | DUE_DATE | Due Date for Tax Return | nvarchar | 8 | 0 | | |
110 | DFMCA_RETURN_O | Data Table for Tax Returns | 44 | DUE_DATE | Due Date for Tax Return | nvarchar | 8 | 0 | | |
111 | TFMCA_BRF216 | BRF: Parameter for Inbound Correspondence Request | 12 | DUE_DATE | BRF: Expression | nvarchar | 20 | 0 | | |
TOPReceivablesPayment Management |
112 | VDAD_HIST | Auto Debits, Historical Data | 10 | DUE_DATE | Due date/calculation date | nvarchar | 8 | 0 | | |
113 | VDAD_RESULT | Result Table for Auto Debit Collection | 5 | DUE_DATE | Due date | nvarchar | 8 | 0 | | |
TOPRights |
114 | CMS_RIG | CMS: Rights table. Includes claims, patents, other rights. | 19 | DUE_DATE | Due date of a claim | nvarchar | 8 | 0 | | |
TOPSocial Services and Social Security |
115 | PSSCD_GPDITEM | Gross Payment Docment Item Data | 26 | DUE_DATE | Due Date | nvarchar | 8 | 0 | | |
116 | PSSCD_NCD | Net Calculation Document Header Data | 11 | DUE_DATE | Due Date | nvarchar | 8 | 0 | | |
TOPTransaction Manager |
117 | SLDT_FLOW | Subledger Distributor Transactions | 53 | DUE_DATE | Due Date | nvarchar | 8 | 0 | | |
118 | TCORT_COSAFL | Security Account Transfer: Flows | 17 | DUE_DATE | Due date | nvarchar | 8 | 0 | | |
119 | TEMT_RAWEXPOS | Raw Exposure | 8 | DUE_DATE | Date to Which Exposure Refers | nvarchar | 8 | 0 | | |
120 | TEMT_VERSEXPOS | Versioned Exposure | 9 | DUE_DATE | Date to Which Exposure Refers | nvarchar | 8 | 0 | | |
121 | TEXT_POSITIONS | Exposure Positions | 28 | DUE_DATE | Due Date of an Exposure Position as a Differentiating Term | nvarchar | 8 | 0 | | |
122 | TEXT_POS_FLOW | Exposure Position Flows | 27 | DUE_DATE | Due Date of an Exposure Position as a Differentiating Term | nvarchar | 8 | 0 | | |
123 | TEXT_REXP_ITEM | Raw Exposure Item | 8 | DUE_DATE | Date on Which Exposure Is Due / Expires | nvarchar | 8 | 0 | | |
124 | TEXT_TRANSACTION | Unmatched Exposure Business Transactions | 27 | DUE_DATE | Due Date of an Exposure Position as a Differentiating Term | nvarchar | 8 | 0 | | |
125 | TRDT_FLOW | Persistent distributor flows | 51 | DUE_DATE | Due Date | nvarchar | 8 | 0 | | |
TOPTransfer to Financial Accounting |
126 | TRLT_FLOW | Treasury Ledger Flows | 22 | DUE_DATE | Due Date | nvarchar | 8 | 0 | | |
TOPTreasury and Risk Management |
127 | TREAT_FLOW | Treasury: TREA Flows | 33 | DUE_DATE | Due Date | nvarchar | 8 | 0 | | |
TOPValue Adjustment |
128 | /IBS/TRB_GUIDKVV | RBD: GUID Table Key fields of Contract | 21 | DUE_DATE | RBD: Valuation Date | nvarchar | 8 | 0 | | |
129 | /IBS/TRB_KVV | RBD Assignment RBD Account - Contract Source System | 21 | DUE_DATE | RBD: Valuation Date | nvarchar | 8 | 0 | | |
130 | /IBS/TRB_SCHIST | RBD IAS - History Value Adjustment Collateral | 5 | DUE_DATE | RBD: Date, Recovery Time | nvarchar | 8 | 0 | | |
131 | /IBS/TRB_SCHISTR | RBD IAS - History Provision Collaterals | 5 | DUE_DATE | RBD: Date, Recovery Time | nvarchar | 8 | 0 | | |
132 | /IBS/TRB_SHCOL | RBD IAS - Value Adjustment Collateral | 4 | DUE_DATE | RBD: Date, Recovery Time | nvarchar | 8 | 0 | | |
133 | /IBS/TRB_SHCOL_R | RBD IAS - Provision Collaterals | 4 | DUE_DATE | RBD: Date, Recovery Time | nvarchar | 8 | 0 | | |
134 | /IBS/TRB_SHEET | RBD IAS - Value Adjustment Cash Flow Positions | 4 | DUE_DATE | RBD: Due Date | nvarchar | 8 | 0 | | |
135 | /IBS/TRB_SHEETH | RBD IAS - Header Data of Valuation Sheet | 5 | DUE_DATE | RBD: Valuation Date | nvarchar | 8 | 0 | | |
136 | /IBS/TRB_SHEET_I | RBD IAS - Provision Utilization | 4 | DUE_DATE | RBD: Due Date | nvarchar | 8 | 0 | | |
137 | /IBS/TRB_SHEET_R | RBD IAS - Provision Cash Flow Positions | 4 | DUE_DATE | RBD: Due Date | nvarchar | 8 | 0 | | |
138 | /IBS/TRB_SHIST | RBD IAS - History Value Adjustment Cash Flow Positions | 5 | DUE_DATE | RBD: Due Date | nvarchar | 8 | 0 | | |
139 | /IBS/TRB_SHISTH | RBD IAS - History Header Data Valuation Sheet | 6 | DUE_DATE | RBD: Valuation Date | nvarchar | 8 | 0 | | |
140 | /IBS/TRB_SHIST_I | RBD IAS - History Provision Utilization | 5 | DUE_DATE | RBD: Due Date | nvarchar | 8 | 0 | | |
141 | /IBS/TRB_SHIST_R | RBD IAS - History Provision Cash Flow Positions | 5 | DUE_DATE | RBD: Due Date | nvarchar | 8 | 0 | | |
TOPWorkflows and Tasks for Risk Assessment |
142 | EHHSSD_EVL_INQUI | Process Control - Inquiry | 21 | DUE_DATE | Task Due Date | nvarchar | 8 | 0 | | |