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

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
Logistics - General :: Logistics Basic Data :: Promotion
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0WRF_DISPRO_TD322Time-Dependent Data for PromotionsPromotion
SQL:  selectupdate insert create

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

SELECT MANDT, AKTNR, MATNR, WERKS, MEM_FLAG, DISPRO_LEVEL, VALID_FROM_STOCK, VALID_TO_STOCK, MIN_STOCK, IND_MIN_STOCK, MAX_STOCK, IND_MAX_STOCK, SEND_FLAG_STOCK, DEL_FLAG_STOCK, STOCK_NOT_RELEV, VALID_FROM_PROCY, VALID_TO_PROCY, PLANNING_CYCLE, IND_PLAN_CYCLE, DELIVERY_CYCLE, IND_DEL_CYCLE, SEND_FLAG_PROCY, DEL_FLAG_PROCY, PROCY_NOT_RELEV, VALID_FROM_PLIFZ, VALID_TO_PLIFZ, PLIFZ_TD, IND_PLIFZ_TD, SEND_FLAG_PLIFZ, DEL_FLAG_PLIFZ, PLIFZ_NOT_RELEV, DISPRO_SOURCE FROM WRF_DISPRO_TD
ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1MANDTClientnvarchar30 Allow NULL? 
2AKTNRPromotionnvarchar100 Allow NULL? 
3MATNRMaterial Numbernvarchar180 Allow NULL? 
4WERKSPlantnvarchar40 Allow NULL? 
5MEM_FLAGHold Item due to Connection to SAP F&Rchar10 Allow NULL? 
6DISPRO_LEVELOrigin Level of Time-Dependent Data for Promotionschar10 Allow NULL? 
7VALID_FROM_STOCKTime-Dependent Stock Data for Promotions Is Valid Fromnvarchar80 Allow NULL? 
8VALID_TO_STOCKTime-Dependent Stock Data for Promotions Is Valid Tonvarchar80 Allow NULL? 
9MIN_STOCKMinimum Stock Leveldecimal133
10IND_MIN_STOCKIndicator for Inclusion of Minimum Stock Levelchar10 Allow NULL? 
11MAX_STOCKMaximum Stock Leveldecimal133
12IND_MAX_STOCKIndicator for Inclusion of Maximum Stock Levelchar10 Allow NULL? 
13SEND_FLAG_STOCKAnalysis Indicator for Time-Based Stock Level for Promotionschar10 Allow NULL? 
14DEL_FLAG_STOCKResend Time-Based Stock Data Due to Changechar10 Allow NULL? 
15STOCK_NOT_RELEVTD Stock Not Relevant for SAP F&Rchar10 Allow NULL? 
16VALID_FROM_PROCYValid-From Date for Time-Based Proc.Cyc. Data for Promotionsnvarchar80 Allow NULL? 
17VALID_TO_PROCYValid-To Date for Time-Dep. Proc. Cycle Data for Promotionsnvarchar80 Allow NULL? 
18PLANNING_CYCLEPlanning cyclenvarchar30 Allow NULL? 
19IND_PLAN_CYCLEIndicator for Treatment of Replenishment Planning Cycleschar10 Allow NULL? 
20DELIVERY_CYCLEPPC planning calendarnvarchar30 Allow NULL? 
21IND_DEL_CYCLEIndicator for Treatment of Delivery Cyclechar10 Allow NULL? 
22SEND_FLAG_PROCYAnalysis Ind.for Time-Based Procurement Cycle for Promotionschar10 Allow NULL? 
23DEL_FLAG_PROCYResend Time-Dep. Procurement Cycle Data Due to Changechar10 Allow NULL? 
24PROCY_NOT_RELEVTD Procurement Cycle Not Relevant for SAP F&Rchar10 Allow NULL? 
25VALID_FROM_PLIFZValid-From Date for Time-Based Plan. Deliv. Time Datanvarchar80 Allow NULL? 
26VALID_TO_PLIFZValid-To Date for Time-Dep. Plan. Deliv. Time Datanvarchar80 Allow NULL? 
27PLIFZ_TDPlanned Delivery Time Time-dependent in Daysdecimal30
28IND_PLIFZ_TDIndicator for Planned Delivery Timechar10 Allow NULL? 
29SEND_FLAG_PLIFZAnalysis of Time-Based Planned Delivery Timechar10 Allow NULL? 
30DEL_FLAG_PLIFZResend Time-Dependent Plan. Del. Time Data Due to Changechar10 Allow NULL? 
31PLIFZ_NOT_RELEVTD Plan. Deliv. Time Not Relevant for F&Rchar10 Allow NULL? 
32DISPRO_SOURCESource of Data Recordchar10 Allow NULL? 
NamePrimaryUniqueTypeColumns
WRF_DISPRO_TD~0YesYesCLUSTEREDMANDT, AKTNR, MATNR, WERKS, MEM_FLAG
WRF_DISPRO_TD~MATNoNoNONCLUSTEREDMANDT, MATNR, WERKS