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

47 columns | Print definition?ERP 6.0  | GRPNR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1PEG_TASS_HIST_DPegging History: Detail5GRPNRGrouping WBS elementnvarchar80
2PEG_TXPT_HISTPegging: intransit stock history5GRPNRGrouping WBS elementnvarchar80
TOPAdvertising Management
3JHTAPIS-M/AM: Settlement Run Log6GRPNRIS-M: Schedule Line Numbernvarchar40
TOPBasic Functions
4FEBEPElectronic Bank Statement Line Items9GRPNRBundle number for grouping line itemsnvarchar20
TOPConditions
5KONDNConditions: Free goods - Data section32GRPNRMaterial groupingnvarchar120
TOPContract Accounts Receivable and Payable
6DFKKMDUGPMaster Data Lot: Items of the Groups of a Lot4GRPNRGroup Number in Master Data Lotnvarchar60
7DFKKMDUGPPMaster Data Lot: Subitems of Group Item4GRPNRGroup Number in Master Data Lotnvarchar60
8FKKBEPElectronic Bank Statement Line Items9GRPNRBundle number for grouping line itemsnvarchar20
TOPFunds Management
9FMLGD_H_CUSTNote to Payee Control13GRPNRFolder Variant for Grouping Postingsnvarchar20
10FMLGD_H_MSGNRMessage Control12GRPNRFolder Variant for Grouping Postingsnvarchar20
TOPHong Kong
11PA0348HR Master Record: Infotype 0348 (HK Appraisal and bonus)27GRPNRAppraisal group numbernvarchar20
12T7HK0PExtension of T001P7GRPNRAppraisal group numbernvarchar20
TOPIncentive and Commission Management ICM
13TCACS_AUT04Commissions: Existing Authorization Groups3GRPNRGroup number for authorization groupsnvarchar40
14TCACS_AUT04TCommissions: Information on Authorization Groups4GRPNRGroup number for authorization groupsnvarchar40
15TCACS_AUT05Commissions: Assignment of Users to Authorization Group4GRPNRGroup number for authorization groupsnvarchar40
16TCACS_AUT08ATable with Quantifying Authorizations for Amount Fields3GRPNRGroup number for authorization groupsnvarchar40
17TCACS_AUT08BTable with Quantifying Authorizations for Volume Fields3GRPNRGroup number for authorization groupsnvarchar40
18TCACS_AUT08CTable with Quantifying Authorizations for Free Fields3GRPNRGroup number for authorization groupsnvarchar40
19TCACS_AUT08DTable with Quantifying Authorizations for Conditions3GRPNRGroup number for authorization groupsnvarchar40
TOPMaterial
20GRPGAAssignment of WBS elements to MRP WBS elements2GRPNRGrouping WBS elementnvarchar80
21GRPGVValidity of grouping WBS elements for plant/MRP group2GRPNRGrouping WBS elementnvarchar80
22PEGOBPeg (master data of the CO object)6GRPNRGrouping WBS elementnvarchar80
TOPPegging, Grouping, and Distribution
23DIS_ADMINDistribution - Administration Table4GRPNRGrouping WBS elementnvarchar80
24DIS_PGPRFDistribution: Assignemnt Distribution Profile - Group WBSEl.2GRPNRGrouping WBS elementnvarchar80
25DIS_TOBJSDistribution: cost objects posted to per group2GRPNRGrouping WBS elementnvarchar80
26DIS_TOBJS_COSPDistribution: Objects distributed to per Group WBS (Cost)2GRPNRGrouping WBS elementnvarchar80
27DIS_TOBJS_COSSDistribution: Objects distributed to per Group WBS (Cost)2GRPNRGrouping WBS elementnvarchar80
28DIS_TOBJS_FMSUDistribution: Objects distributed to per Group WBS (Cash)3GRPNRGrouping WBS elementnvarchar80
29DIS_WLSTDistribution: Worklist of Changed Objects3GRPNRGrouping WBS elementnvarchar80
30PEGEXC_WRK_GRPPegging: Distribution of surplus, scrap, lost, plant & group3GRPNRGrouping WBS elementnvarchar80
31PEG_ADMINPegging - Administration Table4GRPNRGrouping WBS elementnvarchar80
32PEG_DIS_ADMINPegging and Distribution - administration table3GRPNRGrouping WBS elementnvarchar80
33PEG_EXC_GRPNRPegging: Distribution of surplus, scrap, lost - group based2GRPNRGrouping WBS elementnvarchar80
34PEG_GROUPTWERKSPegging: Assignment Group WBS elements to plant3GRPNRGrouping WBS elementnvarchar80
35PEG_LOCKWLSTPegging: Lock Table3GRPNRGrouping WBS elementnvarchar80
36PEG_STOPegging: Record of goods movements w.r.t STO's5GRPNRGrouping WBS elementnvarchar80
37PEG_TACTASSPegging: Current Assignments Based on Goods Movements4GRPNRGrouping WBS elementnvarchar80
38PEG_TASSPegging: Assignment Replenishment Element to WBS Elements4GRPNRGrouping WBS elementnvarchar80
39PEG_TASS_TMPGrp-to-Grp Transf. Pegging: Assign. of Replen to WBS Elems.4GRPNRGrouping WBS elementnvarchar80
40PEG_TCTRLDETPegging: Distribution of Surplus, Scrap, Stock Diff.2GRPNRGrouping WBS elementnvarchar80
41PEG_TSTKPegging: Stock table4GRPNRGrouping WBS elementnvarchar80
42PEG_TSTK_TRANSPegging: Stock transfered without costs (Excess)4GRPNRGrouping WBS elementnvarchar80
43PEG_TXPTPegging: Record of intransit stock in cross plant transfers5GRPNRGrouping WBS elementnvarchar80
TOPPersonnel Administration
44PA0025HR Master Record: Infotype 0025 (Appraisals)28GRPNRGroup number (appraisals)nvarchar20
45T513GAppraisal Groups4GRPNRGroup number (appraisals)nvarchar20
TOPPersonnel Management
46/ERPSOLUT/ERCNTLERP-Solutions eRecruitment controls2GRPNRNumber of Infotype Record with Same Keynvarchar30
47/ERPSOLUT/ERGRPERP Control group for resume mirror2GRPNRNumber of Infotype Record with Same Keynvarchar30