| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPBasic Data |
1 | P444V | Planning Versions: Info Structures | 9 | UPNAM | Last Changed By | nvarchar | 12 | 0 | | |
2 | P44V | Planning Versions | 9 | UPNAM | Last Changed By | nvarchar | 12 | 0 | | |
3 | TN11H | IS-H: Hierarchy of Building Units | 7 | UPNAM | IS-H: Name of Person who Last Changed Data | nvarchar | 12 | 0 | | |
TOPBasic Functions |
4 | T820 | Planning Parameters | 52 | UPNAM | Last Changed By | nvarchar | 12 | 0 | | |
TOPClinical System |
5 | N2DLV_RECEIVER | i.s.h.med: Dispatch - Recipient | 29 | UPNAM | IS-H: Name of Person who Last Changed Data | nvarchar | 12 | 0 | | |
TOPConfiguration management |
6 | IBINCM | IB: Config.Mang.: Component/Instance | 28 | UPNAM | Last user to change object | nvarchar | 12 | 0 | | |
7 | IBSPCM | IB: Config.Mang.: Specialization | 21 | UPNAM | Last user to change object | nvarchar | 12 | 0 | | |
8 | IBSTCM | IB: Conf.Mang.:Structure | 9 | UPNAM | Last user to change object | nvarchar | 12 | 0 | | |
TOPDistribution Requirements Planning |
9 | MDRP_DRUN | Deployment run | 12 | UPNAM | Last Changed By | nvarchar | 12 | 0 | | |
TOPInstalled Base |
10 | IBADDR | IBase: Business Address Services Connection | 10 | UPNAM | Last user to change object | nvarchar | 12 | 0 | | |
11 | IBIB | IB: Installed Base/IBase | 5 | UPNAM | Last User to Change Object | nvarchar | 12 | 0 | | |
12 | IBIN | IB: IBase Components - Condition | 28 | UPNAM | Last user to change object | nvarchar | 12 | 0 | | |
13 | IBINTX | IBase: Text for the Instance | 11 | UPNAM | Last user to change object | nvarchar | 12 | 0 | | |
14 | IBSP | IB: Installed Base Component - Enhancement/Specialization | 21 | UPNAM | Last user to change object | nvarchar | 12 | 0 | | |
15 | IBST | IB: Installation Component - Structure | 9 | UPNAM | Last user to change object | nvarchar | 12 | 0 | | |
TOPLocalization |
16 | J_1B_CIAP_OBJECT | CIAP document data | 41 | UPNAM | Last Changed By | nvarchar | 12 | 0 | | |
TOPPatient Accounting |
17 | NWVIEW_L07_FORMS | IS-H: Forms Entered for Case | 13 | UPNAM | IS-H: Name of Person who Last Changed Data | nvarchar | 12 | 0 | | |
TOPProfitability Analysis |
18 | T821S | Distribution keys | 6 | UPNAM | Last Changed By | nvarchar | 12 | 0 | | |
19 | TKEPPLLEV | Planning Level - Header | 9 | UPNAM | Last Changed By | nvarchar | 12 | 0 | | |
20 | TKEPPLMEPAH | Planning Parameters - Header | 11 | UPNAM | Last Changed By | nvarchar | 12 | 0 | | |
21 | TKEPPLPPH | Planning Package - Header | 10 | UPNAM | Last Changed By | nvarchar | 12 | 0 | | |
22 | TKEPPLPROH | Profile - Header Table | 8 | UPNAM | Last Changed By | nvarchar | 12 | 0 | | |
23 | TKEPPLPROTO | Log Structures for CO-PA Planning | 8 | UPNAM | Last Changed By | nvarchar | 12 | 0 | | |
24 | TKEPTRK | Events: Header | 9 | UPNAM | Last Changed By | nvarchar | 12 | 0 | | |
TOPSales Plan |
25 | ERKO | Event Header | 9 | UPNAM | Last Changed By | nvarchar | 12 | 0 | | |
26 | ERZU | Event Assignment | 18 | UPNAM | Last Changed By | nvarchar | 12 | 0 | | |
27 | LISPL | Background Job for LIS Planning | 13 | UPNAM | Last Changed By | nvarchar | 12 | 0 | | |
28 | P445V | Sales and Operations Planning: Versions | 12 | UPNAM | Last Changed By | nvarchar | 12 | 0 | | |
29 | P445X | LIS Planning Versions Table | 10 | UPNAM | Last Changed By | nvarchar | 12 | 0 | | |
30 | T445P | Planning Types: LIS/SOP | 19 | UPNAM | Last Changed By | nvarchar | 12 | 0 | | |
TOPSAP Healthcare - Industry-Specific Components for Hospitals |
31 | /ISHFR/COSTCOV | IS-H FR: Coverage | 14 | UPNAM | IS-H: Name of Person who Last Changed Data | nvarchar | 12 | 0 | | |
32 | NNL_CLASSL | Meldung Klassifikation log | 9 | UPNAM | IS-H: Name des ändernden Sachbearbeiters | nvarchar | 12 | 0 | | |
33 | NNL_DDS_QH | Deklaration Query kopf | 15 | UPNAM | IS-H: Name des ändernden Sachbearbeiters | nvarchar | 12 | 0 | | |
34 | NNL_DDS_QHL | Deklaration Query kopf log | 16 | UPNAM | IS-H: Name des ändernden Sachbearbeiters | nvarchar | 12 | 0 | | |
35 | NNL_DDS_RH | Deklaration Ergebnis kopf | 26 | UPNAM | IS-H: Name des ändernden Sachbearbeiters | nvarchar | 12 | 0 | | |
36 | NNL_DDS_RHL | Deklaration Ergebnis kopf log | 27 | UPNAM | IS-H: Name des ändernden Sachbearbeiters | nvarchar | 12 | 0 | | |
TOPSCM Basis |
37 | /SAPAPO/DP440G | Master Forecast Profile (APO0300) | 37 | UPNAM | Last Changed By | nvarchar | 12 | 0 | | |
38 | /SAPAPO/DP_ALERT | Profile for Filtering Output to Alert Monitor | 12 | UPNAM | Last Changed By | nvarchar | 12 | 0 | | |
39 | /SAPAPO/TIMESERI | Time Series in Forecast | 22 | UPNAM | Last Changed By | nvarchar | 12 | 0 | | |
TOPTariffs, Duties and Permits |
40 | OIHL | License Master Data | 34 | UPNAM | Name of Person Who Changed Object | nvarchar | 12 | 0 | | |