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

Home | ERP 6.0  | T5UBA
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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

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
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
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 TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2BAREABenefit areanvarchar20CHAR(N' ')NoT5UB3BEN_AREA Allow NULL? 
3BPLANBenefit plannvarchar40CHAR(N' ')NoBEN_PLAN Allow NULL? 
4ENDDAEnd Datenvarchar80DATS(N'00000000')NoENDDA Allow NULL? 
5BEGDAStart Datenvarchar80DATS(N'00000000')NoBEGDA Allow NULL? 
6PLTYPBenefit plan typenvarchar40CHAR(N' ')NoT5UB1BEN_TYPE Allow NULL? 
7CRENRBenefit providernvarchar80NUMC(N'00000000')NoT51RHBEN_PROV Allow NULL? 
8PLNNOBenefit plan numbernvarchar200CHAR(N' ')NoBEN_PLANNO Allow NULL? 
9PLSTABenefit plan statusnvarchar20CHAR(N' ')NoT5UB2BEN_PLSTAT Allow NULL? 
10RLPVRBenefit Dependent/Beneficiary Eligibility Rule Variantnvarchar40CHAR(N' ')NoT74HSBEN_RLPVR Allow NULL? 
11COBOKBenefit indicator COBRA relevancechar10CHAR(N' ')NoBEN_COBRA Allow NULL? 
12IMPUTBenefit indicator imputed income relevantchar10CHAR(N' ')NoBEN_IMPUT Allow NULL? 
13DEFERBenefits Indicator Qualified Planchar10CHAR(N' ')NoBEN_DEFERR Allow NULL? 
14FLXCRBenefits Indicator: Credits Can Be Usedchar10CHAR(N' ')NoBEN_FLXCR Allow NULL? 
15GTLIFBenefits Determination of Imputed Income (Group Term Life)char10NUMC(N'0')NoBEN_GTLIF Allow NULL? 
16CSTCRBenefit indicator for plan attribute costs/creditschar10CHAR(N' ')NoBEN_CSTCR Allow NULL? 
17ERNOCBenefit employer costs are not credited to the employeechar10CHAR(N' ')NoBEN_ERNOC Allow NULL? 
18L457SBenefit Indicator Plan is Savings Plan According to ยง457char10CHAR(N' ')NoBEN_L457S Allow NULL? 
19L403BBenefit indicator plan is relevant for 403(b) limitchar10CHAR(N' ')NoBEN_L403B Allow NULL? 
20EEOWNBenefit indicator 403(b) plan belongs to employeechar10CHAR(N' ')NoBEN_EEOWN Allow NULL? 
21TPASVBenefit scope of third party administrator (TPA) servicechar10CHAR(N' ')NoBEN_TPASV Allow NULL? 
22CMTSVBenefit Calendar Type for Length of Service Calculationchar10CHAR(N' ')NoT54C2BEN_CMTSV Allow NULL? 
23CPMODBenefit Compensation Model for Calculating Earningsnvarchar40CHAR(N' ')NoT74HMBEN_CPMOE Allow NULL? 
24CPMOHBenefit Compensation Model for Calculating Working Hoursnvarchar40CHAR(N' ')NoT74HMBEN_CPMOH Allow NULL? 
25EQSCHBenefit Indic. Ben. Accrual Hours according to Plnd W. Timechar10CHAR(N' ')NoBEN_EQSCH Allow NULL? 
26EQHRSBenefit Number of Benefit Accrual Hoursdecimal152DEC((0))NoBEN_EQHRS
27EQPERBenefit Reference Period for Benefit Accrual Hoursnvarchar20NUMC(N'00')NoBEN_EQPER Allow NULL? 
28LNCODBenefit insurance line code for IDOC transmissionnvarchar30CHAR(N' ')NoBEN_LNCOD Allow NULL? 
29SPARQBenefit indicator spouse's approval requiredchar10CHAR(N' ')NoBEN_SPARQ Allow NULL? 
30PRDEDBenefit indicator prededuction from employee leavingchar10CHAR(N' ')NoBEN_PRDED Allow NULL? 
31DEPYNBenefit indicator for relevancy of dependentschar10CHAR(N' ')NoBEN_DEPYN Allow NULL? 
32BENYNBenefit Indicator for Relevancy of Beneficiarieschar10CHAR(N' ')NoBEN_BENYN Allow NULL? 
33EEBYNBenefit indicator employee's beneficiary statuschar10CHAR(N' ')NoBEN_EEBYN Allow NULL? 
34CTGYNBenefit indicator relevancy of contingency beneficiarychar10CHAR(N' ')NoBEN_CTGYN Allow NULL? 
35INVYNBenefit indicator for relevancy of investmentschar10CHAR(N' ')NoBEN_INVYN Allow NULL? 
36PREYNBenefit indicator pre-tax deductions allowedchar10CHAR(N' ')NoBEN_PREYN Allow NULL? 
37PSTYNBenefit indicator post-tax deductions allowedchar10CHAR(N' ')NoBEN_PSTYN Allow NULL? 
38CSTYNBenefit indicator for cost rule variant relevancychar10CHAR(N' ')NoBEN_CSTYN Allow NULL? 
39CRDYNBenefit indicator for credit rule variant relevancychar10CHAR(N' ')NoBEN_CRDYN Allow NULL? 
40COVYNBenefit indicator for coverage rule variant relevancychar10CHAR(N' ')NoBEN_COVYN Allow NULL? 
41EECYNBenefit indicator for relevancy of EE contributionchar10CHAR(N' ')NoBEN_EECYN Allow NULL? 
42ERCYNBenefit indicator for relevancy of ER contributionchar10CHAR(N' ')NoBEN_ERCYN Allow NULL? 
43VESYNBenefit indicator for relevancy of vesting rulechar10CHAR(N' ')NoBEN_VESYN Allow NULL? 
44BONYNBenefit indicator plan relevant for bonus paymentschar10CHAR(N' ')NoBEN_BONYN Allow NULL? 
45EEWTYBenefit Wage Type for Pre-Tax Employee Contributionsnvarchar40CHAR(N' ')No*BEN_EEWTYP Allow NULL? 
46PTWTYBenefit Wage Type for Post-Tax Employee Contributionsnvarchar40CHAR(N' ')No*BEN_PTWTYP Allow NULL? 
47ERWTYBenefit Wage Type for Employer Contributionnvarchar40CHAR(N' ')No*BEN_ERWTYP Allow NULL? 
48TBWTYBenefit wage type for technical calculation basenvarchar40CHAR(N' ')No*BEN_TBWTYP Allow NULL? 
49BEWTYBenefit wage type for bonus employee pre-tax amountnvarchar40CHAR(N' ')No*BEN_BEWTYP Allow NULL? 
50BPWTYBenefit wage type for employee post-tax bonus contributionnvarchar40CHAR(N' ')No*BEN_BPWTYP Allow NULL? 
51BRWTYBenefit wage type for employer bonus contributionnvarchar40CHAR(N' ')No*BEN_BRWTYP Allow NULL? 
52BTWTYBenefit Technical Wage Type for Bonus Paymentnvarchar40CHAR(N' ')No*BEN_BTWTYP Allow NULL? 
53PRWTYBenefit wage type for payments to providernvarchar40CHAR(N' ')No*BEN_PRWTYP Allow NULL? 
54BSWTYBenefit wage type for calculation basenvarchar40CHAR(N' ')No*BEN_BSWTYP Allow NULL? 
55INWTYBenefit wage type for investmentnvarchar40CHAR(N' ')No*BEN_INWTYP Allow NULL? 
56CPWTYBenefit Wage Type for Storage of Compensation from Modelnvarchar40CHAR(N' ')No*BEN_CPWTYP Allow NULL? 
57IIWTYBenefits Wage Type for Imputed Incomenvarchar40CHAR(N' ')No*BEN_IIWTY Allow NULL? 
58URLPLBenefit URL ID for Information on Benefits Plannvarchar40CHAR(N' ')NoT74HPBEN_URLPL Allow NULL? 
59PPLANTo be deleted - no longer used!nvarchar40CHAR(N' ')NoT5UBABEN_PPLAN Allow NULL? 
60ROTHPBenefits Indicator Roth Planchar10CHAR(N' ')NoBEN_ROTHP Allow NULL? 
61HSAPLBenefits Indicator HSA Planchar10CHAR(N' ')NoBEN_HSAPL Allow NULL? 
62COBSRRelevant for COBRA subsidychar10CHAR(N' ')NoBEN_COBSR Allow NULL? 
63COBCMCOBRA indicator for calendar month planschar10CHAR(N' ')NoBEN_COBCM Allow NULL? 
NamePrimaryUniqueTypeColumns
T5UBA~0YesYesCLUSTEREDENDDA, BPLAN, BAREA, MANDT

All references to SAP and SAP logo are trademarks of SAP AG in Germany, EU, USA and other territories.
No warranty is provided to data provided by this site. This website is not affiliated with, maintained, authorized, endorsed or sponsored by the SAP AG Company or any of its affiliates.
About :: Terms :: Privacy