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
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
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 TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2HASHCODEnvarchar160(N'0000000000000000')Yes Allow NULL? 
3HASHSEQNRnvarchar40(N'0000')Yes Allow NULL? 
4C1ZNR_OLDPointer to cost accountingvarbinary20RAWYesC1ZNO
5BUKRS_OLDCompany Codenvarchar40CHAR(N' ')Yes*BUKRS Allow NULL? 
6GSBER_OLDBusiness Areanvarchar40CHAR(N' ')Yes*GSBER Allow NULL? 
7KOKRS_OLDControlling Areanvarchar40CHAR(N' ')Yes*KOKRS Allow NULL? 
8KOSTL_OLDCost Centernvarchar100CHAR(N' ')Yes*KOSTL Allow NULL? 
9AUFNR_OLDOrder Numbernvarchar120CHAR(N' ')Yes*AUFNR Allow NULL? 
10KSTRG_OLDCost Objectnvarchar120CHAR(N' ')Yes*KSTRG Allow NULL? 
11POSNR_OLDWork Breakdown Structure Element (WBS Element)nvarchar80NUMC(N'00000000')Yes*PS_PSP_PNR Allow NULL? 
12NPLNR_OLDNetwork Number for Account Assignmentnvarchar120CHAR(N' ')Yes*NPLNR Allow NULL? 
13VORNR_OLDOperation/Activity Numbernvarchar40CHAR(N' ')YesVORNR Allow NULL? 
14KDAUF_OLDSales Order Numbernvarchar100CHAR(N' ')Yes*KDAUF Allow NULL? 
15KDPOS_OLDItem Number in Sales Ordernvarchar60NUMC(N'000000')YesKDPOS Allow NULL? 
16PAOBJNR_OLDProfitability Segment Number (CO-PA)nvarchar100NUMC(N'0000000000')YesRKEOBJNR Allow NULL? 
17PRZNR_OLDBusiness Processnvarchar120CHAR(N' ')Yes*CO_PRZNR Allow NULL? 
18FISTL_OLDFunds Centernvarchar160CHAR(N' ')Yes*FISTL Allow NULL? 
19FIPOS_OLDCommitment Itemnvarchar140CHAR(N' ')Yes*FIPOS Allow NULL? 
20GEBER_OLDFundnvarchar100CHAR(N' ')Yes*BP_GEBER Allow NULL? 
21EBELN_OLDPurchasing Document Numbernvarchar100CHAR(N' ')Yes*EBELN Allow NULL? 
22EBELP_OLDItem Number of Purchasing Documentnvarchar50NUMC(N'00000')Yes*EBELP Allow NULL? 
23LSTNR_OLDActivity Numbernvarchar180CHAR(N' ')Yes*ASNUM Allow NULL? 
24LTLST_OLDActivity Typenvarchar60CHAR(N' ')Yes*LSTAR Allow NULL? 
25SBUKR_OLDCompany Codenvarchar40CHAR(N' ')Yes*BUKRS Allow NULL? 
26SGSBR_OLDBusiness Areanvarchar40CHAR(N' ')Yes*GSBER Allow NULL? 
27SKOST_OLDCost Centernvarchar100CHAR(N' ')Yes*KOSTL Allow NULL? 
28LSTAR_OLDActivity Typenvarchar60CHAR(N' ')Yes*LSTAR Allow NULL? 
29EXBEL_OLDAssignment numbernvarchar180CHAR(N' ')YesHR_ZUONR Allow NULL? 
30MWSKZ_OLDTax on sales/purchases codenvarchar20CHAR(N' ')Yes*MWSKZ Allow NULL? 
31OTYPE_OLDObject Typenvarchar20CHAR(N' ')Yes*OTYPE Allow NULL? 
32STELL_OLDJobnvarchar80NUMC(N'00000000')Yes*STELL Allow NULL? 
33POHRS_OLDNumber of Hours for Activity Allocation/External Servicesdecimal72DEC((0))YesPOHRS
34DART_OLDService Type (Public Service Germany)nvarchar20CHAR(N' ')Yes*DART Allow NULL? 
35UDART_OLDService Category (Public Service Germany)nvarchar20CHAR(N' ')Yes*UDART Allow NULL? 
36SGTXT_OLDItem Textnvarchar500CHAR(N' ')YesSGTXT Allow NULL? 
37TXJCD_OLDTax Jurisdictionnvarchar150CHAR(N' ')Yes*TXJCD Allow NULL? 
38FIPEX_OLDCommitment Itemnvarchar240CHAR(N' ')Yes*FM_FIPEX Allow NULL? 
39FKBER_OLDFunctional Areanvarchar160CHAR(N' ')Yes*FKBER Allow NULL? 
40GRANT_NBR_OLDGrantnvarchar200CHAR(N' ')YesGM_GRANT_NBR Allow NULL? 
41SGEBER_OLDSender fundnvarchar100CHAR(N' ')Yes*FM_SFONDS Allow NULL? 
42SFKBER_OLDSending Functional Areanvarchar160CHAR(N' ')Yes*SFKTBER Allow NULL? 
43SGRANT_NBR_OLDSender Grantnvarchar200CHAR(N' ')YesGM_GRANT_SENDER Allow NULL? 
44SEGMENT_OLDSegment for Segmental Reportingnvarchar100CHAR(N' ')Yes*FB_SEGMENT Allow NULL? 
45SSEGMENT_OLDSegment for Segmental Reportingnvarchar100CHAR(N' ')Yes*FB_SEGMENT Allow NULL? 
46BUDGET_PD_OLDFM: Budget Periodnvarchar100CHAR(N' ')Yes*FM_BUDGET_PERIOD Allow NULL? 
47SBUDGET_PD_OLDFM: Sender Budget Periodnvarchar100CHAR(N' ')Yes*FM_SBUDGET_PERIOD Allow NULL? 
48C1ZNR_NEWPointer to cost accountingvarbinary20RAWYesC1ZNO
49BUKRS_NEWCompany Codenvarchar40CHAR(N' ')Yes*BUKRS Allow NULL? 
50GSBER_NEWBusiness Areanvarchar40CHAR(N' ')Yes*GSBER Allow NULL? 
51KOKRS_NEWControlling Areanvarchar40CHAR(N' ')Yes*KOKRS Allow NULL? 
52KOSTL_NEWCost Centernvarchar100CHAR(N' ')Yes*KOSTL Allow NULL? 
53AUFNR_NEWOrder Numbernvarchar120CHAR(N' ')Yes*AUFNR Allow NULL? 
54KSTRG_NEWCost Objectnvarchar120CHAR(N' ')Yes*KSTRG Allow NULL? 
55POSNR_NEWWork Breakdown Structure Element (WBS Element)nvarchar80NUMC(N'00000000')Yes*PS_PSP_PNR Allow NULL? 
56NPLNR_NEWNetwork Number for Account Assignmentnvarchar120CHAR(N' ')Yes*NPLNR Allow NULL? 
57VORNR_NEWOperation/Activity Numbernvarchar40CHAR(N' ')YesVORNR Allow NULL? 
58KDAUF_NEWSales Order Numbernvarchar100CHAR(N' ')Yes*KDAUF Allow NULL? 
59KDPOS_NEWItem Number in Sales Ordernvarchar60NUMC(N'000000')YesKDPOS Allow NULL? 
60PAOBJNR_NEWProfitability Segment Number (CO-PA)nvarchar100NUMC(N'0000000000')YesRKEOBJNR Allow NULL? 
61PRZNR_NEWBusiness Processnvarchar120CHAR(N' ')Yes*CO_PRZNR Allow NULL? 
62FISTL_NEWFunds Centernvarchar160CHAR(N' ')Yes*FISTL Allow NULL? 
63FIPOS_NEWCommitment Itemnvarchar140CHAR(N' ')Yes*FIPOS Allow NULL? 
64GEBER_NEWFundnvarchar100CHAR(N' ')Yes*BP_GEBER Allow NULL? 
65EBELN_NEWPurchasing Document Numbernvarchar100CHAR(N' ')Yes*EBELN Allow NULL? 
66EBELP_NEWItem Number of Purchasing Documentnvarchar50NUMC(N'00000')Yes*EBELP Allow NULL? 
67LSTNR_NEWActivity Numbernvarchar180CHAR(N' ')Yes*ASNUM Allow NULL? 
68LTLST_NEWActivity Typenvarchar60CHAR(N' ')Yes*LSTAR Allow NULL? 
69SBUKR_NEWCompany Codenvarchar40CHAR(N' ')Yes*BUKRS Allow NULL? 
70SGSBR_NEWBusiness Areanvarchar40CHAR(N' ')Yes*GSBER Allow NULL? 
71SKOST_NEWCost Centernvarchar100CHAR(N' ')Yes*KOSTL Allow NULL? 
72LSTAR_NEWActivity Typenvarchar60CHAR(N' ')Yes*LSTAR Allow NULL? 
73EXBEL_NEWAssignment numbernvarchar180CHAR(N' ')YesHR_ZUONR Allow NULL? 
74MWSKZ_NEWTax on sales/purchases codenvarchar20CHAR(N' ')Yes*MWSKZ Allow NULL? 
75OTYPE_NEWObject Typenvarchar20CHAR(N' ')Yes*OTYPE Allow NULL? 
76STELL_NEWJobnvarchar80NUMC(N'00000000')Yes*STELL Allow NULL? 
77POHRS_NEWNumber of Hours for Activity Allocation/External Servicesdecimal72DEC((0))YesPOHRS
78DART_NEWService Type (Public Service Germany)nvarchar20CHAR(N' ')Yes*DART Allow NULL? 
79UDART_NEWService Category (Public Service Germany)nvarchar20CHAR(N' ')Yes*UDART Allow NULL? 
80SGTXT_NEWItem Textnvarchar500CHAR(N' ')YesSGTXT Allow NULL? 
81TXJCD_NEWTax Jurisdictionnvarchar150CHAR(N' ')Yes*TXJCD Allow NULL? 
82FIPEX_NEWCommitment Itemnvarchar240CHAR(N' ')Yes*FM_FIPEX Allow NULL? 
83FKBER_NEWFunctional Areanvarchar160CHAR(N' ')Yes*FKBER Allow NULL? 
84GRANT_NBR_NEWGrantnvarchar200CHAR(N' ')YesGM_GRANT_NBR Allow NULL? 
85SGEBER_NEWSender fundnvarchar100CHAR(N' ')Yes*FM_SFONDS Allow NULL? 
86SFKBER_NEWSending Functional Areanvarchar160CHAR(N' ')Yes*SFKTBER Allow NULL? 
87SGRANT_NBR_NEWSender Grantnvarchar200CHAR(N' ')YesGM_GRANT_SENDER Allow NULL? 
88SEGMENT_NEWSegment for Segmental Reportingnvarchar100CHAR(N' ')Yes*FB_SEGMENT Allow NULL? 
89SSEGMENT_NEWSegment for Segmental Reportingnvarchar100CHAR(N' ')Yes*FB_SEGMENT Allow NULL? 
90BUDGET_PD_NEWFM: Budget Periodnvarchar100CHAR(N' ')Yes*FM_BUDGET_PERIOD Allow NULL? 
91SBUDGET_PD_NEWFM: Sender Budget Periodnvarchar100CHAR(N' ')Yes*FM_SBUDGET_PERIOD Allow NULL? 
NamePrimaryUniqueTypeColumns
T5ITPOS_B~0YesYesCLUSTEREDHASHSEQNR, HASHCODE, MANDT