SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

www.saptables.net

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
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
6AUDLORIPR7KPro: Logical Information Object Attribute Values
7FCO_DOC_HEAD61Failure Cost Document Header
8/OPT/Z1344Reporting table: Text table for exception definitions
9FMIA65Actual Line Item Table for Funds Management
10PEG_TMTNS2Pegging: Movement Types Explicitly Not Supported

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

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

93 columns | Print definition?ERP 6.0  | AWSYS

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000168000PSA for 0FI_GL_40 T90CLNT090 G/L Accounts: Items91AWSYSnvarchar100
2/BIC/B0000169000PSA for 0FI_GL_41 T90CLNT090 Documents, Compact91AWSYSnvarchar100
3/BIC/B0000172000PSA for 0FI_GL_14 T90CLNT090 Gen. Ledger: Items128AWSYSnvarchar100
4ARBERP_D_STSTRIGTrigger table: send cXML acc. doc. rel. msg. based on BTE5AWSYSLogical Systemnvarchar100
5CNV_20100_COESDuplicate COES keys (target values)6AWSYSLogical system of source documentnvarchar100
6FUDT_VDOCBKPFVerification Document Header58AWSYSLogical Systemnvarchar100
7FUDT_VDOCBKPFHVerification Document Header(History)58AWSYSLogical Systemnvarchar100
8GLPCA_CTProfit Center Documents50AWSYSLogical system of source documentnvarchar100
9GLPCA_T_CTProfit Center Documents66AWSYSLogical system of source documentnvarchar100
10GLPOS_C_CTFI Document: Entry View54AWSYSLogical Systemnvarchar100
11GLPOS_C_DEB_CTGLPOS_C_CT Customer Line Items54AWSYSLogical Systemnvarchar100
12GLPOS_C_GL_CTGLPOS_C_CT G/L Line Items54AWSYSLogical Systemnvarchar100
13GLPOS_C_VEN_CTGLPOS_C_CT Vendor Line Items54AWSYSLogical Systemnvarchar100
14GLPOS_N_CTNew General Ledger: Line Item with Currency Type54AWSYSLogical systemnvarchar100
15GLPOS_N_GL_CTNew General Ledger: Line Item with Currency Type54AWSYSLogical systemnvarchar100
16INTITFXFixed Interest Amounts per Invoice7AWSYSLogical Systemnvarchar100
17PAYR_XBANC_HRTemporary Storage in FI for Cashed HR Checks6AWSYSLogical Systemnvarchar100
18ZARIXFI1Archive Information Structure SAP_FI_DOC_00217AWSYSLogical Systemnvarchar100
19ZARIXFI2Archive Information Structure SAP_FI_DOC_DRB111AWSYSLogical Systemnvarchar100
TOPAccounting Interface
20GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)6AWSYSLogical Systemnvarchar100
21GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)6AWSYSLogical Systemnvarchar100
TOPAccounts Receivable Accounting Process Integration
22FDM_CCM_CORRTrigger Table for Manual Adjustments (Claims Management)2AWSYSLogical Systemnvarchar100
TOPAccrual Engine
23ACEPSOITLine Items for Accrual Item in Accrual Engine21AWSYSLogical system of source documentnvarchar100
TOPActual CostingMaterial Ledger
24MLHDMaterial Ledger Document: Header8AWSYSLogical Systemnvarchar100
TOPAutomatic Payments
25PAYRQPayment Requests140AWSYSLogical Systemnvarchar100
TOPBalance Sheet Valuation Procedures
26MYML1LIFO: Transaction-Related Material Layer15AWSYSLogical systemnvarchar100
27MYML1QLIFO: Transaction-Related Material Layer (Quantity)13AWSYSLogical systemnvarchar100
TOPBasic Functions
28ANEKDocument Header Asset Posting46AWSYSLogical Systemnvarchar100
29ETXDCHExternal tax document: header info6AWSYSLogical system of source documentnvarchar100
30FDS2CM&F Line Items in SD Documents (fromr Release 4.0)5AWSYSLogical Systemnvarchar100
31FDSPCash Mgmt Adjustment Items from Document Splitting6AWSYSLogical Systemnvarchar100
TOPBasis Components
32ZDS400_BKPFBelegkopf für Buchhaltung58AWSYSLogisches Systemnvarchar100
TOPBudgeting
33FMBHFunds management budget header (entry documents)29AWSYSLogical system of source documentnvarchar100
TOPBudgeting and Availability Control
34GMBDGTHEADERBudget Document Header28AWSYSLogical system of source documentnvarchar100
TOPCollectionsDisbursements
35VVSCPOSPayment Plan Item115AWSYSLogical system of source documentnvarchar100
TOPContract Accounts Receivable and Payable
36DFKKAWMForeign Trade Reporting: Report File27AWSYSLogical Systemnvarchar100
37DFKKKOHeader Data in Open Item Accounting Document28AWSYSLogical system of source documentnvarchar100
38DFKKMKOHeader data for sample contract accounting document28AWSYSLogical system of source documentnvarchar100
39DFKKORDERRequests: Header Data23AWSYSLogical system of source documentnvarchar100
40DFKKORDER_SRequest Templates: Header Data23AWSYSLogical system of source documentnvarchar100
41FKK_EBS_AR_SYSArchiveLink: Assign Original System for Bills3AWSYSLogical system of source documentnvarchar100
TOPControlling
42COPPP_HDRCO Postprocessing List - Headers40AWSYSLogical system of source documentnvarchar100
TOPCost Object
43FCO_DOC_HEADFailure Cost Document Header6AWSYSLogical Systemnvarchar100
TOPCosting
44COESCO Object: Sales Order Value Line Items5AWSYSLogical system of source documentnvarchar100
TOPCross-Application Components
45BKKPFAccounting document header58AWSYSLogical Systemnvarchar100
TOPData Retention Tool
46TXW_S_ANEARetrieve ANEA from archive29AWSYSLogical system of source documentnvarchar100
47TXW_S_ANEKRetrieve ANEP from archive34AWSYSLogical systemnvarchar100
48TXW_S_ANEPRetrieve ANEP from archive25AWSYSLogical system of source documentnvarchar100
49TXW_S_BKPFRetrieve BKPF from archive33AWSYSLogical systemnvarchar100
50TXW_S_COBKRetrieve COBK from archive28AWSYSLogical system of source documentnvarchar100
51TXW_S_MKPFRetrieve MKPF from archive19AWSYSLogical systemnvarchar100
TOPExpenditure Certification
52FMEUFEXPCertified Expenditure Documents5AWSYSLogical Systemnvarchar100
TOPExpense-Related Billing
53PRSD_DMRP_ACC_CHEngagement Mgmt: Accrual Characteristics for DMR Lines31AWSYSLogical system of source documentnvarchar100
TOPFinancial Accounting
54ACCTHDCompressed Data from FI/CO Document - Header5AWSYSLogical Systemnvarchar100
55ARIX_BKPFFI_DOCUMNT: Header-Oriented Document Index for Archive8AWSYSLogical system of source documentnvarchar100
56BKPFAccounting Document Header58AWSYSLogical Systemnvarchar100
57BSPLSplit Posting Procedures4AWSYSLogical system of source documentnvarchar100
58EBKPFFin.Accntng Doc.Header (of Docs from Extern.Systems)42AWSYSLogical Systemnvarchar100
59VBKPFDocument Header for Document Parking64AWSYSLogical Systemnvarchar100
TOPFSCM In-House Cash
60IHC_DB_PNSource Document for Incoming Payment Orders126AWSYSLogical system of source documentnvarchar100
TOPFunds Management
61BPDKHeader Entry Document22AWSYSLogical system of source documentnvarchar100
62FCABKFI-CA: Document Header11AWSYSLogical Systemnvarchar100
63FMIFIHDFI Header Table in Funds Management15AWSYSLogical Systemnvarchar100
64KBLEDocument Item Processing: Manual Document Entry42AWSYSLogical system of source documentnvarchar100
TOPGeneral Ledger Accounting
65BKPF_ADDAccounting Document Header58AWSYSLogical Systemnvarchar100
66FAGL_MIG_FICHA1Worklist for FI Reassignment Tool10AWSYSLogical Systemnvarchar100
67FAGL_MIG_RPITEMSMigration in New G/L: Objects To Be Posted Subsequently12AWSYSLogical system of source documentnvarchar100
68FAGL_SPLINFOSplittling Information of Open Items7AWSYSLogical system of source documentnvarchar100
TOPGrantee Management
69GMIAActual Line Item Table90AWSYSLogical systemnvarchar100
TOPIndustry Solution - Telecommunications
70IST_EBS_AR_SYSArchiveLink: Assign Original System for Bills3AWSYSLogical system of source documentnvarchar100
TOPInterest
71TZIN1Document Header Data from Source Document (PS Int.Calc.)7AWSYSLogical Systemnvarchar100
TOPInventory Management
72MKPFHeader: Material Document20AWSYSLogical Systemnvarchar100
73MWMKPFHeader Table for the Interface20AWSYSLogical Systemnvarchar100
TOPJoint Venture und Production Sharing Accounting
74T8J_POST_ERRORDocuments with errors in JV posting5AWSYSLogical system of source documentnvarchar100
75T8J_POST_ERROR_CDocuments with errors in JV posting (Open Items)6AWSYSLogical system of source documentnvarchar100
TOPLease Accounting
76FILA_GF_ITEMDOCSAssignment of Process - FI/CO Document Numbers9AWSYSLogical system of source documentnvarchar100
77FILA_GF_ITEMLINKAssignment of Objects to Assets15AWSYSLogical system of source documentnvarchar100
TOPLocalization
78J_1BNFDOCNota Fiscal Header55AWSYSLogical Systemnvarchar100
79J_1B_CIAP_OBJECTCIAP document data54AWSYSLogical Systemnvarchar100
TOPMaterials Management
80BBPD_REBILLINGAdditional Information for Rebilling4AWSYSLogical system of source documentnvarchar100
TOPOverhead Cost Controlling
81COBKCO Object: Document Header39AWSYSLogical system of source documentnvarchar100
TOPOverhead Cost Orders
82AUAKDocument Header for Settlement25AWSYSLogical Systemnvarchar100
TOPPayment Order
83BKKPOHDPayment Order, Header Data27AWSYSLogical Systemnvarchar100
84BKKPOHD_TMPPlanned Payment Order, Header Data28AWSYSLogical Systemnvarchar100
85BKKPOHD_TMP_DELPlanned Payment Order, Header Data28AWSYSLogical Systemnvarchar100
TOPProfit Center Accounting
86GLPCAEC-PCA: Actual Line Items87AWSYSLogical system of source documentnvarchar100
87GLPCPEC-PCA: Plan Line Items140AWSYSLogical system of source documentnvarchar100
TOPProfitability Analysis
88CEERRORCO-PA: Incorrect records from SD63AWSYSLogical Systemnvarchar100
TOPReal Estate Management
89VIDOCSReference Table for Real Estate Documents11AWSYSLogical system of source documentnvarchar100
TOPRegulatory reporting for insurance companies
90ISSRPREFLOWISSR: Basistabelle/Bewegungstabelle42AWSYSSistema logico del documento originalenvarchar100
TOPRemaining Beverage - Obsolete Objects
91/BEV3/CH1030BKPFHeader Data for CH Event Ledger 0000103060AWSYSLogical Systemnvarchar100
TOPRevenues and Earnings
92AD01DLIDynamic items (DI)42AWSYSLogical system of source documentnvarchar100
TOPTime Sheet
93CABAREFCATS: Transfer from CATS II to PS, PM, and CO4AWSYSLogical system of source documentnvarchar100