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
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 :: 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 TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1MANDTClientnvarchar30 Allow NULL? 
2PERNRPersonnel numbernvarchar80 Allow NULL? 
3SUBTYSubtypenvarchar40 Allow NULL? 
4OBJPSObject Identificationnvarchar20 Allow NULL? 
5SPRPSLock Indicator for HR Master Data Recordchar10 Allow NULL? 
6ENDDAEnd Datenvarchar80 Allow NULL? 
7BEGDAStart Datenvarchar80 Allow NULL? 
8SEQNRNumber of Infotype Record with Same Keynvarchar30 Allow NULL? 
9AEDTMChanged Onnvarchar80 Allow NULL? 
10UNAMEName of Person Who Changed Objectnvarchar120 Allow NULL? 
11HISTOHistorical Record Flagchar10 Allow NULL? 
12ITXEXText Exists for Infotypechar10 Allow NULL? 
13REFEXReference Fields Exist (Primary/Secondary Costs)char10 Allow NULL? 
14ORDEXConfirmation Fields Existchar10 Allow NULL? 
15ITBLDInfotype Screen Controlnvarchar20 Allow NULL? 
16PREASReason for Changing Master Datanvarchar20 Allow NULL? 
17FLAG1Reserved Field/Unused Fieldchar10 Allow NULL? 
18FLAG2Reserved Field/Unused Fieldchar10 Allow NULL? 
19FLAG3Reserved Field/Unused Fieldchar10 Allow NULL? 
20FLAG4Reserved Field/Unused Fieldchar10 Allow NULL? 
21RESE1Reserved Field/Unused Field of Length 2nvarchar20 Allow NULL? 
22RESE2Reserved Field/Unused Field of Length 2nvarchar20 Allow NULL? 
23GRPVLGrouping Value for Personnel Assignmentsnvarchar40 Allow NULL? 
24STYPESuperannuation Schemenvarchar60 Allow NULL? 
25PTYPEPayment Optionnvarchar60 Allow NULL? 
26FUTDTEDate of payment for CPF paymentnvarchar80 Allow NULL? 
27APEAMTLiability amountdecimal132
28PBSAMTSG Public Sector Pensions Scheme Basic Salary Per Annumdecimal92
29PAAMTSG PS Pensions Scheme Pensionable Allowance Per Annumdecimal92
30RESECTSG PS Pensions Scheme Relevant Section of Pensions Actnvarchar500 Allow NULL? 
31REFOPTRefund Optionchar10 Allow NULL? 
32REFACTFlag to indicate whether CPF contributions already refundedchar10 Allow NULL? 
33WAERSCurrency Keynvarchar50 Allow NULL? 
34AMTOPTEmployer's CPF contribution amount to be refundeddecimal92
35AMTACTEmployer's CPF contribution amount already refundeddecimal92
36DTREFDate of payment for refund of Govt's CPF sharenvarchar80 Allow NULL? 
37REFRNOSG PS Pensions Receipt No for Refund of CPF Contributionsnvarchar200 Allow NULL? 
38REFRDTSG PS Pensions Receipt Date for Refund of CPF Contributionsnvarchar80 Allow NULL? 
39REFENOSG PS Pensions Enclosure No for Refund of CPF Contributionsnvarchar200 Allow NULL? 
40RECPFACPF minimum top up sum paid to officer's CPF accountdecimal132
41PROCFFlag to indicate whether Ee has been processed for Pensionschar10 Allow NULL? 
42OPUPFIndicator for Pensions Scheme Option selected via reportchar10 Allow NULL? 
43OPMPFIndicator for Scheme Option maintained manually by userchar10 Allow NULL? 
44ACO01Absence Code for absences not counted as pensionable servicenvarchar40 Allow NULL? 
45BEG01SG Public Sector Pensions Scheme Start Datenvarchar80 Allow NULL? 
46END01SG Public Sector Pensions Scheme End Datenvarchar80 Allow NULL? 
47ACO02Absence Code for absences not counted as pensionable servicenvarchar40 Allow NULL? 
48BEG02SG Public Sector Pensions Scheme Start Datenvarchar80 Allow NULL? 
49END02SG Public Sector Pensions Scheme End Datenvarchar80 Allow NULL? 
50ACO03Absence Code for absences not counted as pensionable servicenvarchar40 Allow NULL? 
51BEG03SG Public Sector Pensions Scheme Start Datenvarchar80 Allow NULL? 
52END03SG Public Sector Pensions Scheme End Datenvarchar80 Allow NULL? 
53ACO04Absence Code for absences not counted as pensionable servicenvarchar40 Allow NULL? 
54BEG04SG Public Sector Pensions Scheme Start Datenvarchar80 Allow NULL? 
55END04SG Public Sector Pensions Scheme End Datenvarchar80 Allow NULL? 
56ACO05Absence Code for absences not counted as pensionable servicenvarchar40 Allow NULL? 
57BEG05SG Public Sector Pensions Scheme Start Datenvarchar80 Allow NULL? 
58END05SG Public Sector Pensions Scheme End Datenvarchar80 Allow NULL? 
59ACO06Absence Code for absences not counted as pensionable servicenvarchar40 Allow NULL? 
60BEG06SG Public Sector Pensions Scheme Start Datenvarchar80 Allow NULL? 
61END06SG Public Sector Pensions Scheme End Datenvarchar80 Allow NULL? 
62ACO07Absence Code for absences not counted as pensionable servicenvarchar40 Allow NULL? 
63BEG07SG Public Sector Pensions Scheme Start Datenvarchar80 Allow NULL? 
64END07SG Public Sector Pensions Scheme End Datenvarchar80 Allow NULL? 
65ACO08Absence Code for absences not counted as pensionable servicenvarchar40 Allow NULL? 
66BEG08SG Public Sector Pensions Scheme Start Datenvarchar80 Allow NULL? 
67END08SG Public Sector Pensions Scheme End Datenvarchar80 Allow NULL? 
68ACO09Absence Code for absences not counted as pensionable servicenvarchar40 Allow NULL? 
69BEG09SG Public Sector Pensions Scheme Start Datenvarchar80 Allow NULL? 
70END09SG Public Sector Pensions Scheme End Datenvarchar80 Allow NULL? 
71ACO10Absence Code for absences not counted as pensionable servicenvarchar40 Allow NULL? 
72BEG10SG Public Sector Pensions Scheme Start Datenvarchar80 Allow NULL? 
73END10SG Public Sector Pensions Scheme End Datenvarchar80 Allow NULL? 
74ACO11Absence Code for absences not counted as pensionable servicenvarchar40 Allow NULL? 
75BEG11SG Public Sector Pensions Scheme Start Datenvarchar80 Allow NULL? 
76END11SG Public Sector Pensions Scheme End Datenvarchar80 Allow NULL? 
77ACO12Absence Code for absences not counted as pensionable servicenvarchar40 Allow NULL? 
78BEG12SG Public Sector Pensions Scheme Start Datenvarchar80 Allow NULL? 
79END12SG Public Sector Pensions Scheme End Datenvarchar80 Allow NULL? 
80ACO13Absence Code for absences not counted as pensionable servicenvarchar40 Allow NULL? 
81BEG13SG Public Sector Pensions Scheme Start Datenvarchar80 Allow NULL? 
82END13SG Public Sector Pensions Scheme End Datenvarchar80 Allow NULL? 
83ACO14Absence Code for absences not counted as pensionable servicenvarchar40 Allow NULL? 
84BEG14SG Public Sector Pensions Scheme Start Datenvarchar80 Allow NULL? 
85END14SG Public Sector Pensions Scheme End Datenvarchar80 Allow NULL? 
86ACO15Absence Code for absences not counted as pensionable servicenvarchar40 Allow NULL? 
87BEG15SG Public Sector Pensions Scheme Start Datenvarchar80 Allow NULL? 
88END15SG Public Sector Pensions Scheme End Datenvarchar80 Allow NULL? 
89ACO16Absence Code for absences not counted as pensionable servicenvarchar40 Allow NULL? 
90BEG16SG Public Sector Pensions Scheme Start Datenvarchar80 Allow NULL? 
91END16SG Public Sector Pensions Scheme End Datenvarchar80 Allow NULL? 
92ACO17Absence Code for absences not counted as pensionable servicenvarchar40 Allow NULL? 
93BEG17SG Public Sector Pensions Scheme Start Datenvarchar80 Allow NULL? 
94END17SG Public Sector Pensions Scheme End Datenvarchar80 Allow NULL? 
95ACO18Absence Code for absences not counted as pensionable servicenvarchar40 Allow NULL? 
96BEG18SG Public Sector Pensions Scheme Start Datenvarchar80 Allow NULL? 
97END18SG Public Sector Pensions Scheme End Datenvarchar80 Allow NULL? 
98ACO19Absence Code for absences not counted as pensionable servicenvarchar40 Allow NULL? 
99BEG19SG Public Sector Pensions Scheme Start Datenvarchar80 Allow NULL? 
100END19SG Public Sector Pensions Scheme End Datenvarchar80 Allow NULL? 
101ACO20Absence Code for absences not counted as pensionable servicenvarchar40 Allow NULL? 
102BEG20SG Public Sector Pensions Scheme Start Datenvarchar80 Allow NULL? 
103END20SG Public Sector Pensions Scheme End Datenvarchar80 Allow NULL? 
104PENSALPensionable Salary for Computation of Govt's share of CPFdecimal132
105NPESALNon-Pensionable Salary for Computing Govt's share of CPFdecimal132
106FROSALGuaranteed Basic Salarydecimal132
107GUAPAGuaranteed Pensionable Allowancedecimal132
108CPFPYCPF Payment amount to CPF boarddecimal132
109BENTYSuperannuation optionnvarchar30 Allow NULL? 
110DEDPCDeduction Percentage due to disciplinedecimal52
111PEACDPensions Act Codenvarchar30 Allow NULL? 
112PENSFlag for Pension scheme 2006char10 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