| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /1CN/CBPSAP001 | Vendor/product | 3 | VENDOR | Supplier GUID | varbinary | 16 | 0 | | |
2 | /ATL/SHAAM | Withholding tax for vendors from shaam | 2 | VENDOR | Vendor number from Shaam | nvarchar | 10 | 0 | | |
3 | /ATL/SHAAMSG | Withholding tax for vendors from shaam error file | 2 | VENDOR | Vendor number | nvarchar | 10 | 0 | | |
4 | /BIC/B0000190000 | PSA for 0MM_PUR_PURCH_DATA T90CLNT090 Purchasing Data | 18 | VENDOR | | nvarchar | 10 | 0 | | |
5 | /BIC/B0000191000 | PSA for 0MM_PUR_PURCH_GROUPS T90CLNT090 Purchasing Groups | 13 | VENDOR | | nvarchar | 10 | 0 | | |
6 | /BIC/B0000192000 | PSA for 0MM_PUR_SRV_LEVEL T90CLNT090 PO Service Level | 18 | VENDOR | | nvarchar | 10 | 0 | | |
7 | /GBT/O_BAT_VEN | Batch master - Vendor batch | 3 | VENDOR | Vendor | nvarchar | 10 | 0 | | |
8 | /GBT/O_DLVY_HDR | Delivery | 23 | VENDOR | Vendor | nvarchar | 10 | 0 | | |
9 | /GBT/O_HU_CON | Handling Unit Connection | 10 | VENDOR | Vendor | nvarchar | 10 | 0 | | |
10 | /GBT/O_PURO_HDR | Purchasing Document | 15 | VENDOR | Vendor | nvarchar | 10 | 0 | | |
11 | /OPT/VT_DOC_HEA1 | Document Header - copy of /opt/vt_doc_head | 15 | VENDOR | Account Number of Vendor or Creditor | nvarchar | 10 | 0 | | |
12 | /OPT/VT_DOC_HEAD | Document Header | 15 | VENDOR | Account Number of Vendor or Creditor | nvarchar | 10 | 0 | | |
13 | /SAPSRM/SOCO_SET | Settings for search in Sourcing Cockpit | 20 | VENDOR | Business Partner Number | nvarchar | 10 | 0 | | |
14 | /XLSO/COMM_SETUP | Community Setup table | 5 | VENDOR | Name/Description of external community vendor | nvarchar | 100 | 0 | | |
15 | ARBERP_C_TAXCTGY | Map ERP tax code to cXML tax category | 2 | VENDOR | Vendor Account Number | nvarchar | 10 | 0 | | |
16 | CMCBD_CONSUME | Cash Budgeting Consumption | 34 | VENDOR | Account Number of Vendor or Creditor | nvarchar | 10 | 0 | | |
17 | EPIC_CBC | EPIC:Cash budgeting control consumption table | 11 | VENDOR | Account Number of Vendor or Creditor | nvarchar | 10 | 0 | | |
18 | EPIC_CBC_EBR | Cash Budgeting Control of Bank Receipt | 8 | VENDOR | Account Number of Vendor or Creditor | nvarchar | 10 | 0 | | |
19 | J_3RF_DI_OCCODE | Assign Operator to Company Code | 3 | VENDOR | Operator of Company Code | nvarchar | 10 | 0 | | |
20 | MDUBS | Market Data: Conversion: Basis Spread: Quotation Type | 2 | VENDOR | Market Data: Data Provider | nvarchar | 10 | 0 | | |
21 | MDUCMDCS | Market Data: Price Type Conversion: Commodities / DCS | 2 | VENDOR | Market Data: Data Provider | nvarchar | 10 | 0 | | |
22 | MDUCS | Market Data: Conversion of Credit Spread Quotation Type | 2 | VENDOR | Market Data: Data Provider | nvarchar | 10 | 0 | | |
23 | MRP_REQ_NOTE | Requests and Notes for MRP Cockpit | 18 | VENDOR | Account Number of Vendor or Creditor | nvarchar | 10 | 0 | | |
24 | QAM_L_BCV_A | QIM: Temporary Storage Activities f. Business Context Viewer | 10 | VENDOR | Vendor | nvarchar | 10 | 0 | | |
25 | QAM_L_BCV_I | QIM: Temporary Storage Issues for Business Context Viewer | 11 | VENDOR | Vendor | nvarchar | 10 | 0 | | |
26 | ZARIBA_VENDOR | Ariba Vendor Mapping table | 2 | VENDOR | Account Number of Vendor or Creditor | nvarchar | 10 | 0 | | |
27 | ZEHPRC_CM_D_ROOT | Root | 3 | VENDOR | Supplier | nvarchar | 10 | 0 | | |
28 | ZSERV_DET_CUST | Service details submitted by the customer | 7 | VENDOR | Account Number of Vendor or Creditor | nvarchar | 10 | 0 | | |
TOPAustralia |
29 | T5QSC | Table for Superannuation SuperChoices | 15 | VENDOR | Account Number of Vendor or Creditor | nvarchar | 10 | 0 | | |
30 | T5QSF | Superannuation Fund Code Designation Australia | 30 | VENDOR | Account Number of Vendor or Creditor | nvarchar | 10 | 0 | | |
TOPBasic Functions |
31 | BBP_ES_SETTINGS | Settings for the E-Sourcing-ERP Integration | 2 | VENDOR | Vendor Representing External System | nvarchar | 10 | 0 | | |
TOPBasis Components |
32 | /XFT/INV_Q_6 | PO details (header) for an invoice receipt process | 19 | VENDOR | Vendor Account Number | nvarchar | 10 | 0 | | |
33 | /XFT/INV_Q_6_S | PO details (header) for an invoice receipt process | 19 | VENDOR | Vendor Account Number | nvarchar | 10 | 0 | | |
TOPClaims Management |
34 | ICLBUT01 | External Services: Additions to Business Partner | 5 | VENDOR | Reference Number of Business Partner in Procurement System | nvarchar | 10 | 0 | | |
TOPCollaborative Cross Applications |
35 | /POA/D_CLM_PG01 | Main Details of Package | 4 | VENDOR | Vendor | nvarchar | 250 | 0 | | |
TOPControlling |
36 | IAOM_OM_EXAT | External Characteristics of Object in Outsourcing Manufact | 8 | VENDOR | Vendor Account Number | nvarchar | 10 | 0 | | |
TOPCross-Application Component CA Enhancements |
37 | /SAPMP/MIG_T002 | Migration CS -> DIMP: Object Status Batch Stock | 7 | VENDOR | Account Number of Vendor or Creditor | nvarchar | 10 | 0 | | |
TOPCross-Application Components |
38 | /OPT/S_GR_HDR | VSS Staging Table: GR Header | 7 | VENDOR | Account Number of Vendor or Creditor | nvarchar | 10 | 0 | | |
39 | /OPT/S_GR_LIN | VSS Stageing Table: GR Line | 9 | VENDOR | Account Number of Vendor or Creditor | nvarchar | 10 | 0 | | |
40 | /OPT/S_INV_HDR | VSS Staging Table: Invoice Header | 19 | VENDOR | Account Number of Vendor or Creditor | nvarchar | 10 | 0 | | |
41 | /OPT/S_PAYMENT | VSS Staging Table: Payment | 8 | VENDOR | Account Number of Vendor or Creditor | nvarchar | 10 | 0 | | |
42 | /OPT/S_PO_HDR | VSS Staging Table: PO Header | 14 | VENDOR | Account Number of Vendor or Creditor | nvarchar | 10 | 0 | | |
43 | /OPT/VPR | Vendor Portal Registration | 2 | VENDOR | Account Number of Vendor or Creditor | nvarchar | 10 | 0 | | |
44 | /OPT/VPR_LOC | Vendor Registration Location | 2 | VENDOR | Account Number of Vendor or Creditor | nvarchar | 10 | 0 | | |
45 | /OPT/VPR_PARTNER | Partners for Registered Vendor | 2 | VENDOR | Account Number of Vendor or Creditor | nvarchar | 10 | 0 | | |
TOPDistribution |
46 | WCAT_PROFILE | Cost allocation profile | 17 | VENDOR | Take vendor into account | nvarchar | 1 | 0 | | |
TOPE-Recruiting |
47 | HRP5144 | Database Table for Infotype 5144 | 34 | VENDOR | Vendor (Pointer) | nvarchar | 10 | 0 | | |
48 | HRP5145 | Database Table for Infotype 5145 | 37 | VENDOR | Vendor (Pointer) | nvarchar | 10 | 0 | | |
49 | T77RCF_BGCPAKG | Assignment of Packages to Background Check Service Providers | 2 | VENDOR | Vendor (Pointer) | nvarchar | 10 | 0 | | |
50 | T77RCF_BGCPAKG_T | Assignment of Packages to Background Check Service Providers | 3 | VENDOR | Vendor (Pointer) | nvarchar | 10 | 0 | | |
51 | T77RCF_BGCVNDINF | Background Check Vendor - Additional Information | 2 | VENDOR | Vendor (Pointer) | nvarchar | 10 | 0 | | |
52 | T77RCF_BGCVRES | Background Check Vendor Result Code | 2 | VENDOR | Vendor (Pointer) | nvarchar | 10 | 0 | | |
53 | T77RCF_BGCVRES_T | Text of Background Check Vendor Result Code | 3 | VENDOR | Vendor (Pointer) | nvarchar | 10 | 0 | | |
54 | T77RCF_RPVATTCH | Save Options for Resume Parsing Vendor Attachment | 2 | VENDOR | Vendor (Pointer) | nvarchar | 10 | 0 | | |
55 | T77RCF_VNDR2ACT | Assignment of Service Providers to Activity Types | 3 | VENDOR | Vendor (Pointer) | nvarchar | 10 | 0 | | |
56 | T77RCF_VNDSERV | Service Communication Supported by Vendor | 2 | VENDOR | Vendor (Pointer) | nvarchar | 10 | 0 | | |
TOPExchange Infrastructure |
57 | SXMS_AE_AUDITCNF | XI: Adapter Runtime Data | 2 | VENDOR | Vendor of Adapter or Module | nvarchar | 40 | 0 | | |
TOPFinancial Accounting |
58 | /CCEE/SIFIPE17 | Temporary import of goods | 16 | VENDOR | char120 | nvarchar | 120 | 0 | | |
TOPGlobal Trade |
59 | WB2_D_COMSUB | Trading Contract: commodity sub items | 26 | VENDOR | Vendor Account Number | nvarchar | 10 | 0 | | |
60 | WB2_D_SHD_ITEM | Shadow Items | 15 | VENDOR | Vendor Account Number | nvarchar | 10 | 0 | | |
TOPGrantor Management |
61 | GTRVEND_ACCGRP | Assignment Vendor -> Vendor account groups | 3 | VENDOR | Account Number of Vendor or Creditor | nvarchar | 10 | 0 | | |
TOPMarketing, Accounting and Pricing |
62 | OICQOIL | F&A Oil Table for Repository Default | 4 | VENDOR | F&A repository vendor | nvarchar | 10 | 0 | | |
63 | OIC_FORM_ATTRIB | Attributes of Business Context for F&A Formula | 30 | VENDOR | Vendor Account Number | nvarchar | 10 | 0 | | |
TOPMaster Data Synchronization |
64 | CVI_VEND_LINK | Assignment Between Vendor and Business Partner | 3 | VENDOR | Account Number of Vendor or Creditor | nvarchar | 10 | 0 | | |
TOPMaterials Management |
65 | J_1GMM2GV | End year inventory | 9 | VENDOR | Account Number of Vendor or Creditor | nvarchar | 10 | 0 | | |
TOPNetWeaver Business Content |
66 | BIZCRDC | Business Content: Development Component Versions | 4 | VENDOR | | nvarchar | 20 | 0 | | |
67 | BIZCRDCV | Obsolete | 4 | VENDOR | | nvarchar | 20 | 0 | | |
68 | BIZCRSCV | Business Content: Software Component Versions | 5 | VENDOR | | nvarchar | 255 | 0 | | |
TOPOnline Correction Support Support Package and Add-On Tools |
69 | PATPRDVRS | Product Versions Installed in SPAM/SAINT Queues | 5 | VENDOR | PPMS - Object Vendor | nvarchar | 30 | 0 | | |
70 | PATSWFEATR | SW Features/Instances Installed in SPAM/SAINT Queues | 6 | VENDOR | PPMS - Object Vendor | nvarchar | 30 | 0 | | |
71 | PATSWFTINC | Mit SPAM/SAINT Queue installierte inkludierte SW Features | 8 | VENDOR | PPMS - Anbieter eines Objekts | nvarchar | 30 | 0 | | |
72 | PRDVERS | Information About Installed Product Versions | 4 | VENDOR | PPMS - Object Vendor | nvarchar | 30 | 0 | | |
73 | SWFEATURE | Information About Installed Software Features (Instances) | 5 | VENDOR | PPMS - Object Vendor | nvarchar | 30 | 0 | | |
74 | SWFEATUREINC | Informationen zu inkludierten Software-Features (Instanzen) | 7 | VENDOR | PPMS - Anbieter eines Objekts | nvarchar | 30 | 0 | | |
75 | TECHUSAGES | Informationen zu installierten Technical Usages | 5 | VENDOR | PPMS - Anbieter eines Objekts | nvarchar | 30 | 0 | | |
TOPPrint and Output Management |
76 | TFRT_INFO | Typeface Repo - Font Info | 28 | VENDOR | Typeface Repo - Font Vendor | nvarchar | 64 | 0 | | |
TOPRegulatory reporting for insurance companies |
77 | TMR90 | Umschlüsselung Kurskennzeichen | 2 | VENDOR | Vendor | nvarchar | 5 | 0 | | |
78 | TMR91 | Kurskennzeichen / Vendor | 2 | VENDOR | Vendor | nvarchar | 5 | 0 | | |
79 | TMR92 | Vendor | 2 | VENDOR | Vendor | nvarchar | 5 | 0 | | |
80 | TMR93 | Umschlüsselung Handelsplatz | 2 | VENDOR | Vendor | nvarchar | 5 | 0 | | |
81 | TMR94 | Umschlüsselung Währung | 2 | VENDOR | Vendor | nvarchar | 5 | 0 | | |
TOPSAP NetWeaver Mobile - Use subcomponents |
82 | MEREP_TEST_CUST | MI Test Tool - Customize Tables with Values | 16 | VENDOR | General Flag | nvarchar | 1 | 0 | | |
83 | MEREP_TREPLOPT | MI Testtool:Replenishment Option | 5 | VENDOR | MI:Testcases Vendor | nvarchar | 10 | 0 | | |
84 | MEREP_TREQUIS | MI Testtool - Requisition | 2 | VENDOR | MI:Testcases Vendor | nvarchar | 10 | 0 | | |
85 | MEREP_TVENDOR | MI Testtool - Requisition | 2 | VENDOR | MI:Testcases Vendor | nvarchar | 10 | 0 | | |
TOPSAP Retail Store |
86 | TREC_FORC_COMPL | Temporary data for the receiving forecast | 4 | VENDOR | Vendor Account Number | nvarchar | 10 | 0 | | |
87 | WGMH_SRS | Head for SRS PDC Goodsmovement | 8 | VENDOR | Vendor Account Number | nvarchar | 10 | 0 | | |
88 | WSGM_HEAD_DB_TMP | SRS GM: Temporary Persistence for Header Data | 12 | VENDOR | Account Number of Vendor or Creditor | nvarchar | 10 | 0 | | |
TOPSupplier Workplace |
89 | ISAUTOSICVENDTAB | Accessible vendors per user | 3 | VENDOR | Account Number of Vendor or Creditor | nvarchar | 10 | 0 | | |
TOPTariffs, Duties and Permits |
90 | OIH_J1B_APR | Brazil tax: Acquisition price table | 6 | VENDOR | Account Number of Vendor or Creditor | nvarchar | 10 | 0 | | |
91 | OIH_J_1BTXIX1 | Tax calc.: ISS rules for sales and purchasing exeptions | 10 | VENDOR | Account Number of Vendor or Creditor | nvarchar | 10 | 0 | | |
TOPTrading Contract |
92 | WB2_D_STRING | Logistical string,circle and washout | 6 | VENDOR | Vendor Account Number | nvarchar | 10 | 0 | | |
TOPTreasury |
93 | MDUCMCPE | Market Data: Code Conversion Quotation Type Commodities/CPE | 2 | VENDOR | Market Data: Data Provider | nvarchar | 10 | 0 | | |
94 | MDUCMV | Market Data: Code Conversion for Index Type | 2 | VENDOR | Market Data: Data Provider | nvarchar | 10 | 0 | | |
95 | MDUCR | Mkt Data: Assign New Key for Curr. Symbols | 2 | VENDOR | Market Data: Data Provider | nvarchar | 10 | 0 | | |
96 | MDUCV | Mkt Data: Assign New Key for Curr.Type | 2 | VENDOR | Market Data: Data Provider | nvarchar | 10 | 0 | | |
97 | MDUHR | Market Data: Assign New Keys for Stock Exchanges | 2 | VENDOR | Market Data: Data Provider | nvarchar | 10 | 0 | | |
98 | MDUIR | Market Data: Assign New Key for Index Name | 2 | VENDOR | Market Data: Data Provider | nvarchar | 10 | 0 | | |
99 | MDUIV | Mkt Data:Ass.New Key for Index Type | 2 | VENDOR | Market Data: Data Provider | nvarchar | 10 | 0 | | |
100 | MDURR | Mkt Data: Assign New Key for Ref. Interest Rate Name | 2 | VENDOR | Market Data: Data Provider | nvarchar | 10 | 0 | | |
101 | MDUVV | Mkt Data: Assign New Key for Volatil. Type | 2 | VENDOR | Market Data: Data Provider | nvarchar | 10 | 0 | | |
102 | MDUWR | Market Data: Assign New Key for Securities/Key 1 | 2 | VENDOR | Market Data: Data Provider | nvarchar | 10 | 0 | | |
103 | MDUWV | Mkt Data: Assign New Key for Sec. Price Type | 2 | VENDOR | Market Data: Data Provider | nvarchar | 10 | 0 | | |
TOPUpgrade - General |
104 | NPRDVERS | Zu installierende Produktversionen im Schattenrepository | 4 | VENDOR | | nvarchar | 30 | 0 | | |
105 | NSWFEATINC | Zu installierende inkludierte Instanzen im Schattenrep. | 7 | VENDOR | | nvarchar | 30 | 0 | | |
106 | NSWFEATURE | Zu installierende Instanzen im Schattenrepository | 5 | VENDOR | | nvarchar | 30 | 0 | | |
107 | NTECHUSAGE | zu installierende Technical Usages im Schattenrep. | 5 | VENDOR | | nvarchar | 30 | 0 | | |