| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /SAPPSSRM/DEF_BP | IBU PS: Enhancement of Business Partner | 9 | DUNS4 | DUNS+4 Number for Supplier Registration | nvarchar | 4 | 0 | | |
TOPAP-LIM Logistics Inventory Management Engine |
2 | /LIME/COLL_APS | Collection for Planning System | 30 | DUNS4 | D-U-N-S+4 Number | nvarchar | 13 | 0 | | |
3 | /LIME/COLL_BW | Collection for Business Warehouse | 30 | DUNS4 | D-U-N-S+4 Number | nvarchar | 13 | 0 | | |
4 | /LIME/COLL_FIN | Collection for Financial System | 30 | DUNS4 | D-U-N-S+4 Number | nvarchar | 13 | 0 | | |
5 | /LIME/COLL_INV | Collection for Inventory System | 30 | DUNS4 | D-U-N-S+4 Number | nvarchar | 13 | 0 | | |
6 | /LIME/COLL_LEG | Collection for External System | 30 | DUNS4 | D-U-N-S+4 Number | nvarchar | 13 | 0 | | |
7 | /LIME/COLL_MMIM | Collection for R/3 Inventory Management | 30 | DUNS4 | D-U-N-S+4 Number | nvarchar | 13 | 0 | | |
8 | /LIME/COLL_W2IM | Collection for WME after ERP-MMIM | 30 | DUNS4 | D-U-N-S+4 Number | nvarchar | 13 | 0 | | |
9 | /LIME/LOC_I004 | LIME - Location Key DUNS+4 | 2 | DUNS4 | D-U-N-S+4 Number | nvarchar | 13 | 0 | | |
10 | /LIME/LOC_S004 | Shadow Table for LIME - DUNS+4 | 2 | DUNS4 | D-U-N-S+4 Number | nvarchar | 13 | 0 | | |
11 | /LIME/PN_ITEM | Table to Save Prima Nota Item Data | 12 | DUNS4 | D-U-N-S+4 Number | nvarchar | 13 | 0 | | |
TOPCustomer Master |
12 | KNA1 | General Data in Customer Master | 177 | DUNS4 | DUNS+4 | nvarchar | 4 | 0 | | |
TOPFunctions for U.S. Federal Government |
13 | FMCCRTUPDATES | CCR Vendor Update Table | 3 | DUNS4 | DUNS+4 | nvarchar | 4 | 0 | | |
14 | FMCCRTVENDOR | CCR Vendor Table | 3 | DUNS4 | DUNS+4 | nvarchar | 4 | 0 | | |
15 | FMCCRTVENDORPOC | CCR Vendor Points of Contact | 3 | DUNS4 | DUNS+4 | nvarchar | 4 | 0 | | |
16 | FMCCRVENDOR_CORP | PSM-FG: CCR Vendor Corporate Information | 3 | DUNS4 | DUNS+4 | nvarchar | 4 | 0 | | |
17 | FMCCRVENDOR_DISR | PSM-FG: Disaster Response Contractor Areas Served | 3 | DUNS4 | DUNS+4 | nvarchar | 4 | 0 | | |
18 | FMCCRVENDOR_EXEC | PSM-FG: CCR Executive Compensation | 3 | DUNS4 | DUNS+4 | nvarchar | 4 | 0 | | |
19 | FMCCRVENDOR_EXTC | PSM-FG: CCR Vendor External Certifications | 3 | DUNS4 | DUNS+4 | nvarchar | 4 | 0 | | |
20 | FMCCRVENDOR_FLGS | PSM-FG: CCR Vendor Flags | 3 | DUNS4 | DUNS+4 | nvarchar | 4 | 0 | | |
21 | FMCCRVENDOR_GS | PSM-FG: Goods and Services | 3 | DUNS4 | DUNS+4 | nvarchar | 4 | 0 | | |
22 | FMCCRVENDOR_HDR | PSM-FG: CCR Vendor Table | 3 | DUNS4 | DUNS+4 | nvarchar | 4 | 0 | | |
23 | FMCCRVENDOR_NUMS | PSM-FG: CCR Numerics | 3 | DUNS4 | DUNS+4 | nvarchar | 4 | 0 | | |
24 | FMCCRVENDOR_PROC | PSM-FG: Administrative, civil or criminal proceedings | 3 | DUNS4 | DUNS+4 | nvarchar | 4 | 0 | | |
25 | FMFG_LFACCR | Vendor Master Central Contractor Registry (CCR) | 4 | DUNS4 | DUNS+4 | nvarchar | 4 | 0 | | |