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

60 columns | Print definition?ERP 6.0  | RETYP

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1P2BR_9LREDTARetroactive accounting data6RETYPRetroactive Accounting Typenvarchar40
2P2CO_9LREDTARetroactive Accounting Data6RETYPRetroactive Accounting Typenvarchar40
3P2CO_COSSAPC2CO_SSA6RETYPRetroactive Accounting Typenvarchar40
4P2MX_9LREDTARetroactive Accounting Data6RETYPRetroactive Accounting Typenvarchar40
5P2RI_INFO155Structure for infotype 0155 (IT) with date18RETYPRetroactive accounting typenvarchar10
6T5C1HPension Types10RETYPHR-CH: PF: Pension typenvarchar20
7T77WWW_CLCNFIGMLCustomize Mail Configuration3RETYPReimbursement Typenvarchar40
8T77WWW_CLDCLTXTable to store Declaration text4RETYPReimbursement Typenvarchar40
9T77WWW_CLDCLTXTReimbursement Type Declaration Text(Dialog Text)4RETYPReimbursement Typenvarchar40
10T77WWW_CLDPVCDependent data Visibilty Control3RETYPReimbursement Typenvarchar40
11T77WWW_CLFDATTable to store the file data stored in third party server4RETYPReimbursement Typenvarchar40
12T77WWW_CLHLCHeader Level Field Configuration3RETYPReimbursement Typenvarchar40
13T77WWW_CLHLCOF4 Help/Drop down Options for Header Fields3RETYPReimbursement Typenvarchar40
14T77WWW_CLHLDCHeader level dynamic content configuration3RETYPReimbursement Typenvarchar40
15T77WWW_CLHLDCOF4 Help/Drop down options for Header level dynamic fields3RETYPReimbursement Typenvarchar40
16T77WWW_CLHLDCOTText Table for F4 Help/Drop down Options for Header Fields4RETYPReimbursement Typenvarchar40
17T77WWW_CLHLDCTText Table for Header Level Configuration4RETYPReimbursement Typenvarchar40
18T77WWW_CLLTCSCHMLTC Schemes Master Table3RETYPReimbursement Typenvarchar40
19T77WWW_CLLTCSCHTLTC Scheme Code Text4RETYPReimbursement Typenvarchar40
20T77WWW_CLMLCMultiple line item level dynamic content configuration table3RETYPReimbursement Typenvarchar40
21T77WWW_CLMLCOF4 Help/Drop down Options for Multiple Line Fields3RETYPReimbursement Typenvarchar40
22T77WWW_CLMLDCMultiple line item level dynamic content configuration table3RETYPReimbursement Typenvarchar40
23T77WWW_CLMLDCOF4 Help/Drop down Options for Multiple Line Level3RETYPReimbursement Typenvarchar40
24T77WWW_CLMLDCOTText Table for F4 Help/Drop Down Options for Multiple Fields4RETYPReimbursement Typenvarchar40
25T77WWW_CLMLDCTText Table for Multiple Line Configuration4RETYPReimbursement Typenvarchar40
26T77WWW_CLMLSELIGLTC Schemes mapping with Allowance Grouping4RETYPReimbursement Typenvarchar40
27T77WWW_CLOFPYDCOff-Cycle Payment Day Configuration3RETYPReimbursement Typenvarchar40
28T77WWW_CLPDFLFMTPDF File Format for the Request3RETYPReimbursement Typenvarchar40
29T77WWW_CLREIMReimbursement Type master table3RETYPReimbursement Typenvarchar40
30T77WWW_CLREIMCReimbursement Codes3RETYPReimbursement Typenvarchar40
31T77WWW_CLREIMTText for Reimbursement Codes4RETYPReimbursement Typenvarchar40
32T77WWW_CLRETYPCHReimbursement Type Characteristics Table3RETYPReimbursement Typenvarchar40
33T77WWW_CLRQTYPCHRequest Type Characteristic Table3RETYPReimbursement Typenvarchar40
34T77WWW_CLTRANSDCluster table for storing transaction data.5RETYPReimbursement Typenvarchar40
35T77WWW_CLTRAN_BUBackup Table for Storing Transaction Data5RETYPReimbursement Typenvarchar40
36T77WWW_ELIGIBLEEmployee Eligibility for Advanced Claims6RETYPReimbursement Typenvarchar40
TOPBrazil
37T7BRX1Labor Debits2RETYPRetroactive Accounting Typenvarchar40
TOPFreight Processing
38VFKNAccount Determination in Shipment Costs Item9RETYPSD document categorynvarchar10
TOPHong Kong
39PA0440HR Master Record: Infotype 0440 (Receipts)24RETYPReceipt Typenvarchar40
TOPItaly
40PA0155HR master record, infotype 0155 (Suppl.admin.data)36RETYPRetroactive accounting typenvarchar10
41T5ITAICumulation wage types of recalculated differences3RETYPRetroactive accounting typenvarchar10
TOPLogistics - General LO Enhancements
42/SAPMP/RT_SEQCESequence of Reel Types for Reel Category4RETYPReel Typenvarchar180
TOPMalaysia
43T5LESESS Malaysia: TP1 TP22RETYPRequest Typenvarchar40
44T5LOPDESS Optional Deductions6RETYPRequest Typenvarchar40
TOPPatient Accounting
45NTFIIS-H: Service Catalog Determination Rules3RETYPIS-H: Usage of the Decision Rulenvarchar20
46TN20AIS-H: Service Catalog Column Determination3RETYPIS-H: Usage of the Decision Rulenvarchar20
47TN21PIS-H: Condition Types Usage5RETYPIS-H: Usage of the Decision Rulenvarchar20
TOPPersonnel Administration
48T7COT2Payroll external results transfer: COSSA6RETYPRetroactive Accounting Typenvarchar40
TOPProduction and Revenue Accounting
49OIUP_ME_MEDOC_ITMeasurement document item (PDM Shadow)6RETYPReading Typenvarchar100
50OIU_ME_MEDOC_ITMeasurement document item5RETYPReading Typenvarchar100
51OIU_ME_MREADMeasurement Type Reading4RETYPReading Typenvarchar100
52OIU_ME_RTYPEReading Type2RETYPReading Typenvarchar100
53OIU_ME_RTYPE_CHReading Type Characteristics2RETYPReading Typenvarchar100
54OIU_ME_RTYPE_TXReading Type Text3RETYPReading Typenvarchar100
TOPReuse Services for Country Development
55T799L20Retroactive Accounting Reasons4RETYPRetroactive Accounting Typenvarchar40
56T799L21Define Retroactive Accounting Types3RETYPRetroactive Accounting Typenvarchar40
57T799L2XRetroactive Accounting Types3RETYPRetroactive Accounting Typenvarchar40
58T799L2YTexts Retroactive Accounting Types4RETYPRetroactive Accounting Typenvarchar40
TOPSales Plan
59T445LSOP Planning Table Definitions19RETYPRepetition typenvarchar10
TOPSAP Healthcare - Industry-Specific Components for Hospitals
60NNTFIS-H NL: Service Catalog Determination3RETYPIS-H: Usage of the Decision Rulenvarchar20