| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | /SAPPSSRM/FAUD | Database table for Audit Trail | 8 | EXTID | External ID | nvarchar | 40 | 0 | | |
| 2 | CNVMBTSELGRPVAL | MBT PCL Selection group values | 13 | EXTID | External ID for Identification of Related Values | nvarchar | 20 | 0 | | |
| 3 | CNVMBTSHELLSPEC | Shell Creation: Tables with special handling for copy | 10 | EXTID | External ID for Identification of Related Values | nvarchar | 20 | 0 | | |
| 4 | CNVMBTSPEC | Special handling of tables | 10 | EXTID | External ID for Identification of Related Values | nvarchar | 20 | 0 | | |
| 5 | CNVTDMS_06_SPEC | Special handling of tables | 10 | EXTID | External ID for Identification of Related Values | nvarchar | 20 | 0 | | |
| 6 | J_3RF_DI_PCUST | Assign Electronic ID to Customer | 4 | EXTID | Partner ID (Electronic Invoicing) | nvarchar | 46 | 0 | | |
| 7 | J_3RF_DI_PVEND | Assign Electronic ID to Vendor | 4 | EXTID | Partner ID (Electronic Invoicing) | nvarchar | 46 | 0 | | |
| 8 | PAPBSGB_SWF_ABS | SWF: Absences | 8 | EXTID | SWF: External Personnel Id | nvarchar | 20 | 0 | | |
| 9 | PAPBSGB_SWF_CONT | SWF: Contract Details | 8 | EXTID | SWF: External Personnel Id | nvarchar | 20 | 0 | | |
| 10 | PAPBSGB_SWF_CUR2 | SWF: Curriculum | 8 | EXTID | SWF: External Personnel Id | nvarchar | 20 | 0 | | |
| 11 | PAPBSGB_SWF_CURR | SWF: Curriculum | 8 | EXTID | SWF: External Personnel Id | nvarchar | 20 | 0 | | |
| 12 | PAPBSGB_SWF_PAY | SWF: Additional Payments | 8 | EXTID | SWF: External Personnel Id | nvarchar | 20 | 0 | | |
| 13 | PAPBSGB_SWF_QUAL | SWF: Qualifications | 8 | EXTID | SWF: External Personnel Id | nvarchar | 20 | 0 | | |
| 14 | PAPBSGB_SWF_QUL2 | SWF: Qualifications | 8 | EXTID | SWF: External Personnel Id | nvarchar | 20 | 0 | | |
| 15 | PAPBSGB_SWF_STAF | SWF: Staff Details | 9 | EXTID | SWF: External Personnel Id | nvarchar | 20 | 0 | | |
| TOPBasic Data |
| 16 | TNK01 | IS-H: Service Catalog Types | 8 | EXTID | IS-H: Version of Catalog | nvarchar | 6 | 0 | | |
| TOPClinical System |
| 17 | N1ALCONFIG | AppLog: Configuration | 4 | EXTID | AppLog: External Identification of Configuration | nvarchar | 20 | 0 | | |
| 18 | N1ALPROFILE | AppLog: Profile | 4 | EXTID | AppLog: External Identification of Profile | nvarchar | 20 | 0 | | |
| 19 | N1BCH | Basic Cat.: Catalog Header | 4 | EXTID | Basic Catalog: Catalog ID | nvarchar | 50 | 0 | | |
| 20 | N1BCP | Basic Cat.: Catalog Item | 4 | EXTID | Basic Catalog: Item ID | nvarchar | 50 | 0 | | |
| 21 | N1BCS | OBSOLETE: Basic Cat.: Basic Catalog Set | 5 | EXTID | Basic Cat.: Basic Catalog Set ID | nvarchar | 50 | 0 | | |
| 22 | N1BCSH | Basic Catalog Set: Header Data | 5 | EXTID | Basic Cat.: Basic Catalog Set ID | nvarchar | 50 | 0 | | |
| 23 | N1CORDPROF | CORD: Clinical Order Templates | 4 | EXTID | CORD: External ID of Clinical Order Template | nvarchar | 20 | 0 | | |
| 24 | N1DFO | IS-H*MED: Dispensing Form | 5 | EXTID | External Dispensing Form ID | nvarchar | 30 | 0 | | |
| 25 | N1STF | IS-H*MED: Master Data of Medication Substances | 6 | EXTID | External Dispensing Form ID | nvarchar | 30 | 0 | | |
| 26 | N1STFTYP | IS-H*MED: Substance Types | 6 | EXTID | External Dispensing Form ID | nvarchar | 30 | 0 | | |
| 27 | TN2AD_BC | Basic Catalog Allergy | 3 | EXTID | Basic Catalog: Catalog ID | nvarchar | 50 | 0 | | |
| TOPConfirmations |
| 28 | AFRP0 | Table of planned changes for confirmation (PDC) | 98 | EXTID | External Key for Confirmation (for example, from PDC System) | varbinary | 16 | 0 | | |
| 29 | AFRU | Order Confirmations | 132 | EXTID | External Key for Confirmation (for example, from PDC System) | varbinary | 16 | 0 | | |
| 30 | AFRV | Confirmation pool | 187 | EXTID | External Key for Confirmation (for example, from PDC System) | varbinary | 16 | 0 | | |
| 31 | AFRV_DEL | Backup Copy for Confirmation Pool | 187 | EXTID | External Key for Confirmation (for example, from PDC System) | varbinary | 16 | 0 | | |
| TOPContract Accounts Receivable and Payable |
| 32 | TFK113E | Clearing: Exit Modules | 4 | EXTID | Event in Which a Function Module is Called | nvarchar | 2 | 0 | | |
| TOPEnvironment, Health and Safety |
| 33 | /TDAG/CPT_TASKH | Header data for tasks | 5 | EXTID | External ID | nvarchar | 20 | 0 | | |
| 34 | /TDAG/CPT_TASKHA | CP: Kopfdaten für Aufgaben / Archiv | 5 | EXTID | External ID | nvarchar | 20 | 0 | | |
| TOPExpenditure Certification |
| 35 | FMEUFRUN | Certification Run Parameter | 23 | EXTID | External Run ID | nvarchar | 30 | 0 | | |
| TOPGeographical Functions |
| 36 | GEOOBJR | Gen. object ref. (customer, plant, ...) | 12 | EXTID | External ID for Geo objects (additional info) | nvarchar | 20 | 0 | | |
| TOPGlobal Trade Services |
| 37 | /SAPSLL/PREVDH | Preference: Long-Term Vendor Declaration Header | 34 | EXTID | External Identification | nvarchar | 40 | 0 | | |
| TOPInstalled Base |
| 38 | IBIB | IB: Installed Base/IBase | 17 | EXTID | IB: External Name/ID of Installed Base | nvarchar | 30 | 0 | | |
| TOPNursing |
| 39 | N1SNP | OBSOLETE - Std.Nurs.Plan: Std.Nurs.Plan Header Data | 5 | EXTID | OBSOLETE | nvarchar | 20 | 0 | | |
| 40 | N1SNPH | Std.Nurs.Plan: Header Data | 5 | EXTID | Standard Plan: ID | nvarchar | 50 | 0 | | |
| TOPPatient Management |
| 41 | NDIA | IS-H: Diagnoses | 46 | EXTID | Internal Identifier of the Diagnosis Coding Tool | nvarchar | 8 | 0 | | |
| TOPPension fund General Parts |
| 42 | PA0278 | HR Master Record: Infotype 0278 (Basic Data PF [CH]) | 25 | EXTID | HR-CH: PF: External identification | nvarchar | 12 | 0 | | |
| TOPRemote Logistics Management |
| 43 | OIO_C1_CNTNR | RLM Oil and gas container master data | 6 | EXTID | Container external identifier | nvarchar | 25 | 0 | | |
| TOPSecure Network Communications |
| 44 | USREXTID | Assignment of External ID to Users | 3 | EXTID | External ID (plain text or hash value) | nvarchar | 112 | 0 | | |
| 45 | USREXTID_IDM | Table for Provisioning USREXTID Data from IDM | 5 | EXTID | External ID (Plaintext) | nvarchar | 255 | 0 | | |
| TOPSecurity |
| 46 | USRCERTRULEMIG | Migration table for rule based certificate mapping | 3 | EXTID | External ID (plain text or hash value) | nvarchar | 112 | 0 | | |
| TOPTraining Management |
| 47 | HRP5042 | DB Table for Infotype 5042 | 19 | EXTID | Course Code in External LMS | nvarchar | 32 | 0 | | |
