| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /SAPPSSRM/DEF_BP | IBU PS: Enhancement of Business Partner | 8 | DUNS | DUNS Number for Supplier Registration | nvarchar | 9 | 0 | | |
2 | EHPRCD_ADRD | CP: expanded data for business partner | 7 | DUNS | Data Universal Numbering System | nvarchar | 9 | 0 | | |
3 | EHPRCD_ORGIDS | Organisation | 15 | DUNS | Data Universal Numbering System | nvarchar | 9 | 0 | | |
TOPCustomer Master |
4 | KNA1 | General Data in Customer Master | 176 | DUNS | DUNS Number | nvarchar | 9 | 0 | | |
TOPEnvironment, Health and Safety |
5 | /TDAG/CPT_ADRD | CP: expanded data for business partner | 7 | DUNS | Data Universal Numbering System | nvarchar | 9 | 0 | | |
6 | /TDAG/CPT_ORGIDS | IMDS Organisation | 15 | DUNS | Data Universal Numbering System | nvarchar | 9 | 0 | | |
TOPFunctions for U.S. Federal Government |
7 | FMCCRTUPDATES | CCR Vendor Update Table | 2 | DUNS | DUNS Number | nvarchar | 9 | 0 | | |
8 | FMCCRTVENDOR | CCR Vendor Table | 2 | DUNS | DUNS Number | nvarchar | 9 | 0 | | |
9 | FMCCRTVENDORPOC | CCR Vendor Points of Contact | 2 | DUNS | DUNS Number | nvarchar | 9 | 0 | | |
10 | FMCCRVENDOR_CORP | PSM-FG: CCR Vendor Corporate Information | 2 | DUNS | DUNS Number | nvarchar | 9 | 0 | | |
11 | FMCCRVENDOR_DISR | PSM-FG: Disaster Response Contractor Areas Served | 2 | DUNS | DUNS Number | nvarchar | 9 | 0 | | |
12 | FMCCRVENDOR_EXEC | PSM-FG: CCR Executive Compensation | 2 | DUNS | DUNS Number | nvarchar | 9 | 0 | | |
13 | FMCCRVENDOR_EXTC | PSM-FG: CCR Vendor External Certifications | 2 | DUNS | DUNS Number | nvarchar | 9 | 0 | | |
14 | FMCCRVENDOR_FLGS | PSM-FG: CCR Vendor Flags | 2 | DUNS | DUNS Number | nvarchar | 9 | 0 | | |
15 | FMCCRVENDOR_GS | PSM-FG: Goods and Services | 2 | DUNS | DUNS Number | nvarchar | 9 | 0 | | |
16 | FMCCRVENDOR_HDR | PSM-FG: CCR Vendor Table | 2 | DUNS | DUNS Number | nvarchar | 9 | 0 | | |
17 | FMCCRVENDOR_NUMS | PSM-FG: CCR Numerics | 2 | DUNS | DUNS Number | nvarchar | 9 | 0 | | |
18 | FMCCRVENDOR_PROC | PSM-FG: Administrative, civil or criminal proceedings | 2 | DUNS | DUNS Number | nvarchar | 9 | 0 | | |
19 | FMFG_LFACCR | Vendor Master Central Contractor Registry (CCR) | 3 | DUNS | DUNS Number | nvarchar | 9 | 0 | | |