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

127 columns | Print definition?ERP 6.0  | IMKEY

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000172000PSA for 0FI_GL_14 T90CLNT090 Gen. Ledger: Items141IMKEYnvarchar80
2AUAASettlement Document: Receiver Segment37IMKEYInternal Key for Real Estate Objectnvarchar80
3BSAD_BAKAccounting: Secondary index for customers (cleared items)124IMKEYInternal Key for Real Estate Objectnvarchar80
4BSAK_BAKAccounting: Secondary Index for Vendors (Cleared Items)130IMKEYInternal Key for Real Estate Objectnvarchar80
5BSAS_BAKAccounting: Secondary Index for G/L Accounts (Cleared Items)60IMKEYInternal Key for Real Estate Objectnvarchar80
6BSEGAccounting Document Segment218IMKEYInternal Key for Real Estate Objectnvarchar80
7BSID_BAKAccounting: Secondary Index for Customers124IMKEYInternal Key for Real Estate Objectnvarchar80
8BSIK_BAKAccounting: Secondary index for vendors130IMKEYInternal Key for Real Estate Objectnvarchar80
9BSIS_BAKAccounting: Secondary Index for G/L Accounts60IMKEYInternal Key for Real Estate Objectnvarchar80
10BSSEGAccounting Document Segment207IMKEYInternal Key for Real Estate Objectnvarchar80
11CNVA_PCREA_AA_CPC Reorg Analysis: FI-AA Profit Center assignments16IMKEYInternal Key for Real Estate Objectnvarchar80
12FAGLBSAS_BAKAccounting: Secondary Index for G/L Accounts (Cleared Items)60IMKEYInternal Key for Real Estate Objectnvarchar80
13FAGLBSIS_BAKAccounting: Secondary Index for G/L Accounts60IMKEYInternal Key for Real Estate Objectnvarchar80
14FUDT_VDOCBSEGVerification Document Item with Additional Info207IMKEYInternal Key for Real Estate Objectnvarchar80
15FUDT_VDOCBSEGEVVerification Document Item in the Entry View207IMKEYInternal Key for Real Estate Objectnvarchar80
16FUDT_VDOCBSEGHVerification Document Segment with Additional Info(History)207IMKEYInternal Key for Real Estate Objectnvarchar80
17GLPCA_CTProfit Center Documents76IMKEYInternal Key for Real Estate Objectnvarchar80
18GLPCA_T_CTProfit Center Documents92IMKEYInternal Key for Real Estate Objectnvarchar80
19GLPOS_C_CTFI Document: Entry View139IMKEYInternal Key for Real Estate Objectnvarchar80
20GLPOS_C_DEB_CTGLPOS_C_CT Customer Line Items139IMKEYInternal Key for Real Estate Objectnvarchar80
21GLPOS_C_GL_CTGLPOS_C_CT G/L Line Items139IMKEYInternal Key for Real Estate Objectnvarchar80
22GLPOS_C_VEN_CTGLPOS_C_CT Vendor Line Items139IMKEYInternal Key for Real Estate Objectnvarchar80
23GLPOS_N_CTNew General Ledger: Line Item with Currency Type141IMKEYInternal Key for Real Estate Objectnvarchar80
24GLPOS_N_GL_CTNew General Ledger: Line Item with Currency Type141IMKEYInternal Key for Real Estate Objectnvarchar80
25REGUPProcessed items from payment program122IMKEYInternal Key for Real Estate Objectnvarchar80
26VIXCITCADROTemporary rental object data8IMKEYInternal Key of Real Estate Object (FI)nvarchar80
TOPAccounting Interface
27GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)167IMKEYInternal Key for Real Estate Objectnvarchar80
28GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)167IMKEYInternal Key for Real Estate Objectnvarchar80
TOPAlternative Valuation Run
29CKMLAVRDOCITLines for Cumulation Posting Document60IMKEYInternal Key for Real Estate Objectnvarchar80
TOPBasic Data
30VIBDBEBusiness Entity6IMKEYInternal Key of Real Estate Object (FI)nvarchar80
31VIBDBUBuilding7IMKEYInternal Key of Real Estate Object (FI)nvarchar80
32VIBDPRLand7IMKEYInternal Key of Real Estate Object (FI)nvarchar80
33VIBDRORental Object7IMKEYInternal Key of Real Estate Object (FI)nvarchar80
TOPBasic Functions
34ANLPAsset Periodic Values50IMKEYInternal Key for Real Estate Objectnvarchar80
35ANLZTime-Dependent Asset Allocations36IMKEYInternal Key for Real Estate Objectnvarchar80
36FDI1Cash Management Line Item for RE Classic Planning Records2IMKEYInternal Key for Real Estate Objectnvarchar80
TOPCapital Investments
37ANIADepr. simulation for invest. projects25IMKEYInternal Key for Real Estate Objectnvarchar80
TOPCross-Application Components
38BBSIDAccounting: Secondary index for customers124IMKEYInternal Key for Real Estate Objectnvarchar80
TOPData Retention Tool
39TXW_S_BSEGRetrieve BSEG from archive102IMKEYInternal Key for Real Estate Objectnvarchar80
TOPDunning
40MHNKDunning data (account entries)36IMKEYInternal Key for Real Estate Objectnvarchar80
41MHNKODunning data (acct entries) version before the next change36IMKEYInternal Key for Real Estate Objectnvarchar80
TOPElectronic Bank Statement
42FEB_ACCNT_SAVESaving of Posting Lines for Postprocessing (Account Assign.)65IMKEYInternal Key for Real Estate Objectnvarchar80
43FEB_ACTAcct Assignment Templates65IMKEYInternal Key for Real Estate Objectnvarchar80
TOPExternal Services
44ESKNAccount Assignment in Service Package30IMKEYInternal Key for Real Estate Objectnvarchar80
TOPFinancial Accounting
45ACCTITCompressed Data from FI/CO Document61IMKEYInternal Key for Real Estate Objectnvarchar80
46BSADAccounting: Secondary Index for Customers (Cleared Items)124IMKEYInternal Key for Real Estate Objectnvarchar80
47BSAKAccounting: Secondary Index for Vendors (Cleared Items)130IMKEYInternal Key for Real Estate Objectnvarchar80
48BSASAccounting: Secondary Index for G/L Accounts (Cleared Items)60IMKEYInternal Key for Real Estate Objectnvarchar80
49BSIDAccounting: Secondary Index for Customers124IMKEYInternal Key for Real Estate Objectnvarchar80
50BSIKAccounting: Secondary Index for Vendors130IMKEYInternal Key for Real Estate Objectnvarchar80
51BSISAccounting: Secondary Index for G/L Accounts60IMKEYInternal Key for Real Estate Objectnvarchar80
52EBSEGDoc.Segment of Fin.Accntng External Documents67IMKEYInternal Key for Real Estate Objectnvarchar80
53KMZEIFI: Account Assignment Model Item Information45IMKEYInternal Key for Real Estate Objectnvarchar80
54KOMUAccount Assignment Templates for G/L Account Items45IMKEYInternal Key for Real Estate Objectnvarchar80
55VBSEGADocument Segment for Document Parking - Asset Database57IMKEYInternal Key for Real Estate Objectnvarchar80
56VBSEGSDocument Segment for Document Parking - G/L Account Database40IMKEYInternal Key for Real Estate Objectnvarchar80
TOPFlexible Real Estate Management
57VICAAROBJArchived Data Object13IMKEYInternal Key of Real Estate Object (FI)nvarchar80
58VICAINTRENOAssignment of INTRENO / OBJNR / IMKEY6IMKEYInternal Key of Real Estate Object (FI)nvarchar80
59VIGBOOKLUM: Grundbuch19IMKEYInterner Schlüssel für Immobilienobjektnvarchar80
TOPFreight Processing
60VFKNAccount Determination in Shipment Costs Item29IMKEYInternal Key for Real Estate Objectnvarchar80
TOPFunds Management
61KBLPDocument Item: Manual Document Entry93IMKEYInternal Key for Real Estate Objectnvarchar80
TOPFunds Management-Specific Postings
62FMFUNDTRANSYEARAdditional Documents for Funds Transfer to Diff. Years41IMKEYInternal Key for Real Estate Objectnvarchar80
63PSOSEGSRecurring Request Document Segment, G/L Accounts40IMKEYInternal Key for Real Estate Objectnvarchar80
TOPGeneral Ledger Accounting
64FAGLBSASAccounting: Secondary Index for G/L Accounts (Cleared Items)60IMKEYInternal Key for Real Estate Objectnvarchar80
65FAGLBSISAccounting: Secondary Index for G/L Accounts60IMKEYInternal Key for Real Estate Objectnvarchar80
66FAGL_SPLINFOSplittling Information of Open Items18IMKEYInternal Key for Real Estate Objectnvarchar80
TOPGL Account Posting
67TCJ_POSITIONSCash Journal Document Items72IMKEYInternal Key for Real Estate Objectnvarchar80
TOPInventory Management
68MSEGDocument Segment: Material109IMKEYInternal Key for Real Estate Objectnvarchar80
69MWXMSEGZMSEG: Interface for Posting of Value109IMKEYInternal Key for Real Estate Objectnvarchar80
70MWZMSEGZMSEG:Interface for Posting of Value109IMKEYInternal Key for Real Estate Objectnvarchar80
71RKPFDocument Header: Reservation26IMKEYInternal Key for Real Estate Objectnvarchar80
TOPInvoice Verification
72RBCODocument Item, Incoming Invoice, Account Assignment18IMKEYInternal Key for Real Estate Objectnvarchar80
TOPLocal Currency Changeover
73EWUFI_SCAEMU conversion: Table of the clearings to be adjusted34IMKEYInternal Key for Real Estate Objectnvarchar80
TOPMigration
74VIGWARFLImmobilien gew.: Architektonische Fläche (statischer Teil)5IMKEYKiinteistökohteen sisäinen avainnvarchar80
75VIGWFLOBJImmobilien gew.: Stammdaten Fläche (statischer Teil)4IMKEYKiinteistökohteen sisäinen avainnvarchar80
76VIGWVMFLImmobilien gew.: Stammdaten Vermietfläche (statischer Teil6IMKEYKiinteistökohteen sisäinen avainnvarchar80
77VIMIMAPCNNRConversion Decisions: Contract Numbers7IMKEYInternal Key of Real Estate Object (FI)nvarchar80
TOPProfit Center Accounting
78GLPCAEC-PCA: Actual Line Items95IMKEYInternal Key for Real Estate Objectnvarchar80
79GLPCPEC-PCA: Plan Line Items148IMKEYInternal Key for Real Estate Objectnvarchar80
TOPPurchasing
80EBKNPurchase Requisition Account Assignment32IMKEYInternal Key for Real Estate Objectnvarchar80
81EKKNAccount Assignment in Purchasing Document35IMKEYInternal Key for Real Estate Objectnvarchar80
TOPQuality Inspection
82QALSInspection lot record192IMKEYInternal Key for Real Estate Objectnvarchar80
TOPQuality Notifications
83TQ8COAssignment of reference orders to notification type14IMKEYInternal Key for Real Estate Objectnvarchar80
TOPReal Estate Contract
84VICNCNReal Estate Contract6IMKEYInternal Key of Real Estate Object (FI)nvarchar80
TOPReal Estate Management
85VIAK03Settlement Unit Master Record16IMKEYInternal Key for Real Estate Objectnvarchar80
86VIAK08DME Settlement Units Master Data31IMKEYInternal Key for Real Estate Objectnvarchar80
87VIAK11Inclusion of acct settlement results from D-tape20IMKEYInternal Key for Real Estate Objectnvarchar80
88VIAKBSEGDocument Line Item from SCS for Interface118IMKEYInternal Key for Real Estate Objectnvarchar80
89VIAKUVSales settlement histories14IMKEYInternal Key for Real Estate Objectnvarchar80
90VIAROBJArchived real estate objects8IMKEYInternal Key for Real Estate Objectnvarchar80
91VIBEBECorrection items for input tax treatment21IMKEYInternal Key for Real Estate Objectnvarchar80
92VIBEPPFlow data - Planned items for real estate management2IMKEYInternal Key for Real Estate Objectnvarchar80
93VICN01Real Estate Contract: Contract Data25IMKEYInternal Key for Real Estate Objectnvarchar80
94VIEIGTOLD, replaced by VIEIGE in 3.02IMKEYInternal Key for Real Estate Objectnvarchar80
95VIGBUCHLand register19IMKEYInternal Key for Real Estate Objectnvarchar80
96VIMI01Rental unit - Master data44IMKEYInternal Key for Real Estate Objectnvarchar80
97VIMI04Old. replaced in 3.0 with VIMIMV77IMKEYInternal Key for Real Estate Objectnvarchar80
98VIMI11Applications - Real Estate Management36IMKEYInternal Key for Real Estate Objectnvarchar80
99VIMI16RE: Records of a Rent Adjustment Run33IMKEYInternal Key for Real Estate Objectnvarchar80
100VIMI28Sales settlement histories14IMKEYInternal Key for Real Estate Objectnvarchar80
101VIMI33Offers for a rental unit (-> VIMIMV)49IMKEYInternal Key for Real Estate Objectnvarchar80
102VIMI41Expert opinion on rent adjustment9IMKEYInternal Key for Real Estate Objectnvarchar80
103VIMI44OLD, replaced by VIMI54 for 3.02IMKEYInternal Key for Real Estate Objectnvarchar80
104VIMI45OLD, replaced by VIMI55 for 3.02IMKEYInternal Key for Real Estate Objectnvarchar80
105VIMI46OLD, replaced by VIMI56 for 3.02IMKEYInternal Key for Real Estate Objectnvarchar80
106VIMIMVLease-Out57IMKEYInternal Key for Real Estate Objectnvarchar80
107VIOB01Business entities33IMKEYInternal Key for Real Estate Objectnvarchar80
108VIOB02Property master data39IMKEYInternal Key for Real Estate Objectnvarchar80
109VIOB03Real estate building master43IMKEYInternal Key for Real Estate Objectnvarchar80
110VIOB18Comparative apartments for rent adjustment, external accomm.19IMKEYInternal Key for Real Estate Objectnvarchar80
111VIOB28OLD, replaced by VIOB39 for 3.02IMKEYInternal Key for Real Estate Objectnvarchar80
112VIOB29OLD, replaced by VIOB39 for 3.02IMKEYInternal Key for Real Estate Objectnvarchar80
113VITAXDTax Shares per Real Estate Account Assignment17IMKEYInternal Key for Real Estate Objectnvarchar80
114VIVSTBDocument reference for input tax treatment31IMKEYInternal Key for Real Estate Objectnvarchar80
115VIVW01Management contract: General data4IMKEYInternal Key for Real Estate Objectnvarchar80
116VIVW03Management contract: Calculation forms with selections12IMKEYInternal Key for Real Estate Objectnvarchar80
117VIVW05Management contract: Managed objects7IMKEYInternal Key for Real Estate Objectnvarchar80
118VIVW07Allocation periods: Real estate obj. to management contract7IMKEYInternal Key for Real Estate Objectnvarchar80
119VIVW08Events for management contracts15IMKEYInternal Key for Real Estate Objectnvarchar80
120VIVW09Postings for management costs settlements25IMKEYInternal Key for Real Estate Objectnvarchar80
121VIZNRNAssignment: Real Estate numbers <-> IMKEY <-> INTRENO2IMKEYInternal Key for Real Estate Objectnvarchar80
TOPRemaining Beverage - Obsolete Objects
122/BEV3/CH1030BSG1Document Segment CH Event Ledger Part1209IMKEYInternal Key for Real Estate Objectnvarchar80
TOPRepetitive Manufacturing
123COMPMOVEGoods Movement of Components125IMKEYInternal Key for Real Estate Objectnvarchar80
TOPSelf-Service Procurement
124/SRMERP/D_ACC_ITAccount assignment item29IMKEYInternal Key for Real Estate Objectnvarchar80
TOPService Charge Settlement
125VISCSUSettlement unit8IMKEYInternal Key of Real Estate Object (FI)nvarchar80
TOPSimulation
126VSEBKN_CNVersion: Purchase requisition account assignment33IMKEYInternal Key for Real Estate Objectnvarchar80
TOPTechnical Application Support
127CNV_20425_SCAEMU conversion: Table of the clearings to be adjusted31IMKEYInternal Key for Real Estate Objectnvarchar80