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  | PA3213
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
Payroll :: Payroll General Parts :: Reuse Services for Country Development
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0PA3213831HR PensionsReuse Services for Country Development
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, CTYPE, IDPLN, IDSBP, STATS, WAERS, SEQUE01, METHD01, PCTDD01, FIXDD01, OUCTR01, EXCTR01, SEQUE02, METHD02, PCTDD02, FIXDD02, OUCTR02, EXCTR02, SEQUE03, METHD03, PCTDD03, FIXDD03, OUCTR03, EXCTR03, SEQUE04, METHD04, PCTDD04, FIXDD04, OUCTR04, EXCTR04, SEQUE05, METHD05, PCTDD05, FIXDD05, OUCTR05, EXCTR05, SEQUE06, METHD06, PCTDD06, FIXDD06, OUCTR06, EXCTR06, SEQUE07, METHD07, PCTDD07, FIXDD07, OUCTR07, EXCTR07, SEQUE08, METHD08, PCTDD08, FIXDD08, OUCTR08, EXCTR08, SEQUE09, METHD09, PCTDD09, FIXDD09, OUCTR09, EXCTR09, CTRID FROM PA3213
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT 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? 
24CTYPEPension Subtypenvarchar40CHAR(N' ')YesP_99B_CTYPE Allow NULL? 
25IDPLNPension IDnvarchar40CHAR(N' ')YesT799BPP01P_99B_PPIDPLN Allow NULL? 
26IDSBPPension Subplan IDnvarchar30NUMC(N'000')YesT799BPP02P_99B_PPIDSBP Allow NULL? 
27STATSEmployee Statuschar10CHAR(N' ')YesP_99B_PPSTATUS Allow NULL? 
28WAERSCurrency Keynvarchar50CUKY(N' ')YesTCURCWAERS Allow NULL? 
29SEQUE01Pension Calculation Stepnvarchar30NUMC(N'000')YesT799BPP04P_99B_PPSEQUE Allow NULL? 
30METHD01Pension Calculation Method IDnvarchar40NUMC(N'0000')YesT799BPP03P_99B_PPMETHD Allow NULL? 
31PCTDD01Percent Contribution to Pensiondecimal96DEC((0))YesP_99B_PPPCTDD
32FIXDD01Flat Contribution to Pensiondecimal92CURR((0))YesP_99B_PPFIXDD
33OUCTR01Contribution Modifiernvarchar40NUMC(N'0000')YesT799BPP05P_99B_PPOUCTR Allow NULL? 
34EXCTR01Exceeding Amount Modifiernvarchar40NUMC(N'0000')YesT799BPP05P_99B_PPEXCTR Allow NULL? 
35SEQUE02Pension Calculation Stepnvarchar30NUMC(N'000')YesT799BPP04P_99B_PPSEQUE Allow NULL? 
36METHD02Pension Calculation Method IDnvarchar40NUMC(N'0000')YesT799BPP03P_99B_PPMETHD Allow NULL? 
37PCTDD02Percent Contribution to Pensiondecimal96DEC((0))YesP_99B_PPPCTDD
38FIXDD02Flat Contribution to Pensiondecimal92CURR((0))YesP_99B_PPFIXDD
39OUCTR02Contribution Modifiernvarchar40NUMC(N'0000')YesT799BPP05P_99B_PPOUCTR Allow NULL? 
40EXCTR02Exceeding Amount Modifiernvarchar40NUMC(N'0000')YesT799BPP05P_99B_PPEXCTR Allow NULL? 
41SEQUE03Pension Calculation Stepnvarchar30NUMC(N'000')YesT799BPP04P_99B_PPSEQUE Allow NULL? 
42METHD03Pension Calculation Method IDnvarchar40NUMC(N'0000')YesT799BPP03P_99B_PPMETHD Allow NULL? 
43PCTDD03Percent Contribution to Pensiondecimal96DEC((0))YesP_99B_PPPCTDD
44FIXDD03Flat Contribution to Pensiondecimal92CURR((0))YesP_99B_PPFIXDD
45OUCTR03Contribution Modifiernvarchar40NUMC(N'0000')YesT799BPP05P_99B_PPOUCTR Allow NULL? 
46EXCTR03Exceeding Amount Modifiernvarchar40NUMC(N'0000')YesT799BPP05P_99B_PPEXCTR Allow NULL? 
47SEQUE04Pension Calculation Stepnvarchar30NUMC(N'000')YesT799BPP04P_99B_PPSEQUE Allow NULL? 
48METHD04Pension Calculation Method IDnvarchar40NUMC(N'0000')YesT799BPP03P_99B_PPMETHD Allow NULL? 
49PCTDD04Percent Contribution to Pensiondecimal96DEC((0))YesP_99B_PPPCTDD
50FIXDD04Flat Contribution to Pensiondecimal92CURR((0))YesP_99B_PPFIXDD
51OUCTR04Contribution Modifiernvarchar40NUMC(N'0000')YesT799BPP05P_99B_PPOUCTR Allow NULL? 
52EXCTR04Exceeding Amount Modifiernvarchar40NUMC(N'0000')YesT799BPP05P_99B_PPEXCTR Allow NULL? 
53SEQUE05Pension Calculation Stepnvarchar30NUMC(N'000')YesT799BPP04P_99B_PPSEQUE Allow NULL? 
54METHD05Pension Calculation Method IDnvarchar40NUMC(N'0000')YesT799BPP03P_99B_PPMETHD Allow NULL? 
55PCTDD05Percent Contribution to Pensiondecimal96DEC((0))YesP_99B_PPPCTDD
56FIXDD05Flat Contribution to Pensiondecimal92CURR((0))YesP_99B_PPFIXDD
57OUCTR05Contribution Modifiernvarchar40NUMC(N'0000')YesT799BPP05P_99B_PPOUCTR Allow NULL? 
58EXCTR05Exceeding Amount Modifiernvarchar40NUMC(N'0000')YesT799BPP05P_99B_PPEXCTR Allow NULL? 
59SEQUE06Pension Calculation Stepnvarchar30NUMC(N'000')YesT799BPP04P_99B_PPSEQUE Allow NULL? 
60METHD06Pension Calculation Method IDnvarchar40NUMC(N'0000')YesT799BPP03P_99B_PPMETHD Allow NULL? 
61PCTDD06Percent Contribution to Pensiondecimal96DEC((0))YesP_99B_PPPCTDD
62FIXDD06Flat Contribution to Pensiondecimal92CURR((0))YesP_99B_PPFIXDD
63OUCTR06Contribution Modifiernvarchar40NUMC(N'0000')YesT799BPP05P_99B_PPOUCTR Allow NULL? 
64EXCTR06Exceeding Amount Modifiernvarchar40NUMC(N'0000')YesT799BPP05P_99B_PPEXCTR Allow NULL? 
65SEQUE07Pension Calculation Stepnvarchar30NUMC(N'000')YesT799BPP04P_99B_PPSEQUE Allow NULL? 
66METHD07Pension Calculation Method IDnvarchar40NUMC(N'0000')YesT799BPP03P_99B_PPMETHD Allow NULL? 
67PCTDD07Percent Contribution to Pensiondecimal96DEC((0))YesP_99B_PPPCTDD
68FIXDD07Flat Contribution to Pensiondecimal92CURR((0))YesP_99B_PPFIXDD
69OUCTR07Contribution Modifiernvarchar40NUMC(N'0000')YesT799BPP05P_99B_PPOUCTR Allow NULL? 
70EXCTR07Exceeding Amount Modifiernvarchar40NUMC(N'0000')YesT799BPP05P_99B_PPEXCTR Allow NULL? 
71SEQUE08Pension Calculation Stepnvarchar30NUMC(N'000')YesT799BPP04P_99B_PPSEQUE Allow NULL? 
72METHD08Pension Calculation Method IDnvarchar40NUMC(N'0000')YesT799BPP03P_99B_PPMETHD Allow NULL? 
73PCTDD08Percent Contribution to Pensiondecimal96DEC((0))YesP_99B_PPPCTDD
74FIXDD08Flat Contribution to Pensiondecimal92CURR((0))YesP_99B_PPFIXDD
75OUCTR08Contribution Modifiernvarchar40NUMC(N'0000')YesT799BPP05P_99B_PPOUCTR Allow NULL? 
76EXCTR08Exceeding Amount Modifiernvarchar40NUMC(N'0000')YesT799BPP05P_99B_PPEXCTR Allow NULL? 
77SEQUE09Pension Calculation Stepnvarchar30NUMC(N'000')YesT799BPP04P_99B_PPSEQUE Allow NULL? 
78METHD09Pension Calculation Method IDnvarchar40NUMC(N'0000')YesT799BPP03P_99B_PPMETHD Allow NULL? 
79PCTDD09Percent Contribution to Pensiondecimal96DEC((0))YesP_99B_PPPCTDD
80FIXDD09Flat Contribution to Pensiondecimal92CURR((0))YesP_99B_PPFIXDD
81OUCTR09Contribution Modifiernvarchar40NUMC(N'0000')YesT799BPP05P_99B_PPOUCTR Allow NULL? 
82EXCTR09Exceeding Amount Modifiernvarchar40NUMC(N'0000')YesT799BPP05P_99B_PPEXCTR Allow NULL? 
83CTRIDPension plan contract IDnvarchar200CHAR(N' ')YesP_99B_CTRID Allow NULL? 
NamePrimaryUniqueTypeColumns
PA3213~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