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
Personnel Management :: Personnel Administration :: Italy
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0PA0154991HR master record, infotype 0154 (social security data)Italy
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, CDINP, REGIO, NUDIR, NUUSL, CDUSL, TPA1, CDC1, TPA2, CDC2, TPA3, CDC3, TPA4, CDC4, TPA5, CDC5, TPA6, CDC6, TPA7, CDC7, TPA8, CDC8, TPA9, CDC9, TPA10, CDC10, TPA11, CDC11, TPA12, CDC12, TPA13, CDC13, TPA14, CDC14, TPA15, CDC15, TPA16, CDC16, TPA17, CDC17, TPA18, CDC18, TPA19, CDC19, TPA20, CDC20, TPA21, CDC21, TPA22, CDC22, TPA23, CDC23, TPA24, CDC24, TPA25, CDC25, TPA26, CDC26, TPA27, CDC27, TPA28, CDC28, TPA29, CDC29, TPA30, CDC30, SEDEL, INPSC, MODMN, CODATT, CODALTR, CODAGE, CDATTIV, MATPROV, TIPOLAV, CONTR, TIPEAPPREND FROM PA0154
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? 
24CDINPINPS personal indicatornvarchar90 Allow NULL? 
25REGIOSpecial status regions and districtsnvarchar30 Allow NULL? 
26NUDIRINPDAI manager accountnvarchar100 Allow NULL? 
27NUUSLPersonal number 2nvarchar100 Allow NULL? 
28CDUSL3 single indicatornvarchar40 Allow NULL? 
29TPA1Taxation typenvarchar20 Allow NULL? 
30CDC1Contribution indicatornvarchar50 Allow NULL? 
31TPA2Taxation typenvarchar20 Allow NULL? 
32CDC2Contribution indicatornvarchar50 Allow NULL? 
33TPA3Taxation typenvarchar20 Allow NULL? 
34CDC3Contribution indicatornvarchar50 Allow NULL? 
35TPA4Taxation typenvarchar20 Allow NULL? 
36CDC4Contribution indicatornvarchar50 Allow NULL? 
37TPA5Taxation typenvarchar20 Allow NULL? 
38CDC5Contribution indicatornvarchar50 Allow NULL? 
39TPA6Taxation typenvarchar20 Allow NULL? 
40CDC6Contribution indicatornvarchar50 Allow NULL? 
41TPA7Taxation typenvarchar20 Allow NULL? 
42CDC7Contribution indicatornvarchar50 Allow NULL? 
43TPA8Taxation typenvarchar20 Allow NULL? 
44CDC8Contribution indicatornvarchar50 Allow NULL? 
45TPA9Taxation typenvarchar20 Allow NULL? 
46CDC9Contribution indicatornvarchar50 Allow NULL? 
47TPA10Taxation typenvarchar20 Allow NULL? 
48CDC10Contribution indicatornvarchar50 Allow NULL? 
49TPA11Taxation typenvarchar20 Allow NULL? 
50CDC11Contribution indicatornvarchar50 Allow NULL? 
51TPA12Taxation typenvarchar20 Allow NULL? 
52CDC12Contribution indicatornvarchar50 Allow NULL? 
53TPA13Taxation typenvarchar20 Allow NULL? 
54CDC13Contribution indicatornvarchar50 Allow NULL? 
55TPA14Taxation typenvarchar20 Allow NULL? 
56CDC14Contribution indicatornvarchar50 Allow NULL? 
57TPA15Taxation typenvarchar20 Allow NULL? 
58CDC15Contribution indicatornvarchar50 Allow NULL? 
59TPA16Taxation typenvarchar20 Allow NULL? 
60CDC16Contribution indicatornvarchar50 Allow NULL? 
61TPA17Taxation typenvarchar20 Allow NULL? 
62CDC17Contribution indicatornvarchar50 Allow NULL? 
63TPA18Taxation typenvarchar20 Allow NULL? 
64CDC18Contribution indicatornvarchar50 Allow NULL? 
65TPA19Taxation typenvarchar20 Allow NULL? 
66CDC19Contribution indicatornvarchar50 Allow NULL? 
67TPA20Taxation typenvarchar20 Allow NULL? 
68CDC20Contribution indicatornvarchar50 Allow NULL? 
69TPA21Taxation typenvarchar20 Allow NULL? 
70CDC21Contribution indicatornvarchar50 Allow NULL? 
71TPA22Taxation typenvarchar20 Allow NULL? 
72CDC22Contribution indicatornvarchar50 Allow NULL? 
73TPA23Taxation typenvarchar20 Allow NULL? 
74CDC23Contribution indicatornvarchar50 Allow NULL? 
75TPA24Taxation typenvarchar20 Allow NULL? 
76CDC24Contribution indicatornvarchar50 Allow NULL? 
77TPA25Taxation typenvarchar20 Allow NULL? 
78CDC25Contribution indicatornvarchar50 Allow NULL? 
79TPA26Taxation typenvarchar20 Allow NULL? 
80CDC26Contribution indicatornvarchar50 Allow NULL? 
81TPA27Taxation typenvarchar20 Allow NULL? 
82CDC27Contribution indicatornvarchar50 Allow NULL? 
83TPA28Taxation typenvarchar20 Allow NULL? 
84CDC28Contribution indicatornvarchar50 Allow NULL? 
85TPA29Taxation typenvarchar20 Allow NULL? 
86CDC29Contribution indicatornvarchar50 Allow NULL? 
87TPA30Taxation typenvarchar20 Allow NULL? 
88CDC30Contribution indicatornvarchar50 Allow NULL? 
89SEDELPlace of work indicatornvarchar70 Allow NULL? 
90INPSCINPS indicatornvarchar40 Allow NULL? 
91MODMNCalculation grouping DM10nvarchar40 Allow NULL? 
92CODATTCoCoCo - Contract typenvarchar20 Allow NULL? 
93CODALTRCode: other mandatory insurance formnvarchar30 Allow NULL? 
94CODAGECont.&coord.services - contribution facility codenvarchar20 Allow NULL? 
95CDATTIVCoCoCo - Activity codenvarchar20 Allow NULL? 
96MATPROVRegistration No. of Contr. Position at INPS of Originnvarchar100 Allow NULL? 
97TIPOLAVIdentify special types of workers for stat. purposesnvarchar40 Allow NULL? 
98CONTRINPS Pay Scale Indicator 3char10 Allow NULL? 
99TIPEAPPRENDType of apprenticeship in UniEmensnvarchar40 Allow NULL? 
NamePrimaryUniqueTypeColumns
PA0154~0YesYesCLUSTEREDSEQNR, BEGDA, ENDDA, SPRPS, OBJPS, SUBTY, PERNR, MANDT