| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /CPD/D_MP_HDR | Master Project Header | 8 | CUSTOMER | Customer Number | nvarchar | 10 | 0 | | |
2 | /IXOS/DC_EX_ADDR | Addresses of a customer | 2 | CUSTOMER | Customer number | nvarchar | 10 | 0 | | |
3 | /IXOS/DC_EX_CUST | (J_8AGTD71) Customer | 2 | CUSTOMER | Customer number | nvarchar | 10 | 0 | | |
4 | /IXOS/DC_EX_LCP | (J_8AGTD74) Link customer/product | 2 | CUSTOMER | Customer number | nvarchar | 10 | 0 | | |
5 | /IXOS/DC_EX_SRM | Customer Documents | 2 | CUSTOMER | Customer number | nvarchar | 10 | 0 | | |
6 | /OPT/AT_APPR_HIS | Approval History for Level Based Approvals | 75 | CUSTOMER | Customer Number | nvarchar | 10 | 0 | | |
7 | /OPT/AT_LBA_LOG | Approval History for Level Based Approvals | 76 | CUSTOMER | Customer Number | nvarchar | 10 | 0 | | |
8 | ARBERP_D_SI_SO | Inbound Sales Order versioning for inbound messages | 3 | CUSTOMER | Customer Number | nvarchar | 10 | 0 | | |
9 | CMCBD_CONSUME | Cash Budgeting Consumption | 35 | CUSTOMER | Customer Number | nvarchar | 10 | 0 | | |
10 | CNVCMIS_FIELDS | Explicit conversion rules for fields during migration | 4 | CUSTOMER | Customer Object | nvarchar | 1 | 0 | | |
11 | CNVCMIS_FIPARS | parameters for rules mentioned in cnvmbtfields | 4 | CUSTOMER | Customer Object | nvarchar | 1 | 0 | | |
12 | CNVCMIS_MAPPING | Table for storing information about the mapping | 10 | CUSTOMER | Customer Object | nvarchar | 1 | 0 | | |
13 | CNVCMIS_NTR_STRU | Information about the known values of nontransparent field | 12 | CUSTOMER | Customer Object | nvarchar | 1 | 0 | | |
14 | CNVMBT09TABLE | Tables to be processed | 12 | CUSTOMER | Flag indicating that table is found in customer system | nvarchar | 1 | 0 | | |
15 | CNVMBTCHECKS | MBT Checks | 4 | CUSTOMER | Customer Object | nvarchar | 1 | 0 | | |
16 | CNVMBTCOBJ | conversion objects | 4 | CUSTOMER | Customer Object | nvarchar | 1 | 0 | | |
17 | CNVMBTFIELDS | explicite conversion rules for fields during migration | 4 | CUSTOMER | Customer Object | nvarchar | 1 | 0 | | |
18 | CNVMBTFIPARS | parameters for rules mentioned in cnvmbtfields | 4 | CUSTOMER | Customer Object | nvarchar | 1 | 0 | | |
19 | CNVMBTFORKEY | Foreign key releations in structure + fixed values | 4 | CUSTOMER | Customer Object | nvarchar | 1 | 0 | | |
20 | CNVMBTTABLES | explicite list of tables to be handled during migration | 4 | CUSTOMER | Customer Object | nvarchar | 1 | 0 | | |
21 | CNVMBTTABSTRUC | Field list of tables for file transfer | 4 | CUSTOMER | Customer Object | nvarchar | 1 | 0 | | |
22 | CNVMBTTREE | Structure of conversion object / hierachy | 4 | CUSTOMER | Customer Object | nvarchar | 1 | 0 | | |
23 | CNVMBT_DEL_TABLE | Table to be processed | 12 | CUSTOMER | Just one character | nvarchar | 1 | 0 | | |
24 | CNVTDMSBW_ALLOBJ | All Objects and their tables | 9 | CUSTOMER | Customer Object | nvarchar | 1 | 0 | | |
25 | CNVTDMSBW_EXLOBJ | Objects in BW system and conversion object mapping | 7 | CUSTOMER | Customer Object | nvarchar | 1 | 0 | | |
26 | CNVTDMSBW_OBJDT | Objects in BW system and conversion object mapping | 6 | CUSTOMER | Customer Object | nvarchar | 1 | 0 | | |
27 | CNVTDMS_08_FIELD | explicite conversion rules for fields during migration | 5 | CUSTOMER | Customer Object | nvarchar | 1 | 0 | | |
28 | CNVTDMS_08_FIPAR | parameters for rules mentioned in cnvmbtfields | 5 | CUSTOMER | Customer Object | nvarchar | 1 | 0 | | |
29 | CNVTDMS_09_TABLE | Tables to be processed | 12 | CUSTOMER | Flag indicating that table is found in customer system | nvarchar | 1 | 0 | | |
30 | CNV_20100_BPRIO | Priority control for B-level | 10 | CUSTOMER | Single-Character Indicator | nvarchar | 1 | 0 | | |
31 | CNV_MBT_09_TABLE | Tables for table deletion | 12 | CUSTOMER | Just one character | nvarchar | 1 | 0 | | |
32 | DMC_UPG_CPROJ | MWB: Customer Project | 1 | CUSTOMER | MWB: Customer | nvarchar | 20 | 0 | | |
33 | DMC_UPG_CP_REL | MWB: Release Upgrades in a Customer Project | 1 | CUSTOMER | MWB: Customer | nvarchar | 20 | 0 | | |
34 | DMC_UPG_CUST | MWB: Customer Data for a Project | 1 | CUSTOMER | MWB: Customer | nvarchar | 20 | 0 | | |
35 | EPIC_CBC | EPIC:Cash budgeting control consumption table | 12 | CUSTOMER | Customer Number | nvarchar | 10 | 0 | | |
36 | EPIC_CBC_EBR | Cash Budgeting Control of Bank Receipt | 9 | CUSTOMER | Customer Number | nvarchar | 10 | 0 | | |
37 | FIEUD_SBINV_H | SAFT: Self Billing Invoices (Header)- (MM) | 32 | CUSTOMER | Customer Number | nvarchar | 10 | 0 | | |
38 | FIEUD_SDINV_H | SAFT: Invoices from SD module(Header) | 30 | CUSTOMER | Customer Number | nvarchar | 10 | 0 | | |
39 | MRP_BUF_DEM_ITEM | Supply demand items and uncovered demand items | 20 | CUSTOMER | Customer Number | nvarchar | 10 | 0 | | |
40 | PPH_CACHE_ITEM | Supply demand items and uncovered demand items | 21 | CUSTOMER | Customer Number | nvarchar | 10 | 0 | | |
41 | QAM_L_BCV_A | QIM: Temporary Storage Activities f. Business Context Viewer | 9 | CUSTOMER | Customer | nvarchar | 10 | 0 | | |
42 | QAM_L_BCV_I | QIM: Temporary Storage Issues for Business Context Viewer | 10 | CUSTOMER | Customer | nvarchar | 10 | 0 | | |
43 | REFXCN_IDOC | REFX POS IDOC Inbound data | 3 | CUSTOMER | Customer number of plant | nvarchar | 10 | 0 | | |
44 | REFXCN_IDOCTAB | REFX POS IDOC Inbound data | 4 | CUSTOMER | Customer number of plant | nvarchar | 10 | 0 | | |
45 | SRA019_T_CONFIG | Shipment Customer Configuration | 3 | CUSTOMER | Customer Number | nvarchar | 10 | 0 | | |
46 | ZATPCUSTSITE | ATP Check: Customer Site Mapping | 2 | CUSTOMER | Customer Number | nvarchar | 10 | 0 | | |
47 | ZQUOTAB1 | Quotation details | 2 | CUSTOMER | Character field of length 40 | nvarchar | 40 | 0 | | |
TOPAccounts Receivable Accounting Process Integration |
48 | FDM_INVOICE_MEM | Invoice Information Provided | 6 | CUSTOMER | Customer Number | nvarchar | 10 | 0 | | |
TOPAgency Business Global Trade |
49 | WBRP | Agency business: Item | 156 | CUSTOMER | Customer | nvarchar | 10 | 0 | | |
TOPAMI Event Management |
50 | EFDT_EXPR003 | FDT: Expression - Create Service Order | 9 | CUSTOMER | Customer Number | nvarchar | 10 | 0 | | |
51 | EFDT_EXPR003A | FDT: Expression - Create Service Order | 9 | CUSTOMER | Customer Number | nvarchar | 10 | 0 | | |
52 | EFDT_EXPR003S | FDT: Expression - Create Service Order | 8 | CUSTOMER | Customer Number | nvarchar | 10 | 0 | | |
53 | EFDT_EXPR003T | FDT: Expression - Create Service Order | 8 | CUSTOMER | Customer Number | nvarchar | 10 | 0 | | |
TOPBI Content Analyzer |
54 | RSCONTCHECKPROP | BI Content Checks Properties | 6 | CUSTOMER | Boolean Variable (X=True, -=False, Space=Unknown) | nvarchar | 1 | 0 | | |
TOPBusiness Partner Enhancements for Financial Services |
55 | BP000 | Business Partner Master (General Data) | 8 | CUSTOMER | Customer Number | nvarchar | 10 | 0 | | |
TOPClinical System |
56 | N2HIT_ENTRY | HL: Hit List Entry | 3 | CUSTOMER | General Flag | nvarchar | 1 | 0 | | |
57 | N2HIT_ENTT | HL: Text Table for /MED/GA_HL_ENTRY | 4 | CUSTOMER | General Flag | nvarchar | 1 | 0 | | |
58 | N2HIT_EN_OB | HL: Assignment: Hit List Entry -> Assigned Object | 4 | CUSTOMER | General Flag | nvarchar | 1 | 0 | | |
59 | N2HIT_EN_OT | HL: Text Table for /MED/N2HIT_EN_OB | 5 | CUSTOMER | General Flag | nvarchar | 1 | 0 | | |
TOPCollections Management |
60 | UDM_CCT_ATTR | Customer Contact | 3 | CUSTOMER | Business Partner Number | nvarchar | 10 | 0 | | |
61 | UDM_RSM_ATTR | Resubmissions | 3 | CUSTOMER | Business Partner Number | nvarchar | 10 | 0 | | |
TOPCondition Technique |
62 | /SAPCND/UE_RANGE | Userexit Formula Number Range | 7 | CUSTOMER | Customer System: TRESC checks enabled | nvarchar | 1 | 0 | | |
TOPControlling |
63 | IAOM_CPRO_EXAT | External Characteristics of an Object in cProjects | 14 | CUSTOMER | Sold-to party | nvarchar | 10 | 0 | | |
TOPCross-Application Component CA Enhancements |
64 | /SAPMP/MIG_T002 | Migration CS -> DIMP: Object Status Batch Stock | 8 | CUSTOMER | Customer Number | nvarchar | 10 | 0 | | |
TOPCross-Application Components |
65 | ETP_TASKS | Easy Task Planning: Tasks | 12 | CUSTOMER | 128 character | nvarchar | 128 | 0 | | |
TOPDealer Portal |
66 | /SAPDII/SPPSHIPA | Maintaining Alternate shipping locations | 4 | CUSTOMER | Customer Number | nvarchar | 10 | 0 | | |
TOPDirect Store Delivery |
67 | /DSD/DX_HD | DEX Stream Header (backend) | 2 | CUSTOMER | Customer Number | nvarchar | 10 | 0 | | |
TOPDistributor-Reseller-Management |
68 | /SAPHT/DRMSLSRPT | DRM 867 Outbound processing table | 8 | CUSTOMER | Customer Number | nvarchar | 10 | 0 | | |
TOPElectronic Data Interchange |
69 | PRICAT_K001 | PRICAT: Catalog header | 10 | CUSTOMER | Customer Number | nvarchar | 10 | 0 | | |
70 | PRICAT_K003S | PRICAT: Status of the Catalog Item per Customer | 6 | CUSTOMER | Customer Number | nvarchar | 10 | 0 | | |
71 | PRICAT_K008C | PRICAT: Catalog Item Prices/Conditions/Taxes per Customer | 6 | CUSTOMER | Customer Number | nvarchar | 10 | 0 | | |
72 | PRICAT_K009C | PRICAT: Catalog Item Scales for Condition for Customer | 6 | CUSTOMER | Customer Number | nvarchar | 10 | 0 | | |
73 | PRICAT_K00C | PRICAT: Customer of a Price Catalog | 3 | CUSTOMER | Customer Number | nvarchar | 10 | 0 | | |
74 | PRISBCPARA | PRICAT: SBC Parameters for PRICAT Customers | 1 | CUSTOMER | Customer Number | nvarchar | 10 | 0 | | |
TOPEngineering Change Record |
75 | /PLMI/ECR_HDR | Engineering Change Record Header data | 4 | CUSTOMER | Customer Number 1 | nvarchar | 10 | 0 | | |
TOPEnvironment, Health and Safety |
76 | /TDAG/CPT_TASKH | Header data for tasks | 11 | CUSTOMER | Customer Number | nvarchar | 10 | 0 | | |
77 | /TDAG/CPT_TASKHA | CP: Kopfdaten für Aufgaben / Archiv | 11 | CUSTOMER | Customer Number | nvarchar | 10 | 0 | | |
78 | /TDAG/CPT_TRCKH | Obsolete - CP: Tracker - Kopfdaten | 7 | CUSTOMER | Customer Number | nvarchar | 10 | 0 | | |
79 | /TDAG/CPT_TRCKHA | Obsolete - CP: Tracker - Kopfdaten / Archiv | 7 | CUSTOMER | Customer Number | nvarchar | 10 | 0 | | |
80 | /TDAG/RCSA_CAPOS | Campaign position data | 6 | CUSTOMER | Customer | nvarchar | 10 | 0 | | |
TOPERP related topics |
81 | /MRSS/D_RM_ROUT2 | Routing table to determing Resource management Groups | 13 | CUSTOMER | Customer Number | nvarchar | 10 | 0 | | |
TOPFinancials Basis |
82 | UBC_TB_CEDATA | Cost Events | 4 | CUSTOMER | Customer ID | nvarchar | 20 | 0 | | |
TOPGL Account Posting |
83 | TCJ_POSITIONS | Cash Journal Document Items | 22 | CUSTOMER | Customer Number | nvarchar | 10 | 0 | | |
TOPGlobal Trade |
84 | WB2_D_COMSUB | Trading Contract: commodity sub items | 27 | CUSTOMER | Sold-to party | nvarchar | 10 | 0 | | |
85 | WB2_D_SHD_ITEM | Shadow Items | 16 | CUSTOMER | Sold-to party | nvarchar | 10 | 0 | | |
TOPGrantor Management |
86 | GTRCUST_ACCGRP | Assignment Customer -> Customer account groups | 3 | CUSTOMER | Customer Number | nvarchar | 10 | 0 | | |
TOPInteraction Center WebClient |
87 | CRMC_IC_EMAIL | Email client customizing table | 4 | CUSTOMER | Default To Address in New E-Mail | nvarchar | 1 | 0 | | |
TOPJoint Venture und Production Sharing Accounting |
88 | T8PSA_LIFT_TERM | Lifting Volumes by terminal | 14 | CUSTOMER | Customer Number | nvarchar | 10 | 0 | | |
89 | T8PSA_LIFT_VOL | Lifting Volumes | 21 | CUSTOMER | Customer Number | nvarchar | 10 | 0 | | |
TOPMarketing, Accounting and Pricing |
90 | OICQOIL | F&A Oil Table for Repository Default | 3 | CUSTOMER | F&A repository customer | nvarchar | 10 | 0 | | |
TOPMaster Data Synchronization |
91 | CVI_CUST_LINK | Assignment Between Customer and Business Partner | 3 | CUSTOMER | Customer Number | nvarchar | 10 | 0 | | |
TOPMaterials Management |
92 | J_1GMM2GV | End year inventory | 8 | CUSTOMER | Customer Number | nvarchar | 10 | 0 | | |
TOPMessages |
93 | DNOD_NOTIF_TA | Notification: Data for Task Planning | 8 | CUSTOMER | 128 character | nvarchar | 128 | 0 | | |
TOPOverhead Cost Controlling |
94 | TKALV | Control Parameter for Line Item Report with AAA | 4 | CUSTOMER | Customer Entry | nvarchar | 1 | 0 | | |
TOPPayment Transactions |
95 | TFIBLAPARPVAR | Online Payment: Variants | 4 | CUSTOMER | Customer Number | nvarchar | 10 | 0 | | |
TOPPerishables Procurement |
96 | FIP_D_PDT_TO_CUS | Internal planned delivery time from suppl. Plant to customer | 4 | CUSTOMER | Customer Number | nvarchar | 10 | 0 | | |
97 | FIP_D_PROMO | Promotion data | 5 | CUSTOMER | Customer Number | nvarchar | 10 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
98 | /BEV3/CHCDPBK | CDP: Purchase Control Results | 10 | CUSTOMER | Customer Number of Sold-to Party | nvarchar | 10 | 0 | | |
99 | /BEV3/CHCDPSALES | CDP: Contract Sales (Detailed) | 11 | CUSTOMER | Customer Number of Sold-to Party | nvarchar | 10 | 0 | | |
TOPRental Accounting |
100 | VIRAINV | RE Invoice Header | 18 | CUSTOMER | Customer Number | nvarchar | 10 | 0 | | |
TOPReusable Components of Business Suite Foundation |
101 | /BOFU/SO_BUPA_RT | Sales Order Business Partner Root Table | 7 | CUSTOMER | | nvarchar | 30 | 0 | | |
TOPSAP NetWeaver Mobile - Use subcomponents |
102 | MEREP_TEST_CUST | MI Test Tool - Customize Tables with Values | 5 | CUSTOMER | General Flag | nvarchar | 1 | 0 | | |
TOPSpecification 2 |
103 | SPCPRTNRINF | Partner Information for SPEC 2000 message | 5 | CUSTOMER | Customer Identification Code | nvarchar | 5 | 0 | | |
TOPStructure |
104 | DPR_PROJECT | Project Definition | 24 | CUSTOMER | Business Partner GUID | varbinary | 16 | 0 | | |
TOPStructures |
105 | PSHLP_CUST_DPROF | Data Selection Profile | 11 | CUSTOMER | Customer | nvarchar | 1 | 0 | | |
106 | PSHLP_DATASET_DB | To store the user specific datasets chosen | 12 | CUSTOMER | Single-Character Indicator | nvarchar | 1 | 0 | | |
TOPTrading Contract |
107 | WB2_D_STRING | Logistical string,circle and washout | 7 | CUSTOMER | Sold-to party | nvarchar | 10 | 0 | | |
TOPWeb Channel UM ERP aspects |
108 | ERPD_WEC_CU_DFPM | Default Payment method for a Customer ( Web Channel ) | 2 | CUSTOMER | Customer Number | nvarchar | 10 | 0 | | |
109 | ERPD_WEC_CU_PAYM | Customer Payment Methods ( Web Channel ) | 3 | CUSTOMER | Customer Number | nvarchar | 10 | 0 | | |