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

30 columns | Print definition?ERP 6.0  | ACCTY

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1P2RB_PKPension Fund, Payroll Belgium10ACCTYPF: Account typenvarchar20
2P2RC_PKHR-CH: Pension fund payroll values10ACCTYPF: Account typenvarchar20
3P2RN_PKPayroll Result: Pension Module10ACCTYPF: Account typenvarchar20
4P2UN_PKPension Fund, Payroll United Nations10ACCTYPF: Account typenvarchar20
5PA0717HR Master Record: Infotype 071725ACCTYBenefit point account typenvarchar40
6T74_BPS01Benefit point account type3ACCTYBenefit point account typenvarchar40
7T74_BPS01TBenefit point account type text4ACCTYBenefit point account typenvarchar40
8T74_BPS02Benefit point account attributes entity4ACCTYBenefit point account typenvarchar40
9T74_BPS07Benefit request type6ACCTYBenefit point account typenvarchar40
TOPCompany Pension Scheme Germany
10T5DVOAvailability of Conversion Models5ACCTYType of Availabilitynvarchar10
TOPDenmark
11T5M6AAssignment of Leave Types to Wage Types3ACCTYRelationship Typenvarchar10
TOPLocalization
12IDCNFSPOSChina Golden Audit Interface: Extension to FS Version4ACCTYGolden Audit Interface China: Account Typenvarchar200
TOPNew Zealand
13T7NZLRLeave Rule Table - NZ11ACCTYAccrual Units Typenvarchar10
TOPPension fund General Parts
14T5CPAHR-CH: Determination of Wage Types for PF Value Types7ACCTYPF: Account typenvarchar20
15T5CPKHR-CH: PF account index7ACCTYPF: Account typenvarchar20
16T5CQ2Account View Arrangement3ACCTYPF: Account typenvarchar20
17T72A0HR-PF: Account Types2ACCTYPF: Account typenvarchar20
18T72A0THR-PF: Description of Account Types3ACCTYPF: Account typenvarchar20
19T72A1HR-PF: Account Types per Fund3ACCTYPF: Account typenvarchar20
20T72P0HR-PF: Determination of Payroll Values for PF Value Types11ACCTYPF: Account typenvarchar20
TOPPension fund Netherlands
21T5NDIHR-NL: Eigenschappen van gebeurtenissen10ACCTYPF: rekeningsoortnvarchar20
TOPSAP Healthcare - Industry-Specific Components for Hospitals
22NSRVPProvisional Services in Service-Based Appointment Search7ACCTYAccess Type for Service-Based Appointment Searchnvarchar80
23TNACCTYAccess Types for Service-Based Appointment Search3ACCTYAccess Type for Service-Based Appointment Searchnvarchar80
24TNACCTYTAccess Types for Service-Based Appointment Search (Texts)4ACCTYAccess Type for Service-Based Appointment Searchnvarchar80
25TNBP_ACCTYAssignment of Access Types to Business Partners5ACCTYAccess Type for Service-Based Appointment Searchnvarchar80
TOPSouth Africa
26T5W1KPension Funds and Medical Aid Schemes (RSA)24ACCTYAccount typenvarchar10
27T5W1MSocial insurance companies14ACCTYAccount typenvarchar10
TOPTaiwan
28T7TW3DRetirement Pay Method13ACCTYAccumulation or notnvarchar10
29T7TW3FSeverance Pay Method13ACCTYAccumulation or notnvarchar10
30T7TW3HResignation Pay Method13ACCTYAccumulation or notnvarchar10