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

70 columns | Print definition?ERP 6.0  | GRADE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/MRSS/C_RM_NNRESAssignment for MRS Resource4GRADEGradenvarchar80
2/ORS/APPRLIMITApproval Limit based on Grade Range, Expense Type and CC3GRADEAuthorization Grade Level or Rangenvarchar80
3/SLOAP/PRICING_1Conditions (1-Dimensional Quantity Scale)10GRADEScales are maintainednvarchar10
4HRP1643DB Table for Infotype 164327GRADEJob Rank/Gradenvarchar20
5HRP1650DB-Tabelle zum Infotyp 165019GRADEGradenvarchar40
6HRP5221DB Table for Infotype 522124GRADEGradenvarchar80
7P2RF_FPWPPC2LF9GRADEnvarchar40
8PA0431HR Master Record, Infotype 0431 / View 0008 PSF25GRADEnvarchar40
9PA0576HR Master Record Infotype 057626GRADEnvarchar40
10PA0616HR Master Record: Infotype 061648GRADEHESA: Grade structurenvarchar20
11PA0623HR Master Record: Infotype 062332GRADEGrade IDnvarchar80
12PAPBSGB_HESA_CHESA Archive table for NISR Contract table18GRADEHESA: Grade structurenvarchar20
13PB0623HR Master Record: Infotype 062332GRADEGrade IDnvarchar80
14PIQDB_DE_OTHGRDGraduation from other programs of study13GRADETotal Gradenvarchar30
15PIQDB_DE_REPGRDGraduation in the reporting semester20GRADETotal Gradenvarchar30
16T5FPBS4EAffectation échelle, grade6GRADEGradenvarchar40
17T5FPBS4GGrade3GRADEGradenvarchar40
18T5FPBS4GTLibellé des grades4GRADEGradenvarchar40
19T5FPBS5QAssignation d'une étape à un processus de promotion3GRADEGrade ciblenvarchar40
20T5FPBSA2Grades3GRADECode grade dans l'ordrenvarchar40
21T5FPBSA2TGrade texts4GRADECode grade dans l'ordrenvarchar40
22T5GPBSH_GRAHESA: Grade structure2GRADEHESA: Grade structurenvarchar20
23T5GPBSH_GRATHESA: Grade structure (text)3GRADEHESA: Grade structurenvarchar20
24T5K13Jobs6GRADEWage group (Job Classification)nvarchar80
25T7AEPBS02Rank/Grade3GRADEGradenvarchar80
26T7AEPBS02TRank/Grade Text4GRADEGradenvarchar80
27T7AEPBS06Job Classification7GRADEGradenvarchar80
28T7AEPBS20Job Speciality Rule8GRADEGradenvarchar80
29T7AEPBS56Job classification based education details for UAE PBS10GRADEGradenvarchar80
30T7SAPBS02Rank/Grade3GRADEJob Rank/Gradenvarchar20
31T7SAPBS02TRank/Grade Text4GRADEJob Rank/Gradenvarchar20
32T7SAPBS06Job Classification6GRADEJob Rank/Gradenvarchar20
33T7SAPBS20Job Speciality Rule8GRADEJob Rank/Gradenvarchar20
34T7SAPBS20RJob Speciality Rule10GRADEJob Rank/Gradenvarchar20
35T7SAPBS34Assign Pay Scale to Job Classification6GRADEJob Rank/Gradenvarchar20
36T7SAPBS65Job Relational Education6GRADEJob Rank/Gradenvarchar20
37T7SAPBS71Job Classification (Customer)6GRADEJob Rank/Grade (Customer)nvarchar20
38T7SAPBS72Rank/Grade (Customer)3GRADEJob Rank/Grade (Customer)nvarchar20
39T7SAPBS72TRank/Grade Text (Customer)4GRADEJob Rank/Grade (Customer)nvarchar20
40T7SAPBSM1Minimum Service Duration for KSA Military Sector10GRADEPromotions: Education Gradenvarchar20
41T7SAPBSM6Minimum Service Duration for KSA Military Sector8GRADEPromotions: Education Gradenvarchar20
42T7UNPF_FI_ADDETAdditional Details8GRADESalary Gradetinyint30
43T7UNPF_FI_TRANSAdditional Details8GRADESalary Gradetinyint30
44T7UNPF_HR_CATMMapping table for Pay scale type to Salary Category9GRADESalary Gradetinyint30
45T7UNPF_HR_SALSalary details8GRADESalary Gradetinyint30
46HRP1776DB Table for Infotype 177622GRADEObsoletedecimal82
47HRT1776Table Section for IT 17767GRADEStd Value for Scale Valuedecimal82
48PIQDBAGR_GENDB Table for Appraisals4GRADEStd Value for Scale Valuedecimal82
49PIQDBAPPR_AUD1Audit: Result Folder for Sub(Requirement)5GRADEStd Value for Scale Valuedecimal82
50PIQDBAPPR_AUD3(Sub)Requirement: Applicable Academic Work11GRADEStd Value for Scale Valuedecimal82
51PIQDBAPPR_AUD5Audit: Result Folder for Calculation5GRADEStd Value for Scale Valuedecimal82
52PIQDBPI_PINDEXPerformance Indexes21GRADEStd Value for Scale Valuedecimal82
53PIQPROC_ED_INT_WED Activity Document: Transferred Internal Academic Work8GRADEStd Value for Scale Valuedecimal82
54PIQPROC_PG_LIActivity Document: Academic Performance Index6GRADEStd Value for Scale Valuedecimal82
55PIQPROC_PG_MBActivity Document: Module Booking43GRADEStd Value for Scale Valuedecimal82
56T7PIQ_GB_POINTSUCAS: Points Score for Entry to Higher Education3GRADEOriginal Gradenvarchar100
TOPBusiness Partner
57BP1012Ratings9GRADERatingnvarchar100
58BPCC_MIGCS_MAPAssignment of Rating Procedure/Rating to Institution/Rating5GRADERatingnvarchar100
59TPZ22Business Partner: Ratings3GRADERatingnvarchar100
60TPZ22TBusiness Partner: Description of Ratings3GRADERatingnvarchar100
TOPBusiness Planning and Simulation
61UPX_KPI_EVALBUFKPI Valuation for Alert: Result Buffer5GRADEResult of KPI Valuation: Ratingnvarchar10
TOPCollections Management
62UDM_WL_ITEMWorklist Item59GRADEExternal Valuationnvarchar100
TOPE-Recruiting
63HRP5104DB Table for Infotype 510428GRADEFinal Gradenvarchar40
TOPJapan
64T5JLGPremium amount for employment insurance1GRADEGrade for employment insurancenvarchar20
TOPKorea
65PA0544HR Master Record: Infotype 054426GRADEGradenvarchar40
66T7KR29SI grade table3GRADEGradenvarchar40
TOPNon Profit Organizations
67T7UNPAD_CEBGRDEG CCAQ Staff Grade Mapping table6GRADECCAQ Staff Gradenvarchar40
TOPReuse Services for Country Development
68PA0861HR Master Record: Infotype 086134GRADEnvarchar40
TOPTalent Management
69HRP7404Education28GRADEGradenvarchar40
TOPUSA
70T5U13Jobs6GRADEWage group (Job Classification)nvarchar80