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

74 columns | Print definition?ERP 6.0  | RSNUM

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNVTDMS_05_RESBTDMS Header table for RESB table3RSNUMRSNUM for table CNVTDMS_05_RSEBnvarchar100
2ZEIM_LIPSSD document: Delivery: Item data184RSNUMNumber of Reservation/Dependent Requirementnvarchar100
TOPAllocation
3AUPOAllocation Table Document Item14RSNUMNumber of Reservation/Dependent Requirementnvarchar100
TOPBasic Functions
4FEBREReference record for electronic bank statement line item4RSNUMCopied record numbernvarchar30
5FPLABilling Plan24RSNUMNumber of Reservation/Dependent Requirementnvarchar100
6FPLAPOBilling Plan24RSNUMNumber of Reservation/Dependent Requirementnvarchar100
7VFPLABilling Plan24RSNUMNumber of Reservation/Dependent Requirementnvarchar100
TOPBatches
8CHVW_PREPreliminary Batch Where-used List According to Order/PO10RSNUMNumber of Reservation/Dependent Requirementnvarchar100
TOPClinical System
9N1DRUGDOCIS-H*MED: Drug Documentation13RSNUMMedication: Number of Reservation / Dependent Requirementnvarchar100
TOPConfirmations
10AFFWGoods Movements with Errors from Confirmations26RSNUMNumber of Reservation/Dependent Requirementnvarchar100
11AFRP2Table of planned changes for confirmation: Backflushing5RSNUMNumber of Reservation/Dependent Requirementnvarchar100
TOPConstruction Equipment Management
12J_3GBELPDocument Data - Item Data191RSNUMNumber of Reservation/Dependent Requirementnvarchar100
TOPConsumer Products for Food Beverage
13CFB_BACKFLUSHBackflush of Batches2RSNUMNumber of Reservation/Dependent Requirementnvarchar100
TOPCross-Application Components
14ONROKObject number index for material component/reservation3RSNUMNumber of Reservation/Dependent Requirementnvarchar100
TOPDefense Forces and Public Security
15/ISDFPS/ZEBANCopy of EBAN67RSNUMNumber of Reservation/Dependent Requirementnvarchar100
TOPElectronic Bank Statement
16FEBRE_ORIGOriginal Ref. Record for an Elec. Bank Statement Line Item4RSNUMCopied record numbernvarchar30
TOPInformation System
17MCCOMPVVersions: Material Components5RSNUMNumber of Reservation/Dependent Requirementnvarchar100
18MCSFISR/2 SFIS Data: Old5RSNUMNumber of Reservation/Dependent Requirementnvarchar100
TOPInterface to Terminal Automation System
19OIK02BIS-OIL/TAS: Status of processed functions - messages23RSNUMNumber of Reservation/Dependent Requirementnvarchar100
TOPInventory Management
20MSEGDocument Segment: Material73RSNUMNumber of Reservation/Dependent Requirementnvarchar100
21MWXMSEGZMSEG: Interface for Posting of Value73RSNUMNumber of Reservation/Dependent Requirementnvarchar100
22MWZMSEGZMSEG:Interface for Posting of Value73RSNUMNumber of Reservation/Dependent Requirementnvarchar100
23RESBReservation/dependent requirements2RSNUMNumber of Reservation/Dependent Requirementnvarchar100
24RKPFDocument Header: Reservation2RSNUMNumber of Reservation/Dependent Requirementnvarchar100
25T159ATest Data for Batch Input in Inventory Management21RSNUMNumber of reservation (batch input format)nvarchar100
TOPKANBAN
26PKPSControl Cycle Item / Kanban17RSNUMNumber of Reservation/Dependent Requirementnvarchar100
TOPLogbook
27DIACL_CLISTDI CLIST: Component data2RSNUMNumber of Reservation/Dependent Requirementnvarchar100
TOPMaintenance Orders
28AUFMGoods movements for order30RSNUMNumber of Reservation/Dependent Requirementnvarchar100
TOPMaster Data
29BLPKDocument log header31RSNUMNumber of Reservation/Dependent Requirementnvarchar100
30PKTMPConversion table for PKPS / please do not use16RSNUMNumber of Reservation/Dependent Requirementnvarchar100
31PLAFPlanned Order26RSNUMNumber of Reservation/Dependent Requirementnvarchar100
32REULMaterial stock transfer reservation index4RSNUMNumber of Reservation/Dependent Requirementnvarchar100
33RSDBIndex of the RESB for the Direct Procurement Element2RSNUMNumber of Reservation/Dependent Requirementnvarchar100
34SAFKRun Schedule Master Data40RSNUMNumber of Reservation/Dependent Requirementnvarchar100
TOPMaterial
35RSADDAdditional fields for reservation2RSNUMNumber of Reservation/Dependent Requirementnvarchar100
36RSDBSIndex of purchasing documents for individual customer stock2RSNUMNumber of Reservation/Dependent Requirementnvarchar100
37RSPSPIndex: Reservations for WBS elements/Sales order items2RSNUMNumber of Reservation/Dependent Requirementnvarchar100
TOPMaterial Identification and Reconciliation
38BEREITMaterial identification: staging data4RSNUMNumber of Reservation/Dependent Requirementnvarchar100
39HUM_KOMMIHUM Picking with Partial GI Posting10RSNUMNumber of Reservation/Dependent Requirementnvarchar100
40MISTATUSStatus Table for Material Identification on Mat./Batch Level2RSNUMNumber of Reservation/Dependent Requirementnvarchar100
TOPMaterials Management
41/ISDFPS/CS_EXLSTException List: Overwritten Purchase Requisitions72RSNUMNumber of Reservation/Dependent Requirementnvarchar100
TOPNetwork and Activity
42TCNTM05Assignment Components to Groups2RSNUMNumber of Reservation/Dependent Requirementnvarchar100
43TCNTM06Dates for Components, Events and Date Type2RSNUMNumber of Reservation/Dependent Requirementnvarchar100
44TCNTM07Status of a Date Type for a Component2RSNUMNumber of Reservation/Dependent Requirementnvarchar100
TOPPegging, Grouping, and Distribution
45PEG_TACTASSPegging: Current Assignments Based on Goods Movements12RSNUMNumber of Reservation/Dependent Requirementnvarchar100
TOPProduction Backflush
46PPC_RES_HDRHeader for Postprocessing Reservations3RSNUMNumber of Reservation/Dependent Requirementnvarchar100
TOPProduction Orders
47AFKOOrder Header Data PP Orders13RSNUMNumber of Reservation/Dependent Requirementnvarchar100
48FTINDMissing parts index4RSNUMNumber of Reservation/Dependent Requirementnvarchar100
TOPProgress Tracking
49TXPDATExpediting Data22RSNUMNumber of Reservation/Dependent Requirementnvarchar100
TOPProject System
50PSHLPDB_HIER_TMPTable to store temporary hierarchy data23RSNUMNumber of Reservation/Dependent Requirementnvarchar100
TOPPurchasing
51EBANPurchase Requisition67RSNUMNumber of Reservation/Dependent Requirementnvarchar100
52EKETScheduling Agreement Schedule Lines20RSNUMNumber of Reservation/Dependent Requirementnvarchar100
53EKETHScheduling Agreement Schedules: History Tables20RSNUMNumber of Reservation/Dependent Requirementnvarchar100
54MEREQXPurchase Requisition Change Parameter67RSNUMUpdated information in related user data fieldnvarchar10
TOPRepetitive Manufacturing
55COMPMOVEGoods Movement of Components48RSNUMNumber of Reservation/Dependent Requirementnvarchar100
56RESCOReprocessing Pointer Table3RSNUMNumber of Reservation/Dependent Requirementnvarchar100
TOPRuntime WorkbenchMonitoring
57SXIPERF_REG_RSRPerformance Regression - Run Log Raw Data2RSNUMint100
TOPSCM Basis
58CIFRVMAPMapping Table NR/POS/ET <-> APO GUID (Sales Orders)2RSNUMNumber of Reservation/Dependent Requirementnvarchar100
TOPSelf-Service Procurement
59/SRMERP/D_SC_ITMShopping Cart Item67RSNUMNumber of Reservation/Dependent Requirementnvarchar100
TOPService Processing
60RESTOReservation records for PM technical objects2RSNUMReservation number for technical objectsnvarchar100
TOPShipping
61LIPSSD document: Delivery: Item data184RSNUMNumber of Reservation/Dependent Requirementnvarchar100
62VRSLIReceipt of Materials from Deliveries7RSNUMNumber of Reservation/Dependent Requirementnvarchar100
TOPSimulation
63VSAFKO_CNVersion: Order header data for PP orders14RSNUMNumber of Reservation/Dependent Requirementnvarchar100
64VSEBAN_CNVersion: Purchase requisition67RSNUMNumber of Reservation/Dependent Requirementnvarchar100
65VSFPLA_CNVersion: Billing schedule25RSNUMNumber of Reservation/Dependent Requirementnvarchar100
66VSHIST_OKTransfer history material components2RSNUMNumber of Reservation/Dependent Requirementnvarchar100
67VSPLAF_CNVersion: Planned order27RSNUMNumber of Reservation/Dependent Requirementnvarchar100
68VSRESB_CNVersion: Reservation/Dependent requirements3RSNUMNumber of Reservation/Dependent Requirementnvarchar100
69VSRSADD_CNVersion: Additional fields for reservation3RSNUMNumber of Reservation/Dependent Requirementnvarchar100
70VSRSDB_CNVersion: Index of RESB for direct procurement elements3RSNUMNumber of Reservation/Dependent Requirementnvarchar100
TOPStructures Workbench
71/ISDFPS/MATSPPLNMaterials Planned for Force Element23RSNUMNumber of Reservation/Dependent Requirementnvarchar100
TOPWarehouse Management
72LTAKWM transfer order header29RSNUMNumber of Reservation/Dependent Requirementnvarchar100
73LTBKTransfer requirement header31RSNUMNumber of Reservation/Dependent Requirementnvarchar100
74T311ACross-Reference WM Group for Documents15RSNUMNumber of Reservation/Dependent Requirementnvarchar100