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  | TXW_S_MSEG
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
Cross-Application Components :: General Application Functions :: Data Retention Tool
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0TXW_S_MSEG631Retrieve MSEG from archiveData Retention Tool
SQL:  selectupdate insert create

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

SELECT TXW_MANDT, TXW_MBLNR, TXW_MJAHR, TXW_ZEILE, MANDT, BUKRS, GJAHR, MBLNR, MJAHR, ZEILE, MONAT, BWART, MATNR, WERKS, LGORT, CHARG, EBELN, EBELP, SHKZG, DMBTR, MEINS, MENGE, BWTAR, SAKTO, LIFNR, KUNNR, GSBER, ANLN1, ANLN2, AUFNR, EMLIF, FKBER, GRUND, KDAUF, KDEIN, KDPOS, KOKRS, KOSTL, KZBEW, NPLNR, PARBU, PARGB, PPRCTR, PRCTR, PROJN, WBS_POSID, PS_PSP_PNR, SGTXT, SHKUM, SOBKZ, UMMAT, UMWRK, VPTNR, WAERS, WEUNB, XRUEJ, XRUEM, BNBTR, DMBUM, LBKUM, SALK3, KZZUG, KZVBR FROM TXW_S_MSEG
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1TXW_MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2TXW_MBLNRNumber of Material Documentnvarchar100CHAR(N' ')NoMBLNR Allow NULL? 
3TXW_MJAHRMaterial Document Yearnvarchar40NUMC(N'0000')NoMJAHR Allow NULL? 
4TXW_ZEILEItem in Material Documentnvarchar40NUMC(N'0000')NoMBLPO Allow NULL? 
5MANDTClientnvarchar30CLNT(N'000')Yes*MANDT Allow NULL? 
6BUKRSCompany Codenvarchar40CHAR(N' ')Yes*BUKRS Allow NULL? 
7GJAHRFiscal Yearnvarchar40NUMC(N'0000')YesGJAHR Allow NULL? 
8MBLNRNumber of Material Documentnvarchar100CHAR(N' ')YesMBLNR Allow NULL? 
9MJAHRMaterial Document Yearnvarchar40NUMC(N'0000')YesMJAHR Allow NULL? 
10ZEILEItem in Material Documentnvarchar40NUMC(N'0000')YesMBLPO Allow NULL? 
11MONATFiscal Periodnvarchar20NUMC(N'00')YesMONAT Allow NULL? 
12BWARTMovement Type (Inventory Management)nvarchar30CHAR(N' ')Yes*BWART Allow NULL? 
13MATNRMaterial Numbernvarchar180CHAR(N' ')Yes*MATNR Allow NULL? 
14WERKSPlantnvarchar40CHAR(N' ')Yes*WERKS_D Allow NULL? 
15LGORTStorage Locationnvarchar40CHAR(N' ')Yes*LGORT_D Allow NULL? 
16CHARGBatch Numbernvarchar100CHAR(N' ')Yes*CHARG_D Allow NULL? 
17EBELNPurchasing Document Numbernvarchar100CHAR(N' ')Yes*EBELN Allow NULL? 
18EBELPItem Number of Purchasing Documentnvarchar50NUMC(N'00000')Yes*EBELP Allow NULL? 
19SHKZGDebit/Credit Indicatorchar10CHAR(N' ')YesSHKZG Allow NULL? 
20DMBTRAmount in Local Currencynvarchar160CHAR(N' ')YesTXW_DMBTR Allow NULL? 
21MEINSBase Unit of Measurenvarchar30UNIT(N' ')Yes*MEINS Allow NULL? 
22MENGETotal quantitynvarchar160CHAR(N' ')YesTXW_QUANT Allow NULL? 
23BWTARValuation Typenvarchar100CHAR(N' ')Yes*BWTAR_D Allow NULL? 
24SAKTOCost elementnvarchar100CHAR(N' ')Yes*SAKTO Allow NULL? 
25LIFNRAccount Number of Vendor or Creditornvarchar100CHAR(N' ')Yes*LIFNR Allow NULL? 
26KUNNRCustomer Numbernvarchar100CHAR(N' ')Yes*KUNNR Allow NULL? 
27GSBERBusiness Areanvarchar40CHAR(N' ')Yes*GSBER Allow NULL? 
28ANLN1Main Asset Numbernvarchar120CHAR(N' ')Yes*ANLN1 Allow NULL? 
29ANLN2Asset Subnumbernvarchar40CHAR(N' ')Yes*ANLN2 Allow NULL? 
30AUFNROrder Numbernvarchar120CHAR(N' ')Yes*AUFNR Allow NULL? 
31EMLIFVendor to be supplied/who is to receive deliverynvarchar100CHAR(N' ')Yes*EMLIF Allow NULL? 
32FKBERFunctional Areanvarchar160CHAR(N' ')Yes*FKBER Allow NULL? 
33GRUNDReason for manual valuation of net assetsnvarchar30CHAR(N' ')Yes*GRUND Allow NULL? 
34KDAUFSales Order Numbernvarchar100CHAR(N' ')Yes*KDAUF Allow NULL? 
35KDEINDelivery Schedule for Sales Ordernvarchar40NUMC(N'0000')YesKDEIN Allow NULL? 
36KDPOSItem Number in Sales Ordernvarchar60NUMC(N'000000')YesKDPOS Allow NULL? 
37KOKRSControlling Areanvarchar40CHAR(N' ')Yes*KOKRS Allow NULL? 
38KOSTLCost Centernvarchar100CHAR(N' ')Yes*KOSTL Allow NULL? 
39KZBEWMovement Indicatorchar10CHAR(N' ')YesKZBEW Allow NULL? 
40NPLNRNetwork Number for Account Assignmentnvarchar120CHAR(N' ')Yes*NPLNR Allow NULL? 
41PARBUClearing company codenvarchar40CHAR(N' ')Yes*PARBU Allow NULL? 
42PARGBTrading partner's business areanvarchar40CHAR(N' ')Yes*PARGB Allow NULL? 
43PPRCTRPartner Profit Centernvarchar100CHAR(N' ')Yes*PPRCTR Allow NULL? 
44PRCTRProfit Centernvarchar100CHAR(N' ')Yes*PRCTR Allow NULL? 
45PROJNOld: Project number : No longer used --> PS_POSNRnvarchar160CHAR(N' ')YesPROJN Allow NULL? 
46WBS_POSIDWork Breakdown Structure Element (WBS Element)nvarchar240CHAR(N' ')YesPS_POSID Allow NULL? 
47PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80NUMC(N'00000000')Yes*PS_PSP_PNR Allow NULL? 
48SGTXTItem Textnvarchar500CHAR(N' ')YesSGTXT Allow NULL? 
49SHKUMDebit/credit indicator in revaluationchar10CHAR(N' ')YesSHKUM Allow NULL? 
50SOBKZSpecial Stock Indicatorchar10CHAR(N' ')Yes*SOBKZ Allow NULL? 
51UMMATReceiving/Issuing Materialnvarchar180CHAR(N' ')Yes*UMMAT Allow NULL? 
52UMWRKReceiving/Issuing Plantnvarchar40CHAR(N' ')Yes*UMWRK Allow NULL? 
53VPTNRPartner account numbernvarchar100CHAR(N' ')Yes*JV_PART Allow NULL? 
54WAERSCurrency Keynvarchar50CUKY(N' ')Yes*WAERS Allow NULL? 
55WEUNBGoods Receipt, Non-Valuatedchar10CHAR(N' ')YesWEUNB Allow NULL? 
56XRUEJIndicator: post to previous yearchar10CHAR(N' ')YesXRUEJ Allow NULL? 
57XRUEMAllow Posting to Previous Period (Backposting)char10CHAR(N' ')YesXRUEM Allow NULL? 
58BNBTRDelivery costs in LCnvarchar160CHAR(N' ')YesTXW_BNBTR Allow NULL? 
59DMBUMRevaluation amount on back-posting to previous periodnvarchar160CHAR(N' ')YesTXW_DMBUM Allow NULL? 
60LBKUMTotal valuated stocknvarchar160CHAR(N' ')YesTXW_LBKUM Allow NULL? 
61SALK3Value of total of valuated stocknvarchar160CHAR(N' ')YesTXW_SALK3 Allow NULL? 
62KZZUGReceipt Indicatorchar10CHAR(N' ')YesKZZUG Allow NULL? 
63KZVBRConsumption Postingchar10CHAR(N' ')YesKZVBR Allow NULL? 
NamePrimaryUniqueTypeColumns
TXW_S_MSEG~0YesYesCLUSTEREDTXW_MANDT, TXW_MBLNR, TXW_MJAHR, TXW_ZEILE

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