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

181 columns | Print definition?ERP 6.0  | MONAT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/ATL/HOLIDAYSHolidays Administration4MONATMonth for holiday calculationnvarchar20
2/ATL/SMR1Inventory value in "hard" currency4MONATFiscal Periodnvarchar20
3/BGLOCS/VATMAHDRVAT Margin Header8MONATFiscal Periodnvarchar20
4/BIC/B0000168000PSA for 0FI_GL_40 T90CLNT090 G/L Accounts: Items36MONATnvarchar20
5/BIC/B0000169000PSA for 0FI_GL_41 T90CLNT090 Documents, Compact36MONATnvarchar20
6/BIC/B0000172000PSA for 0FI_GL_14 T90CLNT090 Gen. Ledger: Items42MONATnvarchar20
7/CCEE/SIFIPOBOTIePoboti: Obligatory manysided reconciliation - XML output32MONATFiscal Periodnvarchar20
8/CCEE/SIFI_UMSITTax items applied for decrease/increase of input VAT6MONATFiscal Periodnvarchar20
9/CEECV/BEFI_VATDVAT Report Estonia - document processed from RFUMSV008MONATFiscal Periodnvarchar20
10BOE_REF_DOCReference documnet for BoE23MONATFiscal Periodnvarchar20
11BSAD_BAKAccounting: Secondary index for customers (cleared items)18MONATFiscal Periodnvarchar20
12BSAK_BAKAccounting: Secondary Index for Vendors (Cleared Items)18MONATFiscal Periodnvarchar20
13BSAS_BAKAccounting: Secondary Index for G/L Accounts (Cleared Items)15MONATFiscal Periodnvarchar20
14BSID_BAKAccounting: Secondary Index for Customers18MONATFiscal Periodnvarchar20
15BSIK_BAKAccounting: Secondary index for vendors18MONATFiscal Periodnvarchar20
16BSIS_BAKAccounting: Secondary Index for G/L Accounts15MONATFiscal Periodnvarchar20
17CNV_20200_RF180Copy of RF180 with new AFTLF to determine AFTLF-Mapping14MONATFiscal Periodnvarchar20
18DFKKSAFTBPObsolete! SAF-T Business Partner4MONATFiscal Periodnvarchar20
19DFKKSAFTINV_HSAF-T Source Document: Header4MONATFiscal Periodnvarchar20
20DFKKSAFTINV_ISAF-T Source Document: Item4MONATFiscal Periodnvarchar20
21DFKKSAFTPAY_HSAF-T Payment Source Document: Header4MONATFiscal Periodnvarchar20
22DFKKSAFTPAY_ISAF-T Payment Source Document: Item4MONATFiscal Periodnvarchar20
23DFKKSAFTPAY_ORIGSAF-T Payment Source Document: Item4MONATFiscal Periodnvarchar20
24DFKKSAFTSALObsolete!6MONATFiscal Periodnvarchar20
25DFKKSAFTSAL_BPSAF-T Balances8MONATFiscal Periodnvarchar20
26EPIC_BRS_FI_BUFFEPIC: Bank Reconciliation Statement Buff FI balance table4MONATFiscal Periodnvarchar20
27EPIC_BRS_HEADEREPIC: Bank Reconciliation Statement4MONATFiscal Periodnvarchar20
28EPIC_BRS_SEGMENTEPIC: Bank Reconciliation Statement4MONATFiscal Periodnvarchar20
29FAGLBSAS_BAKAccounting: Secondary Index for G/L Accounts (Cleared Items)15MONATFiscal Periodnvarchar20
30FAGLBSIS_BAKAccounting: Secondary Index for G/L Accounts15MONATFiscal Periodnvarchar20
31FIBKRUD_CMO_HDConsolidated MO header8MONATFiscal Periodnvarchar20
32FIBKRUD_MEMORDERMemo Order for Banking RU8MONATFiscal Periodnvarchar20
33FIEUD_FIDOC_HSAFT: FI Transaction Document Header8MONATFiscal Periodnvarchar20
34FIEUD_FISUMMARYSAFT: FI Transaction Summary Information4MONATFiscal Periodnvarchar20
35FIEUD_INVSUMMARYSAFT: FI Transaction Summary Information4MONATFiscal Periodnvarchar20
36FISKD_SUMMARYSummary table for VAT Ledger3MONATFiscal Periodnvarchar20
37FKKSK_VATLEDFI-CA Slovakia: VAT Ledger Exported Data4MONATFiscal Periodnvarchar20
38FKKSK_VATLED_D2FI-CA Slovakia: VAT Ledger Section D2 records(keys)4MONATFiscal Periodnvarchar20
39FKKSK_VATPERFI-CA Slovakia: VAT Ledger Period Status4MONATFiscal Periodnvarchar20
40FKKSK_VATRUNFI-CA Slovakia: VAT Ledger Report Runs4MONATFiscal Periodnvarchar20
41FUDT_VDOCBKPFVerification Document Header8MONATFiscal Periodnvarchar20
42FUDT_VDOCBKPFHVerification Document Header(History)8MONATFiscal Periodnvarchar20
43GLPOS_C_CTFI Document: Entry View174MONATFiscal Periodnvarchar20
44GLPOS_C_DEB_CTGLPOS_C_CT Customer Line Items174MONATFiscal Periodnvarchar20
45GLPOS_C_GL_CTGLPOS_C_CT G/L Line Items174MONATFiscal Periodnvarchar20
46GLPOS_C_VEN_CTGLPOS_C_CT Vendor Line Items174MONATFiscal Periodnvarchar20
47GLPOS_N_CTNew General Ledger: Line Item with Currency Type177MONATFiscal Periodnvarchar20
48GLPOS_N_GL_CTNew General Ledger: Line Item with Currency Type177MONATFiscal Periodnvarchar20
49GLT0_DIFDelta Table: G/L Account Master Transaction Figures11MONATFiscal Periodnvarchar20
50IDCN_3RFF4ADJDOCAdjustment Document Header7MONATFiscal Periodnvarchar20
51ITMF_D_FISC_PERIFiscal Period5MONATFiscal Periodnvarchar20
52J_1UF_REE_NUMDocument Numbers in Register5MONATFiscal Periodnvarchar20
53RFUMSV00_HISTMaintain data for previous VAT return run5MONATFiscal Periodnvarchar20
54T5D2GTax Procedure (D)3MONATMonthnvarchar20
55ZDG00Data generation time control4MONATMonthnvarchar20
56ZDG10MM data generation table4MONATMonthnvarchar20
57ZDG20SD data generation table4MONATMonthnvarchar20
58ZDG30SD data generation table4MONATMonthnvarchar20
59ZDG40Table for Data Generation (Repetitive Manufacturing)4MONATMonthnvarchar20
60ZDG50Table ZDG50 for Data Gen. in RT Area (Monthly via ZARTJ)4MONATMonthnvarchar20
61ZDG60Table ZDG60 for Data Gen. in RT Area (Monthly via ZARTJ)4MONATMonthnvarchar20
62ZGVBGVB Schadensdb Data5MONATnvarchar20
63ZJVPARMSJournal Entries for Business case7MONATFiscal Periodnvarchar20
TOPAccounting Interface
64GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)51MONATFiscal Periodnvarchar20
65GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)51MONATFiscal Periodnvarchar20
TOPActual CostingMaterial Ledger
66CKMVFM_BSEG_OUTDisplay of FI Documents, Transaction CKMVFM, SAP Note 91298430MONATFiscal Periodnvarchar20
TOPAdvertising Management
67JHAERLIS-M: OPM Ad Error Log for Schedule Line Generation18MONATIS-M: Month in yearnvarchar60
68JHTFKIS-M/AM: Settlement Documents (Billing, Commission) - Header70MONATFiscal Periodnvarchar20
TOPAgency Business Global Trade
69WBRKAgency business: Header120MONATFiscal Periodnvarchar20
TOPAlternative Valuation Run
70CKMLAVRDOCITLines for Cumulation Posting Document25MONATFiscal Periodnvarchar20
TOPAsset Accounting
71APERB_PROTLog Table for Periodic Posting5MONATFiscal Periodnvarchar20
TOPAutomatic Payments
72PAYRQPayment Requests11MONATFiscal Periodnvarchar20
TOPBasic Data
73NLSUIS-H: Totals File for Service Statistics5MONATIS-H: Month to be evaluated in statisticsnvarchar20
TOPBasic Functions
74ANEKDocument Header Asset Posting9MONATFiscal Periodnvarchar20
75ARC_IDX_ATIndex table for ACCTIT/ACCTHD/ACCTCR archives6MONATFiscal Periodnvarchar20
76GSBLCABusiness area consolidation: deviating records6MONATFiscal Periodnvarchar20
77T091CTranslation methods for Asset Accounting6MONATCalendar monthnvarchar20
TOPBasis Components
78ZDS400_BKPFBelegkopf für Buchhaltung8MONATGeschäftsmonatnvarchar20
TOPContract Accounts Receivable and Payable
79FMRC01_FICAResults List Comparison of FM/FI (FI-CA Documents)6MONATFiscal Periodnvarchar20
TOPCross-Application Components
80BBSIDAccounting: Secondary index for customers18MONATFiscal Periodnvarchar20
81BKKPFAccounting document header8MONATFiscal Periodnvarchar20
TOPData Retention Tool
82TXW_S_ANEARetrieve ANEA from archive15MONATFiscal Periodnvarchar20
83TXW_S_ANEKRetrieve ANEP from archive13MONATFiscal Periodnvarchar20
84TXW_S_ANEPRetrieve ANEP from archive16MONATFiscal Periodnvarchar20
85TXW_S_BKPFRetrieve BKPF from archive9MONATFiscal Periodnvarchar20
86TXW_S_BSEGRetrieve BSEG from archive11MONATFiscal Periodnvarchar20
87TXW_S_COBKRetrieve COBK from archive8MONATFiscal Periodnvarchar20
88TXW_S_MKPFRetrieve MKPF from archive8MONATFiscal Periodnvarchar20
89TXW_S_MSEGRetrieve MSEG from archive11MONATFiscal Periodnvarchar20
90TXW_S_VBRKRetrieve VBRK from archive7MONATFiscal Periodnvarchar20
91TXW_S_VBRPRetrieve VBRP from archive8MONATFiscal Periodnvarchar20
TOPData Staging
92RSRADIOMONUser-specific Settings (Radio Buttons)5MONATBooleannvarchar10
TOPData Transfer
93PPDHDTransfer to Accounting: Document Header9MONATFiscal Periodnvarchar20
TOPElectronic Bank Statement
94FEB_ACCNT_SAVESaving of Posting Lines for Postprocessing (Account Assign.)84MONATFiscal Periodnvarchar20
95FEB_ACTAcct Assignment Templates84MONATFiscal Periodnvarchar20
TOPFinancial Accounting
96ACCTITCompressed Data from FI/CO Document16MONATFiscal Periodnvarchar20
97BKPFAccounting Document Header8MONATFiscal Periodnvarchar20
98BSADAccounting: Secondary Index for Customers (Cleared Items)18MONATFiscal Periodnvarchar20
99BSAKAccounting: Secondary Index for Vendors (Cleared Items)18MONATFiscal Periodnvarchar20
100BSASAccounting: Secondary Index for G/L Accounts (Cleared Items)15MONATFiscal Periodnvarchar20
101BSIDAccounting: Secondary Index for Customers18MONATFiscal Periodnvarchar20
102BSIKAccounting: Secondary Index for Vendors18MONATFiscal Periodnvarchar20
103BSISAccounting: Secondary Index for G/L Accounts15MONATFiscal Periodnvarchar20
104EBKPFFin.Accntng Doc.Header (of Docs from Extern.Systems)10MONATFiscal Periodnvarchar20
105FOTRFDITMVAT Refund Items14MONATFiscal Periodnvarchar20
106ICRC05G/L Account Reconciliation - Details on Last Data Selection3MONATFiscal Periodnvarchar20
107J_1UDAM: Depreciation factor3MONATFiscal Periodnvarchar20
108J_1UF_CONTRACTRe-calculation contract4MONATFiscal Periodnvarchar20
109J_1UF_TAX_AN2Reimbursement amount for annex 2 of VAT Declaration Ukraine6MONATFiscal Periodnvarchar20
110RF180Subsequent BA/PC Adjustment: Posting Runs12MONATFiscal Periodnvarchar20
111VBKPFDocument Header for Document Parking10MONATFiscal Periodnvarchar20
TOPFlexible Real Estate Management
112VIXCOTDOCCOA, Distribution of VAT, Documents4MONATFiscal Periodnvarchar20
113VIXCOTDSCOA, Distribution of VAT4MONATFiscal Periodnvarchar20
TOPFunds Management
114FMPU_MIG_RPITEMSMigration of Payment Update: Doc. Bundle to Be Reconstructed7MONATFiscal Periodnvarchar20
115FMSAPF048Archivable FI Documents (Check FM Payment Selection)5MONATFiscal Periodnvarchar20
116FMSAPF048BNon-Archivable FI Documents (Check FM Payment Selection)5MONATFiscal Periodnvarchar20
TOPFunds Management-Specific Postings
117FMBGACORRSHistory for Input Tax Adjustments PCOs4MONATFiscal Periodnvarchar20
118FMBGADCTAXData from Backdated Tax Calculation for PCOs4MONATFiscal Periodnvarchar20
119PAYBUHeader Supplement for Payment Requests Without Vendor7MONATFiscal Periodnvarchar20
120PSOKPFRecurring Request Document Header11MONATFiscal Periodnvarchar20
TOPGeneral Ledger Accounting
121BKPF_ADDAccounting Document Header8MONATFiscal Periodnvarchar20
122FAGLBSASAccounting: Secondary Index for G/L Accounts (Cleared Items)15MONATFiscal Periodnvarchar20
123FAGLBSISAccounting: Secondary Index for G/L Accounts15MONATFiscal Periodnvarchar20
124FAGL_BW_LOG_ITEMFI-GL: Log for BW Extraction: Line Items14MONATFiscal Periodnvarchar20
125FAGL_MIG_RPITEMSMigration in New G/L: Objects To Be Posted Subsequently6MONATFiscal Periodnvarchar20
TOPGermany
126T5D2MMonth of Issue: Employment Tax Statement (Tax Germany)4MONATOutput Monthnvarchar20
TOPGL Account Posting
127TCJ_POSITIONSCash Journal Document Items91MONATFiscal Periodnvarchar20
TOPHoliday Calendar, Factory Calendar, Appointment Calendar
128THOLPublic Holidays3MONATMonth for holiday calculationnvarchar20
129THOLUDates of movable public holidays3MONATMonth for holiday calculationnvarchar20
TOPInformation System
130RFSCASHCash Book table4MONATFiscal Periodnvarchar20
TOPInventory Management
131IKPFHeader: Physical Inventory Document12MONATFiscal Periodnvarchar20
132MWXVM07MFields: Update Control of Module Pool SAPMM07M143MONATFiscal Periodnvarchar20
133MWZVM07MFields: Update Control of Module Pool SAPMM07M143MONATFiscal Periodnvarchar20
TOPInvoice Verification
134RBKPBInvoice Document Header (Batch Invoice Verification)86MONATOutdated: Fiscal period - do NOT use!!!nvarchar20
TOPLease Accounting
135FILA_GF_ITEMDATAProcess Data45MONATFiscal Periodnvarchar20
136FILA_GF_ITEMDOCSAssignment of Process - FI/CO Document Numbers13MONATFiscal Periodnvarchar20
TOPLoans Management
137VDZNB_HEADPmnt Postproc.: Header for a Payment Postprocessing Activity7MONATFiscal Periodnvarchar20
138VZFZE_VDNBZECentral Entry Table for Release Procedure85MONATFiscal Periodnvarchar20
TOPLocalization
139BEL_JOURNALBelgium : Sales/Purchase Journal Period Balances4MONATFiscal Periodnvarchar20
140IDCN_REPSHEQTYShareholders' Equity (Golden Audit)4MONATFiscal Periodnvarchar20
141IDCN_ZJFPLBALP&L Balances for Period Account Entry Closing Method5MONATFiscal Periodnvarchar20
142IDSL_GDDTReport Date for Deferred Tax (Slovakia)4MONATFiscal Periodnvarchar20
143J_3RFTAX_EXTRDTax Extract Detail Lines45MONATFiscal Periodnvarchar20
144J_3RKKRSAccount correspondence line items13MONATFiscal Periodnvarchar20
145J_3RSINCINVIncoming Invoices For Separate VAT7MONATVAT Periodnvarchar20
146J_3RSINVLNKLinks Between Incoming And Outgoing Invoices For Export Oper11MONATVAT Periodnvarchar20
147J_3RSSEPVATCOEFSeparate VAT Coefficients4MONATVAT Periodnvarchar20
148J_3RSSEPVATCOEFASeparate VAT Coefficients EhP5 SP55MONATVAT Periodnvarchar20
149RFITEMAP_NO_ITEMItem wise detail for the Vendor Transactions43MONATFiscal Periodnvarchar20
150RFITEMAR_NO_ITEMItem wise detail for the Customer Transactions43MONATFiscal Periodnvarchar20
151RFITEMGL_NO_ITEMItem wise detail for the GL Account Transactions43MONATFiscal Periodnvarchar20
152VIXCCORRVIIRInvoice Item Reference for Corr/Rev Invoices25MONATFiscal Periodnvarchar20
TOPMaterials Management
153J_1GVL_WHB017Open Production Orders (WIP)3MONATFiscal Periodnvarchar20
154J_1GVL_WHBLOG2Circular Valuation Log5MONATFiscal Periodnvarchar20
155J_1GVL_WHBPOLmaterial analytical ledger period totals4MONATFiscal Periodnvarchar20
TOPPayroll
156T5H7OMonthly statistical reports7MONATMonthnvarchar20
157T7TRG02Nema Orani4MONATMali aynvarchar20
TOPPendulum List Indirect Sales
158/BEV4/PLDANFKONConverted Request Table with Reporting Period14MONATReporting Monthnvarchar20
159/BEV4/PLDANFMELRequest Table with Reporting Period11MONATReporting Monthnvarchar20
160/BEV4/PLDANFZEITRequirement Update9MONATReporting Monthnvarchar20
TOPPeriodical Sales and Distribution
161JFXBPOSDLIS-M: Backup Transfer Internal Table XBPOS7MONATFiscal Periodnvarchar20
TOPPersonnel Time Management
162T552AMonthly Work Schedule7MONATFiscal Periodnvarchar20
TOPReal Estate Management
163VIAK16SCS: Identification Of Settlement With Log Reference25MONATFiscal Periodnvarchar20
164VIAKBKPFDocument Header from Service Charge Settlement for Interface8MONATFiscal Periodnvarchar20
165VIEA03Administration information: Objects of owner settlement6MONATFiscal Periodnvarchar20
166VIEA06Management information: Owner for owner settlement6MONATFiscal Periodnvarchar20
167VISLIDDebit position history19MONATFiscal Periodnvarchar20
168VITAXDTax Shares per Real Estate Account Assignment21MONATFiscal Periodnvarchar20
169VIVSTBDocument reference for input tax treatment30MONATFiscal Periodnvarchar20
TOPReal Estate Slovakia
170TIVXCSKACCPERPPosting Period Control: Periods5MONATPosting Periodnvarchar20
171VIXCSKTAXASSESProperty Tax - Tax Assessment6MONATPosting Periodnvarchar20
TOPRegulatory reporting for insurance companies
172ISSRPREFLOWISSR: Basistabelle/Bewegungstabelle51MONATMese esercizionvarchar20
TOPRemaining Beverage - Obsolete Objects
173/BEV3/CH1030BKPFHeader Data for CH Event Ledger 0000103010MONATFiscal Periodnvarchar20
TOPSAP Media
174J_1SGEWAULIS-M/SD CH: No.Taxable Issues by Weight Groups - Foreign5MONATMonth long textnvarchar100
175J_1SGEWBTEIS-M/SD CH: No.Taxable Issues by Weight Groups - Domestic5MONATMonth long textnvarchar100
176J_1SGEWINLIS-M/SD CH: No.Taxable Issues by Weight Groups - Domestic5MONATMonth long textnvarchar100
177J_1SGEWPLAIS-M/SD CH: No.Taxable Issues by Weight Groups - Domestic5MONATMonth long textnvarchar100
TOPTechnical Application Support
178CNV_20425_S_ABST20425: Reconciliation 2 / 3 local currency9MONATFiscal Periodnvarchar20
TOPTravel Expenses
179PTRV_COUNTNumber of function calls in posting run management2MONATFiscal Periodnvarchar20
180PTRV_DOC_HDTransfer Travel -> FI/CO: Header of TRV int. document10MONATFiscal Periodnvarchar20
TOPValue Adjustment
181/IBS/TRB_UIRBD: RBD Record Data Table (Actual)10MONATFiscal Periodnvarchar20