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  | EKET
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.0EKET702Scheduling Agreement Schedule LinesPurchasing
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, KEY_ID, OTB_VALUE, OTB_CURR, OTB_RES_VALUE, OTB_SPEC_VALUE, SPR_RSN_PROFILE, BUDG_TYPE, OTB_STATUS, OTB_REASON, CHECK_TYPE, DL_ID, HANDOVER_DATE, NO_SCEM, DNG_DATE, DNG_TIME, CNCL_ANCMNT_DONE, DATESHIFT_NUMBER FROM EKET
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')NoEETEN Allow NULL? 
5EINDTItem Delivery Datenvarchar80DATS(N'00000000')YesEINDT Allow NULL? 
6SLFDTStatistics-Relevant Delivery Datenvarchar80DATS(N'00000000')YesSLFDT Allow NULL? 
7LPEINCategory of Delivery Datechar10CHAR(N' ')Yes*LPEIN 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? 
54KEY_IDUnique Number of Budgetnvarchar160NUMC(N'0000000000000000')YesWRF_BUDG_KEY_ID Allow NULL? 
55OTB_VALUERequired Budgetdecimal172CURR((0))YesWRF_POTB_VALUE
56OTB_CURROTB Currencynvarchar50CUKY(N' ')Yes*WRF_POTB_CURRENCY Allow NULL? 
57OTB_RES_VALUEReserved Budget for OTB-Relevant Purchasing Documentdecimal172CURR((0))YesWRF_POTB_RES_VALUE
58OTB_SPEC_VALUESpecial Release Budgetdecimal172CURR((0))YesWRF_POTB_SPECIAL_VALUE
59SPR_RSN_PROFILEReason Profile for OTB Special Releasenvarchar40CHAR(N' ')YesWRF_POTB_SPR_RSN_PROFILE Allow NULL? 
60BUDG_TYPEBudget Typenvarchar20CHAR(N' ')YesWRF_BUDG_TYPE Allow NULL? 
61OTB_STATUSOTB Check Statuschar10CHAR(N' ')YesWRF_POTB_STATUS Allow NULL? 
62OTB_REASONReason Indicator for OTB Check Statusnvarchar30CHAR(N' ')YesWRF_POTB_STATUS_REASON Allow NULL? 
63CHECK_TYPEType of OTB Checkchar10CHAR(N' ')YesWRF_BUDG_OTB_CHECK Allow NULL? 
64DL_IDDate Line ID (GUID)nvarchar220CHAR(N' ')YesWRF_PSCD_DL_ID Allow NULL? 
65HANDOVER_DATETransfer Datenvarchar80DATS(N'00000000')YesWRF_PSCD_HANDOVER_DATE Allow NULL? 
66NO_SCEMPurchase Order Not Transferred to SCEMchar10CHAR(N' ')YesWRF_PSCD_NO_SCEM Allow NULL? 
67DNG_DATECreation Date of Reminder Message Recordnvarchar80DATS(N'00000000')YesWRF_PCTR_DNG_DATE Allow NULL? 
68DNG_TIMECreation Time of Reminder Message Recordnvarchar60TIMS(N'000000')YesWRF_PCTR_DNG_TIME Allow NULL? 
69CNCL_ANCMNT_DONECancellation Threat Madechar10CHAR(N' ')YesWRF_PCTR_CNCL_ANCMT_DONE Allow NULL? 
70DATESHIFT_NUMBERNumber of Current Date Shiftsdecimal30DEC((0))YesWRF_PCTR_DATESHIFT_NUMBER
NamePrimaryUniqueTypeColumns
EKET~0YesYesCLUSTEREDETENR, EBELP, EBELN, MANDT
EKET~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