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

84 columns | Print definition?ERP 6.0  | AWREF

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000170000PSA for 0FI_GL_4 T90CLNT090 FI-GL Items Delta54AWREFnvarchar100
2CNVTDMS_05_ACCTHCollected Header Document Numbers for TDMS_Time-ACCTHD4AWREFAWREF for CNVTDMS_05_ACCTHDnvarchar100
TOPAccounting Interface
3GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)4AWREFReference Document Numbernvarchar100
4GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)4AWREFReference Document Numbernvarchar100
TOPActual CostingMaterial Ledger
5CKMI1Index for Accounting Documents for Material6AWREFReference Document Numbernvarchar100
6MLHDMaterial Ledger Document: Header6AWREFReference Document Numbernvarchar100
TOPBasic Functions
7ARC_IDX_ATIndex table for ACCTIT/ACCTHD/ACCTCR archives2AWREFReference Document Numbernvarchar100
8ETXDCHExternal tax document: header info4AWREFReference Document Numbernvarchar100
9FDS2CM&F Line Items in SD Documents (fromr Release 4.0)3AWREFReference Document Numbernvarchar100
10FDSPCash Mgmt Adjustment Items from Document Splitting4AWREFReference Document Numbernvarchar100
11GLIDXAIndex to Find FI-SL Documents Based on AWKEY2AWREFReference Document Numbernvarchar100
12TTXIExternal tax interface: index file3AWREFReference Document Numbernvarchar100
13TTXYExternal tax interface: tax information3AWREFReference Document Numbernvarchar100
TOPBudgeting
14FMBHFunds management budget header (entry documents)28AWREFReference Document Numbernvarchar100
TOPBudgeting and Availability Control
15GMBDGTHEADERBudget Document Header27AWREFReference Document Numbernvarchar100
TOPCentral Cash Desk Procedure
16FMFG_PPA_INV_LNReason Codes for Accounting Documents (Item Level)2AWREFReference Document Numbernvarchar100
TOPCollectionsDisbursements
17DIMAAWREFSTAWREF for COPA-Reversal FS-CD2AWREFCharacter Field Length = 10nvarchar100
18DIMACOPASTReversal of Contracts in CO-PA5AWREFReference Document Numbernvarchar100
TOPContract Accounts Receivable and Payable
19FKK_JFRK_SHORTHeader Data for IS-M/SD Billing Document - Extracts32AWREFReference Document Numbernvarchar100
20FKK_JLRK_SHORTHeader Data for IS-M/SD Service Settlement - Extracts25AWREFReference Document Numbernvarchar100
21FKK_JLRPCM_SHORTItem Data for IS-M/SD Commission Settlement - Extracts34AWREFReference Document Numbernvarchar100
22FKK_JLRPHD_SHORTItem Data for IS-M/SD Home Delivery Settlement - Extracts39AWREFReference Document Numbernvarchar100
TOPData Retention Tool
23TXW_S_BKPFRetrieve BKPF from archive32AWREFReference Document Numbernvarchar100
TOPEnterprise Services - Personnel Time Management
24TIM_SE_EXT_KEYMapping Table for IT2004: External Key and Infotype Key3AWREFReference Document Numbernvarchar100
TOPFinancial Accounting
25ACCTCRCompressed Data from FI/CO Document - Currencies3AWREFReference Document Numbernvarchar100
26ACCTHDCompressed Data from FI/CO Document - Header3AWREFReference Document Numbernvarchar100
27ACCTITCompressed Data from FI/CO Document3AWREFReference Document Numbernvarchar100
28ARIX_BKPFFI_DOCUMNT: Header-Oriented Document Index for Archive6AWREFReference Document Numbernvarchar100
29FERC_D2Documents per sender and account17AWREFReference Document Numbernvarchar100
30SLPBLog Table for Valuation9AWREFReference Document Numbernvarchar100
TOPFunds Management
31BPDKHeader Entry Document21AWREFReference Document Numbernvarchar100
32FCABKFI-CA: Document Header9AWREFReference Document Numbernvarchar100
33FMFG_PO_SUBSETZEKKN number to correct invoices for SES11AWREFReference Document Numbernvarchar100
34FMFG_PO_ZEKKNZEKKN data for all FI items referencing service POs11AWREFReference Document Numbernvarchar100
35FMFG_SAV_GLIDXASaved GLIDXA data for docs excluded from SL Repost for 6002AWREFReference Document Numbernvarchar100
36FMIFIHDFI Header Table in Funds Management13AWREFReference Document Numbernvarchar100
37KBLEDocument Item Processing: Manual Document Entry35AWREFReference Document Numbernvarchar100
TOPGeneral Ledger Accounting
38FAGLCOFITRACELog of Real-Time Integration CO->FI9AWREFReference Document Numbernvarchar100
39FAGL_SPLINFOSplittling Information of Open Items9AWREFReference Document Numbernvarchar100
TOPInput Tax Treatment
40VIBETAXDZuordnung Vorsteuerbeleg zum Berichtigungsobjekt3AWREFReferenzbelegnummernvarchar100
TOPJoint Venture und Production Sharing Accounting
41T8J_POST_ERRORDocuments with errors in JV posting3AWREFReference Document Numbernvarchar100
42T8J_POST_ERROR_CDocuments with errors in JV posting (Open Items)3AWREFReference Document Numbernvarchar100
TOPLease Accounting
43FILA_GF_ITEMDOCSAssignment of Process - FI/CO Document Numbers7AWREFReference Document Numbernvarchar100
44FILA_GF_ITEMLINKAssignment of Objects to Assets13AWREFReference Document Numbernvarchar100
TOPLoans Management
45VDCHK_AWKEYStorage of unique links between FI and CML doc5AWREFReference Document Numbernvarchar100
TOPLocalization
46J_1AINFINVInflation: Invoices for Replacement Value Determination6AWREFReference Document Numbernvarchar100
47J_1IEWTPROVTable for TDS provisions8AWREFReference Document Numbernvarchar100
48J_1ISERVCService tax details4AWREFReference document numbernvarchar100
TOPMaterials Management
49J_1GVL_MLMaterial Ledger86AWREFReference Document Numbernvarchar100
TOPNew Zealand
50PT2001HR Time Record: Infotype 2001 (Absences)68AWREFReference Document Numbernvarchar100
TOPPeriodical Sales and Distribution
51JFREVLIABACCIS-M/SD: Accr.Table for Rev.Dist.w/Liab.Acct for Transfer19AWREFReference Document Numbernvarchar100
52JFREVLIABACC_REVIS-M/SD: Reverse Revenue Dist. w/Liability Acct for Trans.22AWREFReference Document Numbernvarchar100
53JFREVPERIS-M/SD: Accrual Table for Period-Related Revenue Dist.20AWREFReference Document Numbernvarchar100
54JFREVPER_REVERSEIS-M/SD: Reverse Period-Related Revenue Distribution22AWREFReference Document Numbernvarchar100
55JFREVVAIS-M/SD: Accr.Table for Issue-Rel.Revenue Dist.w/o Liab.Acct19AWREFReference Document Numbernvarchar100
56JFREVVAACCIS-M/SD: Accr.Table for Issue-Related Rev.Dist.w/Liab.Acct18AWREFReference Document Numbernvarchar100
57JFREVVAACC_REVERIS-M/SD: Reverse Issue-Related Revenue Dist. w/Liab. Account21AWREFReference Document Numbernvarchar100
58JFREVVA_REVERSEIS-M/SD: Reverse Issue-Related Revenue Dist. w/o Liab. Acct22AWREFReference Document Numbernvarchar100
59JFRKIS-M/SD: Billing - Header Data93AWREFReference Document Numbernvarchar100
60JKACCADDIS-M/SD: Additional Payments for Renewal Cycle11AWREFReference Document Numbernvarchar100
61JKACCTFPROTIS-M/SD: Log of Liability Account Transfer14AWREFReference Document Numbernvarchar100
TOPPersonnel Time Management
62PA2001HR Time Record: Infotype 2001 (Absences)68AWREFReference Document Numbernvarchar100
63PA2002HR Time Record: Infotype 2002 (Attendances)50AWREFReference Document Numbernvarchar100
64PA2003HR Time Record: Infotype 2003 (Substitutions)64AWREFReference Document Numbernvarchar100
65PA2010HR Time Record: Infotype 2010 (Employee Remuneration Info.)50AWREFReference Document Numbernvarchar100
TOPProfitability Analysis
66CEERRORCO-PA: Incorrect records from SD61AWREFReference Document Numbernvarchar100
TOPReal Estate Management
67VIMIRAInstalments for Lease-Out6AWREFReference Document Numbernvarchar100
68VITAXALine items for correction items4AWREFReference Document Numbernvarchar100
69VITAXDTax Shares per Real Estate Account Assignment3AWREFReference Document Numbernvarchar100
70VITAXROutflows for correction items4AWREFReference Document Numbernvarchar100
71VITAXUTax transfer posting for advance payments with jurisdiction8AWREFReference Document Numbernvarchar100
TOPRegulatory reporting for insurance companies
72ISSRPREFLOWISSR: Basistabelle/Bewegungstabelle45AWREFNumero documento di riferimentonvarchar100
TOPTransfer to Financial Accounting
73TRACT_DOCUMENTTreasury: Accounting Adaptor Document7AWREFReference Document Numbernvarchar100
TOPTravel Expenses
74PTRV_DOC_HDTransfer Travel -> FI/CO: Header of TRV int. document2AWREFReference Document Numbernvarchar100
75PTRV_DOC_ITTransfer Travel -> FI/CO: Lines of TRV interm. document2AWREFReference Document Numbernvarchar100
76PTRV_DOC_MESSTransfer Travel -> FI/CO: CO Replacements of TRV Receipt2AWREFReference Document Numbernvarchar100
77PTRV_DOC_TAXTransfer Travel -> FI/CO: Tax lines of TRV document2AWREFReference Document Numbernvarchar100
78PTRV_ROT_AWKEYAssignment of Trip Results to Posting Doc. Number and Line13AWREFReference Document Numbernvarchar100
79PTRV_RPRPOSTDLog of Posting Program RPRPOSTD3AWREFReference Document Numbernvarchar100
TOPTreasury
80FLQITEMSO_FCLiquidity Calculation-Forecast Line Items from Sales Orders3AWREFReference Document Numbernvarchar100
TOPUS Prompt Payment Act
81FMFG_PPA_INVSTATPPA Invoice Status Table2AWREFReference Document Numbernvarchar100
82FMFG_PPA_INV_HDPPA invoice header information (reason codes)2AWREFReference Document Numbernvarchar100
83FMFG_PPA_INV_HISPPA Invoice Status Change History2AWREFReference Document Numbernvarchar100
84FMFG_PPA_LINKLink the application log to an Invoice (PPA)3AWREFReference Document Numbernvarchar100