SAP Tables - SAP Business One/ERP Table Definition reference

 Module:  Table: 

icon of database logic symbol SAP  TABLESv1Made in Britain - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

1BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
2FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
3/ISDFPS/CHVW_E34External Batch Where-Used List
4FMARCPAR4Parallelization of FMARC_BATCH
5CEKRS5Movement type parameters for automatic ERS
6/1RA/0SD010MI170Items for Class SD01 - Raw Data
7/ATL/AANLCP79Periodic Asset-value fields, like anlc, for all areas
8BSEG345Accounting Document Segment
9AUDLORIPR7KPro: Logical Information Object Attribute Values
10/OPT/Z1344Reporting table: Text table for exception definitions

B1 9.2: Top 10 requests

1OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OPOR386Purchase Order
9JDT1124Journal Entry - Rows
10OACT114G/L Accounts

B1 8.8: Top 10 requests

2OINV268A/R Invoice
3OVPM154Outgoing Payments
4ORCT154Incoming Payment
5OPCH268A/P Invoice
6OIVL77Whse Journal
7OOCR9Loading Factors
8OSRN20Serial Numbers Master Data
9JDT1110Journal Entry - Rows
10OBOT10Bill Of Exchang Transaction - the webs number one PHP Function reference tool

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
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
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