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

78 columns | Print definition?ERP 6.0  | KUNAG

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000182000PSA for 2LIS_12_VCHDR T90CLNT090 Delivery Header Data19KUNAGnvarchar100
2/BIC/B0000183000PSA for 2LIS_12_VCITM T90CLNT090 Delivery Item20KUNAGnvarchar100
3/BIC/B0000184000PSA for 2LIS_13_VDHDR T90CLNT090 Bill.Doc.Header Data20KUNAGnvarchar100
4/BIC/B0000185000PSA for 2LIS_13_VDITM T90CLNT090 Billing Doc. Item16KUNAGnvarchar100
5/BIC/B0000186000PSA for 2LIS_13_VDKON T90CLNT090 Billing Docu. Cond.16KUNAGnvarchar100
6MEV_D_AD_ITEM_SDPeriod-End Valuation: Accruals Document Item SD14KUNAGSold-to partynvarchar100
7MEV_D_WL_ITEMPeriod-end valuation: Worklist item41KUNAGSold-to partynvarchar100
8S730ES730 - Structural information5KUNAGShip-to partynvarchar100
TOPAccounting Interface
9GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)245KUNAGSold-to partynvarchar100
10GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)245KUNAGSold-to partynvarchar100
TOPAdvertising Management
11JHFREV2IS-M/AM: Key Dates for Billing Document Revenue Recognition43KUNAGBusiness Partner: Sold-to Partynvarchar100
12JHFREV4IS-M/AM: Billing Document Revenue Recognition Key Date Qties40KUNAGBusiness Partner: Sold-to Partynvarchar100
13JHTFPIS-M/AM: Billing/Settlement Documents - Item101KUNAGBusiness Partner: Sold-to Partynvarchar100
TOPAllocation
14AUVDIWorklist for Deliveries (Follow-on Doc. Generation)14KUNAGSold-to partynvarchar100
TOPBasic Functions
15FDS1Cash Management & Forecast: Line Items of SD Documents10KUNAGSold-to partynvarchar100
TOPBilling
16A146Customer Hierarchy11KUNAGSold-to partynvarchar100
17A147Customer Hierarchy (Sales Deal)11KUNAGSold-to partynvarchar100
18A149Customer-dependent data determination7KUNAGSold-to partynvarchar100
19VBRKBilling Document: Header Data53KUNAGSold-to partynvarchar100
20VBRLSales Document: Invoice List9KUNAGSold-to partynvarchar100
21VRKPASales Index: Bills by Partner Functions9KUNAGSold-to partynvarchar100
22VRPMASD Index: Billing Items per Material8KUNAGSold-to partynvarchar100
TOPConditions
23A901Sales org./Distr. Chl/Sold-to pt/Region6KUNAGSold-to partynvarchar100
24A907Sales org./Distr. Chl/Sold-to pt6KUNAGSold-to partynvarchar100
25A909Sales org./Distr. Chl/Sold-to pt/Incoterms/Inco. 26KUNAGSold-to partynvarchar100
TOPConsumption-Based Planning See Also PP-MRP
26EDMMSAssignment of EDI partner to purchasing org. and plant3KUNAGSold-to party at customer, transferred via EDI by vendornvarchar200
TOPContract Accounts Receivable and Payable
27FKK_JFRK_SHORTHeader Data for IS-M/SD Billing Document - Extracts11KUNAGSold-to partynvarchar100
TOPCosting
28COERSales Order Value Revenue29KUNAGSold-to partynvarchar100
TOPData Collection
29S008Communications Table SD -> CO/Projects25KUNAGSold-to partynvarchar100
30S108Additionals7KUNAGSold-to partynvarchar100
31S108ES108 - Structural Information6KUNAGSold-to partynvarchar100
32S123Customer / material group13KUNAGSold-to partynvarchar100
33S123ES123 - Structural Information8KUNAGSold-to partynvarchar100
34S124Customer / material9KUNAGSold-to partynvarchar100
35S124ES124 - Structural Information4KUNAGSold-to partynvarchar100
36S130Replenishment10KUNAGShip-to partynvarchar100
37S130ES130 - Structural Information5KUNAGShip-to partynvarchar100
38S261SD - Delivery note31KUNAGSold-to partynvarchar100
39S261BIW1SD - Delivery note31KUNAGSold-to partynvarchar100
40S261BIW2SD - Delivery note31KUNAGSold-to partynvarchar100
41S262SD - Billing document23KUNAGSold-to partynvarchar100
42S262BIW1SD - Billing document23KUNAGSold-to partynvarchar100
43S262BIW2SD - Billing document23KUNAGSold-to partynvarchar100
44S730copy of S130 Repl.m 4 VMI XI10KUNAGShip-to partynvarchar100
TOPData Retention Tool
45TXW_S_LIKPRetrieve LIKP from archive10KUNAGSold-to partynvarchar100
46TXW_S_VBRKRetrieve VBRK from archive19KUNAGSold-to partynvarchar100
TOPDelivery Confirmation
47DELCONHDDelivery Confirmation: Basis of Logistic.Match. - Header4KUNAGSold-to partynvarchar100
TOPDistributor-Reseller-Management
48A313SD Doc./Item/Personnel/Sold-to pt/No.ser.no./Customer9KUNAGSold-to partynvarchar100
TOPEmpties Management
49/BEV1/EMLGBSDCustomer Empties Stock per Month7KUNAGSold-to partynvarchar100
50/BEV1/EMLGBWDPEmpties Movement Account Customer10KUNAGSold-to partynvarchar100
51/BEV1/EMLGKTOEmpties Account4KUNAGSold-to partynvarchar100
TOPIntegration
52FKK_VBRK_SHORTHeader Data for SD Billing Document - Extracts16KUNAGSold-to partynvarchar100
TOPInvoice Forecasting
53IFW_WORKLISTInvoice forecasting worklist10KUNAGSold-to partynvarchar100
TOPLocalization
54J_1IEXCHDRExcise invoice header detail26KUNAGSold-to partynvarchar100
55J_1ILICHDRExcise Bonding: License Header9KUNAGSold-to partynvarchar100
56J_3RSCCDHEADERCargo Customs Declaration Header18KUNAGSold-to partynvarchar100
TOPMedia Product Sales and Distribution
57JKSDCREDITMEMOIS-M/SD Worklist of Mass Credit Memos14KUNAGSold-to partynvarchar100
58JKSDUNSOLDIS-M: Header Data on Unsold Copies17KUNAGSold-to partynvarchar100
TOPPatient Accounting
59NVBRKIS-H: Billing document header data41KUNAGSold-to partynvarchar100
TOPPeriodical Sales and Distribution
60A386Sales Org./Dist.Chl./Division/Sold-To Pty7KUNAGSold-to partynvarchar100
61JFRKIS-M/SD: Billing - Header Data43KUNAGSold-to partynvarchar100
TOPProfitability Analysis
62CEERRORCO-PA: Incorrect records from SD52KUNAGSold-to partynvarchar100
TOPPurchasing
63EKPVShipping Data For Stock Transfer of Purchasing Document Item8KUNAGSold-to partynvarchar100
TOPRecycling Administration Core Functions
64J_7LVBRKNON-SD Interface: Billing: Header Data16KUNAGSold-to partynvarchar100
TOPRevenue recognition
65VBREVERevenue Recognition: Revenue Recognition Lines24KUNAGSold-to partynvarchar100
66VBREVKRevenue Recognition: Control Lines13KUNAGSold-to partynvarchar100
TOPRoute Settlement
67/DSD/SL_DIFIACDSD Settlement: Interim Accounts2KUNAGTolerance Group Customizing: Drivernvarchar100
68/DSD/SL_IACFINSettlement: Interim Accounts, Final Difference2KUNAGTolerance Group Customizing: Drivernvarchar100
69/DSD/SL_PMSIACDSD Settlement: Driver and Customer Accounts (Collection)3KUNAGSold-to Party Receipts/Expendituresnvarchar100
TOPSales
70SLS_TMPL_HEADSales: Template Head5KUNAGSold-to partynvarchar100
71SLS_TMPL_KEYSales: Template Key3KUNAGSold-to partynvarchar100
TOPSelf-Billing Proced.
72T665DSD Self-Billing Procedure: Contractor Processing Parameters2KUNAGSold-to partynvarchar100
73VSBHDRIDoc Self-Billing Procedure w. Automatic Postings20KUNAGSold-to partynvarchar100
74VSBOIISelf-Billing: Index of Generated Open Items3KUNAGSold-to partynvarchar100
TOPShipping
75LIKPSD Document: Delivery Header Data31KUNAGSold-to partynvarchar100
76VLKPASD Index: Deliveries by Partner Functions9KUNAGSold-to partynvarchar100
77VLPMASD Index: Delivery Items by Material8KUNAGSold-to partynvarchar100
TOPTraders and Schedulers Workbench
78S430SIS: (OIL-TSW) Sales document statistics by TSW object14KUNAGSold-to partynvarchar100