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  | PA9990
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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

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
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
1ERP EHP76.0PA9990871HR Master Record: Infotype 9990
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, PY_SEQNR, MOLGA, ABKRS, WAERS, FPPER, PAYTY, PAYID, PAY_DATE, ZZTEL0114B, ZZTEL0115B, ZZTEL0116B, ZZTEL0117B, ZZTEL0286B, ZZTEL0287B, ZZTEL0288B, ZZTEL0289B, ZZTEL0290A, ZZTEL0291A, ZZTEL0292A, ZZTEL0293A, ZZTEL0118B, ZZTEL0119B, ZZTEL0120B, ZZTEL0121B, ZZTEL0122B, ZZTEL0123B, ZZTEL0124B, ZZTEL0125B, ZZTEL0126A, ZZTEL0127A, ZZTEL0128A, ZZTEL0129A, ZZTEL0130B, ZZTEL0131B, ZZTEL0132B, ZZTEL0133B, ZZTEL0134A, ZZTEL0135A, ZZTEL0136A, ZZTEL0137A, ZZTEL0138B, ZZTEL0139B, ZZTEL0140B, ZZTEL0141B, ZZTEL0142B, ZZTEL0143B, ZZTEL0144B, ZZTEL0145B, ZZTEL0146A, ZZTEL0147A, ZZTEL0148A, ZZTEL0149A, ZZTEL0150B, ZZTEL0151B, ZZTEL0152B, ZZTEL0153B, ZZTEL0154B, ZZTEL0155B, ZZTEL0156B, ZZTEL0157B, ZZTEL0158A, ZZTEL0159A, ZZTEL0160A, ZZTEL0161A FROM PA9990
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? 
24PY_SEQNRSequence Numbernvarchar50NUMC(N'00000')YesCDSEQ Allow NULL? 
25MOLGACountry Groupingnvarchar20CHAR(N' ')Yes*MOLGA Allow NULL? 
26ABKRSPayroll Areanvarchar20CHAR(N' ')Yes*ABKRS Allow NULL? 
27WAERSCurrency Keynvarchar50CUKY(N' ')Yes*WAERS Allow NULL? 
28FPPERFor-period for payrollnvarchar60CHAR(N' ')YesFAPER Allow NULL? 
29PAYTYPayroll typechar10CHAR(N' ')YesPAYTY Allow NULL? 
30PAYIDPayroll Identifierchar10CHAR(N' ')YesPAYID Allow NULL? 
31PAY_DATEPay date for payroll resultnvarchar80DATS(N'00000000')YesPAY_DATE Allow NULL? 
32ZZTEL0114BBonusdecimal152CURR((0))YesZZTEL0114B
33ZZTEL0115BBonus MTDdecimal152CURR((0))YesZZTEL0115B
34ZZTEL0116BBonus QTDdecimal152CURR((0))YesZZTEL0116B
35ZZTEL0117BBonus YTDdecimal152CURR((0))YesZZTEL0117B
36ZZTEL0286BHoliday Earningsdecimal152CURR((0))YesZZTEL0286B
37ZZTEL0287BHoliday Pay MTDdecimal152CURR((0))YesZZTEL0287B
38ZZTEL0288BHoliday Pay QTDdecimal152CURR((0))YesZZTEL0288B
39ZZTEL0289BHoliday Pay YTDdecimal152CURR((0))YesZZTEL0289B
40ZZTEL0290AHoliday Hoursdecimal152DEC((0))YesZZTEL0290A
41ZZTEL0291AHoliday Hours MTDdecimal152DEC((0))YesZZTEL0291A
42ZZTEL0292AHoliday Hours QTDdecimal152DEC((0))YesZZTEL0292A
43ZZTEL0293AHoliday Hours YTDdecimal152DEC((0))YesZZTEL0293A
44ZZTEL0118BNet Paydecimal152CURR((0))YesZZTEL0118B
45ZZTEL0119BNet Pay MTDdecimal152CURR((0))YesZZTEL0119B
46ZZTEL0120BNet Pay QTDdecimal152CURR((0))YesZZTEL0120B
47ZZTEL0121BNet Pay YTDdecimal152CURR((0))YesZZTEL0121B
48ZZTEL0122BOvertime Earningsdecimal152CURR((0))YesZZTEL0122B
49ZZTEL0123BOvertime Pay MTDdecimal152CURR((0))YesZZTEL0123B
50ZZTEL0124BOvertime Pay QTDdecimal152CURR((0))YesZZTEL0124B
51ZZTEL0125BOvertime Pay YTDdecimal152CURR((0))YesZZTEL0125B
52ZZTEL0126AOvertime Hoursdecimal152DEC((0))YesZZTEL0126A
53ZZTEL0127AOvertime Hours MTDdecimal152DEC((0))YesZZTEL0127A
54ZZTEL0128AOvertime Hours QTDdecimal152DEC((0))YesZZTEL0128A
55ZZTEL0129AOvertime Hours YTDdecimal152DEC((0))YesZZTEL0129A
56ZZTEL0130BRegular Paydecimal152CURR((0))YesZZTEL0130B
57ZZTEL0131BRegular Pay MTDdecimal152CURR((0))YesZZTEL0131B
58ZZTEL0132BRegular Pay QTDdecimal152CURR((0))YesZZTEL0132B
59ZZTEL0133BRegular Pay YTDdecimal152CURR((0))YesZZTEL0133B
60ZZTEL0134ARegular Hrsdecimal152DEC((0))YesZZTEL0134A
61ZZTEL0135ARegular Hrs MTDdecimal152DEC((0))YesZZTEL0135A
62ZZTEL0136ARegular Hrs QTDdecimal152DEC((0))YesZZTEL0136A
63ZZTEL0137ARegular Hrs YTDdecimal152DEC((0))YesZZTEL0137A
64ZZTEL0138BShift Premiumdecimal152CURR((0))YesZZTEL0138B
65ZZTEL0139BShift Premium MTDdecimal152CURR((0))YesZZTEL0139B
66ZZTEL0140BShift Premium QTDdecimal152CURR((0))YesZZTEL0140B
67ZZTEL0141BShift Premium YTDdecimal152CURR((0))YesZZTEL0141B
68ZZTEL0142BSick Earningsdecimal152CURR((0))YesZZTEL0142B
69ZZTEL0143BSick Pay MTDdecimal152CURR((0))YesZZTEL0143B
70ZZTEL0144BSick Pay QTDdecimal152CURR((0))YesZZTEL0144B
71ZZTEL0145BSick Pay YTDdecimal152CURR((0))YesZZTEL0145B
72ZZTEL0146ASick Hoursdecimal152DEC((0))YesZZTEL0146A
73ZZTEL0147ASick Hours MTDdecimal152DEC((0))YesZZTEL0147A
74ZZTEL0148ASick Hours QTDdecimal152DEC((0))YesZZTEL0148A
75ZZTEL0149ASick Hours YTDdecimal152DEC((0))YesZZTEL0149A
76ZZTEL0150BTotal Grossdecimal152CURR((0))YesZZTEL0150B
77ZZTEL0151BTotal Gross MTDdecimal152CURR((0))YesZZTEL0151B
78ZZTEL0152BTotal Gross QTDdecimal152CURR((0))YesZZTEL0152B
79ZZTEL0153BTotal Gross YTDdecimal152CURR((0))YesZZTEL0153B
80ZZTEL0154BVacation Earningsdecimal152CURR((0))YesZZTEL0154B
81ZZTEL0155BVacation Pay MTDdecimal152CURR((0))YesZZTEL0155B
82ZZTEL0156BVacation Pay QTDdecimal152CURR((0))YesZZTEL0156B
83ZZTEL0157BVacation Pay YTDdecimal152CURR((0))YesZZTEL0157B
84ZZTEL0158AVacation Hoursdecimal152DEC((0))YesZZTEL0158A
85ZZTEL0159AVacation Hours MTDdecimal152DEC((0))YesZZTEL0159A
86ZZTEL0160AVacation Hours QTDdecimal152DEC((0))YesZZTEL0160A
87ZZTEL0161AVacation Hours YTDdecimal152DEC((0))YesZZTEL0161A
NamePrimaryUniqueTypeColumns
PA9990~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