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

104 columns | Print definition?ERP 6.0  | AKTNR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000183000PSA for 2LIS_12_VCITM T90CLNT090 Delivery Item34AKTNRnvarchar100
2/BIC/B0000185000PSA for 2LIS_13_VDITM T90CLNT090 Billing Doc. Item25AKTNRnvarchar100
3/BIC/B0000186000PSA for 2LIS_13_VDKON T90CLNT090 Billing Docu. Cond.24AKTNRnvarchar100
4/BIC/B0000187000PSA for 2LIS_02_ITM T90CLNT090 Purch. Data (Item)28AKTNRnvarchar100
5/BIC/B0000189000PSA for 2LIS_02_SCL T90CLNT090 Purch.Data Sch.Line28AKTNRnvarchar100
6CNVTDMS_05_WAKHICollector Table for Entries in Table WAKHIND4AKTNRAction for CNVTDMS_05_*nvarchar100
7DMF_D_PROMOTransferred promotions3AKTNRPromotionnvarchar100
8REFXCN_PROMCATPromotional Data2AKTNRPromotionnvarchar100
9ZEIM_LIPSSD document: Delivery: Item data152AKTNRPromotionnvarchar100
TOPAgency Business Global Trade
10WBRPAgency business: Item59AKTNRPromotionnvarchar100
TOPAllocation
11AUBSIWorklist for PO (Follow-on Document Generation)33AKTNRPromotionnvarchar100
12AUKAIWorklist for Sales Orders (FBG)25AKTNRPromotionnvarchar100
13AUPOAllocation Table Document Item18AKTNRPromotionnvarchar100
14AUUMIWorklist for Stock Transport Orders (Follow-on Doc. Gen.)32AKTNRPromotionnvarchar100
15AUVDIWorklist for Deliveries (Follow-on Doc. Generation)46AKTNRPromotionnvarchar100
TOPBilling
16VBRPBilling Document: Item Data131AKTNRPromotionnvarchar100
TOPCollectionsDisbursements
17TKKVMAKTDunning Activities4AKTNRActivity Number of a Dunning Levelnvarchar30
18VVKKMAKTExecuted Dunning Activities7AKTNRActivity Number of a Dunning Levelnvarchar30
TOPConditions
19KONAAgreements40AKTNRPromotionnvarchar100
20KONHConditions (Header)18AKTNRPromotionnvarchar100
21KONPConditions (Item)52AKTNRPromotionnvarchar100
TOPConsumption-Based Planning See Also PP-MRP
22WSAF_PROMO_DELTAChange Information for Promotions3AKTNRPromotionnvarchar100
TOPCross-Application Components
23FRE_DB_ABI_HEADHeader table for DIF occurrence2AKTNRPromotionnvarchar100
24FRE_DB_ABI_POSItem table for DIF occurrence2AKTNRPromotionnvarchar100
TOPData Collection
25S086Promotion8AKTNRPromotionnvarchar100
26S086ES086 - Structural Information3AKTNRPromotionnvarchar100
27S117Receipt/article29AKTNRPromotionnvarchar100
28S120Sales as per receipts31AKTNRPromotionnvarchar100
29S120BIW1S120BIW1 * Sales as Per Receipts31AKTNRPromotionnvarchar100
30S120BIW2S120BIW2 * Sales as Per Receipts31AKTNRPromotionnvarchar100
31S121Material aggregation - POS11AKTNRPromotionnvarchar100
32S121ES121 - Structural Information6AKTNRPromotionnvarchar100
33S270Do not use!43AKTNRPromotionnvarchar100
34S270BIW1Do not use!43AKTNRPromotionnvarchar100
35S270BIW2Do not use!43AKTNRPromotionnvarchar100
36S271Do not use!24AKTNRPromotionnvarchar100
37S271BIW1Do not use!24AKTNRPromotionnvarchar100
38S271BIW2Do not use!24AKTNRPromotionnvarchar100
39S272Do not use!42AKTNRPromotionnvarchar100
40S272BIW1Do not use!42AKTNRPromotionnvarchar100
41S272BIW2Do not use!42AKTNRPromotionnvarchar100
42S273Do not use!25AKTNRPromotionnvarchar100
43S273BIW1Do not use!25AKTNRPromotionnvarchar100
44S273BIW2Do not use!25AKTNRPromotionnvarchar100
45S275Transfer BW: Einkaufsdaten33AKTNRActienvarchar100
46S275BIW1S275BIW1 * Transfer to BW: Purchasing Data33AKTNRPromotionnvarchar100
47S275BIW2S275BIW2 * Transfer to BW: Purchasing Data33AKTNRPromotionnvarchar100
48S276Transfer BW: Vertriebsdaten29AKTNRActienvarchar100
49S276BIW1S276BIW1 * Transfer to BW: Sales and Distribution Data29AKTNRPromotionnvarchar100
50S276BIW2S276BIW2 * BW Transfer: Sales and Distribution Data29AKTNRPromotionnvarchar100
51S277Transfer BW: VP-Umbewertung25AKTNRActienvarchar100
52S277BIW1S277BIW1 * Transfer to BW: Revaluation at Retail25AKTNRPromotionnvarchar100
53S277BIW2S277BIW2 * Transfer to BW: Revaluation at Retail25AKTNRPromotionnvarchar100
54S279Transfer BW: Bestandsführung24AKTNRActienvarchar100
55S279BIW1S279BIW1 * BW Transfer: Inventory Management24AKTNRPromotionnvarchar100
56S279BIW2S279BIW2 * BW Transfer: Inventory Management24AKTNRPromotionnvarchar100
57S953BW Vorl.für BON/Artikel S11729AKTNRAktionnvarchar100
TOPDefense Forces and Public Security
58/ISDFPS/ZEBANCopy of EBAN81AKTNRPromotionnvarchar100
TOPFree Goods
59KONBBYHBonus Buys: Header14AKTNRPromotionnvarchar100
TOPInventory Management
60MSEGDocument Segment: Material139AKTNRPromotionnvarchar100
61MWXMSEGZMSEG: Interface for Posting of Value139AKTNRPromotionnvarchar100
62MWZMSEGZMSEG:Interface for Posting of Value139AKTNRPromotionnvarchar100
63USEGRetail Revaluation Document: Revaluation Segment21AKTNRPromotionnvarchar100
TOPInvoice Verification
64RBDRSEGBatch IV: Invoice Document Items82AKTNRPromotionnvarchar100
TOPMaterials Management
65/ISDFPS/CS_EXLSTException List: Overwritten Purchase Requisitions86AKTNRPromotionnvarchar100
TOPMerchandise and Assortment Planning
66TWISPS_NOPROMO1Parameters for Promotions Created in MAP2AKTNRPromotionnvarchar100
TOPPerishables Procurement
67FIP_D_PROMOPromotion data3AKTNRPromotionnvarchar100
68FIP_D_PROMO_TPromotion data Texts2AKTNRPromotionnvarchar100
TOPPOS Interface
69WVFBDRS Interface, Intermediate Buffer, Order Item FM31AKTNRPromotionnvarchar100
TOPPrice Planning Workbench
70WRF_PPW_PPDHEADPPD Header7AKTNRPromotion Numbernvarchar100
TOPProduct Catalog
71WWMIProduct catalog4AKTNRPromotionnvarchar100
TOPPromotion
72WAALMaterial-to-vendor assignment in price maintenance (promo.)2AKTNRPromotionnvarchar100
73WAELDelivery Phases in Retail Promotion2AKTNRPromotionnvarchar100
74WAGUValidity of plant groups - IS-R2AKTNRPromotionnvarchar100
75WAKCAssignment of Coupons to Promotion2AKTNRPromotionnvarchar100
76WAKHPromotion Header Data, IS-R2AKTNRPromotionnvarchar100
77WAKHINDPromotion header data IS-R: index table for conditions3AKTNRPromotionnvarchar100
78WAKPPromotion Item Data2AKTNRPromotionnvarchar100
79WAKRPromotion Discounts2AKTNRPromotionnvarchar100
80WAKRWPromotion discounts by plant2AKTNRPromotionnvarchar100
81WAKTPromotion description short text, IS-R2AKTNRPromotionnvarchar100
82WALEMaterial to store assignment to promotion2AKTNRPromotionnvarchar100
83WARNGSaving of RANGES2AKTNRPromotionnvarchar100
84WAZBModule plant-group assignment2AKTNRPromotionnvarchar100
85WAZTPromotion/themes assignment2AKTNRPromotionnvarchar100
86WAZWPromotion/advertising media assignment2AKTNRPromotionnvarchar100
87WMATSITEQTYTIMEMaterial Quantities in Sites for Promotion Periods2AKTNRPromotionnvarchar100
88WMFPMarkdown Planning - item data (materials)12AKTNRPromotionnvarchar100
89WRF_DISPRO_DF_QWorklist for Assignm of TD Promo Data after Changes to Promo2AKTNRPromotionnvarchar100
90WRF_DISPRO_QUEUEWorklist After Changes to Promotions2AKTNRPromotionnvarchar100
91WRF_DISPRO_TDTime-Dependent Data for Promotions2AKTNRPromotionnvarchar100
92WRF_RPR_WAPGAssignment of Plant Grouping to Local Plant Group No.2AKTNRPromotionnvarchar100
93WRF_RPR_WAPGTPlant Group Descr. Short Text2AKTNRPromotionnvarchar100
94WRF_RPR_WAPLAssignment of Plants to Local Plant Groups2AKTNRPromotionnvarchar100
TOPPurchasing
95EBANPurchase Requisition81AKTNRPromotionnvarchar100
96EKPOPurchasing Document Item133AKTNRPromotionnvarchar100
97MEREQXPurchase Requisition Change Parameter81AKTNRUpdated information in related user data fieldnvarchar10
98WDFR1Requirements Planning for Perishables46AKTNRPromotionnvarchar100
99WRF_POHF_POLOrder list29AKTNRPromotionnvarchar100
TOPRemaining Beverage - Obsolete Objects
100/BEV1/RBKPCopy Table for KONP for Accrual (Field KBRUE)52AKTNRPromotionnvarchar100
TOPRetail Enterprise Services
101WESD_BBY_SENTBonus Buy: Stores Supplied via Service6AKTNRPromotionnvarchar100
102WESD_PROMO_SENTRetail Promotion: Stores Supplied via Service4AKTNRPromotionnvarchar100
TOPShipping
103LIPSSD document: Delivery: Item data152AKTNRPromotionnvarchar100
TOPSimulation
104VSEBAN_CNVersion: Purchase requisition81AKTNRPromotionnvarchar100