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  | T496T
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
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
1ERP EHP76.0T496T911Print PP shop papers: Transaction control
SQL:  selectupdate insert create

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

SELECT MANDT, AUTYP, AUART, WERKS, DISPO, TCODE, DVARG, DCOPG, PSTEU, SLIST, LGO1X, LG1VS, LG1CS, LG01P, LGO2X, LG2VS, LG2CS, LG02P, LGO3X, LG3VS, LG3CS, LG03P, LGO4X, LG4VS, LG4CS, LG04P, LVO1X, LV1VS, LV1CS, LV01P, LVO2X, LV2VS, LV2CS, LV02P, LVO3X, LV3VS, LV3CS, LV03P, LVO4X, LV4VS, LV4CS, LV04P, LFO1X, LF1VS, LF1CS, LF01P, LFO2X, LF2VS, LF2CS, LF02P, LFO3X, LF3VS, LF3CS, LF03P, LFO4X, LF4VS, LF4CS, LF04P, LKO1X, LK1VS, LK1CS, LK01P, LKO2X, LK2VS, LK2CS, LK02P, LKO3X, LK3VS, LK3CS, LK03P, LKO4X, LK4VS, LK4CS, LK04P, LPO1X, LP1VS, LP1CS, LP01P, LPO2X, LP2VS, LP2CS, LP02P, LPO3X, LP3VS, LP3CS, LP03P, LPO4X, LP4VS, LP4CS, LP04P, INFOS FROM T496T
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2AUTYPOrder categorynvarchar20NUMC(N'00')NoAUFTYP Allow NULL? 
3AUARTReference order type (can be masked)nvarchar40CHAR(N' ')NoFAUART Allow NULL? 
4WERKSPrint control: Plantnvarchar40CHAR(N' ')NoDWERKS Allow NULL? 
5DISPOPrint control: MRP groupnvarchar30CHAR(N' ')NoCO_DDISP Allow NULL? 
6TCODETransaction Codenvarchar200CHAR(N' ')No*TCODE Allow NULL? 
7DVARGPrint PP shop papers: Print variantnvarchar20NUMC(N'00')YesDRVAR Allow NULL? 
8DCOPGNumber of printoutsnvarchar20NUMC(N'00')YesCO_COPIES Allow NULL? 
9PSTEUControl key checkchar10CHAR(N' ')YesCO_PSTEUS Allow NULL? 
10SLISTPrint as individual listschar10CHAR(N' ')YesCO_SLIST Allow NULL? 
11LGO1XIndicator: Print listchar10CHAR(N' ')YesCO_XDRUCK Allow NULL? 
12LG1VSPrint PP shop papers: Print variantnvarchar20NUMC(N'00')YesDRVAR Allow NULL? 
13LG1CSNumber of printoutsnvarchar20NUMC(N'00')YesCO_COPIES Allow NULL? 
14LG01PSequence priority for printingnvarchar20NUMC(N'00')YesCO_DPRIO Allow NULL? 
15LGO2XIndicator: Print listchar10CHAR(N' ')YesCO_XDRUCK Allow NULL? 
16LG2VSPrint PP shop papers: Print variantnvarchar20NUMC(N'00')YesDRVAR Allow NULL? 
17LG2CSNumber of printoutsnvarchar20NUMC(N'00')YesCO_COPIES Allow NULL? 
18LG02PSequence priority for printingnvarchar20NUMC(N'00')YesCO_DPRIO Allow NULL? 
19LGO3XIndicator: Print listchar10CHAR(N' ')YesCO_XDRUCK Allow NULL? 
20LG3VSPrint PP shop papers: Print variantnvarchar20NUMC(N'00')YesDRVAR Allow NULL? 
21LG3CSNumber of printoutsnvarchar20NUMC(N'00')YesCO_COPIES Allow NULL? 
22LG03PSequence priority for printingnvarchar20NUMC(N'00')YesCO_DPRIO Allow NULL? 
23LGO4XIndicator: Print listchar10CHAR(N' ')YesCO_XDRUCK Allow NULL? 
24LG4VSPrint PP shop papers: Print variantnvarchar20NUMC(N'00')YesDRVAR Allow NULL? 
25LG4CSNumber of printoutsnvarchar20NUMC(N'00')YesCO_COPIES Allow NULL? 
26LG04PSequence priority for printingnvarchar20NUMC(N'00')YesCO_DPRIO Allow NULL? 
27LVO1XIndicator: Print listchar10CHAR(N' ')YesCO_XDRUCK Allow NULL? 
28LV1VSPrint PP shop papers: Print variantnvarchar20NUMC(N'00')YesDRVAR Allow NULL? 
29LV1CSNumber of printoutsnvarchar20NUMC(N'00')YesCO_COPIES Allow NULL? 
30LV01PSequence priority for printingnvarchar20NUMC(N'00')YesCO_DPRIO Allow NULL? 
31LVO2XIndicator: Print listchar10CHAR(N' ')YesCO_XDRUCK Allow NULL? 
32LV2VSPrint PP shop papers: Print variantnvarchar20NUMC(N'00')YesDRVAR Allow NULL? 
33LV2CSNumber of printoutsnvarchar20NUMC(N'00')YesCO_COPIES Allow NULL? 
34LV02PSequence priority for printingnvarchar20NUMC(N'00')YesCO_DPRIO Allow NULL? 
35LVO3XIndicator: Print listchar10CHAR(N' ')YesCO_XDRUCK Allow NULL? 
36LV3VSPrint PP shop papers: Print variantnvarchar20NUMC(N'00')YesDRVAR Allow NULL? 
37LV3CSNumber of printoutsnvarchar20NUMC(N'00')YesCO_COPIES Allow NULL? 
38LV03PSequence priority for printingnvarchar20NUMC(N'00')YesCO_DPRIO Allow NULL? 
39LVO4XIndicator: Print listchar10CHAR(N' ')YesCO_XDRUCK Allow NULL? 
40LV4VSPrint PP shop papers: Print variantnvarchar20NUMC(N'00')YesDRVAR Allow NULL? 
41LV4CSNumber of printoutsnvarchar20NUMC(N'00')YesCO_COPIES Allow NULL? 
42LV04PSequence priority for printingnvarchar20NUMC(N'00')YesCO_DPRIO Allow NULL? 
43LFO1XIndicator: Print listchar10CHAR(N' ')YesCO_XDRUCK Allow NULL? 
44LF1VSPrint PP shop papers: Print variantnvarchar20NUMC(N'00')YesDRVAR Allow NULL? 
45LF1CSNumber of printoutsnvarchar20NUMC(N'00')YesCO_COPIES Allow NULL? 
46LF01PSequence priority for printingnvarchar20NUMC(N'00')YesCO_DPRIO Allow NULL? 
47LFO2XIndicator: Print listchar10CHAR(N' ')YesCO_XDRUCK Allow NULL? 
48LF2VSPrint PP shop papers: Print variantnvarchar20NUMC(N'00')YesDRVAR Allow NULL? 
49LF2CSNumber of printoutsnvarchar20NUMC(N'00')YesCO_COPIES Allow NULL? 
50LF02PSequence priority for printingnvarchar20NUMC(N'00')YesCO_DPRIO Allow NULL? 
51LFO3XIndicator: Print listchar10CHAR(N' ')YesCO_XDRUCK Allow NULL? 
52LF3VSPrint PP shop papers: Print variantnvarchar20NUMC(N'00')YesDRVAR Allow NULL? 
53LF3CSNumber of printoutsnvarchar20NUMC(N'00')YesCO_COPIES Allow NULL? 
54LF03PSequence priority for printingnvarchar20NUMC(N'00')YesCO_DPRIO Allow NULL? 
55LFO4XIndicator: Print listchar10CHAR(N' ')YesCO_XDRUCK Allow NULL? 
56LF4VSPrint PP shop papers: Print variantnvarchar20NUMC(N'00')YesDRVAR Allow NULL? 
57LF4CSNumber of printoutsnvarchar20NUMC(N'00')YesCO_COPIES Allow NULL? 
58LF04PSequence priority for printingnvarchar20NUMC(N'00')YesCO_DPRIO Allow NULL? 
59LKO1XIndicator: Print listchar10CHAR(N' ')YesCO_XDRUCK Allow NULL? 
60LK1VSPrint PP shop papers: Print variantnvarchar20NUMC(N'00')YesDRVAR Allow NULL? 
61LK1CSNumber of printoutsnvarchar20NUMC(N'00')YesCO_COPIES Allow NULL? 
62LK01PSequence priority for printingnvarchar20NUMC(N'00')YesCO_DPRIO Allow NULL? 
63LKO2XIndicator: Print listchar10CHAR(N' ')YesCO_XDRUCK Allow NULL? 
64LK2VSPrint PP shop papers: Print variantnvarchar20NUMC(N'00')YesDRVAR Allow NULL? 
65LK2CSNumber of printoutsnvarchar20NUMC(N'00')YesCO_COPIES Allow NULL? 
66LK02PSequence priority for printingnvarchar20NUMC(N'00')YesCO_DPRIO Allow NULL? 
67LKO3XIndicator: Print listchar10CHAR(N' ')YesCO_XDRUCK Allow NULL? 
68LK3VSPrint PP shop papers: Print variantnvarchar20NUMC(N'00')YesDRVAR Allow NULL? 
69LK3CSNumber of printoutsnvarchar20NUMC(N'00')YesCO_COPIES Allow NULL? 
70LK03PSequence priority for printingnvarchar20NUMC(N'00')YesCO_DPRIO Allow NULL? 
71LKO4XIndicator: Print listchar10CHAR(N' ')YesCO_XDRUCK Allow NULL? 
72LK4VSPrint PP shop papers: Print variantnvarchar20NUMC(N'00')YesDRVAR Allow NULL? 
73LK4CSNumber of printoutsnvarchar20NUMC(N'00')YesCO_COPIES Allow NULL? 
74LK04PSequence priority for printingnvarchar20NUMC(N'00')YesCO_DPRIO Allow NULL? 
75LPO1XIndicator: Print listchar10CHAR(N' ')YesCO_XDRUCK Allow NULL? 
76LP1VSPrint PP shop papers: Print variantnvarchar20NUMC(N'00')YesDRVAR Allow NULL? 
77LP1CSNumber of printoutsnvarchar20NUMC(N'00')YesCO_COPIES Allow NULL? 
78LP01PSequence priority for printingnvarchar20NUMC(N'00')YesCO_DPRIO Allow NULL? 
79LPO2XIndicator: Print listchar10CHAR(N' ')YesCO_XDRUCK Allow NULL? 
80LP2VSPrint PP shop papers: Print variantnvarchar20NUMC(N'00')YesDRVAR Allow NULL? 
81LP2CSNumber of printoutsnvarchar20NUMC(N'00')YesCO_COPIES Allow NULL? 
82LP02PSequence priority for printingnvarchar20NUMC(N'00')YesCO_DPRIO Allow NULL? 
83LPO3XIndicator: Print listchar10CHAR(N' ')YesCO_XDRUCK Allow NULL? 
84LP3VSPrint PP shop papers: Print variantnvarchar20NUMC(N'00')YesDRVAR Allow NULL? 
85LP3CSNumber of printoutsnvarchar20NUMC(N'00')YesCO_COPIES Allow NULL? 
86LP03PSequence priority for printingnvarchar20NUMC(N'00')YesCO_DPRIO Allow NULL? 
87LPO4XIndicator: Print listchar10CHAR(N' ')YesCO_XDRUCK Allow NULL? 
88LP4VSPrint PP shop papers: Print variantnvarchar20NUMC(N'00')YesDRVAR Allow NULL? 
89LP4CSNumber of printoutsnvarchar20NUMC(N'00')YesCO_COPIES Allow NULL? 
90LP04PSequence priority for printingnvarchar20NUMC(N'00')YesCO_DPRIO Allow NULL? 
91INFOSIndicator: do not display notification messageschar10CHAR(N' ')YesCO_INFOS Allow NULL? 
NamePrimaryUniqueTypeColumns
T496T~0YesYesCLUSTEREDTCODE, DISPO, WERKS, AUART, AUTYP, 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