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

78 columns | Print definition?ERP 6.0  | SCALE_ID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/1CN/LBPSCALEDEFScale Table - Fixed Part of a Scale2SCALE_IDScale IDvarbinary160
2/1CN/LBPSCALEDIMScale Table - Scale Dimensions4SCALE_IDScale IDvarbinary160
3/1CN/LBPSCB__LINScale Table - Variable Part of a Scale2SCALE_IDScale IDvarbinary160
4/1CN/LBPSCC__LINScale Table - Variable Part of a Scale2SCALE_IDScale IDvarbinary160
5/1CN/LBPSCD__LINScale Table - Variable Part of a Scale2SCALE_IDScale IDvarbinary160
6/1CN/LBPSCE__LINScale Table - Variable Part of a Scale2SCALE_IDScale IDvarbinary160
7/1CN/LBPSCF__LINScale Table - Variable Part of a Scale2SCALE_IDScale IDvarbinary160
8/1CN/LBPSCL__LINScale Table - Variable Part of a Scale2SCALE_IDScale IDvarbinary160
9/1CN/LBPSCM__LINScale Table - Variable Part of a Scale2SCALE_IDScale IDvarbinary160
10/1CN/LBPSCN__LINScale Table - Variable Part of a Scale2SCALE_IDScale IDvarbinary160
11/1CN/LBPSCO__LINScale Table - Variable Part of a Scale2SCALE_IDScale IDvarbinary160
12/1CN/LBPSCP__LINScale Table - Variable Part of a Scale2SCALE_IDScale IDvarbinary160
13/1CN/LBPSCR__LINScale Table - Variable Part of a Scale2SCALE_IDScale IDvarbinary160
14/1CN/LBPSCS__LINScale Table - Variable Part of a Scale2SCALE_IDScale IDvarbinary160
15/1CN/LBPSCTC1LINScale Table - Variable Part of a Scale2SCALE_IDScale IDvarbinary160
16/1CN/LPNSCALEDEFScale Table - Fixed Part of a Scale2SCALE_IDScale IDvarbinary160
17/1CN/LPNSCALEDIMScale Table - Scale Dimensions4SCALE_IDScale IDvarbinary160
18/1CN/LPNSCA__LINScale Table - Variable Part of a Scale2SCALE_IDScale IDvarbinary160
19/1CN/LPTSCALEDEFScale Table - Fixed Part of a Scale2SCALE_IDScale IDvarbinary160
20/1CN/LPTSCALEDIMScale Table - Scale Dimensions4SCALE_IDScale IDvarbinary160
21/1CN/LPTSCB__LINScale Table - Variable Part of a Scale2SCALE_IDScale IDvarbinary160
22/1CN/LPTSCC__LINScale Table - Variable Part of a Scale2SCALE_IDScale IDvarbinary160
23/1CN/LPTSCD__LINScale Table - Variable Part of a Scale2SCALE_IDScale IDvarbinary160
24/1CN/LPTSCE__LINScale Table - Variable Part of a Scale2SCALE_IDScale IDvarbinary160
25/1CN/LPTSCF__LINScale Table - Variable Part of a Scale2SCALE_IDScale IDvarbinary160
26/1CN/LPTSCL__LINScale Table - Variable Part of a Scale2SCALE_IDScale IDvarbinary160
27/1CN/LPTSCM__LINScale Table - Variable Part of a Scale2SCALE_IDScale IDvarbinary160
28/1CN/LPTSCN__LINScale Table - Variable Part of a Scale2SCALE_IDScale IDvarbinary160
29/1CN/LPTSCO__LINScale Table - Variable Part of a Scale2SCALE_IDScale IDvarbinary160
30/1CN/LPTSCP__LINScale Table - Variable Part of a Scale2SCALE_IDScale IDvarbinary160
31/1CN/LPTSCR__LINScale Table - Variable Part of a Scale2SCALE_IDScale IDvarbinary160
32/1CN/LPTSCS__LINScale Table - Variable Part of a Scale2SCALE_IDScale IDvarbinary160
33/1CN/LPTSCTC1LINScale Table - Variable Part of a Scale2SCALE_IDScale IDvarbinary160
34/1CN/LRMSCALEDEFScale Table - Fixed Part of a Scale2SCALE_IDScale IDvarbinary160
35/1CN/LRMSCALEDIMScale Table - Scale Dimensions4SCALE_IDScale IDvarbinary160
36/1CN/LRMSCA__LINScale Table - Variable Part of a Scale2SCALE_IDScale IDvarbinary160
37/1CN/LTXSCALEDEFScale Table - Fixed Part of a Scale2SCALE_IDScale IDvarbinary160
38/1CN/LTXSCALEDIMScale Table - Scale Dimensions4SCALE_IDScale IDvarbinary160
39/1CN/LTXSCB__LINScale Table - Variable Part of a Scale2SCALE_IDScale IDvarbinary160
40/1CN/LTXSCC__LINScale Table - Variable Part of a Scale2SCALE_IDScale IDvarbinary160
41/1CN/LTXSCD__LINScale Table - Variable Part of a Scale2SCALE_IDScale IDvarbinary160
42/1CN/LTXSCE__LINScale Table - Variable Part of a Scale2SCALE_IDScale IDvarbinary160
43/1CN/LTXSCF__LINScale Table - Variable Part of a Scale2SCALE_IDScale IDvarbinary160
44/1CN/LTXSCL__LINScale Table - Variable Part of a Scale2SCALE_IDScale IDvarbinary160
45/1CN/LTXSCM__LINScale Table - Variable Part of a Scale2SCALE_IDScale IDvarbinary160
46/1CN/LTXSCN__LINScale Table - Variable Part of a Scale2SCALE_IDScale IDvarbinary160
47/1CN/LTXSCO__LINScale Table - Variable Part of a Scale2SCALE_IDScale IDvarbinary160
48/1CN/LTXSCP__LINScale Table - Variable Part of a Scale2SCALE_IDScale IDvarbinary160
49/1CN/LTXSCR__LINScale Table - Variable Part of a Scale2SCALE_IDScale IDvarbinary160
50/1CN/LTXSCS__LINScale Table - Variable Part of a Scale2SCALE_IDScale IDvarbinary160
51/1CN/LTXSCTC1LINScale Table - Variable Part of a Scale2SCALE_IDScale IDvarbinary160
52/NAKISA/CRITERIAMaintain Criteria / Scale ID for RFC2SCALE_IDAppraisal Element IDnvarchar80
53/NAKISA/HRP9808DB Table for Infotype 980821SCALE_IDNumc 8nvarchar80
54/NAKISA/HRP9809DB Table for Infotype 980922SCALE_IDNumc 8nvarchar80
55/NAKISA/HRT9821Table Part Infotype 98215SCALE_IDScale IDnvarchar80
56/NAKISA/TM_SCALENakisa Talent Management Scale IDs3SCALE_IDScale IDnvarchar80
57T5UPBSTC41Assign Classifications to Qualification Groups5SCALE_IDScale IDnvarchar80
TOPAppraisal Systems
58HRP1044DB Table for Infotype 104418SCALE_IDScale IDnvarchar80
TOPConsumer Products for Food Beverage
59CFB_SCALEDefine Scale Control2SCALE_IDScale IDnvarchar30
60CFB_SCALE_ASSIGNAssign Scale Groups3SCALE_IDScale IDnvarchar30
61CFB_WEIGH_LISTDatabase of Weigh List6SCALE_IDScale IDnvarchar30
TOPE-Recruiting
62T77RCF_SCALESScales for Ranking and Weighting3SCALE_IDScale IDnvarchar80
TOPMaintenance Orders
63/MRSS/D_SQM_MHQualification Matrix5SCALE_IDScale IDnvarchar80
TOPPerformance Assessment Workbench
64SLS_QLOGPAW - Qualification Generation Log24SCALE_IDPAW - Qualification Scale IDnvarchar80
65SLS_TTYQUPAW - Test Type Qualifications8SCALE_IDPAW - Qualification Scale IDnvarchar80
TOPQualifications and Requirements
66T77SKHR-PD: Scales2SCALE_IDScale IDnvarchar80
67T77SNHR-PD: Quantity Scale Proficiencies2SCALE_IDScale IDnvarchar80
68T77SPHR-PD: Quality Scale Proficiencies2SCALE_IDScale IDnvarchar80
69T77SP_DESCRPA-PD: Proficiency Descriptions for a Quality Scale2SCALE_IDScale IDnvarchar80
70T77SP_DESCRIPTPA-PD: Proficiency Descriptions for a Quality Scale (Text)3SCALE_IDScale IDnvarchar80
71T77TNHR-PD: Proficiency Texts for Quantity Scale3SCALE_IDScale IDnvarchar80
72T77TPHR-PD: Proficiency Texts for Quality Scale3SCALE_IDScale IDnvarchar80
73T77TSHR-PD: Scale Names3SCALE_IDScale IDnvarchar80
TOPSouth Africa
74T5W8IAppraisal template - Object attributes4SCALE_IDScale IDnvarchar80
TOPTalent Management
75HRP7408Potential21SCALE_IDScale IDnvarchar80
76HRP7409Performance22SCALE_IDScale IDnvarchar80
77T77TMC_SCA_MAPScale Mapping2SCALE_IDScale IDnvarchar80
78T77TM_JF_LEVELTalent Management: Job Family Level Maintenance4SCALE_IDScale IDnvarchar80