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  | EKETH
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
Materials Management :: Purchasing
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0EKETH532Scheduling Agreement Schedules: History TablesPurchasing
SQL:  selectupdate insert create

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

SELECT MANDT, EBELN, EBELP, ETENR, EINDT, SLFDT, LPEIN, MENGE, AMENG, WEMNG, WAMNG, UZEIT, BANFN, BNFPO, ESTKZ, QUNUM, QUPOS, MAHNZ, BEDAT, RSNUM, SERNR, FIXKZ, GLMNG, DABMG, CHARG, LICHA, CHKOM, VERID, ABART, MNG02, DAT01, ALTDT, AULWE, MBDAT, MBUHR, LDDAT, LDUHR, TDDAT, TDUHR, WADAT, WAUHR, ELDAT, ELUHR, ANZSN, NODISP, GEO_ROUTE, ROUTE_GTS, GTS_IND, TSP, CD_LOCNO, CD_LOCTYPE, HANDOVERDATE, HANDOVERTIME FROM EKETH
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2EBELNPurchasing Document Numbernvarchar100CHAR(N' ')NoEKKOEBELN Allow NULL? 
3EBELPItem Number of Purchasing Documentnvarchar50NUMC(N'00000')NoEKPOEBELP Allow NULL? 
4ETENRDelivery Schedule Line Counternvarchar40NUMC(N'0000')No*EETEN Allow NULL? 
5EINDTItem Delivery Datenvarchar80DATS(N'00000000')YesEINDT Allow NULL? 
6SLFDTStatistics-Relevant Delivery Datenvarchar80DATS(N'00000000')YesSLFDT Allow NULL? 
7LPEINCategory of Delivery Datechar10CHAR(N' ')YesTPRGLPEIN Allow NULL? 
8MENGEScheduled Quantitydecimal133QUAN((0))YesETMEN
9AMENGPrevious Quantity (Delivery Schedule Lines)decimal133QUAN((0))YesVOMNG
10WEMNGQuantity of Goods Receiveddecimal133QUAN((0))YesWEEMG
11WAMNGIssued Quantitydecimal133QUAN((0))YesWAMNG
12UZEITDelivery Date Time-Spotnvarchar60TIMS(N'000000')YesLZEIT Allow NULL? 
13BANFNPurchase Requisition Numbernvarchar100CHAR(N' ')YesBANFN Allow NULL? 
14BNFPOItem Number of Purchase Requisitionnvarchar50NUMC(N'00000')YesEBANBNFPO Allow NULL? 
15ESTKZCreation Indicator (Purchase Requisition/Schedule Lines)char10CHAR(N' ')YesESTKZ Allow NULL? 
16QUNUMNumber of Quota Arrangementnvarchar100CHAR(N' ')YesQUNUM Allow NULL? 
17QUPOSQuota Arrangement Itemnvarchar30NUMC(N'000')YesQUPOS Allow NULL? 
18MAHNZNo. of Reminders/Expediters for Schedule Linedecimal30DEC((0))YesMAHNZE
19BEDATOrder date of schedule linenvarchar80DATS(N'00000000')YesETBDT Allow NULL? 
20RSNUMNumber of Reservation/Dependent Requirementnvarchar100NUMC(N'0000000000')Yes*RSNUM Allow NULL? 
21SERNRBOM explosion numbernvarchar80CHAR(N' ')Yes*SERNR Allow NULL? 
22FIXKZSchedule Line is "Fixed"char10CHAR(N' ')YesETFIX Allow NULL? 
23GLMNGQuantity Delivered (Stock Transfer)decimal133QUAN((0))YesGLMNG
24DABMGQuantity Reduced (MRP)decimal133QUAN((0))YesDABMG
25CHARGBatch Numbernvarchar100CHAR(N' ')Yes*CHARG_D Allow NULL? 
26LICHAVendor Batch Numbernvarchar150CHAR(N' ')YesLICHN Allow NULL? 
27CHKOMComponentschar10CHAR(N' ')YesCHKOM Allow NULL? 
28VERIDProduction Versionnvarchar40CHAR(N' ')Yes*VERID Allow NULL? 
29ABARTScheduling agreement release typechar10CHAR(N' ')YesMEABART Allow NULL? 
30MNG02Committed Quantitydecimal133QUAN((0))YesMNG06
31DAT01Committed Datenvarchar80DATS(N'00000000')YesDAT05 Allow NULL? 
32ALTDTPrevious delivery datenvarchar80DATS(N'00000000')YesALTDT Allow NULL? 
33AULWERoute Schedulenvarchar100CHAR(N' ')YesVALWAULWE Allow NULL? 
34MBDATMaterial Staging/Availability Datenvarchar80DATS(N'00000000')YesMBDAT Allow NULL? 
35MBUHRMaterial Staging Time (Local, Relating to a Plant)nvarchar60TIMS(N'000000')YesMBUHR Allow NULL? 
36LDDATLoading Datenvarchar80DATS(N'00000000')YesLDDAT Allow NULL? 
37LDUHRLoading Time (Local Time Relating to a Shipping Point)nvarchar60TIMS(N'000000')YesLDUHR Allow NULL? 
38TDDATTransportation Planning Datenvarchar80DATS(N'00000000')YesTDDAT_D Allow NULL? 
39TDUHRTransp. Planning Time (Local, Relating to a Shipping Point)nvarchar60TIMS(N'000000')YesTDUHR Allow NULL? 
40WADATGoods Issue Datenvarchar80DATS(N'00000000')YesWADAT Allow NULL? 
41WAUHRTime of Goods Issue (Local, Relating to a Plant)nvarchar60TIMS(N'000000')YesWAUHR Allow NULL? 
42ELDATGoods Receipt End Datenvarchar80DATS(N'00000000')YesELDAT Allow NULL? 
43ELUHRGoods Receipt End Time (Local, Relating to a Plant)nvarchar60TIMS(N'000000')YesELUHR Allow NULL? 
44ANZSNNumber of serial numbersint100INT4((0))YesANZSN Allow NULL? 
45NODISPInd: Reserv. not applicable to MRP;Purc. req. not createdchar10CHAR(N' ')YesNODISP Allow NULL? 
46GEO_ROUTEDescription of a Geographical Routenvarchar100CHAR(N' ')Yes/SPE/DE_ROUTE_ID Allow NULL? 
47ROUTE_GTSRoute Code for SAP Global Trade Servicesnvarchar100CHAR(N' ')Yes/SPE/DE_ROUTE_GTS_CODE Allow NULL? 
48GTS_INDGoods Traffic Typenvarchar20CHAR(N' ')Yes/SPE/DE_LEG_GTS_CODE Allow NULL? 
49TSPForwarding agentnvarchar100CHAR(N' ')Yes*SPDNR Allow NULL? 
50CD_LOCNOLocation number in APOnvarchar200CHAR(N' ')YesAPOLOCNO Allow NULL? 
51CD_LOCTYPEAPO location typenvarchar40CHAR(N' ')YesAPOLOCTYPE Allow NULL? 
52HANDOVERDATEHandover Date at the Handover Locationnvarchar80DATS(N'00000000')YesHANDOVER_DATE Allow NULL? 
53HANDOVERTIMEHandover time at the handover locationnvarchar60TIMS(N'000000')YesHANDOVER_TIME Allow NULL? 
NamePrimaryUniqueTypeColumns
EKETH~0YesYesCLUSTEREDETENR, EBELP, EBELN, MANDT
EKETH~ENoNoNONCLUSTEREDBNFPO, BANFN, 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