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

52 columns | Print definition?ERP 6.0  | BEDAT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000187000PSA for 2LIS_02_ITM T90CLNT090 Purch. Data (Item)6BEDATnvarchar80
2/BIC/B0000188000PSA for 2LIS_02_HDR T90CLNT090 Purch.Data (Header)9BEDATnvarchar80
3/BIC/B0000189000PSA for 2LIS_02_SCL T90CLNT090 Purch.Data Sch.Line6BEDATnvarchar80
4FIEUD_MMINV_ISAFT:MM: Item Details for XML Purchase Invoice10BEDATPurchase Order Datenvarchar80
5FIWTQAD_CERTWithholding tax certificate details9BEDATPurchasing Document Datenvarchar80
6IDSAU_WT_CERTWithholding tax certificate details9BEDATPurchasing Document Datenvarchar80
7P2RB_I0125Garnishment payroll Belgium35BEDATDate signaturenvarchar80
8PA0297HR Master Record: Infotype 0297 Work conditions47BEDATStart Datenvarchar80
TOPAllocation
9AUBSIWorklist for PO (Follow-on Document Generation)2BEDATPurchase Order Datenvarchar80
10AUFIAllocation Table, Document Sub-item, Stores27BEDATPurchase Order Datenvarchar80
11AULWDelivery Phases21BEDATOrder date/ latest date for generating follow-on documentsnvarchar80
12AUVWDelivery Phase for Distribution Center17BEDATOrder date/ latest date for generating follow-on documentsnvarchar80
TOPBasic Functions
13FPLABilling Plan6BEDATStart date for billing plan/invoice plannvarchar80
14FPLAPOBilling Plan6BEDATStart date for billing plan/invoice plannvarchar80
15VBSKCollective Processing for a Sales Document Header25BEDATDate of deliveries in picking wavesnvarchar80
16VFPLABilling Plan6BEDATStart date for billing plan/invoice plannvarchar80
TOPBelgium
17PA0125HR Master Record: Infotype 0125 (Garnishment B)42BEDATDate signaturenvarchar80
TOPCross-Application Components
18FRE_OP_ITEM_INF&R CON R/3 - Order Proposal Inbound Item Buffer13BEDATOrder date of schedule linenvarchar80
TOPData Collection
19S270Do not use!44BEDATDocument datenvarchar80
20S270BIW1Do not use!44BEDATDocument datenvarchar80
21S270BIW2Do not use!44BEDATDocument datenvarchar80
22S275Transfer BW: Einkaufsdaten34BEDATDatum van inkoopdocumentnvarchar80
23S275BIW1S275BIW1 * Transfer to BW: Purchasing Data34BEDATPurchasing Document Datenvarchar80
24S275BIW2S275BIW2 * Transfer to BW: Purchasing Data34BEDATPurchasing Document Datenvarchar80
TOPData Retention Tool
25TXW_S_EKKORetrieve EKKO from archive10BEDATPurchasing Document Datenvarchar80
TOPDefense Forces and Public Security
26/ISDFPS/ZEBANCopy of EBAN61BEDATPurchase Order Datenvarchar80
TOPMaterials Management
27/ISDFPS/CS_EXLSTException List: Overwritten Purchase Requisitions66BEDATPurchase Order Datenvarchar80
TOPPayroll
28PA0637Személyügyi törzsrekord 0637 infótípus28BEDATBejelentés idopontjanvarchar80
TOPPOS Interface
29WVFBDRS Interface, Intermediate Buffer, Order Item FM34BEDATOrder date of schedule linenvarchar80
30WVFB2SRS: received external requirement numbers/phys. inv. nos5BEDATOrder date of schedule linenvarchar80
TOPProduct Cost Planning
31KALACosting Run: General Data/Parameters10BEDATRequirements Datenvarchar80
32KALMCosting Run: Costing Objects34BEDATRequirements Datenvarchar80
33KALOCosting Run: Costing Objects (KVMK)28BEDATRequirements Datenvarchar80
34KEKOProduct Costing - Header Data20BEDATRequirements Datenvarchar80
TOPPromotion
35WAKPPromotion Item Data46BEDATOrder date with vendornvarchar80
TOPPurchase Orders
36WBO1Log header file for simulative list for load building18BEDATPurchase Order Datenvarchar80
TOPPurchasing
37EBANPurchase Requisition61BEDATPurchase Order Datenvarchar80
38EIPAOrder Price History: Info Record8BEDATPurchase Order Datenvarchar80
39EKABRelease Documentation6BEDATPurchase Order Datenvarchar80
40EKETScheduling Agreement Schedule Lines19BEDATOrder date of schedule linenvarchar80
41EKETHScheduling Agreement Schedules: History Tables19BEDATOrder date of schedule linenvarchar80
42EKKOPurchasing Document Header26BEDATPurchasing Document Datenvarchar80
43MEREQXPurchase Requisition Change Parameter61BEDATUpdated information in related user data fieldnvarchar10
44WDFR_DISPPerishables Planning Header91BEDATPurchase Order Datenvarchar80
45WRF_PRCT_WL_ITEMOriginal Table for Worklist Items10BEDATPurchase Order Datenvarchar80
46WRF_PRCT_WL_SHDWShadow Table for Worklist Items13BEDATPurchase Order Datenvarchar80
TOPPurchasing Information System
47MCEKSR/2 PURCHIS Data (Status: Last Data Transmission)28BEDATPurchase Order Datenvarchar80
TOPSAP Retail Store
48WOSASAP Retail Store, Store Orders: Entities Table8BEDATPurchase Order Datenvarchar80
TOPShipping
49LIPSPOLIPS Reference Data Purchase Order13BEDATPurchase Order Datenvarchar80
TOPSimulation
50VSEBAN_CNVersion: Purchase requisition62BEDATPurchase Order Datenvarchar80
51VSFPLA_CNVersion: Billing schedule7BEDATStart date for billing plan/invoice plannvarchar80
TOPTraders and Schedulers Workbench
52S431PURCHIS: (OIL-TSW) Purchasing document stats by TSW object27BEDATPurchase Order Datenvarchar80