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  | MDSM
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
Production Planning and Control :: Material Requirements Planning :: Master Data
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0MDSM1032Simulative dependent requirementsMaster Data
SQL:  selectupdate insert create

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

SELECT MANDT, SBNUM, SBPOS, SBART, AUFST, AUFWG, POSNR, SORTF, PLSCN, MATNR, WERKS, LGORT, PRVBE, BDART, POSTP, UPSKZ, SCHGT, TXTPS, INPOS, DUMPS, KFPOS, NODSP, DBSKZ, BDMNG, MEINS, ESMNG, SHKZG, BEIKZ, ERSKZ, ERFMG, ERFME, UMREZ, UMREN, FMENG, ALPOS, EWAHR, ALPGR, ALPRF, ALPST, AUSCH, AVOAU, NETAU, BDTER, SBTER, VERTI, NLFZT, BDZTP, ROHPS, ROANZ, ROMEN, ROMEI, ROMS1, ROMS2, ROMS3, RFORM, CUOBJ, NFPKZ, KZAUS, NFEAG, NFGRP, NAFKZ, NOMNG, NOMAT, NFUML, LTXSP, POTX1, POTX2, PLNUM, BAUGR, BAUST, BAUWG, SERNR, AENNR, REVLV, STLTY, STLNR, STLKN, STPOZ, OBJNR, FLGAT, PLNFL, VORNR, APLZL, STVKN, VRPLA, PBDNR, KNTTP, SOBKZ, KZVBR, KDAUF, KDPOS, KDEIN, PSPEL, CLAKZ, SANKA, KZKUP, STLAL, TECHS, LIFNR, EDGNO, NLFZV, NLFMV, KZBWS FROM MDSM
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2SBNUMSimulation requirements numbernvarchar100NUMC(N'0000000000')NoSBNUM Allow NULL? 
3SBPOSSimulation requirements item numbernvarchar40NUMC(N'0000')NoSBPOS Allow NULL? 
4SBARTRecord typechar10CHAR(N' ')NoRSART Allow NULL? 
5AUFSTOrder levelnvarchar20NUMC(N'00')NoAUFST Allow NULL? 
6AUFWGOrder pathnvarchar20NUMC(N'00')NoAUFWG Allow NULL? 
7POSNRBOM item numbernvarchar40CHAR(N' ')NoAPOSN Allow NULL? 
8SORTFSort Stringnvarchar100CHAR(N' ')NoSORTP Allow NULL? 
9PLSCNPlanning Scenario of Long-Term Planningnvarchar30NUMC(N'000')NoPLSCPLSCN Allow NULL? 
10MATNRMaterial Numbernvarchar180CHAR(N' ')NoMARAMATNR Allow NULL? 
11WERKSPlantnvarchar40CHAR(N' ')NoT001WWERKS_D Allow NULL? 
12LGORTStorage Locationnvarchar40CHAR(N' ')NoT001LLGORT_D Allow NULL? 
13PRVBEProduction Supply Areanvarchar100CHAR(N' ')NoPVBEPRVBE Allow NULL? 
14BDARTRequirement typenvarchar20CHAR(N' ')NoBDART Allow NULL? 
15POSTPItem Category (Bill of Material)char10CHAR(N' ')NoT418POSTP Allow NULL? 
16UPSKZIndicator: sub-items existchar10CHAR(N' ')NoUPSKZ Allow NULL? 
17SCHGTIndicator: Bulk Materialchar10CHAR(N' ')NoSCHGT Allow NULL? 
18TXTPSItem text indicatorchar10CHAR(N' ')NoTXTPS Allow NULL? 
19INPOSIndicator: intra materialchar10CHAR(N' ')NoINPOS Allow NULL? 
20DUMPSPhantom item indicatorchar10CHAR(N' ')NoDUMPS Allow NULL? 
21KFPOSIndicator: "configurable item"char10CHAR(N' ')NoKFPOS Allow NULL? 
22NODSPInd: Reserv. not applicable to MRP;Purc. req. not createdchar10CHAR(N' ')NoNODISP Allow NULL? 
23DBSKZDirect procurement indicatorchar10CHAR(N' ')NoDBSKZ Allow NULL? 
24BDMNGRequirement Quantitydecimal133QUAN((0))NoBDMNG
25MEINSBase Unit of Measurenvarchar30UNIT(N' ')NoT006MEINS Allow NULL? 
26ESMNGUsage quantity per order unit of measurefloat1516FLTP((0))NoESMNG
27SHKZGDebit/Credit Indicatorchar10CHAR(N' ')NoSHKZG Allow NULL? 
28BEIKZMaterial Provision Indicatorchar10CHAR(N' ')NoT417BEIKZ Allow NULL? 
29ERSKZIndicator: spare partchar10CHAR(N' ')NoT413ERSKZ Allow NULL? 
30ERFMGQuantity in Unit of Entrydecimal133QUAN((0))NoERFMG
31ERFMEUnit of Entrynvarchar30UNIT(N' ')NoT006ERFME Allow NULL? 
32UMREZNumerator for Conversion to Base Units of Measuredecimal50DEC((0))NoUMREZ
33UMRENDenominator for conversion to base units of measuredecimal50DEC((0))NoUMREN
34FMENGQuantity is Fixedchar10CHAR(N' ')NoFMENG Allow NULL? 
35ALPOSAlternative item indicatorchar10CHAR(N' ')NoALTPS Allow NULL? 
36EWAHRUsage probability in % (alternative item)decimal30DEC((0))NoEWAHR
37ALPGRAlternative item: groupnvarchar20CHAR(N' ')NoCS_ALPGR Allow NULL? 
38ALPRFAlternative item: ranking ordernvarchar20NUMC(N'00')NoCS_ALPRF Allow NULL? 
39ALPSTAlternative item: strategychar10CHAR(N' ')NoCS_ALPST Allow NULL? 
40AUSCHComponent scrap in percentdecimal52DEC((0))NoKAUSF
41AVOAUOperation scrapdecimal52DEC((0))NoAVOAU
42NETAUIndicator: Net scrapchar10CHAR(N' ')NoNETAU Allow NULL? 
43BDTERRequirement Date for the Componentnvarchar80DATS(N'00000000')NoBDTER Allow NULL? 
44SBTERLatest requirements datenvarchar80DATS(N'00000000')NoSBTER Allow NULL? 
45VERTIMRP Distribution Keynvarchar40CHAR(N' ')No*SA_VERTL Allow NULL? 
46NLFZTLead-time offsetdecimal30DEC((0))NoNLFZT
47BDZTPTime that reservation quantity requirednvarchar60TIMS(N'000000')NoBDZTP Allow NULL? 
48ROHPSVariable-sized item indicatorchar10CHAR(N' ')NoROHPS Allow NULL? 
49ROANZNumber of variable-size itemsdecimal133QUAN((0))NoROANZ
50ROMENQuantity of variable-size itemdecimal133QUAN((0))NoROMEN
51ROMEIUnit of measure for sizes 1 to 3nvarchar30UNIT(N' ')NoT006ROMEI Allow NULL? 
52ROMS1Size 1decimal133QUAN((0))NoROMS1
53ROMS2Size 2decimal133QUAN((0))NoROMS2
54ROMS3Size 3decimal133QUAN((0))NoROMS3
55RFORMFormula keynvarchar20CHAR(N' ')NoT418FRFORM Allow NULL? 
56CUOBJConfiguration (internal object number)nvarchar180NUMC(N'000000000000000000')NoCUOBJ Allow NULL? 
57NFPKZIndicator: Follow-Up Itemchar10CHAR(N' ')NoCS_KZNFP Allow NULL? 
58KZAUSDiscontinuation indicatorchar10CHAR(N' ')NoKZAUS Allow NULL? 
59NFEAGDiscontinuation groupnvarchar20CHAR(N' ')NoCS_NFEAG Allow NULL? 
60NFGRPFollow-up groupnvarchar20CHAR(N' ')NoCS_NFGRP Allow NULL? 
61NAFKZIndicator: follow-up material active/not activechar10CHAR(N' ')NoNAFKZ Allow NULL? 
62NOMNGRequired quantitydecimal133QUAN((0))NoNOMNG
63NOMATFollow-Up/Original Materialnvarchar180CHAR(N' ')No*NOMAT Allow NULL? 
64NFUMLNOT USED: Quantity transfer factor for follow-up materialdecimal54DEC((0))NoNFUML
65LTXSPLanguage: The long text was stored in this languagechar10LANG(N' ')NoT002LTXSP Allow NULL? 
66POTX1BOM Item Text (Line 1)nvarchar400CHAR(N' ')NoPOTX1 Allow NULL? 
67POTX2BOM item text (line 2)nvarchar400CHAR(N' ')NoPOTX2 Allow NULL? 
68PLNUMPlanned order numbernvarchar100CHAR(N' ')NoPLAFPLNUM Allow NULL? 
69BAUGRMaterial number of higher-level assemblynvarchar180CHAR(N' ')NoMARABAUGR Allow NULL? 
70BAUSTAssembly order levelnvarchar20NUMC(N'00')NoBAUST Allow NULL? 
71BAUWGAssembly order pathnvarchar20NUMC(N'00')NoBAUWG Allow NULL? 
72SERNRBOM explosion numbernvarchar80CHAR(N' ')No*SERNR Allow NULL? 
73AENNRChange Numbernvarchar120CHAR(N' ')NoAENRAENNR Allow NULL? 
74REVLVRevision Levelnvarchar20CHAR(N' ')NoREVLV Allow NULL? 
75STLTYBOM categorychar10CHAR(N' ')NoSTLTY Allow NULL? 
76STLNRBill of materialnvarchar80CHAR(N' ')NoSTNUM Allow NULL? 
77STLKNBOM item node numbernvarchar80NUMC(N'00000000')NoSTLKN Allow NULL? 
78STPOZInternal counternvarchar80NUMC(N'00000000')NoCIM_COUNT Allow NULL? 
79OBJNRObject numbernvarchar220CHAR(N' ')NoONR00J_OBJNR Allow NULL? 
80FLGATSequence categorychar10CHAR(N' ')NoTCA07FOLGENART Allow NULL? 
81PLNFLSequencenvarchar60CHAR(N' ')NoPLNFOLGE Allow NULL? 
82VORNROperation/Activity Numbernvarchar40CHAR(N' ')NoVORNR Allow NULL? 
83APLZLInternal counternvarchar80NUMC(N'00000000')NoCIM_COUNT Allow NULL? 
84STVKNInherited node number of BOM itemnvarchar80NUMC(N'00000000')NoSTVKN Allow NULL? 
85VRPLAIndicator: planning without final assemblychar10CHAR(N' ')NoVRPLA Allow NULL? 
86PBDNRRequirements Plan Numbernvarchar100CHAR(N' ')NoPBDNR Allow NULL? 
87KNTTPAccount Assignment Categorychar10CHAR(N' ')NoT163KKNTTP Allow NULL? 
88SOBKZSpecial Stock Indicatorchar10CHAR(N' ')NoT148SOBKZ Allow NULL? 
89KZVBRConsumption Postingchar10CHAR(N' ')NoKZVBR Allow NULL? 
90KDAUFSales Order Numbernvarchar100CHAR(N' ')NoVBUKKDAUF Allow NULL? 
91KDPOSItem Number in Sales Ordernvarchar60NUMC(N'000000')NoKDPOS Allow NULL? 
92KDEINDelivery Schedule for Sales Ordernvarchar40NUMC(N'0000')NoKDEIN Allow NULL? 
93PSPELWBS Elementnvarchar80NUMC(N'00000000')NoPRPSPS_POSNR Allow NULL? 
94CLAKZIndicator: classification existschar10CHAR(N' ')NoCLAKZ Allow NULL? 
95SANKAIndicator: item relevant to costingchar10CHAR(N' ')NoSANKA Allow NULL? 
96KZKUPIndicator: co-productchar10CHAR(N' ')NoKZKUP Allow NULL? 
97STLALAlternative BOMnvarchar20CHAR(N' ')NoSTLAL Allow NULL? 
98TECHSParameter Variant/Standard Variantnvarchar120CHAR(N' ')NoTECHS Allow NULL? 
99LIFNRAccount Number of Vendor or Creditornvarchar100CHAR(N' ')NoLFA1LIFNR Allow NULL? 
100EDGNOInternal number for edge of object dependencies treenvarchar170NUMC(N'00000000000000000')NoM60IEDGNO Allow NULL? 
101NLFZVLead-time offset for operationdecimal30DEC((0))NoCS_NLFZV
102NLFMVUnit for lead-time offset for operationnvarchar30UNIT(N' ')No*CS_NLFMV Allow NULL? 
103KZBWSValuation of Special Stockchar10CHAR(N' ')YesKZBWS Allow NULL? 
NamePrimaryUniqueTypeColumns
MDSM~0YesYesCLUSTEREDSBART, SBPOS, SBNUM, MANDT
MDSM~MNoNoNONCLUSTEREDBDTER, WERKS, MATNR, PLSCN, 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