| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /1RA/0SD010MI | Items for Class SD01 - Raw Data | 45 | SALES_ORG | Sales Organization (Compatible with SD, CRM, ...) | nvarchar | 20 | 0 | | |
2 | /1RA/0SD012MI | Items for Class SD01 - Processable | 46 | SALES_ORG | Sales Organization (Compatible with SD, CRM, ...) | nvarchar | 20 | 0 | | |
3 | /1RA/0SD014MI | Items for Class SD01 - Processed | 45 | SALES_ORG | Sales Organization (Compatible with SD, CRM, ...) | nvarchar | 20 | 0 | | |
4 | /MRE/C_PRT_SET | Mobile Retail Print Settings | 2 | SALES_ORG | Sales organization - CRM | nvarchar | 14 | 0 | | |
5 | /MRE/RSC_S0_DETA | Sales Organization Details | 2 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | |
6 | /MRE/RSC_S0_TRAN | Sales Order Transaction Details | 2 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | |
7 | /MRE/RSC_SAL_ORG | Sales Organization | 2 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | |
8 | /MRE/RSC_SA_TRGT | Sales Area Specific Target | 2 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | |
9 | /MRE/RSC_SOR_FLP | Mobile Retail Mapping Object Filter Profile To Sales Org | 2 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | |
10 | /MRE/SAREA_TRGT | Sales Area Specific Target | 2 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | |
11 | /MRE/SORG_ATTR | Customizing table for sales organization attributes | 2 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | |
12 | /MRSS/M_AUT_ASGN | Mirror for Control table for automatic assignment creation | 9 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | |
13 | /MRSS/M_CAP_PLAN | MRS: capacitive planning Mirror Table | 7 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | |
14 | /MRSS/M_DEF_DUR | MRS Mirror: work of operation(default value for integration) | 7 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | |
15 | /MRSS/M_MAPNPOS | Mirror for Code Groups for Notification Items | 6 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | |
16 | /MRSS/M_MAPTASK | Mirror for Mapping of R/3 task | 6 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | |
17 | /MRSS/M_PREV_DEL | Mirror for Prevent Deletion of Operations | 5 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | |
18 | /MRSS/M_R3_AFD | Mirror for Assignment follows Demand (ERP Addon) | 7 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | |
19 | /MRSS/M_RSG_AA | Mirror for Allow Abstract Assignment | 8 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | |
20 | /MRSS/M_RSG_CTRL | MRS: Mirror for resource planning relevance of operations | 6 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | |
21 | /MRSS/M_RSG_SA | Mirror for extended assignments | 8 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | |
22 | /MRSS/M_RSG_STEF | Control Keys for Production Resources/Tools in Resource Plng | 7 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | |
23 | /MRSS/M_RSG_ST_V | Mirror for Control-Key Default Values for PRT | 6 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | |
24 | /MRSS/M_SUPERVSR | Mirror for Site Supervisor Indicator | 6 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | |
25 | /MRSS/M_TRV_TIME | Mirror for Customizing for travel times | 9 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | |
26 | /XLSO/ADVERTISE | Advertisements | 3 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | |
27 | /XLSO/FLEXI_CAT | Flexible catalog with sales area details | 4 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | |
28 | /XLSO/RECOM_LRNR | Recommendation for Learner | 3 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | |
29 | /XLSO/RECOM_PROD | Recommendation for Product | 3 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | |
30 | EHPRCD_CMP_POS | Campaign Position | 10 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | |
31 | FARR_D_CHECK_IC | Transparent Table for the Data Consistency Check Selection | 4 | SALES_ORG | Sales Organization (Compatible with SD, CRM, ...) | nvarchar | 20 | 0 | | |
32 | FARR_D_CONTRACT | Contract | 23 | SALES_ORG | Sales Organization (Compatible with SD, CRM, ...) | nvarchar | 20 | 0 | | |
33 | FARR_D_POB | Performance Obligation | 8 | SALES_ORG | Sales Organization (Compatible with SD, CRM, ...) | nvarchar | 20 | 0 | | |
34 | FIEUD_SDINV_H | SAFT: Invoices from SD module(Header) | 10 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | |
35 | ZATPCUSTSITE | ATP Check: Customer Site Mapping | 4 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | |
36 | ZMAT_SLS1 | Sales Area DAta | 3 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | |
TOPAgency Business Global Trade |
37 | TMPRX_DEF | AB: Default Data for eSOA Services | 4 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | |
38 | TMZR_PRX_GRP | AB: Mapping Group for eSOA-Services | 6 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | |
TOPCapacity and Resource Planning |
39 | /MRSS/C_MAPNPOS | Code Groups for Notification Items | 4 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | |
40 | /MRSS/C_MAPTASK | Mapping of R/3 task | 4 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | |
41 | /MRSS/C_MOB_STAT | Assignment of Abstract Status to Plants (Mobile Integration) | 3 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | |
42 | /MRSS/C_RCT_NPRV | Determination of MRS relevance | 3 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | |
43 | /MRSS/C_SUPERVSR | Site Supervisor Indicator | 4 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | |
44 | /MRSS/C_TRV_TIME | Customizing for travel times | 7 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | |
TOPDistributor-Reseller-Management |
45 | /SAPHT/DRMBUDL | Bill Up Due List | 16 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | |
46 | /SAPHT/DRMCRFCST | Reference customers for EC creation during EC aliasing | 4 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | |
47 | /SAPHT/DRMCSADRV | DRM: Sales Area derivation | 4 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | |
48 | /SAPHT/DRMHEAD | DRM FIFO Header | 11 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | |
49 | /SAPHT/DRMINVSUM | DRM Inventory Summary | 8 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | |
50 | /SAPHT/DRMIUSR | DRM Internet User Management Table | 5 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | |
51 | /SAPHT/DRMPPDL | Price Protection Due List | 8 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | |
52 | /SAPHT/DRMPR_DEF | Default Profile for the Tracking Partner | 2 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | |
53 | /SAPHT/DRMR3XN | DRM relevant ERP Transactions | 44 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | |
54 | /SAPHT/DRMSDDL | Ship and Debit Due List | 8 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | |
55 | /SAPHT/DRMSTAG | DRM Staging Area | 8 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | |
56 | /SAPHT/DRM_CLOSE | DRM CLOSING TABLE | 4 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | |
57 | /SAPHT/DRM_PHONE | DRM Phone Table | 4 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | |
58 | KOTW002 | Sales org./Distr. chl/Division/Material | 4 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | |
59 | S496 | DRM: MS Side Business Metrics | 5 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | |
60 | S496E | S496 - Structural information | 5 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | |
61 | S497 | DRM: DR Side Business Metrics | 5 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | |
62 | S497E | S497 - Structural information | 5 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | |
TOPDSD Connector |
63 | /DSD/ME_CND_TYPE | Condition types manual discount | 2 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | |
64 | /DSD/ME_CND_T_T | Condition types manual discount | 2 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | |
65 | /DSD/ME_CUST_HD | DSD CN: Customer Details | 14 | SALES_ORG | DSD Connector: Sales Organization | nvarchar | 4 | 0 | | |
66 | /DSD/ME_CUST_SA | DSD CN: Sales area dependent customer master data | 3 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | |
67 | /DSD/ME_MAT_SOR | DSD CN: Material Sales Organization Data | 3 | SALES_ORG | DSD Connector: Sales Organization | nvarchar | 4 | 0 | | |
TOPEnvironment, Health and Safety |
68 | /TDAG/RCSA_CAPOS | Campaign position data | 7 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | |
TOPFunds Management |
69 | FMFGRODEF | Define Reimbursable Orders | 2 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | |
TOPGlobal Trade |
70 | TWCBPROXYDEFAULT | Default Data for Proxy Call | 5 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | |
TOPGrantor Management |
71 | GTRFIBILL_H | Header of Grantor FI AP/AR Billing Doc | 14 | SALES_ORG | Sales Organization (CRM) | nvarchar | 14 | 0 | | |
TOPIntegration Customer Relationship Management |
72 | ECRMSALSERVDATA | Customizing Table for CRM Organization Data | 5 | SALES_ORG | CRM Sales Organization: Description of Department | nvarchar | 12 | 0 | | |
73 | ESALES_PRODSALES | Profiles of the sales transaction | 7 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | |
74 | ESALES_SALESAREA | Alternative Sales Areas for Profile | 3 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | |
TOPLogistics - General |
75 | CMDET_S06667 | Individual Records for Updating External Credit Data | 13 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | |
TOPMaintenance Orders |
76 | /MRSS/C_AUT_ASGN | Control table for automatic assignment creation | 7 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | |
77 | /MRSS/C_CAP_DATE | Capacitive Assignment - Dates | 5 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | |
78 | /MRSS/C_CAP_PLAN | MRS: capacitive planning | 5 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | |
79 | /MRSS/C_DEF_DUR | MRS: work of operation (default value for integration) | 5 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | |
80 | /MRSS/C_OPT_FIL | Demand Filter Definition for Optimization | 8 | SALES_ORG | Sales Org | nvarchar | 4 | 0 | | |
81 | /MRSS/C_PREV_DEL | Prevent Deletion of Operations | 3 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | |
82 | /MRSS/C_R3_AFD | Assignment follows Demand (ERP Addon) | 5 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | |
83 | /MRSS/C_RAP_ASG | Degree of Coverage of Demands | 3 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | |
84 | /MRSS/C_RAP_PAR | Parameters for PS Integration | 4 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | |
85 | /MRSS/C_RAP_PV | Settings for Process Variants | 4 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | |
86 | /MRSS/C_RSG_AA | Allow Abstract Assignment | 6 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | |
87 | /MRSS/C_RSG_CTRL | MRS: resource planning relevance of operations | 4 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | |
88 | /MRSS/C_RSG_SA | Extended assignments | 6 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | |
89 | /MRSS/C_RSG_STEF | Control Keys for Production Resources/Tools in Resource Plng | 5 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | |
90 | /MRSS/C_RSG_ST_V | Control-Key Default Values for Production Resources & Tools | 4 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | |
91 | /MRSS/D_DEM_INFO | Informative Fields for Demand Items | 12 | SALES_ORG | Sales Org | nvarchar | 4 | 0 | | |
TOPMerchandise and Assortment Planning |
92 | TWISPS_NOPROMO1 | Parameters for Promotions Created in MAP | 9 | SALES_ORG | Sales Organization: Promotion Header | nvarchar | 4 | 0 | | |
TOPPeriodical Sales and Distribution |
93 | JITCIRCBOOK | IS-M/SD: Circulation Book with Delivery Quantities | 22 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | |
TOPReusable Components of Business Suite Foundation |
94 | /BOBF/DM_CST_HDR | Customer Header | 5 | SALES_ORG | Sales Organization | nvarchar | 10 | 0 | | |
95 | /BOBF/DM_SORD_RT | Sales Order Header | 6 | SALES_ORG | Sales Organization | nvarchar | 10 | 0 | | |
96 | /BOFU/DB_CUST_1 | Test Customer Header | 4 | SALES_ORG | | nvarchar | 10 | 0 | | |
97 | /BOFU/DDMOCUST_H | Demo Customer Header | 5 | SALES_ORG | Sales Organization | nvarchar | 10 | 0 | | |
98 | /BOFU/DDMOSORDHD | Sales Order Header | 6 | SALES_ORG | Sales Organization | nvarchar | 10 | 0 | | |
99 | /BOFU/DTSTCUST_H | Test Customer Header | 4 | SALES_ORG | Sales Organization | nvarchar | 10 | 0 | | |
100 | /BOFU/DTSTSORDHD | Sales Order Header | 5 | SALES_ORG | Sales Organization | nvarchar | 10 | 0 | | |
101 | /BOFU/SO_BUPA_RT | Sales Order Business Partner Root Table | 5 | SALES_ORG | | nvarchar | 10 | 0 | | |
TOPStructures |
102 | PSLA_CONFIG_TBL | Configuration of Commercial Project Inception | 4 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | |
TOPSupply Chain Management |
103 | TCM_SLS_ORG_MAP | Mapping TCM Organizational unit to sales organisation | 5 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | |
TOPVisit Control |
104 | /DSD/VC_TSTR | DSD: Customer / Calendar Type / Time Stream ID | 3 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | |
105 | /DSD/VC_VLH | DSD: Visit List - Header Data | 26 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | |
106 | /DSD/VC_VPH | DSD: Visit Schedule - Header Data | 33 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | |