| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /IBS/TRB_ECF_PCF | RBD ECF - Provision Cash Flow | 20 | REFNR | RBD: Reference | nvarchar | 35 | 0 | | |
2 | /IBS/TRB_ECF_PCO | RBD ECF - Provision Collateral | 25 | REFNR | RBD: Reference | nvarchar | 35 | 0 | | |
3 | /IBS/TRB_ECF_PUT | RBD ECF - Provision Utilization | 18 | REFNR | RBD: Reference | nvarchar | 35 | 0 | | |
4 | /IBS/TRB_ECF_VCF | RBD ECF - Value Adjustment - Cash Flow | 18 | REFNR | RBD: Reference | nvarchar | 35 | 0 | | |
5 | /IBS/TRB_ECF_VCO | RBD ECF - Value Adjustment - Collateral | 23 | REFNR | RBD: Reference | nvarchar | 35 | 0 | | |
6 | /IBS/TRB_ECH_PCF | RBD ECF - Provision History - Cash Flow | 21 | REFNR | RBD: Reference | nvarchar | 35 | 0 | | |
7 | /IBS/TRB_ECH_PCO | RBD ECF - Provision History - Collateral | 26 | REFNR | RBD: Reference | nvarchar | 35 | 0 | | |
8 | /IBS/TRB_ECH_PUT | RBD ECF - Provision History - Utilization | 19 | REFNR | RBD: Reference | nvarchar | 35 | 0 | | |
9 | /IBS/TRB_ECH_VCF | RBD ECF - Value Adjustment History - Cash Flow | 19 | REFNR | RBD: Reference | nvarchar | 35 | 0 | | |
10 | /IBS/TRB_ECH_VCO | RBD ECF - Value Adjustment History - Collateral | 24 | REFNR | RBD: Reference | nvarchar | 35 | 0 | | |
11 | /IBS/TRB_ECI_CF | RBD ECF - Cash Flow Import Table | 14 | REFNR | RBD: Reference | nvarchar | 35 | 0 | | |
12 | /IBS/TRB_ECI_CO | RBD ECF - Import Table for Collateral | 19 | REFNR | RBD: Reference | nvarchar | 35 | 0 | | |
13 | /IBS/TRB_KTO_PRP | RBD Account. Master Data | 11 | REFNR | RBD: Reference Number Source System | nvarchar | 100 | 0 | | |
14 | P2PL_EAB | Payroll Result PL: Split Y, absences | 15 | REFNR | Reference number | nvarchar | 8 | 0 | | |
15 | P2RB_PENS | Pensioner's data (B) | 13 | REFNR | Reference number | nvarchar | 20 | 0 | | |
16 | P2RO_RO_ABX | Extension of AB table | 7 | REFNR | Reference number | nvarchar | 8 | 0 | | |
17 | P2UA_UAILL | struc.UAILL - information about sick-list compensation calc. | 19 | REFNR | Reference number | nvarchar | 8 | 0 | | |
18 | PA3347 | HR Master Record Infotype 3347 | 24 | REFNR | Relationship Between Periods | nvarchar | 2 | 0 | | |
19 | T77WWW_CLFDAT | Table to store the file data stored in third party server | 3 | REFNR | Request Reference Number | nvarchar | 13 | 0 | | |
20 | T77WWW_CLTRANSD | Cluster table for storing transaction data. | 4 | REFNR | Request Reference Number | nvarchar | 13 | 0 | | |
21 | T77WWW_CLTRAN_BU | Backup Table for Storing Transaction Data | 4 | REFNR | Request Reference Number | nvarchar | 13 | 0 | | |
22 | TKO01 | Control parameters for order type | 3 | REFNR | Reference order number | nvarchar | 12 | 0 | | |
TOPABAP Test Frameworks ATC, CheckMan, Code Inspector |
23 | CRM_CATL | CATT: Log Process Data | 7 | REFNR | CATT - Referred test case | nvarchar | 30 | 0 | | |
24 | CRM_CATM | CATT: Log for model and function data | 10 | REFNR | CATT - Referred test case | nvarchar | 30 | 0 | | |
TOPAddress ManagementBusiness Address |
25 | SADRP | Address Management: Personal Data | 32 | REFNR | Address reference for alias names | nvarchar | 10 | 0 | | |
TOPAustria |
26 | T5A1O_REF | ELDA: Reference Number | 2 | REFNR | Reference Number | nvarchar | 30 | 0 | | |
27 | T5A71 | L16 Consolidation File | 35 | REFNR | Reference Number | nvarchar | 30 | 0 | | |
28 | T5A74 | E18 Consolidation File | 35 | REFNR | Reference Number | nvarchar | 30 | 0 | | |
TOPBasic Functions |
29 | EIEI | Foreign Trade: Export/Import Communication Data | 9 | REFNR | Sales and Distribution Document Number | nvarchar | 10 | 0 | | |
30 | EIKP | Foreign Trade: Export/Import Header Data | 67 | REFNR | Sales and Distribution Document Number | nvarchar | 10 | 0 | | |
TOPBelgium |
31 | PA0504 | Pensioner's Advantage B | 25 | REFNR | Reference number | nvarchar | 20 | 0 | | |
32 | PA0735 | HR Master Record: Infotype 0735 (Dimona B) | 46 | REFNR | Dimona Declaration Number | nvarchar | 20 | 0 | | |
33 | T5BDI0 | HR-BE: Dimona Central Table | 3 | REFNR | Dimona Declaration Number | nvarchar | 20 | 0 | | |
34 | T5BX2 | Assign Description text to BELCOTAX form, BOW (Obsolete) | 9 | REFNR | Fiche Code | nvarchar | 3 | 0 | | |
TOPBenefits |
35 | PA0211 | HR Master Record: Infotype 0211 (COBRA Beneficiaries) | 37 | REFNR | COBRA reference number of COBRA-insured person | nvarchar | 3 | 0 | | |
TOPCanada |
36 | T5KYS | No longer used | 6 | REFNR | Sequential number | nvarchar | 4 | 0 | | |
TOPCATT Computer Aided Test Tool |
37 | CATF | CATT: Subsequent Data in Test Procedure | 7 | REFNR | CATT - Referred test case | nvarchar | 30 | 0 | | |
38 | CATL | CATT: Log Process Data | 6 | REFNR | CATT - Referred test case | nvarchar | 30 | 0 | | |
39 | CATM | CATT: Log for model and function data | 9 | REFNR | CATT - Referred test case | nvarchar | 30 | 0 | | |
40 | CATO | CATT - Static TCD data from CATF log | 8 | REFNR | CATT - Referred test case | nvarchar | 30 | 0 | | |
41 | CATP | CATT - Parameters and variants | 3 | REFNR | CATT - Referred test case | nvarchar | 30 | 0 | | |
TOPContract Accounts Receivable and Payable |
42 | DFKKESR | POR Payment Supplement | 3 | REFNR | POR Reference Key | nvarchar | 24 | 0 | | |
43 | DFKKREP06 | Tax Report Data (Invoicing Time or Triggered) | 33 | REFNR | Number of Contract Accts Rec. & Payable Doc. | nvarchar | 12 | 0 | | |
44 | DFKKREP06_S | Tax Report Data - Shadow Table for Posting Date | 33 | REFNR | Number of Contract Accts Rec. & Payable Doc. | nvarchar | 12 | 0 | | |
45 | DFKKREP07 | Tax Report Data (Clearing Time) | 38 | REFNR | Number of Contract Accts Rec. & Payable Doc. | nvarchar | 12 | 0 | | |
46 | DFKKREV06 | Report for Tax on Sales/Purchases (bill. time or triggered) | 29 | REFNR | Number of Contract Accts Rec. & Payable Doc. | nvarchar | 12 | 0 | | |
47 | DFKKREV07 | Report on Tax on Sales/Purchases (clearing time) | 35 | REFNR | Number of Contract Accts Rec. & Payable Doc. | nvarchar | 12 | 0 | | |
TOPCross-Application Components |
48 | AAUUFK | Order master data | 5 | REFNR | Reference order number | nvarchar | 12 | 0 | | |
TOPFinancial Accounting |
49 | FBICRC001A | ICRC: Open Items GL Accounts: Documents | 37 | REFNR | Reference Number | nvarchar | 30 | 0 | | |
50 | FBICRC002A | ICRC: GL Accounts: Documents | 37 | REFNR | Reference Number | nvarchar | 30 | 0 | | |
51 | FBICRC003A | ICRC: Open Items Customers/Vendors: Documents | 38 | REFNR | Reference Number | nvarchar | 30 | 0 | | |
52 | ICRCA | ICRC: Items to be Reconciled | 24 | REFNR | ICRC: Reference Number for Related Invoice Items | nvarchar | 27 | 0 | | |
53 | ICRCU | ICRC: Potentially Differing Document Groups | 24 | REFNR | ICRC: Reference Number for Related Invoice Items | nvarchar | 27 | 0 | | |
54 | ICRCZ | ICRC: Reconciled, Completed Items | 24 | REFNR | ICRC: Reference Number for Related Invoice Items | nvarchar | 27 | 0 | | |
TOPIntercompany Data Exchange |
55 | EMRDETAIL | IDE: detailed information on MR results (ISU_USAGE_DATA) | 2 | REFNR | Reference number | nvarchar | 30 | 0 | | |
56 | EREFDISSUP | Reference Between Supplier and Distributor Documents | 7 | REFNR | Number of a billing document | nvarchar | 12 | 0 | | |
TOPItaly |
57 | PA0407 | HR master record, infotype 0407 (Abs.addit.inf.) | 30 | REFNR | Reference number | nvarchar | 8 | 0 | | |
TOPJoint Venture und Production Sharing Accounting |
58 | T8JEV | Joint venture event table | 10 | REFNR | Character Field of Length 12 | nvarchar | 12 | 0 | | |
59 | T8PSA_EVENT | PSA Event table | 10 | REFNR | Character Field of Length 12 | nvarchar | 12 | 0 | | |
TOPMaster Data |
60 | SAFK | Run Schedule Master Data | 4 | REFNR | Reference order | nvarchar | 12 | 0 | | |
TOPNetherlands |
61 | T5N1C | Health Insurance Companies (NL) | 5 | REFNR | Reference Number | nvarchar | 10 | 0 | | |
TOPNew Zealand |
62 | PT2001 | HR Time Record: Infotype 2001 (Absences) | 56 | REFNR | Reference number | nvarchar | 8 | 0 | | |
TOPOverhead Cost Orders |
63 | AUFK | Order master data | 5 | REFNR | Reference order number | nvarchar | 12 | 0 | | |
TOPPatient Management |
64 | NKSP | IS-H: Insurance verification/certificate - item data | 34 | REFNR | IS-H: Reference field of an IV item (external reference) | nvarchar | 20 | 0 | | |
65 | NLEI | IS-H: Services Performed | 47 | REFNR | _ | nvarchar | 10 | 0 | | |
TOPPayroll |
66 | T7PL11 | Configuration of data sources for ZUS reporting | 2 | REFNR | Reference number of data source for ZUS reporting | nvarchar | 3 | 0 | | |
67 | T7RO558_AB | Transfer absences (supplement to T558D) | 9 | REFNR | Reference number | nvarchar | 8 | 0 | | |
TOPPension Administration |
68 | PA0845 | HR Master Record Infotype 0845 (Work Relationships) | 30 | REFNR | Reference Number for Uniqueness from Infotype 0845 | nvarchar | 2 | 0 | | |
TOPPeriodical Sales and Distribution |
69 | JKAKPR | Ad Pre-Print Order: Header Data | 20 | REFNR | IS-M: Reference number for ad pre-print order | nvarchar | 20 | 0 | | |
TOPPersonnel Administration |
70 | T7PL05 | Configuration table for GUS forms | 3 | REFNR | Reference number of data source for GUS reporting | nvarchar | 4 | 0 | | |
71 | T7PL0T | Texts for T7PL05 | 3 | REFNR | Reference number of data source for GUS reporting | nvarchar | 4 | 0 | | |
72 | T7PL1T | Texts for T7PL05 | 2 | REFNR | Reference number of data source for GUS reporting | nvarchar | 4 | 0 | | |
73 | T7PLC0 | Identyfikatory skladników dla formularza PIT-8C | 3 | REFNR | Numer referencyjny-PIT 8C | nvarchar | 2 | 0 | | |
74 | T7PLC1 | Opisy skladników dla formularza PIT-8C | 2 | REFNR | Numer referencyjny-PIT 8C | nvarchar | 2 | 0 | | |
TOPPersonnel Time Management |
75 | PA2001 | HR Time Record: Infotype 2001 (Absences) | 56 | REFNR | Reference number | nvarchar | 8 | 0 | | |
TOPPOS Interface |
76 | WPLST | POS interface: processing log | 18 | REFNR | External reference no. (GR/I slip) | nvarchar | 15 | 0 | | |
TOPReal Estate Management |
77 | VIMI04 | Old. replaced in 3.0 with VIMIMV | 92 | REFNR | Reference number for collateral securities | nvarchar | 30 | 0 | | |
78 | VIMI32 | Other collateral | 11 | REFNR | Reference number for collateral securities | nvarchar | 30 | 0 | | |
79 | VIMIMV | Lease-Out | 72 | REFNR | Reference number for collateral securities | nvarchar | 30 | 0 | | |
TOPSAP Healthcare - Industry-Specific Components for Hospitals |
80 | NWCH80 | IS-H CH: ELACH Datenempfang; Ablage Nachrichten feldweise | 13 | REFNR | IS-H CH: N.fattura/richiesta gar.rimb.spese (rifer.a orig.) | nvarchar | 35 | 0 | | |
81 | NWCH94 | Fees: Further Breakdown | 4 | REFNR | Number for Assignment of Further Breakdown | nvarchar | 10 | 0 | | |
TOPSimulation |
82 | VSAUFK_CN | Version: Order master data | 6 | REFNR | Reference order number | nvarchar | 12 | 0 | | |
TOPTools |
83 | PA0579 | HR Master Record Infotype 0579 (Ext. Wage Components) | 25 | REFNR | Reference Number | nvarchar | 40 | 0 | | |
TOPTransaction Manager |
84 | REFCC | References between CO object numbers, currency differences | 3 | REFNR | Netting number | nvarchar | 10 | 0 | | |
85 | REFH | References between CO object numbers, header table | 3 | REFNR | Reference number (unit no.) | nvarchar | 10 | 0 | | |
86 | REFON | References between object numbers (CO object no.) | 3 | REFNR | Reference number (unit no.) | nvarchar | 10 | 0 | | |
87 | THMHRT_HR | Hedge Relationship | 38 | REFNR | Reference number (unit no.) | nvarchar | 10 | 0 | | |
TOPValue Adjustment |
88 | /IBS/TRB_KTO | RBD Account. Master Data | 11 | REFNR | RBD: Reference Number Source System | nvarchar | 100 | 0 | | |
TOPWarehouse Management |
89 | LEIN | Storage unit header records | 20 | REFNR | Group | nvarchar | 10 | 0 | | |
90 | LTAK | WM transfer order header | 11 | REFNR | Group | nvarchar | 10 | 0 | | |
91 | T311 | Definition of WM Groups | 3 | REFNR | Group | nvarchar | 10 | 0 | | |
92 | T311A | Cross-Reference WM Group for Documents | 3 | REFNR | Group | nvarchar | 10 | 0 | | |
93 | T311L | Definition of Run Within a WM Group | 3 | REFNR | Group | nvarchar | 10 | 0 | | |
TOPWarranty Claim Processing |
94 | PNWTYV | Warranty Claim Version (PVS Node) | 11 | REFNR | Reference Number | nvarchar | 35 | 0 | | |
95 | PVWTY | Warranty Claim Item (PPE Variant) | 14 | REFNR | Reference Number | nvarchar | 35 | 0 | | |