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  | PA0831
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
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0PA08311481HR master record for infotypes 0831Personnel Administration
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, ENTIT, BRANC, DATAF, GJTAA, GJTDA, MOTAA, MOTDA, ACCAF, CONSE, PEEMP, PECOM, BTEMP, EMPCU, BTCOM, COMCU, BTUPC, UPCCU, CENTR, MODEL, FAM01, FAM02, FAM03, FAM04, FAM05, FAM06, FAM07, FAM08, FAM09, FAM10, FAM11, FAM12, FAI01, FAI02, FAI03, FAI04, FAI05, FAI06, FAI07, FAI08, FAI09, FAI10, FAI11, FAI12, DAF01, DAF02, DAF03, DAF04, DAF05, DAF06, DAF07, DAF08, DAF09, DAF10, DAF11, DAF12, CHE01, CHE02, CHE03, CHE04, CHE05, CHE06, CHE07, CHE08, CHE09, CHE10, CHE11, CHE12, PAYIN, PAYTY, PAYID, BONDT, OCRSN, TYPCO, SUBCO, ENOAC, COREX, TCO01, TCO02, TCO03, TCO04, TCO05, TCO06, TCO07, TCO08, TCO09, TCO10, TCO11, TCO12, IDT01, IDT02, IDT03, IDT04, IDT05, IDT06, IDT07, IDT08, IDT09, IDT10, IDT11, IDT12, IDN01, IDN02, IDN03, IDN04, IDN05, IDN06, IDN07, IDN08, IDN09, IDN10, IDN11, IDN12, UPC01, UPC02, UPC03, UPC04, UPC05, UPC06, UPC07, UPC08, UPC09, UPC10, UPC11, UPC12, REAFP FROM PA0831
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? 
24ENTITSocial insurance entity IDnvarchar100CHAR(N' ')YesT7CO04PCO_ENTIT Allow NULL? 
25BRANCSocial Insurance branchnvarchar30NUMC(N'000')YesT7CO05PCO_BRANC Allow NULL? 
26DATAFAffiliation datenvarchar80DATS(N'00000000')YesPCO_DATAF Allow NULL? 
27GJTAAEvent year TAAnvarchar40NUMC(N'0000')YesPCO_GJTAA Allow NULL? 
28GJTDAEvent year TDAnvarchar40NUMC(N'0000')YesPCO_GJTDA Allow NULL? 
29MOTAATAA event monthnvarchar20NUMC(N'00')YesPCO_MOTAA Allow NULL? 
30MOTDATDA event monthnvarchar20NUMC(N'00')YesPCO_MOTDA Allow NULL? 
31ACCAFAffiliation accountnvarchar180CHAR(N' ')YesPCO_ACCAF Allow NULL? 
32CONSEConsecutive Tax benefitnvarchar20CHAR(N' ')YesPCO_CONSE Allow NULL? 
33PEEMPEmployee percentagedecimal74DEC((0))YesPCO_PEEMP
34PECOMCompany percentagedecimal74DEC((0))YesPCO_PECOM
35BTEMPEmployee valuedecimal152CURR((0))YesPCO_BTEMP
36EMPCUCurrency Keynvarchar50CUKY(N' ')Yes*WAERS Allow NULL? 
37BTCOMCompany valuedecimal152CURR((0))YesPCO_BTCOM
38COMCUCurrency Keynvarchar50CUKY(N' ')Yes*WAERS Allow NULL? 
39BTUPCUPC valuedecimal152CURR((0))YesPCO_BTUPC
40UPCCUCurrency Keynvarchar50CUKY(N' ')Yes*WAERS Allow NULL? 
41CENTRWork centernvarchar60CHAR(N' ')YesT7CO06PCO_CENTR Allow NULL? 
42MODELPayment Modelnvarchar40CHAR(N' ')YesT549WMODE1 Allow NULL? 
43FAM01Family record typenvarchar40CHAR(N' ')YesPCO_FAMSA Allow NULL? 
44FAM02Family record typenvarchar40CHAR(N' ')YesPCO_FAMSA Allow NULL? 
45FAM03Family record typenvarchar40CHAR(N' ')YesPCO_FAMSA Allow NULL? 
46FAM04Family record typenvarchar40CHAR(N' ')YesPCO_FAMSA Allow NULL? 
47FAM05Family record typenvarchar40CHAR(N' ')YesPCO_FAMSA Allow NULL? 
48FAM06Family record typenvarchar40CHAR(N' ')YesPCO_FAMSA Allow NULL? 
49FAM07Family record typenvarchar40CHAR(N' ')YesPCO_FAMSA Allow NULL? 
50FAM08Family record typenvarchar40CHAR(N' ')YesPCO_FAMSA Allow NULL? 
51FAM09Family record typenvarchar40CHAR(N' ')YesPCO_FAMSA Allow NULL? 
52FAM10Family record typenvarchar40CHAR(N' ')YesPCO_FAMSA Allow NULL? 
53FAM11Family record typenvarchar40CHAR(N' ')YesPCO_FAMSA Allow NULL? 
54FAM12Family record typenvarchar40CHAR(N' ')YesPCO_FAMSA Allow NULL? 
55FAI01Object Identificationnvarchar20CHAR(N' ')YesOBJPS Allow NULL? 
56FAI02Object Identificationnvarchar20CHAR(N' ')YesOBJPS Allow NULL? 
57FAI03Object Identificationnvarchar20CHAR(N' ')YesOBJPS Allow NULL? 
58FAI04Object Identificationnvarchar20CHAR(N' ')YesOBJPS Allow NULL? 
59FAI05Object Identificationnvarchar20CHAR(N' ')YesOBJPS Allow NULL? 
60FAI06Object Identificationnvarchar20CHAR(N' ')YesOBJPS Allow NULL? 
61FAI07Object Identificationnvarchar20CHAR(N' ')YesOBJPS Allow NULL? 
62FAI08Object Identificationnvarchar20CHAR(N' ')YesOBJPS Allow NULL? 
63FAI09Object Identificationnvarchar20CHAR(N' ')YesOBJPS Allow NULL? 
64FAI10Object Identificationnvarchar20CHAR(N' ')YesOBJPS Allow NULL? 
65FAI11Object Identificationnvarchar20CHAR(N' ')YesOBJPS Allow NULL? 
66FAI12Object Identificationnvarchar20CHAR(N' ')YesOBJPS Allow NULL? 
67DAF01Affiliation date of the beneficiarynvarchar80DATS(N'00000000')YesPCO_DAFIB Allow NULL? 
68DAF02Affiliation date of the beneficiarynvarchar80DATS(N'00000000')YesPCO_DAFIB Allow NULL? 
69DAF03Affiliation date of the beneficiarynvarchar80DATS(N'00000000')YesPCO_DAFIB Allow NULL? 
70DAF04Affiliation date of the beneficiarynvarchar80DATS(N'00000000')YesPCO_DAFIB Allow NULL? 
71DAF05Affiliation date of the beneficiarynvarchar80DATS(N'00000000')YesPCO_DAFIB Allow NULL? 
72DAF06Affiliation date of the beneficiarynvarchar80DATS(N'00000000')YesPCO_DAFIB Allow NULL? 
73DAF07Affiliation date of the beneficiarynvarchar80DATS(N'00000000')YesPCO_DAFIB Allow NULL? 
74DAF08Affiliation date of the beneficiarynvarchar80DATS(N'00000000')YesPCO_DAFIB Allow NULL? 
75DAF09Affiliation date of the beneficiarynvarchar80DATS(N'00000000')YesPCO_DAFIB Allow NULL? 
76DAF10Affiliation date of the beneficiarynvarchar80DATS(N'00000000')YesPCO_DAFIB Allow NULL? 
77DAF11Affiliation date of the beneficiarynvarchar80DATS(N'00000000')YesPCO_DAFIB Allow NULL? 
78DAF12Affiliation date of the beneficiarynvarchar80DATS(N'00000000')YesPCO_DAFIB Allow NULL? 
79CHE01UPC beneficiary/Fund subsidychar10CHAR(N' ')YesPCO_CHECB Allow NULL? 
80CHE02UPC beneficiary/Fund subsidychar10CHAR(N' ')YesPCO_CHECB Allow NULL? 
81CHE03UPC beneficiary/Fund subsidychar10CHAR(N' ')YesPCO_CHECB Allow NULL? 
82CHE04UPC beneficiary/Fund subsidychar10CHAR(N' ')YesPCO_CHECB Allow NULL? 
83CHE05UPC beneficiary/Fund subsidychar10CHAR(N' ')YesPCO_CHECB Allow NULL? 
84CHE06UPC beneficiary/Fund subsidychar10CHAR(N' ')YesPCO_CHECB Allow NULL? 
85CHE07UPC beneficiary/Fund subsidychar10CHAR(N' ')YesPCO_CHECB Allow NULL? 
86CHE08UPC beneficiary/Fund subsidychar10CHAR(N' ')YesPCO_CHECB Allow NULL? 
87CHE09UPC beneficiary/Fund subsidychar10CHAR(N' ')YesPCO_CHECB Allow NULL? 
88CHE10UPC beneficiary/Fund subsidychar10CHAR(N' ')YesPCO_CHECB Allow NULL? 
89CHE11UPC beneficiary/Fund subsidychar10CHAR(N' ')YesPCO_CHECB Allow NULL? 
90CHE12UPC beneficiary/Fund subsidychar10CHAR(N' ')YesPCO_CHECB Allow NULL? 
91PAYINOff-cycle indicatorchar10CHAR(N' ')YesPCO_PAYIN Allow NULL? 
92PAYTYPayroll typechar10CHAR(N' ')YesPAYTY Allow NULL? 
93PAYIDPayroll Identifierchar10CHAR(N' ')YesPAYID Allow NULL? 
94BONDTOff-cycle payroll payment datenvarchar80DATS(N'00000000')YesBONDT Allow NULL? 
95OCRSNReason for Off-Cycle Payrollnvarchar40CHAR(N' ')YesT52OCRPAY_OCRSN Allow NULL? 
96TYPCOContributor typenvarchar20NUMC(N'00')YesPCO_TYPCO Allow NULL? 
97SUBCOContributor subtypenvarchar20NUMC(N'00')YesPCO_SUBCO Allow NULL? 
98ENOACForeigner not obligated to contribute to pensionchar10CHAR(N' ')YesPCO_ENOAC Allow NULL? 
99COREXColombian residing abroadchar10CHAR(N' ')YesPCO_COREX Allow NULL? 
100TCO01Contributor typenvarchar20NUMC(N'00')YesPCO_TYPCO Allow NULL? 
101TCO02Contributor typenvarchar20NUMC(N'00')YesPCO_TYPCO Allow NULL? 
102TCO03Contributor typenvarchar20NUMC(N'00')YesPCO_TYPCO Allow NULL? 
103TCO04Contributor typenvarchar20NUMC(N'00')YesPCO_TYPCO Allow NULL? 
104TCO05Contributor typenvarchar20NUMC(N'00')YesPCO_TYPCO Allow NULL? 
105TCO06Contributor typenvarchar20NUMC(N'00')YesPCO_TYPCO Allow NULL? 
106TCO07Contributor typenvarchar20NUMC(N'00')YesPCO_TYPCO Allow NULL? 
107TCO08Contributor typenvarchar20NUMC(N'00')YesPCO_TYPCO Allow NULL? 
108TCO09Contributor typenvarchar20NUMC(N'00')YesPCO_TYPCO Allow NULL? 
109TCO10Contributor typenvarchar20NUMC(N'00')YesPCO_TYPCO Allow NULL? 
110TCO11Contributor typenvarchar20NUMC(N'00')YesPCO_TYPCO Allow NULL? 
111TCO12Contributor typenvarchar20NUMC(N'00')YesPCO_TYPCO Allow NULL? 
112IDT01Identification typenvarchar20CHAR(N' ')YesPCO_ICTYP Allow NULL? 
113IDT02Identification typenvarchar20CHAR(N' ')YesPCO_ICTYP Allow NULL? 
114IDT03Identification typenvarchar20CHAR(N' ')YesPCO_ICTYP Allow NULL? 
115IDT04Identification typenvarchar20CHAR(N' ')YesPCO_ICTYP Allow NULL? 
116IDT05Identification typenvarchar20CHAR(N' ')YesPCO_ICTYP Allow NULL? 
117IDT06Identification typenvarchar20CHAR(N' ')YesPCO_ICTYP Allow NULL? 
118IDT07Identification typenvarchar20CHAR(N' ')YesPCO_ICTYP Allow NULL? 
119IDT08Identification typenvarchar20CHAR(N' ')YesPCO_ICTYP Allow NULL? 
120IDT09Identification typenvarchar20CHAR(N' ')YesPCO_ICTYP Allow NULL? 
121IDT10Identification typenvarchar20CHAR(N' ')YesPCO_ICTYP Allow NULL? 
122IDT11Identification typenvarchar20CHAR(N' ')YesPCO_ICTYP Allow NULL? 
123IDT12Identification typenvarchar20CHAR(N' ')YesPCO_ICTYP Allow NULL? 
124IDN01Identification numbernvarchar120CHAR(N' ')YesPCO_ICNUM Allow NULL? 
125IDN02Identification numbernvarchar120CHAR(N' ')YesPCO_ICNUM Allow NULL? 
126IDN03Identification numbernvarchar120CHAR(N' ')YesPCO_ICNUM Allow NULL? 
127IDN04Identification numbernvarchar120CHAR(N' ')YesPCO_ICNUM Allow NULL? 
128IDN05Identification numbernvarchar120CHAR(N' ')YesPCO_ICNUM Allow NULL? 
129IDN06Identification numbernvarchar120CHAR(N' ')YesPCO_ICNUM Allow NULL? 
130IDN07Identification numbernvarchar120CHAR(N' ')YesPCO_ICNUM Allow NULL? 
131IDN08Identification numbernvarchar120CHAR(N' ')YesPCO_ICNUM Allow NULL? 
132IDN09Identification numbernvarchar120CHAR(N' ')YesPCO_ICNUM Allow NULL? 
133IDN10Identification numbernvarchar120CHAR(N' ')YesPCO_ICNUM Allow NULL? 
134IDN11Identification numbernvarchar120CHAR(N' ')YesPCO_ICNUM Allow NULL? 
135IDN12Identification numbernvarchar120CHAR(N' ')YesPCO_ICNUM Allow NULL? 
136UPC01UPC valuedecimal152CURR((0))YesPCO_BTUPC
137UPC02UPC valuedecimal152CURR((0))YesPCO_BTUPC
138UPC03UPC valuedecimal152CURR((0))YesPCO_BTUPC
139UPC04UPC valuedecimal152CURR((0))YesPCO_BTUPC
140UPC05UPC valuedecimal152CURR((0))YesPCO_BTUPC
141UPC06UPC valuedecimal152CURR((0))YesPCO_BTUPC
142UPC07UPC valuedecimal152CURR((0))YesPCO_BTUPC
143UPC08UPC valuedecimal152CURR((0))YesPCO_BTUPC
144UPC09UPC valuedecimal152CURR((0))YesPCO_BTUPC
145UPC10UPC valuedecimal152CURR((0))YesPCO_BTUPC
146UPC11UPC valuedecimal152CURR((0))YesPCO_BTUPC
147UPC12UPC valuedecimal152CURR((0))YesPCO_BTUPC
148REAFPEvent: Transfer of pension systemchar10CHAR(N' ')YesPCO_REAFP Allow NULL? 
NamePrimaryUniqueTypeColumns
PA0831~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