SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

Schema:
 Module:  Table: 
Column: 
Searchbeta 

icon of database logic symbol SAP  TABLESv1Made in Britain

JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5OJDT100Journal Entry
6INV1265A/R Invoice - Rows
7OPCH386A/P Invoice
8JDT1124Journal Entry - Rows
9OPOR386Purchase Order
10OVTG52Tax Definition

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data

106 columns | Print definition?ERP 6.0  | SALES_ORG

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/1RA/0SD010MIItems for Class SD01 - Raw Data45SALES_ORGSales Organization (Compatible with SD, CRM, ...)nvarchar200
2/1RA/0SD012MIItems for Class SD01 - Processable46SALES_ORGSales Organization (Compatible with SD, CRM, ...)nvarchar200
3/1RA/0SD014MIItems for Class SD01 - Processed45SALES_ORGSales Organization (Compatible with SD, CRM, ...)nvarchar200
4/MRE/C_PRT_SETMobile Retail Print Settings2SALES_ORGSales organization - CRMnvarchar140
5/MRE/RSC_S0_DETASales Organization Details2SALES_ORGSales Organizationnvarchar40
6/MRE/RSC_S0_TRANSales Order Transaction Details2SALES_ORGSales Organizationnvarchar40
7/MRE/RSC_SAL_ORGSales Organization2SALES_ORGSales Organizationnvarchar40
8/MRE/RSC_SA_TRGTSales Area Specific Target2SALES_ORGSales Organizationnvarchar40
9/MRE/RSC_SOR_FLPMobile Retail Mapping Object Filter Profile To Sales Org2SALES_ORGSales Organizationnvarchar40
10/MRE/SAREA_TRGTSales Area Specific Target2SALES_ORGSales Organizationnvarchar40
11/MRE/SORG_ATTRCustomizing table for sales organization attributes2SALES_ORGSales Organizationnvarchar40
12/MRSS/M_AUT_ASGNMirror for Control table for automatic assignment creation9SALES_ORGSales Organizationnvarchar40
13/MRSS/M_CAP_PLANMRS: capacitive planning Mirror Table7SALES_ORGSales Organizationnvarchar40
14/MRSS/M_DEF_DURMRS Mirror: work of operation(default value for integration)7SALES_ORGSales Organizationnvarchar40
15/MRSS/M_MAPNPOSMirror for Code Groups for Notification Items6SALES_ORGSales Organizationnvarchar40
16/MRSS/M_MAPTASKMirror for Mapping of R/3 task6SALES_ORGSales Organizationnvarchar40
17/MRSS/M_PREV_DELMirror for Prevent Deletion of Operations5SALES_ORGSales Organizationnvarchar40
18/MRSS/M_R3_AFDMirror for Assignment follows Demand (ERP Addon)7SALES_ORGSales Organizationnvarchar40
19/MRSS/M_RSG_AAMirror for Allow Abstract Assignment8SALES_ORGSales Organizationnvarchar40
20/MRSS/M_RSG_CTRLMRS: Mirror for resource planning relevance of operations6SALES_ORGSales Organizationnvarchar40
21/MRSS/M_RSG_SAMirror for extended assignments8SALES_ORGSales Organizationnvarchar40
22/MRSS/M_RSG_STEFControl Keys for Production Resources/Tools in Resource Plng7SALES_ORGSales Organizationnvarchar40
23/MRSS/M_RSG_ST_VMirror for Control-Key Default Values for PRT6SALES_ORGSales Organizationnvarchar40
24/MRSS/M_SUPERVSRMirror for Site Supervisor Indicator6SALES_ORGSales Organizationnvarchar40
25/MRSS/M_TRV_TIMEMirror for Customizing for travel times9SALES_ORGSales Organizationnvarchar40
26/XLSO/ADVERTISEAdvertisements3SALES_ORGSales Organizationnvarchar40
27/XLSO/FLEXI_CATFlexible catalog with sales area details4SALES_ORGSales Organizationnvarchar40
28/XLSO/RECOM_LRNRRecommendation for Learner3SALES_ORGSales Organizationnvarchar40
29/XLSO/RECOM_PRODRecommendation for Product3SALES_ORGSales Organizationnvarchar40
30EHPRCD_CMP_POSCampaign Position10SALES_ORGSales Organizationnvarchar40
31FARR_D_CHECK_ICTransparent Table for the Data Consistency Check Selection4SALES_ORGSales Organization (Compatible with SD, CRM, ...)nvarchar200
32FARR_D_CONTRACTContract23SALES_ORGSales Organization (Compatible with SD, CRM, ...)nvarchar200
33FARR_D_POBPerformance Obligation8SALES_ORGSales Organization (Compatible with SD, CRM, ...)nvarchar200
34FIEUD_SDINV_HSAFT: Invoices from SD module(Header)10SALES_ORGSales Organizationnvarchar40
35ZATPCUSTSITEATP Check: Customer Site Mapping4SALES_ORGSales Organizationnvarchar40
36ZMAT_SLS1Sales Area DAta3SALES_ORGSales Organizationnvarchar40
TOPAgency Business Global Trade
37TMPRX_DEFAB: Default Data for eSOA Services4SALES_ORGSales Organizationnvarchar40
38TMZR_PRX_GRPAB: Mapping Group for eSOA-Services6SALES_ORGSales Organizationnvarchar40
TOPCapacity and Resource Planning
39/MRSS/C_MAPNPOSCode Groups for Notification Items4SALES_ORGSales Organizationnvarchar40
40/MRSS/C_MAPTASKMapping of R/3 task4SALES_ORGSales Organizationnvarchar40
41/MRSS/C_MOB_STATAssignment of Abstract Status to Plants (Mobile Integration)3SALES_ORGSales Organizationnvarchar40
42/MRSS/C_RCT_NPRVDetermination of MRS relevance3SALES_ORGSales Organizationnvarchar40
43/MRSS/C_SUPERVSRSite Supervisor Indicator4SALES_ORGSales Organizationnvarchar40
44/MRSS/C_TRV_TIMECustomizing for travel times7SALES_ORGSales Organizationnvarchar40
TOPDistributor-Reseller-Management
45/SAPHT/DRMBUDLBill Up Due List16SALES_ORGSales Organizationnvarchar40
46/SAPHT/DRMCRFCSTReference customers for EC creation during EC aliasing4SALES_ORGSales Organizationnvarchar40
47/SAPHT/DRMCSADRVDRM: Sales Area derivation4SALES_ORGSales Organizationnvarchar40
48/SAPHT/DRMHEADDRM FIFO Header11SALES_ORGSales Organizationnvarchar40
49/SAPHT/DRMINVSUMDRM Inventory Summary8SALES_ORGSales Organizationnvarchar40
50/SAPHT/DRMIUSRDRM Internet User Management Table5SALES_ORGSales Organizationnvarchar40
51/SAPHT/DRMPPDLPrice Protection Due List8SALES_ORGSales Organizationnvarchar40
52/SAPHT/DRMPR_DEFDefault Profile for the Tracking Partner2SALES_ORGSales Organizationnvarchar40
53/SAPHT/DRMR3XNDRM relevant ERP Transactions44SALES_ORGSales Organizationnvarchar40
54/SAPHT/DRMSDDLShip and Debit Due List8SALES_ORGSales Organizationnvarchar40
55/SAPHT/DRMSTAGDRM Staging Area8SALES_ORGSales Organizationnvarchar40
56/SAPHT/DRM_CLOSEDRM CLOSING TABLE4SALES_ORGSales Organizationnvarchar40
57/SAPHT/DRM_PHONEDRM Phone Table4SALES_ORGSales Organizationnvarchar40
58KOTW002Sales org./Distr. chl/Division/Material4SALES_ORGSales Organizationnvarchar40
59S496DRM: MS Side Business Metrics5SALES_ORGSales Organizationnvarchar40
60S496ES496 - Structural information5SALES_ORGSales Organizationnvarchar40
61S497DRM: DR Side Business Metrics5SALES_ORGSales Organizationnvarchar40
62S497ES497 - Structural information5SALES_ORGSales Organizationnvarchar40
TOPDSD Connector
63/DSD/ME_CND_TYPECondition types manual discount2SALES_ORGSales Organizationnvarchar40
64/DSD/ME_CND_T_TCondition types manual discount2SALES_ORGSales Organizationnvarchar40
65/DSD/ME_CUST_HDDSD CN: Customer Details14SALES_ORGDSD Connector: Sales Organizationnvarchar40
66/DSD/ME_CUST_SADSD CN: Sales area dependent customer master data3SALES_ORGSales Organizationnvarchar40
67/DSD/ME_MAT_SORDSD CN: Material Sales Organization Data3SALES_ORGDSD Connector: Sales Organizationnvarchar40
TOPEnvironment, Health and Safety
68/TDAG/RCSA_CAPOSCampaign position data7SALES_ORGSales Organizationnvarchar40
TOPFunds Management
69FMFGRODEFDefine Reimbursable Orders2SALES_ORGSales Organizationnvarchar40
TOPGlobal Trade
70TWCBPROXYDEFAULTDefault Data for Proxy Call5SALES_ORGSales Organizationnvarchar40
TOPGrantor Management
71GTRFIBILL_HHeader of Grantor FI AP/AR Billing Doc14SALES_ORGSales Organization (CRM)nvarchar140
TOPIntegration Customer Relationship Management
72ECRMSALSERVDATACustomizing Table for CRM Organization Data5SALES_ORGCRM Sales Organization: Description of Departmentnvarchar120
73ESALES_PRODSALESProfiles of the sales transaction7SALES_ORGSales Organizationnvarchar40
74ESALES_SALESAREAAlternative Sales Areas for Profile3SALES_ORGSales Organizationnvarchar40
TOPLogistics - General
75CMDET_S06667Individual Records for Updating External Credit Data13SALES_ORGSales Organizationnvarchar40
TOPMaintenance Orders
76/MRSS/C_AUT_ASGNControl table for automatic assignment creation7SALES_ORGSales Organizationnvarchar40
77/MRSS/C_CAP_DATECapacitive Assignment - Dates5SALES_ORGSales Organizationnvarchar40
78/MRSS/C_CAP_PLANMRS: capacitive planning5SALES_ORGSales Organizationnvarchar40
79/MRSS/C_DEF_DURMRS: work of operation (default value for integration)5SALES_ORGSales Organizationnvarchar40
80/MRSS/C_OPT_FILDemand Filter Definition for Optimization8SALES_ORGSales Orgnvarchar40
81/MRSS/C_PREV_DELPrevent Deletion of Operations3SALES_ORGSales Organizationnvarchar40
82/MRSS/C_R3_AFDAssignment follows Demand (ERP Addon)5SALES_ORGSales Organizationnvarchar40
83/MRSS/C_RAP_ASGDegree of Coverage of Demands3SALES_ORGSales Organizationnvarchar40
84/MRSS/C_RAP_PARParameters for PS Integration4SALES_ORGSales Organizationnvarchar40
85/MRSS/C_RAP_PVSettings for Process Variants4SALES_ORGSales Organizationnvarchar40
86/MRSS/C_RSG_AAAllow Abstract Assignment6SALES_ORGSales Organizationnvarchar40
87/MRSS/C_RSG_CTRLMRS: resource planning relevance of operations4SALES_ORGSales Organizationnvarchar40
88/MRSS/C_RSG_SAExtended assignments6SALES_ORGSales Organizationnvarchar40
89/MRSS/C_RSG_STEFControl Keys for Production Resources/Tools in Resource Plng5SALES_ORGSales Organizationnvarchar40
90/MRSS/C_RSG_ST_VControl-Key Default Values for Production Resources & Tools4SALES_ORGSales Organizationnvarchar40
91/MRSS/D_DEM_INFOInformative Fields for Demand Items12SALES_ORGSales Orgnvarchar40
TOPMerchandise and Assortment Planning
92TWISPS_NOPROMO1Parameters for Promotions Created in MAP9SALES_ORGSales Organization: Promotion Headernvarchar40
TOPPeriodical Sales and Distribution
93JITCIRCBOOKIS-M/SD: Circulation Book with Delivery Quantities22SALES_ORGSales Organizationnvarchar40
TOPReusable Components of Business Suite Foundation
94/BOBF/DM_CST_HDRCustomer Header5SALES_ORGSales Organizationnvarchar100
95/BOBF/DM_SORD_RTSales Order Header6SALES_ORGSales Organizationnvarchar100
96/BOFU/DB_CUST_1Test Customer Header4SALES_ORGnvarchar100
97/BOFU/DDMOCUST_HDemo Customer Header5SALES_ORGSales Organizationnvarchar100
98/BOFU/DDMOSORDHDSales Order Header6SALES_ORGSales Organizationnvarchar100
99/BOFU/DTSTCUST_HTest Customer Header4SALES_ORGSales Organizationnvarchar100
100/BOFU/DTSTSORDHDSales Order Header5SALES_ORGSales Organizationnvarchar100
101/BOFU/SO_BUPA_RTSales Order Business Partner Root Table5SALES_ORGnvarchar100
TOPStructures
102PSLA_CONFIG_TBLConfiguration of Commercial Project Inception4SALES_ORGSales Organizationnvarchar40
TOPSupply Chain Management
103TCM_SLS_ORG_MAPMapping TCM Organizational unit to sales organisation5SALES_ORGSales Organizationnvarchar40
TOPVisit Control
104/DSD/VC_TSTRDSD: Customer / Calendar Type / Time Stream ID3SALES_ORGSales Organizationnvarchar40
105/DSD/VC_VLHDSD: Visit List - Header Data26SALES_ORGSales Organizationnvarchar40
106/DSD/VC_VPHDSD: Visit Schedule - Header Data33SALES_ORGSales Organizationnvarchar40