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

35 columns | Print definition?ERP 6.0  | FORMI

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1T042ZA_FORMATDifferent PMW Format5FORMIPayment Medium Formatnvarchar300
TOPBank Accounting
2DFPAYGPayment date: Grouping6FORMIPayment Medium Formatnvarchar300
3DFPAYVPayment Medium: Selection Variants2FORMIPayment Medium Formatnvarchar300
4TFPM042FPayment medium formats: General attributes1FORMIPayment Medium Formatnvarchar300
5TFPM042FBPayment medium formats: Events1FORMIPayment Medium Formatnvarchar300
6TFPM042FBCPayment medium formats: Customer events2FORMIPayment Medium Formatnvarchar300
7TFPM042FDPayment Medium Formats: Preassignment of Format Parameters1FORMIPayment Medium Formatnvarchar300
8TFPM042FDCPayt Medium Formats: Cust. Preassignm. of Format Parameters2FORMIPayment Medium Formatnvarchar300
9TFPM042FFPayment medium formats: Format parameters1FORMIPayment Medium Formatnvarchar300
10TFPM042FFCPayment medium formats: Customer format parameters2FORMIPayment Medium Formatnvarchar300
11TFPM042FGPayment medium formats: Level of detail of payment medium1FORMIPayment Medium Formatnvarchar300
12TFPM042FGCPayt. medium formats: Cust. level of det. of payment mediums2FORMIPayment Medium Formatnvarchar300
13TFPM042FMPayment medium formats: Reqd fields for format parameters1FORMIPayment Medium Formatnvarchar300
14TFPM042FMCPayment medium formats: Cust. reqd. fields for format para.2FORMIPayment Medium Formatnvarchar300
15TFPM042FTPayment medium formats: Texts2FORMIPayment Medium Formatnvarchar300
16TFPM042FVPayment medium formats: Note to payee fields1FORMIPayment Medium Formatnvarchar300
17TFPM042FZPayment medium formats: Supplements1FORMIPayment Medium Formatnvarchar300
18TFPM042FZTPayment medium formats: Supplement text2FORMIPayment Medium Formatnvarchar300
TOPContract Accounts Receivable and Payable
19DPAYGPayment program - payment group6FORMIPayment medium formatnvarchar300
20DPAYVPayment program: Variants for payment medium and list5FORMIPayment medium formatnvarchar300
21TFK042FPayment medium formats1FORMIPayment medium formatnvarchar300
22TFK042FBPayment medium events1FORMIPayment medium formatnvarchar300
23TFK042FEPayment program: company code format specifications3FORMIPayment medium formatnvarchar300
24TFK042FFLevel of Detail When Creating Payment Medium1FORMIPayment medium formatnvarchar300
25TFK042FGLevel of Detail When Creating Payment Medium (Refinement)2FORMIPayment medium formatnvarchar300
26TFK042FMRequired Fields for Format Parameters1FORMIPayment medium formatnvarchar300
27TFK042FTPayment medium formats (long text)2FORMIPayment medium formatnvarchar300
28TFK042FXText Fields for Reference Details (Note to Payee)1FORMIPayment medium formatnvarchar300
29TFK042FZSupplements for payment medium formats1FORMIPayment medium formatnvarchar300
30TFK042FZTSupplements for payment medium formats (long text)2FORMIPayment medium formatnvarchar300
31TFK042ZPayment Program: Additional Specifications for Payt Methods11FORMIPayment medium formatnvarchar300
32TFKPAYMFBCPayment Medium: Installation-Specific Modules4FORMIPayment medium formatnvarchar300
33TFKPAYMFBMPayment Medium: Events and Standard Function Modules2FORMIPayment medium formatnvarchar300
34TFKPAYMFBSPayment Medium: Standard Modules4FORMIPayment medium formatnvarchar300
TOPPayment Transactions
35T042ZPayment Methods for Automatic Payment15FORMIPayment Medium Formatnvarchar300