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

66 columns | Print definition?ERP 6.0  | ABLAD

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/AIN/KBNDGR2KSTKanban: Device Group to Kanban Status Mapping7ABLADUnloading Pointnvarchar250
2/BIC/B0000182000PSA for 2LIS_12_VCHDR T90CLNT090 Delivery Header Data9ABLADnvarchar250
3/BIC/B0000183000PSA for 2LIS_12_VCITM T90CLNT090 Delivery Item13ABLADnvarchar250
4ZEIM_AFPOOrder item58ABLADUnloading Pointnvarchar250
TOPAdvertising Management
5JHTFPAIS-M/AM: Settlement/Billing Document Item: Partner12ABLADUnloading Pointnvarchar250
TOPAllocation
6AUVDIWorklist for Deliveries (Follow-on Doc. Generation)51ABLADUnloading Pointnvarchar250
7AUVTShipping-Specific Data of Plants for Delivery Generation18ABLADUnloading Pointnvarchar250
TOPBank Customer Accounts
8BKKPOGISPEDI Payments: Reporting Data to Clearing, Segm. E1EDLA119ABLADUnloading Pointnvarchar350
TOPBasic Functions
9T661WDetermination of Sold-to Party for EDI DlvSched/JIT4ABLADUnloading Pointnvarchar250
10T663ADealing with errors:Scheduling agreements with rel.orders3ABLADUnloading Pointnvarchar250
11T664ASpecial processing for deliveries for ext.agents3ABLADUnloading Pointnvarchar250
12T665ASpecial Processing for Self-Billing3ABLADUnloading Pointnvarchar250
13VBPASales Document: Partner10ABLADUnloading Pointnvarchar250
TOPConfirmations
14AFFWGoods Movements with Errors from Confirmations24ABLADUnloading Pointnvarchar250
TOPCross-Application Components
15VBBPASales Document: Partner10ABLADUnloading Pointnvarchar250
16VVBBPASales Document: Partner10ABLADUnloading Pointnvarchar250
17VVVBPASales Document: Partner10ABLADUnloading Pointnvarchar250
TOPCustomer Master
18KNVACustomer Master Unloading Points3ABLADUnloading Pointnvarchar250
TOPData Collection
19S159W&S: Picking Waves38ABLADUnloading Pointnvarchar250
20S261SD - Delivery note27ABLADUnloading Pointnvarchar250
21S261BIW1SD - Delivery note27ABLADUnloading Pointnvarchar250
22S261BIW2SD - Delivery note27ABLADUnloading Pointnvarchar250
TOPFreight Processing
23VFPAPartner for Shipment Costs10ABLADUnloading Pointnvarchar250
TOPInventory Management
24MSEGDocument Segment: Material51ABLADUnloading Pointnvarchar250
25MWXMSEGZMSEG: Interface for Posting of Value51ABLADUnloading Pointnvarchar250
26MWZMSEGZMSEG:Interface for Posting of Value51ABLADUnloading Pointnvarchar250
27RESBReservation/dependent requirements146ABLADUnloading Pointnvarchar250
TOPJust-In-Time Processing
28JITPGDJIT: Unloading Points and Assembly Locations per Customer4ABLADUnloading Pointnvarchar250
TOPKANBAN
29PABITJIT call items9ABLADUnloading Pointnvarchar250
30PKHDControl Cycle38ABLADStoring Positionnvarchar250
31PVBEProduction Supply Area6ABLADUnloading Pointnvarchar250
TOPLocalization
32J_1IRAINDTLArticle Inward Note Detail37ABLADUnloading Pointnvarchar250
TOPMaintenance Orders
33AUFMGoods movements for order28ABLADUnloading Pointnvarchar250
34TPEXTProfile for external procurement8ABLADUnloading Pointnvarchar250
TOPMaster data
35KOTP003Material/Ship-To Party/Unloading Point6ABLADUnloading Pointnvarchar250
TOPPatient Accounting
36NMKAPIS-H MM: Material catalog items16ABLADIS-H: Unloading Pointnvarchar250
TOPPeriodical Sales and Distribution
37JLPASales Document: Partner10ABLADUnloading Pointnvarchar250
TOPPlant Master
38WRF12Plant / receiving points5ABLADUnloading Pointnvarchar250
TOPProduction Orders
39AFPOOrder item58ABLADUnloading Pointnvarchar250
40AFVCOperation within an order143ABLADUnloading Pointnvarchar250
TOPPurchasing
41EBKNPurchase Requisition Account Assignment21ABLADUnloading Pointnvarchar250
42EKKNAccount Assignment in Purchasing Document23ABLADUnloading Pointnvarchar250
43EKPVShipping Data For Stock Transfer of Purchasing Document Item19ABLADUnloading Pointnvarchar250
TOPR2-R3 Link
44LDK01Communication Record 01 Decentralized WMS: GR/GI R/2 -> ERP22ABLADUnloading Pointnvarchar250
TOPRemaining Beverage - Obsolete Objects
45/BEV1/RBVBPASales Document: Partner, Copy VBPA for Indirect Orders10ABLADUnloading Pointnvarchar250
TOPRemote Logistics Management
46OIO_MX_OBJECTRLM tracking extract object data43ABLADUnloading Pointnvarchar250
TOPRepetitive Manufacturing
47COMPMOVEGoods Movement of Components47ABLADUnloading Pointnvarchar250
TOPReuse Services for Country Development
48PA0048HR Master Record: Infotype 0048 (Residence Status - CH)26ABLADExpiration Datenvarchar80
TOPSales
49VLPKMScheduling agreements by customer material5ABLADUnloading Pointnvarchar250
TOPSelf-Service Procurement
50/SRMERP/D_ACC_ITAccount assignment item21ABLADUnloading Pointnvarchar250
TOPShipping
51DVK01R/2-R/3 Link: Delivery Header Data R2 -> R337ABLADUnloading Pointnvarchar250
52LIKPSD Document: Delivery Header Data17ABLADUnloading Pointnvarchar250
53VARKDelivery Plan: Customer-Specific Itinerary6ABLADUnloading Pointnvarchar250
54VAWKDelivery Plan: Itinerary Determination, Customer-Specific4ABLADUnloading Pointnvarchar250
TOPSimulation
55VSAFPO_CNVersion: Order items in PP orders59ABLADUnloading Pointnvarchar250
56VSAFVC_CNVersion: Operation in order144ABLADUnloading Pointnvarchar250
57VSEBKN_CNVersion: Purchase requisition account assignment22ABLADUnloading Pointnvarchar250
58VSRESB_CNVersion: Reservation/Dependent requirements147ABLADUnloading Pointnvarchar250
TOPSupplier Workplace
59SICJIT_VENDAUTHTable with authorities for vendors8ABLADUnloading Pointnvarchar250
TOPTransportation
60VTPAShipping Partner10ABLADUnloading Pointnvarchar250
61VTTSStage of Shipment34ABLADDestination: Additional information (e.g. unloading point)nvarchar250
TOPTransportation and Distribution
62OIGSPAPartner in TD-shipment10ABLADUnloading Pointnvarchar250
TOPVisit Control
63/DSD/VC_VLPDSD: Visit List - Item Data13ABLADUnloading Pointnvarchar250
64/DSD/VC_VPPDSD: Visit Schedule - Item Data15ABLADUnloading Pointnvarchar250
TOPWarehouse Management
65LTAPTransfer order item34ABLADUnloading Pointnvarchar250
66LTBPTransfer requirement item26ABLADUnloading Pointnvarchar250