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  | VBEP
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
8JDT1124Journal Entry - Rows
9OPOR386Purchase Order
10OVTG52Tax Definition

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
Sales and Distribution :: Sales
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0VBEP612Sales Document: Schedule Line DataSales
SQL:  selectupdate insert create

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

SELECT MANDT, VBELN, POSNR, ETENR, ETTYP, LFREL, EDATU, EZEIT, WMENG, BMENG, VRKME, LMENG, MEINS, BDDAT, BDART, PLART, VBELE, POSNE, ETENE, RSDAT, IDNNR, BANFN, BSART, BSTYP, WEPOS, REPOS, LRGDT, PRGRS, TDDAT, MBDAT, LDDAT, WADAT, CMENG, LIFSP, GRSTR, ABART, ABRUF, ROMS1, ROMS2, ROMS3, ROMEI, RFORM, UMVKZ, UMVKN, VERFP, BWART, BNFPO, ETART, AUFNR, PLNUM, SERNR, AESKD, ABGES, MBUHR, TDUHR, LDUHR, WAUHR, AULWE, HANDOVERDATE, HANDOVERTIME, MBDAT_DRS FROM VBEP
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2VBELNSales Documentnvarchar100CHAR(N' ')NoVBUKVBELN_VA Allow NULL? 
3POSNRSales Document Itemnvarchar60NUMC(N'000000')NoVBUPPOSNR_VA Allow NULL? 
4ETENRDelivery Schedule Line Numbernvarchar40NUMC(N'0000')NoETENR Allow NULL? 
5ETTYPSchedule line categorynvarchar20CHAR(N' ')YesTVEPETTYP Allow NULL? 
6LFRELItem is relevant for deliverychar10CHAR(N' ')YesLFREL Allow NULL? 
7EDATUSchedule line datenvarchar80DATS(N'00000000')YesEDATU Allow NULL? 
8EZEITArrival timenvarchar60TIMS(N'000000')YesEZEIT_VBEP Allow NULL? 
9WMENGOrder quantity in sales unitsdecimal133QUAN((0))YesWMENG
10BMENGConfirmed Quantitydecimal133QUAN((0))YesBMENG
11VRKMESales unitnvarchar30UNIT(N' ')YesT006VRKME Allow NULL? 
12LMENGRequired quantity for mat.management in stockkeeping unitsdecimal133QUAN((0))YesLMENG
13MEINSBase Unit of Measurenvarchar30UNIT(N' ')YesT006MEINS Allow NULL? 
14BDDATRequirement date (deadline for procurement)nvarchar80DATS(N'00000000')YesBDDAT Allow NULL? 
15BDARTRequirement typenvarchar20CHAR(N' ')YesBDART Allow NULL? 
16PLARTPlanning typechar10CHAR(N' ')Yes*PLART Allow NULL? 
17VBELEBusiness document numbernvarchar100CHAR(N' ')YesVBUKVBELE Allow NULL? 
18POSNEBusiness item numbernvarchar60NUMC(N'000000')YesVBUPPOSNE Allow NULL? 
19ETENESchedule linenvarchar40NUMC(N'0000')YesVBEPETENE Allow NULL? 
20RSDATEarliest possible reservation datenvarchar80DATS(N'00000000')YesRSDAT Allow NULL? 
21IDNNRMaintenance requestnvarchar100NUMC(N'0000000000')YesIDNNR Allow NULL? 
22BANFNPurchase Requisition Numbernvarchar100CHAR(N' ')YesBANFN Allow NULL? 
23BSARTOrder Type (Purchasing)nvarchar40CHAR(N' ')YesT161BSART Allow NULL? 
24BSTYPPurchasing Document Categorychar10CHAR(N' ')YesBSTYP Allow NULL? 
25WEPOSConfirmation status of schedule line (incl.ALE)char10CHAR(N' ')YesWEPOS_A Allow NULL? 
26REPOSInvoice Receipt Indicatorchar10CHAR(N' ')YesREPOS Allow NULL? 
27LRGDTReturn date for returnable packagingnvarchar80DATS(N'00000000')YesLRGDT Allow NULL? 
28PRGRSDate type (day, week, month, interval)char10CHAR(N' ')YesPRGRS Allow NULL? 
29TDDATTransportation Planning Datenvarchar80DATS(N'00000000')YesTDDAT_D Allow NULL? 
30MBDATMaterial Staging/Availability Datenvarchar80DATS(N'00000000')YesMBDAT Allow NULL? 
31LDDATLoading Datenvarchar80DATS(N'00000000')YesLDDAT Allow NULL? 
32WADATGoods Issue Datenvarchar80DATS(N'00000000')YesWADAT Allow NULL? 
33CMENGCorrected quantity in sales unitdecimal133QUAN((0))YesCMENG
34LIFSPSchedule line blocked for deliverynvarchar20CHAR(N' ')YesTVLSLIFSP_EP Allow NULL? 
35GRSTRGroup definition of structure datanvarchar30NUMC(N'000')YesGRSTR Allow NULL? 
36ABARTRelease typechar10CHAR(N' ')YesABART Allow NULL? 
37ABRUFForecast Delivery schedule numbernvarchar100NUMC(N'0000000000')YesABRUF Allow NULL? 
38ROMS1Committed quantitydecimal133QUAN((0))YesDCQNT
39ROMS2Size 2decimal133QUAN((0))YesROMS2
40ROMS3Size 3decimal133QUAN((0))YesROMS3
41ROMEIUnit of measure for sizes 1 to 3nvarchar30UNIT(N' ')YesT006ROMEI Allow NULL? 
42RFORMFormula keynvarchar20CHAR(N' ')Yes*RFORM Allow NULL? 
43UMVKZNumerator (factor) for conversion of sales quantity into SKUdecimal50DEC((0))YesUMVKZ
44UMVKNDenominator (Divisor) for Conversion of Sales Qty into SKUdecimal50DEC((0))YesUMVKN
45VERFPAvailability confirmed automaticallychar10CHAR(N' ')YesVERFP_MAS Allow NULL? 
46BWARTMovement Type (Inventory Management)nvarchar30CHAR(N' ')YesT156BWART Allow NULL? 
47BNFPOItem Number of Purchase Requisitionnvarchar50NUMC(N'00000')YesEBANBNFPO Allow NULL? 
48ETARTSchedule line type EDIchar10CHAR(N' ')YesTVETEDI_ETTYP Allow NULL? 
49AUFNROrder Numbernvarchar120CHAR(N' ')YesAUFKAUFNR Allow NULL? 
50PLNUMPlanned order numbernvarchar100CHAR(N' ')YesPLAFPLNUM Allow NULL? 
51SERNRBOM explosion numbernvarchar80CHAR(N' ')YesSNUMSERNR Allow NULL? 
52AESKDCustomer Engineering Change Statusnvarchar170CHAR(N' ')YesAESKD Allow NULL? 
53ABGESGuaranteed (factor between 0 and 1)float1516FLTP((0))YesABGES_CM
54MBUHRMaterial Staging Time (Local, Relating to a Plant)nvarchar60TIMS(N'000000')YesMBUHR Allow NULL? 
55TDUHRTransp. Planning Time (Local, Relating to a Shipping Point)nvarchar60TIMS(N'000000')YesTDUHR Allow NULL? 
56LDUHRLoading Time (Local Time Relating to a Shipping Point)nvarchar60TIMS(N'000000')YesLDUHR Allow NULL? 
57WAUHRTime of Goods Issue (Local, Relating to a Plant)nvarchar60TIMS(N'000000')YesWAUHR Allow NULL? 
58AULWERoute Schedulenvarchar100CHAR(N' ')YesVALWAULWE Allow NULL? 
59HANDOVERDATEHandover Date at the Handover Locationnvarchar80DATS(N'00000000')YesHANDOVER_DATE Allow NULL? 
60HANDOVERTIMEHandover time at the handover locationnvarchar60TIMS(N'000000')YesHANDOVER_TIME Allow NULL? 
61MBDAT_DRSMaterial Availability Date Third-Party Order Planningnvarchar80DATS(N'00000000')YesMBDAT_DRS Allow NULL? 
NamePrimaryUniqueTypeColumns
VBEP~0YesYesCLUSTEREDMANDT, VBELN, POSNR, ETENR
VBEP~SM0NoNoNONCLUSTEREDAUFNR

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