| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /BIC/B0000187000 | PSA for 2LIS_02_ITM T90CLNT090 Purch. Data (Item) | 38 | KONNR | | nvarchar | 10 | 0 | | |
2 | /BIC/B0000189000 | PSA for 2LIS_02_SCL T90CLNT090 Purch.Data Sch.Line | 36 | KONNR | | nvarchar | 10 | 0 | | |
3 | P2RB_PK | Pension Fund, Payroll Belgium | 11 | KONNR | Individual PF account number | nvarchar | 10 | 0 | | |
4 | P2RC_PK | HR-CH: Pension fund payroll values | 11 | KONNR | Individual PF account number | nvarchar | 10 | 0 | | |
5 | P2RN_PK | Payroll Result: Pension Module | 11 | KONNR | Individual PF account number | nvarchar | 10 | 0 | | |
6 | P2UN_PK | Pension Fund, Payroll United Nations | 11 | KONNR | Individual PF account number | nvarchar | 10 | 0 | | |
TOPData Retention Tool |
7 | TXW_S_EKKO | Retrieve EKKO from archive | 16 | KONNR | Number of Principal Purchase Agreement | nvarchar | 10 | 0 | | |
TOPDefense Forces and Public Security |
8 | /ISDFPS/ZEBAN | Copy of EBAN | 48 | KONNR | Number of Principal Purchase Agreement | nvarchar | 10 | 0 | | |
TOPExternal Services |
9 | TMP_SPEC | Model Service Specifications | 23 | KONNR | Number of Principal Purchase Agreement | nvarchar | 10 | 0 | | |
TOPMaster Data |
10 | PLAF | Planned Order | 30 | KONNR | Number of Principal Purchase Agreement | nvarchar | 10 | 0 | | |
TOPMaterials Management |
11 | /ISDFPS/CS_EXLST | Exception List: Overwritten Purchase Requisitions | 53 | KONNR | Number of Principal Purchase Agreement | nvarchar | 10 | 0 | | |
TOPPension fund General Parts |
12 | T5CPB | HR-CH: Pension fund postings | 2 | KONNR | Individual PF account number | nvarchar | 10 | 0 | | |
13 | T5CPK | HR-CH: PF account index | 2 | KONNR | Individual PF account number | nvarchar | 10 | 0 | | |
14 | T5CPZ | HR-CH: Personnel number account number assignment (PF) | 2 | KONNR | Individual PF account number | nvarchar | 10 | 0 | | |
15 | T72FA | HR-PF: FI Index Table | 5 | KONNR | Individual PF account number | nvarchar | 10 | 0 | | |
TOPPension fund Netherlands |
16 | T5ND1 | HR-CH: Pension fund postings | 2 | KONNR | Individual PF account number | nvarchar | 10 | 0 | | |
17 | T5NDB | Log tabel voor euroconversie van tabel T5CPB | 3 | KONNR | Nummer van een individuele PF-rekening | nvarchar | 10 | 0 | | |
TOPPension Fund Switzerland |
18 | PA3230 | Personnel Master Record for Infotype 3230 | 26 | KONNR | Individual PF account number | nvarchar | 10 | 0 | | |
19 | T5CDB | PA-PF-CH Specific Enhancement for T5PCB (EMZ and so on) | 2 | KONNR | Individual PF account number | nvarchar | 10 | 0 | | |
TOPPerishables Procurement |
20 | FIP_D_ORDER_LINE | Order lines for FIP | 31 | KONNR | Number of Principal Purchase Agreement | nvarchar | 10 | 0 | | |
TOPPOS Interface |
21 | WVFB | DRS Interface, Intermediate Buffer, Order Item FM | 19 | KONNR | Number of Principal Purchase Agreement | nvarchar | 10 | 0 | | |
TOPPurchase Orders |
22 | WBO2 | Log item file for simulative list for load building | 37 | KONNR | Number of Principal Purchase Agreement | nvarchar | 10 | 0 | | |
TOPPurchasing |
23 | EBAN | Purchase Requisition | 48 | KONNR | Number of Principal Purchase Agreement | nvarchar | 10 | 0 | | |
24 | EKAB | Release Documentation | 2 | KONNR | Number of Principal Purchase Agreement | nvarchar | 10 | 0 | | |
25 | EKKO | Purchasing Document Header | 41 | KONNR | Number of Principal Purchase Agreement | nvarchar | 10 | 0 | | |
26 | EKPO | Purchasing Document Item | 61 | KONNR | Number of Principal Purchase Agreement | nvarchar | 10 | 0 | | |
27 | MEREQX | Purchase Requisition Change Parameter | 48 | KONNR | Updated information in related user data field | nvarchar | 1 | 0 | | |
TOPReturnable Packaging Logistics |
28 | RLACCT | Returnable packaging account | 23 | KONNR | Number of Outline Agreement | nvarchar | 10 | 0 | | |
TOPSelf-Service Procurement |
29 | /SRMERP/D_SC_ITM | Shopping Cart Item | 61 | KONNR | Number of Principal Purchase Agreement | nvarchar | 10 | 0 | | |
TOPSimulation |
30 | VSEBAN_CN | Version: Purchase requisition | 49 | KONNR | Number of Principal Purchase Agreement | nvarchar | 10 | 0 | | |
31 | VSPLAF_CN | Version: Planned order | 31 | KONNR | Number of Principal Purchase Agreement | nvarchar | 10 | 0 | | |