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  | PA0307
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
Personnel Management :: Personnel Administration
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0PA03071541Additional data for taxationPersonnel 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, LGA_001, BET_001, LGA_002, BET_002, LGA_003, BET_003, LGA_004, BET_004, LGA_005, BET_005, LGA_006, BET_006, LGA_007, BET_007, LGA_008, BET_008, LGA_009, BET_009, LGA_010, BET_010, LGA_011, BET_011, LGA_012, BET_012, LGA_013, BET_013, LGA_014, BET_014, LGA_015, BET_015, LGA_016, BET_016, LGA_017, BET_017, LGA_018, BET_018, LGA_019, BET_019, LGA_020, BET_020, LGA_021, BET_021, LGA_022, BET_022, LGA_023, BET_023, LGA_024, BET_024, LGA_025, BET_025, LGA_026, BET_026, LGA_027, BET_027, LGA_028, BET_028, LGA_029, BET_029, LGA_030, BET_030, LGA_031, BET_031, LGA_032, BET_032, LGA_033, BET_033, LGA_034, BET_034, LGA_035, BET_035, LGA_036, BET_036, LGA_037, BET_037, LGA_038, BET_038, LGA_039, BET_039, LGA_040, BET_040, LGA_051, SZO_051, LGA_052, SZO_052, LGA_053, SZO_053, LGA_054, SZO_054, LGA_055, SZO_055, LGA_056, SZO_056, LGA_057, SZO_057, LGA_058, SZO_058, LGA_059, SZO_059, LGA_060, SZO_060, LGA_061, ANZ_061, EIN_061, LGA_062, ANZ_062, EIN_062, LGA_063, ANZ_063, EIN_063, LGA_064, ANZ_064, EIN_064, LGA_065, ANZ_065, EIN_065, LGA_066, ANZ_066, EIN_066, LGA_071, FBC_071, LGA_072, FBC_072, LGA_073, FBC_073, LGA_074, FBC_074, LGA_075, FBC_075, LGA_076, FBC_076, WAERS FROM PA0307
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT 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? 
24LGA_001Wage Typenvarchar40CHAR(N' ')Yes*LGART Allow NULL? 
25BET_001Amountdecimal92CURR((0))YesBETRG
26LGA_002Wage Typenvarchar40CHAR(N' ')Yes*LGART Allow NULL? 
27BET_002Amountdecimal92CURR((0))YesBETRG
28LGA_003Wage Typenvarchar40CHAR(N' ')Yes*LGART Allow NULL? 
29BET_003Amountdecimal92CURR((0))YesBETRG
30LGA_004Wage Typenvarchar40CHAR(N' ')Yes*LGART Allow NULL? 
31BET_004Amountdecimal92CURR((0))YesBETRG
32LGA_005Wage Typenvarchar40CHAR(N' ')Yes*LGART Allow NULL? 
33BET_005Amountdecimal92CURR((0))YesBETRG
34LGA_006Wage Typenvarchar40CHAR(N' ')Yes*LGART Allow NULL? 
35BET_006Amountdecimal92CURR((0))YesBETRG
36LGA_007Wage Typenvarchar40CHAR(N' ')Yes*LGART Allow NULL? 
37BET_007Amountdecimal92CURR((0))YesBETRG
38LGA_008Wage Typenvarchar40CHAR(N' ')Yes*LGART Allow NULL? 
39BET_008Amountdecimal92CURR((0))YesBETRG
40LGA_009Wage Typenvarchar40CHAR(N' ')Yes*LGART Allow NULL? 
41BET_009Amountdecimal92CURR((0))YesBETRG
42LGA_010Wage Typenvarchar40CHAR(N' ')Yes*LGART Allow NULL? 
43BET_010Amountdecimal92CURR((0))YesBETRG
44LGA_011Wage Typenvarchar40CHAR(N' ')Yes*LGART Allow NULL? 
45BET_011Amountdecimal92CURR((0))YesBETRG
46LGA_012Wage Typenvarchar40CHAR(N' ')Yes*LGART Allow NULL? 
47BET_012Amountdecimal92CURR((0))YesBETRG
48LGA_013Wage Typenvarchar40CHAR(N' ')Yes*LGART Allow NULL? 
49BET_013Amountdecimal92CURR((0))YesBETRG
50LGA_014Wage Typenvarchar40CHAR(N' ')Yes*LGART Allow NULL? 
51BET_014Amountdecimal92CURR((0))YesBETRG
52LGA_015Wage Typenvarchar40CHAR(N' ')Yes*LGART Allow NULL? 
53BET_015Amountdecimal92CURR((0))YesBETRG
54LGA_016Wage Typenvarchar40CHAR(N' ')Yes*LGART Allow NULL? 
55BET_016Amountdecimal92CURR((0))YesBETRG
56LGA_017Wage Typenvarchar40CHAR(N' ')Yes*LGART Allow NULL? 
57BET_017Amountdecimal92CURR((0))YesBETRG
58LGA_018Wage Typenvarchar40CHAR(N' ')Yes*LGART Allow NULL? 
59BET_018Amountdecimal92CURR((0))YesBETRG
60LGA_019Wage Typenvarchar40CHAR(N' ')Yes*LGART Allow NULL? 
61BET_019Amountdecimal92CURR((0))YesBETRG
62LGA_020Wage Typenvarchar40CHAR(N' ')Yes*LGART Allow NULL? 
63BET_020Amountdecimal92CURR((0))YesBETRG
64LGA_021Wage Typenvarchar40CHAR(N' ')Yes*LGART Allow NULL? 
65BET_021Amountdecimal92CURR((0))YesBETRG
66LGA_022Wage Typenvarchar40CHAR(N' ')Yes*LGART Allow NULL? 
67BET_022Amountdecimal92CURR((0))YesBETRG
68LGA_023Wage Typenvarchar40CHAR(N' ')Yes*LGART Allow NULL? 
69BET_023Amountdecimal92CURR((0))YesBETRG
70LGA_024Wage Typenvarchar40CHAR(N' ')Yes*LGART Allow NULL? 
71BET_024Amountdecimal92CURR((0))YesBETRG
72LGA_025Wage Typenvarchar40CHAR(N' ')Yes*LGART Allow NULL? 
73BET_025Amountdecimal92CURR((0))YesBETRG
74LGA_026Wage Typenvarchar40CHAR(N' ')Yes*LGART Allow NULL? 
75BET_026Amountdecimal92CURR((0))YesBETRG
76LGA_027Wage Typenvarchar40CHAR(N' ')Yes*LGART Allow NULL? 
77BET_027Amountdecimal92CURR((0))YesBETRG
78LGA_028Wage Typenvarchar40CHAR(N' ')Yes*LGART Allow NULL? 
79BET_028Amountdecimal92CURR((0))YesBETRG
80LGA_029Wage Typenvarchar40CHAR(N' ')Yes*LGART Allow NULL? 
81BET_029Amountdecimal92CURR((0))YesBETRG
82LGA_030Wage Typenvarchar40CHAR(N' ')Yes*LGART Allow NULL? 
83BET_030Amountdecimal92CURR((0))YesBETRG
84LGA_031Wage Typenvarchar40CHAR(N' ')Yes*LGART Allow NULL? 
85BET_031Amountdecimal92CURR((0))YesBETRG
86LGA_032Wage Typenvarchar40CHAR(N' ')Yes*LGART Allow NULL? 
87BET_032Amountdecimal92CURR((0))YesBETRG
88LGA_033Wage Typenvarchar40CHAR(N' ')Yes*LGART Allow NULL? 
89BET_033Amountdecimal92CURR((0))YesBETRG
90LGA_034Wage Typenvarchar40CHAR(N' ')Yes*LGART Allow NULL? 
91BET_034Amountdecimal92CURR((0))YesBETRG
92LGA_035Wage Typenvarchar40CHAR(N' ')Yes*LGART Allow NULL? 
93BET_035Amountdecimal92CURR((0))YesBETRG
94LGA_036Wage Typenvarchar40CHAR(N' ')Yes*LGART Allow NULL? 
95BET_036Amountdecimal92CURR((0))YesBETRG
96LGA_037Wage Typenvarchar40CHAR(N' ')Yes*LGART Allow NULL? 
97BET_037Amountdecimal92CURR((0))YesBETRG
98LGA_038Wage Typenvarchar40CHAR(N' ')Yes*LGART Allow NULL? 
99BET_038Amountdecimal92CURR((0))YesBETRG
100LGA_039Wage Typenvarchar40CHAR(N' ')Yes*LGART Allow NULL? 
101BET_039Amountdecimal92CURR((0))YesBETRG
102LGA_040Wage Typenvarchar40CHAR(N' ')Yes*LGART Allow NULL? 
103BET_040Amountdecimal92CURR((0))YesBETRG
104LGA_051Wage Typenvarchar40CHAR(N' ')Yes*LGART Allow NULL? 
105SZO_051Data field for entering tax-related notionsnvarchar250CHAR(N' ')YesP21_ADSZO Allow NULL? 
106LGA_052Wage Typenvarchar40CHAR(N' ')Yes*LGART Allow NULL? 
107SZO_052Data field for entering tax-related notionsnvarchar250CHAR(N' ')YesP21_ADSZO Allow NULL? 
108LGA_053Wage Typenvarchar40CHAR(N' ')Yes*LGART Allow NULL? 
109SZO_053Data field for entering tax-related notionsnvarchar250CHAR(N' ')YesP21_ADSZO Allow NULL? 
110LGA_054Wage Typenvarchar40CHAR(N' ')Yes*LGART Allow NULL? 
111SZO_054Data field for entering tax-related notionsnvarchar250CHAR(N' ')YesP21_ADSZO Allow NULL? 
112LGA_055Wage Typenvarchar40CHAR(N' ')Yes*LGART Allow NULL? 
113SZO_055Data field for entering tax-related notionsnvarchar250CHAR(N' ')YesP21_ADSZO Allow NULL? 
114LGA_056Wage Typenvarchar40CHAR(N' ')Yes*LGART Allow NULL? 
115SZO_056Data field for entering tax-related notionsnvarchar250CHAR(N' ')YesP21_ADSZO Allow NULL? 
116LGA_057Wage Typenvarchar40CHAR(N' ')Yes*LGART Allow NULL? 
117SZO_057Data field for entering tax-related notionsnvarchar250CHAR(N' ')YesP21_ADSZO Allow NULL? 
118LGA_058Wage Typenvarchar40CHAR(N' ')Yes*LGART Allow NULL? 
119SZO_058Data field for entering tax-related notionsnvarchar250CHAR(N' ')YesP21_ADSZO Allow NULL? 
120LGA_059Wage Typenvarchar40CHAR(N' ')Yes*LGART Allow NULL? 
121SZO_059Data field for entering tax-related notionsnvarchar250CHAR(N' ')YesP21_ADSZO Allow NULL? 
122LGA_060Wage Typenvarchar40CHAR(N' ')Yes*LGART Allow NULL? 
123SZO_060Data field for entering tax-related notionsnvarchar250CHAR(N' ')YesP21_ADSZO Allow NULL? 
124LGA_061Wage Typenvarchar40CHAR(N' ')Yes*LGART Allow NULL? 
125ANZ_061Numberdecimal72DEC((0))YesANZHL
126EIN_061Time/Measurement Unitnvarchar30CHAR(N' ')Yes*PT_ZEINH Allow NULL? 
127LGA_062Wage Typenvarchar40CHAR(N' ')Yes*LGART Allow NULL? 
128ANZ_062Numberdecimal72DEC((0))YesANZHL
129EIN_062Time/Measurement Unitnvarchar30CHAR(N' ')Yes*PT_ZEINH Allow NULL? 
130LGA_063Wage Typenvarchar40CHAR(N' ')Yes*LGART Allow NULL? 
131ANZ_063Numberdecimal72DEC((0))YesANZHL
132EIN_063Time/Measurement Unitnvarchar30CHAR(N' ')Yes*PT_ZEINH Allow NULL? 
133LGA_064Wage Typenvarchar40CHAR(N' ')Yes*LGART Allow NULL? 
134ANZ_064Numberdecimal72DEC((0))YesANZHL
135EIN_064Time/Measurement Unitnvarchar30CHAR(N' ')Yes*PT_ZEINH Allow NULL? 
136LGA_065Wage Typenvarchar40CHAR(N' ')Yes*LGART Allow NULL? 
137ANZ_065Numberdecimal72DEC((0))YesANZHL
138EIN_065Time/Measurement Unitnvarchar30CHAR(N' ')Yes*PT_ZEINH Allow NULL? 
139LGA_066Wage Typenvarchar40CHAR(N' ')Yes*LGART Allow NULL? 
140ANZ_066Numberdecimal72DEC((0))YesANZHL
141EIN_066Time/Measurement Unitnvarchar30CHAR(N' ')Yes*PT_ZEINH Allow NULL? 
142LGA_071Wage Typenvarchar40CHAR(N' ')Yes*LGART Allow NULL? 
143FBC_071Release override (override by 0)char10CHAR(N' ')YesP21_FBIRB Allow NULL? 
144LGA_072Wage Typenvarchar40CHAR(N' ')Yes*LGART Allow NULL? 
145FBC_072Release override (override by 0)char10CHAR(N' ')YesP21_FBIRB Allow NULL? 
146LGA_073Wage Typenvarchar40CHAR(N' ')Yes*LGART Allow NULL? 
147FBC_073Release override (override by 0)char10CHAR(N' ')YesP21_FBIRB Allow NULL? 
148LGA_074Wage Typenvarchar40CHAR(N' ')Yes*LGART Allow NULL? 
149FBC_074Release override (override by 0)char10CHAR(N' ')YesP21_FBIRB Allow NULL? 
150LGA_075Wage Typenvarchar40CHAR(N' ')Yes*LGART Allow NULL? 
151FBC_075Release override (override by 0)char10CHAR(N' ')YesP21_FBIRB Allow NULL? 
152LGA_076Wage Typenvarchar40CHAR(N' ')Yes*LGART Allow NULL? 
153FBC_076Release override (override by 0)char10CHAR(N' ')YesP21_FBIRB Allow NULL? 
154WAERSCurrency Keynvarchar50CUKY(N' ')YesTCURCWAERS Allow NULL? 
NamePrimaryUniqueTypeColumns
PA0307~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