| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | ACMTST_DB_BPA | ACMTST: Business Partner (DB-Table) | 10 | CURRENCY_CODE | Currency Key | nvarchar | 5 | 0 | | |
2 | ACMTST_DB_EMPL | ACMTST: Employee (DB-Table) | 13 | CURRENCY_CODE | | nvarchar | 5 | 0 | | |
3 | ACMTST_DB_SO | ACMTST: Sales Order Header (DB-Table) | 9 | CURRENCY_CODE | | nvarchar | 5 | 0 | | |
4 | SEPM_OIA_CUST_T | Customizing table for Open Item Analysis | 3 | CURRENCY_CODE | EPM OIA: Target Currency used in Currency Conversion | nvarchar | 5 | 0 | | |
5 | T7UNPF_FI_ADDET | Additional Details | 12 | CURRENCY_CODE | Payment Currency | nvarchar | 5 | 0 | | |
6 | T7UNPF_FI_TRANS | Additional Details | 12 | CURRENCY_CODE | Payment Currency | nvarchar | 5 | 0 | | |
TOPNetWeaver Demonstration |
7 | SDEMO_PD_PR | SAP NetWeaver Demo Model - Product Price | 4 | CURRENCY_CODE | Currency Code | nvarchar | 5 | 0 | | |
8 | SDEMO_PO | Purchase Order Header | 19 | CURRENCY_CODE | Currency Code | nvarchar | 5 | 0 | | |
9 | SDEMO_PO_I | Purchase Order Item | 8 | CURRENCY_CODE | Currency Code | nvarchar | 5 | 0 | | |
10 | SDEMO_SO | SAP NetWeaver Demo Model - Sales Order Header | 23 | CURRENCY_CODE | Currency Code | nvarchar | 5 | 0 | | |
11 | SDEMO_SO_I | SAP NetWeaver Demo Model - Sales Order Item | 8 | CURRENCY_CODE | Currency Code | nvarchar | 5 | 0 | | |
12 | SNWD_BPA | EPM: Business Partners | 16 | CURRENCY_CODE | EPM: Currency Code | nvarchar | 5 | 0 | | |
13 | SNWD_COMPANY | EPM: Company Master | 6 | CURRENCY_CODE | EPM: Currency Code | nvarchar | 5 | 0 | | |
14 | SNWD_PD | EPM: Product Data Table | 17 | CURRENCY_CODE | EPM: Currency Code | nvarchar | 5 | 0 | | |
15 | SNWD_PO | EPM: Purchase Order Header Table | 10 | CURRENCY_CODE | EPM: Currency Code | nvarchar | 5 | 0 | | |
16 | SNWD_PO_I | EPM: Purchase Order Item Table | 7 | CURRENCY_CODE | EPM: Currency Code | nvarchar | 5 | 0 | | |
17 | SNWD_PO_INV_HEAD | EPM: Purchase Order Invoice Header Table | 12 | CURRENCY_CODE | EPM: Currency Code | nvarchar | 5 | 0 | | |
18 | SNWD_PO_INV_ITEM | EPM: Purchase Order Invoice Items Table | 10 | CURRENCY_CODE | EPM: Currency Code | nvarchar | 5 | 0 | | |
19 | SNWD_SO | EPM: Sales Order Header Table | 12 | CURRENCY_CODE | EPM: Currency Code | nvarchar | 5 | 0 | | |
20 | SNWD_SO_I | EPM: Sales Order Item Table | 7 | CURRENCY_CODE | EPM: Currency Code | nvarchar | 5 | 0 | | |
21 | SNWD_SO_INV_HEAD | EPM: Sales Order Invoice Header Table | 12 | CURRENCY_CODE | EPM: Currency Code | nvarchar | 5 | 0 | | |
22 | SNWD_SO_INV_ITEM | EPM: Sales Order Invoice Items Table | 10 | CURRENCY_CODE | EPM: Currency Code | nvarchar | 5 | 0 | | |
TOPProcess Controls |
23 | GRPC_ACCOUNT_GRP | Account Group Scoping Info. | 9 | CURRENCY_CODE | Currency | nvarchar | 5 | 0 | | |
24 | GRPC_SCOP_THRESH | Scoping Threshold | 7 | CURRENCY_CODE | Currency | nvarchar | 5 | 0 | | |
TOPSpecification 2 |
25 | ADS2KUPL_CURMAP | SPEC2000 IP Upload: Currency Code Mapping | 1 | CURRENCY_CODE | SPEC 2000 Flat File Upload: Currency Code (S&T File) | nvarchar | 1 | 0 | | |
TOPTravel Planning |
26 | FTPT_IMR_FSP | IMR: Assignment Table Passengers-Segments-TST | 10 | CURRENCY_CODE | Currency code | nvarchar | 5 | 0 | | |
27 | FTPT_IMR_HTL | IMR - Hotel | 16 | CURRENCY_CODE | Currency code | nvarchar | 5 | 0 | | |
28 | FTPT_IMR_HTL_DIR | IMR - Hotel (Direct Access) | 16 | CURRENCY_CODE | Currency code | nvarchar | 5 | 0 | | |
TOPWorkforce Management Application |
29 | WFACAS_SHIFT_SEG | Shift Segment Table | 12 | CURRENCY_CODE | Currency Key | nvarchar | 5 | 0 | | |
30 | WFAC_LOCATION | Location | 6 | CURRENCY_CODE | Currency Key | nvarchar | 5 | 0 | | |
31 | WFAC_LOCSETTN | General Location Settings | 7 | CURRENCY_CODE | Currency Key | nvarchar | 5 | 0 | | |
32 | WFA_SHIFT_SG2 | Shifts Segments for WFM Schedule | 11 | CURRENCY_CODE | Currency Key | nvarchar | 5 | 0 | | |
TOPWorkforce Management Core |
33 | WFMCAS_SHIFT_SEG | Shift Segment Table | 12 | CURRENCY_CODE | Currency Key | nvarchar | 5 | 0 | | |
34 | WFMCAS_SHIFT_SG2 | Shifts Integrated with WFD Server | 11 | CURRENCY_CODE | Currency Key | nvarchar | 5 | 0 | | |
35 | WFMC_LOCATION | Location | 6 | CURRENCY_CODE | Currency Key | nvarchar | 5 | 0 | | |
36 | WFMC_LOCSETTN | General Location Settings | 7 | CURRENCY_CODE | Currency Key | nvarchar | 5 | 0 | | |