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

118 columns | Print definition?ERP 6.0  | VALUT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000168000PSA for 0FI_GL_40 T90CLNT090 G/L Accounts: Items53VALUTnvarchar80
2/BIC/B0000169000PSA for 0FI_GL_41 T90CLNT090 Documents, Compact53VALUTnvarchar80
3/BIC/B0000170000PSA for 0FI_GL_4 T90CLNT090 FI-GL Items Delta20VALUTnvarchar80
4/BIC/B0000172000PSA for 0FI_GL_14 T90CLNT090 Gen. Ledger: Items61VALUTnvarchar80
5/OPT/VIM_1ITEM_SDocument Item93VALUTValue datenvarchar80
6/OPT/VIM_TITEMDocument Item93VALUTValue datenvarchar80
7BOE_COL_ITEMCollection item data table23VALUTValue datenvarchar80
8BOE_DIS_ITEMDiscount item data table12VALUTValue datenvarchar80
9BOE_PAY_ITEMPayment item data table12VALUTValue datenvarchar80
10BSAS_BAKAccounting: Secondary Index for G/L Accounts (Cleared Items)32VALUTValue datenvarchar80
11BSEGAccounting Document Segment54VALUTValue datenvarchar80
12BSIS_BAKAccounting: Secondary Index for G/L Accounts32VALUTValue datenvarchar80
13BSSEGAccounting Document Segment43VALUTValue datenvarchar80
14DFKK_TRIGX_PAYOutbound Interface: New Trigger Table for Payment Info17VALUTDue date for net paymentnvarchar80
15EPIC_EBR_HDROBSOLETE!!!58VALUTValue date of the item to be clearednvarchar80
16FAGLBSAS_BAKAccounting: Secondary Index for G/L Accounts (Cleared Items)32VALUTValue datenvarchar80
17FAGLBSIS_BAKAccounting: Secondary Index for G/L Accounts32VALUTValue datenvarchar80
18FIAPSAD_ORDR_LTLine Item for Order Number KSA16VALUTValue datenvarchar80
19FUDT_VDOCBSEGVerification Document Item with Additional Info43VALUTValue datenvarchar80
20FUDT_VDOCBSEGEVVerification Document Item in the Entry View43VALUTValue datenvarchar80
21FUDT_VDOCBSEGHVerification Document Segment with Additional Info(History)43VALUTValue datenvarchar80
22GLPCA_CTProfit Center Documents124VALUTValue datenvarchar80
23GLPCA_T_CTProfit Center Documents140VALUTValue datenvarchar80
24GLPOS_C_CTFI Document: Entry View251VALUTValue datenvarchar80
25GLPOS_C_DEB_CTGLPOS_C_CT Customer Line Items251VALUTValue datenvarchar80
26GLPOS_C_GL_CTGLPOS_C_CT G/L Line Items251VALUTValue datenvarchar80
27GLPOS_C_VEN_CTGLPOS_C_CT Vendor Line Items251VALUTValue datenvarchar80
28GLPOS_N_CTNew General Ledger: Line Item with Currency Type260VALUTValue datenvarchar80
29GLPOS_N_GL_CTNew General Ledger: Line Item with Currency Type260VALUTValue datenvarchar80
30YVIM_1ITEMDocument Item93VALUTValue datenvarchar80
TOPAccounting Interface
31GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)50VALUTValue datenvarchar80
32GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)50VALUTValue datenvarchar80
TOPAutomatic Payments
33PAYRQPayment Requests121VALUTValue Date for the Sending Banknvarchar80
TOPBasic Functions
34FEBEPElectronic Bank Statement Line Items15VALUTValue date of the item to be clearednvarchar80
TOPCollectionsDisbursements
35VVKKTRIMATrigger for Checking Dunning Status7VALUTValue datenvarchar80
36VVSCPOSPayment Plan Item78VALUTValue datenvarchar80
37VVSCRESPAYMENTBill Scheduling: Universal Life14VALUTValue datenvarchar80
TOPContract Accounts Receivable and Payable
38DFKKBRLEVYRECLevy Way: Data from Payment Lot for Levy Way report (Brazil)8VALUTValue datenvarchar80
39DFKKCFRLSClarification Cases: Returns Lots14VALUTValue datenvarchar80
40DFKKCMKManually Issued Checks Lot: Header Data11VALUTValue datenvarchar80
41DFKKCMPManually Issued Checks Lot: Item Data10VALUTValue datenvarchar80
42DFKKCOLLITEMCollection Units16VALUTValue Datenvarchar80
43DFKKCOLLPAYMCollection Payments10VALUTValue Datenvarchar80
44DFKKCOL_LOGCollections Agency File: Settlement Log (Payments)9VALUTValue date (batch input)nvarchar80
45DFKKCRRepository For Checks27VALUTValue datenvarchar80
46DFKKCRDELCR: Deleted Payment Medium / Basic Data30VALUTValue datenvarchar80
47DFKKEXCExternal Payment Information14VALUTValue datenvarchar80
48DFKKEXCJCash Journal: Data Store for Inbound Services8VALUTValue datenvarchar80
49DFKKEXC_PAYINFOInformation for Payment Medium27VALUTValue datenvarchar80
50DFKKEXC_SUMExternal Payment Information: Totals Records8VALUTValue datenvarchar80
51DFKKEXC_SUM_HISTCash Desk Closing History (DFKKEXC_SUM)9VALUTValue datenvarchar80
52DFKKEXC_TMPExternal Payment Information: Account Assignment Parameters10VALUTValue datenvarchar80
53DFKKMOPKItems in contract account document18VALUTValue datenvarchar80
54DFKKOPKItems in contract account document18VALUTValue datenvarchar80
55DFKKOPKCCard Data Appendix for FICA Document22VALUTValue datenvarchar80
56DFKKOPK_SHORTOffsetting Items for FI-CA Document - Extracts12VALUTValue datenvarchar80
57DFKKPOHPayment Order: Header Data21VALUTValue datenvarchar80
58DFKKPPPPayment Assignments to Promises to Pay11VALUTValue datenvarchar80
59DFKKRHReturns History22VALUTValue datenvarchar80
60DFKKRKReturns lot: Header data18VALUTValue datenvarchar80
61DFKKRPReturns lot: Data for payment32VALUTValue datenvarchar80
62DFKKSUMPosting totals from FI-CA37VALUTValue datenvarchar80
63DFKKSUMOLDTotals Records Without Account Assignment Changes11VALUTValue datenvarchar80
64DFKKZKPayment lot: Header data16VALUTValue datenvarchar80
65DFKKZPPayment lot: Data for payment26VALUTValue datenvarchar80
66DFKK_TRIGGER_PAYOutbound Interface: Trigger Table for Payment Information16VALUTDue date for net paymentnvarchar80
67DPAYHPayment program - data for payment63VALUTValue datenvarchar80
68FKKBEPElectronic Bank Statement Line Items15VALUTValue date of the item to be clearednvarchar80
TOPData Retention Tool
69TXW_S_BSEGRetrieve BSEG from archive78VALUTValue datenvarchar80
TOPFinancial Accounting
70/OPT/VIM_1ITEMDocument Item93VALUTValue datenvarchar80
71ACCTITCompressed Data from FI/CO Document15VALUTValue datenvarchar80
72AVIKPayment Advice Header49VALUTValue datenvarchar80
73BSASAccounting: Secondary Index for G/L Accounts (Cleared Items)32VALUTValue datenvarchar80
74BSISAccounting: Secondary Index for G/L Accounts32VALUTValue datenvarchar80
75EBSEGDoc.Segment of Fin.Accntng External Documents27VALUTValue datenvarchar80
76KMZEIFI: Account Assignment Model Item Information15VALUTValue datenvarchar80
77KOMUAccount Assignment Templates for G/L Account Items15VALUTValue datenvarchar80
78VBSEGDDocument Segment for Customer Document Parking29VALUTValue datenvarchar80
79VBSEGKDocument Segment for Vendor Document Parking34VALUTValue datenvarchar80
80VBSEGSDocument Segment for Document Parking - G/L Account Database24VALUTValue datenvarchar80
TOPFunds Management
81FMEPFI-FM Line Items20VALUTValue datenvarchar80
TOPFunds Management-Specific Postings
82FMFUNDTRANSYEARAdditional Documents for Funds Transfer to Diff. Years26VALUTValue datenvarchar80
83PSOSEGDDocument Segment: Recurring Request, Customer30VALUTValue datenvarchar80
84PSOSEGKRecurring Request Document Segment, Vendors35VALUTValue datenvarchar80
85PSOSEGSRecurring Request Document Segment, G/L Accounts25VALUTValue datenvarchar80
TOPGeneral Ledger Accounting
86BSEG_ADDEntry View of Accounting Document for Additional Ledgers15VALUTValue datenvarchar80
87FAGLBSASAccounting: Secondary Index for G/L Accounts (Cleared Items)32VALUTValue datenvarchar80
88FAGLBSISAccounting: Secondary Index for G/L Accounts32VALUTValue datenvarchar80
89GLFLEXAFlexible general ledger: Actual line items39VALUTValue datenvarchar80
TOPGL transfer
90BKKC02General Ledger: Posting Totals for FI13VALUTValue datenvarchar80
TOPInformation System
91DKKOPBalance Audit Trail54VALUTValue datenvarchar80
92DKOKPOpen Item Account Balance Audit Trail55VALUTValue datenvarchar80
93DSKOPBalance Audit Trail56VALUTValue datenvarchar80
TOPIntercompany Data Exchange
94IUEEDPPLOTATADMDistribute Aggregated Payments: Parameter/Status Management6VALUTValue datenvarchar80
TOPJoint Venture und Production Sharing Accounting
95JVPO1JVA: Plan Line Items110VALUTValue datenvarchar80
96JVSO1JV LI Table with Objects for JVTO146VALUTValue datenvarchar80
TOPLoans Management
97VDZNB_PAYINFOPayment Postprocessing: Payment Inform. for a PPP Activity9VALUTValue date of the item to be clearednvarchar80
98VDZNB_PAYMENTPayment Postprocessing: Payments for a PPP Activity16VALUTValue datenvarchar80
99VZFZE_VDNBZECentral Entry Table for Release Procedure21VALUTValue datenvarchar80
TOPLocalization
100J_3RFTAX_EXTRDTax Extract Detail Lines63VALUTValue datenvarchar80
101RFITEMAP_NO_ITEMItem wise detail for the Vendor Transactions62VALUTValue datenvarchar80
102RFITEMAR_NO_ITEMItem wise detail for the Customer Transactions62VALUTValue datenvarchar80
103RFITEMGL_NO_ITEMItem wise detail for the GL Account Transactions62VALUTValue datenvarchar80
TOPPayment Transactions
104FPRL_ITEMItem Data149VALUTValue datenvarchar80
105PYORDHPayment order header data13VALUTValue datenvarchar80
106REGUHSettlement data from payment program59VALUTValue datenvarchar80
107REGUHHREGUH version before the 'n'th change21VALUTValue datenvarchar80
108REGUHMPayment Data for Cross-Payment Run Payment Medium17VALUTValue datenvarchar80
109REGUHOREGUH version before the 'n'th change31VALUTValue datenvarchar80
TOPPayments
110DFKKBOHBoleto: Header data24VALUTValue datenvarchar80
TOPProfit Center Accounting
111GLPCAEC-PCA: Actual Line Items97VALUTValue datenvarchar80
TOPProject System
112FILTER_PS_LOGFilter for PS EHP48VALUTText (80 Characters)nvarchar800
TOPReal Estate Management
113RFVIUMSATZTest Data for RE Multicash Sales Data9VALUTValue datenvarchar80
114VIAKBSEGDocument Line Item from SCS for Interface28VALUTDatenvarchar80
TOPReceivablesPayment Management
115VDARL_RLSDirect Debits Per Contract8VALUTValue datenvarchar80
TOPRegulatory reporting for insurance companies
116ISSRPREFLOWISSR: Basistabelle/Bewegungstabelle17VALUTData valutanvarchar80
TOPRemaining Beverage - Obsolete Objects
117/BEV3/CH1030BSG1Document Segment CH Event Ledger Part145VALUTValue datenvarchar80
TOPSAP Credit Management
118DFKKCRLPCredit Management: Last Payment5VALUTValue datenvarchar80