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

55 columns | Print definition?ERP 6.0  | FDGRP

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1BSEGAccounting Document Segment63FDGRPPlanning Groupnvarchar100
2BSSEGAccounting Document Segment52FDGRPPlanning Groupnvarchar100
3FUDT_VDOCBSEGVerification Document Item with Additional Info52FDGRPPlanning Groupnvarchar100
4FUDT_VDOCBSEGEVVerification Document Item in the Entry View52FDGRPPlanning Groupnvarchar100
5FUDT_VDOCBSEGHVerification Document Segment with Additional Info(History)52FDGRPPlanning Groupnvarchar100
6GLPOS_C_CTFI Document: Entry View109FDGRPPlanning Groupnvarchar100
7GLPOS_C_DEB_CTGLPOS_C_CT Customer Line Items109FDGRPPlanning Groupnvarchar100
8GLPOS_C_GL_CTGLPOS_C_CT G/L Line Items109FDGRPPlanning Groupnvarchar100
9GLPOS_C_VEN_CTGLPOS_C_CT Vendor Line Items109FDGRPPlanning Groupnvarchar100
10GLPOS_N_CTNew General Ledger: Line Item with Currency Type111FDGRPPlanning Groupnvarchar100
11GLPOS_N_GL_CTNew General Ledger: Line Item with Currency Type111FDGRPPlanning Groupnvarchar100
TOPAccounting Interface
12GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)273FDGRPPlanning Groupnvarchar100
13GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)273FDGRPPlanning Groupnvarchar100
TOPBasic Functions
14FDD1Cash mgmt and forecast-Loan line items-Memo records10FDGRPPlanning Groupnvarchar100
15FDFIEPCM: FI Line Items (OP of Deb/Cred for Drilldown)8FDGRPPlanning Groupnvarchar100
16FDI1Cash Management Line Item for RE Classic Planning Records10FDGRPPlanning Groupnvarchar100
17FDLFCash Management Line Items for Agency Business10FDGRPPlanning Groupnvarchar100
18FDLF2Cash Management Line Items for Agency Business (As of 604)11FDGRPPlanning Groupnvarchar100
19FDM1Cash Management & Forecast: Line Items of MM Documents13FDGRPPlanning Groupnvarchar100
20FDM2Cash management line items from MM purchase requisition9FDGRPPlanning Groupnvarchar100
21FDMVCash Planning Line Items of Earmarked Funds17FDGRPPlanning Groupnvarchar100
22FDRECash Management Line Items from RE-FX (Real Estate)7FDGRPPlanning Groupnvarchar100
23FDS2CM&F Line Items in SD Documents (fromr Release 4.0)12FDGRPPlanning Groupnvarchar100
24FDSPCash Mgmt Adjustment Items from Document Splitting27FDGRPPlanning Groupnvarchar100
25FDT1CMF Line Items for Forex, Money Market, Derivatives12FDGRPPlanning Groupnvarchar100
26FDW1Cash Mgt and Forecast - Securities Line Items- Planned Flows11FDGRPPlanning Groupnvarchar100
TOPCollectionsDisbursements
27DIMAIOBPARIO: Insurance Object-Partner Relationship in FS-CD15FDGRPPlanning Groupnvarchar100
28VVKKFOPSingle Doc in Posting Data Interface70FDGRPPlanning Groupnvarchar100
29VVKKFOPTTable for FS-CD Test Data of Structure VKKKFOP47FDGRPPlanning Groupnvarchar100
30VVSCITEMBill Scheduling: Scheduling Document57FDGRPPlanning Groupnvarchar100
31VVSCITEM_MANScheduling Items: Temp. Storage for Manual -> Auto Change57FDGRPPlanning Groupnvarchar100
32VVSCPOSPayment Plan Item125FDGRPPlanning Groupnvarchar100
TOPContract Accounts Receivable and Payable
33DFKKCASHFCInterim Table for Cash Management and Forecast Data6FDGRPPlanning Groupnvarchar100
34DFKKIP_GRPPayment Specification: Header Data36FDGRPPlanning Groupnvarchar100
35DFKKIP_GRPHPayment Specification: Payment Data (History)38FDGRPPlanning Groupnvarchar100
36DFKKMOPItems in contract account document78FDGRPPlanning Groupnvarchar100
37DFKKOPItems in contract account document78FDGRPPlanning Groupnvarchar100
38DFKKOP_REPOpen Items from FPO482FDGRPPlanning Groupnvarchar100
39DFKKORDERPOSRequests: Items67FDGRPPlanning Groupnvarchar100
40DFKKORDERPOS_SRequest Templates: Items52FDGRPPlanning Groupnvarchar100
41DFKKPPPromises to Pay Header Table17FDGRPPlanning Groupnvarchar100
42FKKVKPContract Account Partner-Specific42FDGRPPlanning Groupnvarchar100
TOPContract Billing
43ERCHBilling Doc. Data85FDGRPPlanning Groupnvarchar100
TOPFinancial Accounting
44VBSEGDDocument Segment for Customer Document Parking34FDGRPPlanning Groupnvarchar100
45VBSEGKDocument Segment for Vendor Document Parking39FDGRPPlanning Groupnvarchar100
46VBSEGSDocument Segment for Document Parking - G/L Account Database31FDGRPPlanning Groupnvarchar100
TOPFunds Management-Specific Postings
47FMFUNDTRANSYEARAdditional Documents for Funds Transfer to Diff. Years32FDGRPPlanning Groupnvarchar100
48PSOSEGDDocument Segment: Recurring Request, Customer35FDGRPPlanning Groupnvarchar100
49PSOSEGKRecurring Request Document Segment, Vendors40FDGRPPlanning Groupnvarchar100
50PSOSEGSRecurring Request Document Segment, G/L Accounts31FDGRPPlanning Groupnvarchar100
TOPInvoicing
51DEABPSCustomer change table: Logical view of BB amounts71FDGRPPlanning Groupnvarchar100
TOPMaster Data
52T012KHouse Bank Accounts11FDGRPPlanning Groupnvarchar100
TOPPublic Sector Contract Accounts Receivable and Payable
53TFICA_DEFSamples for Contract Account Types22FDGRPPlanning Groupnvarchar100
TOPReal Estate Management
54VIAKBSEGDocument Line Item from SCS for Interface55FDGRPPlanning Groupnvarchar100
TOPRemaining Beverage - Obsolete Objects
55/BEV3/CH1030BSG1Document Segment CH Event Ledger Part154FDGRPPlanning Groupnvarchar100