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

27 columns | Print definition?ERP 6.0  | SCHID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1P2IE_PENSPension Funds (IE)7SCHIDScheme Identification Numbernvarchar30
2P2RU_GRDOCPayroll Results: Garnishment for US Document20SCHIDSeparate check indicatornvarchar10
3T5GPBS1CLASS CPX Pension Scheme Cross Reference5SCHIDCLASS CPX INTERFACE Scheme Idnvarchar30
4T5GPBSP_PSCHLocal Government Pension Schemes2SCHIDPension schemenvarchar30
5T5GPBST_PENTPS Primary and Additional pension schemes2SCHIDPension schemenvarchar30
6T5GPBS_USSAbsence Evaluation: Scheme Switches2SCHIDPension schemenvarchar30
7T5G_ERPENCUMEmployer's Pensionable Pay options3SCHIDPension schemenvarchar30
TOPB2A Business to Administration
8T50G_XMLXML-Global Schema7SCHIDXML-Schema Identificationnvarchar50
TOPGeneral Parts
9T74_FBN_GB04Flexible Benefits Plan GB Pension Attribute6SCHIDPension schemenvarchar30
TOPGreat Britain
10T5G30Pension Schemes2SCHIDPension schemenvarchar30
11T5G31Pension Contribution Calculation Rules2SCHIDPension schemenvarchar30
12T5G32Pension Holidays2SCHIDPension schemenvarchar30
13T5G37Pension Scheme Types2SCHIDPension schemenvarchar30
14T5G3TPension Scheme Names3SCHIDPension schemenvarchar30
15T5G_ERPENAbsence Valuation5SCHIDPension schemenvarchar30
TOPIreland
16PA0361HR Master Record : Infotype 0361 (Pensions Admin. - IE)24SCHIDScheme Identification Numbernvarchar30
17T7IEPPension schemes Ireland2SCHIDScheme Identification Numbernvarchar30
TOPProduction Planning
18TCPFS1Organization of data adjustment for external planning tool3SCHIDPlanning toolnvarchar100
19TCPFS3External planning tool: lock table3SCHIDPlanning toolnvarchar100
20TCPFS4External planning tool2SCHIDPlanning toolnvarchar100
21TCPFS4TPlanning tool description3SCHIDPlanning toolnvarchar100
22TCPFS5External planning tool: start parameters for Windows NT3SCHIDPlanning toolnvarchar100
TOPUnited Kingdom
23T5GASHE1ASHE Pension Type2SCHIDPension schemenvarchar30
24T5GPBSP_PROLGPS Protected Contribution Rates2SCHIDPension schemenvarchar30
25T5GPBSP_SCHGBLGP: Pension Schemes2SCHIDPension schemenvarchar30
26T5GPBSP_UNPLGPS Unprotected Contribution Rates2SCHIDPension schemenvarchar30
TOPUSA
27PA0194HR Master Record Infotype 0194 (Garnishment Document)29SCHIDSeparate check indicatornvarchar10