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  | PA0495
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 :: Singapore :: Public Sector
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0PA04951121HR-PS-SG: Pensions SchemePublic Sector
SQL:  selectupdate insert create

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

SELECT MANDT, PERNR, SUBTY, OBJPS, SPRPS, ENDDA, BEGDA, SEQNR, AEDTM, UNAME, HISTO, ITXEX, REFEX, ORDEX, ITBLD, PREAS, FLAG1, FLAG2, FLAG3, FLAG4, RESE1, RESE2, GRPVL, STYPE, PTYPE, FUTDTE, APEAMT, PBSAMT, PAAMT, RESECT, REFOPT, REFACT, WAERS, AMTOPT, AMTACT, DTREF, REFRNO, REFRDT, REFENO, RECPFA, PROCF, OPUPF, OPMPF, ACO01, BEG01, END01, ACO02, BEG02, END02, ACO03, BEG03, END03, ACO04, BEG04, END04, ACO05, BEG05, END05, ACO06, BEG06, END06, ACO07, BEG07, END07, ACO08, BEG08, END08, ACO09, BEG09, END09, ACO10, BEG10, END10, ACO11, BEG11, END11, ACO12, BEG12, END12, ACO13, BEG13, END13, ACO14, BEG14, END14, ACO15, BEG15, END15, ACO16, BEG16, END16, ACO17, BEG17, END17, ACO18, BEG18, END18, ACO19, BEG19, END19, ACO20, BEG20, END20, PENSAL, NPESAL, FROSAL, GUAPA, CPFPY, BENTY, DEDPC, PEACD, PENS FROM PA0495
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2PERNRPersonnel numbernvarchar80NUMC(N'00000000')NoPA0003PERSNO Allow NULL? 
3SUBTYSubtypenvarchar40CHAR(N' ')NoSUBTY Allow NULL? 
4OBJPSObject Identificationnvarchar20CHAR(N' ')NoOBJPS Allow NULL? 
5SPRPSLock Indicator for HR Master Data Recordchar10CHAR(N' ')NoSPRPS Allow NULL? 
6ENDDAEnd Datenvarchar80DATS(N'00000000')NoENDDA Allow NULL? 
7BEGDAStart Datenvarchar80DATS(N'00000000')NoBEGDA Allow NULL? 
8SEQNRNumber of Infotype Record with Same Keynvarchar30NUMC(N'000')NoSEQNR Allow NULL? 
9AEDTMChanged Onnvarchar80DATS(N'00000000')YesAEDAT Allow NULL? 
10UNAMEName of Person Who Changed Objectnvarchar120CHAR(N' ')YesAENAM Allow NULL? 
11HISTOHistorical Record Flagchar10CHAR(N' ')YesHISTO Allow NULL? 
12ITXEXText Exists for Infotypechar10CHAR(N' ')YesITXEX Allow NULL? 
13REFEXReference Fields Exist (Primary/Secondary Costs)char10CHAR(N' ')YesPRFEX Allow NULL? 
14ORDEXConfirmation Fields Existchar10CHAR(N' ')YesORDEX Allow NULL? 
15ITBLDInfotype Screen Controlnvarchar20CHAR(N' ')YesITBLD Allow NULL? 
16PREASReason for Changing Master Datanvarchar20CHAR(N' ')YesT530EPREAS Allow NULL? 
17FLAG1Reserved Field/Unused Fieldchar10CHAR(N' ')YesNUSED Allow NULL? 
18FLAG2Reserved Field/Unused Fieldchar10CHAR(N' ')YesNUSED Allow NULL? 
19FLAG3Reserved Field/Unused Fieldchar10CHAR(N' ')YesNUSED Allow NULL? 
20FLAG4Reserved Field/Unused Fieldchar10CHAR(N' ')YesNUSED Allow NULL? 
21RESE1Reserved Field/Unused Field of Length 2nvarchar20CHAR(N' ')YesNUSED2 Allow NULL? 
22RESE2Reserved Field/Unused Field of Length 2nvarchar20CHAR(N' ')YesNUSED2 Allow NULL? 
23GRPVLGrouping Value for Personnel Assignmentsnvarchar40CHAR(N' ')YesPCCE_GPVAL Allow NULL? 
24STYPESuperannuation Schemenvarchar60CHAR(N' ')YesT5RPBS8AP25_STYPE Allow NULL? 
25PTYPEPayment Optionnvarchar60CHAR(N' ')YesT5RPBS8BP25_PTYPE Allow NULL? 
26FUTDTEDate of payment for CPF paymentnvarchar80DATS(N'00000000')YesP25_FUTDTE Allow NULL? 
27APEAMTLiability amountdecimal132CURR((0))YesP25_LIAMT
28PBSAMTSG Public Sector Pensions Scheme Basic Salary Per Annumdecimal92CURR((0))YesP25_PBSAMT
29PAAMTSG PS Pensions Scheme Pensionable Allowance Per Annumdecimal92CURR((0))YesP25_PAAMT
30RESECTSG PS Pensions Scheme Relevant Section of Pensions Actnvarchar500CHAR(N' ')YesP25_RESECT Allow NULL? 
31REFOPTRefund Optionchar10CHAR(N' ')YesP25_REFOPT Allow NULL? 
32REFACTFlag to indicate whether CPF contributions already refundedchar10CHAR(N' ')YesP25_REFACT Allow NULL? 
33WAERSCurrency Keynvarchar50CUKY(N' ')YesTCURCWAERS Allow NULL? 
34AMTOPTEmployer's CPF contribution amount to be refundeddecimal92CURR((0))YesP25_AMTOPT
35AMTACTEmployer's CPF contribution amount already refundeddecimal92CURR((0))YesP25_AMTACT
36DTREFDate of payment for refund of Govt's CPF sharenvarchar80DATS(N'00000000')YesP25_DTREF Allow NULL? 
37REFRNOSG PS Pensions Receipt No for Refund of CPF Contributionsnvarchar200CHAR(N' ')YesP25_REFRNO Allow NULL? 
38REFRDTSG PS Pensions Receipt Date for Refund of CPF Contributionsnvarchar80DATS(N'00000000')YesP25_REFRDT Allow NULL? 
39REFENOSG PS Pensions Enclosure No for Refund of CPF Contributionsnvarchar200CHAR(N' ')YesP25_REFENO Allow NULL? 
40RECPFACPF minimum top up sum paid to officer's CPF accountdecimal132CURR((0))YesP25_RECPFA
41PROCFFlag to indicate whether Ee has been processed for Pensionschar10CHAR(N' ')YesP25_PROCF Allow NULL? 
42OPUPFIndicator for Pensions Scheme Option selected via reportchar10CHAR(N' ')YesP25_OPUPF Allow NULL? 
43OPMPFIndicator for Scheme Option maintained manually by userchar10CHAR(N' ')YesP25_OPMPF Allow NULL? 
44ACO01Absence Code for absences not counted as pensionable servicenvarchar40CHAR(N' ')Yes*P25_ACODE Allow NULL? 
45BEG01SG Public Sector Pensions Scheme Start Datenvarchar80DATS(N'00000000')YesP25_BEGDA Allow NULL? 
46END01SG Public Sector Pensions Scheme End Datenvarchar80DATS(N'00000000')YesP25_ENDDA Allow NULL? 
47ACO02Absence Code for absences not counted as pensionable servicenvarchar40CHAR(N' ')Yes*P25_ACODE Allow NULL? 
48BEG02SG Public Sector Pensions Scheme Start Datenvarchar80DATS(N'00000000')YesP25_BEGDA Allow NULL? 
49END02SG Public Sector Pensions Scheme End Datenvarchar80DATS(N'00000000')YesP25_ENDDA Allow NULL? 
50ACO03Absence Code for absences not counted as pensionable servicenvarchar40CHAR(N' ')Yes*P25_ACODE Allow NULL? 
51BEG03SG Public Sector Pensions Scheme Start Datenvarchar80DATS(N'00000000')YesP25_BEGDA Allow NULL? 
52END03SG Public Sector Pensions Scheme End Datenvarchar80DATS(N'00000000')YesP25_ENDDA Allow NULL? 
53ACO04Absence Code for absences not counted as pensionable servicenvarchar40CHAR(N' ')Yes*P25_ACODE Allow NULL? 
54BEG04SG Public Sector Pensions Scheme Start Datenvarchar80DATS(N'00000000')YesP25_BEGDA Allow NULL? 
55END04SG Public Sector Pensions Scheme End Datenvarchar80DATS(N'00000000')YesP25_ENDDA Allow NULL? 
56ACO05Absence Code for absences not counted as pensionable servicenvarchar40CHAR(N' ')Yes*P25_ACODE Allow NULL? 
57BEG05SG Public Sector Pensions Scheme Start Datenvarchar80DATS(N'00000000')YesP25_BEGDA Allow NULL? 
58END05SG Public Sector Pensions Scheme End Datenvarchar80DATS(N'00000000')YesP25_ENDDA Allow NULL? 
59ACO06Absence Code for absences not counted as pensionable servicenvarchar40CHAR(N' ')Yes*P25_ACODE Allow NULL? 
60BEG06SG Public Sector Pensions Scheme Start Datenvarchar80DATS(N'00000000')YesP25_BEGDA Allow NULL? 
61END06SG Public Sector Pensions Scheme End Datenvarchar80DATS(N'00000000')YesP25_ENDDA Allow NULL? 
62ACO07Absence Code for absences not counted as pensionable servicenvarchar40CHAR(N' ')Yes*P25_ACODE Allow NULL? 
63BEG07SG Public Sector Pensions Scheme Start Datenvarchar80DATS(N'00000000')YesP25_BEGDA Allow NULL? 
64END07SG Public Sector Pensions Scheme End Datenvarchar80DATS(N'00000000')YesP25_ENDDA Allow NULL? 
65ACO08Absence Code for absences not counted as pensionable servicenvarchar40CHAR(N' ')Yes*P25_ACODE Allow NULL? 
66BEG08SG Public Sector Pensions Scheme Start Datenvarchar80DATS(N'00000000')YesP25_BEGDA Allow NULL? 
67END08SG Public Sector Pensions Scheme End Datenvarchar80DATS(N'00000000')YesP25_ENDDA Allow NULL? 
68ACO09Absence Code for absences not counted as pensionable servicenvarchar40CHAR(N' ')Yes*P25_ACODE Allow NULL? 
69BEG09SG Public Sector Pensions Scheme Start Datenvarchar80DATS(N'00000000')YesP25_BEGDA Allow NULL? 
70END09SG Public Sector Pensions Scheme End Datenvarchar80DATS(N'00000000')YesP25_ENDDA Allow NULL? 
71ACO10Absence Code for absences not counted as pensionable servicenvarchar40CHAR(N' ')Yes*P25_ACODE Allow NULL? 
72BEG10SG Public Sector Pensions Scheme Start Datenvarchar80DATS(N'00000000')YesP25_BEGDA Allow NULL? 
73END10SG Public Sector Pensions Scheme End Datenvarchar80DATS(N'00000000')YesP25_ENDDA Allow NULL? 
74ACO11Absence Code for absences not counted as pensionable servicenvarchar40CHAR(N' ')Yes*P25_ACODE Allow NULL? 
75BEG11SG Public Sector Pensions Scheme Start Datenvarchar80DATS(N'00000000')YesP25_BEGDA Allow NULL? 
76END11SG Public Sector Pensions Scheme End Datenvarchar80DATS(N'00000000')YesP25_ENDDA Allow NULL? 
77ACO12Absence Code for absences not counted as pensionable servicenvarchar40CHAR(N' ')Yes*P25_ACODE Allow NULL? 
78BEG12SG Public Sector Pensions Scheme Start Datenvarchar80DATS(N'00000000')YesP25_BEGDA Allow NULL? 
79END12SG Public Sector Pensions Scheme End Datenvarchar80DATS(N'00000000')YesP25_ENDDA Allow NULL? 
80ACO13Absence Code for absences not counted as pensionable servicenvarchar40CHAR(N' ')Yes*P25_ACODE Allow NULL? 
81BEG13SG Public Sector Pensions Scheme Start Datenvarchar80DATS(N'00000000')YesP25_BEGDA Allow NULL? 
82END13SG Public Sector Pensions Scheme End Datenvarchar80DATS(N'00000000')YesP25_ENDDA Allow NULL? 
83ACO14Absence Code for absences not counted as pensionable servicenvarchar40CHAR(N' ')Yes*P25_ACODE Allow NULL? 
84BEG14SG Public Sector Pensions Scheme Start Datenvarchar80DATS(N'00000000')YesP25_BEGDA Allow NULL? 
85END14SG Public Sector Pensions Scheme End Datenvarchar80DATS(N'00000000')YesP25_ENDDA Allow NULL? 
86ACO15Absence Code for absences not counted as pensionable servicenvarchar40CHAR(N' ')Yes*P25_ACODE Allow NULL? 
87BEG15SG Public Sector Pensions Scheme Start Datenvarchar80DATS(N'00000000')YesP25_BEGDA Allow NULL? 
88END15SG Public Sector Pensions Scheme End Datenvarchar80DATS(N'00000000')YesP25_ENDDA Allow NULL? 
89ACO16Absence Code for absences not counted as pensionable servicenvarchar40CHAR(N' ')Yes*P25_ACODE Allow NULL? 
90BEG16SG Public Sector Pensions Scheme Start Datenvarchar80DATS(N'00000000')YesP25_BEGDA Allow NULL? 
91END16SG Public Sector Pensions Scheme End Datenvarchar80DATS(N'00000000')YesP25_ENDDA Allow NULL? 
92ACO17Absence Code for absences not counted as pensionable servicenvarchar40CHAR(N' ')Yes*P25_ACODE Allow NULL? 
93BEG17SG Public Sector Pensions Scheme Start Datenvarchar80DATS(N'00000000')YesP25_BEGDA Allow NULL? 
94END17SG Public Sector Pensions Scheme End Datenvarchar80DATS(N'00000000')YesP25_ENDDA Allow NULL? 
95ACO18Absence Code for absences not counted as pensionable servicenvarchar40CHAR(N' ')Yes*P25_ACODE Allow NULL? 
96BEG18SG Public Sector Pensions Scheme Start Datenvarchar80DATS(N'00000000')YesP25_BEGDA Allow NULL? 
97END18SG Public Sector Pensions Scheme End Datenvarchar80DATS(N'00000000')YesP25_ENDDA Allow NULL? 
98ACO19Absence Code for absences not counted as pensionable servicenvarchar40CHAR(N' ')Yes*P25_ACODE Allow NULL? 
99BEG19SG Public Sector Pensions Scheme Start Datenvarchar80DATS(N'00000000')YesP25_BEGDA Allow NULL? 
100END19SG Public Sector Pensions Scheme End Datenvarchar80DATS(N'00000000')YesP25_ENDDA Allow NULL? 
101ACO20Absence Code for absences not counted as pensionable servicenvarchar40CHAR(N' ')Yes*P25_ACODE Allow NULL? 
102BEG20SG Public Sector Pensions Scheme Start Datenvarchar80DATS(N'00000000')YesP25_BEGDA Allow NULL? 
103END20SG Public Sector Pensions Scheme End Datenvarchar80DATS(N'00000000')YesP25_ENDDA Allow NULL? 
104PENSALPensionable Salary for Computation of Govt's share of CPFdecimal132CURR((0))YesP25_PENSAL
105NPESALNon-Pensionable Salary for Computing Govt's share of CPFdecimal132CURR((0))YesP25_NPESAL
106FROSALGuaranteed Basic Salarydecimal132CURR((0))YesP25_GUABS
107GUAPAGuaranteed Pensionable Allowancedecimal132CURR((0))YesP25_GUAPA
108CPFPYCPF Payment amount to CPF boarddecimal132CURR((0))YesP25_CPFPY
109BENTYSuperannuation optionnvarchar30CHAR(N' ')YesT5RPBS8UP25_BENTY Allow NULL? 
110DEDPCDeduction Percentage due to disciplinedecimal52DEC((0))YesP25_DEDPC
111PEACDPensions Act Codenvarchar30CHAR(N' ')YesT5RPBS8TP25_PEACD Allow NULL? 
112PENSFlag for Pension scheme 2006char10CHAR(N' ')YesP25_PENS Allow NULL? 
NamePrimaryUniqueTypeColumns
PA0495~0YesYesCLUSTEREDSEQNR, BEGDA, ENDDA, SPRPS, OBJPS, SUBTY, 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