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

36 columns | Print definition?ERP 6.0  | KDEIN

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1ZEIM_AFPOOrder item13KDEINDelivery Schedule for Sales Ordernvarchar40
TOPConfirmations
2AFFWGoods Movements with Errors from Confirmations17KDEINDelivery Schedule for Sales Ordernvarchar40
TOPContract Accounts Receivable and Payable
3DFKKDEFREV_POSLine Item Table (Event-Based Deferred Revenues)34KDEINDelivery Schedule for Sales Ordernvarchar40
4DFKKMOPKItems in contract account document13KDEINDelivery Schedule for Sales Ordernvarchar40
5DFKKOPKItems in contract account document13KDEINDelivery Schedule for Sales Ordernvarchar40
6DFKKORDERPOSRequests: Items50KDEINDelivery Schedule for Sales Ordernvarchar40
7DFKKORDERPOS_SRequest Templates: Items44KDEINDelivery Schedule for Sales Ordernvarchar40
8DFKKSUMPosting totals from FI-CA22KDEINDelivery Schedule for Sales Ordernvarchar40
9DFKKSUMOLDTotals Records Without Account Assignment Changes9KDEINDelivery Schedule for Sales Ordernvarchar40
10FKKDEFREVTrigger Table for Deferred Revenue Postings22KDEINDelivery Schedule for Sales Ordernvarchar40
TOPData Retention Tool
11TXW_S_MSEGRetrieve MSEG from archive35KDEINDelivery Schedule for Sales Ordernvarchar40
TOPElectronic Bank Statement
12FEB_ACCNT_SAVESaving of Posting Lines for Postprocessing (Account Assign.)45KDEINDelivery Schedule for Sales Ordernvarchar40
13FEB_ACTAcct Assignment Templates45KDEINDelivery Schedule for Sales Ordernvarchar40
TOPFinancial Accounting
14VBSEGADocument Segment for Document Parking - Asset Database47KDEINDelivery Schedule for Sales Ordernvarchar40
15VBSEGSDocument Segment for Document Parking - G/L Account Database89KDEINDelivery Schedule Line Numbernvarchar40
TOPFunds Management-Specific Postings
16FMFUNDTRANSYEARAdditional Documents for Funds Transfer to Diff. Years88KDEINDelivery Schedule Line Numbernvarchar40
17PSOSEGSRecurring Request Document Segment, G/L Accounts87KDEINDelivery Schedule Line Numbernvarchar40
TOPGL Account Posting
18TCJ_POSITIONSCash Journal Document Items52KDEINDelivery Schedule for Sales Ordernvarchar40
TOPInformation System
19MCAFPOVVersions: Order Item30KDEINDelivery Schedule for Sales Ordernvarchar40
20MCCOMPVVersions: Material Components20KDEINDelivery Schedule for Sales Ordernvarchar40
TOPInventory Management
21ISEGPhysical Inventory Document Items13KDEINDelivery Schedule for Sales Ordernvarchar40
22MSEGDocument Segment: Material23KDEINDelivery Schedule for Sales Ordernvarchar40
23MWXMSEGZMSEG: Interface for Posting of Value23KDEINDelivery Schedule for Sales Ordernvarchar40
24MWZMSEGZMSEG:Interface for Posting of Value23KDEINDelivery Schedule for Sales Ordernvarchar40
25RESBReservation/dependent requirements36KDEINDelivery Schedule for Sales Ordernvarchar40
26RKPFDocument Header: Reservation19KDEINDelivery Schedule for Sales Ordernvarchar40
TOPMaster Data
27KDPLIndex customer order -> planned order4KDEINDelivery Schedule for Sales Ordernvarchar40
28MDSMSimulative dependent requirements92KDEINDelivery Schedule for Sales Ordernvarchar40
29PLAFPlanned Order24KDEINDelivery Schedule for Sales Ordernvarchar40
30PSPLIndex project -> planned order9KDEINDelivery Schedule for Sales Ordernvarchar40
TOPProduction Orders
31AFPOOrder item13KDEINDelivery Schedule for Sales Ordernvarchar40
TOPProfit Center Accounting
32GLPCPEC-PCA: Plan Line Items132KDEINDelivery Schedule for Sales Ordernvarchar40
TOPRepetitive Manufacturing
33COMPMOVEGoods Movement of Components118KDEINDelivery Schedule for Sales Ordernvarchar40
TOPSimulation
34VSAFPO_CNVersion: Order items in PP orders14KDEINDelivery Schedule for Sales Ordernvarchar40
35VSPLAF_CNVersion: Planned order25KDEINDelivery Schedule for Sales Ordernvarchar40
36VSRESB_CNVersion: Reservation/Dependent requirements37KDEINDelivery Schedule for Sales Ordernvarchar40