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  | WDFR_DISP
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
Materials Management :: Purchasing
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0WDFR_DISP1311Perishables Planning HeaderPurchasing
SQL:  selectupdate insert create

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

SELECT MANDT, FBELN, IBELN, WERKS, TABIX, VLFKZ, WVBUKRS, WVKORG, WVTWEG, WVSPART, WVLAND1, WVKUNNR, WVLIFNR, NAME1, DISART, ABGART, AUFAR, APSTP, SBELN, ASTRA, ABELN, ABELP, LISTG, RUNDG, RESTV, AAVIT, BERMIMA, BSTGE, BEZCH, AFDTP, AFDAT, VKDTP, VKDAT, FBDAT, FUDAT, FLDAT, FBDTP, FUDTP, FLDTP, WBTYP, AKTBE, I_BELNR, I_POSNR, LEIND, LZEIT, ALIFNR, ABSMNG, ABSMEI, AMENGE, AMEINS, IA_SAMMELBEST, UPDKZ, BESKZ, SATKZ, AKTKZ, ABNKZ, EINDT, BESAB, BESBI, AINDT, ABGAB, ABGBI, AUSAB, AUSBI, LFDAT_AB, LFDAT_BI, UHRAB, UHRBI, DTIME, DHOUR, CD, FT, PA, CD_FT, CD_PA, KABE, BEBE, BRBE, OPTI, AVAIL, ROULE, STOCK, SAMKZ, LGORT, BBTYP, BBTEXT, MATKL, AKTMA, EKORG, EKGRP, BEDAT, BSDAT, AVRULE, DEBNR, BUKRS, VKORG, VTWEG, SPART, LAND1, ERWSE, SPRAS, SAMANZ, VARANZ, LAGAB, LIVAR, VKERV, BSART, PSTYP, KNTTP, MISCH, BPROT, ABNER, ATPER, FVBER, UMSER, BVLER, UAVER, DIFER, INFER, KALER, SORER, TEXT_TITEL, TEXT_TITEL_40, FBEZCH, ERDAT, AEDAT, ERNAM, AENAM, GEDAT, GETIME, KAPPL FROM WDFR_DISP
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2FBELNPerishables Planning Numbernvarchar100CHAR(N' ')NoWDFR_FBELN Allow NULL? 
3IBELNPerishables Planning Numbernvarchar100CHAR(N' ')YesWDFR_FBELN Allow NULL? 
4WERKSPlantnvarchar40CHAR(N' ')YesT001WWERKS_D Allow NULL? 
5TABIXRow Index of Internal Tablesint100INT4((0))YesSYTABIX Allow NULL? 
6VLFKZPlant categorychar10CHAR(N' ')YesVLFKZ Allow NULL? 
7WVBUKRSCompany Codenvarchar40CHAR(N' ')YesT001BUKRS Allow NULL? 
8WVKORGSales Organizationnvarchar40CHAR(N' ')YesTVKOVKORG Allow NULL? 
9WVTWEGDistribution Channelnvarchar20CHAR(N' ')YesTVTWVTWEG Allow NULL? 
10WVSPARTDivisionnvarchar20CHAR(N' ')YesTSPASPART Allow NULL? 
11WVLAND1Country Keynvarchar30CHAR(N' ')YesT005LAND1 Allow NULL? 
12WVKUNNRCustomer number of plantnvarchar100CHAR(N' ')YesKNA1KUNNR_WK Allow NULL? 
13WVLIFNRVendor number of plantnvarchar100CHAR(N' ')YesLFA1LIFNR_WK Allow NULL? 
14NAME1Namenvarchar300CHAR(N' ')YesNAME1 Allow NULL? 
15DISARTWDFR MRP procedurenvarchar20CHAR(N' ')YesWDFR_DISART Allow NULL? 
16ABGARTWDFR issue typenvarchar20CHAR(N' ')YesWDFR_ABGART Allow NULL? 
17AUFARAllocation Table Typenvarchar40CHAR(N' ')YesT620AUFAR Allow NULL? 
18APSTPItem category of allocation tablenvarchar40CHAR(N' ')YesT621APSTP Allow NULL? 
19SBELNNo. of allocation rulenvarchar100CHAR(N' ')YesSVKOSBELN Allow NULL? 
20ASTRAAllocation Strategynvarchar40CHAR(N' ')YesT627ASTRA Allow NULL? 
21ABELNAllocation Table Numbernvarchar100CHAR(N' ')YesAUKOABELN Allow NULL? 
22ABELPItem number of allocation tablenvarchar50NUMC(N'00000')YesAUPOABELP Allow NULL? 
23LISTGListing Indicatorchar10CHAR(N' ')YesLISTG Allow NULL? 
24RUNDGRounding off in allocation tablechar10CHAR(N' ')YesRUNDG Allow NULL? 
25RESTVSplit remainderchar10CHAR(N' ')YesRESTV Allow NULL? 
26AAVITNotification Category Allocation: Info Exchance HQ - Plantnvarchar40CHAR(N' ')YesT626AAVIT Allow NULL? 
27BERMIMAInclude Minimum and Maximum Quantitieschar10CHAR(N' ')YesBERMIMA Allow NULL? 
28BSTGEGoods recipient of vendor purchase orderchar10CHAR(N' ')YesBSTGE Allow NULL? 
29BEZCHDescriptionnvarchar400CHAR(N' ')YesBEZEI40 Allow NULL? 
30AFDTPExternal date typechar10CHAR(N' ')YesTPRGPRGBZ Allow NULL? 
31AFDATConfirmation request datenvarchar80DATS(N'00000000')YesAFIDT Allow NULL? 
32VKDTPExternal date typechar10CHAR(N' ')YesTPRGPRGBZ Allow NULL? 
33VKDATDate of start of sales at plantnvarchar80DATS(N'00000000')YesVKIDT Allow NULL? 
34FBDATRelease date of PO generationnvarchar80DATS(N'00000000')YesFBIDT Allow NULL? 
35FUDATRelease date for generation of stock transfernvarchar80DATS(N'00000000')YesFUIDT Allow NULL? 
36FLDATRelease date for generation of delivery notenvarchar80DATS(N'00000000')YesFLIDT Allow NULL? 
37FBDTPExternal date typechar10CHAR(N' ')Yes*PRGBZ Allow NULL? 
38FUDTPExternal date typechar10CHAR(N' ')Yes*PRGBZ Allow NULL? 
39FLDTPExternal date typechar10CHAR(N' ')Yes*PRGBZ Allow NULL? 
40WBTYPDefault doc. category, store order inbound - replenishmentchar10CHAR(N' ')YesVWWSBTYPVO Allow NULL? 
41AKTBEPromotionnvarchar100CHAR(N' ')YesWAKHWAKTION Allow NULL? 
42I_BELNRDocument number of store order document buffernvarchar100CHAR(N' ')Yes*WGSREQN Allow NULL? 
43I_POSNRItem number of inbound document buffernvarchar50NUMC(N'00000')Yes*WGSREQP Allow NULL? 
44LEINDDelivery Datenvarchar100CHAR(N' ')YesEEIND Allow NULL? 
45LZEITDelivery Date Time-Spotnvarchar60TIMS(N'000000')YesLZEIT Allow NULL? 
46ALIFNRAccount Number of Vendor or Creditornvarchar100CHAR(N' ')YesLFA1LIFNR Allow NULL? 
47ABSMNGPurchase Order Quantitydecimal133QUAN((0))YesBSTMG
48ABSMEIBase Unit of Measurenvarchar30UNIT(N' ')YesT006MEINS Allow NULL? 
49AMENGEPurchase Order Quantitydecimal133QUAN((0))YesBSTMG
50AMEINSPurchase Order Unit of Measurenvarchar30UNIT(N' ')YesT006BSTME Allow NULL? 
51IA_SAMMELBESTIndividual, User-Defined Characterchar10CHAR(N' ')YesCHAR0001 Allow NULL? 
52UPDKZChange Type (U, I, S, D)char10CHAR(N' ')YesCDCHNGIND Allow NULL? 
53BESKZOrder indicatorchar10CHAR(N' ')YesWDFR_BESKZ Allow NULL? 
54SATKZIndicates generic materialnvarchar20CHAR(N' ')YesWDFR_SATKZ Allow NULL? 
55AKTKZIndividual, User-Defined Characterchar10CHAR(N' ')YesCHAR0001 Allow NULL? 
56ABNKZIndividual, User-Defined Characterchar10CHAR(N' ')YesCHAR0001 Allow NULL? 
57EINDTDelivery date of purchase ordernvarchar80DATS(N'00000000')YesWDFR_EINDT Allow NULL? 
58BESABProcurement datenvarchar80DATS(N'00000000')YesWDFR_BDAT Allow NULL? 
59BESBIProcurement datenvarchar80DATS(N'00000000')YesWDFR_BDAT Allow NULL? 
60AINDTInbound Delivery Date for POnvarchar80DATS(N'00000000')YesWDFR_AINDT Allow NULL? 
61ABGABIssue datenvarchar80DATS(N'00000000')YesWDFR_ABGDAT Allow NULL? 
62ABGBIIssue datenvarchar80DATS(N'00000000')YesWDFR_ABGDAT Allow NULL? 
63AUSABPOS selling periodnvarchar80DATS(N'00000000')YesWDFR_AUSDAT Allow NULL? 
64AUSBIPOS selling periodnvarchar80DATS(N'00000000')YesWDFR_AUSDAT Allow NULL? 
65LFDAT_ABDatenvarchar80DATS(N'00000000')YesFRMDATUM Allow NULL? 
66LFDAT_BIDatenvarchar80DATS(N'00000000')YesFRMDATUM Allow NULL? 
67UHRABProcurement period: timenvarchar60TIMS(N'000000')YesFRM_PROC_TIME Allow NULL? 
68UHRBIProcurement period: timenvarchar60TIMS(N'000000')YesFRM_PROC_TIME Allow NULL? 
69DTIMESchedule-line interval (days)smallint50INT2((0))YesFRM_LIEWR
70DHOURSchedule-line interval (hours)decimal42DEC((0))YesFRM_LIEWR_H
71CDCross-dockingchar10CHAR(N' ')YesWDFR_CD Allow NULL? 
72FTFlow-throughchar10CHAR(N' ')YesWDFR_FT Allow NULL? 
73PAPutawaychar10CHAR(N' ')YesWDFR_PA Allow NULL? 
74CD_FTCross-docking/flow-throughchar10CHAR(N' ')YesWDFR_CD_FT Allow NULL? 
75CD_PACross-docking/putawaychar10CHAR(N' ')YesWDFR_CD_PA Allow NULL? 
76KABEInclude sales orderschar10CHAR(N' ')YesWDFR_KABE Allow NULL? 
77BEBEInclude purchase orderschar10CHAR(N' ')YesWDFR_BEBE Allow NULL? 
78BRBEInclude backorderschar10CHAR(N' ')YesFRMTALL Allow NULL? 
79OPTIOrder Optimizingchar10CHAR(N' ')YesFRMBEST Allow NULL? 
80AVAILCheck if merchandise already procuredchar10CHAR(N' ')YesFRM_PR_CHECK Allow NULL? 
81ROULEChecking Rule for Availability Checknvarchar20CHAR(N' ')YesT441RPRREG Allow NULL? 
82STOCKExclude stock from checkchar10CHAR(N' ')YesFRM_IN_CHECK Allow NULL? 
83SAMKZMark item for collective purchase orderchar10CHAR(N' ')YesWDFR_SAMKZ Allow NULL? 
84LGORTStorage Locationnvarchar40CHAR(N' ')YesT001LLGORT_D Allow NULL? 
85BBTYPAssortment List Typechar10CHAR(N' ')YesTWBBBBTYP Allow NULL? 
86BBTEXTDescription of assortment list typenvarchar200CHAR(N' ')YesBBTEXT Allow NULL? 
87MATKLMaterial Groupnvarchar90CHAR(N' ')YesT023MATKL Allow NULL? 
88AKTMAPromotionnvarchar100CHAR(N' ')YesWAKHWAKTION Allow NULL? 
89EKORGPurchasing Organizationnvarchar40CHAR(N' ')YesT024EEKORG Allow NULL? 
90EKGRPPurchasing Groupnvarchar30CHAR(N' ')YesT024BKGRP Allow NULL? 
91BEDATPurchase Order Datenvarchar80DATS(N'00000000')YesBEDAT Allow NULL? 
92BSDATStock datenvarchar80DATS(N'00000000')YesWDFR_BETDAT Allow NULL? 
93AVRULEChecking Rule for Availability Checknvarchar20CHAR(N' ')YesT441RPRREG Allow NULL? 
94DEBNRCustomer Numbernvarchar100CHAR(N' ')YesKNA1KUNNR Allow NULL? 
95BUKRSCompany Codenvarchar40CHAR(N' ')YesT001BUKRS Allow NULL? 
96VKORGSales Organizationnvarchar40CHAR(N' ')YesTVKOVKORG Allow NULL? 
97VTWEGDistribution Channelnvarchar20CHAR(N' ')YesTVTWVTWEG Allow NULL? 
98SPARTDivisionnvarchar20CHAR(N' ')YesTSPASPART Allow NULL? 
99LAND1Country Keynvarchar30CHAR(N' ')YesT005LAND1 Allow NULL? 
100ERWSEIndicator: Extended Selectionchar10CHAR(N' ')YesERWSE Allow NULL? 
101SPRASLanguage Keychar10LANG(N' ')YesT002SPRAS Allow NULL? 
102SAMANZDisplay Configurable Materialchar10CHAR(N' ')YesSAMANZ Allow NULL? 
103VARANZDisplay Variantschar10CHAR(N' ')YesVARANZ Allow NULL? 
104LAGABOptions in warehouse processingchar10CHAR(N' ')YesLAGAB Allow NULL? 
105LIVARList variant for sales price calculationnvarchar20CHAR(N' ')YesTWSTLIVAR Allow NULL? 
106VKERVSales price determination sequencenvarchar20CHAR(N' ')YesTWEVEKERV_V Allow NULL? 
107BSARTPurchasing Document Typenvarchar40CHAR(N' ')YesT161ESART Allow NULL? 
108PSTYPItem Category in Purchasing Documentchar10CHAR(N' ')YesT163PSTYP Allow NULL? 
109KNTTPAccount Assignment Categorychar10CHAR(N' ')YesT163KKNTTP Allow NULL? 
110MISCHDetermine mixed pricechar10CHAR(N' ')YesWDFR_MISCH Allow NULL? 
111BPROTSave confirmation logchar10CHAR(N' ')YesWDFR_BPROT Allow NULL? 
112ABNERDetermine recipientschar10CHAR(N' ')YesWDFR_ABNER Allow NULL? 
113ATPERDetermine ATP stockchar10CHAR(N' ')YesWDFR_ATPER Allow NULL? 
114FVBERDetermine stockchar10CHAR(N' ')YesWDFR_FVBER Allow NULL? 
115UMSERDetermine saleschar10CHAR(N' ')YesWDFR_UMSER Allow NULL? 
116BVLERDetermine vendor purchase orderschar10CHAR(N' ')YesWDFR_BVLER Allow NULL? 
117UAVERDetermine store POschar10CHAR(N' ')YesWDFR_UAVER Allow NULL? 
118DIFERDetermine remaining quantitychar10CHAR(N' ')YesWDFR_DIFER Allow NULL? 
119INFERAnalyze info structurechar10CHAR(N' ')YesWDFR_INFER Allow NULL? 
120KALERDetermine price from price calculationchar10CHAR(N' ')YesWDFR_KALER Allow NULL? 
121SORERRefine datachar10CHAR(N' ')YesWDFR_SORER Allow NULL? 
122TEXT_TITELDescriptionnvarchar200CHAR(N' ')YesVTEXT Allow NULL? 
123TEXT_TITEL_40Text for title, length 40nvarchar400CHAR(N' ')YesW_TITEL_2 Allow NULL? 
124FBEZCHDescriptionnvarchar400CHAR(N' ')YesBEZEI40 Allow NULL? 
125ERDATDate on Which Record Was Creatednvarchar80DATS(N'00000000')YesERDAT Allow NULL? 
126AEDATChanged Onnvarchar80DATS(N'00000000')YesAEDAT Allow NULL? 
127ERNAMName of Person who Created the Objectnvarchar120CHAR(N' ')YesERNAM Allow NULL? 
128AENAMName of Person Who Changed Objectnvarchar120CHAR(N' ')YesAENAM Allow NULL? 
129GEDATField of type DATSnvarchar80DATS(N'00000000')YesDATS Allow NULL? 
130GETIMETime in CHAR Formatnvarchar60CHAR(N' ')YesTIME Allow NULL? 
131KAPPLApplicationnvarchar20CHAR(N' ')Yes*KAPPL Allow NULL? 
NamePrimaryUniqueTypeColumns
WDFR_DISP~0YesYesCLUSTEREDMANDT, FBELN

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