| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /AIF/T_CIFPP_IDX | Standard Index Table for CIF Postprocessing | 39 | POSNO | Order Item | nvarchar | 6 | 0 | | |
2 | AIS_LAYOUT_MRTAB | Key Figures on CfaR Tab for Std Rep. on RDB (Period ALV) | 4 | POSNO | Display Sequence of Key Figures | nvarchar | 2 | 0 | | |
3 | AIS_LAYOUT_MRTB2 | Key Figures on CfaR Tab for Std Rep. on RDB (Period ALV) | 4 | POSNO | Display Sequence of Key Figures | nvarchar | 2 | 0 | | |
4 | BKK_OPD_IT_EXT | External Item Selection Table - Outgoing Payment Dispatcher | 4 | POSNO | Item in Payment Order | nvarchar | 5 | 0 | | |
5 | BKK_SEPA_LIM_EV | Event Table for Mandate Limits | 6 | POSNO | Position in Item | nvarchar | 3 | 0 | | |
6 | BKK_SEPA_LIM_HIS | History Table for Mandate Limits | 7 | POSNO | Position in Item | nvarchar | 3 | 0 | | |
7 | PA3366 | HR Master Record: Infotype 3366 | 27 | POSNO | Post box or private bag number | nvarchar | 8 | 0 | | |
8 | PB3366 | Applicant data infotype 3366 (model) | 27 | POSNO | Post box or private bag number | nvarchar | 8 | 0 | | |
9 | TNWAT_FREQU | Leistungsgenerierung für ambulante Besuche | 9 | POSNO | IS-H: Positionsnummer | nvarchar | 4 | 0 | | |
10 | TNWCHSDRG03 | Swiss-DRG - Leistungsregeln DRG-Zusatzentgelte Medikamente | 10 | POSNO | IS-H CH: Positionsnummer | nvarchar | 4 | 0 | | |
11 | TNWCH_ADDCHARGE | Leistungsregel: Altersprüfung bei Zusatzentgelten | 9 | POSNO | IS-H CH: Positionsnummer | nvarchar | 4 | 0 | | |
12 | TNWCH_ATC_REL | Statistikrelevante ATC-Codes | 5 | POSNO | IS-H CH: Positionsnummer | nvarchar | 4 | 0 | | |
TOPAccount Management |
13 | BKKITNTC | Notice: Payment Item with Notice Lock Period > 0 | 6 | POSNO | Position in Item | nvarchar | 3 | 0 | | |
TOPAerospace Defence Industry Solution |
14 | DIT434P | Stock determination: FS item table | 5 | POSNO | Stock determination: Item number | nvarchar | 3 | 0 | | |
TOPALE Integration Technology |
15 | EDISYN | Syntax Description for Extended Basic Types | 3 | POSNO | Sequential Number of Segment in IDoc Type | nvarchar | 4 | 0 | | |
16 | EDSYN | IDoc syntax after 3.0 | 2 | POSNO | Sequential Number of Segment in IDoc Type | nvarchar | 4 | 0 | | |
TOPBank Customer Accounts |
17 | BKKCORRITEM | Auxiliary Table: Payment Items for Adjustments | 4 | POSNO | Position in Item | nvarchar | 3 | 0 | | |
18 | BKK_PRENOTE | Prenotes | 36 | POSNO | Position in Item | nvarchar | 3 | 0 | | |
TOPChina |
19 | PA0536 | HR Master Record: Infotype 0536 (Administration) | 41 | POSNO | Position number | nvarchar | 1 | 0 | | |
TOPConfiguration management |
20 | IBSTCM | IB: Conf.Mang.:Structure | 12 | POSNO | IB: Item number | nvarchar | 4 | 0 | | |
TOPCustomer Bill of Services |
21 | BOSPS_ATTRBOS | BOS PS Object link attribute references | 3 | POSNO | Sequential Number of Segment in IDoc Type | nvarchar | 4 | 0 | | |
TOPCustomer Contact |
22 | BPCTPOSFORM | Object Relationships for BP Contact: Attribute Values | 3 | POSNO | Sequential Number of Segment in IDoc Type | nvarchar | 4 | 0 | | |
TOPGeneral Object Relations |
23 | SRABRELSD | Object relationship: attribute position assignment logistics | 3 | POSNO | Sequential Number of Segment in IDoc Type | nvarchar | 4 | 0 | | |
TOPGL transfer |
24 | BKKC12_ITEM | GL: New Balances for Balance Sheet Preparation (Items) | 4 | POSNO | Position in Item | nvarchar | 3 | 0 | | |
25 | BKKCNOITGL | Table of Items not Updated on the Account | 4 | POSNO | Position in Item | nvarchar | 3 | 0 | | |
26 | BKKITGL | Gen. Ledger: Payment Item Data | 4 | POSNO | Position in Item | nvarchar | 3 | 0 | | |
TOPInformation System |
27 | AIS_LAYOUT_BTTAB | Key Figs for Backtesting Tab Page in Std Report for RDB | 4 | POSNO | Display Sequence of Key Figures | nvarchar | 2 | 0 | | |
28 | AIS_LAYOUT_FLTAB | Key Figures on PA Flow Tab for Standard Reporting on RDB | 4 | POSNO | Display Sequence of Key Figures | nvarchar | 2 | 0 | | |
29 | AIS_LAYOUT_MATAB | Key Figures on Mat. Band Tab for Standard Reporting on RDB | 4 | POSNO | Display Sequence of Key Figures | nvarchar | 2 | 0 | | |
30 | AIS_LAYOUT_PHFRM | Key Figures in PH Frame for Standard Reporting on the RDB | 4 | POSNO | Display Sequence of Key Figures | nvarchar | 2 | 0 | | |
31 | AIS_LAYOUT_RHTAB | Key Figures on RH Tab for Standard Reporting on the RDB | 4 | POSNO | Display Sequence of Key Figures | nvarchar | 2 | 0 | | |
32 | AIS_LAYOUT_SSTAB | Key Figures on Line Items Tab for Standard Rep. on RDB | 4 | POSNO | Display Sequence of Key Figures | nvarchar | 2 | 0 | | |
TOPInstalled Base |
33 | IBST | IB: Installation Component - Structure | 12 | POSNO | IB: Item number | nvarchar | 4 | 0 | | |
34 | T371Y | IBase: Tabstrip Control | 2 | POSNO | IB: Item number | nvarchar | 4 | 0 | | |
TOPLogistics - General |
35 | CRMVBREF2 | SD Object Link to Item References | 3 | POSNO | Sequential Number of Segment in IDoc Type | nvarchar | 4 | 0 | | |
TOPLogistics Basic Data |
36 | T434P | Stock determination: FS item table | 5 | POSNO | Stock determination: Item number | nvarchar | 3 | 0 | | |
TOPMaster Data |
37 | BCA_US_HLD2REL | Hold Records which have not been released - Dual Control | 22 | POSNO | Position in Item | nvarchar | 3 | 0 | | |
38 | BCA_US_HOLD | Hold Amounts Which Affect Available Balance | 21 | POSNO | Position in Item | nvarchar | 3 | 0 | | |
TOPMedia Product |
39 | JPTTTLLNKATTR | Attributes for Generic Title Object Relationship | 3 | POSNO | Sequential Number of Segment in IDoc Type | nvarchar | 4 | 0 | | |
TOPOffer and Rental Request |
40 | TIVORHMATTRA | Accommodation Attributes | 5 | POSNO | Position Number | nvarchar | 2 | 0 | | |
41 | TIVORHMATTRP | Personnel Attributes | 5 | POSNO | Position Number | nvarchar | 2 | 0 | | |
TOPPatient Accounting |
42 | TNRS2_CT | IS-H: Check Procedure for Rules - Case Category Restriction | 7 | POSNO | IS-H: Item Number | nvarchar | 4 | 0 | | |
TOPPayment Item |
43 | BKKI3 | Turnover Items Not Posted for Last Bank Statement | 4 | POSNO | Position in Item | nvarchar | 3 | 0 | | |
44 | BKKIT | Payment Item | 4 | POSNO | Position in Item | nvarchar | 3 | 0 | | |
45 | BKKITADR | Payment Item: Address of Transferring Party | 4 | POSNO | Position in Item | nvarchar | 3 | 0 | | |
46 | BKKITAI | Info Items for Interest Penalty at Balancing | 4 | POSNO | Position in Item | nvarchar | 3 | 0 | | |
47 | BKKITENQ | Blocked Payment Items | 4 | POSNO | Position in Item | nvarchar | 3 | 0 | | |
48 | BKKITPRE | Parked Payment Items | 6 | POSNO | Position in Item | nvarchar | 3 | 0 | | |
49 | BKKITREL | Payment Item | 4 | POSNO | Position in Item | nvarchar | 3 | 0 | | |
50 | BKKITTMP | Planned Payment Items | 4 | POSNO | Position in Item | nvarchar | 3 | 0 | | |
51 | BKKITTMP_DEL | Planned Payment Items - Completed | 4 | POSNO | Position in Item | nvarchar | 3 | 0 | | |
52 | BKKNT | Purpose | 4 | POSNO | Position in Item | nvarchar | 3 | 0 | | |
53 | BKKNTTMP | Payment Notes of Planned Payment Items | 4 | POSNO | Position in Item | nvarchar | 3 | 0 | | |
TOPPayment Order |
54 | BKKPOIT | Item in Payment Order | 4 | POSNO | Item in Payment Order | nvarchar | 5 | 0 | | |
55 | BKKPOIT_TMP | Items in Planned Payment Order | 4 | POSNO | Item in Payment Order | nvarchar | 5 | 0 | | |
56 | BKKPOIT_TMP_DEL | Items in Planned Payment Order | 4 | POSNO | Item in Payment Order | nvarchar | 5 | 0 | | |
57 | BKKPONT | Payment Order, Application of Funds | 4 | POSNO | Item in Payment Order | nvarchar | 5 | 0 | | |
58 | BKKPONT_TMP | Planned Payment Order, Payment Details | 4 | POSNO | Item in Payment Order | nvarchar | 5 | 0 | | |
59 | BKKPONT_TMP_DEL | Planned Payment Order, Payment Details | 4 | POSNO | Item in Payment Order | nvarchar | 5 | 0 | | |
TOPReport Selection for Product Costing |
60 | TKKR4 | Hierarchy Summarization (Summarized Object Types) | 10 | POSNO | Sequence for Summarization Object Type | nvarchar | 2 | 0 | | |
TOPRisk Analysis |
61 | JBRRMBM | Assignment of Characteristics to Analysis Structures | 5 | POSNO | RM: Position of Characteristic in Characteristics Entry | tinyint | 3 | 0 | | |
TOPSales |
62 | VBREF | SD Object Link to Item References | 3 | POSNO | Sequential Number of Segment in IDoc Type | nvarchar | 4 | 0 | | |
TOPSAP Business Partner |
63 | TB040F | BDT: Selection and Display Fields of Evaluation | 6 | POSNO | BP: Item no. on selection screen in relation to section no. | nvarchar | 3 | 0 | | |
TOPSAP Healthcare - Industry-Specific Components for Hospitals |
64 | /ISHFR/NVVW_TDA | Individual Contract Scheme Item Data - Time-Dependent | 5 | POSNO | IS-H: Item Number | nvarchar | 4 | 0 | | |
65 | /ISHFR/TN16P_TDA | Items for Contract Schemes - Time-Dependent | 4 | POSNO | IS-H: Item Number | nvarchar | 4 | 0 | | |
66 | /ISHFR/TNGAPP | IS-H FR: Supplements (Item Data) | 10 | POSNO | IS-H: Item Number | nvarchar | 4 | 0 | | |
67 | /ISHFR/TNWFR_F10 | IS-H FR: Per Diem Fee | 13 | POSNO | Item Number | nvarchar | 4 | 0 | | |
68 | NCH40 | IS-H CH: Service Rules Billability/Flat Rate Consolidation | 16 | POSNO | IS-H CH: Item number | nvarchar | 4 | 0 | | |
69 | NCH43 | IS-H CH: Leistungsregeln Zuschlagsleistungen | 15 | POSNO | IS-H CH: Numero posizione | nvarchar | 4 | 0 | | |
70 | NCH43A | IS-H CH: Rollenumschlüsselung für Arztzuordnungen | 14 | POSNO | IS-H CH: Numero posizione | nvarchar | 4 | 0 | | |
71 | NCH44 | IS-H CH: Leistungsregeln OPS | 14 | POSNO | IS-H CH: Numero posizione | nvarchar | 4 | 0 | | |
72 | NCH44A | IS-H CH: Rollenumschlüsselung für Arztzuordnungen | 13 | POSNO | IS-H CH: Numero posizione | nvarchar | 4 | 0 | | |
73 | NCH45 | IS-H CH: Leistungsregeln Radiologie | 6 | POSNO | IS-H CH: Numero posizione | nvarchar | 4 | 0 | | |
74 | NVVW | IS-H: Individual Contract Schemes Item Data | 5 | POSNO | IS-H: Item Number | nvarchar | 4 | 0 | | |
75 | TN16P | IS-H SG: Contract Scheme Items | 4 | POSNO | IS-H: Item Number | nvarchar | 4 | 0 | | |
76 | TNA40S | IS-H AT: Leistungsregeln Höchstwertstaffelung | 7 | POSNO | IS-H CH: Positionsnummer | nvarchar | 4 | 0 | | |
77 | TNA40V | IS-H AT: Leistungsregeln Abrechenbarkeit/Pauschalierung | 12 | POSNO | IS-H CH: Positionsnummer | nvarchar | 4 | 0 | | |
78 | TNAUMLEI | IS-H AT: Umschlüsselung Leistung | 16 | POSNO | IS-H CH: Positionsnummer | nvarchar | 4 | 0 | | |
79 | TNCH51 | IS-H CH: Billing Agreement Items | 4 | POSNO | IS-H CH: Item number | nvarchar | 4 | 0 | | |
80 | TNWAT_SCOEWKOMM | IS-H AT: Scoring - Std-Kommentar für akzept. Errors/Warnings | 4 | POSNO | IS-H AT: Positionsnummer | nvarchar | 4 | 0 | | |
81 | TNWCHSDRG02 | Swiss-DRG - Leistungsregeln DRG-Zusatzentgelte generieren | 11 | POSNO | IS-H CH: Positionsnummer | nvarchar | 4 | 0 | | |
82 | TNWCH_AL_EXTRA | IS-H CH: ANALYSE - Leistungsregeln Zuschlagsleistungen | 16 | POSNO | IS-H CH : numéro de poste | nvarchar | 4 | 0 | | |
TOPSCM Basis |
83 | CIFERRLOG | Error Recording in Enhanced CIF Error Handling | 27 | POSNO | Item Number of Document (Purchasing, Sales...) | nvarchar | 6 | 0 | | |
TOPTransportation and Distribution |
84 | OIGSMS | TD Material Samples on a Shipment | 4 | POSNO | Sequential Number of Segment in IDoc Type | nvarchar | 4 | 0 | | |
85 | OIGSVCS | TD Vehicle Seals on Transport Units | 5 | POSNO | Item number (2 digits) | nvarchar | 2 | 0 | | |