| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /BIC/B0000005000 | Change Log Table of DataStore Object 0PERS_BOD | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
2 | /BIC/B0000006000 | Change Log Table of DataStore Object 0PERS_VAR | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
3 | /BIC/B0000007000 | Change Log Table of DataStore Object 0PERS_WTE | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
4 | /BIC/B0000008000 | Transfer Structure Application 80RSPL_AGS | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
5 | /BIC/B0000009000 | Transfer Structure Application 80RSPL_AST | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
6 | /BIC/B0000010000 | Transfer Structure Application 80RSPL_CST | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
7 | /BIC/B0000011000 | Transfer Structure Application 80RSPL_HST | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
8 | /BIC/B0000012000 | Transfer Structure Application 80RSPL_LCK | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
9 | /BIC/B0000013000 | Transfer Structure Application 80RSPL_PLC | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
10 | /BIC/B0000014000 | Transfer Structure Application 80RSPL_PSS | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
11 | /BIC/B0000015000 | Transfer Structure Application 80RSPL_SEL | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
12 | /BIC/B0000016000 | Transfer Structure Application 80RSPL_SPS | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
13 | /BIC/B0000017000 | Change Log Table of DataStore Object 0TCTHP24O | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
14 | /BIC/B0000018000 | Error Stack DTP_7KU36MOUFNCES7S4B2PZC13FM 0001 | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
15 | /BIC/B0000103000 | PSA for /CPD/PFP_DS_AFVC T90CLNT090 DataSource for NWA | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
16 | /BIC/B0000103001 | PSA for /CPD/PFP_DS_AFVC T90CLNT090 DataSource for NWA | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
17 | /BIC/B0000104000 | PSA for /CPD/PFP_DS_AUFK T90CLNT090 DataSource for Ntwrk | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
18 | /BIC/B0000104001 | PSA for /CPD/PFP_DS_AUFK T90CLNT090 DataSource for Ntwrk | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
19 | /BIC/B0000105000 | PSA for /CPD/PFP_DS_PROJ T90CLNT090 DataSource for Proj. | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
20 | /BIC/B0000105001 | PSA for /CPD/PFP_DS_PROJ T90CLNT090 DataSource for Proj. | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
21 | /BIC/B0000106000 | PSA for /CPD/PFP_DS_PROJ_TEXT T90CLNT090 DataSource for Proj | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
22 | /BIC/B0000107000 | PSA for /CPD/PFP_DS_SALES T90CLNT090 DataSource for SO | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
23 | /BIC/B0000107001 | PSA for /CPD/PFP_DS_SALES T90CLNT090 DataSource for SO | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
24 | /BIC/B0000108000 | PSA for /CPD/PFP_DS_WBS T90CLNT090 DataSource for WBS | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
25 | /BIC/B0000108001 | PSA for /CPD/PFP_DS_WBS T90CLNT090 DataSource for WBS | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
26 | /BIC/B0000109000 | PSA for /CPD/PFP_DS_WBS_DATE T90CLNT090 DataSource for WBS | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
27 | /BIC/B0000109001 | PSA for /CPD/PFP_DS_WBS_DATE T90CLNT090 DataSource for WBS | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
28 | /BIC/B0000110000 | PSA for /CPD/PFP_DS_WBS_TEXT T90CLNT090 DataSource for WBS | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
29 | /BIC/B0000135000 | Change Log Table of DataStore Object 0PERS_VR1 | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
30 | /BIC/B0000136000 | PSA for 0DPR_PROJECT_TEXT T90CLNT090 Project Def. Texts | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
31 | /BIC/B0000137000 | PSA for 0DPR_PHASE_TEXT T90CLNT090 Phase Texts | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
32 | /BIC/B0000138000 | PSA for 0DPR_TASK_TEXT T90CLNT090 Task Texts | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
33 | /BIC/B0000139000 | PSA for 0DPR_PROJECT_DATE T90CLNT090 Proj. Def. Dates | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
34 | /BIC/B0000140000 | PSA for 0DPR_PHASE_DATE T90CLNT090 Phase Dates | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
35 | /BIC/B0000141000 | PSA for 0DPR_TASK_DATE T90CLNT090 Task Dates | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
36 | /BIC/B0000149000 | PSA for 0DPR_TASK_ATTR T90CLNT090 Task Attributes | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
37 | /BIC/B0000151000 | PSA for 0DPR_PROJECT_ATTR T90CLNT090 Proj. Def. Attr. | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
38 | /BIC/B0000152000 | PSA for 0DPR_PHASE_ATTR T90CLNT090 Phase Attributes | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
39 | /BIC/B0000157000 | PSA for 0CO_AREA_ATTR T90CLNT090 CO Area | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
40 | /BIC/B0000158000 | PSA for 0CO_AREA_TEXT T90CLNT090 CO Area | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
41 | /BIC/B0000159000 | PSA for 0COSTCENTER_ATTR T90CLNT090 Cost center | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
42 | /BIC/B0000160000 | PSA for 0COSTCENTER_TEXT T90CLNT090 Cost Center | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
43 | /BIC/B0000164000 | PSA for 0FI_AP_20 T90CLNT090 Vendor Balances | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
44 | /BIC/B0000165000 | PSA for 0FI_AP_4 T90CLNT090 FI-AP: Items Delta | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
45 | /BIC/B0000166000 | PSA for 0FI_AR_4 T90CLNT090 FI-AR Items Delta | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
46 | /BIC/B0000167000 | PSA for 0FI_AR_20 T90CLNT090 Customer Balances | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
47 | /BIC/B0000168000 | PSA for 0FI_GL_40 T90CLNT090 G/L Accounts: Items | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
48 | /BIC/B0000169000 | PSA for 0FI_GL_41 T90CLNT090 Documents, Compact | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
49 | /BIC/B0000170000 | PSA for 0FI_GL_4 T90CLNT090 FI-GL Items Delta | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
50 | /BIC/B0000171000 | PSA for 0FI_GL_21 T90CLNT090 G/L Accts: Balances | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
51 | /BIC/B0000172000 | PSA for 0FI_GL_14 T90CLNT090 Gen. Ledger: Items | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
52 | /BIC/B0000173000 | PSA for 0FI_GL_10 T90CLNT090 General Ledger: Bal. | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
53 | /BIC/B0000174000 | PSA for 0FI_GL_11 T90CLNT090 Lead. Ldgr Bals LIs | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
54 | /BIC/B0000175000 | PSA for 0FI_GL_12 T90CLNT090 Lead. Ldgr Bals (Q) | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
55 | /BIC/B0000176000 | PSA for 2LIS_11_VAHDR T90CLNT090 Sales Doc. Header | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
56 | /BIC/B0000177000 | PSA for 2LIS_11_V_ITM T90CLNT090 Sls-Ship.Alloc.Item | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
57 | /BIC/B0000178000 | PSA for 2LIS_11_VAITM T90CLNT090 Sales Doc. Item | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
58 | /BIC/B0000179000 | PSA for 2LIS_11_VASCL T90CLNT090 Sales Doc. Schedule | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
59 | /BIC/B0000180000 | PSA for 2LIS_11_V_SCL T90CLNT090 Sls-Ship.Alloc.Sch. | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
60 | /BIC/B0000181000 | PSA for 2LIS_11_VAKON T90CLNT090 Sales Document Cond. | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
61 | /BIC/B0000182000 | PSA for 2LIS_12_VCHDR T90CLNT090 Delivery Header Data | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
62 | /BIC/B0000183000 | PSA for 2LIS_12_VCITM T90CLNT090 Delivery Item | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
63 | /BIC/B0000184000 | PSA for 2LIS_13_VDHDR T90CLNT090 Bill.Doc.Header Data | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
64 | /BIC/B0000185000 | PSA for 2LIS_13_VDITM T90CLNT090 Billing Doc. Item | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
65 | /BIC/B0000186000 | PSA for 2LIS_13_VDKON T90CLNT090 Billing Docu. Cond. | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
66 | /BIC/B0000187000 | PSA for 2LIS_02_ITM T90CLNT090 Purch. Data (Item) | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
67 | /BIC/B0000188000 | PSA for 2LIS_02_HDR T90CLNT090 Purch.Data (Header) | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
68 | /BIC/B0000189000 | PSA for 2LIS_02_SCL T90CLNT090 Purch.Data Sch.Line | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
69 | /BIC/B0000190000 | PSA for 0MM_PUR_PURCH_DATA T90CLNT090 Purchasing Data | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
70 | /BIC/B0000191000 | PSA for 0MM_PUR_PURCH_GROUPS T90CLNT090 Purchasing Groups | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
71 | /BIC/B0000192000 | PSA for 0MM_PUR_SRV_LEVEL T90CLNT090 PO Service Level | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
72 | /BIC/B0000193000 | PSA for EIM_DS_SD DI_SOURCE Segment 0001 | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
73 | /BIC/B0000193001 | PSA for EIM_DS_SD DI_SOURCE Segment 0001 | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
74 | /BIC/B0000199000 | Change Log Table of DataStore Object DS_AFPO | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
75 | /BIC/B0000200000 | Change Log Table of DataStore Object DS_LIPS | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
76 | /BIC/B0000201000 | Change Log Table of DataStore Object DS_VBAK | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
77 | /BIC/B0000202000 | Change Log Table of DataStore Object DS_VBAP | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
78 | /BIC/B0000203000 | Change Log Table of DataStore Object DS_VBEP | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
79 | /BIC/B0000204000 | Change Log Table of DataStore Object DS_SD | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
80 | /BIC/B0000218000 | PSA for 0CO_OM_OPA_1 T90CLNT090 Orders: Costs | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
81 | /BIC/B0000219000 | PSA for 0CO_OM_OPA_3 T90CLNT090 Orders: Total plan | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
82 | /BIC/B0000220000 | PSA for 0CO_OM_OPA_4 T90CLNT090 Orders: Statist. KFs | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
83 | /BIC/B0000221000 | PSA for 0CO_OM_OPA_2 T90CLNT090 Orders: Budget | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
84 | /BIC/B0000222000 | PSA for 0CO_OM_OPA_5 T90CLNT090 Orders: Selections | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
85 | /BIC/B0000223000 | PSA for 0CO_OM_OPA_6 T90CLNT090 Orders: ActCostDelta | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
86 | /BIC/B0000228000 | PSA for DS_MM DI_SOURCE Segment 0001 | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
87 | /BIC/B0000231000 | PSA for DS_AFPO DI_SOURCE Segment 0001 | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
88 | /BIC/B0000232000 | PSA for DS_LIPS DI_SOURCE Segment 0001 | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
89 | /BIC/B0000233000 | PSA for DS_VBAP DI_SOURCE Segment 0001 | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
90 | /BIC/B0000235000 | Change Log Table of DataStore Object DSO_MM | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
91 | /BIC/B0000240000 | Change Log Table of DataStore Object DSO_LIPS | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
92 | /BIC/B0000244000 | Change Log Table of DataStore Object DSO_AFPO | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
93 | /BIC/B0000248000 | Change Log Table of DataStore Object DSO_VBAP | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
94 | /BIC/B0000271000 | PSA for DS_VBEP DI_SOURCE Segment 0001 | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
95 | /BIC/B0000272000 | Change Log Table of DataStore Object DSO_VBEP | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
96 | /BIC/B0000276000 | Transfer Structure Application /CPD/8PFP_C01 | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
97 | /BIC/B0000277000 | Change Log Table of DataStore Object DSO_APD | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
98 | /BIC/B0000280000 | PSA for 0HR_PA_0 T90CLNT090 Employee | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
99 | /BIC/B0000281000 | PSA for 0EMPLOYEE_ATTR T90CLNT090 Employee | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
100 | /BIC/B0000282000 | PSA for 0EMPLOYEE_TEXT T90CLNT090 Employee | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
101 | /BIC/B0000283000 | PSA for 0EMPLOYEE_2_ATTR T90CLNT090 Employee | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
102 | /BIC/B0000284000 | PSA for 0EMPLOYEE_2_TEXT T90CLNT090 Employee (Texts) | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
103 | /BIC/B0000285000 | PSA for 0PERSON_ATTR T90CLNT090 Person | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
104 | /BIC/B0000286000 | PSA for 0PERSON_TEXT T90CLNT090 Person | 3 | PARTNO | Partition value for PSA table | int | 10 | 0 | | |
105 | RSDAREFTABDB2_OR | DB2-z/OS HiPe NLS: Template for reqstate table | 3 | PARTNO | | int | 10 | 0 | | |
106 | RSDB2A_CONTROL | DB2 Accelerator: conrol center TOC | 10 | PARTNO | Number of partitions of the tablespace or indexspace | smallint | 5 | 0 | | |
107 | RSDB2A_STATUS | DB2 Accelerator: current table data status in accelerator | 2 | PARTNO | Number of partitions of the tablespace or indexspace | smallint | 5 | 0 | | |
108 | RSDB2A_STA_STD | DB2 Accelerator: current table data status in accelerator | 2 | PARTNO | Number of partitions of the tablespace or indexspace | smallint | 5 | 0 | | |
109 | RSDB2NLS_CHKRSLT | DB2-z/OS HiPe NLS: Check results | 4 | PARTNO | | int | 10 | 0 | | |
110 | RSDB2NLS_CONTROL | DB2-z/OS HiPe NLS: Table of Content | 5 | PARTNO | | smallint | 5 | 0 | | |
TOPData Staging |
111 | RSTSODS | Operational Data Store for the transfer structure | 13 | PARTNO | Partition number for PSA partitioning | nvarchar | 4 | 0 | | |
112 | RSTSODSPART | Partitioning Information | 2 | PARTNO | Partition number for PSA partitioning | nvarchar | 4 | 0 | | |
TOPReturnable Packaging Logistics |
113 | RLACSTHD | Returnable Packaging Account Statement | 5 | PARTNO | Sequence number for RP account postings per acct and deltype | int | 10 | 0 | | |
114 | RLPODLMT | Delimitation Record for Returnable Packaging Acct Postings | 4 | PARTNO | Sequence number for RP account postings per acct and deltype | int | 10 | 0 | | |