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

47 columns | Print definition?ERP 6.0  | VERTRAG

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNVTDMS_05_EVERContracts TDMS for ISU3VERTRAGBELNR for CNVTDMS_05_*nvarchar100
2ECRM_MIOMR_TMPTemporary MR Data2VERTRAGContractnvarchar100
3ETOUEXCEPTRESPARArchiving Index TOU Exception Response4VERTRAGContractnvarchar100
TOPArchiving
4ERCHARCIndex for Archivable Billing Documents5VERTRAGContractnvarchar100
TOPContract Billing
5EOUTL_ASSIGNAssigne Contracts to Outline Agreement3VERTRAGContractnvarchar100
6EPPMHEADERHeader Table for Prepayment Meter3VERTRAGContractnvarchar100
7ERCHBilling Doc. Data7VERTRAGContractnvarchar100
8ERCH_RIVAHeader Data for Billing Document Extract (RIVA)6VERTRAGContractnvarchar100
9ERCH_SHORTHeader Data for Billing Document - Extract7VERTRAGContractnvarchar100
TOPIntegration Customer Relationship Management
10ECRM_REPL_HDHeader Data for IS-U Sales Replication Error Handling3VERTRAGContractnvarchar100
11EVER_CRMQISU Contract CRM-Entry Queue4VERTRAGContractnvarchar100
12EVER_CRMQ_PLANEDISU Contract CRM-Entry Queue4VERTRAGContractnvarchar100
13EVER_PC_CONTRTable of Contracts for Mass Rate Change3VERTRAGContractnvarchar100
14EVER_PC_CONTRPARMast.Data Generator: Attribute Table for Mass Product Change2VERTRAGContractnvarchar100
TOPIntercompany Data Exchange
15ECROSSREFNOReference Number for IDoc9VERTRAGContractnvarchar100
16ESERVICEPoint of delivery service2VERTRAGPoint of delivery ID (as in contract)nvarchar100
TOPInvoicing
17DBEOSBIS-U On-Site Billing5VERTRAGContractnvarchar100
18DBERDLPrint Document Line Items11VERTRAGContractnvarchar100
19DBERDLBReference of a Print Doc. Line Item to a Bill.Doc. Line Item9VERTRAGContractnvarchar100
20DBERDZDB Table: Individ. Lines - Print Document22VERTRAGContractnvarchar100
21DEABPTable: Customer Change Header Data for BB Amounts3VERTRAGContractnvarchar100
22EABPBudget Billing Plan3VERTRAGContractnvarchar100
23EABPJVL_CORRCorrespondence Print: Bud. Bill. Plan Header and YAP Info.5VERTRAGContractnvarchar100
24EITRTemporary Selection Data for IS-U Invoicing10VERTRAGContractnvarchar100
25EJVLYearly Advance Payment3VERTRAGReference Specifications from Contractnvarchar200
26ERDTSAdditional Charges and Taxes of a Print Document8VERTRAGContractnvarchar100
27ERDZ_SHORTInternal Table for Individual Print Doc.Lines -Extract Data14VERTRAGContractnvarchar100
28TEPYPMContract history for generating payment schedule2VERTRAGContractnvarchar100
29TEPYPM_TEMPLATETemplates for contract history, payment plan generation2VERTRAGContractnvarchar100
TOPMarketing
30EMKT_ESTM_CONSMarketing: Extrapolated Consumption for Each Contract2VERTRAGContractnvarchar100
31EMKT_ESTM_CONS_IMarketing: Trigger for Consumption Extraction (Insert)2VERTRAGContractnvarchar100
32EMKT_ESTM_CONS_PMarketing: Extrapolation Index for Mass Activity2VERTRAGContractnvarchar100
33EMKT_ESTM_CONS_UMarketing: Trigger for Consumption Extraction (Update)2VERTRAGContractnvarchar100
TOPMaster Data
34ELACCZLoyalty Account Line Item15VERTRAGContractnvarchar100
35EVERIS-U Cont.2VERTRAGContractnvarchar100
36EVERHIS-U Contract History2VERTRAGContractnvarchar100
TOPMove-InOut
37EAUSVMove-out Doc. Contract Level3VERTRAGContractnvarchar100
38ECAMIOPRCIIS-U: Parked Document: Contracts and Installations9VERTRAGContractnvarchar100
39EEINVMove-in Doc. for Cont.3VERTRAGContractnvarchar100
TOPSAP Utilities
40ECONCPOSTPosting Details for Concession5VERTRAGContractnvarchar100
41EVER_AUDITIS-U Audit Flags for Contracts2VERTRAGContractnvarchar100
TOPStatistics
42EMDSTTSCONNotes for Future Changes to Stock Statistics3VERTRAGContractnvarchar100
TOPWaste Management
43EWAOBJH_AATWaste Billing Categories for Service Frequency Service5VERTRAGContractnvarchar100
44EWAOBJH_AAT_HISTHistory and Valution of WBCs for Service Freq. Service5VERTRAGContractnvarchar100
45EWA_WA_WEIGHOFFLOffline Weighing16VERTRAGContractnvarchar100
46EWA_WA_WEIGHPROCWeighing Transaction64VERTRAGContractnvarchar100
47ISU2A_INDEX_GGIndex Table for Document Numbers for Guarantor Contract2VERTRAGContractnvarchar100