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

51 columns | Print definition?ERP 6.0  | RSPOS

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1ZEIM_LIPSSD document: Delivery: Item data185RSPOSItem Number of Reservation/Dependent Requirementnvarchar40
TOPAllocation
2AUPOAllocation Table Document Item15RSPOSItem Number of Reservation/Dependent Requirementnvarchar40
TOPAssortment List
3WDLSPPOS outbound log: IDoc (items)14RSPOSItem created due to restartnvarchar10
TOPBasic Functions
4FPLABilling Plan25RSPOSItem Number of Reservation/Dependent Requirementnvarchar40
5FPLAPOBilling Plan25RSPOSItem Number of Reservation/Dependent Requirementnvarchar40
6VFPLABilling Plan25RSPOSItem Number of Reservation/Dependent Requirementnvarchar40
TOPBatches
7CHVW_PREPreliminary Batch Where-used List According to Order/PO11RSPOSItem Number of Reservation/Dependent Requirementnvarchar40
TOPClinical System
8N1DRUGDOCIS-H*MED: Drug Documentation14RSPOSMedication: Document Number of Reservationnvarchar40
TOPConfirmations
9AFFWGoods Movements with Errors from Confirmations27RSPOSItem Number of Reservation/Dependent Requirementnvarchar40
TOPConstruction Equipment Management
10J_3GBELPDocument Data - Item Data192RSPOSItem Number of Reservation/Dependent Requirementnvarchar40
TOPConsumer Products for Food Beverage
11CFB_BACKFLUSHBackflush of Batches3RSPOSItem Number of Reservation/Dependent Requirementnvarchar40
TOPCross-Application Components
12ONROKObject number index for material component/reservation4RSPOSItem Number of Reservation/Dependent Requirementnvarchar40
TOPInformation System
13MCCOMPVVersions: Material Components6RSPOSItem Number of Reservation/Dependent Requirementnvarchar40
TOPInventory Management
14MSEGDocument Segment: Material74RSPOSItem Number of Reservation/Dependent Requirementnvarchar40
15MWXMSEGZMSEG: Interface for Posting of Value74RSPOSItem Number of Reservation/Dependent Requirementnvarchar40
16MWZMSEGZMSEG:Interface for Posting of Value74RSPOSItem Number of Reservation/Dependent Requirementnvarchar40
17RESBReservation/dependent requirements3RSPOSItem Number of Reservation/Dependent Requirementnvarchar40
18T159ATest Data for Batch Input in Inventory Management22RSPOSItem number of reservation (batch input format)nvarchar40
TOPKANBAN
19PKPSControl Cycle Item / Kanban18RSPOSItem Number of Reservation/Dependent Requirementnvarchar40
TOPLogbook
20DIACL_CLISTDI CLIST: Component data3RSPOSItem Number of Reservation/Dependent Requirementnvarchar40
TOPMaintenance History
21HIMAPM order history - materials4RSPOSItem Number of Reservation/Dependent Requirementnvarchar40
TOPMaintenance Orders
22AUFMGoods movements for order31RSPOSItem Number of Reservation/Dependent Requirementnvarchar40
TOPMaster Data
23PKTMPConversion table for PKPS / please do not use17RSPOSItem Number of Reservation/Dependent Requirementnvarchar40
24REULMaterial stock transfer reservation index5RSPOSItem Number of Reservation/Dependent Requirementnvarchar40
25RSDBIndex of the RESB for the Direct Procurement Element3RSPOSItem Number of Reservation/Dependent Requirementnvarchar40
TOPMaterial
26RSADDAdditional fields for reservation3RSPOSItem Number of Reservation/Dependent Requirementnvarchar40
27RSDBSIndex of purchasing documents for individual customer stock3RSPOSItem Number of Reservation/Dependent Requirementnvarchar40
28RSPSPIndex: Reservations for WBS elements/Sales order items3RSPOSItem Number of Reservation/Dependent Requirementnvarchar40
TOPMaterial Identification and Reconciliation
29BEREITMaterial identification: staging data5RSPOSItem Number of Reservation/Dependent Requirementnvarchar40
30HUM_KOMMIHUM Picking with Partial GI Posting11RSPOSItem Number of Reservation/Dependent Requirementnvarchar40
31MISTATUSStatus Table for Material Identification on Mat./Batch Level3RSPOSItem Number of Reservation/Dependent Requirementnvarchar40
TOPNetwork and Activity
32TCNTM05Assignment Components to Groups3RSPOSItem Number of Reservation/Dependent Requirementnvarchar40
33TCNTM06Dates for Components, Events and Date Type3RSPOSItem Number of Reservation/Dependent Requirementnvarchar40
34TCNTM07Status of a Date Type for a Component3RSPOSItem Number of Reservation/Dependent Requirementnvarchar40
TOPPegging, Grouping, and Distribution
35PEG_TACTASSPegging: Current Assignments Based on Goods Movements13RSPOSItem Number of Reservation/Dependent Requirementnvarchar40
TOPProduction Backflush
36PPC_MATSuper BOM for Backflushed Materials14RSPOSItem Number of Reservation/Dependent Requirementnvarchar40
TOPProduction Orders
37FTINDMissing parts index5RSPOSItem Number of Reservation/Dependent Requirementnvarchar40
TOPProject System
38PSHLPDB_HIER_TMPTable to store temporary hierarchy data24RSPOSItem Number of Reservation/Dependent Requirementnvarchar40
TOPRepetitive Manufacturing
39COMPMOVEGoods Movement of Components49RSPOSItem Number of Reservation/Dependent Requirementnvarchar40
TOPSCM Basis
40CIFRVMAPMapping Table NR/POS/ET <-> APO GUID (Sales Orders)3RSPOSItem Number of Reservation/Dependent Requirementnvarchar40
TOPSelf-Service Procurement
41/SRMERP/D_SC_ITMShopping Cart Item68RSPOSItem Number of Reservation/Dependent Requirementnvarchar40
TOPShipping
42LIPSSD document: Delivery: Item data185RSPOSItem Number of Reservation/Dependent Requirementnvarchar40
43VRSLIReceipt of Materials from Deliveries8RSPOSItem Number of Reservation/Dependent Requirementnvarchar40
TOPSimulation
44VSFPLA_CNVersion: Billing schedule26RSPOSItem Number of Reservation/Dependent Requirementnvarchar40
45VSHIST_OKTransfer history material components3RSPOSItem Number of Reservation/Dependent Requirementnvarchar40
46VSRESB_CNVersion: Reservation/Dependent requirements4RSPOSItem Number of Reservation/Dependent Requirementnvarchar40
47VSRSADD_CNVersion: Additional fields for reservation4RSPOSItem Number of Reservation/Dependent Requirementnvarchar40
48VSRSDB_CNVersion: Index of RESB for direct procurement elements4RSPOSItem Number of Reservation/Dependent Requirementnvarchar40
TOPStructures Workbench
49/ISDFPS/MATSPPLNMaterials Planned for Force Element69RSPOSItem Number of Reservation/Dependent Requirementnvarchar40
TOPWarehouse Management
50LTAPTransfer order item104RSPOSItem Number of Reservation/Dependent Requirementnvarchar40
51LTBPTransfer requirement item33RSPOSItem Number of Reservation/Dependent Requirementnvarchar40