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
Payroll :: Mexico :: Public Sector
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0PAPBSMXSARC781SAR current resultPublic Sector
SQL:  selectupdate insert create

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

SELECT MANDT, PERNR, RPTYR, RPTPD, EVTYP, RFCNP, RFCNC, CURPP, CURPC, SSNNP, SSNNC, LNAMP, LNAMC, SNAMP, SNAMC, FNAMP, FNAMC, PATNP, PATNC, WKCTP, WKCTC, BRANN, PAYCT, ICEFA, GBDAT, GBDEP, GESCH, BEGDA, CONDA, TEMDA, BQWAM, FOVLN, SARAM, SARAA, SARIT, FOVAM, FOVAA, FOVIT, WAERS, MARST, EEADR, EEDST, EECTY, EEZIP, EESTE, APPTY, INTCN, SCDAT, ISBQW, SABQW, INTWG, WKDAY, MARSP, EEADP, EEDSP, EECTP, EEZPP, EESTP, APPTP, ICEFP, INTCP, SCDAP, ISBQP, SABQP, INTWP, WKDAP, TMRSN, PERNP, DINCA, DINCP, DAUSE, DAUSP, AFORE, AFORP, AHSOL, AHSOP, IAHSC, IAHSP FROM PAPBSMXSARC
ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1MANDTClientnvarchar30 Allow NULL? 
2PERNRPersonnel numbernvarchar80 Allow NULL? 
3RPTYRReport yearnvarchar40 Allow NULL? 
4RPTPDReport periodnvarchar20 Allow NULL? 
5EVTYPEvent typechar10 Allow NULL? 
6RFCNPRFC Numbernvarchar130 Allow NULL? 
7RFCNCRFC Numbernvarchar130 Allow NULL? 
8CURPPCURP numbernvarchar180 Allow NULL? 
9CURPCCURP numbernvarchar180 Allow NULL? 
10SSNNPIMSS affiliation numbernvarchar110 Allow NULL? 
11SSNNCIMSS affiliation numbernvarchar110 Allow NULL? 
12LNAMPLast Namenvarchar400 Allow NULL? 
13LNAMCLast Namenvarchar400 Allow NULL? 
14SNAMPSecond Namenvarchar400 Allow NULL? 
15SNAMCSecond Namenvarchar400 Allow NULL? 
16FNAMPFirst Namenvarchar400 Allow NULL? 
17FNAMCFirst Namenvarchar400 Allow NULL? 
18PATNPISSSTE paying agent numbernvarchar60 Allow NULL? 
19PATNCISSSTE paying agent numbernvarchar60 Allow NULL? 
20WKCTPDistribution keynvarchar200 Allow NULL? 
21WKCTCDistribution keynvarchar200 Allow NULL? 
22BRANNISSSTE actual branch codenvarchar50 Allow NULL? 
23PAYCTPayment center IDnvarchar70 Allow NULL? 
24ICEFABank codenvarchar30 Allow NULL? 
25GBDATDate of Birthnvarchar80 Allow NULL? 
26GBDEPBirth state codenvarchar20 Allow NULL? 
27GESCHGender keychar10 Allow NULL? 
28BEGDAStart Datenvarchar80 Allow NULL? 
29CONDAISSSTE contribution start datenvarchar80 Allow NULL? 
30TEMDAEnd Datenvarchar80 Allow NULL? 
31BQWAMBQW amountdecimal152
32FOVLNFOVISSSTE loan indicatorchar10 Allow NULL? 
33SARAMSAR contribution amountdecimal152
34SARAASAR addtional contribtuion amountdecimal152
35SARITSAR interest for late submissiondecimal152
36FOVAMFOVISSSTE contribution amountdecimal152
37FOVAAFOVISSSTE additional contribution amountdecimal152
38FOVITFOVISSSTE interest for late submissiondecimal152
39WAERSCurrency Keynvarchar50 Allow NULL? 
40MARSTMarital Status Keychar10 Allow NULL? 
41EEADRStreet and House Numbernvarchar600 Allow NULL? 
42EEDSTLocality or district of workernvarchar300 Allow NULL? 
43EECTYCity, locality or municipality of the workernvarchar300 Allow NULL? 
44EEZIPEmployee's postal codenvarchar50 Allow NULL? 
45EESTEFederal area of workernvarchar20 Allow NULL? 
46APPTYEmployee's appointment typenvarchar20 Allow NULL? 
47INTCNWorker internal control numbernvarchar300 Allow NULL? 
48SCDATSalary change datenvarchar80 Allow NULL? 
49ISBQWSalario Base de CotizaciĆ³n ISSSTEdecimal152
50SABQWSAR Basic Quotation Wagedecimal152
51INTWGIntegrated wagedecimal152
52WKDAYDays worked in the period (bimonthly)decimal152
53MARSPMarital Status Keychar10 Allow NULL? 
54EEADPStreet and House Numbernvarchar600 Allow NULL? 
55EEDSPLocality or district of workernvarchar300 Allow NULL? 
56EECTPCity, locality or municipality of the workernvarchar300 Allow NULL? 
57EEZPPEmployee's postal codenvarchar50 Allow NULL? 
58EESTPFederal area of workernvarchar20 Allow NULL? 
59APPTPEmployee's appointment typenvarchar20 Allow NULL? 
60ICEFPBank codenvarchar30 Allow NULL? 
61INTCPWorker internal control numbernvarchar300 Allow NULL? 
62SCDAPSalary change datenvarchar80 Allow NULL? 
63ISBQPSalario Base de CotizaciĆ³n ISSSTEdecimal152
64SABQPSAR Basic Quotation Wagedecimal152
65INTWPIntegrated wagedecimal152
66WKDAPDays worked in the period (bimonthly)decimal152
67TMRSNCause of deregistrationchar10 Allow NULL? 
68PERNPPersonnel numbernvarchar80 Allow NULL? 
69DINCADays worked in the period (bimonthly)decimal152
70DINCPDays worked in the period (bimonthly)decimal152
71DAUSEDays worked in the period (bimonthly)decimal152
72DAUSPDays worked in the period (bimonthly)decimal152
73AFOREEvent typechar10 Allow NULL? 
74AFORPEvent typechar10 Allow NULL? 
75AHSOLSingle-Character Indicatorchar10 Allow NULL? 
76AHSOPSingle-Character Indicatorchar10 Allow NULL? 
77IAHSCCurrent solidary savings amountdecimal152
78IAHSPAmount of previous solidary savingsdecimal152
NamePrimaryUniqueTypeColumns
PAPBSMXSARC~0YesYesCLUSTEREDRPTPD, RPTYR, PERNR, MANDT