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)
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
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
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data
Payroll :: Italy
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0T5ITPOS_B911Data (traceability)Italy
SQL:  selectupdate insert create

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

SELECT MANDT, HASHCODE, HASHSEQNR, C1ZNR_OLD, BUKRS_OLD, GSBER_OLD, KOKRS_OLD, KOSTL_OLD, AUFNR_OLD, KSTRG_OLD, POSNR_OLD, NPLNR_OLD, VORNR_OLD, KDAUF_OLD, KDPOS_OLD, PAOBJNR_OLD, PRZNR_OLD, FISTL_OLD, FIPOS_OLD, GEBER_OLD, EBELN_OLD, EBELP_OLD, LSTNR_OLD, LTLST_OLD, SBUKR_OLD, SGSBR_OLD, SKOST_OLD, LSTAR_OLD, EXBEL_OLD, MWSKZ_OLD, OTYPE_OLD, STELL_OLD, POHRS_OLD, DART_OLD, UDART_OLD, SGTXT_OLD, TXJCD_OLD, FIPEX_OLD, FKBER_OLD, GRANT_NBR_OLD, SGEBER_OLD, SFKBER_OLD, SGRANT_NBR_OLD, SEGMENT_OLD, SSEGMENT_OLD, BUDGET_PD_OLD, SBUDGET_PD_OLD, C1ZNR_NEW, BUKRS_NEW, GSBER_NEW, KOKRS_NEW, KOSTL_NEW, AUFNR_NEW, KSTRG_NEW, POSNR_NEW, NPLNR_NEW, VORNR_NEW, KDAUF_NEW, KDPOS_NEW, PAOBJNR_NEW, PRZNR_NEW, FISTL_NEW, FIPOS_NEW, GEBER_NEW, EBELN_NEW, EBELP_NEW, LSTNR_NEW, LTLST_NEW, SBUKR_NEW, SGSBR_NEW, SKOST_NEW, LSTAR_NEW, EXBEL_NEW, MWSKZ_NEW, OTYPE_NEW, STELL_NEW, POHRS_NEW, DART_NEW, UDART_NEW, SGTXT_NEW, TXJCD_NEW, FIPEX_NEW, FKBER_NEW, GRANT_NBR_NEW, SGEBER_NEW, SFKBER_NEW, SGRANT_NBR_NEW, SEGMENT_NEW, SSEGMENT_NEW, BUDGET_PD_NEW, SBUDGET_PD_NEW FROM T5ITPOS_B
ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1MANDTClientnvarchar30 Allow NULL? 
2HASHCODEnvarchar160 Allow NULL? 
3HASHSEQNRnvarchar40 Allow NULL? 
4C1ZNR_OLDPointer to cost accountingvarbinary20
5BUKRS_OLDCompany Codenvarchar40 Allow NULL? 
6GSBER_OLDBusiness Areanvarchar40 Allow NULL? 
7KOKRS_OLDControlling Areanvarchar40 Allow NULL? 
8KOSTL_OLDCost Centernvarchar100 Allow NULL? 
9AUFNR_OLDOrder Numbernvarchar120 Allow NULL? 
10KSTRG_OLDCost Objectnvarchar120 Allow NULL? 
11POSNR_OLDWork Breakdown Structure Element (WBS Element)nvarchar80 Allow NULL? 
12NPLNR_OLDNetwork Number for Account Assignmentnvarchar120 Allow NULL? 
13VORNR_OLDOperation/Activity Numbernvarchar40 Allow NULL? 
14KDAUF_OLDSales Order Numbernvarchar100 Allow NULL? 
15KDPOS_OLDItem Number in Sales Ordernvarchar60 Allow NULL? 
16PAOBJNR_OLDProfitability Segment Number (CO-PA)nvarchar100 Allow NULL? 
17PRZNR_OLDBusiness Processnvarchar120 Allow NULL? 
18FISTL_OLDFunds Centernvarchar160 Allow NULL? 
19FIPOS_OLDCommitment Itemnvarchar140 Allow NULL? 
20GEBER_OLDFundnvarchar100 Allow NULL? 
21EBELN_OLDPurchasing Document Numbernvarchar100 Allow NULL? 
22EBELP_OLDItem Number of Purchasing Documentnvarchar50 Allow NULL? 
23LSTNR_OLDActivity Numbernvarchar180 Allow NULL? 
24LTLST_OLDActivity Typenvarchar60 Allow NULL? 
25SBUKR_OLDCompany Codenvarchar40 Allow NULL? 
26SGSBR_OLDBusiness Areanvarchar40 Allow NULL? 
27SKOST_OLDCost Centernvarchar100 Allow NULL? 
28LSTAR_OLDActivity Typenvarchar60 Allow NULL? 
29EXBEL_OLDAssignment numbernvarchar180 Allow NULL? 
30MWSKZ_OLDTax on sales/purchases codenvarchar20 Allow NULL? 
31OTYPE_OLDObject Typenvarchar20 Allow NULL? 
32STELL_OLDJobnvarchar80 Allow NULL? 
33POHRS_OLDNumber of Hours for Activity Allocation/External Servicesdecimal72
34DART_OLDService Type (Public Service Germany)nvarchar20 Allow NULL? 
35UDART_OLDService Category (Public Service Germany)nvarchar20 Allow NULL? 
36SGTXT_OLDItem Textnvarchar500 Allow NULL? 
37TXJCD_OLDTax Jurisdictionnvarchar150 Allow NULL? 
38FIPEX_OLDCommitment Itemnvarchar240 Allow NULL? 
39FKBER_OLDFunctional Areanvarchar160 Allow NULL? 
40GRANT_NBR_OLDGrantnvarchar200 Allow NULL? 
41SGEBER_OLDSender fundnvarchar100 Allow NULL? 
42SFKBER_OLDSending Functional Areanvarchar160 Allow NULL? 
43SGRANT_NBR_OLDSender Grantnvarchar200 Allow NULL? 
44SEGMENT_OLDSegment for Segmental Reportingnvarchar100 Allow NULL? 
45SSEGMENT_OLDSegment for Segmental Reportingnvarchar100 Allow NULL? 
46BUDGET_PD_OLDFM: Budget Periodnvarchar100 Allow NULL? 
47SBUDGET_PD_OLDFM: Sender Budget Periodnvarchar100 Allow NULL? 
48C1ZNR_NEWPointer to cost accountingvarbinary20
49BUKRS_NEWCompany Codenvarchar40 Allow NULL? 
50GSBER_NEWBusiness Areanvarchar40 Allow NULL? 
51KOKRS_NEWControlling Areanvarchar40 Allow NULL? 
52KOSTL_NEWCost Centernvarchar100 Allow NULL? 
53AUFNR_NEWOrder Numbernvarchar120 Allow NULL? 
54KSTRG_NEWCost Objectnvarchar120 Allow NULL? 
55POSNR_NEWWork Breakdown Structure Element (WBS Element)nvarchar80 Allow NULL? 
56NPLNR_NEWNetwork Number for Account Assignmentnvarchar120 Allow NULL? 
57VORNR_NEWOperation/Activity Numbernvarchar40 Allow NULL? 
58KDAUF_NEWSales Order Numbernvarchar100 Allow NULL? 
59KDPOS_NEWItem Number in Sales Ordernvarchar60 Allow NULL? 
60PAOBJNR_NEWProfitability Segment Number (CO-PA)nvarchar100 Allow NULL? 
61PRZNR_NEWBusiness Processnvarchar120 Allow NULL? 
62FISTL_NEWFunds Centernvarchar160 Allow NULL? 
63FIPOS_NEWCommitment Itemnvarchar140 Allow NULL? 
64GEBER_NEWFundnvarchar100 Allow NULL? 
65EBELN_NEWPurchasing Document Numbernvarchar100 Allow NULL? 
66EBELP_NEWItem Number of Purchasing Documentnvarchar50 Allow NULL? 
67LSTNR_NEWActivity Numbernvarchar180 Allow NULL? 
68LTLST_NEWActivity Typenvarchar60 Allow NULL? 
69SBUKR_NEWCompany Codenvarchar40 Allow NULL? 
70SGSBR_NEWBusiness Areanvarchar40 Allow NULL? 
71SKOST_NEWCost Centernvarchar100 Allow NULL? 
72LSTAR_NEWActivity Typenvarchar60 Allow NULL? 
73EXBEL_NEWAssignment numbernvarchar180 Allow NULL? 
74MWSKZ_NEWTax on sales/purchases codenvarchar20 Allow NULL? 
75OTYPE_NEWObject Typenvarchar20 Allow NULL? 
76STELL_NEWJobnvarchar80 Allow NULL? 
77POHRS_NEWNumber of Hours for Activity Allocation/External Servicesdecimal72
78DART_NEWService Type (Public Service Germany)nvarchar20 Allow NULL? 
79UDART_NEWService Category (Public Service Germany)nvarchar20 Allow NULL? 
80SGTXT_NEWItem Textnvarchar500 Allow NULL? 
81TXJCD_NEWTax Jurisdictionnvarchar150 Allow NULL? 
82FIPEX_NEWCommitment Itemnvarchar240 Allow NULL? 
83FKBER_NEWFunctional Areanvarchar160 Allow NULL? 
84GRANT_NBR_NEWGrantnvarchar200 Allow NULL? 
85SGEBER_NEWSender fundnvarchar100 Allow NULL? 
86SFKBER_NEWSending Functional Areanvarchar160 Allow NULL? 
87SGRANT_NBR_NEWSender Grantnvarchar200 Allow NULL? 
88SEGMENT_NEWSegment for Segmental Reportingnvarchar100 Allow NULL? 
89SSEGMENT_NEWSegment for Segmental Reportingnvarchar100 Allow NULL? 
90BUDGET_PD_NEWFM: Budget Periodnvarchar100 Allow NULL? 
91SBUDGET_PD_NEWFM: Sender Budget Periodnvarchar100 Allow NULL? 
NamePrimaryUniqueTypeColumns
T5ITPOS_B~0YesYesCLUSTEREDHASHSEQNR, HASHCODE, MANDT