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

65 columns | Print definition?ERP 6.0  | PROJK

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000168000PSA for 0FI_GL_40 T90CLNT090 G/L Accounts: Items84PROJKnvarchar240
2/BIC/B0000169000PSA for 0FI_GL_41 T90CLNT090 Documents, Compact84PROJKnvarchar240
3/BIC/B0000170000PSA for 0FI_GL_4 T90CLNT090 FI-GL Items Delta27PROJKnvarchar80
4/BIC/B0000172000PSA for 0FI_GL_14 T90CLNT090 Gen. Ledger: Items111PROJKnvarchar240
5/OPT/VIM_1ITEM_SDocument Item45PROJKWork Breakdown Structure Element (WBS Element)nvarchar80
6/OPT/VIM_TITEMDocument Item45PROJKWork Breakdown Structure Element (WBS Element)nvarchar80
7BSAD_BAKAccounting: Secondary index for customers (cleared items)95PROJKWork Breakdown Structure Element (WBS Element)nvarchar80
8BSAK_BAKAccounting: Secondary Index for Vendors (Cleared Items)99PROJKWork Breakdown Structure Element (WBS Element)nvarchar80
9BSAS_BAKAccounting: Secondary Index for G/L Accounts (Cleared Items)46PROJKWork Breakdown Structure Element (WBS Element)nvarchar80
10BSEGAccounting Document Segment226PROJKWork Breakdown Structure Element (WBS Element)nvarchar80
11BSID_BAKAccounting: Secondary Index for Customers95PROJKWork Breakdown Structure Element (WBS Element)nvarchar80
12BSIK_BAKAccounting: Secondary index for vendors99PROJKWork Breakdown Structure Element (WBS Element)nvarchar80
13BSIS_BAKAccounting: Secondary Index for G/L Accounts46PROJKWork Breakdown Structure Element (WBS Element)nvarchar80
14BSSEGAccounting Document Segment215PROJKWork Breakdown Structure Element (WBS Element)nvarchar80
15FAGLBSAS_BAKAccounting: Secondary Index for G/L Accounts (Cleared Items)46PROJKWork Breakdown Structure Element (WBS Element)nvarchar80
16FAGLBSIS_BAKAccounting: Secondary Index for G/L Accounts46PROJKWork Breakdown Structure Element (WBS Element)nvarchar80
17FIKZD_CONTR_MAPPSubsoil use contracts mapping20PROJKWork Breakdown Structure Element (WBS Element)nvarchar80
18FUDT_VDOCBSEGVerification Document Item with Additional Info215PROJKWork Breakdown Structure Element (WBS Element)nvarchar80
19FUDT_VDOCBSEGEVVerification Document Item in the Entry View215PROJKWork Breakdown Structure Element (WBS Element)nvarchar80
20FUDT_VDOCBSEGHVerification Document Segment with Additional Info(History)215PROJKWork Breakdown Structure Element (WBS Element)nvarchar80
21GLPOS_C_CTFI Document: Entry View199PROJKWork Breakdown Structure Element (WBS Element)nvarchar80
22GLPOS_C_DEB_CTGLPOS_C_CT Customer Line Items199PROJKWork Breakdown Structure Element (WBS Element)nvarchar80
23GLPOS_C_GL_CTGLPOS_C_CT G/L Line Items199PROJKWork Breakdown Structure Element (WBS Element)nvarchar80
24GLPOS_C_VEN_CTGLPOS_C_CT Vendor Line Items199PROJKWork Breakdown Structure Element (WBS Element)nvarchar80
25GLPOS_N_CTNew General Ledger: Line Item with Currency Type204PROJKWork Breakdown Structure Element (WBS Element)nvarchar80
26GLPOS_N_GL_CTNew General Ledger: Line Item with Currency Type204PROJKWork Breakdown Structure Element (WBS Element)nvarchar80
27J_1UF_TAXDEC_SELSelections for tax declaration13PROJKWork Breakdown Structure Element (WBS Element)nvarchar80
28REGUPProcessed items from payment program98PROJKWork Breakdown Structure Element (WBS Element)nvarchar80
29YVIM_1ITEMDocument Item45PROJKWork Breakdown Structure Element (WBS Element)nvarchar80
TOPAccounting Interface
30GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)173PROJKProject Account Assignment (PS_PSP_PNR Batch Input Field)nvarchar240
31GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)173PROJKProject Account Assignment (PS_PSP_PNR Batch Input Field)nvarchar240
TOPActual CostingMaterial Ledger
32CKMVFM_BSEG_OUTDisplay of FI Documents, Transaction CKMVFM, SAP Note 91298412PROJKWork Breakdown Structure Element (WBS Element)nvarchar80
TOPContract Accounts Receivable and Payable
33TECODIS-U: CO account assignment key / allocation13PROJKIndividual Structural Element (WBS Element) in Ext. Formatnvarchar240
34TFKCODFI-CA: CO Account Assignment Key/Allocation11PROJKIndividual Structural Element (WBS Element) in Ext. Formatnvarchar240
TOPCross-Application Components
35BBSIDAccounting: Secondary index for customers95PROJKWork Breakdown Structure Element (WBS Element)nvarchar80
TOPData Retention Tool
36TXW_S_BSEGRetrieve BSEG from archive35PROJKWork Breakdown Structure Element (WBS Element)nvarchar80
TOPFinancial Accounting
37/OPT/VIM_1ITEMDocument Item45PROJKWork Breakdown Structure Element (WBS Element)nvarchar80
38BSADAccounting: Secondary Index for Customers (Cleared Items)95PROJKWork Breakdown Structure Element (WBS Element)nvarchar80
39BSAKAccounting: Secondary Index for Vendors (Cleared Items)99PROJKWork Breakdown Structure Element (WBS Element)nvarchar80
40BSASAccounting: Secondary Index for G/L Accounts (Cleared Items)46PROJKWork Breakdown Structure Element (WBS Element)nvarchar80
41BSIDAccounting: Secondary Index for Customers95PROJKWork Breakdown Structure Element (WBS Element)nvarchar80
42BSIKAccounting: Secondary Index for Vendors99PROJKWork Breakdown Structure Element (WBS Element)nvarchar80
43BSISAccounting: Secondary Index for G/L Accounts46PROJKWork Breakdown Structure Element (WBS Element)nvarchar80
44EBSEGDoc.Segment of Fin.Accntng External Documents81PROJKInput Field for PS_PSP_PNRnvarchar240
45KMZEIFI: Account Assignment Model Item Information60PROJKWork Breakdown Structure Element (WBS Element)nvarchar80
46KOMUAccount Assignment Templates for G/L Account Items60PROJKWork Breakdown Structure Element (WBS Element)nvarchar80
TOPFunds Management
47FMLGD_H_VG_03_01Posting Type 03: G/L Account Debit Posting11PROJKWork Breakdown Structure Element (WBS Element)nvarchar80
48FMLGD_H_VG_04_01Posting Type 04: G/L Account Credit Posting11PROJKWork Breakdown Structure Element (WBS Element)nvarchar80
49FMSPLITOObject table 111PROJKWork Breakdown Structure Element (WBS Element)nvarchar80
50FMUSFGOObject table 1 for US Federal Government12PROJKWork Breakdown Structure Element (WBS Element)nvarchar80
TOPGeneral Ledger Accounting
51BSEG_ADDEntry View of Accounting Document for Additional Ledgers48PROJKWork Breakdown Structure Element (WBS Element)nvarchar80
52FAGLBSASAccounting: Secondary Index for G/L Accounts (Cleared Items)46PROJKWork Breakdown Structure Element (WBS Element)nvarchar80
53FAGLBSISAccounting: Secondary Index for G/L Accounts46PROJKWork Breakdown Structure Element (WBS Element)nvarchar80
TOPJoint Venture und Production Sharing Accounting
54JVOO1Object Table for FI-SL Table JVTO115PROJKWork Breakdown Structure Element (WBS Element)nvarchar80
55JVOO2JV Billing FI-SL Object Table12PROJKWork Breakdown Structure Element (WBS Element)nvarchar80
56JVPSC01OObject table 116PROJKWork Breakdown Structure Element (WBS Element)nvarchar80
57T8J_POST_ERROR_CDocuments with errors in JV posting (Open Items)24PROJKWork Breakdown Structure Element (WBS Element)nvarchar80
TOPLocal Currency Changeover
58EWUFI_SCAEMU conversion: Table of the clearings to be adjusted19PROJKWork Breakdown Structure Element (WBS Element)nvarchar80
TOPLocalization
59J_3RFTAX_EXTRDTax Extract Detail Lines114PROJKIndividual Structural Element (WBS Element) in Ext. Formatnvarchar240
60RFITEMAP_NO_ITEMItem wise detail for the Vendor Transactions113PROJKIndividual Structural Element (WBS Element) in Ext. Formatnvarchar240
61RFITEMAR_NO_ITEMItem wise detail for the Customer Transactions113PROJKIndividual Structural Element (WBS Element) in Ext. Formatnvarchar240
62RFITEMGL_NO_ITEMItem wise detail for the GL Account Transactions113PROJKIndividual Structural Element (WBS Element) in Ext. Formatnvarchar240
TOPRemaining Beverage - Obsolete Objects
63/BEV3/CH1030BSG1Document Segment CH Event Ledger Part1217PROJKWork Breakdown Structure Element (WBS Element)nvarchar80
TOPRemote Logistics Management
64OIO_MX_OBJECTRLM tracking extract object data35PROJKWork Breakdown Structure Element (WBS Element)nvarchar80
TOPTechnical Application Support
65CNV_20425_SCAEMU conversion: Table of the clearings to be adjusted16PROJKWork Breakdown Structure Element (WBS Element)nvarchar80