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
Payroll
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0PA32651441HR master record, infotype 3265Payroll
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, KULTYP, KULSOR, KIKKOD, KIKTXT, KLAND, KALLOM, ORGEH, PLANS, STELL, OSSZEG, PNEM, BIZKAT, EGHKAT, KIFPN, MKULCSSZ, MKSZOR, HEOSSZ, HEOPN, DSZOR, HDEOSSZ, HDEPN, RFKOD, RADOSSZ, RADPN, VPOSSZ, VPMERT, VDPPN, EKIOSSZ, EKIPN, KNAPK, DTSZOR, DTOSSZ, DTKPN, HTFAMSA, HTOBJPS, HTFANAM, HTFAVOR, HTOSSZ, HTPNEM, GYFAMSA01, GYOBJPS01, GYFANAM01, GYFAVOR01, GYOSSZE01, GYPZNEM01, GYFAMSA02, GYOBJPS02, GYFANAM02, GYFAVOR02, GYOSSZE02, GYPZNEM02, GYFAMSA03, GYOBJPS03, GYFANAM03, GYFAVOR03, GYOSSZE03, GYPZNEM03, GYFAMSA04, GYOBJPS04, GYFANAM04, GYFAVOR04, GYOSSZE04, GYPZNEM04, GYFAMSA05, GYOBJPS05, GYFANAM05, GYFAVOR05, GYOSSZE05, GYPZNEM05, GYFAMSA06, GYOBJPS06, GYFANAM06, GYFAVOR06, GYOSSZE06, GYPZNEM06, GYFAMSA07, GYOBJPS07, GYFANAM07, GYFAVOR07, GYOSSZE07, GYPZNEM07, GYFAMSA08, GYOBJPS08, GYFANAM08, GYFAVOR08, GYOSSZE08, GYPZNEM08, GYFAMSA09, GYOBJPS09, GYFANAM09, GYFAVOR09, GYOSSZE09, GYPZNEM09, BESKAT, MUTER, HTSZAZ, GYSZAZ01, GYSZAZ02, GYSZAZ03, GYSZAZ04, GYSZAZ05, GYSZAZ06, GYSZAZ07, GYSZAZ08, GYSZAZ09, FOGJUTT, FOGPZNEM, KSZKEZD, KSZVEGE, KSZSZAM, KNAPKIEG, KNAPKPNZNEM, KNAPCSOKK, KNAPPOTL, KNAPPPNZNEM, KNAPD, KNAPDPNZNEM, KNAPE, KNAPEPNZNEM, ENAPFEL, UNAPFEL FROM PA3265
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? 
24KULTYPSubtypenvarchar40 Allow NULL? 
25KULSORField service numbernvarchar20 Allow NULL? 
26KIKKODExpatriation codenvarchar30 Allow NULL? 
27KIKTXTExpatriation textnvarchar400 Allow NULL? 
28KLANDExpatriation countrynvarchar30 Allow NULL? 
29KALLOMWorkplace codenvarchar30 Allow NULL? 
30ORGEHOrganizational Unitnvarchar80 Allow NULL? 
31PLANSPositionnvarchar80 Allow NULL? 
32STELLJobnvarchar80 Allow NULL? 
33OSSZEGField service basic dues amountdecimal102
34PNEMBasic dues currencynvarchar50 Allow NULL? 
35BIZKATSecurity categorynvarchar20 Allow NULL? 
36EGHKATClimate categorynvarchar20 Allow NULL? 
37KIFPNCurrency of paymentnvarchar50 Allow NULL? 
38MKULCSSZJob keysnvarchar20 Allow NULL? 
39MKSZORJob multiplierdecimal42
40HEOSSZAmount of monthly duesdecimal102
41HEOPNCurrency of monthly duesnvarchar50 Allow NULL? 
42DSZORMultiplier for foreign exchange duesdecimal42
43HDEOSSZAmount of monthly foreign exchange duesdecimal102
44HDEPNCurrency of foreign exchange duesnvarchar50 Allow NULL? 
45RFKODRank for positionnvarchar20 Allow NULL? 
46RADOSSZAmount of basic foreign exchange dues by gradedecimal102
47RADPNCurrency of basic foreign exchange dues by ranknvarchar50 Allow NULL? 
48VPOSSZManager foreign exchange dues allowance amountdecimal102
49VPMERTManager foreign exchange dues allowance proportiondecimal42
50VDPPNManager foreign exchange dues allowance currencynvarchar50 Allow NULL? 
51EKIOSSZAmount of foreign exchange dues additiondecimal102
52EKIPNCurrency of dues additionnvarchar50 Allow NULL? 
53KNAPKCategory for daily allowance abroadchar10 Allow NULL? 
54DTSZORForeign exchange multiplier for enduring studies abroaddecimal42
55DTOSSZForeign exchange dues for persons endurably studying abroaddecimal102
56DTKPNCurrency of foreign exchange dues f. enduring studies abroadnvarchar50 Allow NULL? 
57HTFAMSASubtype Spousenvarchar40 Allow NULL? 
58HTOBJPSNumber of spouse, domestic partnernvarchar20 Allow NULL? 
59HTFANAMSurname of spouse, domestic partnernvarchar400 Allow NULL? 
60HTFAVORFirst name of spouse, domestic partnernvarchar400 Allow NULL? 
61HTOSSZAmount of dues for spouse, domestic partnerdecimal102
62HTPNEMCurrency of dues for spouse, domestic partnernvarchar50 Allow NULL? 
63GYFAMSA01Subtype Childnvarchar40 Allow NULL? 
64GYOBJPS01Child numbernvarchar20 Allow NULL? 
65GYFANAM01Child's surnamenvarchar400 Allow NULL? 
66GYFAVOR01Child's first namenvarchar400 Allow NULL? 
67GYOSSZE01Amount of dues for childdecimal102
68GYPZNEM01Currency of dues for childrennvarchar50 Allow NULL? 
69GYFAMSA02Subtype Childnvarchar40 Allow NULL? 
70GYOBJPS02Child numbernvarchar20 Allow NULL? 
71GYFANAM02Child's surnamenvarchar400 Allow NULL? 
72GYFAVOR02Child's first namenvarchar400 Allow NULL? 
73GYOSSZE02Amount of dues for childdecimal102
74GYPZNEM02Currency of dues for childrennvarchar50 Allow NULL? 
75GYFAMSA03Subtype Childnvarchar40 Allow NULL? 
76GYOBJPS03Child numbernvarchar20 Allow NULL? 
77GYFANAM03Child's surnamenvarchar400 Allow NULL? 
78GYFAVOR03Child's first namenvarchar400 Allow NULL? 
79GYOSSZE03Amount of dues for childdecimal102
80GYPZNEM03Currency of dues for childrennvarchar50 Allow NULL? 
81GYFAMSA04Subtype Childnvarchar40 Allow NULL? 
82GYOBJPS04Child numbernvarchar20 Allow NULL? 
83GYFANAM04Child's surnamenvarchar400 Allow NULL? 
84GYFAVOR04Child's first namenvarchar400 Allow NULL? 
85GYOSSZE04Amount of dues for childdecimal102
86GYPZNEM04Currency of dues for childrennvarchar50 Allow NULL? 
87GYFAMSA05Subtype Childnvarchar40 Allow NULL? 
88GYOBJPS05Child numbernvarchar20 Allow NULL? 
89GYFANAM05Child's surnamenvarchar400 Allow NULL? 
90GYFAVOR05Child's first namenvarchar400 Allow NULL? 
91GYOSSZE05Amount of dues for childdecimal102
92GYPZNEM05Currency of dues for childrennvarchar50 Allow NULL? 
93GYFAMSA06Subtype Childnvarchar40 Allow NULL? 
94GYOBJPS06Child numbernvarchar20 Allow NULL? 
95GYFANAM06Child's surnamenvarchar400 Allow NULL? 
96GYFAVOR06Child's first namenvarchar400 Allow NULL? 
97GYOSSZE06Amount of dues for childdecimal102
98GYPZNEM06Currency of dues for childrennvarchar50 Allow NULL? 
99GYFAMSA07Subtype Childnvarchar40 Allow NULL? 
100GYOBJPS07Child numbernvarchar20 Allow NULL? 
101GYFANAM07Child's surnamenvarchar400 Allow NULL? 
102GYFAVOR07Child's first namenvarchar400 Allow NULL? 
103GYOSSZE07Amount of dues for childdecimal102
104GYPZNEM07Currency of dues for childrennvarchar50 Allow NULL? 
105GYFAMSA08Subtype Childnvarchar40 Allow NULL? 
106GYOBJPS08Child numbernvarchar20 Allow NULL? 
107GYFANAM08Child's surnamenvarchar400 Allow NULL? 
108GYFAVOR08Child's first namenvarchar400 Allow NULL? 
109GYOSSZE08Amount of dues for childdecimal102
110GYPZNEM08Currency of dues for childrennvarchar50 Allow NULL? 
111GYFAMSA09Subtype Childnvarchar40 Allow NULL? 
112GYOBJPS09Child numbernvarchar20 Allow NULL? 
113GYFANAM09Child's surnamenvarchar400 Allow NULL? 
114GYFAVOR09Child's first namenvarchar400 Allow NULL? 
115GYOSSZE09Amount of dues for childdecimal102
116GYPZNEM09Currency of dues for childrennvarchar50 Allow NULL? 
117BESKATClassification categorynvarchar90 Allow NULL? 
118MUTERAction areachar10 Allow NULL? 
119HTSZAZSpouse allowance in % of foreign currency allowancenvarchar50 Allow NULL? 
120GYSZAZ01Child allowance in % of basic allowancedecimal51
121GYSZAZ02Child allowance in % of basic allowancedecimal51
122GYSZAZ03Child allowance in % of basic allowancedecimal51
123GYSZAZ04Child allowance in % of basic allowancedecimal51
124GYSZAZ05Child allowance in % of basic allowancedecimal51
125GYSZAZ06Child allowance in % of basic allowancedecimal51
126GYSZAZ07Child allowance in % of basic allowancedecimal51
127GYSZAZ08Child allowance in % of basic allowancedecimal51
128GYSZAZ09Child allowance in % of basic allowancedecimal51
129FOGJUTTRecipient benefitsdecimal102
130FOGPZNEMRecipient benefits currencynvarchar50 Allow NULL? 
131KSZKEZDField service start timenvarchar60 Allow NULL? 
132KSZVEGEField service end timenvarchar60 Allow NULL? 
133KSZSZAMField service calculation methodchar10 Allow NULL? 
134KNAPKIEGInternational per diem supplementdecimal102
135KNAPKPNZNEMInternational per diem supplement currencynvarchar50 Allow NULL? 
136KNAPCSOKKInternational per diem reduction factordecimal51
137KNAPPOTLInternational per diem surcharge amountdecimal102
138KNAPPPNZNEMInternational per diem surcharge currencynvarchar50 Allow NULL? 
139KNAPDInternational per diemdecimal102
140KNAPDPNZNEMInternational per diem currencynvarchar50 Allow NULL? 
141KNAPEInternational per diem advancedecimal102
142KNAPEPNZNEMInternational per diem advance currencynvarchar50 Allow NULL? 
143ENAPFELFirst day not 8 hourschar10 Allow NULL? 
144UNAPFELLast day not 8 hourschar10 Allow NULL? 
NamePrimaryUniqueTypeColumns
PA3265~0YesYesCLUSTEREDSEQNR, BEGDA, ENDDA, SPRPS, OBJPS, SUBTY, PERNR, MANDT