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  | PA0881
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 :: Korea
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0PA08811371HR Master Record: Infotype 0881Korea
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, EXPTY, DPT01, OBJ01, NAM01, OAM01, CUR01, DPT02, OBJ02, NAM02, OAM02, CUR02, DPT03, OBJ03, NAM03, OAM03, CUR03, DPT04, OBJ04, NAM04, OAM04, CUR04, DPT05, OBJ05, NAM05, OAM05, CUR05, DPT06, OBJ06, NAM06, OAM06, CUR06, DPT07, OBJ07, NAM07, OAM07, CUR07, DPT08, OBJ08, NAM08, OAM08, CUR08, DPT09, OBJ09, NAM09, OAM09, CUR09, HAN01, ELV01, HAN02, ELV02, HAN03, ELV03, HAN04, ELV04, HAN05, ELV05, HAN06, ELV06, HAN07, ELV07, HAN08, ELV08, HAN09, ELV09, HAE01, HAE02, HAE03, HAE04, HAE05, HAE06, HAE07, HAE08, HAE09, CDM01, CDM02, CDM03, CDM04, CDM05, CDM06, CDM07, CDM08, CDM09, PNSTY, INSNM, ACCNO, PREIN, PREBN, FINCO, RCBEG, RCEND, STY01, STY02, STY03, STY04, STY05, STY06, STY07, STY08, STY09, LDNAM, LDREG, INRAT, ADDRE, HOUTY, FLRAR, PRD01, PRD02, PRD03, PRD04, PRD05, PRD06, PRD07, PRD08, PRD09 FROM PA0881
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? 
24EXPTYExpense typenvarchar40CHAR(N' ')YesPKR_EXPTY Allow NULL? 
25DPT01Subtypenvarchar40CHAR(N' ')YesSUBTY Allow NULL? 
26OBJ01Object Identificationnvarchar20CHAR(N' ')YesOBJPS Allow NULL? 
27NAM01Expense amount info from NTSdecimal102CURR((0))YesPKR_NTSAM
28OAM01Expense amount info from other sourcedecimal102CURR((0))YesPKR_OTHAM
29CUR01Expense currency keynvarchar50CUKY(N' ')Yes*PKR_EXCUR Allow NULL? 
30DPT02Subtypenvarchar40CHAR(N' ')YesSUBTY Allow NULL? 
31OBJ02Object Identificationnvarchar20CHAR(N' ')YesOBJPS Allow NULL? 
32NAM02Expense amount info from NTSdecimal102CURR((0))YesPKR_NTSAM
33OAM02Expense amount info from other sourcedecimal102CURR((0))YesPKR_OTHAM
34CUR02Expense currency keynvarchar50CUKY(N' ')Yes*PKR_EXCUR Allow NULL? 
35DPT03Subtypenvarchar40CHAR(N' ')YesSUBTY Allow NULL? 
36OBJ03Object Identificationnvarchar20CHAR(N' ')YesOBJPS Allow NULL? 
37NAM03Expense amount info from NTSdecimal102CURR((0))YesPKR_NTSAM
38OAM03Expense amount info from other sourcedecimal102CURR((0))YesPKR_OTHAM
39CUR03Expense currency keynvarchar50CUKY(N' ')Yes*PKR_EXCUR Allow NULL? 
40DPT04Subtypenvarchar40CHAR(N' ')YesSUBTY Allow NULL? 
41OBJ04Object Identificationnvarchar20CHAR(N' ')YesOBJPS Allow NULL? 
42NAM04Expense amount info from NTSdecimal102CURR((0))YesPKR_NTSAM
43OAM04Expense amount info from other sourcedecimal102CURR((0))YesPKR_OTHAM
44CUR04Expense currency keynvarchar50CUKY(N' ')Yes*PKR_EXCUR Allow NULL? 
45DPT05Subtypenvarchar40CHAR(N' ')YesSUBTY Allow NULL? 
46OBJ05Object Identificationnvarchar20CHAR(N' ')YesOBJPS Allow NULL? 
47NAM05Expense amount info from NTSdecimal102CURR((0))YesPKR_NTSAM
48OAM05Expense amount info from other sourcedecimal102CURR((0))YesPKR_OTHAM
49CUR05Expense currency keynvarchar50CUKY(N' ')Yes*PKR_EXCUR Allow NULL? 
50DPT06Subtypenvarchar40CHAR(N' ')YesSUBTY Allow NULL? 
51OBJ06Object Identificationnvarchar20CHAR(N' ')YesOBJPS Allow NULL? 
52NAM06Expense amount info from NTSdecimal102CURR((0))YesPKR_NTSAM
53OAM06Expense amount info from other sourcedecimal102CURR((0))YesPKR_OTHAM
54CUR06Expense currency keynvarchar50CUKY(N' ')Yes*PKR_EXCUR Allow NULL? 
55DPT07Subtypenvarchar40CHAR(N' ')YesSUBTY Allow NULL? 
56OBJ07Object Identificationnvarchar20CHAR(N' ')YesOBJPS Allow NULL? 
57NAM07Expense amount info from NTSdecimal102CURR((0))YesPKR_NTSAM
58OAM07Expense amount info from other sourcedecimal102CURR((0))YesPKR_OTHAM
59CUR07Expense currency keynvarchar50CUKY(N' ')Yes*PKR_EXCUR Allow NULL? 
60DPT08Subtypenvarchar40CHAR(N' ')YesSUBTY Allow NULL? 
61OBJ08Object Identificationnvarchar20CHAR(N' ')YesOBJPS Allow NULL? 
62NAM08Expense amount info from NTSdecimal102CURR((0))YesPKR_NTSAM
63OAM08Expense amount info from other sourcedecimal102CURR((0))YesPKR_OTHAM
64CUR08Expense currency keynvarchar50CUKY(N' ')Yes*PKR_EXCUR Allow NULL? 
65DPT09Subtypenvarchar40CHAR(N' ')YesSUBTY Allow NULL? 
66OBJ09Object Identificationnvarchar20CHAR(N' ')YesOBJPS Allow NULL? 
67NAM09Expense amount info from NTSdecimal102CURR((0))YesPKR_NTSAM
68OAM09Expense amount info from other sourcedecimal102CURR((0))YesPKR_OTHAM
69CUR09Expense currency keynvarchar50CUKY(N' ')Yes*PKR_EXCUR Allow NULL? 
70HAN01Indicator for the handicapped insurancechar10CHAR(N' ')YesPKR_HNDIS Allow NULL? 
71ELV01Dependant's education levelchar10CHAR(N' ')YesPKR_EDULV Allow NULL? 
72HAN02Indicator for the handicapped insurancechar10CHAR(N' ')YesPKR_HNDIS Allow NULL? 
73ELV02Dependant's education levelchar10CHAR(N' ')YesPKR_EDULV Allow NULL? 
74HAN03Indicator for the handicapped insurancechar10CHAR(N' ')YesPKR_HNDIS Allow NULL? 
75ELV03Dependant's education levelchar10CHAR(N' ')YesPKR_EDULV Allow NULL? 
76HAN04Indicator for the handicapped insurancechar10CHAR(N' ')YesPKR_HNDIS Allow NULL? 
77ELV04Dependant's education levelchar10CHAR(N' ')YesPKR_EDULV Allow NULL? 
78HAN05Indicator for the handicapped insurancechar10CHAR(N' ')YesPKR_HNDIS Allow NULL? 
79ELV05Dependant's education levelchar10CHAR(N' ')YesPKR_EDULV Allow NULL? 
80HAN06Indicator for the handicapped insurancechar10CHAR(N' ')YesPKR_HNDIS Allow NULL? 
81ELV06Dependant's education levelchar10CHAR(N' ')YesPKR_EDULV Allow NULL? 
82HAN07Indicator for the handicapped insurancechar10CHAR(N' ')YesPKR_HNDIS Allow NULL? 
83ELV07Dependant's education levelchar10CHAR(N' ')YesPKR_EDULV Allow NULL? 
84HAN08Indicator for the handicapped insurancechar10CHAR(N' ')YesPKR_HNDIS Allow NULL? 
85ELV08Dependant's education levelchar10CHAR(N' ')YesPKR_EDULV Allow NULL? 
86HAN09Indicator for the handicapped insurancechar10CHAR(N' ')YesPKR_HNDIS Allow NULL? 
87ELV09Dependant's education levelchar10CHAR(N' ')YesPKR_EDULV Allow NULL? 
88HAE01Indicator for the handicapped educationchar10CHAR(N' ')YesPKR_HNDED Allow NULL? 
89HAE02Indicator for the handicapped educationchar10CHAR(N' ')YesPKR_HNDED Allow NULL? 
90HAE03Indicator for the handicapped educationchar10CHAR(N' ')YesPKR_HNDED Allow NULL? 
91HAE04Indicator for the handicapped educationchar10CHAR(N' ')YesPKR_HNDED Allow NULL? 
92HAE05Indicator for the handicapped educationchar10CHAR(N' ')YesPKR_HNDED Allow NULL? 
93HAE06Indicator for the handicapped educationchar10CHAR(N' ')YesPKR_HNDED Allow NULL? 
94HAE07Indicator for the handicapped educationchar10CHAR(N' ')YesPKR_HNDED Allow NULL? 
95HAE08Indicator for the handicapped educationchar10CHAR(N' ')YesPKR_HNDED Allow NULL? 
96HAE09Indicator for the handicapped educationchar10CHAR(N' ')YesPKR_HNDED Allow NULL? 
97CDM01Expense Typechar10CHAR(N' ')YesPKR_CADME Allow NULL? 
98CDM02Expense Typechar10CHAR(N' ')YesPKR_CADME Allow NULL? 
99CDM03Expense Typechar10CHAR(N' ')YesPKR_CADME Allow NULL? 
100CDM04Expense Typechar10CHAR(N' ')YesPKR_CADME Allow NULL? 
101CDM05Expense Typechar10CHAR(N' ')YesPKR_CADME Allow NULL? 
102CDM06Expense Typechar10CHAR(N' ')YesPKR_CADME Allow NULL? 
103CDM07Expense Typechar10CHAR(N' ')YesPKR_CADME Allow NULL? 
104CDM08Expense Typechar10CHAR(N' ')YesPKR_CADME Allow NULL? 
105CDM09Expense Typechar10CHAR(N' ')YesPKR_CADME Allow NULL? 
106PNSTYSecondary Category of Expensenvarchar20CHAR(N' ')YesPKR_PNSTY Allow NULL? 
107INSNMName of Pension/Saving Institutionnvarchar300CHAR(N' ')YesPKR_INSNM Allow NULL? 
108ACCNOAccount Numbernvarchar200CHAR(N' ')YesPKR_ACCNO Allow NULL? 
109PREINPrevious Companychar10CHAR(N' ')YesPKR_PREIN Allow NULL? 
110PREBNPrevious Company / Taxpayer Association Business Numbernvarchar120CHAR(N' ')Yes*PKR_BIZNO Allow NULL? 
111FINCOInstitution's Financial Codenvarchar30NUMC(N'000')YesT7KR5DPKR_FINCO Allow NULL? 
112RCBEGRental Contract Begin Datenvarchar80DATS(N'00000000')YesPKR_RCBEG Allow NULL? 
113RCENDRental Contract End Datenvarchar80DATS(N'00000000')YesPKR_RCEND Allow NULL? 
114STY01Expense Categorychar10CHAR(N' ')YesPKR_EXSTY Allow NULL? 
115STY02Expense Categorychar10CHAR(N' ')YesPKR_EXSTY Allow NULL? 
116STY03Expense Categorychar10CHAR(N' ')YesPKR_EXSTY Allow NULL? 
117STY04Expense Categorychar10CHAR(N' ')YesPKR_EXSTY Allow NULL? 
118STY05Expense Categorychar10CHAR(N' ')YesPKR_EXSTY Allow NULL? 
119STY06Expense Categorychar10CHAR(N' ')YesPKR_EXSTY Allow NULL? 
120STY07Expense Categorychar10CHAR(N' ')YesPKR_EXSTY Allow NULL? 
121STY08Expense Categorychar10CHAR(N' ')YesPKR_EXSTY Allow NULL? 
122STY09Expense Categorychar10CHAR(N' ')YesPKR_EXSTY Allow NULL? 
123LDNAMName of Landlordnvarchar200CHAR(N' ')YesPKR_LDNAM Allow NULL? 
124LDREGKorean Business or Registration Numbernvarchar130CHAR(N' ')YesPKR_RGBZN Allow NULL? 
125INRATInterest Ratedecimal42DEC((0))YesPKR_INRAT
126ADDREAddress of Rented Apartment or Housenvarchar1000CHAR(N' ')YesPKR_ADDRR Allow NULL? 
127HOUTYHouse Typechar10CHAR(N' ')YesPKR_HOUTY Allow NULL? 
128FLRARFloor Areadecimal52DEC((0))YesPKR_FLRAR
129PRD01Expense Periodchar10CHAR(N' ')YesPKR_EXPRD Allow NULL? 
130PRD02Expense Periodchar10CHAR(N' ')YesPKR_EXPRD Allow NULL? 
131PRD03Expense Periodchar10CHAR(N' ')YesPKR_EXPRD Allow NULL? 
132PRD04Expense Periodchar10CHAR(N' ')YesPKR_EXPRD Allow NULL? 
133PRD05Expense Periodchar10CHAR(N' ')YesPKR_EXPRD Allow NULL? 
134PRD06Expense Periodchar10CHAR(N' ')YesPKR_EXPRD Allow NULL? 
135PRD07Expense Periodchar10CHAR(N' ')YesPKR_EXPRD Allow NULL? 
136PRD08Expense Periodchar10CHAR(N' ')YesPKR_EXPRD Allow NULL? 
137PRD09Expense Periodchar10CHAR(N' ')YesPKR_EXPRD Allow NULL? 
NamePrimaryUniqueTypeColumns
PA0881~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