| 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) | 23 | STATU | | nvarchar | 1 | 0 | | |
2 | /BIC/B0000188000 | PSA for 2LIS_02_HDR T90CLNT090 Purch.Data (Header) | 24 | STATU | | nvarchar | 1 | 0 | | |
3 | /BIC/B0000189000 | PSA for 2LIS_02_SCL T90CLNT090 Purch.Data Sch.Line | 23 | STATU | | nvarchar | 1 | 0 | | |
4 | /SMERP/STG_PM006 | Data staging - Equip List Set - Classifications - Cmplx Tab | 15 | STATU | Classification status | nvarchar | 1 | 0 | | |
5 | /SMERP/STG_PM011 | Data staging - Func Loc. LSet - Classifications - Cmplx Tab | 15 | STATU | Classification status | nvarchar | 1 | 0 | | |
6 | HRP1654 | Table BD pour infotype 1654 | 19 | STATU | Statut | nvarchar | 4 | 0 | | |
7 | KSSK_CONV | Allocation Table: Object to Class | 8 | STATU | Classification status | nvarchar | 1 | 0 | | |
8 | P08P1CLS | CLASS CPX INTERFACE Snapshot Table | 12 | STATU | CLASS CPX INTERFACE Status | nvarchar | 1 | 0 | | |
9 | P2NZ_LVACC | Payroll Result: Leave Accruals LVACC - NZ | 9 | STATU | LVACC record status for NZ payroll | nvarchar | 1 | 0 | | |
10 | PA0863 | Infotype 0863 | 25 | STATU | Statut | nvarchar | 4 | 0 | | |
11 | PA3311 | HR Master Record: Infotype 3311 | 32 | STATU | Pension Service Duration Status | nvarchar | 1 | 0 | | |
12 | PA3336 | HR Master Record: Infotype 3336 | 32 | STATU | Pension Service Duration Status | nvarchar | 1 | 0 | | |
13 | PDPBSZVADM_R | SPI Confirmation: Administration Table | 13 | STATU | Notification Block Status, DATUEV-ZVE | nvarchar | 2 | 0 | | |
14 | PDPBSZVLOG_R | SPI Confirmation: Log Table | 4 | STATU | Notification Block Status, DATUEV-ZVE | nvarchar | 2 | 0 | | |
15 | T020 | FI/AM Transaction Control | 6 | STATU | Program Status at Start of Transaction | nvarchar | 8 | 0 | | |
16 | T5FPBSD10 | Clasification statut pour décisions | 2 | STATU | Statut | nvarchar | 4 | 0 | | |
17 | T5FPBSD10T | Libellés classification statuts pour décisions | 3 | STATU | Statut | nvarchar | 4 | 0 | | |
18 | T5FPBSD4 | Statuts de décision par modificateur | 3 | STATU | Statut | nvarchar | 4 | 0 | | |
19 | T5H81T | Registered employment relationships (multiple employer) | 3 | STATU | | nvarchar | 1 | 0 | | |
20 | T5H82T | Registered employment relationships (multiple employer) | 3 | STATU | | nvarchar | 1 | 0 | | |
21 | T5RPD | Personnel Data Deletion Log | 4 | STATU | Status for Destroying Personnel Numbers | nvarchar | 2 | 0 | | |
22 | T5RPL | Personnel Data Deletion Log | 4 | STATU | Status for Destroying Personnel Numbers | nvarchar | 2 | 0 | | |
23 | T7INDA_STATUS | Status for DA Process | 3 | STATU | Status of the Disciplinary Action | nvarchar | 3 | 0 | | |
24 | T7INDA_STATUST | Status text for DA | 4 | STATU | Status of the Disciplinary Action | nvarchar | 3 | 0 | | |
25 | T7RU53 | Employee Group/Subgroup Russia attributes | 4 | STATU | Employee Grouping for Reporting | nvarchar | 1 | 0 | | |
26 | T7RU53ST | Status for PSG - reporting | 3 | STATU | Employee Grouping for Reporting | nvarchar | 1 | 0 | | |
27 | TCA43 | Automatic selection of task lists (alternatives) | 6 | STATU | Status | nvarchar | 3 | 0 | | |
28 | TCLC | Classification Status | 3 | STATU | Classification status | nvarchar | 1 | 0 | | |
29 | TKSB0 | Transaction control CO | 7 | STATU | Program Status at Start of Transaction | nvarchar | 8 | 0 | | |
30 | YIT_PROC | IDA: Processes in IDES | 13 | STATU | IDA: status of script, process, training | nvarchar | 4 | 0 | | |
31 | YIT_STATU | IDA: Status | 1 | STATU | IDA: status of script, process, training | nvarchar | 4 | 0 | | |
32 | YIT_STATUL | IDA: Status | 1 | STATU | IDA: status of script, process, training | nvarchar | 4 | 0 | | |
TOPAssortment Maintenance |
33 | WRS1 | Assortment | 3 | STATU | Status of assortment | nvarchar | 1 | 0 | | |
TOPAustria |
34 | PA0367 | HR Master Record: Infotype 0367 (SI Notification Suppl. A) | 26 | STATU | Status Information for ELDA | nvarchar | 1 | 0 | | |
35 | PA0467 | HR Master Record: Infotype 0467 (Add'l SI Notif. f.Comp A) | 26 | STATU | Status Information for ELDA | nvarchar | 1 | 0 | | |
36 | PA0526 | HR Master Record: Infotype 0526 | 26 | STATU | Status Information for ELDA | nvarchar | 1 | 0 | | |
37 | T5A1O | ELDA: Data Records Created | 7 | STATU | ELDA: Status of Data Record | nvarchar | 1 | 0 | | |
38 | T5A1Q | ELDA: Confirmed Data Records | 7 | STATU | ELDA: Status of Data Record | nvarchar | 1 | 0 | | |
TOPBasic Data |
39 | P44V | Planning Versions | 15 | STATU | LIS version status | nvarchar | 1 | 0 | | |
TOPBasic Functions |
40 | T852G | Subgroup companies | 12 | STATU | Company status | nvarchar | 1 | 0 | | |
41 | TVBST | SD Documents: Processing Status: Texts | 5 | STATU | General SD status | nvarchar | 1 | 0 | | |
TOPChina |
42 | PA0528 | HR Master Record: Infotype 0528 (Family information) | 40 | STATU | Job status | nvarchar | 2 | 0 | | |
43 | T7CN65 | Occupation status for family member | 2 | STATU | Job status | nvarchar | 2 | 0 | | |
44 | T7CN6X | Occoupation status text | 3 | STATU | Job status | nvarchar | 2 | 0 | | |
TOPClasses |
45 | INOB | Link between Internal Number and Object | 9 | STATU | Classification status | nvarchar | 1 | 0 | | |
46 | KLAH | Class Header Data | 5 | STATU | Class status | nvarchar | 1 | 0 | | |
47 | KSSK | Allocation Table: Object to Class | 8 | STATU | Classification status | nvarchar | 1 | 0 | | |
TOPClinical System |
48 | N1PRFAL | IS-H*MED: PATREG: Fälle | 8 | STATU | IS-H: Olgu durumu | nvarchar | 1 | 0 | | |
49 | N1PRPAT | IS-H*MED: PATREG: Patientenstammdatentabelle | 50 | STATU | IS-H: Hasta durumu | nvarchar | 1 | 0 | | |
50 | N1PRTMPPAT | IS-H*MED: PATREG: Temporäre Patientenstammdatentabelle | 51 | STATU | IS-H: Hasta durumu | nvarchar | 1 | 0 | | |
51 | N1PRTMPPATLOC | IS-H*MED: PATREG: NPAT umgeschlüsselt auf N1PRPAT lokal | 51 | STATU | IS-H: Hasta durumu | nvarchar | 1 | 0 | | |
52 | N2DOCFAL | IS-H*MED: Case Data for Archived Documents | 16 | STATU | IS-H: Case Status | nvarchar | 1 | 0 | | |
TOPContract Accounts Receivable and Payable |
53 | DFKKDEFREV_HEAD | Header Table (Event-Based Deferred Revenues) | 5 | STATU | Status of Event-Based Deferred Revenues | nvarchar | 1 | 0 | | |
TOPCross-Application Component CA Enhancements |
54 | MILL_CLPROFP | Profile for Selection by Characteristics: Items | 18 | STATU | Yes/No (X/ ) | nvarchar | 1 | 0 | | |
TOPCross-Application Components |
55 | FRE_MC_MCH_NODE | Merchandise Category and MC-Hier. Node sent to F&R | 4 | STATU | Class status | nvarchar | 1 | 0 | | |
TOPDefense Forces and Public Security |
56 | /ISDFPS/ZEBAN | Copy of EBAN | 8 | STATU | Processing status of purchase requisition | nvarchar | 1 | 0 | | |
TOPDistribution Requirements Planning |
57 | MDRP_DRUN | Deployment run | 15 | STATU | Status of background job | nvarchar | 1 | 0 | | |
TOPEngineering Configuration Order BOM |
58 | CUOBOM_CHANGE | Manually Changed Items in the Order BOM | 12 | STATU | Change status of an item in the order BOM | nvarchar | 1 | 0 | | |
TOPEnvironment |
59 | LKLAH | Class Header (Special Objects) | 5 | STATU | Class status | nvarchar | 1 | 0 | | |
60 | LKSSK | Allocation Table: Object to Class | 8 | STATU | Classification status | nvarchar | 1 | 0 | | |
TOPExternal personnel administration |
61 | HRWFD_HEAD | HCM - WFD Main interface table | 9 | STATU | Status for HCM - WFD interface | nvarchar | 1 | 0 | | |
TOPFlow Manufacturing |
62 | LDLBH | Line balance/planned rate header record | 4 | STATU | Status of line balance | nvarchar | 1 | 0 | | |
TOPFrance |
63 | HRT1680 | Table Part Infotype 1680 | 4 | STATU | Training Need Status Code | nvarchar | 4 | 0 | | |
64 | T77TNM_RE | Table Training Needs Status Reason | 3 | STATU | Training Need Status Code | nvarchar | 4 | 0 | | |
65 | T77TNM_RET | Table Training Needs Status Reason Text | 4 | STATU | Training Need Status Code | nvarchar | 4 | 0 | | |
66 | T77TNM_ST | Table Training Needs Status | 3 | STATU | Training Need Status Code | nvarchar | 4 | 0 | | |
67 | T77TNM_STT | Table Training Needs Status Text | 4 | STATU | Training Need Status Code | nvarchar | 4 | 0 | | |
TOPInventory Controlling |
68 | PROP | Forecast parameters | 43 | STATU | LIS version status | nvarchar | 1 | 0 | | |
TOPMaterials Management |
69 | /ISDFPS/CS_EXLST | Exception List: Overwritten Purchase Requisitions | 13 | STATU | Processing status of purchase requisition | nvarchar | 1 | 0 | | |
TOPNetherlands |
70 | T5N1T | NSI: Created Data Records (Retroactive) | 6 | STATU | NSI: Status of Data Record | nvarchar | 1 | 0 | | |
71 | T5N5D | NSI: Created Data Records | 7 | STATU | NSI: Status of Data Record | nvarchar | 1 | 0 | | |
TOPOwnership |
72 | OIUOW_ORP_TWB | ORP test workbench comparison history | 6 | STATU | CHAR01 data element for SYST | nvarchar | 1 | 0 | | |
TOPPatient Accounting |
73 | NFAP | IS-H: Items for CASE selection billing | 6 | STATU | IS-H: Status of case after billing (E)rror (W)arning (S)ucce | nvarchar | 1 | 0 | | |
TOPPatient Management |
74 | NAPP | IS-H: Provisional Appointments for Visit Scheduling | 10 | STATU | IS-H: Internal Status of Outpatient Visit | nvarchar | 2 | 0 | | |
75 | NBEW | IS-H: Movements for Case | 10 | STATU | IS-H: Internal Status of Outpatient Visit | nvarchar | 2 | 0 | | |
76 | NFAL | IS-H: Cases | 16 | STATU | IS-H: Case Status | nvarchar | 1 | 0 | | |
77 | NPAE | IS-H: Patient Master Data (Institution-Related) | 7 | STATU | Patient Status | nvarchar | 1 | 0 | | |
78 | NPAT | IS-H: Patient Master Data (General) | 41 | STATU | Patient Status | nvarchar | 1 | 0 | | |
TOPPayroll |
79 | PA0730 | Personál.kmen.záznam Infotyp 0730 | 38 | STATU | Status výpoctu (Zkuš.doba,Výsluha,Jmenování,Tarif,Místo... ) | nvarchar | 1 | 0 | | |
80 | PB0730 | Personál.kmen.záznam Infotyp 0730 | 38 | STATU | Status výpoctu (Zkuš.doba,Výsluha,Jmenování,Tarif,Místo... ) | nvarchar | 1 | 0 | | |
81 | T5H81 | Registered employment relationships | 3 | STATU | | nvarchar | 1 | 0 | | |
82 | T5H81M | Registered employment relationships -- for comm. contracts | 3 | STATU | | nvarchar | 1 | 0 | | |
83 | T5H82 | Registered employment relationships - sent statuses | 3 | STATU | | nvarchar | 1 | 0 | | |
84 | T5H82M | Registered employment relationships -- for comm. contracts | 3 | STATU | | nvarchar | 1 | 0 | | |
85 | T7RO1P | Insurance result table - Person 1:1 with RGDIR | 5 | STATU | Single-Character Indicator | nvarchar | 1 | 0 | | |
86 | T7ROA2 | Insurance result table - Person 1:1 with RGDIR | 5 | STATU | Single-Character Indicator | nvarchar | 1 | 0 | | |
87 | T7SKDNP | HR Cluster with simulated bases for DNP calc. in 1/2010 | 7 | STATU | Internal Use | nvarchar | 1 | 0 | | |
88 | T7SKRL | HR Cluster 2 | 7 | STATU | Internal Use | nvarchar | 1 | 0 | | |
89 | T7SKRZZP | HR Cluster 2 | 8 | STATU | Status field list (supplementary insurance -Public Sector) | nvarchar | 10 | 0 | | |
TOPPersonnel Administration |
90 | HRPAD_DELPN | Status Table for Destruction of Data in Live Systems | 4 | STATU | Status for Destroying Personnel Numbers in Live Systems | nvarchar | 2 | 0 | | |
91 | T582L | Infotypes - country-specific settings | 5 | STATU | Status for country dependency in infotypes | nvarchar | 1 | 0 | | |
TOPProduct Safety |
92 | TCGRULPOSMREST | EHS: Easy Expert Set of Rules, Characteristic Restrictions | 72 | STATU | Yes/No (X/ ) | nvarchar | 1 | 0 | | |
TOPProduction Optimization Interface POI |
93 | TCLOI2 | Status Filter for Task List Selection | 3 | STATU | Status | nvarchar | 3 | 0 | | |
TOPPublic Sector |
94 | PA0794 | HR Master Record Infotype 0794 | 25 | STATU | Status Information for ELDA | nvarchar | 1 | 0 | | |
95 | PDPBSZVADM | Administration Table for ZVE-PBS Notification Procedure | 11 | STATU | Notification Block Status, DATUEV-ZVE | nvarchar | 2 | 0 | | |
96 | PDPBSZVLOG | Log Table for ZVE-PBS Notification Procedure | 10 | STATU | Notification Block Status, DATUEV-ZVE | nvarchar | 2 | 0 | | |
97 | PDPBSZVSUM | Totals Record (Record Type 90), SPI | 20 | STATU | Notification Block Status, DATUEV-ZVE | nvarchar | 2 | 0 | | |
98 | T5D5G | Supplementary Pension Public Sector: Combination Table | 19 | STATU | Status Field String (Supplementary Pension - Public Sector) | nvarchar | 10 | 0 | | |
TOPPurchasing |
99 | EBAN | Purchase Requisition | 8 | STATU | Processing status of purchase requisition | nvarchar | 1 | 0 | | |
100 | EKKO | Purchasing Document Header | 8 | STATU | Status of Purchasing Document | nvarchar | 1 | 0 | | |
101 | EKPB | "Material Provided" Item in Purchasing Document | 6 | STATU | Indicator: Firm or Trade-Off Zone | nvarchar | 1 | 0 | | |
102 | EKPO | Purchasing Document Item | 5 | STATU | RFQ status | nvarchar | 1 | 0 | | |
103 | MEREQX | Purchase Requisition Change Parameter | 8 | STATU | Updated information in related user data field | nvarchar | 1 | 0 | | |
104 | WDFR_POS | Perishables Planninng Item | 56 | STATU | RFQ status | nvarchar | 1 | 0 | | |
TOPRecruitment |
105 | T750X | Vacancy | 18 | STATU | Staffing status | nvarchar | 1 | 0 | | |
TOPResourcen Management |
106 | MRTRST_HDR | RMS-MRTRS : MR Transformation Header | 26 | STATU | Status | nvarchar | 3 | 0 | | |
107 | RMXTC_T18 | TMS-API: Cust.: Status of Insp. Plans Copied w. Stab. Study | 3 | STATU | Status | nvarchar | 3 | 0 | | |
TOPReuse Services for Country Development |
108 | PA0860 | HR Master Record: Infotype 0860 | 24 | STATU | Status | nvarchar | 4 | 0 | | |
109 | PA0861 | HR Master Record: Infotype 0861 | 32 | STATU | Status | nvarchar | 4 | 0 | | |
110 | T5F99A4 | Status | 3 | STATU | Status | nvarchar | 4 | 0 | | |
111 | T5F99A4T | Status Texts | 4 | STATU | Status | nvarchar | 4 | 0 | | |
112 | T5F99P1 | Status | 3 | STATU | Status | nvarchar | 4 | 0 | | |
113 | T5F99P1T | Status Text | 4 | STATU | Status | nvarchar | 4 | 0 | | |
TOPRouting |
114 | PLKO | Task list - header | 17 | STATU | Status | nvarchar | 3 | 0 | | |
TOPSales Plan |
115 | LISPL | Background Job for LIS Planning | 17 | STATU | Status of background job | nvarchar | 1 | 0 | | |
116 | LISPLF | Planning Entries Table for Background Planning in LIS | 7 | STATU | Processing status: step carried out in the background | nvarchar | 1 | 0 | | |
117 | P445G | Parameters for PLOB Version_Key Figure | 7 | STATU | Indicator of origin for stock | nvarchar | 1 | 0 | | |
118 | P445S | Possible Version Statuses | 2 | STATU | LIS version status | nvarchar | 1 | 0 | | |
119 | P445T | Version Status Text | 3 | STATU | LIS version status | nvarchar | 1 | 0 | | |
120 | P445V | Sales and Operations Planning: Versions | 16 | STATU | LIS version status | nvarchar | 1 | 0 | | |
121 | P445X | LIS Planning Versions Table | 14 | STATU | LIS version status | nvarchar | 1 | 0 | | |
122 | PGAN | Proportional Factors per Planning Object Relation (SOP/LIS) | 9 | STATU | LIS branch status | nvarchar | 1 | 0 | | |
123 | PGMI | Product Group/Member Allocation | 12 | STATU | LIS branch status | nvarchar | 1 | 0 | | |
TOPSAP Healthcare - Industry-Specific Components for Hospitals |
124 | NAKR1 | IS-H AT: LKF - Grunddaten | 4 | STATU | IS-H: LKF - Satzart | nvarchar | 1 | 0 | | |
125 | TNLZR2 | IS-H NL:LAZR Afspraaksoort | 4 | STATU | IS-H: Interne status van een poliklinisch bezoek | nvarchar | 2 | 0 | | |
TOPShipping |
126 | LIPSPO | LIPS Reference Data Purchase Order | 12 | STATU | Status field string | nvarchar | 10 | 0 | | |
127 | TVSLT | Deliveries: Texts Processing Status | 4 | STATU | General SD status | nvarchar | 1 | 0 | | |
TOPSimulation |
128 | VSEBAN_CN | Version: Purchase requisition | 9 | STATU | Processing status of purchase requisition | nvarchar | 1 | 0 | | |
TOPSouth Africa |
129 | PA3202 | HR Master Record: Infotype 3202 | 25 | STATU | Status/Level of Labour Relations Intervention | nvarchar | 3 | 0 | | |
130 | T5W64 | SARS Interface : Employee Status | 5 | STATU | SARS Interface: Employee Status | nvarchar | 2 | 0 | | |
131 | T5W9O | Outcome Types of Labour Relations Interventions | 3 | STATU | Status/Level of Labour Relations Intervention | nvarchar | 3 | 0 | | |
132 | T5W9OT | Text - Outcome Types Labour Relations Interventions | 4 | STATU | Status/Level of Labour Relations Intervention | nvarchar | 3 | 0 | | |
133 | T5W9PR | Role responsibilities | 4 | STATU | Status/Level of Labour Relations Intervention | nvarchar | 3 | 0 | | |
134 | T5W9S | Status/Level of a Labour Relation intervention process | 3 | STATU | Status/Level of Labour Relations Intervention | nvarchar | 3 | 0 | | |
135 | T5W9ST | Text - Status/Level of a Lab. Relation intervention process | 4 | STATU | Status/Level of Labour Relations Intervention | nvarchar | 3 | 0 | | |
TOPStandard Network |
136 | TCA41 | Default values for standard networks and profiles | 25 | STATU | Status | nvarchar | 3 | 0 | | |
TOPTaiwan |
137 | T7TW1L | Last rported data of LI/NHI reports | 10 | STATU | Insurance status | nvarchar | 2 | 0 | | |
TOPTax Reporter |
138 | T5UYY | TR Monitor | 6 | STATU | 30 Characters | nvarchar | 30 | 0 | | |
TOPTravel Expenses |
139 | PTRV_CHANGE | Change to Trip | 17 | STATU | Status of Travel Expense Posting Runs | nvarchar | 2 | 0 | | |
140 | PTRV_VERSION | History Table | 21 | STATU | Status of Travel Expense Posting Runs | nvarchar | 2 | 0 | | |
TOPTravel Management |
141 | FITV_REJECT | Rejected Trips | 17 | STATU | Status of Travel Expense Posting Runs | nvarchar | 2 | 0 | | |
TOPTreasury |
142 | TZC37 | Financial Assets Management status definition | 4 | STATU | Contract status | nvarchar | 2 | 0 | | |
TOPUSA |
143 | PA0672 | FMLA Event Infotype | 27 | STATU | Approval Status | nvarchar | 1 | 0 | | |
TOPVehicle Management System |
144 | CVLC02 | VELO : Vehicle Status | 2 | STATU | Vehicle Status | nvarchar | 4 | 0 | | |
145 | CVLC02T | VELO : Text for CVLC02 | 3 | STATU | Vehicle Status | nvarchar | 4 | 0 | | |
TOPWarehouse Management |
146 | LEIN | Storage unit header records | 10 | STATU | Status of Storage Unit | nvarchar | 1 | 0 | | |
147 | LL01 | Whse Activity Monitor: Critical Transfer Order Items | 14 | STATU | Warehouse activity monitor: processing status | nvarchar | 1 | 0 | | |
148 | LL02 | Whse Activity Monitor: Critical Transfer Requirement Items | 15 | STATU | Warehouse activity monitor: processing status | nvarchar | 1 | 0 | | |
149 | LL03 | Whse Activity Monitor: Critical Posting Change Documents | 11 | STATU | Warehouse activity monitor: processing status | nvarchar | 1 | 0 | | |
150 | LL04 | Whse Activity Monitor: Critical Deliveries | 11 | STATU | Warehouse activity monitor: processing status | nvarchar | 1 | 0 | | |
151 | LL05 | Whse Activity Monitor: Critical Stocks | 11 | STATU | Warehouse activity monitor: processing status | nvarchar | 1 | 0 | | |
152 | LL06 | Whse Activity Monitor: Critical Storage Bins | 11 | STATU | Warehouse activity monitor: processing status | nvarchar | 1 | 0 | | |
153 | LL07 | Whse Activity Monitor: Critical Production Orders | 11 | STATU | Warehouse activity monitor: processing status | nvarchar | 1 | 0 | | |
154 | LRF_WKQU | Assignment User ->Queue | 5 | STATU | Indicator: Status User | nvarchar | 1 | 0 | | |
155 | LTBK | Transfer requirement header | 4 | STATU | Header Status of Transfer Requirement | nvarchar | 1 | 0 | | |
156 | LUBU | Posting Change Document | 4 | STATU | Status of Posting Change | nvarchar | 1 | 0 | | |