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

53 columns | Print definition?ERP 6.0  | GCATE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1P2BR_GRORDAlimony order8GCATECode for categorynvarchar10
2P2CO_COGARPC2CO_GAR6GCATEGarnishment categorynvarchar10
3P2MX_GRORDMaintenance payment order7GCATECode for categorynvarchar10
4P2RK_GRORDPayroll results Canada: Garnishment order7GCATECode for categorynvarchar10
5P2RU_GRDOCPayroll Results: Garnishment for US Document9GCATEGarnishment document categorynvarchar10
6T7RUG2OBSOLETE Garnishmetn Document Category (Russia)3GCATEGarnishment Document Categorynvarchar10
7T7RUG2TOBSOLETE: Garnishmetn Document Category (Russia): Texts4GCATEGarnishment Document Categorynvarchar10
TOPBrazil
8PA0736Alimony order for Brazil26GCATECode for categorynvarchar10
9T7BRG0Calculation rule characteristics3GCATECode for categorynvarchar10
TOPCanada
10PA0066HR Master data infotype 0066 - Canadian garnishment: order26GCATECode for categorynvarchar10
11T5KG9Garnishee fee3GCATECode for categorynvarchar10
TOPMexico
12PA0426Garnishment26GCATECode for categorynvarchar10
13T7MXG0Maintenance payment debt Mexico2GCATECode for categorynvarchar10
TOPPayroll General Parts
14PA0476HR master record infotype 0476 (Deductions Spain)26GCATECode for Garnishment Categorynvarchar10
15T52G2Garnishment category3GCATECode for categorynvarchar10
16T52G3Description of the garnishment category4GCATECode for categorynvarchar10
17T52G6Remittance rule4GCATECode for categorynvarchar10
18T52G7Debt3GCATECode for categorynvarchar10
19T52G8Description of the debt4GCATECode for categorynvarchar10
20T52GFCalculation rule4GCATECode for categorynvarchar10
21T52GGDescription of the calculation rule5GCATECode for categorynvarchar10
22T52GHCalculation rule characteristics4GCATECode for categorynvarchar10
23T52GIGarnishee fee4GCATECode for categorynvarchar10
24T52GJDescription of garnishee fee5GCATECode for categorynvarchar10
25T53G1Garnishment Category3GCATECode for Garnishment Categorynvarchar10
26T53G1TDescription of the garnishment category4GCATECode for Garnishment Categorynvarchar10
27T53G4Debt Types for Garnishments3GCATECode for Garnishment Categorynvarchar10
28T53G4TDescription of the debt4GCATECode for Garnishment Categorynvarchar10
29T53GQService Charge4GCATECode for Garnishment Categorynvarchar10
30T53GRService Charge Description5GCATECode for Garnishment Categorynvarchar10
31T53GSService Charge Characterisitics4GCATECode for Garnishment Categorynvarchar10
32T53GTPriority of debts4GCATECode for Garnishment Categorynvarchar10
33T53GUCalculation Model4GCATECode for Garnishment Categorynvarchar10
34T53GVDescription of the calculation model5GCATECode for Garnishment Categorynvarchar10
35T53GWCharacteristics of the Calculation Rule4GCATECode for Garnishment Categorynvarchar10
TOPPersonnel Administration
36PA0835HR master record for infotypes 083525GCATEGarnishment categorynvarchar10
37T7CO16Garnishment categories2GCATEGarnishment categorynvarchar10
38T7CO16TGarnishment category texts (CO)2GCATEGarnishment categorynvarchar10
39T7COT6Payroll external results transfer: COGAR6GCATEGarnishment categorynvarchar10
TOPRussia
40PA0296HR Master Record Infotype 0296 (Garnishment Document)44GCATEGarnishment Document Categorynvarchar10
41T7RUG0HR: Garnishment Order Types4GCATEGarnishment Document Categorynvarchar10
42T7RUG1Garnishment Document Category2GCATEGarnishment Document Categorynvarchar10
43T7RUGXHR: Garnishmetn Document Category (Russia) - TEXT table3GCATEGarnishment Document Categorynvarchar10
TOPSpain
44T5EG9Garnishee fee3GCATECode for categorynvarchar10
TOPUSA
45PA0194HR Master Record Infotype 0194 (Garnishment Document)46GCATEGarnishment document categorynvarchar10
46T5UG0HR: Garnishment Order Types4GCATEGarnishment document categorynvarchar10
47T5UG1HR: Garnishment Document Category2GCATEGarnishment document categorynvarchar10
48T5UG6Government Service Charge4GCATEGarnishment document categorynvarchar10
49T5UG7Government Remittance Rule4GCATEGarnishment document categorynvarchar10
50T5UG8Company Remittance Rule5GCATEGarnishment document categorynvarchar10
51T5UGCService Charge4GCATEGarnishment document categorynvarchar10
52T5UGGCompany Service Charge5GCATEGarnishment document categorynvarchar10
53T5UGIGarnishment Letters4GCATEGarnishment document categorynvarchar10