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

77 columns | Print definition?ERP 6.0  | DIVISION

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/GBT/O_DLVY_ITMDelivery Item for Tracking22DIVISIONDivisionnvarchar20
2/GBT/O_SALO_HDRSales Document19DIVISIONDivisionnvarchar20
3/MRE/RSC_S0_DETASales Organization Details4DIVISIONDivisionnvarchar20
4/MRE/RSC_SA_TRGTSales Area Specific Target4DIVISIONDivisionnvarchar20
5/MRE/SAREA_TRGTSales Area Specific Target4DIVISIONDivisionnvarchar20
6/XLSO/FLEXI_CATFlexible catalog with sales area details6DIVISIONDivisionnvarchar20
7/XLSO/SALES_CN_PXLSO Table to store Country and Sales Area with Plant4DIVISIONDivisionnvarchar20
8FIEUD_SDINV_HSAFT: Invoices from SD module(Header)11DIVISIONDistribution Channelnvarchar20
9HRT7900Table Part Infotype 79006DIVISIONDivisionnvarchar20
10ZATPCUSTSITEATP Check: Customer Site Mapping6DIVISIONDivisionnvarchar20
11ZLAMLam Division11DIVISIONManufacturer model numbernvarchar200
12ZLAMSUBLAM Division12DIVISIONManufacturer model numbernvarchar200
13ZMAT_REQMaterial Request10DIVISIONDivisionnvarchar20
14ZMAT_SLS1Sales Area DAta5DIVISIONDivisionnvarchar20
TOPAdvertising Management
15/NAM/JJTMINMAXRLMin Max Rules4DIVISIONDivisionnvarchar20
16TJJCAMP_SLS_AREAIS-M/AM: Marketing Campaign - Sales Area5DIVISIONDivisionnvarchar20
TOPAgency Business Global Trade
17TMPRX_DEFAB: Default Data for eSOA Services6DIVISIONDivisionnvarchar20
18TMZR_PRX_GRPAB: Mapping Group for eSOA-Services8DIVISIONDivisionnvarchar20
TOPBasic Functions
19ETXDCIExternal tax document: line item info10DIVISIONBusiness area/division codenvarchar40
20TTXYExternal tax interface: tax information10DIVISIONBusiness Areanvarchar40
TOPContract Accounts Receivable and Payable
21DFK_JC_CNTR_MSGMessages for Background Processing2DIVISIONABAP Program Namenvarchar400
TOPCPE in SD
22CPEC_SD_VALFORMArea of Validity for Commodity Pricing Formula in SD7DIVISIONDivisionnvarchar20
23CPEC_SD_VALRULEArea of Validity for Commodity Pricing Term Rule in SD6DIVISIONDivisionnvarchar20
24CPEC_SD_VALTERMArea of Validity for Commodity Pricing Term in SD7DIVISIONDivisionnvarchar20
TOPDepreciation Simulation
25IMCCIM Summarization: Characteristics that are master data41DIVISIONRequesting Divisionnvarchar20
TOPDistributor-Reseller-Management
26/SAPHT/DRMBUDLBill Up Due List18DIVISIONDivisionnvarchar20
27/SAPHT/DRMCRFCSTReference customers for EC creation during EC aliasing6DIVISIONDivisionnvarchar20
28/SAPHT/DRMCSADRVDRM: Sales Area derivation6DIVISIONDivisionnvarchar20
29/SAPHT/DRMHEADDRM FIFO Header13DIVISIONDivisionnvarchar20
30/SAPHT/DRMINVSUMDRM Inventory Summary10DIVISIONDivisionnvarchar20
31/SAPHT/DRMIUSRDRM Internet User Management Table7DIVISIONDivisionnvarchar20
32/SAPHT/DRMPPDLPrice Protection Due List10DIVISIONDivisionnvarchar20
33/SAPHT/DRMPR_DEFDefault Profile for the Tracking Partner4DIVISIONDivisionnvarchar20
34/SAPHT/DRMR3XNDRM relevant ERP Transactions46DIVISIONDivisionnvarchar20
35/SAPHT/DRMSDDLShip and Debit Due List10DIVISIONDivisionnvarchar20
36/SAPHT/DRMSTAGDRM Staging Area10DIVISIONDivisionnvarchar20
37/SAPHT/DRM_CLOSEDRM CLOSING TABLE6DIVISIONDivisionnvarchar20
38/SAPHT/DRM_PHONEDRM Phone Table6DIVISIONDivisionnvarchar20
39KOTW002Sales org./Distr. chl/Division/Material6DIVISIONDivisionnvarchar20
TOPDSD Connector
40/DSD/ME_CND_TYPECondition types manual discount4DIVISIONDivisionnvarchar20
41/DSD/ME_CND_T_TCondition types manual discount4DIVISIONDivisionnvarchar20
42/DSD/ME_CUST_HDDSD CN: Customer Details16DIVISIONDSD Connector: Divisionnvarchar20
43/DSD/ME_CUST_SADSD CN: Sales area dependent customer master data5DIVISIONDivisionnvarchar20
44/DSD/ME_MAT_HDDSD CN: Material Data for Downloading to HH6DIVISIONDSD Connector: Divisionnvarchar20
TOPElectronic Data Interchange
45PRICAT_K001PRICAT: Catalog header18DIVISIONDivisionnvarchar20
46PRICAT_K003PRICAT: Catalog item basic data24DIVISIONDivisionnvarchar20
47PRICAT_K003_PROIndication of Data to be Adopted from PRICAT_K00322DIVISIONIndicator for copying catalog datanvarchar10
TOPEnergy Data Management
48EAMI_AMS_ALLOCAllocation of AMI to Grid3DIVISIONDivisionnvarchar20
49EEDMDAYOFFSETEDM Day Offset3DIVISIONDivisionnvarchar20
50EEDMDAYOFFSETTEDM Day Offset3DIVISIONDivisionnvarchar20
TOPFunds Management
51FMFGRODEFDefine Reimbursable Orders4DIVISIONDivisionnvarchar20
TOPGrantor Management
52GTRFIBILL_HHeader of Grantor FI AP/AR Billing Doc17DIVISIONDivisionnvarchar20
TOPIntegration Customer Relationship Management
53ECRMSALSERVDATACustomizing Table for CRM Organization Data3DIVISIONDivisionnvarchar20
54ECRMTRANSACTTYPECustomizing Table for CRM Transaction Type2DIVISIONDivisionnvarchar20
55ESALES_PRODSALESProfiles of the sales transaction9DIVISIONDivisionnvarchar20
56ESALES_SALESAREAAlternative Sales Areas for Profile5DIVISIONDivisionnvarchar20
57ESIMPRODUCTSAdmissible Simulation Products3DIVISIONDivisionnvarchar20
TOPIntercompany Data Exchange
58TECDEService Types3DIVISIONDivisionnvarchar20
TOPLocalization
59J_3RFTAXROTax Accounting: Object table21DIVISIONDivision Numbernvarchar50
60J_3RFTAXRVOTax Accounting: Object table21DIVISIONDivision Numbernvarchar50
TOPLogistics - General
61CMDET_S06667Individual Records for Updating External Credit Data15DIVISIONDivisionnvarchar20
TOPMarketing, Accounting and Pricing
62OIC_FORM_ATTRIBAttributes of Business Context for F&A Formula11DIVISIONDivisionnvarchar20
TOPMaster Data
63ECRM_OBJ_MDTDVDivision Dependant MDT3DIVISIONDivisionnvarchar20
64GMGRGrant Master30DIVISIONDivisionnvarchar20
TOPPeriodical Sales and Distribution
65JLHDEXTINTERFACEIS-M: External Interface for Home Delivery Settlement10DIVISIONDivisionnvarchar20
TOPRegional structure
66EADRCITYAMSAMS for Locations4DIVISIONDivisionnvarchar20
67EADRSTRTAMSAMS for Street9DIVISIONDivisionnvarchar20
TOPRegulatory reporting for insurance companies
68TISSR_DIVISIONISSR: Versicherungssparte3DIVISIONKennzeichen Versicherungsspartenvarchar20
69TISSR_DIVISIONTISSR: Versicherungssparte4DIVISIONKennzeichen Versicherungsspartenvarchar20
TOPSAP Utilities
70TEQD_PROCQuantity Determination Procedure2DIVISIONDivisionnvarchar20
TOPSupply Chain Management
71TCM_SLS_ORG_MAPMapping TCM Organizational unit to sales organisation7DIVISIONDivisionnvarchar20
TOPTransaction Tax Engine
72TTEPD3_USITEMPersistency TTE Document UsItem5DIVISIONBusiness Area/Division Codenvarchar40
73TTEPDT_USITEMPersistency TTE Document UsItem5DIVISIONBusiness Area/Division Codenvarchar40
74TTESDT_USITEMOutput Exemptions5DIVISIONBusiness Area/Division Codenvarchar40
TOPVisit Control
75/DSD/VC_TSTRDSD: Customer / Calendar Type / Time Stream ID5DIVISIONDivisionnvarchar20
76/DSD/VC_VLHDSD: Visit List - Header Data28DIVISIONDivisionnvarchar20
77/DSD/VC_VPHDSD: Visit Schedule - Header Data35DIVISIONDivisionnvarchar20