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
6OPCH386A/P Invoice
7INV1265A/R Invoice - Rows
8JDT1124Journal Entry - Rows
9OPOR386Purchase Order
10OVTG52Tax Definition

B1 8.8: Top 10 requests

TableColumnsDescription
1ORCT154Incoming Payment
2OITM249Items
3OINV268A/R Invoice
4OIVL77Whse Journal
5OINM101Whse Journal
6OVPM154Outgoing Payments
7OPCH268A/P Invoice
8JDT1110Journal Entry - Rows
9OOCR9Loading Factors
10OSRN20Serial Numbers Master Data
1ERP EHP76.0T7HRJOPPD441JOPPD Form data - Intermediate table
SQL:  selectupdate insert create

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

SELECT MANDT, BUKRS, OZIZV, VRIZV, EEOIB, CADAT, OZSTJ, OZPRI, OZMJE, OZVRE, RAZOD, RAZDO, OZNPR, STAT0, STAT1, REDBR, PAYDT, OZPOD, MUNCP, MUNCR, KATEG, EMDIS, WKHRS, IZPRI, OSNDO, EEPE1, EEPE2, ERHE, ERIN, EREM, ERPE1, ERPE2, ERTA, EREMI, IZDAT, OSODB, TAX, STAX, IZNPR, OZNAI, OBPRI, PERNR, ORIGN, STAT2 FROM T7HRJOPPD
ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1MANDTClientnvarchar30 Allow NULL? 
2BUKRSCompany Codenvarchar40 Allow NULL? 
3OZIZVJOPPD identification/Oznaka izvjescanvarchar50 Allow NULL? 
4VRIZVJOPPD type/Vrsta izvjescachar10 Allow NULL? 
5EEOIBOIB personal identification numbernvarchar110 Allow NULL? 
6CADATCorrection/Addition datenvarchar80 Allow NULL? 
7OZSTJIncome recipient identif./ Oznaka stjecatelja/osiguranikanvarchar40 Allow NULL? 
8OZPRIIncome type/ Oznaka primitka/obveze doprinosanvarchar40 Allow NULL? 
9OZMJEFirst/last month/ Oznaka prvog/zadnjeg mjesecachar10 Allow NULL? 
10OZVREIdent. for full/non-full or half-wrk.timechar10 Allow NULL? 
11RAZODStart Datenvarchar80 Allow NULL? 
12RAZDOEnd Datenvarchar80 Allow NULL? 
13OZNPRIdent. for untaxable payment/ Oznaka neoporez. primitkanvarchar20 Allow NULL? 
14STAT0Statuschar10 Allow NULL? 
15STAT1Statuschar10 Allow NULL? 
16REDBRSequential numberint100 Allow NULL? 
17PAYDTPay date for awardsnvarchar80 Allow NULL? 
18OZPODSubmitter identification/ Oznaka podnositeljachar10 Allow NULL? 
19MUNCPMunicipality Code HRnvarchar80 Allow NULL? 
20MUNCRMunicipality of worknvarchar80 Allow NULL? 
21KATEGBenefical categorychar10 Allow NULL? 
22EMDISDuty to Employment insur. for disabledchar10 Allow NULL? 
23WKHRSPlanned working time in hoursdecimal52
24IZPRITotal gross amountdecimal152
25OSNDOInsurance base/ Osnova za obracun doprinosadecimal152
26EEPE1Pension insurance contributiondecimal152
27EEPE2Pension insurance level 2/ Doprinos za mirov. osig. stup IIdecimal152
28ERHEHealth insurance/ Doprinos za zdravstveno osiguranjedecimal152
29ERINInjury insurance/ Doprinos za zaštitu zdravlja na radudecimal152
30EREMEmployment insurance/ Doprinos za zapošljavanjedecimal152
31ERPE1Pension insurance for beneficiary/ Mirov. osiguranje benef.decimal152
32ERPE2Pens. insurance for benef. level 2 / Mir. osig. benef. st. 2decimal152
33ERTAHealth insurance for trip abroad/ Zdravstv. osig. inozemst.decimal152
34EREMIEmployment insurance for disabled/ Dopr. za zapošl. invalid.decimal152
35IZDATCost/ Izdatakdecimal152
36OSODBPersonal tax relief/ Osobni odbitakdecimal152
37TAXTax amount/ Iznos obracunanog poreza na dohodakdecimal152
38STAXSurtax amount/ Iznos obracunanog prireza porezu na dohodakdecimal152
39IZNPRUntaxable payment/ Iznos neoporezivog primitkadecimal152
40OZNAIPayment method identification/ Oznaka nacina isplatechar10 Allow NULL? 
41OBPRIIncome from dependent work/ Obracunani primit. od nesam.radadecimal152
42PERNRPersonnel numbernvarchar80 Allow NULL? 
43ORIGNVersion Number Componentnvarchar20 Allow NULL? 
44STAT2Statuschar10 Allow NULL? 
NamePrimaryUniqueTypeColumns
T7HRJOPPD~0YesYesCLUSTEREDSTAT1, STAT0, OZNPR, RAZDO, RAZOD, OZVRE, OZMJE, OZPRI, OZSTJ, CADAT, EEOIB, VRIZV, OZIZV, BUKRS, MANDT