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

52 columns | Print definition?ERP 6.0  | REGEL

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1T157RDisplay Rule for Availability Block4REGELRules for display of goods movementsnvarchar30
2T5D1VSI Processing Routines4REGELRule Number (SI)nvarchar30
3T5D1XSupplementary Pension (D) Percentage Rates4REGELRule Number (SI)nvarchar30
4T5M3O!Not Used: OSI Bank Transfer Information5REGELRule numbernvarchar20
5T77KZD1Group of deductions4REGELRule for Limitsnvarchar40
6T77KZD3Limit Rules2REGELRule for Limitsnvarchar40
7T7RUFBFlexible Employee Data (Contants)9REGELRule for printing formnvarchar20
8TKA3AAutomatic account assignment - default assignments7REGELMandatory fields for detailed account assignmentsnvarchar10
TOPBasic Functions
9MMPREF_PRO_01Logging table for archiving object MMPREF8REGELNormal preference determination rulenvarchar30
10MMPREF_PRO_01_BLog table - Preference - Information from rules7REGELNormal preference determination rulenvarchar30
11MMPREK_PRO_01Log table for archiving object MMPREK11REGELNormal preference determination rulenvarchar30
12MMPREK_PRO_01_BLog table - Preference - Info from rule10REGELNormal preference determination rulenvarchar30
13MMPREW_PRO_01Log table for archiving object MMPREW12REGELNormal preference determination rulenvarchar30
14MMPREW_PRO_01_BPreference CPG: Log - Information from rule9REGELNormal preference determination rulenvarchar30
15T604RPreference: Preference Rule / Percentages2REGELNormal preference determination rulenvarchar30
16TVGRPFGroup Referencing Requirement: Fields6REGELReferencing requirement: Copy rulenvarchar10
17TVRGRule table for indirect date determination for contracts2REGELRule for indirect date determinationnvarchar20
18TVRGTRules for Indirect Date Determination: Descriptions3REGELRule for indirect date determinationnvarchar20
TOPContract Accounts Receivable and Payable
19TFK009Definition of Report Time / Type of Sales / Purchase Taxes9REGELSet Of Rules For Addtl Data In Sales/Purchase Tax Reportnvarchar20
20TFK009SDefinition of Report Time / Type for Other Taxes9REGELSet Of Rules For Addtl Data In Sales/Purchase Tax Reportnvarchar20
21TFK009_REVDefinition of Report Time / Type of Sales / Purchase Taxes10REGELSet Of Rules For Addtl Data In Sales/Purchase Tax Reportnvarchar20
22TFK010Interprtn of Set of Rules for Sales/Purchase Tax Recording2REGELSet Of Rules For Addtl Data In Sales/Purchase Tax Reportnvarchar20
23TFK010TText Table for Set of Rules for Sales/Purchase Tax Recording3REGELSet Of Rules For Addtl Data In Sales/Purchase Tax Reportnvarchar20
24TFK011Definition of Report Time / Type for Other Taxes9REGELSet Of Rules For Addtl Data In Sales/Purchase Tax Reportnvarchar20
TOPGermany
25T5D1SGross SI4REGELRule Number (SI)nvarchar30
TOPHoliday Calendar, Factory Calendar, Appointment Calendar
26THOLPublic Holidays2REGELHoliday rulenvarchar10
TOPLocal Currency Changeover
27EWUCUPAKETContains the individual packages for user-defined objects16REGELName of a form routinenvarchar300
TOPPatient Accounting
28NTFIIS-H: Service Catalog Determination Rules13REGELIS-H: name of an additional decision rulenvarchar50
29TN23RIS-H: Rule Table for BDT Format3REGELRule Number BDT Formatnvarchar30
30TN29IS-H: Procedure for Calculating Estimated Bill5REGELIS-H: Rule for estimated invoicenvarchar100
31TN29RIS-H: Assign FMs -> Estimation Procedure Rules3REGELIS-H: Rule for estimated invoicenvarchar100
32TN29R1IS-H: Customer default for asgmt of FMs to EstimProc. rules1REGELIS-H: Rule for estimated invoicenvarchar100
33TN29TIS-H: Text table for TN29R4REGELIS-H: Rule for estimated invoicenvarchar100
34TNFPSEIS-H: Rule Table for FRs Per Case and PSs3REGELIS-H: Rule Numbernvarchar80
35TNFPSE_NDXIS-H: Index on ICPM of Table TNFPSE4REGELIS-H: Rule Numbernvarchar80
TOPPayroll
36T7UAD0Group of deductions4REGELRule for Limitsnvarchar40
37T7UAD3Limit Rules2REGELRule for Limitsnvarchar40
TOPPayroll General Parts
38PA0165HR Master Record: Infotype 0165 (Limits Deductions)27REGELRule for Limitsnvarchar40
39T512DLine Layout in Window10REGELRule for printing formnvarchar20
40T512EForm-Related Control of Wage Types15REGELRule for printing formnvarchar20
41T512NRule Table for Form4REGELForm rulenvarchar20
42T512QInformation in Fixed Positions11REGELRule for printing formnvarchar20
43T51D1Limits for Deductions10REGELRule for Limitsnvarchar40
44T51D4Limit Rules3REGELRule for Limitsnvarchar40
45T530BPayment Condition (Special Payments)18REGELSpecial conditions T530Bnvarchar20
TOPPersonnel Administration
46T5H6HGarnishment rule2REGELGarnishment rulenvarchar40
TOPPersonnel Time Management
47T550ADaily Work Schedule8REGELDaily work schedule selection rulenvarchar20
48T550XDaily Work Schedule Selection Rules3REGELDaily work schedule selection rulenvarchar20
TOPRussia
49T7RUD1Group of deductions4REGELRule for Limitsnvarchar40
50T7RUD3Limit Rules2REGELRule for Limitsnvarchar40
TOPSAP Healthcare - Industry-Specific Components for Hospitals
51NNTFIS-H NL: Service Catalog Determination15REGELIS-H: name of an additional decision rulenvarchar50
TOPSwitzerland
52T5CR0HR-CH: Rules for Determining the Pension Start9REGELSpecial Processing Rule for Determining the Pension Agenvarchar20