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
Personnel Management :: Benefits
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0T5UBA631Benefit planBenefits
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, BAREA, BPLAN, ENDDA, BEGDA, PLTYP, CRENR, PLNNO, PLSTA, RLPVR, COBOK, IMPUT, DEFER, FLXCR, GTLIF, CSTCR, ERNOC, L457S, L403B, EEOWN, TPASV, CMTSV, CPMOD, CPMOH, EQSCH, EQHRS, EQPER, LNCOD, SPARQ, PRDED, DEPYN, BENYN, EEBYN, CTGYN, INVYN, PREYN, PSTYN, CSTYN, CRDYN, COVYN, EECYN, ERCYN, VESYN, BONYN, EEWTY, PTWTY, ERWTY, TBWTY, BEWTY, BPWTY, BRWTY, BTWTY, PRWTY, BSWTY, INWTY, CPWTY, IIWTY, URLPL, PPLAN, ROTHP, HSAPL, COBSR, COBCM FROM T5UBA
ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1MANDTClientnvarchar30 Allow NULL? 
2BAREABenefit areanvarchar20 Allow NULL? 
3BPLANBenefit plannvarchar40 Allow NULL? 
4ENDDAEnd Datenvarchar80 Allow NULL? 
5BEGDAStart Datenvarchar80 Allow NULL? 
6PLTYPBenefit plan typenvarchar40 Allow NULL? 
7CRENRBenefit providernvarchar80 Allow NULL? 
8PLNNOBenefit plan numbernvarchar200 Allow NULL? 
9PLSTABenefit plan statusnvarchar20 Allow NULL? 
10RLPVRBenefit Dependent/Beneficiary Eligibility Rule Variantnvarchar40 Allow NULL? 
11COBOKBenefit indicator COBRA relevancechar10 Allow NULL? 
12IMPUTBenefit indicator imputed income relevantchar10 Allow NULL? 
13DEFERBenefits Indicator Qualified Planchar10 Allow NULL? 
14FLXCRBenefits Indicator: Credits Can Be Usedchar10 Allow NULL? 
15GTLIFBenefits Determination of Imputed Income (Group Term Life)char10 Allow NULL? 
16CSTCRBenefit indicator for plan attribute costs/creditschar10 Allow NULL? 
17ERNOCBenefit employer costs are not credited to the employeechar10 Allow NULL? 
18L457SBenefit Indicator Plan is Savings Plan According to ยง457char10 Allow NULL? 
19L403BBenefit indicator plan is relevant for 403(b) limitchar10 Allow NULL? 
20EEOWNBenefit indicator 403(b) plan belongs to employeechar10 Allow NULL? 
21TPASVBenefit scope of third party administrator (TPA) servicechar10 Allow NULL? 
22CMTSVBenefit Calendar Type for Length of Service Calculationchar10 Allow NULL? 
23CPMODBenefit Compensation Model for Calculating Earningsnvarchar40 Allow NULL? 
24CPMOHBenefit Compensation Model for Calculating Working Hoursnvarchar40 Allow NULL? 
25EQSCHBenefit Indic. Ben. Accrual Hours according to Plnd W. Timechar10 Allow NULL? 
26EQHRSBenefit Number of Benefit Accrual Hoursdecimal152
27EQPERBenefit Reference Period for Benefit Accrual Hoursnvarchar20 Allow NULL? 
28LNCODBenefit insurance line code for IDOC transmissionnvarchar30 Allow NULL? 
29SPARQBenefit indicator spouse's approval requiredchar10 Allow NULL? 
30PRDEDBenefit indicator prededuction from employee leavingchar10 Allow NULL? 
31DEPYNBenefit indicator for relevancy of dependentschar10 Allow NULL? 
32BENYNBenefit Indicator for Relevancy of Beneficiarieschar10 Allow NULL? 
33EEBYNBenefit indicator employee's beneficiary statuschar10 Allow NULL? 
34CTGYNBenefit indicator relevancy of contingency beneficiarychar10 Allow NULL? 
35INVYNBenefit indicator for relevancy of investmentschar10 Allow NULL? 
36PREYNBenefit indicator pre-tax deductions allowedchar10 Allow NULL? 
37PSTYNBenefit indicator post-tax deductions allowedchar10 Allow NULL? 
38CSTYNBenefit indicator for cost rule variant relevancychar10 Allow NULL? 
39CRDYNBenefit indicator for credit rule variant relevancychar10 Allow NULL? 
40COVYNBenefit indicator for coverage rule variant relevancychar10 Allow NULL? 
41EECYNBenefit indicator for relevancy of EE contributionchar10 Allow NULL? 
42ERCYNBenefit indicator for relevancy of ER contributionchar10 Allow NULL? 
43VESYNBenefit indicator for relevancy of vesting rulechar10 Allow NULL? 
44BONYNBenefit indicator plan relevant for bonus paymentschar10 Allow NULL? 
45EEWTYBenefit Wage Type for Pre-Tax Employee Contributionsnvarchar40 Allow NULL? 
46PTWTYBenefit Wage Type for Post-Tax Employee Contributionsnvarchar40 Allow NULL? 
47ERWTYBenefit Wage Type for Employer Contributionnvarchar40 Allow NULL? 
48TBWTYBenefit wage type for technical calculation basenvarchar40 Allow NULL? 
49BEWTYBenefit wage type for bonus employee pre-tax amountnvarchar40 Allow NULL? 
50BPWTYBenefit wage type for employee post-tax bonus contributionnvarchar40 Allow NULL? 
51BRWTYBenefit wage type for employer bonus contributionnvarchar40 Allow NULL? 
52BTWTYBenefit Technical Wage Type for Bonus Paymentnvarchar40 Allow NULL? 
53PRWTYBenefit wage type for payments to providernvarchar40 Allow NULL? 
54BSWTYBenefit wage type for calculation basenvarchar40 Allow NULL? 
55INWTYBenefit wage type for investmentnvarchar40 Allow NULL? 
56CPWTYBenefit Wage Type for Storage of Compensation from Modelnvarchar40 Allow NULL? 
57IIWTYBenefits Wage Type for Imputed Incomenvarchar40 Allow NULL? 
58URLPLBenefit URL ID for Information on Benefits Plannvarchar40 Allow NULL? 
59PPLANTo be deleted - no longer used!nvarchar40 Allow NULL? 
60ROTHPBenefits Indicator Roth Planchar10 Allow NULL? 
61HSAPLBenefits Indicator HSA Planchar10 Allow NULL? 
62COBSRRelevant for COBRA subsidychar10 Allow NULL? 
63COBCMCOBRA indicator for calendar month planschar10 Allow NULL? 
NamePrimaryUniqueTypeColumns
T5UBA~0YesYesCLUSTEREDENDDA, BPLAN, BAREA, MANDT