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  | /NFM/TORDERPOS
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)
8BSEG345Accounting Document Segment
9/1RA/0SD010MI170Items for Class SD01 - Raw Data
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
8JDT1124Journal Entry - Rows
9OPOR386Purchase Order
10OVTG52Tax Definition

B1 8.8: Top 10 requests

TableColumnsDescription
1ORCT154Incoming Payment
2OITM249Items
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OINM101Whse Journal
7OPCH268A/P Invoice
8JDT1110Journal Entry - Rows
9OOCR9Loading Factors
10OSRN20Serial Numbers Master Data
Industry Specific :: Mill Products Industry Solution :: Non-Ferrous Metal enhancements
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0/NFM/TORDERPOS552Documents: NF Item DataNon-Ferrous Metal enhancements
SQL:  selectupdate insert create

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

SELECT MANDT, BLT, BELNR, POSNR, BUKRS, GJAHR, NES, NFS, KTA, NDT, NMO, NKU, STK, FSP, EDS, EDM, NEB, BWR, BWM, BWA, STB, BCU, BZU, NNO, VGW, VGE, BEI, KPT, BMG, BME, BEM, EIND, BEK, BZS, KZS, BKW, BWB, BKS, NKW, NKN, NKS, KURSK, PRT, BWE, NBD, KPOSN, KGW1, KGU1, EING, KGFE, KGSP, BSL, LOEKZ, VTP_NFS, VTP_NEB FROM /NFM/TORDERPOS
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2BLTNF document categorychar10CHAR(N' ')No/NFM/BLT Allow NULL? 
3BELNRDocument Numbernvarchar100CHAR(N' ')No/NFM/BLN Allow NULL? 
4POSNRDocument Item Numbernvarchar60NUMC(N'000000')No/NFM/PSN Allow NULL? 
5BUKRSCompany Codenvarchar40CHAR(N' ')NoT001BUKRS Allow NULL? 
6GJAHRFiscal Yearnvarchar40NUMC(N'0000')NoGJAHR Allow NULL? 
7NESNF Keynvarchar30CHAR(N' ')No*/NFM/NES Allow NULL? 
8NFSRate Determination Keynvarchar20CHAR(N' ')Yes*/NFM/NFS Allow NULL? 
9KTAActual Rate Date of NF Metalnvarchar80DATS(N'00000000')Yes/NFM/KTA Allow NULL? 
10NDTKey Date for NF Rate Determinationnvarchar80DATS(N'00000000')Yes/NFM/NDT Allow NULL? 
11NMORate Month for NF Metalnvarchar60ACCP(N' ')Yes/NFM/NMO Allow NULL? 
12NKURate in Document Currencydecimal152CURR((0))Yes/NFM/NKU
13STKStatistical Ratechar10CHAR(N' ')Yes/NFM/STK Allow NULL? 
14FSPNF Billing / Invoice Blocknvarchar20CHAR(N' ')Yes*/NFM/FSP Allow NULL? 
15EDSCoverage Key for NF Metalnvarchar100CHAR(N' ')Yes/NFM/EDS Allow NULL? 
16EDMCoverage quantitydecimal153QUAN((0))Yes/NFM/EDM
17NEBBase Keynvarchar20CHAR(N' ')Yes/NFM/NEB Allow NULL? 
18BWRBase Value in Document Currencydecimal152CURR((0))Yes/NFM/BWR
19BWMIndicator: Base Value Changed Manuallychar10CHAR(N' ')Yes/NFM/BWM Allow NULL? 
20BWAOld Base Valuedecimal152CURR((0))Yes/NFM/BWA
21STBStatistical Base Valuechar10CHAR(N' ')Yes/NFM/STB Allow NULL? 
22BCUBase Value Currency Key (Document Currency)nvarchar50CUKY(N' ')YesTCURC/NFM/BCU Allow NULL? 
23BZUPercentage Procurement Surchargedecimal31DEC((0))Yes/NFM/BZU
24NNONet Ratedecimal132CURR((0))Yes/NFM/NNO
25VGWCharge Weight of NF Metal for Each Reference Quantitydecimal153QUAN((0))Yes/NFM/VGW
26VGEReference quantity for charge weightdecimal50DEC((0))Yes/NFM/VGE
27BEIMaterial Provisionchar10CHAR(N' ')Yes/NFM/BEI Allow NULL? 
28KPTIndicator: Rate determination completed (posting allowed)char10CHAR(N' ')Yes/NFM/KPT Allow NULL? 
29BMGBase Quantity for NF Metaldecimal50DEC((0))Yes/NFM/BMG
30BMEBase Unit of Measurenvarchar30UNIT(N' ')YesT006MEINS Allow NULL? 
31BEMProvision Quantitydecimal153QUAN((0))Yes/NFM/BEM
32EINDNF Metal Vendor for Coveragenvarchar100CHAR(N' ')Yes*/NFM/END Allow NULL? 
33BEKNF Metal Providernvarchar100CHAR(N' ')Yes/NFM/BEK Allow NULL? 
34BZSAbsolute surcharge on base valuedecimal152CURR((0))Yes/NFM/BZS
35KZSProvision cash discount for ratedecimal152CURR((0))Yes/NFM/KZS
36BKWBase Value Currency Keynvarchar50CUKY(N' ')YesTCURC/NFM/BKW Allow NULL? 
37BWBBase value in base value currencydecimal152CURR((0))Yes/NFM/BWB
38BKSBase Value Rate for Conversion to Local Currencydecimal95DEC((0))Yes/NFM/BKS
39NKWRate Currency Keynvarchar50CUKY(N' ')YesTCURC/NFM/NKW Allow NULL? 
40NKNRate in Rate Currency (J_1NNCU)decimal132CURR((0))Yes/NFM/NKN
41NKSRate for conversion of rate currency to local currencydecimal95DEC((0))Yes/NFM/NKS
42KURSKExchange Rate for Price Determinationdecimal95DEC((0))YesKURSK
43PRTCS Internal Hex Fieldvarbinary20RAWYes/NFM/PRT
44BWEReporting Base (Uniform Base)decimal152CURR((0))Yes/NFM/BWE
45NBDNumber of Posting Daysnvarchar30NUMC(N'000')Yes/NFM/NBD Allow NULL? 
46KPOSNCondition item numbernvarchar60NUMC(N'000000')YesKPOSN Allow NULL? 
47KGW1Structural Weight of NF Metal for Each Reference Quantitydecimal153QUAN((0))No/NFM/KGW
48KGU1Reference Quantity for Structural Weightdecimal133QUAN((0))No/NFM/KGU
49EINGCoverage Issue Posting for Structural Weightchar10CHAR(N' ')Yes/NFM/EING Allow NULL? 
50KGFEIndicator: Structural weight missingchar10CHAR(N' ')No/NFM/KGFE Allow NULL? 
51KGSPIndicator: Posting block due to missing structural weightchar10CHAR(N' ')Yes/NFM/KGSP Allow NULL? 
52BSLExchange Key for NF Processingnvarchar30CHAR(N' ')Yes/NFM/TBOESL/NFM/BOESL Allow NULL? 
53LOEKZDeletion Indicator in Purchasing Documentchar10CHAR(N' ')YesELOEK Allow NULL? 
54VTP_NFSCS: Default Type for NF Defaultsnvarchar20CHAR(N' ')Yes/NFM/VTP Allow NULL? 
55VTP_NEBCS: Default Type for NF Defaultsnvarchar20CHAR(N' ')Yes/NFM/VTP Allow NULL? 
NamePrimaryUniqueTypeColumns
/NFM/TORDERPOS~0YesYesCLUSTEREDNES, GJAHR, BUKRS, POSNR, BELNR, BLT, MANDT
/NFM/TORDERPOS~J01NoNoNONCLUSTEREDBELNR, 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