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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

135 columns | Print definition?ERP 6.0  | KTOSL

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000170000PSA for 0FI_GL_4 T90CLNT090 FI-GL Items Delta67KTOSLnvarchar30
2/CCEE/FISITCASlovenia: Tax Code Assigments to DMEE File Positions6KTOSLTransaction Keynvarchar30
3/CCEE/RSFITAXConvert Tax on sales3KTOSLTransaction Keynvarchar30
4/CCEE/RSFITCASerbia: Tax Code Assigments to DMEE File Positions6KTOSLTransaction Keynvarchar30
5/CCEE/SIFI_UMSITTax items applied for decrease/increase of input VAT8KTOSLTransaction Keynvarchar30
6/CEECV/BEFI_VATDVAT Report Estonia - document processed from RFUMSV0019KTOSLTransaction Keynvarchar30
7/CEECV/BVFI_DTTKExclude Transaction Key from VAT Declaration3KTOSLTransaction Keynvarchar30
8/CEECV/BVFI_PVNDocuments for VAT Declaration18KTOSLTransaction Keynvarchar30
9/CEECV/ROFIRFUMDRFUMSV00:Asgn.Tax codes to ROspec columns-DEFERRED t.codes4KTOSLTransaction Keynvarchar30
10/SAPPCE/TDPC78Deferred Tax: Single Transfer Postings6KTOSLTransaction Keynvarchar30
11BBP_PCACCProcurement Card: Accounting Data45KTOSLTransaction Keynvarchar30
12BBP_PCMODProcurement Card: Modified Statement Data47KTOSLTransaction Keynvarchar30
13BSEGAccounting Document Segment48KTOSLTransaction Keynvarchar30
14BSETTax Data Document Segment14KTOSLTransaction Keynvarchar30
15BSSEGAccounting Document Segment37KTOSLTransaction Keynvarchar30
16CNV_20100_T030CNV backup copy for T0304KTOSLnvarchar30
17DFKKEPRTLog for Inconsistent FI-CA Documents60KTOSLTransaction key for account determinationnvarchar30
18DFKKOP_DPDown Payments: Tax Data for Business Partner Item13KTOSLTransaction key for account determinationnvarchar30
19FISKC_DOCTYPDocument type by tax codes4KTOSLTransaction Keynvarchar30
20FISKC_DOCTYPEDocument type by tax codes3KTOSLTransaction Keynvarchar30
21FISKC_TAXSECTax section Slovakia6KTOSLTransaction Keynvarchar30
22FISKC_TAXSECTNTax section slovakia6KTOSLTransaction Keynvarchar30
23FUDT_VDOCBSEGVerification Document Item with Additional Info37KTOSLTransaction Keynvarchar30
24FUDT_VDOCBSEGEVVerification Document Item in the Entry View37KTOSLTransaction Keynvarchar30
25FUDT_VDOCBSEGHVerification Document Segment with Additional Info(History)37KTOSLTransaction Keynvarchar30
26FUDT_VDOCBSETTax Data Document Segment of Verification Document14KTOSLTransaction Keynvarchar30
27FUDT_VDOCBSETHTax Data Document Segment of Verification Document(History)14KTOSLTransaction Keynvarchar30
28GLPOS_C_CTFI Document: Entry View153KTOSLTransaction Keynvarchar30
29GLPOS_C_DEB_CTGLPOS_C_CT Customer Line Items153KTOSLTransaction Keynvarchar30
30GLPOS_C_GL_CTGLPOS_C_CT G/L Line Items153KTOSLTransaction Keynvarchar30
31GLPOS_C_VEN_CTGLPOS_C_CT Vendor Line Items153KTOSLTransaction Keynvarchar30
32GLPOS_N_CTNew General Ledger: Line Item with Currency Type155KTOSLTransaction Keynvarchar30
33GLPOS_N_GL_CTNew General Ledger: Line Item with Currency Type155KTOSLTransaction Keynvarchar30
34IDPL_SIAssign Number Range for Internal Invoices to Company Code4KTOSLTransaction Key for Internal Invoicesnvarchar30
35J_1UF_VAT_OPTYPEVAT Declaration Lines 3 and 4 Grouped by Operation Types6KTOSLTransaction Keynvarchar30
36J_1UF_VAT_OPTYPTVAT Declaration Lines 3 and 4 Grouped by Operation Types7KTOSLTransaction Keynvarchar30
37T007BTax Processing in Accounting2KTOSLInternal processing keynvarchar30
38T007GTable no Longer Used -> T007K/L4KTOSLTransaction Keynvarchar30
39T007K_MYTable for Grouping Tax Basis Balances for Malaysia5KTOSLTransaction Keynvarchar30
40T007L_MYTable for Grouping Tax Balances for Malaysia5KTOSLTransaction Keynvarchar30
41T007NVVDeferred taxes. Tax account assignment to non-deductible cod3KTOSLTransaction Keynvarchar30
42T030Standard Accounts Table3KTOSLTransaction Keynvarchar30
43T030ATransaction Keys and Assignment to Groups1KTOSLTransaction Keynvarchar30
44T030BStandard Posting Keys2KTOSLTransaction Keynvarchar30
45T030CGlobal Standard Account Table3KTOSLTransaction Keynvarchar30
46T030GStandard Accounts Table - Business Area Breakdown4KTOSLTransaction Keynvarchar30
47T030KTax Accounts Determination3KTOSLTransaction Keynvarchar30
48T030RRules for Determination of Standard Accounts3KTOSLTransaction Keynvarchar30
49T030WTransaction Key Names2KTOSLTransaction Keynvarchar30
50T033UAccount Determ.for Balance Sheet Transfer Postings3KTOSLTransaction Keynvarchar30
51TFK_USTPD_KTOSLExt. Tax per Document: Derive Transaction Key and Cond. Type5KTOSLTransaction Keynvarchar30
TOPAccounting Interface
52GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)65KTOSLTransaction Keynvarchar30
53GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)65KTOSLTransaction Keynvarchar30
TOPActual CostingMaterial Ledger
54CKMVFM_BSEG_OUTDisplay of FI Documents, Transaction CKMVFM, SAP Note 91298422KTOSLTransaction Keynvarchar30
55TCKMLBNKSAssignment of Other Account Key if Not to Activate4KTOSLTransaction Keynvarchar30
TOPAlternative Valuation Run
56CKMLAVRDOCITLines for Cumulation Posting Document35KTOSLTransaction Keynvarchar30
TOPBasic Functions
57T059KWithholding tax code and processing key4KTOSLInternal processing keynvarchar30
TOPCollectionsDisbursements
58VVSCPOSPayment Plan Item103KTOSLTransaction key for account determinationnvarchar30
TOPContract Accounts Receivable and Payable
59DFKKARREPCONTSTARGENTINA: Legal report sales tax control table4KTOSLInternal processing keynvarchar30
60DFKKFMBGAINFOTax Information for Public-Owned Commercial Operations19KTOSLTransaction Keynvarchar30
61DFKKMOPKItems in contract account document37KTOSLTransaction key for account determinationnvarchar30
62DFKKOPKItems in contract account document37KTOSLTransaction key for account determinationnvarchar30
63DFKKORDERPOSRequests: Items56KTOSLTransaction Keynvarchar30
64DFKKQSRIndividual Records for Withholding Tax Report24KTOSLTransaction key for account determinationnvarchar30
65DFKKREP06Tax Report Data (Invoicing Time or Triggered)26KTOSLTransaction key for account determinationnvarchar30
66DFKKREP06_STax Report Data - Shadow Table for Posting Date26KTOSLTransaction key for account determinationnvarchar30
67DFKKREP07Tax Report Data (Clearing Time)32KTOSLTransaction key for account determinationnvarchar30
68DFKKSUMPosting totals from FI-CA29KTOSLTransaction Keynvarchar30
69TEARREPCONTSTARGENTINA: Legal report sales tax control table3KTOSLInternal processing keynvarchar30
70TFK007MMaximum Tax5KTOSLTransaction Keynvarchar30
71TFK009Definition of Report Time / Type of Sales / Purchase Taxes4KTOSLTax Item Typenvarchar30
72TFK009_ARARGENTINA: Legal reporting time / grouping3KTOSLInternal processing keynvarchar30
73TFK011Definition of Report Time / Type for Other Taxes4KTOSLTax Item Typenvarchar30
74TFKTAXMINMinimum Amounts for Taxes4KTOSLTransaction Keynvarchar30
TOPData Transfer
75PPDITTransfer to Accounting: Lines in HR IDOCs7KTOSLTransaction Keynvarchar30
TOPExchanges
76OIA07Logical Inventory Valuation Segment Table5KTOSLTransaction Keynvarchar30
77OIA08LIA Document: Item Data32KTOSLFee accounting process keynvarchar30
78TOIABIS-OIL Exchange - Posting keys2KTOSLFee accounting process keynvarchar30
79TOIAEPurchase Fee Account Assignment6KTOSLFee accounting process keynvarchar30
80TOIAFSales Fee Account Assignment6KTOSLFee accounting process keynvarchar30
81TOIAHCheck Table for Fee Accounting Process Strings3KTOSLFee accounting process keynvarchar30
82TOIAHTFee Account Assignment Descriptions4KTOSLFee accounting process keynvarchar30
TOPFinancial Accounting
83/CCEE/FISITAXConvert Tax on sales3KTOSLTransaction Keynvarchar30
84/CCEE/YUFI_RFUMSRFUMSV00: Assignment of Tax codes to serbian columns3KTOSLTransaction Keynvarchar30
85/CEECV/ROFIRFUMSRFUMSV00: Assignment of Tax codes to RO-specific columns4KTOSLTransaction Keynvarchar30
86/CEECV/ROFITAXConvert Tax on sales3KTOSLTransaction Keynvarchar30
87/CEECV/ROFIUMSVTax Balances per Comp.Code, Tax Code and Process.Key7KTOSLTransaction Keynvarchar30
88ACCTITCompressed Data from FI/CO Document22KTOSLTransaction Keynvarchar30
89BFIT_AFI Subsequent BA/PC Adjustment: G/L Account Items11KTOSLTransaction Keynvarchar30
90DEFTAX_ITEMData for Deferred Taxes6KTOSLTransaction Keynvarchar30
91T007MTable for Grouping Taxes for BW4KTOSLTransaction Keynvarchar30
92T030UAccount Determ.for Balance Sheet Transfer Postings4KTOSLTransaction Keynvarchar30
TOPFunds Management-Specific Postings
93FMBGACORRSHistory for Input Tax Adjustments PCOs14KTOSLTransaction Keynvarchar30
94FMBGADCTAXData from Backdated Tax Calculation for PCOs14KTOSLTransaction Keynvarchar30
TOPGeneral Ledger Accounting
95BSEG_ADDEntry View of Accounting Document for Additional Ledgers14KTOSLTransaction Keynvarchar30
96FAGL_RTRACK1Summary: Company Code Currently Affected by Reorg. and KTOSL6KTOSLTransaction Keynvarchar30
97T8G16Allocation: internal key - item category (SAP)3KTOSLTransaction Keynvarchar30
TOPGL transfer
98BKKC02General Ledger: Posting Totals for FI17KTOSLTransaction Keynvarchar30
TOPIncentive and Commission Management ICM
99CACSCD_DOCCD_TISettlement to FS-CD: Reference Tax Information5KTOSLTransaction Keynvarchar30
100CACSFI_DOCFI_TISettlement to FI: Reference Tax Information6KTOSLTransaction Keynvarchar30
101CACSHR_DOCHR_TISettlement to PY: Reference Tax Information5KTOSLTransaction Keynvarchar30
102CACS_DOCFI_TData Transfer: FI Document (Tax Item)9KTOSLTransaction Keynvarchar30
TOPInformation System
103T007KTable for Grouping Tax Basis Balances5KTOSLTransaction Keynvarchar30
104T007LTable for Grouping Tax Balances5KTOSLTransaction Keynvarchar30
105T044LSorted List of Open Items7KTOSLAccount determination for sorted listnvarchar30
106UMSVTax Balances per Comp.Code, Tax Code and Process.Key7KTOSLTransaction Keynvarchar30
TOPInvoicing
107DBERDLPrint Document Line Items10KTOSLTransaction Keynvarchar30
108DBERDZDB Table: Individ. Lines - Print Document5KTOSLTransaction Keynvarchar30
109ERDTSAdditional Charges and Taxes of a Print Document7KTOSLTransaction Keynvarchar30
110ERDZ_SHORTInternal Table for Individual Print Doc.Lines -Extract Data5KTOSLTransaction Keynvarchar30
TOPInvoicing in Contract Accounts Receivable and Payable
111DFKKINVBILL_TTax Items of Billing Document12KTOSLTransaction key for account determinationnvarchar30
112DFKKINVDOC_IItems of Invoicing Document37KTOSLTransaction key for account determinationnvarchar30
TOPJoint Venture und Production Sharing Accounting
113JVPO1JVA: Plan Line Items129KTOSLTransaction Keynvarchar30
114JVSO1JV LI Table with Objects for JVTO165KTOSLTransaction Keynvarchar30
TOPLocal Currency Changeover
115EWUMMFIEMU: transfer table for clearing entries MM-FI16KTOSLTransaction Keynvarchar30
TOPLocalization
116BASE_TYPE_ITAssign Base Amount Type4KTOSLTransaction Keynvarchar30
117ES340_OPRKEYOperation Key in Model - 3405KTOSLTransaction Keynvarchar30
118IDES_SIAssign Number Range for Self Invoices to Company Code5KTOSLTransaction Key for Self Invoicesnvarchar30
119J_1ATAXIDTax Class3KTOSLInternal processing keynvarchar30
120J_1ATPKOFAssignment of official code to processing key3KTOSLInternal processing keynvarchar30
121J_1ATXMINMinimum amount per tax processing key3KTOSLInternal processing keynvarchar30
122J_1IT030KIndia Tax account determination ( T030K + BWMOD )3KTOSLTransaction Keynvarchar30
123J_3RUMSVTax Balances per Comp.Code, Tax Code and Process.Key+ client7KTOSLTransaction Keynvarchar30
124RFIDPTAAVPro-Rata Asset Acquisition Value24KTOSLTransaction Keynvarchar30
125RFIDPTPRTKDefine Trans. Key4KTOSLAccount keynvarchar30
126T007K_LUTable for Grouping Tax Basis Balances Luxembourg5KTOSLTransaction Keynvarchar30
127T007L_ITGrouping Tax Balances Italy Black List5KTOSLTransaction Keynvarchar30
128T007L_LUTable for Grouping Tax Balances Luxembourg5KTOSLTransaction Keynvarchar30
129T007_ITRetail Value-Added Tax Settings4KTOSLTransaction Keynvarchar30
TOPReal Estate Management
130VITAXDTax Shares per Real Estate Account Assignment47KTOSLTransaction Keynvarchar30
TOPRemaining Beverage - Obsolete Objects
131/BEV3/CH1030BSG1Document Segment CH Event Ledger Part139KTOSLTransaction Keynvarchar30
TOPTransaction Manager
132AT210Rules for Determining a Taxes for CFM postings11KTOSLTransaction Keynvarchar30
TOPTravel Expenses
133PTRV_DOC_ITTransfer Travel -> FI/CO: Lines of TRV interm. document6KTOSLTransaction Keynvarchar30
134PTRV_DOC_TAXTransfer Travel -> FI/CO: Tax lines of TRV document6KTOSLTransaction Keynvarchar30
TOPTreasury
135FLQASSETLiquidity Calculation - Settings for FI Mechanisms7KTOSLLiquidity Calculation: Account Key for Material Accountnvarchar30