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

76 columns | Print definition?ERP 6.0  | KASSE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1P2RB_PKPension Fund, Payroll Belgium7KASSEPension fundnvarchar40
2P2RC_PKHR-CH: Pension fund payroll values7KASSEPension fundnvarchar40
3P2RN_PKPayroll Result: Pension Module7KASSEPension fundnvarchar40
4P2UN_PKPension Fund, Payroll United Nations7KASSEPension fundnvarchar40
5T5C1ETransaction Types2KASSEPension fundnvarchar20
6T5C1FTotal Transaction Types2KASSEPension fundnvarchar20
7T5C1GPercentages2KASSEPension fundnvarchar20
8T5C1HPension Types2KASSEPension fundnvarchar20
9T5C1ITexts for Pension Types3KASSEPension fundnvarchar20
10T5C1JPension Rates (CH)2KASSEPension fundnvarchar20
11T5C1KHR-CH: insurance contributions2KASSEInsurance companiesnvarchar20
12T5C1ZCompany Pension Fund Factors2KASSEPension fundnvarchar20
TOPPension fund General Parts
13PA0278HR Master Record: Infotype 0278 (Basic Data PF [CH])24KASSEPension fundnvarchar40
14PA0279HR Master Record: Infotype 0279 (Individual Values PF [CH])24KASSEPension fundnvarchar40
15T5CP0HR-CH: Pension funds2KASSEPension fundnvarchar40
16T5CP1HR-CH: Texts for pension funds3KASSEPension fundnvarchar40
17T5CP2HR-CH: Control of pension funds2KASSEPension fundnvarchar40
18T5CP3HR-CH: Field assignment for infotype 2792KASSEPension fundnvarchar40
19T5CP4HR-CH: Value assignment for fields (BI)2KASSEPension fundnvarchar40
20T5CP5HR-CH: Infotypes for BI2KASSEPension fundnvarchar40
21T5CP8HR-PF: Frame Texts for Infotype 02793KASSEPension fundnvarchar40
22T5CPAHR-CH: Determination of Wage Types for PF Value Types3KASSEPension fundnvarchar40
23T5CPEControl of PF Calculations2KASSEPension fundnvarchar40
24T5CPFFund Function View2KASSEPension fundnvarchar40
25T5CPFTFund Function Names3KASSEPension fundnvarchar40
26T5CPJFund Function View Categories2KASSEPension fundnvarchar40
27T5CPJTFund Function View Category Names3KASSEPension fundnvarchar40
28T5CPKHR-CH: PF account index3KASSEPension fundnvarchar40
29T5CPMInfotype 0279 Fund and Employee Grouping Data2KASSEPension fundnvarchar40
30T5CPNPF Functions in Fund Function View Category2KASSEPension fundnvarchar40
31T5CPRAdditional PF Re-Calculation Infotypes2KASSEPension fundnvarchar40
32T5CPSAdditional Infotype Field Values for PF Calculation2KASSEPension fundnvarchar40
33T5CPVControl of PF Functions2KASSEPension fundnvarchar40
34T5CPWAd Hoc Query Field Assignment2KASSEPension fundnvarchar40
35T5NF3PA-PF-NL: Feldzuordnung für Infotyp 2792KASSEPensioenfondsnvarchar40
36T72A1HR-PF: Account Types per Fund2KASSEPension fundnvarchar40
37T72A5HR-IB: History PF recalculation3KASSEPension fundnvarchar40
38T72A6HR-IB: Parameters for a PF recalculation3KASSEPension fundnvarchar40
39T72A9HR-PF: Total Compensation Statement Integration4KASSEPension fundnvarchar40
40T72AAHR-IB: Relevance of PF Recalculations2KASSEPension fundnvarchar40
41T72ABHR-IB: Eligibility of PF recalculations2KASSEPension fundnvarchar40
42T72ACVarainats for the Wage Maintenance Debugger6KASSEPension fundnvarchar40
43T72P0HR-PF: Determination of Payroll Values for PF Value Types5KASSEPension fundnvarchar40
44T72T5HR-PF: TS Account Data6KASSEPension fundnvarchar40
45T72T6HR-PF: TS Account Data Totals Formation6KASSEPension fundnvarchar40
46T72T9HR-PF: TS Payroll Data6KASSEPension fundnvarchar40
47T72TAHR-PF: TS Payroll Data Totals Formation6KASSEPension fundnvarchar40
48T72TBHR-PF: TS Parameter Values6KASSEPension fundnvarchar40
TOPPension fund Netherlands
49PA0665Personal-Stammsatz Infotyp 066545KASSEPensioenfondsnvarchar40
50T5ND2HR-CH: Pension fund postings2KASSEPension fundnvarchar40
51T5ND5Action per Event for retroactive Accounting for NL Pension2KASSEPensioenfondsnvarchar40
52T5NDCLog tabel voor euroconversie van tabel T5NE3 VK Reporting2KASSEPensioenfondsnvarchar40
53T5NDDLog tabel voor euroconversie van tabel T5NEA VK Reporting2KASSEPensioenfondsnvarchar40
54T5NDGHR-NL: Output-sequentie voor output-groepering2KASSEPensioenfondsnvarchar40
55T5NDHHR-NL: Output-groepering voor gebeurtenis2KASSEPensioenfondsnvarchar40
56T5NDIHR-NL: Eigenschappen van gebeurtenissen2KASSEPensioenfondsnvarchar40
57T5NDKHR-NL: Gebeurtenissentabel SAP HR Pension Funds Netherlands2KASSEPensioenfondsnvarchar40
58T5NE3Standentabel (VK-rapport)4KASSEPensioenfondsnvarchar40
59T5NE6Berekeningsmethode (VK-rapport)4KASSEPensioenfondsnvarchar40
60T5NE9Account (VK rapport)4KASSEPensioenfondsnvarchar40
61T5NEAAccount (VK rapport)4KASSEPensioenfondsnvarchar40
62T5NF1PA-PF-NL: Pensionsprodukte2KASSEPensioenfondsnvarchar40
63T5NF2PA-PF-NL: Pensionsprodukttexte3KASSEPensioenfondsnvarchar40
64T5NF4HR-PF: Kaderteksten voor infotype 02793KASSEPensioenfondsnvarchar40
65T5NH4Bepaling van het parametergebied voor de werkgever5KASSEPensioenfondsnvarchar40
66T5NP0Vastleggen van de relatie tussen werkgever en het fonds5KASSEPensioenfondsnvarchar40
67T5NP1Vastleggen van de relatie tussen werkgever en het product5KASSEPensioenfondsnvarchar40
68T5NP2Vastleggen van relatie tussen wg, fonds en parameter gebied5KASSEPensioenfondsnvarchar40
TOPPension Fund Switzerland
69PA3230Personnel Master Record for Infotype 323024KASSEPension fundnvarchar40
70T5CD2Mapping Infotype 3230 Value Type by DTA Update Value Type2KASSEPension fundnvarchar40
71T5CD3House Bank Pension Fund for Non-Recurring Payments2KASSEPension fundnvarchar40
72T5CD4Pension Fund Data for WEF File2KASSEPension fundnvarchar40
TOPSwitzerland
73T5C17Texts for Pension Funds3KASSEPension fundnvarchar20
74T5C18Pension Funds - Insurance Types2KASSEPension fundnvarchar20
75T5C1CPension funds2KASSEPension fundnvarchar20
76T5C1DTexts for Pension Funds3KASSEPension fundnvarchar20