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  | WVFB
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
Sales and Distribution :: POS Interface
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0WVFB711DRS Interface, Intermediate Buffer, Order Item FMPOS Interface
SQL:  selectupdate insert create

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

SELECT MANDT, WGSREQN, WGSREQP, WBTYP, ACTION, BUKRS, BSTYP, BSART, LIFNR, ZTERM, EKORG, EKGRP, DISPO, AFNAM, WAERS, WKURS, KUNNR, RESWK, KONNR, MATNR, EMATN, WERKS, BEDNR, MATKL, IDNLF, MENGE, MEINS, PSTYP, LMEIN, EAN11, AKTNR, EINDT, UZEIT, BEDAT, VSTAT, POSNRI, KNTTP, KOSTL, LTSNR, LGORT, WVFBSORT, WVFB_NO_WF, WVFBSTEP, WVFBCALL, WVFBPARTEXIST, WVFBCONDEXIST, USRC1, USRC2, USRN1, USRN2, VSTEL, LPRIO, ROUTE, SPDNR, VKORG, VTWEG, SPART, VKBUR, VKGRP, AUART, RETPO, I_BELNR, I_POSNR, E_BELNR, E_POSNR, E_OBJTYPE, FREE, SEGNUM, KTPNR, UPTYP, HL_ITEM FROM WVFB
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2WGSREQNDocument number of store order document buffernvarchar100CHAR(N' ')No*WGSREQN Allow NULL? 
3WGSREQPItem number of inbound document buffernvarchar50NUMC(N'00000')No*WGSREQP Allow NULL? 
4WBTYPDefault doc. category, store order inbound - replenishmentchar10CHAR(N' ')YesVWWSBTYPVO Allow NULL? 
5ACTIONSales promotion code for the itemnvarchar30CHAR(N' ')YesWVFB_ACTION Allow NULL? 
6BUKRSCompany Codenvarchar40CHAR(N' ')No*BUKRS Allow NULL? 
7BSTYPPurchasing Document Categorychar10CHAR(N' ')YesBSTYP Allow NULL? 
8BSARTPurchasing Document Typenvarchar40CHAR(N' ')Yes*ESART Allow NULL? 
9LIFNRVendor Account Numbernvarchar100CHAR(N' ')Yes*ELIFN Allow NULL? 
10ZTERMTerms of Payment Keynvarchar40CHAR(N' ')YesDZTERM Allow NULL? 
11EKORGPurchasing Organizationnvarchar40CHAR(N' ')Yes*EKORG Allow NULL? 
12EKGRPPurchasing Groupnvarchar30CHAR(N' ')Yes*BKGRP Allow NULL? 
13DISPOMRP Controller (Materials Planner)nvarchar30CHAR(N' ')Yes*DISPO Allow NULL? 
14AFNAMName of Requisitioner/Requesternvarchar120CHAR(N' ')YesAFNAM Allow NULL? 
15WAERSCurrency Keynvarchar50CUKY(N' ')Yes*WAERS Allow NULL? 
16WKURSExchange Ratedecimal95DEC((0))YesWKURS
17KUNNRCustomer Numbernvarchar100CHAR(N' ')Yes*KUNNR Allow NULL? 
18RESWKSupplying (Issuing) Plant in Stock Transport Ordernvarchar40CHAR(N' ')Yes*RESWK Allow NULL? 
19KONNRNumber of Principal Purchase Agreementnvarchar100CHAR(N' ')Yes*KONNR Allow NULL? 
20MATNRMaterial Numbernvarchar180CHAR(N' ')Yes*MATNR Allow NULL? 
21EMATNMaterial Numbernvarchar180CHAR(N' ')Yes*EMATNR Allow NULL? 
22WERKSPlantnvarchar40CHAR(N' ')Yes*EWERK Allow NULL? 
23BEDNRRequirement tracking numbernvarchar350CHAR(N' ')YesBEDNR_EXT Allow NULL? 
24MATKLMaterial Groupnvarchar90CHAR(N' ')Yes*MATKL Allow NULL? 
25IDNLFMaterial Number Used by Vendornvarchar350CHAR(N' ')YesIDNLF Allow NULL? 
26MENGEPurchase Order Quantitydecimal133QUAN((0))YesBSTMG
27MEINSPurchase Order Unit of Measurenvarchar30UNIT(N' ')Yes*BSTME Allow NULL? 
28PSTYPItem Category in Purchasing Documentchar10CHAR(N' ')Yes*PSTYP Allow NULL? 
29LMEINBase Unit of Measurenvarchar30UNIT(N' ')Yes*LAGME Allow NULL? 
30EAN11International Article Number (EAN/UPC)nvarchar180CHAR(N' ')YesEAN11 Allow NULL? 
31AKTNRPromotionnvarchar100CHAR(N' ')Yes*WAKTION Allow NULL? 
32EINDTItem Delivery Datenvarchar80DATS(N'00000000')YesEINDT Allow NULL? 
33UZEITDelivery Date Time-Spotnvarchar60TIMS(N'000000')YesLZEIT Allow NULL? 
34BEDATOrder date of schedule linenvarchar80DATS(N'00000000')YesETBDT Allow NULL? 
35VSTATDRS FM interface - processing statuschar10CHAR(N' ')YesVSTATUS Allow NULL? 
36POSNRISI FM Interface: Internal item no.nvarchar100NUMC(N'0000000000')YesPOSNRI Allow NULL? 
37KNTTPAccount Assignment Categorychar10CHAR(N' ')Yes*WVFBKNTTP Allow NULL? 
38KOSTLCost centernvarchar100CHAR(N' ')Yes*WVFBKOSTL Allow NULL? 
39LTSNRVendor Subrangenvarchar60CHAR(N' ')Yes*LTSNR Allow NULL? 
40LGORTStorage Locationnvarchar40CHAR(N' ')YesWVFBLGORT Allow NULL? 
41WVFBSORTSort in step 2char10CHAR(N' ')YesWVFBSORT Allow NULL? 
42WVFB_NO_WFNo workflowchar10CHAR(N' ')YesWVFB_NO_WF Allow NULL? 
43WVFBSTEPExecution stepchar10CHAR(N' ')YesWVFBSTEP Allow NULL? 
44WVFBCALLCalling programchar10CHAR(N' ')YesWVFBCALL Allow NULL? 
45WVFBPARTEXISTInput partner definitions existchar10CHAR(N' ')YesWVFBPARTEXIST Allow NULL? 
46WVFBCONDEXISTCondition_existchar10CHAR(N' ')YesWVFBCONDEXIST Allow NULL? 
47USRC1User field format character for release strategynvarchar200CHAR(N' ')YesUSRC1 Allow NULL? 
48USRC2User field format character for release strategynvarchar200CHAR(N' ')YesUSRC1 Allow NULL? 
49USRN1User field numeric for release strategynvarchar100NUMC(N'0000000000')YesUSRN1 Allow NULL? 
50USRN2User field numeric for release strategynvarchar100NUMC(N'0000000000')YesUSRN1 Allow NULL? 
51VSTELShipping pointnvarchar40CHAR(N' ')Yes*WVFBVSTEL Allow NULL? 
52LPRIODelivery prioritynvarchar20NUMC(N'00')Yes*WVFBLPRIO Allow NULL? 
53ROUTERoutenvarchar60CHAR(N' ')Yes*WVFBROUTE Allow NULL? 
54SPDNRCarriernvarchar100CHAR(N' ')Yes*WVFBSPDNR Allow NULL? 
55VKORGSales organizationnvarchar40CHAR(N' ')Yes*WVFBVKORG Allow NULL? 
56VTWEGDistribution channelnvarchar20CHAR(N' ')Yes*WVFBVTWEG Allow NULL? 
57SPARTDivisionnvarchar20CHAR(N' ')Yes*WVFBSPART Allow NULL? 
58VKBURSales Officenvarchar40CHAR(N' ')Yes*VKBUR Allow NULL? 
59VKGRPSales Groupnvarchar30CHAR(N' ')Yes*VKGRP Allow NULL? 
60AUARTSales Document Typenvarchar40CHAR(N' ')Yes*AUART Allow NULL? 
61RETPOReturns Itemchar10CHAR(N' ')YesRETPO Allow NULL? 
62I_BELNRDocument number of store order document buffernvarchar100CHAR(N' ')Yes*WGSREQN Allow NULL? 
63I_POSNRItem number of inbound document buffernvarchar50NUMC(N'00000')Yes*WGSREQP Allow NULL? 
64E_BELNRObject keynvarchar700CHAR(N' ')YesSWO_TYPEID Allow NULL? 
65E_POSNRDocument Item in Follow-On Document for Store Ordernvarchar60NUMC(N'000000')Yes*WVFB_BELP Allow NULL? 
66E_OBJTYPEObject Typenvarchar100CHAR(N' ')Yes*SWO_OBJTYP Allow NULL? 
67FREEFree Itemchar10CHAR(N' ')YesUMSON Allow NULL? 
68SEGNUMNumber of SAP segmentnvarchar60NUMC(N'000000')YesIDOCDSGNUM Allow NULL? 
69KTPNRItem Number of Principal Purchase Agreementnvarchar50NUMC(N'00000')Yes*KTPNR Allow NULL? 
70UPTYPSubitem Category, Purchasing Documentchar10CHAR(N' ')Yes*UPTYP Allow NULL? 
71HL_ITEMHigher-Level Item in Purchasing Documentsnvarchar50NUMC(N'00000')Yes*UEBPO Allow NULL? 
NamePrimaryUniqueTypeColumns
WVFB~0YesYesCLUSTEREDMANDT, WGSREQN, WGSREQP

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