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  | NUMBR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1P2RG_MSAMaternity and Sickness Absences (GB)10NUMBRHR payroll: Numberdecimal152
2P2RR_RMPayroll Results: Table for Master data (SG)56NUMBRQuota Number Compensateddecimal105
3PA0294HR Naster Record Infotype 0294 - reserved !24NUMBRNumbernvarchar50
4T7RUPACKERRPFR error BCDATA6NUMBRNumbernvarchar50
5T7RUSENDescription of length of service (CIS)3NUMBRNumbernvarchar50
6T7RUSENTText table for T7RUSEN3NUMBRNumbernvarchar50
TOPAdvertising Management
7JHAGAPMIS-M/AM: Messages Log for Sales Agent Determination5NUMBRCounter used to differentiate between data base entriesnvarchar40
TOPAustralia
8PA0701HR Terminations Data Container : Infotype 070169NUMBRQuota Number Compensateddecimal105
TOPBank Accounting
9TFPM042FVPayment medium formats: Note to payee fields5NUMBRNumber of Fields for Reference Informationnvarchar40
TOPConsumption-Based Planning See Also PP-MRP
10MDRDDelivery Relationships: Recipients per Plant and Material14NUMBRnvarchar50
11MDRD_EXTWGDelivery Relationships: Recipients per Plant and Material14NUMBRnvarchar50
12WDRDDelivery Relationships: Recipients per Plant and Material26NUMBRnvarchar50
13WDRD_EXTWGDelivery Relationships: Recipients per Plant and Material26NUMBRnvarchar50
TOPContract Accounts Receivable and Payable
14TFK042FXText Fields for Reference Details (Note to Payee)6NUMBRNumber of Lines for Reference Information (Note to Payee)nvarchar30
TOPCross-Application Components
15J_2GLPDOCSFIFI legal documents16NUMBRCounter ( the last number used )nvarchar90
16J_2GLPLEGDOCLegal printed documents18NUMBRCounter ( the last number used )nvarchar90
TOPData Collection
17T242XSAP-EIS: Data Transfer: Origin Parameters5NUMBRNumber of logs per sender program and transfer methodnvarchar20
18TKCCCEIS: Currency translation with data entry / planning6NUMBRNumber of translation key in currency translationnvarchar30
TOPData Transfer
19T241QText table for currency translation type4NUMBRNumber of translation key in currency translationnvarchar30
20T242QCurrency translation type3NUMBRNumber of translation key in currency translationnvarchar30
TOPDirect Bank Communication
21LWM_D_USER_BADGEPayment Approval App - User number of batches for the badge4NUMBRint100
TOPIndia
22T7INC5Perk value of car8NUMBRNumber field - Store HP or CC of carnvarchar50
TOPIntegrated Product and Process Engineering
23CMIG_MAPPINGMapping Table (Classic PP and iPPE Objekt Key)2NUMBRNumber for Migration Tablesnvarchar120
24CMIG_STATUSStatus Table (iPPE Migration)2NUMBRNumber for Migration Tablesnvarchar120
TOPNew Zealand
25PT0416Time Quota Compensation Infotype: Database Table29NUMBRQuota Number Compensateddecimal105
TOPPersonnel Time Management
26PA0416Time Quota Compensation Infotype: Database Table29NUMBRQuota Number Compensateddecimal105
TOPProfitability Analysis
27CEFORMSTable for description of structures12NUMBRNumber of translation key in currency translationnvarchar30
TOPReporting
28P05TPRNL_EE_IRIPension Return: Income Relationship Indicators13NUMBRHR payroll: Numberdecimal152
29P05TPRNL_EE_PRPIPension Return: Income Rel - Pens/Ins Rel Period Indic PL17NUMBRHR payroll: Numberdecimal152
30P05TPRNL_LP_COLLPension Return: Collective Return - Legal Pers Level13NUMBRHR payroll: Numberdecimal152