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)
8BSEG345Accounting Document Segment
9/1RA/0SD010MI170Items for Class SD01 - Raw Data
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
1ERP EHP76.0P2UN_QDDCON931Australia Public Sector: Payroll
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, DCT_PERNR, DCT_SEQNR, DCT_ROWID, BEGDA, ENDDA, MASSG, TMDAT, NTDAT, PTDAT, EROLE, WAERS, AJW01, AJA01, LAW01, LAA01, FUN01, ROA01, AJW02, AJA02, LAW02, LAA02, FUN02, ROA02, AJW03, AJA03, LAW03, LAA03, FUN03, ROA03, AJW04, AJA04, LAW04, LAA04, FUN04, ROA04, AJW05, AJA05, LAW05, LAA05, FUN05, ROA05, AJW06, AJA06, LAW06, LAA06, FUN06, ROA06, AJW07, AJA07, LAW07, LAA07, FUN07, ROA07, AJW08, AJA08, LAW08, LAA08, FUN08, ROA08, AJW09, AJA09, LAW09, LAA09, FUN09, ROA09, AJW10, AJA10, LAW10, LAA10, FUN10, ROA10, ETPTP, EXL01, EXL02, EXL03, EXL04, EXL05, EXL06, EXL07, EXL08, EXL09, EXL10, EXT01, EXT02, EXT03, EXT04, EXT05, EXT06, EXT07, EXT08, EXT09, EXT10 FROM P2UN_QDDCON
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2DCT_PERNRPersonnel Numbernvarchar80NUMC(N'00000000')NoP_PERNR Allow NULL? 
3DCT_SEQNRSequence Numbernvarchar50NUMC(N'00000')NoHRPY_RGDIRCDSEQ Allow NULL? 
4DCT_ROWIDUnique Row Numbernvarchar50NUMC(N'00000')NoHRDCT_ROWID Allow NULL? 
5BEGDAStart Datenvarchar80DATS(N'00000000')YesBEGDA Allow NULL? 
6ENDDAEnd Datenvarchar80DATS(N'00000000')YesENDDA Allow NULL? 
7MASSGReason for Actionnvarchar20CHAR(N' ')Yes*MASSG Allow NULL? 
8TMDATDate of terminationnvarchar80DATS(N'00000000')YesPAU_TMDAT Allow NULL? 
9NTDATNotice datenvarchar80DATS(N'00000000')YesPAU_NTDAT Allow NULL? 
10PTDATLast notice datenvarchar80DATS(N'00000000')YesPAU_PTDAT Allow NULL? 
11EROLEEmployer request EE leave before notice periodchar10CHAR(N' ')YesPAU_EROLE Allow NULL? 
12WAERSCurrency Keynvarchar50CUKY(N' ')Yes*WAERS Allow NULL? 
13AJW01WT for payment adj.nvarchar40CHAR(N' ')Yes*PAU_AJTWT Allow NULL? 
14AJA01Adjustment Amountdecimal92CURR((0))YesPAU_AJAMT
15LAW01WT for leave payment adj.nvarchar40CHAR(N' ')Yes*PAU_LATWT Allow NULL? 
16LAA01Leave adjustment Amountdecimal92CURR((0))YesPAU_LAAMT
17FUN01Rollover fund namenvarchar300CHAR(N' ')YesPAU_FUNAM Allow NULL? 
18ROA01Rollover Amountdecimal92CURR((0))YesPAU_ROAMT
19AJW02WT for payment adj.nvarchar40CHAR(N' ')Yes*PAU_AJTWT Allow NULL? 
20AJA02Adjustment Amountdecimal92CURR((0))YesPAU_AJAMT
21LAW02WT for leave payment adj.nvarchar40CHAR(N' ')Yes*PAU_LATWT Allow NULL? 
22LAA02Leave adjustment Amountdecimal92CURR((0))YesPAU_LAAMT
23FUN02Rollover fund namenvarchar300CHAR(N' ')YesPAU_FUNAM Allow NULL? 
24ROA02Rollover Amountdecimal92CURR((0))YesPAU_ROAMT
25AJW03WT for payment adj.nvarchar40CHAR(N' ')Yes*PAU_AJTWT Allow NULL? 
26AJA03Adjustment Amountdecimal92CURR((0))YesPAU_AJAMT
27LAW03WT for leave payment adj.nvarchar40CHAR(N' ')Yes*PAU_LATWT Allow NULL? 
28LAA03Leave adjustment Amountdecimal92CURR((0))YesPAU_LAAMT
29FUN03Rollover fund namenvarchar300CHAR(N' ')YesPAU_FUNAM Allow NULL? 
30ROA03Rollover Amountdecimal92CURR((0))YesPAU_ROAMT
31AJW04WT for payment adj.nvarchar40CHAR(N' ')Yes*PAU_AJTWT Allow NULL? 
32AJA04Adjustment Amountdecimal92CURR((0))YesPAU_AJAMT
33LAW04WT for leave payment adj.nvarchar40CHAR(N' ')Yes*PAU_LATWT Allow NULL? 
34LAA04Leave adjustment Amountdecimal92CURR((0))YesPAU_LAAMT
35FUN04Rollover fund namenvarchar300CHAR(N' ')YesPAU_FUNAM Allow NULL? 
36ROA04Rollover Amountdecimal92CURR((0))YesPAU_ROAMT
37AJW05WT for payment adj.nvarchar40CHAR(N' ')Yes*PAU_AJTWT Allow NULL? 
38AJA05Adjustment Amountdecimal92CURR((0))YesPAU_AJAMT
39LAW05WT for leave payment adj.nvarchar40CHAR(N' ')Yes*PAU_LATWT Allow NULL? 
40LAA05Leave adjustment Amountdecimal92CURR((0))YesPAU_LAAMT
41FUN05Rollover fund namenvarchar300CHAR(N' ')YesPAU_FUNAM Allow NULL? 
42ROA05Rollover Amountdecimal92CURR((0))YesPAU_ROAMT
43AJW06WT for payment adj.nvarchar40CHAR(N' ')Yes*PAU_AJTWT Allow NULL? 
44AJA06Adjustment Amountdecimal92CURR((0))YesPAU_AJAMT
45LAW06WT for leave payment adj.nvarchar40CHAR(N' ')Yes*PAU_LATWT Allow NULL? 
46LAA06Leave adjustment Amountdecimal92CURR((0))YesPAU_LAAMT
47FUN06Rollover fund namenvarchar300CHAR(N' ')YesPAU_FUNAM Allow NULL? 
48ROA06Rollover Amountdecimal92CURR((0))YesPAU_ROAMT
49AJW07WT for payment adj.nvarchar40CHAR(N' ')Yes*PAU_AJTWT Allow NULL? 
50AJA07Adjustment Amountdecimal92CURR((0))YesPAU_AJAMT
51LAW07WT for leave payment adj.nvarchar40CHAR(N' ')Yes*PAU_LATWT Allow NULL? 
52LAA07Leave adjustment Amountdecimal92CURR((0))YesPAU_LAAMT
53FUN07Rollover fund namenvarchar300CHAR(N' ')YesPAU_FUNAM Allow NULL? 
54ROA07Rollover Amountdecimal92CURR((0))YesPAU_ROAMT
55AJW08WT for payment adj.nvarchar40CHAR(N' ')Yes*PAU_AJTWT Allow NULL? 
56AJA08Adjustment Amountdecimal92CURR((0))YesPAU_AJAMT
57LAW08WT for leave payment adj.nvarchar40CHAR(N' ')Yes*PAU_LATWT Allow NULL? 
58LAA08Leave adjustment Amountdecimal92CURR((0))YesPAU_LAAMT
59FUN08Rollover fund namenvarchar300CHAR(N' ')YesPAU_FUNAM Allow NULL? 
60ROA08Rollover Amountdecimal92CURR((0))YesPAU_ROAMT
61AJW09WT for payment adj.nvarchar40CHAR(N' ')Yes*PAU_AJTWT Allow NULL? 
62AJA09Adjustment Amountdecimal92CURR((0))YesPAU_AJAMT
63LAW09WT for leave payment adj.nvarchar40CHAR(N' ')Yes*PAU_LATWT Allow NULL? 
64LAA09Leave adjustment Amountdecimal92CURR((0))YesPAU_LAAMT
65FUN09Rollover fund namenvarchar300CHAR(N' ')YesPAU_FUNAM Allow NULL? 
66ROA09Rollover Amountdecimal92CURR((0))YesPAU_ROAMT
67AJW10WT for payment adj.nvarchar40CHAR(N' ')Yes*PAU_AJTWT Allow NULL? 
68AJA10Adjustment Amountdecimal92CURR((0))YesPAU_AJAMT
69LAW10WT for leave payment adj.nvarchar40CHAR(N' ')Yes*PAU_LATWT Allow NULL? 
70LAA10Leave adjustment Amountdecimal92CURR((0))YesPAU_LAAMT
71FUN10Rollover fund namenvarchar300CHAR(N' ')YesPAU_FUNAM Allow NULL? 
72ROA10Rollover Amountdecimal92CURR((0))YesPAU_ROAMT
73ETPTPTransitional ETPchar10CHAR(N' ')YesPAU_ETPTP Allow NULL? 
74EXL01Flag in Termination Organizer to set a payment as Excludedchar10CHAR(N' ')YesP13Q_EXCLUDED Allow NULL? 
75EXL02Flag in Termination Organizer to set a payment as Excludedchar10CHAR(N' ')YesP13Q_EXCLUDED Allow NULL? 
76EXL03Flag in Termination Organizer to set a payment as Excludedchar10CHAR(N' ')YesP13Q_EXCLUDED Allow NULL? 
77EXL04Flag in Termination Organizer to set a payment as Excludedchar10CHAR(N' ')YesP13Q_EXCLUDED Allow NULL? 
78EXL05Flag in Termination Organizer to set a payment as Excludedchar10CHAR(N' ')YesP13Q_EXCLUDED Allow NULL? 
79EXL06Flag in Termination Organizer to set a payment as Excludedchar10CHAR(N' ')YesP13Q_EXCLUDED Allow NULL? 
80EXL07Flag in Termination Organizer to set a payment as Excludedchar10CHAR(N' ')YesP13Q_EXCLUDED Allow NULL? 
81EXL08Flag in Termination Organizer to set a payment as Excludedchar10CHAR(N' ')YesP13Q_EXCLUDED Allow NULL? 
82EXL09Flag in Termination Organizer to set a payment as Excludedchar10CHAR(N' ')YesP13Q_EXCLUDED Allow NULL? 
83EXL10Flag in Termination Organizer to set a payment as Excludedchar10CHAR(N' ')YesP13Q_EXCLUDED Allow NULL? 
84EXT01Flag in Termination Organizer to set a payment as Excludedchar10CHAR(N' ')YesP13Q_EXCLUDED Allow NULL? 
85EXT02Flag in Termination Organizer to set a payment as Excludedchar10CHAR(N' ')YesP13Q_EXCLUDED Allow NULL? 
86EXT03Flag in Termination Organizer to set a payment as Excludedchar10CHAR(N' ')YesP13Q_EXCLUDED Allow NULL? 
87EXT04Flag in Termination Organizer to set a payment as Excludedchar10CHAR(N' ')YesP13Q_EXCLUDED Allow NULL? 
88EXT05Flag in Termination Organizer to set a payment as Excludedchar10CHAR(N' ')YesP13Q_EXCLUDED Allow NULL? 
89EXT06Flag in Termination Organizer to set a payment as Excludedchar10CHAR(N' ')YesP13Q_EXCLUDED Allow NULL? 
90EXT07Flag in Termination Organizer to set a payment as Excludedchar10CHAR(N' ')YesP13Q_EXCLUDED Allow NULL? 
91EXT08Flag in Termination Organizer to set a payment as Excludedchar10CHAR(N' ')YesP13Q_EXCLUDED Allow NULL? 
92EXT09Flag in Termination Organizer to set a payment as Excludedchar10CHAR(N' ')YesP13Q_EXCLUDED Allow NULL? 
93EXT10Flag in Termination Organizer to set a payment as Excludedchar10CHAR(N' ')YesP13Q_EXCLUDED Allow NULL? 
NamePrimaryUniqueTypeColumns
P2UN_QDDCON~0YesYesCLUSTEREDDCT_ROWID, DCT_SEQNR, DCT_PERNR, MANDT