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

89 columns | Print definition?ERP 6.0  | ETENR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000179000PSA for 2LIS_11_VASCL T90CLNT090 Sales Doc. Schedule16ETENRnvarchar40
2/BIC/B0000180000PSA for 2LIS_11_V_SCL T90CLNT090 Sls-Ship.Alloc.Sch.11ETENRnvarchar40
3/BIC/B0000189000PSA for 2LIS_02_SCL T90CLNT090 Purch.Data Sch.Line74ETENRnvarchar40
4/OPT/VIM_1ITEM_SDocument Item51ETENRDelivery Schedule Line Numbernvarchar40
5/OPT/VIM_TITEMDocument Item51ETENRDelivery Schedule Line Numbernvarchar40
6CNVTDMS_05_J3AVAFill Header for AFS - J_3_AVA*6ETENRPASUBNRnvarchar40
7FRE_SO_POINTERChange Pointers for changed Sales Order Documents4ETENRDelivery Schedule Line Numbernvarchar40
8PPHMRP_EKET_PPMRP Live: Schedule lines for postprocessing4ETENRDelivery Schedule Line Counternvarchar40
9YVIM_1ITEMDocument Item51ETENRDelivery Schedule Line Numbernvarchar40
10ZEIM_VBEPSales Document: Schedule Line Data4ETENRDelivery Schedule Line Numbernvarchar40
TOPApplication System
11/SAPTRX/ASITEMIDItem Identifier Refernce Table5ETENRSchedule Line Numbernvarchar100
TOPBasic Functions
12FDM1Cash Management & Forecast: Line Items of MM Documents9ETENRDelivery Schedule Line Numbernvarchar40
13FDS1Cash Management & Forecast: Line Items of SD Documents4ETENRDelivery Schedule Line Numbernvarchar40
14VBBESales Requirements: Individual Records4ETENRDelivery Schedule Line Numbernvarchar40
TOPBasis Components
15ZDS400_BUF1Tabelle für Beispielprogramm des ZDS4004ETENRPositionsnummer des Einkaufsbelegsnvarchar50
16ZDS400_VBEPTabelle für Beispielprogramm des ZDS4004ETENREinteilungsnummernvarchar40
TOPCommand and Support Relationships
17/ISDFPS/OPEN_POSOpen MM Documents Intended for Collective Processing5ETENRDelivery Schedule Line Counternvarchar40
TOPCross-Application Components
18FRE_OP_PO_KEYKey-Completion F&R Order Proposal <-> R/3 Purchase Order4ETENRDelivery Schedule Line Counternvarchar40
19FRE_PO_GI_WLDatabase Table for order item worklist concerning GI date4ETENRDelivery Schedule Line Counternvarchar40
20FRE_PO_POINTERChange Pointers Changed Purchase Order Documents4ETENRDelivery Schedule Line Counternvarchar40
21VVBEPSales Document: Schedule Line Data4ETENRDelivery Schedule Line Numbernvarchar40
22VVBUVSales Document: Incompletion Log4ETENRDelivery Schedule Line Numbernvarchar40
TOPDangerous Goods Management
23VBEPDGAPDG: Appendix Table for VBEPDG4ETENRDelivery Schedule Line Numbernvarchar40
TOPData Collection
24S008Communications Table SD -> CO/Projects10ETENRDelivery Schedule Line Numbernvarchar40
25S260SD - Sales order10ETENRDelivery Schedule Line Numbernvarchar40
26S260BIW1SD - Sales order5ETENRDelivery Schedule Line Numbernvarchar40
27S260BIW2SD - Sales order5ETENRDelivery Schedule Line Numbernvarchar40
28S261SD - Delivery note10ETENRDelivery Schedule Line Numbernvarchar40
29S261BIW1SD - Delivery note5ETENRDelivery Schedule Line Numbernvarchar40
30S261BIW2SD - Delivery note5ETENRDelivery Schedule Line Numbernvarchar40
31S263SD - Sales order/delivery note10ETENRDelivery Schedule Line Numbernvarchar40
32S263BIW1SD - Sales order/delivery note5ETENRDelivery Schedule Line Numbernvarchar40
33S263BIW2SD - Sales order/delivery note5ETENRDelivery Schedule Line Numbernvarchar40
34S264SD- Offer10ETENRDelivery Schedule Line Numbernvarchar40
35S264BIW1S264BIW1 * SD - Quotation10ETENRDelivery Schedule Line Numbernvarchar40
36S264BIW2S264BIW2 * SD - Quotation10ETENRDelivery Schedule Line Numbernvarchar40
TOPEnhancements to scheduling agreements MM Outbound
37ISAUTOEKLWESLast Deliveries for FLAB6ETENRDelivery Schedule Line Counternvarchar40
38ISAUTOEKLWESHLast Deliveries for FLAB6ETENRDelivery Schedule Line Counternvarchar40
TOPEnvironment, Health and Safety
39VBEPDGAppendix Table for Dangerous Goods Data4ETENRDelivery Schedule Line Numbernvarchar40
TOPFinancial Accounting
40/OPT/VIM_1ITEMDocument Item51ETENRDelivery Schedule Line Numbernvarchar40
TOPFunds Management
41FMEPFI-FM Line Items33ETENRDelivery Schedule Line Numbernvarchar40
TOPKANBAN
42PKPSControl Cycle Item / Kanban16ETENRDelivery Schedule Line Counternvarchar40
TOPMaster Data
43PKTMPConversion table for PKPS / please do not use15ETENRDelivery Schedule Line Counternvarchar40
TOPMaterial Master
44MEIKMake-to-Order Stock for Customer Order6ETENRDelivery Schedule Line Numbernvarchar40
TOPMaterials Management
45/ISDFPS/OPENPOS2Open MM Documents Intended for Collective Processing6ETENRDelivery Schedule Line Counternvarchar40
TOPPeriodical Sales and Distribution
46JFFDICHTObject Flow of Deliveries for Summarized Billing Item6ETENRSales Order Schedule Linenvarchar40
47JFFSIS-M/SD: Error Log for Collective Billing Doc.Processing5ETENRDelivery Schedule Line Numbernvarchar40
48JFXJFFSDLIS-M: Backup Transfer Internal Table XJFFS7ETENRDelivery Schedule Line Numbernvarchar40
49JKEPSales Order: Schedule Line Data4ETENRSales Order Schedule Linenvarchar40
50JKWWWTEMP_SERVIS-M: Temporary Table for Changes from Internet63ETENRSales Order Schedule Linenvarchar40
51JLFSIS-M/SD: Error Log for Collective Settlement Processing5ETENRDelivery Schedule Line Numbernvarchar40
52JLRPIS-M/SD: Item Data for Settlement149ETENRDelivery Schedule Line Numbernvarchar40
53JVTLFZUOIS-M/SD: Assignment of Delivery to Schedule Line6ETENRSales Order Schedule Linenvarchar40
54JVTNCT5IS-M/SD: Tab.5 in Collective Netchange File (Sch.Line ChNo.)7ETENRSales Order Schedule Linenvarchar40
55JVTNOTICEIS-M/SD: Carrier Change Notifications10ETENRSales Order Schedule Linenvarchar40
56JVTORDERCHIS-M/SD: Order Change Types for Carrier Notification6ETENRSales Order Schedule Linenvarchar40
57JVTZAEM1IS-M/SD: Carrier Change Notification - Order Change16ETENRSales Order Schedule Linenvarchar40
58JVTZUOBUNDIS-M/SD: Assgmt of Postal Newspaper Pack to Order (Sch.Line)5ETENRSales Order Schedule Linenvarchar40
TOPProfitability Analysis
59CEERRORCO-PA: Incorrect records from SD5ETENRDelivery Schedule Line Numbernvarchar40
TOPPurchasing
60EKCCIndex Table for CCP Process4ETENRDelivery Schedule Line Counternvarchar40
61EKEHScheduling Agreement Release Documentation6ETENRDelivery Schedule Line Counternvarchar40
62EKEHHRemoved Scheduling Agreement Release Documentation6ETENRDelivery Schedule Line Counternvarchar40
63EKETScheduling Agreement Schedule Lines4ETENRDelivery Schedule Line Counternvarchar40
64EKETHScheduling Agreement Schedules: History Tables4ETENRDelivery Schedule Line Counternvarchar40
65WGRC_ACT_POAssignment of Times to Door/Area Capacities5ETENRDelivery Schedule Line Numbernvarchar40
66WGRC_ASS_ACT_POAssignment of Times to Door/Area Capacities5ETENRDelivery Schedule Line Numbernvarchar40
67WGRC_PO_REWORKNumber of Incorrect Documents for Which Reworking Required4ETENRDelivery Schedule Line Numbernvarchar40
68WRF_POTB_TRF_POLog Table OTB Transfer, Document Data5ETENRDelivery Schedule Line Numbernvarchar40
69WRF_PRCT_REM_QTYRem.Qties4ETENRDelivery Schedule Line Counternvarchar40
70WRF_PRCT_WL_ITEMOriginal Table for Worklist Items4ETENRDelivery Schedule Line Counternvarchar40
71WRF_PRCT_WL_SHDWShadow Table for Worklist Items4ETENRDelivery Schedule Line Counternvarchar40
TOPPurchasing Information System
72MCEKSR/2 PURCHIS Data (Status: Last Data Transmission)7ETENRDelivery Schedule Line Numbernvarchar40
TOPQuality Inspection
73QALSInspection lot record115ETENRDelivery Schedule Line Counternvarchar40
TOPRemaining Beverage - Obsolete Objects
74/BEV3/CHCIVBFSError Log Collective Run CH Docs. Using Create Invoice7ETENRDelivery Schedule Line Numbernvarchar40
TOPSales
75VBEHSchedule line history4ETENRDelivery Schedule Line Numbernvarchar40
76VBEPSales Document: Schedule Line Data4ETENRDelivery Schedule Line Numbernvarchar40
77VBUVSales Document: Incompletion Log4ETENRDelivery Schedule Line Numbernvarchar40
TOPSerial Numbers
78SER08Document Header for Purchase Order Item Serial Numbers5ETENRDelivery Schedule Line Counternvarchar40
79SER09Doc. Header for Serial Numbers for Purchase Requisition Item5ETENRDelivery Schedule Line Counternvarchar40
TOPShipping
80VBFSError Log for Collective Processing5ETENRDelivery Schedule Line Numbernvarchar40
TOPSimulation
81VSVBEP_CNVersion: Sales document: Schedule line data5ETENRDelivery Schedule Line Numbernvarchar40
TOPSpecification 2
82ADSPCM_MM_SACSAC for MM4ETENRDelivery Schedule Line Counternvarchar40
83ADSPCM_SD_SACSAC for SD4ETENRDelivery Schedule Line Numbernvarchar40
TOPSubsequent Settlement
84EKBOIndex of Docs. for Price Determ./Updating, Subsequent Sett.13ETENRDelivery Schedule Line Counternvarchar40
TOPTraders and Schedulers Workbench
85S430SIS: (OIL-TSW) Sales document statistics by TSW object8ETENRDelivery Schedule Line Numbernvarchar40
86S431PURCHIS: (OIL-TSW) Purchasing document stats by TSW object8ETENRDelivery Schedule Line Counternvarchar40
TOPTransaction Manager
87VTBSIANF**Caution! Do not use. Will be deleted!!22ETENRDelivery Schedule Line Numbernvarchar40
88VTBSIZUHedge Allocation30ETENRDelivery Schedule Line Numbernvarchar40
TOPTreasury
89FLQITEMPO_FCLiquidity Calculation - Forecast Line Items for MM POs5ETENRDelivery Schedule Line Numbernvarchar40