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

28 columns | Print definition?ERP 6.0  | PROZT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/NAKISA/THRPROGRProgress type detail information5PROZTWeighting Percentagedecimal52
2GRPC_UPG_HRP1001Backup Data23PROZTWeighting Percentagedecimal52
3P2RX_FUNDAccounting Structure for Funds Management16PROZTWeighting Percentagedecimal52
4ZRP1001Infotype 1001 DB Table23PROZTWeighting Percentagedecimal52
5HRT1752Table Section for Infotype 17525PROZTWeighting Percentagedecimal52
6HRT1759Table Section for Infotype 175911PROZTWeighting Percentagedecimal52
TOPBudget Management
7HRP1502DB Table for Infotype 150228PROZTPercentage for expenditure typedecimal52
8T7PM6_MSGTolerance limits for each expenditure type in payroll3PROZT% Financingnvarchar30
9T7PMGAverage Amounts for Collective Agreements (PSG)13PROZTPercentage for expenditure typedecimal52
10T7PMG_2HR-FPM: Distribution Keys for Default Values4PROZTWeighting Percentagedecimal52
11T7PMNValuation of Absence Types6PROZTWeighting percentagedecimal52
TOPContract Accounts Receivable and Payable
12DFKKDOUBTD_RET_WBuffer: Printout for Ind.Val.Ad - Return Values (User Event)12PROZTPercentage share of value adjustmentnvarchar30
13DFKKDOUBTD_WBuffer: Create Printout for Receivables Adjustment17PROZTPercentage share of value adjustmentnvarchar30
14DFKKZWDoubtful/Individual Val. Adjust. for Receivables - Trigger14PROZTPercentage share of value adjustmentnvarchar30
15DFKKZW2Doubtful/Indiv. Val. Adjustments for Receivables - Tfr Pstg15PROZTPercentage share of value adjustmentnvarchar30
16DFKKZWFHDoubtful/Individually Adjusted Receivables: History16PROZTPercentage share of value adjustmentnvarchar30
17DFKKZWFPDoubtful/Individually Adjusted Receivables: Tfrd Receivables19PROZTPercentage share of value adjustmentnvarchar30
18DFKKZWFTDoubtful/Individually Adjusted Receivables: Trigger Table15PROZTPercentage share of value adjustmentnvarchar30
19DFKKZWHDoubtful/Ind.Val.Adj.Receivables - History14PROZTPercentage share of value adjustmentnvarchar30
20TFK048ABDefine Percentage Rates for Write-Off Reasons (CZ, SK)4PROZTPercentage Part of Tax-Relevant Write-Offnvarchar30
21TFKZVARValue Adjustment Variants - Definition of Age Grid4PROZTPercentage share of value adjustmentnvarchar30
TOPCross-Application Objects in HR
22HRP5586DB Table for Infotype 558620PROZTWeighting Percentagedecimal52
TOPGermany
23PA0029HR Master Record: Infotype 0029 (Workers' Compensation)26PROZTPercentage for a Workers' Compensation Associationdecimal52
TOPOrganizational Management
24HRP1001Infotype 1001 DB Table23PROZTWeighting Percentagedecimal52
25HRP1001_ARCHInfotype 1001: Inverse Relationship After Archiving23PROZTWeighting Percentagedecimal52
TOPPosition Budgeting and Control
26HRFPM_SP_ASSPERSHRFPM: Assignment Percentages S-P8PROZTWeighting Percentagedecimal52
TOPStaffing
27HRT1018Table Division Infotype 1018 Cost Distribution20PROZTWeighting Percentagedecimal52
TOPWork Center
28CRCAWork Center Capacity Allocation14PROZTPercentage share of available capacitynvarchar30