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  | PAPBSMXSARC
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
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 TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2PERNRPersonnel numbernvarchar80NUMC(N'00000000')NoPA0003PERSNO Allow NULL? 
3RPTYRReport yearnvarchar40NUMC(N'0000')NoPMXP_RPTYR Allow NULL? 
4RPTPDReport periodnvarchar20NUMC(N'00')NoPMXP_RPTPD Allow NULL? 
5EVTYPEvent typechar10CHAR(N' ')YesPMXP_EVTYP Allow NULL? 
6RFCNPRFC Numbernvarchar130CHAR(N' ')YesPMXP_RFCNM Allow NULL? 
7RFCNCRFC Numbernvarchar130CHAR(N' ')YesPMXP_RFCNM Allow NULL? 
8CURPPCURP numbernvarchar180CHAR(N' ')YesPMXP_CURPN Allow NULL? 
9CURPCCURP numbernvarchar180CHAR(N' ')YesPMXP_CURPN Allow NULL? 
10SSNNPIMSS affiliation numbernvarchar110CHAR(N' ')YesPMX_NIMSS Allow NULL? 
11SSNNCIMSS affiliation numbernvarchar110CHAR(N' ')YesPMX_NIMSS Allow NULL? 
12LNAMPLast Namenvarchar400CHAR(N' ')YesPAD_NACHN Allow NULL? 
13LNAMCLast Namenvarchar400CHAR(N' ')YesPAD_NACHN Allow NULL? 
14SNAMPSecond Namenvarchar400CHAR(N' ')YesPAD_NACH2 Allow NULL? 
15SNAMCSecond Namenvarchar400CHAR(N' ')YesPAD_NACH2 Allow NULL? 
16FNAMPFirst Namenvarchar400CHAR(N' ')YesPAD_VORNA Allow NULL? 
17FNAMCFirst Namenvarchar400CHAR(N' ')YesPAD_VORNA Allow NULL? 
18PATNPISSSTE paying agent numbernvarchar60CHAR(N' ')YesPMXP_PATNR Allow NULL? 
19PATNCISSSTE paying agent numbernvarchar60CHAR(N' ')YesPMXP_PATNR Allow NULL? 
20WKCTPDistribution keynvarchar200CHAR(N' ')YesPMXP_WKCTR Allow NULL? 
21WKCTCDistribution keynvarchar200CHAR(N' ')YesPMXP_WKCTR Allow NULL? 
22BRANNISSSTE actual branch codenvarchar50CHAR(N' ')YesPMXP_BRANN Allow NULL? 
23PAYCTPayment center IDnvarchar70CHAR(N' ')YesPMXP_PAYCT Allow NULL? 
24ICEFABank codenvarchar30CHAR(N' ')YesPMXP_ICEFA Allow NULL? 
25GBDATDate of Birthnvarchar80DATS(N'00000000')YesGBDAT Allow NULL? 
26GBDEPBirth state codenvarchar20CHAR(N' ')YesPMXP_GBDEP Allow NULL? 
27GESCHGender keychar10CHAR(N' ')YesPMXP_GESCH Allow NULL? 
28BEGDAStart Datenvarchar80DATS(N'00000000')YesBEGDA Allow NULL? 
29CONDAISSSTE contribution start datenvarchar80DATS(N'00000000')YesPMXP_CONDA Allow NULL? 
30TEMDAEnd Datenvarchar80DATS(N'00000000')YesENDDA Allow NULL? 
31BQWAMBQW amountdecimal152CURR((0))YesPMXP_BQWAM
32FOVLNFOVISSSTE loan indicatorchar10CHAR(N' ')YesPMXP_FOVLN Allow NULL? 
33SARAMSAR contribution amountdecimal152CURR((0))YesPMXP_SARAM
34SARAASAR addtional contribtuion amountdecimal152CURR((0))YesPMXP_SARAA
35SARITSAR interest for late submissiondecimal152CURR((0))YesPMXP_SARIT
36FOVAMFOVISSSTE contribution amountdecimal152CURR((0))YesPMXP_FOVAM
37FOVAAFOVISSSTE additional contribution amountdecimal152CURR((0))YesPMXP_FOVAA
38FOVITFOVISSSTE interest for late submissiondecimal152CURR((0))YesPMXP_FOVIT
39WAERSCurrency Keynvarchar50CUKY(N' ')Yes*WAERS Allow NULL? 
40MARSTMarital Status Keychar10CHAR(N' ')Yes*FAMST Allow NULL? 
41EEADRStreet and House Numbernvarchar600CHAR(N' ')YesPAD_STRAS Allow NULL? 
42EEDSTLocality or district of workernvarchar300CHAR(N' ')YesPMXP_EEDST Allow NULL? 
43EECTYCity, locality or municipality of the workernvarchar300CHAR(N' ')YesPMXP_EECTY Allow NULL? 
44EEZIPEmployee's postal codenvarchar50CHAR(N' ')YesPMXP_EEZIP Allow NULL? 
45EESTEFederal area of workernvarchar20CHAR(N' ')YesPMXP_EESTE Allow NULL? 
46APPTYEmployee's appointment typenvarchar20CHAR(N' ')YesPMXP_APPTY Allow NULL? 
47INTCNWorker internal control numbernvarchar300CHAR(N' ')YesPMXP_INTCN Allow NULL? 
48SCDATSalary change datenvarchar80DATS(N'00000000')YesPMXP_SCDAT Allow NULL? 
49ISBQWSalario Base de Cotización ISSSTEdecimal152CURR((0))YesPMXP_ISBQW
50SABQWSAR Basic Quotation Wagedecimal152CURR((0))YesPMXP_SABQW
51INTWGIntegrated wagedecimal152CURR((0))YesPMXP_INTWG
52WKDAYDays worked in the period (bimonthly)decimal152DEC((0))YesPMXP_WKDAY
53MARSPMarital Status Keychar10CHAR(N' ')Yes*FAMST Allow NULL? 
54EEADPStreet and House Numbernvarchar600CHAR(N' ')YesPAD_STRAS Allow NULL? 
55EEDSPLocality or district of workernvarchar300CHAR(N' ')YesPMXP_EEDST Allow NULL? 
56EECTPCity, locality or municipality of the workernvarchar300CHAR(N' ')YesPMXP_EECTY Allow NULL? 
57EEZPPEmployee's postal codenvarchar50CHAR(N' ')YesPMXP_EEZIP Allow NULL? 
58EESTPFederal area of workernvarchar20CHAR(N' ')YesPMXP_EESTE Allow NULL? 
59APPTPEmployee's appointment typenvarchar20CHAR(N' ')YesPMXP_APPTY Allow NULL? 
60ICEFPBank codenvarchar30CHAR(N' ')YesPMXP_ICEFA Allow NULL? 
61INTCPWorker internal control numbernvarchar300CHAR(N' ')YesPMXP_INTCN Allow NULL? 
62SCDAPSalary change datenvarchar80DATS(N'00000000')YesPMXP_SCDAT Allow NULL? 
63ISBQPSalario Base de Cotización ISSSTEdecimal152CURR((0))YesPMXP_ISBQW
64SABQPSAR Basic Quotation Wagedecimal152CURR((0))YesPMXP_SABQW
65INTWPIntegrated wagedecimal152CURR((0))YesPMXP_INTWG
66WKDAPDays worked in the period (bimonthly)decimal152DEC((0))YesPMXP_WKDAY
67TMRSNCause of deregistrationchar10CHAR(N' ')YesPMXP_TMRSN Allow NULL? 
68PERNPPersonnel numbernvarchar80NUMC(N'00000000')Yes*PERSNO Allow NULL? 
69DINCADays worked in the period (bimonthly)decimal152DEC((0))YesPMXP_WKDAY
70DINCPDays worked in the period (bimonthly)decimal152DEC((0))YesPMXP_WKDAY
71DAUSEDays worked in the period (bimonthly)decimal152DEC((0))YesPMXP_WKDAY
72DAUSPDays worked in the period (bimonthly)decimal152DEC((0))YesPMXP_WKDAY
73AFOREEvent typechar10CHAR(N' ')YesPMXP_EVTYP Allow NULL? 
74AFORPEvent typechar10CHAR(N' ')YesPMXP_EVTYP Allow NULL? 
75AHSOLSingle-Character Indicatorchar10CHAR(N' ')YesCHAR1 Allow NULL? 
76AHSOPSingle-Character Indicatorchar10CHAR(N' ')YesCHAR1 Allow NULL? 
77IAHSCCurrent solidary savings amountdecimal152CURR((0))YesPMXP_IAHSC
78IAHSPAmount of previous solidary savingsdecimal152CURR((0))YesPMXP_IAHSP
NamePrimaryUniqueTypeColumns
PAPBSMXSARC~0YesYesCLUSTEREDRPTPD, RPTYR, PERNR, 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