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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

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

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
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

25 columns | Print definition?ERP 6.0  | EXDAT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1T5UPBS01ACTIONPersonnel Action Definition7EXDATAction Typenvarchar20
TOPCompensation Management
2PA0382HR Master Data Record Infotype 0382 (Award)39EXDATExercise datenvarchar80
TOPContract Accounts Receivable and Payable
3DFKKWLWorklist13EXDATWork Item: Planned Run Datenvarchar80
4DFKKWLAWorklist (Work Item Type)13EXDATWork Item: Planned Run Datenvarchar80
TOPCost Center Accounting
5TKSR1HSummarization log (header)3EXDATDate of the last executionnvarchar80
6TKSR2HSummarization log - versions3EXDATDate of the last executionnvarchar80
7TKSR3HSummarization log - value types3EXDATDate of the last executionnvarchar80
8TKSR4HSummarization log - sequence information3EXDATDate of the last executionnvarchar80
TOPFunds Management
9FMBLREGLOGSafe the Runs of the Year-End Balancing Report6EXDATSystem Datenvarchar80
TOPJust-In-Time Processing
10JITITComponents Group8EXDATExternal Status Timedecimal150
TOPLease Accounting
11/LSIERP/WLWorklist11EXDATWorklist: Planned Execution Datenvarchar80
TOPLocalization
12J_1IEXCDTLExcise invoice line item details8EXDATExcise Document Datenvarchar80
13J_1IEXCHDRExcise invoice header detail11EXDATExcise Document Datenvarchar80
14J_1IGRXREFGoods Receipt to Excise Invoice Coss Reference9EXDATExcise Document Datenvarchar80
15J_1IKONVExcise recalculated conditions7EXDATExcise Document Datenvarchar80
16J_1IQRDEPQuarterly Returns Depot structure8EXDATnvarchar100
17J_1I_INBDELVINBOUND DELIVERY DETAILS FROM sus5EXDATExcise Document Datenvarchar80
TOPNon Profit Organizations
18T7UNPAD_EGEXPMGTNPO: Expense Management Table35EXDATReceipt Datenvarchar80
TOPPayroll
19PA0771Personel ana verileri: Bilgi tipi 077128EXDATTarihnvarchar80
20PB0771Personel ana verileri: Bilgi tipi 077128EXDATTarihnvarchar80
TOPPersonnel Administration
21PA0028HR Master Record: Infotype 0028 (Int. Medical Service)24EXDATExamination datenvarchar80
TOPRecruitment
22PB0028HR Master Record: Infotype 0028 (Int. Medical Service)24EXDATExamination datenvarchar80
TOPStatistics
23DBESTA_BWPROTHHistory Record for Extraction to BW Sales Statistics13EXDATExtraction Datenvarchar80
TOPTax
24T5D2PETNotif.: Key Figures7EXDATETNotif.: Key Figure Allowed for External Data (Amount)nvarchar10
TOPVisit Control
25/DSD/VC_VLHDSD: Visit List - Header Data3EXDATExecution Datenvarchar80