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

91 columns | Print definition?ERP 6.0  | LIMIT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/CEECV/BEFI_VATDVAT Report Estonia - document processed from RFUMSV0029LIMITDocuments under accounting limit per transaction partnernvarchar40
2/OPT/AT_APPR_HISApproval History for Level Based Approvals15LIMITAmount in document currencydecimal132
3/OPT/AT_LBA_LOGApproval History for Level Based Approvals16LIMITAmount in document currencydecimal132
4/ORS/APPRLIMITApproval Limit based on Grade Range, Expense Type and CC6LIMITAmount in local currencydecimal132
5/SAPSRM/D_WF_016Agent to Ad Hoc Process Level Map4LIMITPurchase Document Valuedecimal152
6/SAPSRM/TT_DATATest Data for SRM Test Tool24LIMITSelect Limit Itemnvarchar10
7BBP_PDLIMValue Limit4LIMITOverall Limitdecimal152
8CNV_10020_CFOBJHConcatenated/fragmented objects: Header data5LIMITIntervalnvarchar10
9CNV_10020_CFOBJPConcatenated/fragmented objects: Item data7LIMITInterval limitnvarchar10
10CNV_10020_MSGMessage output control3LIMITUpper limit for number of messagesint100
11DFKKHUREPDSRecording Data for Domestic Sales Hungary32LIMITGeneral Flagnvarchar10
12FISKC_PRTYPESlovakia Product Type7LIMITThreshold Amountdecimal132
13HRP5503DB Table for Info Record 550318LIMITOverall Limitdecimal152
14J_1UF_CUST_RE01Parked Tax Voucher - Reaction Customizing5LIMITLimit of Amount or Quantitydecimal133
15J_1UF_TP_LIMITSLimits for define controllable transactions4LIMITControlled Transaction Amount Limitdecimal172
16J_3RF_TP_CP_SBCLControllable Partners. Data saved in backgroud. BC Limits16LIMITControlled Transaction Amount Limitdecimal212
17J_3RF_TP_CP_SNBLControllable Partners. Data saved in backgroud. NonBC Limits16LIMITControlled Transaction Amount Limitdecimal212
18J_3RF_TP_LIMITSLimits for define controllable transactions14LIMITControlled Transaction Amount Limitdecimal212
19J_3RF_TP_LIMITTYLimit types and descriptions (Obsolete)5LIMITControlled Transaction Amount Limitdecimal212
20P2CN_CNSPPayroll result: Special Payment (CN)14LIMITLimitation for Severance Paynvarchar10
21P2RU_GRORDPayroll Results: Garnishment for US Order17LIMITLimitdecimal92
22REQHEADSTemporary Header Data: Requirement Coverage Request (Limit)5LIMITOverall Limitdecimal234
23REQLINEAdministrative Line Data: Requirement Coverage Request14LIMITOverall Limitdecimal234
24SFICLClass Table for SAPfind4LIMITUpper limit for number of objects in a classint100
25T7QA86Allowance Contribution Rule10LIMITAllowance Contribution Amount Upper Limitdecimal82
26TFICClass Table for SAPfind4LIMITUpper limit for number of objects in a classint100
27TLRC_THM_LIMITLimit Amounts per TIG5LIMITClearing Threshold Valuesdecimal212
TOPAustria
28T5A0PPersonnel Area/Subarea AT9LIMITApply Limitsnvarchar10
TOPBenefits
29T5UBDTo be deleted - no longer used!20LIMITBenefit maximum pre-tax contribution per annumdecimal132
30T5UBIBenefit cost rule11LIMITBenefit insurance cost rule variant limitnvarchar130
31T74FHBenefit employee contribution rule42LIMITBenefit maximum pre-tax contribution per annumdecimal132
TOPBrazil
32T7BRGRSIB table - Self-employed5LIMITScale limitdecimal152
33T7BRISSIB table6LIMITScale limitdecimal152
34T7BRSFChild allowance5LIMITScale limitdecimal152
35T7BRSISIB table5LIMITScale limitdecimal152
36T7BRTAUnion dues6LIMITScale limitdecimal152
37T7BRTXWIT table5LIMITScale limitdecimal152
TOPBusiness Package for Manager Self-Service FI
38FPB_LINE_RULEADMLine Item Monitor: Administration Rules10LIMITTotal Value in Controlling Area Currencydecimal152
39FPB_LINE_RULESLine Item Monitor: Rule Administration11LIMITTotal Value in Controlling Area Currencydecimal152
TOPChina
40PA3212HR Master Record: Infotype 3212 (Special Payment CN)31LIMITLimitation for Severance Paynvarchar10
TOPClaims Management
41ICLCCEVENTClaim Bundle12LIMITClaim Bundle Compensation Reservedecimal172
42ICLPOLLLimit and Deductible in Policy Snapshot13LIMITLimitdecimal152
43ICSCCEVENTShadow Table Claim Bundle12LIMITClaim Bundle Compensation Reservedecimal172
44ICSPOLLLimit and Deductible in Policy Snapshot13LIMITLimitdecimal152
45TICL083Internal Claim Type: Limit and Deductible12LIMITLimitdecimal152
46TICL163Benefit Type Tree: Limit and Deductible11LIMITLimitdecimal152
TOPCompany Pension Scheme Germany
47T5DCDControl Information: Entitlements49LIMITFinal Processing Rulenvarchar40
48T5DWPRules for Final Processing2LIMITFinal Processing Rulenvarchar40
49T5DWPTTexts for Final Processing Rules3LIMITFinal Processing Rulenvarchar40
TOPConsolidation
50TF555Methods for Interunit Elimination14LIMITThreshold value (limit) for posting differencesdecimal172
51TF557Methods: Threshold Value for Posting Differences5LIMITThreshold value (limit) for posting differencesdecimal172
TOPContract Accounts Receivable and Payable
52TFK057FI-CA: Amount Limit Table for Interest Calculation5LIMITAmount Limitdecimal132
53TFKCMCAPCapacity Restriction for Dunning Activities (Customizing)6LIMITUpper Limit without Release Procedureint100
TOPEnvironment, Health and Safety
54/TDAG/CPT_EXEMLICP: Exemption Limits6LIMITExemption Limit (Percent)decimal107
TOPExternal Services
55ESUCExt. Services Management: Unplanned Limits on Contract Item7LIMITOverall Limitdecimal132
56ESUPExt. Services Management: Unpl. Limits on Service Package6LIMITOverall Limitdecimal132
57ESUSServices Management: Unplanned Limits on Service Types7LIMITOverall Limitdecimal132
TOPFinland
58T7FIC0Age groups for company cars (Finland)3LIMITLimited car benefitnvarchar10
TOPGeneral Parts
59T74_FBN_GB05Flexible Benefits Employee Pension Contribution Rule (GB)11LIMITBenefit insurance cost rule variant limitnvarchar130
TOPGermany
60P01Y15PAISY: Management Table Subrecord Type 1545LIMITPAISY: 1561 Total Amount (Limit)decimal92
TOPItaly
61T5ITF3Provision accrual9LIMITRangenvarchar20
62T5ITI9Table to split AB7LIMITInterval limitnvarchar40
63T5ITITSpecial parameters for grace10LIMITLimit value of grace parameternvarchar40
TOPLocalization
64TIVXCPTINSTLIMITInstallment limit for the Municipal Property Tax3LIMITLimit of Installmentdecimal152
TOPOLAP Technology
65RSADMINCCustomizing Table General BW52LIMITDatabase Cache Limitint100
TOPPayroll
66PA0935HR Master Record: Infotype 093526LIMITLimitednvarchar10
67PB0935Applicant data infotype 0935 (model)26LIMITLimitednvarchar10
68T7BGC2Contract types NAP3LIMITLimitednvarchar10
69T7ROE1Configuration of external deductions15LIMITID of limit for external transfersnvarchar40
70T7ROE5Limits for External deductions - Total Limit2LIMITID of limit for external transfersnvarchar40
TOPPayroll General Parts
71T51D3Reduction Rules4LIMITReduction rulenvarchar10
TOPPersonnel Time Management
72T559PLimits for Time Balances9LIMITValue limit for balance limitsdecimal94
73T559UOvertime rules8LIMITNumber of hoursdecimal74
TOPPublic sector Sweden
74T5SAL_CEAbsence Limits7LIMITCalendar daysdecimal62
TOPReal Estate Slovakia
75TIVXCSKVZNLocal regulations: rates, prices, increments19LIMITMinimum Limit of Property Taxdecimal112
TOPRecipe Development
76/PLMB/CCK_DRECompliance Check: Detailed Results12LIMITCompliance Check: Limit for Constraint %decimal126
TOPRemaining Beverage - Obsolete Objects
77/BEV3/CHRGVBVBAgreement / Agreement Rule12LIMITLimit for Rule Listnvarchar40
78/BEV3/CHRGXXXXRule XXXX12LIMITSingle-Character Indicatornvarchar10
TOPSAP Healthcare - Industry-Specific Components for Hospitals
79/ISHFR/TNWFRLVTYIS-H FR: Maximum Limit for Exemptions7LIMITIS-H FR: Upper Limit for Patient Contribution Exemptiondecimal112
80NWCH90Fee-Based Services29LIMITLimitnvarchar100
81TNWCH94LLimitation for Fee Recipient3LIMITLimitnvarchar100
82TNWCH94LCFees: Assignment of Breakdown Code to Limit Level7LIMITLimitnvarchar100
83TNWCH94LDFees: Validity of Limitation3LIMITLimitnvarchar100
84TNWCH94LSFees: Limitation Levels3LIMITLimitnvarchar100
85TNWCH94LTLimitation Texts for Fee Recipient4LIMITLimitnvarchar100
TOPTravel Expenses
86T706B4_ALTERNTravel Expense Type: Alternative Assignment of Wage Types4LIMITIndicator: Other Characteristics For Exceeding Maximum Ratenvarchar10
TOPTreasury
87VTBDFKUDatafeed: Market Data Monitoring3LIMITDatafeed: Rate monitoringtinyint30
88VTB_DFCUDatafeed: Translation Table18LIMITDatafeed: Rate monitoringtinyint30
89VTB_MARKETDatafeed: Market data37LIMITDatafeed: Rate monitoringtinyint30
90VTB_MARKET_TDatafeed: Temporary market data copy for workflow37LIMITDatafeed: Rate monitoringtinyint30
TOPVenezuela
91T7VEPNNotice or seniority days3LIMITNumber of Months Workednvarchar30