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)
8BSEG345Accounting Document Segment
9/1RA/0SD010MI170Items for Class SD01 - Raw Data
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
1ORCT154Incoming Payment
2OITM249Items
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OINM101Whse Journal
7OPCH268A/P Invoice
8JDT1110Journal Entry - Rows
9OOCR9Loading Factors
10OSRN20Serial Numbers Master Data
Payroll :: USA :: Net :: Tax :: BSI
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0BSIUDTT431HR-US: BSI test data (tax record)BSI
SQL:  selectupdate insert create

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

SELECT MANDT, TSTCASE, SEQNO, AUTH_CODE, RESID_CODE, TAX_TYPE, RECIP_FORM, FORMULA_NO, TAX_EX_IND, RECI_PARTI, CERT_CODE, PAY_PER_WA, PAYPERWAID, YTD_WAGES, YTD_TAX, ROUND_IND, MAR_STA_IN, REG_EXEMP, REG_EXE_AM, PERS_EXEMP, DEPE_EXEMP, ADD_EXEMP, ADD_EX_AM, SUPPL_CODE, BASE_WAGES, ADD_TAX_CO, ADD_TAX_RT, ADD_AMOUNT, EIC_STATUS, PAY_PER_TX, MTD_WAGES, MTD_TAX, PERC_WORKD, R_TX_CR_AM, EXPERIE_RT, MAX_WG_OVR, SE_ADJ_TAX, CALCED_TAX, TAXBLE_WAG, TOTAL_WAG, TAX_RATE, TAX_EXEMP, CALC_STA FROM BSIUDTT
ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1MANDTClientnvarchar30 Allow NULL? 
2TSTCASEBSI: Test Case Numbernvarchar50 Allow NULL? 
3SEQNOTwo digit numbernvarchar20 Allow NULL? 
4AUTH_CODEAuthority Codenvarchar110 Allow NULL? 
5RESID_CODEResident Codechar10 Allow NULL? 
6TAX_TYPETax Typenvarchar20 Allow NULL? 
7RECIP_FORMReciprocal Formulanvarchar60 Allow NULL? 
8FORMULA_NOFormula Numbernvarchar60 Allow NULL? 
9TAX_EX_INDTax Exemption Indicatorchar10 Allow NULL? 
10RECI_PARTIReciprocal Participationchar10 Allow NULL? 
11CERT_CODECertificate Codechar10 Allow NULL? 
12PAY_PER_WAPay Period Wagesnvarchar240 Allow NULL? 
13PAYPERWAIDBSI interface: BOOLchar10 Allow NULL? 
14YTD_WAGESYear To Date Wagesnvarchar240 Allow NULL? 
15YTD_TAXYear To Date Taxnvarchar240 Allow NULL? 
16ROUND_INDRounding Indicatorchar10 Allow NULL? 
17MAR_STA_INMarital Status Indicatornvarchar20 Allow NULL? 
18REG_EXEMPRegular Exemptionsnvarchar60 Allow NULL? 
19REG_EXE_AMRegular Exemption Amountnvarchar240 Allow NULL? 
20PERS_EXEMPPersonal Exemptionsnvarchar60 Allow NULL? 
21DEPE_EXEMPDependent Exemptionsnvarchar60 Allow NULL? 
22ADD_EXEMPAdditional Exemptionsnvarchar60 Allow NULL? 
23ADD_EX_AMAdditional Exemption Amountnvarchar240 Allow NULL? 
24SUPPL_CODESupplemental Codechar10 Allow NULL? 
25BASE_WAGESBase Wagesnvarchar240 Allow NULL? 
26ADD_TAX_COAdditional Tax Codechar10 Allow NULL? 
27ADD_TAX_RTAdditional Tax Ratenvarchar240 Allow NULL? 
28ADD_AMOUNTAdditional Amountnvarchar240 Allow NULL? 
29EIC_STATUSEIC Status Indicatorchar10 Allow NULL? 
30PAY_PER_TXPay Period Taxnvarchar240 Allow NULL? 
31MTD_WAGESMonth To Date or Quarter to Date Wagesnvarchar240 Allow NULL? 
32MTD_TAXMonth To Date or Quarter to Date Taxesnvarchar240 Allow NULL? 
33PERC_WORKDPercent Workednvarchar240 Allow NULL? 
34R_TX_CR_AMReciprocal Tax Credit Amountnvarchar240 Allow NULL? 
35EXPERIE_RTExperience Ratenvarchar240 Allow NULL? 
36MAX_WG_OVRMaximum Wage Overridenvarchar240 Allow NULL? 
37SE_ADJ_TAXSelf Adjust Taxchar10 Allow NULL? 
38CALCED_TAXCalculated Taxnvarchar240 Allow NULL? 
39TAXBLE_WAGTaxable Wagesnvarchar240 Allow NULL? 
40TOTAL_WAGBSI interface: AMOUNTnvarchar240 Allow NULL? 
41TAX_RATETax Ratenvarchar240 Allow NULL? 
42TAX_EXEMPTotal Exemption Valuenvarchar240 Allow NULL? 
43CALC_STACalculation Statuschar10 Allow NULL? 
NamePrimaryUniqueTypeColumns
BSIUDTT~0YesYesCLUSTEREDSEQNO, TSTCASE, MANDT