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

33 columns | Print definition?ERP 6.0  | PFNUM

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1P01PF_PFBB_DIRPO Rebuild: Transfer Garnishable Amount Directly4PFNUMGarnishment Numbernvarchar30
2P2RA_CMASSPayroll Result: Garnishment (A) - Net Parts6PFNUMGarnishment Numbernvarchar30
3P2RA_GRDLGPayroll Result: Garnishment (A) - Bases6PFNUMGarnishment Numbernvarchar30
4P2RA_GUTHAPayroll Result: Garnishment (A) - Credit6PFNUMGarnishment Numbernvarchar30
5P2RA_MASSEPayroll Result: Garnishment (A) - Net Parts with Differences6PFNUMGarnishment Numbernvarchar30
6P2RA_STAUSPayroll Result: Garnishment (A) - Compensation Payment6PFNUMGarnishment Numbernvarchar30
7P2RA_STPFBPayroll Result: Garnishment (A) - Garnishable Amt (Mst.Data)6PFNUMGarnishment Numbernvarchar30
8P2RA_STPSOPayroll Result: Garnishment (A) - Special Condition6PFNUMGarnishment Numbernvarchar30
9P2RD_APFBTPayroll Result: Garnishment D - Garnishable Amount6PFNUMGarnishment Numbernvarchar30
10P2RD_APFGRPayroll Result: Garnishment D - Garnishment Bases6PFNUMGarnishment Numbernvarchar30
11P2RD_GUTHAPayroll Result: Garnishment D - Cluster Key DP6PFNUMGarnishment Numbernvarchar30
12P2RD_STAUSPayroll Result: Garnishment D - Settlement Payment6PFNUMGarnishment Numbernvarchar30
13P2RD_STLGAPayroll Result: Garnishment D - Spec. Cond. Wage Types6PFNUMGarnishment Numbernvarchar30
14P2TH_PFUNDPayroll Results : Provident Fund TH8PFNUMProvident Fund Number (TH)nvarchar200
15T7UNPF_HR_STFHDStaff Member Header Table5PFNUMPension Numbernvarchar60
TOPAustria
16PA0131HR Master Record: Infotype 0131 (Garnishment/Cession A)25PFNUMGarnishment Numbernvarchar30
17PA0132HR Master Record: Infotype 0132 (Garnishment Claim A)25PFNUMGarnishment Numbernvarchar30
18PA0133HR Master Record: Infotype 0133 (Garn. Interest A)25PFNUMGarnishment Numbernvarchar30
19PA0134HR Master Record: Infotype 0134 (Garnishment Amount A)25PFNUMGarnishment Numbernvarchar30
20PA0135HR Master Record: Infotype 0135 (Spec. Garn. Cond. A)25PFNUMGarnishment Numbernvarchar30
21PA0136HR Master Record: Infotype 0136 (Garn. Transfer A)25PFNUMGarnishment Numbernvarchar30
22PA0137HR Master Record: Infotype 0137 (Garn. Compensation A)25PFNUMGarnishment Numbernvarchar30
TOPGarnishmentCession
23P01PF_TILGGarnishment of Principle of Origin: Repayment Amounts5PFNUMGarnishment Numbernvarchar30
TOPGermany
24PA0111HR Master Record: Infotype 0111 (Garnishment/Cession - D)25PFNUMGarnishment Numbernvarchar30
25PA0112HR Master Record: Infotype 0112 (Garnishment Claim - D)25PFNUMGarnishment Numbernvarchar30
26PA0113HR Master Record: Infotype 0113 (Garnish. Interest - D)25PFNUMGarnishment Numbernvarchar30
27PA0114HR Master Record: Infotype 0114 (Garnishment Amount D)25PFNUMGarnishment Numbernvarchar30
28PA0115HR Master Record: Infotype 0115 (Garnishment Wages D )25PFNUMGarnishment Numbernvarchar30
29PA0116HR Master Record: Infotype 0116 (Garn. Transfer D)25PFNUMGarnishment Numbernvarchar30
30PA0117HR Master Record: Infotype 0117 (Garn. Compensation D)25PFNUMGarnishment Numbernvarchar30
31PA0904HR Master Record Infotype 090425PFNUMGarnishment Numbernvarchar30
TOPNon Profit Organizations
32PA0961HR Master Record: Infotype 096128PFNUMPension Fund Numbernvarchar200
TOPThailand
33PA0366Provident Fund THAILAND24PFNUMProvident Fund Number (TH)nvarchar200