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

102 columns | Print definition?ERP 6.0  | STCEG

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/ATL/KPRCPTDetail of receipt35STCEGVAT Registration Numbernvarchar200
2/ATL/KPRCPTKPDetail of temporary receipt35STCEGVAT Registration Numbernvarchar200
3/CCEE/SIFI_RFASDSI EC Sales List - reported data - deliveries3STCEGVAT Registration Numbernvarchar200
4/CCEE/SIFI_RFASLSI EC Sales List - reported data3STCEGVAT Registration Numbernvarchar200
5/CEECV/BEFI_VATDVAT Report Estonia - document processed from RFUMSV0018STCEGVAT Registration Numbernvarchar200
6/CEECV/BVFI_PVNDocuments for VAT Declaration17STCEGVAT Registration Numbernvarchar200
7/CEECV/RORFMDATARO RFUMSV00 official run data14STCEGVAT Registration Numbernvarchar200
8BSAD_BAKAccounting: Secondary index for customers (cleared items)86STCEGVAT Registration Numbernvarchar200
9BSAK_BAKAccounting: Secondary Index for Vendors (Cleared Items)93STCEGVAT Registration Numbernvarchar200
10BSEGAccounting Document Segment199STCEGVAT Registration Numbernvarchar200
11BSETTax Data Document Segment16STCEGVAT Registration Numbernvarchar200
12BSID_BAKAccounting: Secondary Index for Customers86STCEGVAT Registration Numbernvarchar200
13BSIK_BAKAccounting: Secondary index for vendors93STCEGVAT Registration Numbernvarchar200
14BSSEGAccounting Document Segment188STCEGVAT Registration Numbernvarchar200
15CNV_20100_T001CNV backup copy for T00128STCEGVAT Registration Numbernvarchar200
16CNV_20200_T001ADOriginal settings of company codes (additional fields)9STCEGVAT Registration Numbernvarchar200
17DFKKHUREPDSRecording Data for Domestic Sales Hungary26STCEGVAT Registration Numbernvarchar200
18FIAPPTD_BALANCETable to store the Balances for Vendor/Customer/Bank Account22STCEGCounterpart ID or VAT Registration Numbernvarchar200
19FIAPPTD_TRANSTable to store the transaction details of the CBR PT27STCEGCounterpart ID or VAT Registration Numbernvarchar200
20FISKD_VATCNTRLDocument's information reported to SK authorities13STCEGVAT Registration Numbernvarchar200
21FUDT_VDOCBSEGVerification Document Item with Additional Info188STCEGVAT Registration Numbernvarchar200
22FUDT_VDOCBSEGEVVerification Document Item in the Entry View188STCEGVAT Registration Numbernvarchar200
23FUDT_VDOCBSEGHVerification Document Segment with Additional Info(History)188STCEGVAT Registration Numbernvarchar200
24FUDT_VDOCBSETTax Data Document Segment of Verification Document16STCEGVAT Registration Numbernvarchar200
25FUDT_VDOCBSETHTax Data Document Segment of Verification Document(History)16STCEGVAT Registration Numbernvarchar200
26GLPOS_C_CTFI Document: Entry View236STCEGVAT Registration Numbernvarchar200
27GLPOS_C_DEB_CTGLPOS_C_CT Customer Line Items236STCEGVAT Registration Numbernvarchar200
28GLPOS_C_GL_CTGLPOS_C_CT G/L Line Items236STCEGVAT Registration Numbernvarchar200
29GLPOS_C_VEN_CTGLPOS_C_CT Vendor Line Items236STCEGVAT Registration Numbernvarchar200
30GLPOS_N_CTNew General Ledger: Line Item with Currency Type244STCEGVAT Registration Numbernvarchar200
31GLPOS_N_GL_CTNew General Ledger: Line Item with Currency Type244STCEGVAT Registration Numbernvarchar200
32REGUPProcessed items from payment program90STCEGVAT Registration Numbernvarchar200
33TZD0ADarwin: Customer default values per trans. type for KNA120STCEGVAT Registration Numbernvarchar200
TOPAccounting Interface
34GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)125STCEGVAT Registration Numbernvarchar200
35GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)125STCEGVAT Registration Numbernvarchar200
TOPAdvertising Management
36JHTFKIS-M/AM: Settlement Documents (Billing, Commission) - Header92STCEGVAT Registration Numbernvarchar200
TOPAgency Business Global Trade
37WBPAAgency Business: Business Partner Assignment18STCEGVAT Registration Numbernvarchar200
38WBRKAgency business: Header151STCEGVendor VAT registration numbernvarchar200
TOPBasic Functions
39VBPASales Document: Partner21STCEGVAT Registration Numbernvarchar200
TOPBasis Components
40ZDS400_T001Buchungskreise27STCEGUmsatzsteuer-Identifikationsnummernvarchar200
TOPBilling
41VBRKBilling Document: Header Data57STCEGVAT Registration Numbernvarchar200
TOPBusiness Partner
42TIVBPVENDORGENVendor Preassignment (General Data)38STCEGVAT Registration Numbernvarchar200
TOPBusiness Partner Enhancements for Financial Services
43BP1020BP: Business Partner - Fiscal Data10STCEGVAT Registration Numbernvarchar200
TOPContract Accounts Receivable and Payable
44DFKKREP01Data for Sales Lists (Belgium)3STCEGVAT Registration Numbernvarchar200
45DFKKREP02Data for Sales Lists (Belgium)3STCEGVAT Registration Numbernvarchar200
46DFKKREPZMRecording Data for EC Sales List22STCEGVAT Registration Numbernvarchar200
47FKK_JFRK_SHORTHeader Data for IS-M/SD Billing Document - Extracts25STCEGVAT Registration Numbernvarchar200
48FKK_JLRK_SHORTHeader Data for IS-M/SD Service Settlement - Extracts23STCEGVAT Registration Numbernvarchar200
TOPCross-Application Components
49BBSIDAccounting: Secondary index for customers86STCEGVAT Registration Numbernvarchar200
50BC490KKNA1General data in customer master64STCEGVAT Registration Numbernvarchar200
51KKNA1General Data in Customer Master64STCEGVAT Registration Numbernvarchar200
52SKNA1Customer Master table for BC417 Course64STCEGVAT Registration Numbernvarchar200
53VBBPASales Document: Partner21STCEGVAT Registration Numbernvarchar200
54VVBBPASales Document: Partner21STCEGVAT Registration Numbernvarchar200
55VVVBPASales Document: Partner21STCEGVAT Registration Numbernvarchar200
TOPCustomer Master
56KNA1General Data in Customer Master64STCEGVAT Registration Numbernvarchar200
TOPData Retention Tool
57TXW_S_BSEGRetrieve BSEG from archive94STCEGVAT Registration Numbernvarchar200
58TXW_S_VBRKRetrieve VBRK from archive34STCEGVAT Registration Numbernvarchar200
TOPERS
59ISAERSLISTERS Collective Settlement List19STCEGVAT Registration Numbernvarchar200
TOPFinancial Accounting
60/CCEE/SIFIDDVSpecial Tax Table10STCEGVAT Registration Numbernvarchar200
61/CCEE/SIFIPE17Temporary import of goods17STCEGVAT Registration Numbernvarchar200
62BSADAccounting: Secondary Index for Customers (Cleared Items)86STCEGVAT Registration Numbernvarchar200
63BSAKAccounting: Secondary Index for Vendors (Cleared Items)93STCEGVAT Registration Numbernvarchar200
64BSIDAccounting: Secondary Index for Customers86STCEGVAT Registration Numbernvarchar200
65BSIKAccounting: Secondary Index for Vendors93STCEGVAT Registration Numbernvarchar200
66FOTRFDITMVAT Refund Items51STCEGVAT Registration Numbernvarchar200
67FOTRFDITMCHGChange Documents, VAT Refund Item25STCEGVAT Registration Numbernvarchar200
68KNASCustomer master (VAT registration numbers general section)4STCEGVAT Registration Numbernvarchar200
69LFA1Vendor Master (General Section)55STCEGVAT Registration Numbernvarchar200
70LFASVendor master (VAT registration numbers general section)4STCEGVAT Registration Numbernvarchar200
71T001Company Codes14STCEGVAT Registration Numbernvarchar200
72T001NCompany Code - EC Tax Numbers / Notifications4STCEGVAT Registration Numbernvarchar200
73VBSEGDDocument Segment for Customer Document Parking80STCEGVAT Registration Numbernvarchar200
74VBSEGKDocument Segment for Vendor Document Parking93STCEGVAT Registration Numbernvarchar200
75VBSEGSDocument Segment for Document Parking - G/L Account Database64STCEGVAT Registration Numbernvarchar200
TOPFunds Management-Specific Postings
76FMFUNDTRANSYEARAdditional Documents for Funds Transfer to Diff. Years63STCEGVAT Registration Numbernvarchar200
77PSOSEGDDocument Segment: Recurring Request, Customer81STCEGVAT Registration Numbernvarchar200
78PSOSEGKRecurring Request Document Segment, Vendors94STCEGVAT Registration Numbernvarchar200
79PSOSEGSRecurring Request Document Segment, G/L Accounts62STCEGVAT Registration Numbernvarchar200
TOPGL Account Posting
80TCJ_POSITIONSCash Journal Document Items98STCEGVAT Registration Numbernvarchar200
TOPInformation System
81DKKOPBalance Audit Trail64STCEGVAT Registration Numbernvarchar200
82DSKOPBalance Audit Trail76STCEGVAT Registration Numbernvarchar200
83QSTREFI/HR Withholding Tax Report for Spain12STCEGVAT Registration Numbernvarchar200
84RFASLD11BEC Sales List (Spain)5STCEGVAT Registration Numbernvarchar200
TOPIntercompany Data Exchange
85TINV_HEAD_SHORTExtract of Bill Receipt (Evaluation System): Bill Header8STCEGVAT Registration Numbernvarchar200
86TINV_INV_HEADBill Header14STCEGVAT Registration Numbernvarchar200
TOPInvoice Verification
87RBKPDocument Header: Invoice Receipt116STCEGVAT Registration Numbernvarchar200
TOPLocalization
88RFASLD15EC Sales List for new EU Countries5STCEGVAT Registration Numbernvarchar200
89RFITEMAP_NO_ITEMItem wise detail for the Vendor Transactions146STCEGVAT Registration Numbernvarchar200
90RFITEMAR_NO_ITEMItem wise detail for the Customer Transactions146STCEGVAT Registration Numbernvarchar200
91RFITEMGL_NO_ITEMItem wise detail for the GL Account Transactions146STCEGVAT Registration Numbernvarchar200
TOPPayment Transactions
92FPRL_ITEMItem Data53STCEGVAT Registration Numbernvarchar200
93REGUP_COREProcessed Items from Payment Program30STCEGVAT Registration Numbernvarchar200
TOPPeriodical Sales and Distribution
94JFRKIS-M/SD: Billing - Header Data46STCEGVAT Registration Numbernvarchar200
95JLRKIS-M/SD: Settlement Header Data30STCEGVAT Registration Numbernvarchar200
TOPPurchasing
96EKKOPurchasing Document Header69STCEGVAT Registration Numbernvarchar200
TOPRemaining Beverage - Obsolete Objects
97/BEV1/RBVBPASales Document: Partner, Copy VBPA for Indirect Orders21STCEGVAT Registration Numbernvarchar200
98/BEV3/CH1030BSG1Document Segment CH Event Ledger Part1190STCEGVAT Registration Numbernvarchar200
TOPThird Party ManagementCOA
99VIMMMNMandate24STCEGVAT Registration Numbernvarchar200
TOPTravel Expenses
100PTRV_VATDETAILSupplier Data for VAT Refund in Travel Management8STCEGVAT Registration Numbernvarchar200
101T706_VAT_FLDSCountry-Dependent Field Control for Receipt Data11STCEGVAT Registration Numbernvarchar10
TOPTreasury
102VZKNA1Collector for batch input KNA1 from RF-VV43STCEGVAT Registration Numbernvarchar200