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

73 columns | Print definition?ERP 6.0  | FKDAT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000178000PSA for 2LIS_11_VAITM T90CLNT090 Sales Doc. Item119FKDATnvarchar80
2/BIC/B0000179000PSA for 2LIS_11_VASCL T90CLNT090 Sales Doc. Schedule99FKDATnvarchar80
3/BIC/B0000181000PSA for 2LIS_11_VAKON T90CLNT090 Sales Document Cond.64FKDATnvarchar80
4/BIC/B0000184000PSA for 2LIS_13_VDHDR T90CLNT090 Bill.Doc.Header Data14FKDATnvarchar80
5/BIC/B0000185000PSA for 2LIS_13_VDITM T90CLNT090 Billing Doc. Item12FKDATnvarchar80
6/BIC/B0000186000PSA for 2LIS_13_VDKON T90CLNT090 Billing Docu. Cond.12FKDATnvarchar80
7J_1I_LICHDREXIM : License Header22FKDATBilling date for billing index and printoutnvarchar80
TOPAccounting Interface
8GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)250FKDATBilling date for billing index and printoutnvarchar80
9GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)250FKDATBilling date for billing index and printoutnvarchar80
TOPAdvertising Management
10JHAGVXIS-M/AM: Order Sales Agent Assignment Settlement Index12FKDATIS-M: Planned Billing/Settlement Datenvarchar80
11JHFREV2IS-M/AM: Key Dates for Billing Document Revenue Recognition39FKDATIS-M: Actual Billing/Settlement Datenvarchar80
12JHFREV4IS-M/AM: Billing Document Revenue Recognition Key Date Qties36FKDATIS-M: Actual Billing/Settlement Datenvarchar80
13JHTFKIS-M/AM: Settlement Documents (Billing, Commission) - Header17FKDATIS-M: Actual Billing/Settlement Datenvarchar80
14JHTFXIS-M/AM: Billing Index - Order Billing5FKDATIS-M: Planned Billing/Settlement Datenvarchar80
15JHTVAABPIS-M/AM: Contract Settlement Item Data25FKDATIS-M: Actual Billing/Settlement Datenvarchar80
TOPBasic Functions
16FDS1Cash Management & Forecast: Line Items of SD Documents14FKDATBilling date for billing index and printoutnvarchar80
17FPLTBilling Plan: Dates6FKDATSettlement date for deadlinenvarchar80
18FPLTPOBilling Plan: Dates6FKDATSettlement date for deadlinenvarchar80
19VFPLTBilling Plan: Dates6FKDATSettlement date for deadlinenvarchar80
TOPBilling
20TVFKDBilling Document: Billing Date by Number Range3FKDATBilling date for billing index and printoutnvarchar80
21VBRKBilling Document: Header Data12FKDATBilling date for billing index and printoutnvarchar80
22VRKPASales Index: Bills by Partner Functions5FKDATBilling date for billing index and printoutnvarchar80
23VRPMASD Index: Billing Items per Material4FKDATBilling date for billing index and printoutnvarchar80
TOPContract Accounts Receivable and Payable
24FKK_JFRK_SHORTHeader Data for IS-M/SD Billing Document - Extracts9FKDATBilling date for billing index and printoutnvarchar80
TOPCosting
25COERSales Order Value Revenue38FKDATBilling date for billing index and printoutnvarchar80
TOPCross-Application Components
26VVBKDSales Document: Business Data22FKDATBilling date for billing index and printoutnvarchar80
TOPData Collection
27S008Communications Table SD -> CO/Projects49FKDATBilling date for billing index and printoutnvarchar80
28S260SD - Sales order70FKDATBilling date for billing index and printoutnvarchar80
29S260BIW1SD - Sales order70FKDATBilling date for billing index and printoutnvarchar80
30S260BIW2SD - Sales order70FKDATBilling date for billing index and printoutnvarchar80
31S262SD - Billing document26FKDATBilling date for billing index and printoutnvarchar80
32S262BIW1SD - Billing document26FKDATBilling date for billing index and printoutnvarchar80
33S262BIW2SD - Billing document26FKDATBilling date for billing index and printoutnvarchar80
34S264SD- Offer72FKDATBilling date for billing index and printoutnvarchar80
35S264BIW1S264BIW1 * SD - Quotation72FKDATBilling date for billing index and printoutnvarchar80
36S264BIW2S264BIW2 * SD - Quotation72FKDATBilling date for billing index and printoutnvarchar80
TOPData Retention Tool
37TXW_S_VBRKRetrieve VBRK from archive14FKDATBilling date for billing index and printoutnvarchar80
TOPDelivery Confirmation
38DELCONHDDelivery Confirmation: Basis of Logistic.Match. - Header8FKDATBilling Document Datenvarchar80
TOPEmpties Management
39/BEV1/EMLGBWDPEmpties Movement Account Customer17FKDATBilling date for billing index and printoutnvarchar80
40/BEV1/EMLGFADEmpties Movement - Customer Billing Status11FKDATBilling date for billing index and printoutnvarchar80
TOPFinancial Accounting
41/CCEE/SIFIPE7Pro forma invoice for temporary export of goods8FKDATBilling date for billing index and printoutnvarchar80
TOPIntegration
42FKK_VBRK_SHORTHeader Data for SD Billing Document - Extracts11FKDATBilling date for billing index and printoutnvarchar80
TOPInvoice Forecasting
43IFW_HEADERInvoice forecasting header7FKDATBilling date for billing index and printoutnvarchar80
TOPLocalization
44J_3RFGTDINVGTD usage in billing documents13FKDATBilling date for billing index and printoutnvarchar80
TOPMedia Product Sales and Distribution
45JKSDCREDITMEMOIS-M/SD Worklist of Mass Credit Memos15FKDATBilling date for billing index and printoutnvarchar80
46JKSDUNSOLDIS-M: Header Data on Unsold Copies18FKDATBilling date for billing index and printoutnvarchar80
TOPPatient Accounting
47NVBRKIS-H: Billing document header data12FKDATBilling date for billing index and printoutnvarchar80
48TN22PIS-H: Control Parameters FI Posting Down Payment14FKDATIS-H: Rule for Due Datenvarchar10
49TN22QIS-H: Control Parameters FI Posting Copayment Request10FKDATIS-H: Rule for Due Datenvarchar10
50TN22RIS-H: Control Params FI Posting Copayment/Copay.Cred.Memo11FKDATIS-H: Rule for Due Datenvarchar10
51TN22SIS-H: Control Parameters FI Posting Down Payment Request12FKDATIS-H: Rule for Due Datenvarchar10
TOPPeriodical Sales and Distribution
52JFDFSIS-M/SD: Billing/Settlement Index7FKDATIS-M: Billing/Settlement Datenvarchar80
53JFRKIS-M/SD: Billing - Header Data10FKDATBilling date for billing index and printoutnvarchar80
54JLRPIS-M/SD: Item Data for Settlement155FKDATIS-M: Billing/Settlement Datenvarchar80
55TJF31IS-M/SD: Collective Transfer Run to RF/FI6FKDATBilling date for billing index and printoutnvarchar80
TOPProfitability Analysis
56CEERRORCO-PA: Incorrect records from SD58FKDATBilling date for billing index and printoutnvarchar80
TOPRecycling Administration Core Functions
57J_7LVBRKNON-SD Interface: Billing: Header Data9FKDATBilling date for billing index and printoutnvarchar80
TOPRemaining Beverage - Obsolete Objects
58/BEV1/BO_DATAProof Table for Rebate Processing12FKDATBilling date for billing index and printoutnvarchar80
59/BEV1/RBWEItemized Proof Rebate Settlement36FKDATBilling date for billing index and printoutnvarchar80
60/BEV3/CHFKFKDRKDocument Print History4FKDATBilling date for billing index and printoutnvarchar80
TOPRevenues and Earnings
61AD01DLIEFDI flow: Individual flow21FKDATBilling date for billing index and printoutnvarchar80
TOPSales
62VBKDSales Document: Business Data22FKDATBilling date for billing index and printoutnvarchar80
63VKDFSSD Index: Billing Initiator4FKDATBilling date for billing index and printoutnvarchar80
TOPSAP Healthcare - Industry-Specific Components for Hospitals
64TN22FIS-H: Steuerungsparameter FI-Buchung amb. Zuzahl.anforderung8FKDATIS-H: Regel für Fälligkeitsdatumnvarchar10
65TN22GIS-H: Steuerungsparameter FI-Buchung amb. Zuzahlung10FKDATIS-H: Regel für Fälligkeitsdatumnvarchar10
TOPService Station Retailing
66OIRA_PRINTINDEXPrint group index data12FKDATBilling date for billing index and printoutnvarchar80
67OIRA_PRNDOC_HEADPrint document header data8FKDATBilling date for billing index and printoutnvarchar80
68OIRPBLSales Index: Billing by Business Location3FKDATBilling date for billing index and printoutnvarchar80
TOPShipping
69LIKPSD Document: Delivery Header Data47FKDATBilling date for billing index and printoutnvarchar80
70VBLKSD Document: Delivery Note Header6FKDATBilling date for billing index and printoutnvarchar80
TOPSimulation
71VSFPLT_CNVersion: Billing schedule: Dates7FKDATBilling date for billing index and printoutnvarchar80
72VSVBKD_CNVersion: Sales document - commercial data23FKDATBilling date for billing index and printoutnvarchar80
TOPWarranty Claim Processing
73PNWTYVWarranty Claim Version (PVS Node)13FKDATBilling Document Datenvarchar80